Prabhu Duraisamy
SAP Data Architect
Summary
Senior SAP Data Architect with 18+ years of experience delivering end-to-end data architecture for global enterprises. Specializes in designing future-proof data landscapes on SAP BTP, leveraging SAP Datasphere, SAC, and BW/4HANA to create a unified data fabric from S/4HANA and legacy sources. Proven leader in data transformation initiatives, focused on building governed data products, enabling company-wide self-service analytics, and driving tangible business value—such as slashing reporting cycles by 90% through advanced modeling and automation.
Overview
21
21
years of professional experience
Work History
SAP Datasphere / SAC Consultant
TCS / Client : Standard Chartered
02.2024 - Current
- Project : ESG (Environmental, Social, and Governance) Daily Reporting Automation
- Designed and modeled transactional and master data in SAP Datasphere to create a single source of truth using Graphical Views, Dataflows, Replication Flows, script views, SQL, joins, unions, filter expressions, calculated columns, and hierarchies.
- Implemented complex data transformations to harmonize multiple source systems.
- Managed replication flows, task chains, and monitored data pipelines to ensure timely and accurate data loads.
- Tuned Datasphere performance with remote statistics and partitions, improving load and query performance.
- Managed spaces, roles, and user access; implemented row-level security and automated validation frameworks.
- Developed ESG Financial Performance dashboards in SAP Analytics Cloud (SAC) providing daily, monthly, and rolling 15-day insights. Enabled monitoring of sustainability and financial KPIs for informed decision-making.
- Integrated daily flash data with monthly official figures for variance analysis across Revenue, Assets, NII, GII, and Income.
- Reduced reporting cycle from 30+ days to daily flash reporting (90% faster).
- Eliminated manual reporting through full automation.
- Delivered a blueprint hybrid cloud architecture for enterprise-wide adoption.
- Improved query performance by 35% through optimized dataflows and partitioning.
- Developed and delivered a comprehensive training curriculum for DataSphere, successfully onboarding 30+ consultants and directly improving the team's collective skill set and project delivery capabilities.
SAP Datasphere & SAC Consultant
TCS / Client : Standard Chartered
06.2023 - 01.2024
- Project : Procurement Spend & Supplier Performance Analytics (PoC)
- Integrated SAP Ariba procurement data (POs, Invoices, Contracts, Supplier Master) into Datasphere via OData APIs.
- Built semantic models aligning Ariba procurement with S/4HANA Finance (GL, Cost Centers).
- Developed SAC PoC dashboards demonstrating spend by category, supplier, business unit, supplier performance, and contract utilization.
- Showcased real-time analytics and self-service reporting for procurement.
- Enabled enterprise-wide procurement visibility and actionable insights.
- Reduced manual reconciliation between Ariba and S/4HANA by 70%.
- Delivered PoC dashboards adopted as the template for wider procurement analytics rollout.
SAP Data Architect / Senior Technical Consultant
TCS / Client : Deutsche Bank
05.2016 - 05.2023
- Project : BW/4HANA Migration & Finance Analytics Transformation
- Led a two-stage migration: legacy BW 7.5 → BW on HANA → BW/4HANA, modernizing the data warehouse and enabling high-performance analytics.
- Converted InfoCubes, MultiProviders, and DSOs to Advanced DSOs (aDSO) and CompositeProviders, simplifying complex banking data models and aligning with finance and regulatory reporting requirements.
- Optimized extraction from S/4HANA Finance and Controlling modules (ACDOCA, FI/CO) using ODP and CDS Views for near real-time reporting of banking KPIs.
- Designed and implemented modern data models using ADSOs and Composite Providers, streamlining S/4HANA data flows and creating a blueprint for hybrid data landscape with Datasphere.
- Utilized Open Hub Destinations to feed curated data to external platforms and data lakes.
- Integrated BW/4HANA models with SAC to deliver Finance dashboards, including Super TB (Trial Balance) and VAT text reporting for regulatory and compliance purposes.
- Optimized HANA Calculation Views to push down complex logic, improving query performance by 40% and reducing ETL load times by 3 hours.
- Coordinated with business stakeholders for data reconciliation, functional sign-offs, and ensuring reporting accuracy throughout the migration.
SAP Technical Lead (BW, ABAP & Workflow)
TechMahindra / Delaware Consulting
06.2014 - 12.2015
- Led OpenText VIM implementation and upgrade (7.0 → 7.5), managing functional configuration and BI analytics.
- Designed BI data models for VIM, created automated Process Chains, configured workflows for PO/Non-PO approvals.
- Collaborated with SAP NetWeaver Portal for invoice approval integration.
- Automated invoice processing, reducing manual effort by 70%.
- Enabled real-time reporting for finance and procurement KPIs.
- Streamlined PO/Non-PO approval workflows across multiple regions.
- Client: Qater GAS and Sembcorp
SAP Technical Lead (BW, ABAP & Workflow)
Cognizant Technology Solutions
03.2013 - 05.2014
- Spearheaded end-to-end data flow development by creating InfoCubes, DSOs, Transformations, and DTPs to load master and transaction data from SAP R/3.
- Designed and developed a suite of key performance indicator (KPI) reports for Procure-to-Pay, Order-to-Cash, and Record-to-Review processes using BEx Query Designer.
- Led the quality assurance team, ensuring the timely and high-quality delivery of all BI objects through rigorous unit and acceptance testing.
- Modeled data and built process chains to automate and schedule daily master and transaction data loads, ensuring data integrity and availability.
- Activated business content, created generic data sources, and leveraged navigational attributes to enable flexible, drill-down analysis for business users.
- Client: Merck Pvt. Ltd.
SAP Consultant & Team Lead
Various Organizations
01.2005 - 01.2013
- Led SAP BW implementations, BI reporting, workflow automation, and OpenText VIM configurations across Asia.
- Developed ABAP solutions: reports, BDC programs, LSMW, Smart Forms, ALE/IDOC interfaces.
- Executed SAP BW upgrades from 3.5 to 7.0 with performance optimization.
- Successfully delivered multiple end-to-end SAP projects across Asia.
- Standardized BI reporting and workflow solutions, reducing errors and improving efficiency.
- Executed BW upgrades and performance optimization with zero major downtime.
- Configured and customized SAP modules to align with client business processes.
- Clients: Merck, Schering Plough, ABB, Ranbaxy, Asian Paints
Education
Bachelor of Science - Mathematics
Bharathiyar University
India01.2005
Master of Science - Computer Information Systems
Bharathiyar University
India01.2001
Skills
- SAP BTP & Data Warehousing: SAP Datasphere (DWC), Data Builder, Business Builder, Space Management; integration with multiple SAP and non-SAP source systems
- Data Modeling & Architecture: Graphical Views, SQL Views, Table Functions, Dataflows, Replication Flows, Analytic Models, Persistence Optimization
- Data Integration (Hybrid & Multi-Source): Experience integrating SAP systems (S/4HANA Finance, Ariba, SuccessFactors), as well as non-SAP platforms including Hadoop and other cloud/on-premise sources; Cloud Connector, Data Integration Agent (DIP), ODP, SDI, SLT, BODS
- Reporting & Analytics: SAP Analytics Cloud (SAC), Analysis for Office (AFO); delivering dashboards and insights across Finance, Procurement (Ariba), HR (SuccessFactors), and core SAP modules including SD, MM, and others from hybrid data landscapes
- SAP HANA & S/4HANA Ecosystem: HANA Modeling (Calculation View, CDS Views, Procedures), Embedded Analytics, HANA Database Optimization
- Data Governance & Security: Row-Level Security, Transport Management, Data Governance Frameworks
- Methodologies & Tools: Full Project Lifecycle, Agile, PL/SQL, DataStage
TRAINING & AWARDS LEADERSHIP
Spearheaded DataSphere training program for 30+ consultants across 2 cohorts, Developed training curriculum that reduced onboarding time by 30%, Honored with "Best Performer Award" for driving key deliverables and ensuring the successful execution of the BW migration project.
Timeline
SAP Datasphere / SAC Consultant
TCS / Client : Standard Chartered
02.2024 - Current
SAP Datasphere & SAC Consultant
TCS / Client : Standard Chartered
06.2023 - 01.2024
SAP Data Architect / Senior Technical Consultant
TCS / Client : Deutsche Bank
05.2016 - 05.2023
SAP Technical Lead (BW, ABAP & Workflow)
TechMahindra / Delaware Consulting
06.2014 - 12.2015
SAP Technical Lead (BW, ABAP & Workflow)
Cognizant Technology Solutions
03.2013 - 05.2014
SAP Consultant & Team Lead
Various Organizations
01.2005 - 01.2013
Bachelor of Science - Mathematics
Bharathiyar University
Master of Science - Computer Information Systems
Bharathiyar University