Souvik Dutta
Kolkata
Summary
- Seasoned professional with 12 years in SAP BW and BODS, delivering full-cycle implementations, enhancements, and support for key clients. Extensive experience with BODS integration across flat files, Oracle DB, SQL Server, and SAP ECC. Extensive knowledge in platform transforms, data integrator transforms, and job recovery processes. Proven track record on best practices to push the data into SAP ECC,S/4 HANA using various load mechanisms like IDOCs, LSMW, DMC with strong communication skills and adaptability in dynamic environments.
Overview
12
12
years of professional experience
1
1
Certification
Work History
SAP BODS Consultant
IBM
Kolkata
08.2022 - Current
- Created mapping documents through collaboration with business users.
- Developed ETL jobs using BODS 4.2 to extract different kinds of source data for master data objects like vendor, material, and some other transactional objects like AP, open reservation, PO, PO text, etc.
- I have used IDOCs, LSMW, and DMC as load mechanisms.
- Extensively worked on LTMOM to create new structures for migration objects. Also, to add new fields that are not present in the DMC template.
- Worked on the POC for DMC, as well as the backend HANA staging table-based automated loading.
- Prepared technical specifications, data validation files, and automated no. Of manual tasks performed by the business in the BODS jobs.
SAP BODS Consultant
IBM
Kolkata
09.2021 - 07.2022
- Developed ETL jobs with BODS 4.2 to extract source data for Master data objects and transactional items.
- Loaded transformed data into SAP via IDOCs.
- Created technical specifications and data validation files to ensure accuracy.
- Automated numerous manual tasks performed by Business in BODS jobs.
SAP BODS Consultant
PwC
Kolkata
01.2021 - 03.2021
- Facilitated workshops to gather stakeholder input and drive consensus on projects.
- Collaborated with cross-functional teams to define project requirements.
- Led technical workshops to enhance team understanding of solutions.
- Created detailed design documents that outlined system architecture,data models and integration points with other systems.
- Developed ETL jobs using BODS 4.2 to extract data from SAP ECC tables using ABAP dataflow, and loaded them into staging tables, which were later used as a source for the Tableau dashboard.
SAP BODS Consultant
Accenture
Hyderabad
11.2019 - 12.2020
- Migrated customer master data from legacy system (Oracle JDE) to SAP ECC.
- Created mapping documents through collaboration with business users.
- Transformed data according to business requirements using various methods, including SQL Transform and Validation Transform.
- Extracted data from Oracle JDE to flat file, then loaded into SAP using LSMW.
- Conducted Bit Testing, QA, and facilitated Prod movement for assigned jobs.
- Prepared User Test (UT), Technical Design (TD), and Execution Procedure documents.
SAP BODS Consultant
Accenture
Hyderabad
06.2019 - 10.2019
- Replicating the Informatica jobs to the BODS environment after understanding the Informatica flows.
- Mostly worked on the complex flows using transformations like Table Comparison, Case Transform, SQL Transform, and Map Operation.
- Extracting data from a flat file and moving the data to the BW target.
SAP BODS Consultant
Tata Consultancy Services
Hyderabad
05.2018 - 06.2019
- Involves end-to-end implementations of BODS using Agile methodology.
- Extracting data from the Oracle system, and loading data to the Hana system.
- Working with DS transformations like SQL transform, case transform, history preserving, table comparison, case, map operation, merge, query, and SQL.
- Source and target data stores with multiple configurations for development, testing, and production will be created.
- Attending the calls with the user to collect the requirements.
- Attending daily Scrum calls to update the status and maintain the stories assigned in JIRA.
SAP BODS Consultant
Infosys Technologies
Hyderabad
05.2017 - 05.2018
- Development of ETL jobs using SAP Data Services.
- Identify potential areas of improvement or enhancement.
- Requirement gathering and analysis for work packages.
- Coordinate with other teams for parallel deployment cycles and correct, timely environment setup.
- Monitor the batch in production warranty support.
- Scheduling the jobs by analyzing the dependency and business requirements.
SAP BW Consultant
Infosys Technologies
Hyderabad
02.2014 - 04.2017
- Responsible for delivering BW & BI reporting on time and Batch completion within defined SLA.
- Pro-actively identified performance bottleneck and improved the performance of batches by proper tuning.
- Monitoring of tickets in Service-Now and making sure to resolve the incidents within the agreed SLA.
- Actively involved in data load Monitoring and rectification of load failures (including master and transactional loads) for reporting availability of data and sending the status mails to the end users.
- Creation and maintenance of BI indexes for cubes.
- Involved in monitoring the BW Process chains for Master & Transaction data loads.
- Coordinating with cross functional teams as and when required.
- Maintaining the work history until the tickets are closed.
- Responsible for monitoring daily, weekly, and monthly HANA jobs.
- Analyzed the reason for DTP failures & fixing the errors.
- Responsible to solve user queries which are built on HANA schemas.
Education
B. Tech - Computer Science
Birbhum Institute of Engineering And Technology (WBUT)
Suri05-2013
Higher Secondary Examination -
Labpur Jadavlal High School
Labpur04-2009
Secondary Examination -
Labpur Jadavlal High School
Labpur04-2007
Skills
- ETL tool: SAP BODS 42
- SAP Data Migration
- SAP S/4 HANA Data Migration
- Data migration cockpit (DMC)
- Managing DMC Project using tcode: LTMOM
- Data warehousing tool: SAP NetWeaver BI
- Oracle 11g database
- SQL Server database
- Sybase database
- Microsoft Access
- Microsoft Office
- HP ALM
- JIRA
Certification
- SAP Application Associate Certified- Data Integration with Data Services 4.2
- SAP Certified Associate - SAP Generative AI Developer
Timeline
SAP BODS Consultant
IBM
08.2022 - Current
SAP BODS Consultant
IBM
09.2021 - 07.2022
SAP BODS Consultant
PwC
01.2021 - 03.2021
SAP BODS Consultant
Accenture
11.2019 - 12.2020
SAP BODS Consultant
Accenture
06.2019 - 10.2019
SAP BODS Consultant
Tata Consultancy Services
05.2018 - 06.2019
SAP BODS Consultant
Infosys Technologies
05.2017 - 05.2018
SAP BW Consultant
Infosys Technologies
02.2014 - 04.2017
B. Tech - Computer Science
Birbhum Institute of Engineering And Technology (WBUT)
Higher Secondary Examination -
Labpur Jadavlal High School
Secondary Examination -
Labpur Jadavlal High School