Sachin Kumar Agrawal
Bhubaneswar, Odisha
Summary
Accomplished Data Architect at HCL Technology with expertise in S4 HANA migration and ETL strategies. Successfully led complex data migrations and developed scalable data architecture solutions. Proven team leader and mentor, enhancing project efficiency through performance tuning and training initiatives. Proficient in SAP BODS and advanced SQL, driving impactful business intelligence solutions. Seasoned Data Architect with background in designing, creating, and managing large-scale data infrastructures. Strong skills in database design, data modeling and extraction, transformation, and load (ETL) processes. Adept at implementing data security measures and ensuring regulatory compliance. Past experience includes improving system performance, streamlining data processing, and driving business intelligence efforts for previous employers.
Overview
15
15
years of professional experience
2
2
Certifications
Work History
Data Architect
HCL Technology
07.2022 - Current
- Led HANA Analytics project for Ericsson Account, developing ETL jobs with SAP BODS.
- Created HDB procedures and calculation views in SAP Native HANA to meet business requirements.
- Migrated data from SAP HANA to HADOOP System for cold data archival and Snowflake for cost savings.
- Reviewed team members' code to ensure quality and compliance with standards.
- Managed daily activities and provided guidance to team members on project demands.
- Participated in technical panel for candidate selection through internal and external interviews.
- Conducted training for new hires and experienced staff as part of cross-skilling initiatives.
- Initiated HANA to Snowflake migration using AWS Glue and SAP BODS.
- Designed data architecture frameworks for scalable and efficient data management solutions.
- Collaborated with cross-functional teams to gather data requirements and specifications.
- Developed data models using industry-standard tools and methodologies for project implementation.
- Conducted performance tuning of database systems to enhance system efficiency and reliability.
- Mentored junior team members on data architecture best practices and design principles.
- Facilitated workshops to educate stakeholders on data management strategies and tools.
- Developed and managed enterprise-wide data analytics environments.
- Created and implemented complex business intelligence solutions.
- Implemented database objects such as tables, views, stored procedures, triggers and user-defined functions.
- Monitored ETL processes to ensure that they are running efficiently with minimal errors.
Data Migration Lead
Infosys India Pvt Ltd
bhubaneswar
12.2021 - 07.2022
- Developed SAP BODS program to extract data from SAP ECC and Non-SAP Systems and transform the data as per Business Required format.
- Processed the data into S4 HANA System.
- Created preload and post load report for Data validation and reconciliation Purpose.
- Migrated data into S4 HANA using SAP BODS and LTMC/LTMOM.
- Prior experience in migrating Vendor Master, Customer master, Material Master and Bill of Material Data into S4 HANA System.
Senior Advisory Technical Services Specialist
IBM India Pvt Ltd
01.2020 - 12.2021
- Extracted data from SQL Server and Various Rest API and Loaded the data into HANA Database using SSIS and BODS.
- Once data was transformed, HANA Modelling Views were Created for Business Analysis.
- Provided BODS Training and Job Support to New joiners.
- Provided SME Support to Other Projects.
- Conducted BODS internal and external interviews along with Managerial discussion for various Requirements.
Data Migration Team Lead
Accenture Solutions Pvt Ltd
09.2017 - 01.2020
- Implemented the one of the largest S4 HANA data migration when S4 HANA was recently launched.
- WBA is the 2nd largest pharmaceutical company in US. We implemented the one of the largest S4 HANA data migration when S4 HANA was recently launched.
Module Lead for 6-member Team
Accenture Solutions Pvt Ltd
06.2016 - 08.2017
- Implemented data migration for Clydesdale Bank and Yorkshire Bank.
- CYBG plc is a holding company that owns Clydesdale Bank and Yorkshire Bank in the United Kingdom.
Senior SAP BODS Developer
Accenture Solutions Pvt Ltd
11.2015 - 06.2016
- Worked on data migration project for Entergy Corp.
- Entergy Corp. is an integrated energy company engaged primarily in electric power production and retail distribution operations in the Deep South of the United States.
SAP BODS Technical Lead
Tata Consultancy Services Pvt Ltd
07.2014 - 07.2015
- Provided solution for support issues like Data Fixing, code fixing, creating Ad-hoc crystal report, as well as creating BODS code to extract data from various sources and to load into the data warehouse.
- Yorkshire Building Society is UK’s second largest building society. It provides financial solution to its customers.
ETL(BODS) / Business Objects Developer
Tata Consultancy Services Pvt Ltd
04.2011 - 02.2014
- TCL's BI project serves as a single enterprise-wide Intelligence and Reporting project using best in market technologies viz. SAP BODS and SAP BO Reporting.
- TCL caters to all the financial solutions available under NBFC's role viz.: Consumer Finance, Advisory Services, Securities, Commercial Finance, Infrastructure Finance, Investment Banking, Private Equity, Credit Cards.
Education
Bachelor of Technology - Information Technology
Silicon Institute of Technology
Bhubaneswar Odisha07-2010
Skills
- S4 HANA migration expertise
- ETL tools with SAP BODS
- SAP HANA modeling and development
- ECC to S4 HANA data transfer
- Integration and ETL strategies
- Data warehouse solutions in SAP HANA
- Migration from HANA to Snowflake
- Migration from HANA to Azure cloud
- Reporting with SAP Business Objects
- Proficient in Microsoft SSIS
- Scripting in Python 36
- Archival from HANA to Hadoop
- Management of Oracle databases
- Management of SQL Server databases
- Advanced SQL writing skills
- PL/SQL development expertise
- Informatica PowerCenter knowledge base
- Proficient in Linux OS environment
- Proficient in UNIX OS environment
- Expertise in Information Steward
- Team leadership
- Performance tuning
- Training and mentoring
- SQL expertise
- Data warehousing expertise
Overall Experience
15 years of Experience in Implementation Data warehouse (Oracle, SAP HANA) and Data Migration(S4 HANA) Projects
Domain Experience
8 years of experience in BFSI Domain Project implementation experience
5 years of experience in Networking Domain Project implementation experience
Current Role
Data Architect, HCL Technology, 07/28/22, Lead Consultant on HANA Analytics project, Develop ETL jobs using SAP BODS, Create HDB procedure and Calculation Views in SAP Native HANA, Develop solutions to migrate data from SAP HANA to HAPPOD and Snowflake, Review code of team members, Manage and provide guidance to team members, Conduct interviews for candidate selection, Provide training to new joiners and experienced staff
Previous Roles
- Data Migration Lead, Infosys India Pvt Ltd, 12/30/21, 07/28/22, 7 months, Develop SAP BODS program to extract data from SAP ECC and Non-SAP Systems, Transform data as per business requirements, Process data into S4 HANA System, Create preload and post load reports for data validation
- Senior Advisory Technical Services Specialist, IBM India Pvt Ltd, 01/07/20, 12/26/21, 2 years, Extract data from SQL Server and various REST APIs, Load data into HANA Database using SSIS and BODS, Create HANA Modelling Views for business analysis, Provide BODS training and job support to new joiners
- Data Migration Team Lead, Accenture Solutions Pvt Ltd, 10/26/15, 01/04/20, 4.3 years, Lead data migration projects, Support daily batch job execution, Fix issues raised via Remedy Tool
- SAP BODS / Oracle Senior Developer, Tata Consultancy Services Pvt Ltd, 12/20/10, 10/23/15, 4.10 years, Develop solutions to load data into SAP, Support data migration from legacy systems to MDG System
Projects
Ericsson Sales Analytics, HCL Technology Ltd, Ericsson, 07/28/22 to 10/31/25, Team Lead/ BODS SME, SAP BODS, Native HANA Modelling, Microsoft SSIS, Snowflake, AWS Glue Walgreens Boot Alliance (WBA), Accenture, Walgreens Boot Alliance (WBA), 09/01/17 to 01/31/20, SAP Data Migration Team Lead, SAP BODS, Oracle PL SQL, SAP ECC, S4 HANA Yorkshire Building Society, TATA CONSULTANCE SERVICES LIMITED, Yorkshire Building Society, UK, 07/01/14 to 07/31/15, SAP BODS Technical Lead, SAP BODS
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Certification
SAP Certified Application Associate - Data Integration with SAP Data Services 4.2
Timeline
Data Architect
HCL Technology
07.2022 - Current
Data Migration Lead
Infosys India Pvt Ltd
12.2021 - 07.2022
Senior Advisory Technical Services Specialist
IBM India Pvt Ltd
01.2020 - 12.2021
Data Migration Team Lead
Accenture Solutions Pvt Ltd
09.2017 - 01.2020
Module Lead for 6-member Team
Accenture Solutions Pvt Ltd
06.2016 - 08.2017
Senior SAP BODS Developer
Accenture Solutions Pvt Ltd
11.2015 - 06.2016
SAP BODS Technical Lead
Tata Consultancy Services Pvt Ltd
07.2014 - 07.2015
ETL(BODS) / Business Objects Developer
Tata Consultancy Services Pvt Ltd
04.2011 - 02.2014
Bachelor of Technology - Information Technology
Silicon Institute of Technology