BW Architect - K2 Partnering Solutions - Singapore
(2025-09 - 2026-06)
Data-driven and result-oriented SAP Analytics Consultant with 4 years of experience specializing in designing, developing, and deploying enterprise-grade reporting solutions using SAP Analytics Cloud (SAC)
- Configured and maintained Data Provisioning Agents (DP Agent) to establish secure connections between on-premises SAP ECC systems and SAP Business Data Cloud (BDC).
- Developed enterprise-grade dashboards in SAP Analytics Cloud (SAC) leveraging Live Connections to SAP DWC, ensuring real-time executive reporting.
- Authored complex SQL views and implemented data transformation pipelines (Data Flows) to cleanse and harmonize multi-source data.
- Implemented Data Access Controls (DAC) in DWC to enforce strict row-level security based on regional user authorization matrixes.
- Partnered with business analysts to gather reporting requirements, translating them into technical data warehouse specifications.
- Designed and deployed interactive executive dashboards using the SAC Optimized Story Experience, enhancing platform performance by 40% for over 200 global users.
- Implemented robust financial planning modules incorporating Data Actions and Value Driver Trees (VDT) for automated budgeting and forecasting processes.
- Utilized JavaScript within SAC Analytics Designer / Optimized Stories to create customized widgets, dynamic visibility, and guided analytical workflows.
- Configured secure Live Connections linking SAC to SAP Datasphere (DWC) and S/4HANA embedded analytics without data replication.
- Deployed Smart Predict capabilities to generate rolling sales forecasts, reducing variance between planned and actual revenue metrics.
- Developed calculation models (Dimensions, Measures, Hierarchies) and stories for Finance, HR, and Supply Chain business units.
- Conducted cross-departmental workshops and created documentation to transition traditional business users into self-service SAC power users.
BW Architect / Lead SAC Planning Consultant - Techtheos
(2025-03 - 2025-08)
Migrated an excel-heavy annual budgeting cycle into a unified SAC Planning solution integrated with S/4HANA Finance. Consolidated data entry workflows across 15 regional departments, reducing the annual budgeting preparation cycle timeline by 3 weeks.
- Construct business-friendly entities in the Business Builder (Data Products, Perspectives, and Consumption Models) to expose clean, formatted data to the analytics layer.
- Design strategies for Data Virtualization (real-time query federations) versus physical Data Replication (Data Flows, Replication Flows) to optimize system performance and reduce costs.
- Build high-fidelity executive dashboards Business Objects (BOBJ), Qlik Sense, operational reports, and KPIs using the SAC Optimized Story Experience.
- Manage SAC folder structures, roles, teams, and object-level permissions. Set up schedules to automatically broadcast reports via email.
- Optimize the data journey by pushing heavy computations down to Datasphere (via analytical datasets/models) so that SAC stories load instantly.
- Collaborate with business stakeholders to translate vague business problems into definitive technical schemas in Datasphere and UI layouts in SAC & Business Objects (BOBJ).
- Conduct training sessions for business power users, teaching them how to leverage Datasphere's semantic layers to build their own ad-hoc SAC reports safely.
BW Architect - INK IT Solutions
(2024-09 - 2025-03)
- Written complex SQL scripts, table functions, and graphical Data Flows to cleanse, blend, harmonize, and enrich multi-source data.
- Develop modern Analytic Models with complex multi-dimensional calculations, variables, and hierarchies tailored for seamless frontend consumption.
- Utilize the SAP Datasphere Catalogue to discover, classify, map lineage, and govern corporate data assets, ensuring a clear "single source of truth".
- Collaborate closely with SAP Analytics Cloud (SAC) and S4HANA teams to ensure Datasphere consumption models are highly optimized for instant report loading.
- Monitor system health, analyse query execution plans, and implement indexes, partitioning's, or persistence strategies to optimize slow-running views.
- Reduced data replication costs and storage by 35% by strategically implementing Data Virtualization for real-time S/4HANA CDS views while reserving physical Replication Flows for high-frequency legacy tables.
- Collaborating with clients to identify and document their business requirements related to SAP Datasphere.
- Configure and customize the SAP Datasphere system to align with the client's business processes and requirements. Implement data extraction, transformation, loading (ETL) processes & Release Management. Develop and maintain data integration interfaces with external systems.
- Worked on SAP BW Transport Management with the BAU, OPS and data Management team to move the developments across all Landscapes.
- Worked on Realtime data load by SLT data model to the BW system and resolving all the issues if occurred.
- Extraction in the FI module was implemented to fetch data with reporting tool Qlik Sense, Qlik View on the General ledger, Account Receivables, Account payables, and Assets payables.
Lead Consultant - Tata Consultancy Services
(2022-05 - 2024-09)
- Responsible for creating complex and Multidimensional reports using Master / Transaction details cross tab, slice & dice and sub-queries using SAP BW & BO tools. (Lumira, AFO, BEX Designer, BEx & Analyzer, & WebI)
- Strong knowledge of S4HANA architecture and functionalities.
- Designed and developed SAP Datasphere solutions including data modelling, data integration, and semantic layer development to support enterprise analytics and reporting requirements.
- Created and optimized Datasphere models using Graphical Views, SQL Views, Data Builder, and Business Builder concepts.
- Worked on 3.X flows, 2LIS data structure for Inventory, SD, MM & FI modules and resolving production system issues. Develop and implement new SAP Business Data Cl
