Sanjeev Kumar Hamsala
SAP Delivery Manager
Hyderabad
Summary
Results-driven and strategic SAP Delivery Manager with over 21 years of progressive experience in Information Technology. Specializes in SAP Business Warehouse (BW), S/4HANA Analytics, and end-to-end BI/Analytics transformations. Skilled in delivering high-value SAP solutions across complex enterprise landscapes, with a proven track record of success in leading full lifecycle implementations, managing global rollouts, and driving enterprise-wide performance optimization initiatives. Recognized for exceptional stakeholder management, cross-functional leadership, and global delivery excellence, having successfully led large-scale programs in Automotive, Retail, Oil & Gas, Pharma, and Banking domains. Possesses a unique combination of technical depth and business acumen, enabling the seamless translation of business objectives into scalable, future-ready analytics solutions.
Overview
18
18
years of professional experience
4
4
years of post-secondary education
Work History
SAP Delivery Manager
Accenture Solutions Private Ltd
10.2022 - Current
- Led a cross-functional team of 53+ resources across multiple SAP and non-SAP applications ensuring high-quality delivery in both development and support areas.
- Conducted a comprehensive Current Landscape Assessment as part of SAP RISE transformation journey, involved in detailed analysis of system inventory, custom developments, integrations and business processes across FPSL, GL ,Group Reporting, HANA EE, SAC and B4HANA.
- Evaluated technical readiness, identified key pain points and defined the transformation roadmap to support SAP RISE adoption, vendor consolidation and operational model transition.
- Actively involved in project budgeting, cost tracking, financial planning, ensuring optimal resource allocation and alignment with business objectives.
- Monitored and maintained CCI (Cost Center Information) to ensure cost control, reporting accuracy and alignment with financial governance standards.
- Oversaw the Edson Project delivering a tightly integrated SAP SuccessFactors solution (Employee Central, Payroll, Concur) with SAP BTP-based ETD (Enterprise Threat Detection) for enhanced operational visibility and compliance.
- Worked closely with HR, Finance and Security stakeholders to ensure seamless integration, data flows and governance across cloud and on-premise systems.
- Managed ITSCM (IT Service Continuity Management) activities, including risk identification, impact analysis and strategy documentation to ensure business continuity across critical SAP systems.
- Prepared and maintained detailed Runbooks for disaster recovery, failover processes and key business operations to ensure readiness and repeatability during continuity testing.
SAP Service Manager
Accenture Solutions Private
09.2019 - 09.2022
- Global Template Implementation: Designed a scalable global template to integrate a cluster of source systems with SAP B4HANA, ensuring consistency across various geographies and business units.
- Master Data Consolidation: Consolidated master data from multiple heterogeneous source systems, enabling unified reporting and analytics.
- Optimized Data Flow Architecture: Developed a lean and efficient data flow for both master and transactional data using Calculation Views (Cal Views) and Composite Providers, enhancing system performance and maintainability.
- Advanced SAC Reporting: Built highly customized and complex reports in SAP Analytics Cloud (SAC), including specialized visualizations such as Waterfall Reports to support detailed business analysis.
- Custom Roles & Authorization Concepts: Implemented new concepts in Roles and Rights management tailored to meet specific organizational and compliance requirements
Team Lead -Technical Architect
Accenture Services Pvt.Ltd
09.2017 - 08.2019
- Successfully transitioned from an SAP BW background to leading S4HANA Analytics initiatives, overcoming steep learning curves and tight project timelines.
- Spearheaded collaboration between ABAP and Reporting teams driving the development of complex and business-critical reports.
- Managed dual operations (CFIN & SEF workstreams) for the same client across two time zones (USA & Europe) ensuring seamless delivery and coordination.
- Delivered robust analytics solutions across multiple functional areas including Central Finance (CFIN), Manufacturing (MFG), Order to Cash (OTC) and Procure to Pay (PTP).
- Pioneered the implementation of hierarchies in Trial Balance (TB) and Accounts Payable/Receivable (AP/AR) aging buckets within the CFIN stream.
- Enhanced standard CDS Views through CDS View Extensions to accommodate business-specific logic and requirements.
- Extensively utilized DCL (Data Control Language) for custom report authorization and data security.
- Maintained mapping/control tables for transforming legacy to new values and enabling entity derivations.
- Designed and built custom CDS Views as extractors, successfully replicated into BODS and SAP BW and also developed complex extractors for Legacy Systems.
- Executed projects using Agile methodology, actively participated in scrum of scrums, quality audits and daily stand-up calls.
- End-to-end involvement in SOW preparation, requirement gathering, report/extractor design and stakeholder coordination
Team Lead & BW Architect
Accenture GmbH
12.2013 - 08.2017
- Designed a Global Template for Corporate Functions (FI-GL and Purchasing) enabling standardized processes and analytics across 63 plant rollouts worldwide.
- Redesigned data flows for Master Data (MD) and Transactional Data (TD) to improve performance and scalability while ensuring zero disruption to existing reporting architecture.
- Led efforts in scoping, requirement gathering, solution design and end-to-end delivery of BI solutions collaborating closely with business stakeholders and technical teams.
- Managed an offshore development team from onsite ensuring seamless coordination, quality delivery and adherence to timelines.
- Created and maintained detailed Technical and Functional Design documents alongside test case preparation and execution for system validation.
- Integrated multiple source systems- SAP ECC, SAP BW and Legacy platforms into the Corporate BW system, achieving unified reporting and streamlined data management.
- Delivered complex logic for profit center splits involving dummy outlets and derived business-critical fields such as SG Fire Key and SG Control Key based on parameters like customer, vendor, material and material group.
Technical Architect
Sonata Software Ltd
06.2013 - 10.2013
- Designed and optimized the data flow for Master Data (MD) and Transactional Data (TD) to streamline operations and enhance system performance.
- Maintained and deployed comprehensive Technical and Functional Design documents along with detailed testing documentation ensuring clarity and traceability throughout the project lifecycle.
- Integrated data from Legacy systems and SAP ECC into the SAP BW system, consolidating data sources for unified reporting and analytics.
- Successfully extracted data from 24 Legacy systems, transformed it within SAP BW and delivered it back to the Legacy systems using Open Hub for downstream processes.
OSC and BW Consultant
NTT Data
09.2012 - 05.2013
- Implemented SD and Inventory processes in SAP BW ensuring efficient data flow and integration for Sales and Distribution as well as Inventory management.
- Utilized Open Hub to integrate data for the eSPA application, enabling seamless data exchange between SAP BW and external systems.
- Integrated BW queries with BOBJ aligning with the AS-IS ADWH architecture for smooth and accurate data reporting.
- Deployed Currency Translations at the query level ensuring accurate currency conversion and reporting for global business requirements.
OSC and BW Consultant
Intelligroup, NTT DATA
06.2011 - 08.2012
- RAC (Response Time Analysis & Control): Conducted detailed analysis and optimization of query response times ensuring efficient performance and timely data delivery.
- Re-partitioning Expertise: Extensively worked on re-partitioning data, improving system performance and optimizing data load processes.
- Automation of Flat File Loading: Implemented an automated process for flat file loading, streamlining data ingestion and reducing manual intervention.
- Pre-cal Server & Report Broadcasting: Worked on Pre-cal server configuration to optimize report broadcasting ensuring timely and accurate distribution of critical business reports.
- Functional Area Support: Provided dedicated support for the GOM (Global Oil Movement) functional area ensuring smooth system operations and addressing business needs.
BW Lead and Consultant
IntelliGroup USA
02.2010 - 05.2011
- SOLMAN Implementation: Designed and implemented the RFC Status vs Partner Report within Solution Manager (SOLMAN) ensuring comprehensive monitoring and system health checks.
- Variation Order Deployment: Successfully deployed Variation Order functionality in the BI system enabling improved reporting and analysis of order variations.
- System Testing Post-Upgrade: Conducted thorough testing of the system post-upgrade with ENHP1 and Unicode, ensuring that the system functioned correctly after the upgrade and remained fully compatible.
- Data Flow Design & Documentation: Involved in the design of the data flow for the solution along with preparing the technical design documents and time estimates for the project.
- Acted as the Point of Contact (POC) for FMC for the offshore team ensuring smooth communication, knowledge sharing and delivery.
BW Consultant
Intelligroup Pvt Ltd
09.2009 - 01.2010
- Key Role in SAP BI Implementation: Played a pivotal role in the SAP BI implementation contributing to the successful deployment of BI solutions across functional areas.
- End-User Requirement Gathering for HR: Engaged with end-users to gather requirements for HR analytics ensuring that the final solution met business needs and provided actionable insights.
- HR Data Flow Design: Involved in the designing of the data flow for HR from the source system ensuring seamless extraction, transformation and loading (ETL) of HR data into the BI system.
- BI Content Activation for Core Modules: Activated the data flow for SD, FI, CO, and PS modules from BI content, streamlining data reporting and analytics.
- Custom Report Development: Developed a custom report integrating Web Application Designer (WAD) with the SAP Portal enhancing accessibility and usability for end-users.
BW Consultant
Intelligroup UK
10.2008 - 08.2009
- Load Monitoring & Work Schedule Management: Monitored and managed BW data load schedules ensuring smooth operations by preparing work schedules for the team and allocating tasks effectively.
- BW Data Load Scheduling & Troubleshooting: Oversaw the scheduling, monitoring and troubleshooting of data extraction/load problems & ensuring timely and accurate data loads into the system.
- Queue Management: Managed and prioritized the queue of system-generated and customer-generated tickets, addressed issues efficiently to maintain smooth operations.
- Info Package Design & Scheduling: Designed and scheduled Info Packages based on time and event triggers and ensured timely rectification of errors in the data load process.
- Process Chain & Info Package Group Management: Actively involved in monitoring and scheduling Info Package groups and process chains ensuring successful execution of data loads within the specified timeframes.
- Periodic Schedule Management: Ensured successful execution of periodic schedules (daily, weekly, and monthly) contributing to the timely availability of data for reporting and analysis.
- Error Analysis & Rectification: Analyzed load errors and worked swiftly to rectify issues when data upload requests failed ensuring the latest data was available in the target system.
- Knowledge Transfer & Documentation: Contributed to ongoing Knowledge Transfer (KT) activities including the preparation of user documentation to facilitate smooth handovers and team onboarding.
- Data Load Optimization: Worked on optimizing data loads, reducing load times and enhancing overall system performance.
- Production Load Error Analysis: Proactively analyzed production load errors and rectified issues within stipulated timelines, minimizing downtime and data inconsistencies.
- Background Job Definition: Defined and managed various background jobs for Info Packages ensuring that the data extraction processes ran smoothly and efficiently.
BW Consultant
IntelliGroup USA
12.2007 - 09.2008
- Work Schedule Preparation & Team Coordination: Responsible for preparing the work schedule for the team ensuring effective task allocation and timely execution of data load activities.
- BW Data Load Scheduling & Monitoring: Managed BW data load scheduling, monitored ongoing data extraction processes and troubleshot data load issues to ensure seamless operation.
- Load Failure Analysis & RCA: Collected and analyzed load failure data, identified the frequency and root causes of load failures and provided detailed Root Cause Analysis (RCA) to the client for approval and resolution.
- Backfill Scheduling: Coordinated and scheduled backfill loads for the week ensuring that missing or delayed data loads were properly addressed and completed.
- Info Package & Process Chain Management: Actively involved in monitoring and scheduling Info Package groups and process chains ensuring all data loads were executed successfully.
- Periodic Schedule Management: Ensured the successful execution of periodic schedules (daily, weekly, monthly) & ensured timely data availability for reporting and business analysis.
- Error Analysis & Rectification: Analyzed and resolved errors that occurred during data uploads ensuring the latest data was made available in the target system without delays.
- Knowledge Transfer & Documentation: Contributed to ongoing Knowledge Transfer (KT) activities including the preparation of user documentation to facilitate smooth onboarding and knowledge sharing within the team.
- Data Load Optimization: Worked on optimizing data load processes, reducing load times and improving overall system performance.
- Production Load Error Rectification: Actively analyzed production load errors and ensured timely rectification, minimizing downtime and ensured data accuracy in production environments.
BW Consultant
Intelligroup Pvt Limited
08.2007 - 11.2007
- Data Warehouse Architecture & Future Planning: Worked closely with business stakeholders to understand their needs and architected the data warehouse layer to support current and future requirements ensuring scalability and adaptability.
- Sales Data Analysis Support: Architected the Enterprise Data Warehouse (EDW) to support day-to-day analysis of sales data, managing a system of approximately 2 TB in size with continuous growth.
- System Stabilization & BI 7.0 Upgrade: Played a key role in stabilizing the BW system and was actively involved in the system upgrade to BI 7.0, overseeing the availability of the EDW and performing post-upgrade steps to ensure successful implementation of the technical upgrade.
- BI Server Configuration & JAVA Stack Management: Assisted in the configuration of the JAVA stack for the BI server ensuring proper setup and system readiness.
- Impact Analysis for Enhancements: Validated enhancements and requirements, carefully assessing their impact before implementation to ensure system stability and minimize disruptions.
- Data Extraction & Validation: Provided data extracts for data validation with source systems ensuring data integrity across multiple platforms.
- End-User Training & Support: Delivered end-user training on query development and data extract generation, empowering users to leverage the system effectively for their analytical needs.
- EDW Performance Tuning: Worked on tuning the EDW for optimal performance, considering data volumes of up to 25 million records per day, ensuring fast and efficient data processing even under high load conditions.
BW Consultant
IntelliGroup USA
11.2006 - 07.2007
- BI 7.0 Upgrade Management: Led end-to-end process of BI 7.0 upgrade including pre-upgrade and post-upgrade testing and ensuring smooth system transition.
- Upgrade System Consolidation: Consolidated the upgraded system, validating system integrity and ensuring that all components were functional post-upgrade.
- Data Migration from BW 3.0 to BI 7.0: Managed the data migration from BW 3.0 to BI 7.0 ensuring the smooth transfer of data with minimal disruption.
- Functional Upgrade Implementation: Implemented Data Transfer Process (DTP) for the functional upgrade of the system enhancing the data extraction and transformation processes.
- Object Inspection & Validation: Conducted comprehensive visual and technical inspections of objects ensuring all objects functioned properly and adhered to required standards.
- Load Process Verification: Monitored and validated the loading process ensuring that data loads occurred correctly after the upgrade.
- Report Comparison: Conducted detailed report comparisons between the old and upgraded systems ensuring consistency and accuracy of data and reports across both versions.
- OSS Notes & Patches Implementation: Implemented OSS Notes and applied several patches to ensure system stability, resolved bugs and enhanced system performance.
Education
Bachelor of Industrial & Production Engineering -
Malnad College of Engineering
Hassan 01.1997 - 01.2001
Skills
- SAP RISE
- BS9
- FPSL
- S4HANA
- SAP R/3
- B4HANA
- SAP BW on HANA
- SAP BW
- SOLMAN
- SAP Reporting layer
- Analysis of Office
- ABAP-CDS view
- SAP BOBJ tools
- SAC
Key Clients
- Bank of Ireland, Banking, Ireland
- BMW Group, Automotive, Germany
- ALDI, Retail Market, Poland
- Stanley Black and Decker, NL and USA
- Continental Automotive, Hannover, Germany
- SONY CHINA, Retail, China
- GE-IS, Oil & Gas, China
- ExxonMobil, Oil & Gas, Budapest, Hungary
- FMC, Oil & Gas, Houston, Texas
- Aricent India, Telecom, India
- Harrow Council, UK
- Meda Pharma, NJ, USA
- Hindustan Unilever Ltd, Retail, India
- Medpointe Pharma, NJ, USA
Timeline
SAP Delivery Manager
Accenture Solutions Private Ltd
10.2022 - Current
SAP Service Manager
Accenture Solutions Private
09.2019 - 09.2022
Team Lead -Technical Architect
Accenture Services Pvt.Ltd
09.2017 - 08.2019
Team Lead & BW Architect
Accenture GmbH
12.2013 - 08.2017
Technical Architect
Sonata Software Ltd
06.2013 - 10.2013
OSC and BW Consultant
NTT Data
09.2012 - 05.2013
OSC and BW Consultant
Intelligroup, NTT DATA
06.2011 - 08.2012
BW Lead and Consultant
IntelliGroup USA
02.2010 - 05.2011
BW Consultant
Intelligroup Pvt Ltd
09.2009 - 01.2010
BW Consultant
Intelligroup UK
10.2008 - 08.2009
BW Consultant
IntelliGroup USA
12.2007 - 09.2008
BW Consultant
Intelligroup Pvt Limited
08.2007 - 11.2007
BW Consultant
IntelliGroup USA
11.2006 - 07.2007
Bachelor of Industrial & Production Engineering -
Malnad College of Engineering
01.1997 - 01.2001
Similar Profiles
Akshat ChoudharyAkshat Choudhary
Health Clinical Services Associate at Accenture Solutions Private LtdHealth Clinical Services Associate at Accenture Solutions Private Ltd
Aakash VijayanAakash Vijayan
Health Operations Associate at Accenture Solutions Private LTDHealth Operations Associate at Accenture Solutions Private LTD
Parinita GuptaParinita Gupta
Custom Software Engineering Specialist at Accenture Solutions Private LtdCustom Software Engineering Specialist at Accenture Solutions Private Ltd