Joanna J

Application Development Analyst - Accenture PLC - Bangalore, India

(2021-04)

Project: OGE (Oil, Gas and Energy) - Accenture PLC

(2025-10)

Designed and implemented semantic data models in SAP Datasphere using Data Builder and Business Builder, enabling near-real-time S/4HANA data integration across 3 business units with full calculation logic, transformation rules, and business metadata management.
Built end-to-end data pipelines for ingestion, transformation, harmonization, and synchronization of data from SAP and non-SAP source systems using replication flows, data flows, and task chains within SAP Datasphere.
Developed SQL-based views and transformation logic in SAP Datasphere, delivering analytical datasets with advanced data blending that reduced ad hoc data requests by 60%.
Built SAC stories and responsive dashboards consuming SAP Datasphere analytical datasets, enabling self-service analytics for business stakeholders.

Project: Phillips 66 - Accenture PLC

(2025-07 - 2025-09)

Led end-to-end BI delivery generating 200+ reports and 35+ custom objects across BEx, Analysis for Office (AFO), Web Intelligence, and SAC, covering full-cycle requirements gathering, solution design, build, and UAT.
Configured data access controls and authorization models including 950+ authorization objects with system/user segregation and row-level security across BW, BOBJ, and SAC layers, achieving zero security incidents post go-live.

Project: Pfizer BI ASM - Accenture PLC

(2022-07 - 2025-06)

Developed BOBJ Web Intelligence reports with optimized data sources, data quality validation workflows, and reusable semantic layers in SAP IDT with consistent KPI definitions and data lineage, eliminating legacy manual processes.
Designed drill-capable KPI dashboards and ad hoc data visualization solutions serving 200+ active users across operations and management audiences.
Extended L2 support and incident management: resolved data mismatches, performance issues, and access errors while ensuring SLA compliance through structured coordination between end-users and technical teams.

Project: Sunlife - Accenture PLC

(2021-06 - 2022-06)

Architected SAP BW/4HANA data warehouse from scratch with end-to-end data flows covering InfoObject creation, ADSOs, CompositeProviders, BEx Queries, Process Chains, and production deployment, achieving zero data quality escalations post-launch.
Achieved 40% reduction in report load times by redesigning data models with improved indexing strategies, aggregation logic, and ETL transformation efficiency.
Designed extraction, transformation, and BEx query provisioning pipelines feeding Analysis for Office (AFO) and SAC; documented all data flows and workflows for knowledge transfer.

About