Summary
Overview
Work History
Education
Skills
TRAINING & AWARDS LEADERSHIP
Timeline
Generic

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
India
01.2005

Master of Science - Computer Information Systems

Bharathiyar University
India
01.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
Prabhu DuraisamySAP Data Architect