Utkarsh Sharma
Dublin
Summary
Seasoned Specialist offering 9 years of comprehensive experience interpreting and implementing Data Migration, Data Warehousing, Integration, CD/CI, Business Intelligence & Reporting solutions. Practiced and knowledgeable professional possessing excellent problem solving and analytical skills paired with leading team, strong knowledge of QA terms, tools and methodologies in navigating unforeseen challenges in end-to-end SDLC of Data Management/Engineering.
Overview
9
9
years of professional experience
Work History
SAP Data Migration Specialist
Deloitte Consulting India Pvt. Ltd
Bangalore, India
07.2021 - 12.2023
- Possess a strong foundation in SAP Data Services and Information Stewards, relational databases, and data visualization, data modelling, showcasing comprehensive knowledge in the development and execution of ETL processes from Extraction to Load into S/4 HANA.
- Led development and support for 15+ migration objects across 4 SAP Data Migration projects, demonstrating proficiency in technical design and documentation aligned with business requirements, with full life cycle SAP implementation.
- Expert in extracting and staging legacy data into SAP HANA, transformation, implementation of complex data manipulations, including aggregation, merge, pivot, and intricate joins, data quality checks etc.
- Developed and implemented robust data cleansing solutions, including validation workflows and reconciliation processes, reducing manual work by 25%
- Proficient in utilizing Information Stewards and SAP BODS for data profiling and de-duplication.
- Few of the migration objects developed for conversion from scratch: Customer Master, Vendor Master, Invoices PTP(Open/ Paid), OTC Pricing Conditions, WBS, GL Balances.
- Recognized by management for providing exceptional customer service.
- Achieved cost-savings by developing functional solutions to problems.
- Assisted the manager in setting achievable goals for the team while monitoring progress towards them.
SAP Data Warehousing Consultant
Capgemini Technology India Pvt. Ltd
Bangalore, India
02.2015 - 06.2021
- Possesses a strong foundation in Data Warehouse (DWH) concepts, SAP Data Services, relational databases, and fundamentals of reporting, showcasing expertise in data debugging.
- Managed extensive datasets in Finance, Indirect-Procurement, Sales Analysis, and Transactional/Master data, processing 100-150 million records daily/weekly.
- Collaborated with business users and analysts for effective requirements gathering.
- Designed and customized data models for a Data Warehouse, supporting data from diverse sources, including SAP ERP systems, ECC, BW, databases.
- Proficient in staging raw data and loading into Teradata Db history tables, employing upsert/truncate & load strategies.
- Demonstrated expertise in job scheduling, batch creation, and concurrent processing using DSMC or Tivoli Scheduler.
- Proficient in SQL and various SAP Data Services transformations, contributing to the maintenance and performance tuning of 30+ jobs.
- Engaged in change requests and tickets within SLA for application/data stabilization.
- Aiding front end team in building reports over the real time transactional data via Power BI.
- Also, worked in Data Integration roles to process the Warehoused data to for parallel processing via building data pipelines.
- Maintained database performance by troubleshooting query problems and optimizing queries for better results.
- Provided leadership and guidance to team members, ensuring that tasks were completed on time and to a high standard.
- Received client accolades and extra mile awards for outstanding performance, client satisfaction awards, and consistent recognition for exceeding expectations; actively engaged in community service, including organizing blood donation camps.
Education
Master of Science - Data Analytics
National College of Ireland
Dublin, Ireland03.2024
Bachelor of Science - Electrical, Electronics And Communications Engineering
Reva Institute of Technology And Management
Bangalore, India07.2014
Skills
- SQL
- SAP Data Services (32, 4X)
- SAP Information Stewards
- Informatica
- SAP HANA
- Teradata
- Oracle Db
- SQL Server
- BAPI, Idhoc, LTMC
- Power BI
- Azure Fundamentals-Data Factory
- Share-point
- Tableau-Fundamentals
- Python
- Windows
- MS Office
- MS Visio
Languages
English
First Language
Accomplishments
- Received client accolades and extra mile awards for outstanding performance.
- Recognition for exceeding expectations.
- Received award for Going beyond the call of duty to support and deliver.
Affiliations
- Actively engaged in community service and animal welfare.
- Organizing blood donation camps.
- Arduous reader of topics of History and Literature.
Timeline
SAP Data Migration Specialist
Deloitte Consulting India Pvt. Ltd
07.2021 - 12.2023
SAP Data Warehousing Consultant
Capgemini Technology India Pvt. Ltd
02.2015 - 06.2021
Master of Science - Data Analytics
National College of Ireland
Bachelor of Science - Electrical, Electronics And Communications Engineering
Reva Institute of Technology And Management
Similar Profiles
Surya Deepthi PemmarajuSurya Deepthi Pemmaraju
Sr.Analyst - Procurement at Deloitte Consulting India Pvt LtdDeloitte Support Services India Pvt LtdSr.Analyst - Procurement at Deloitte Consulting India Pvt LtdDeloitte Support Services India Pvt Ltd
Shwetha SShwetha S
Team Leader at Deloitte Consulting India Pvt. LtdTeam Leader at Deloitte Consulting India Pvt. Ltd
Ashish NairAshish Nair
Digital Care Senior Consultant at Deloitte Consulting India Pvt LtdDigital Care Senior Consultant at Deloitte Consulting India Pvt Ltd