Data Migration S4 Hana

Chaithanya Chama

Email: **************@*****.***

Ph: +1-224-***-****

LinkedIn: linkedin.com/in/chaitanya-chama-89551a111

PROFESSIONAL SUMMARY

Around 9 years of experience in IT Services industry as SAP Resource in Finance, QM, Pharma, PM, and HR Domains.

Extensive experience in data migration and conversion.

Performed end to end Data Migration Implementation Projects with SAP ERP, Non-SAP Systems and S4 HANA.

Extensive experience of driving and leading data transformation engagements in the capacity of Data Lead, working with various data stakeholders from business to successfully transform data for an enterprise.

Experience in Finance, Asset Master, and QM Objects- Inspection Type, Work Centers, Certification Profiles, Inspection Plans Objects.

Experience in Extraction, Transformation, Validation and Loading.

Experience on different types of transformations like Query, Merge, Case, Validations, Table comparison, History Preserving, Key Generation, Pivot, Reverse Pivot and Map Operation.

Worked on IDOC, LSMW, LTMC and BAPI mechanisms.

Having knowledge on SCD1 and SCD2 Implementations.

Worked on creation of Reconciliation Reports, Code execution documents and Technical Specification Documents.

Experience on creating System Configurations for different landscapes.

Worked on Code Deployment in different environments.

Experience in file formats like text files and Excel files.

Experience on Central Repository usage.

Experience in Handling Multi byte languages in source extraction and used different code pages to extract the correct data.

Worked on Performance Tuning techniques like Degree of Parallelism, Multithreading and Partitioning.

Performed code review and unit test plan.

Involved in both Implementation, Rollouts, and support Projects.

Worked on SAP ECC Configurations and Database systems.

Having knowledge of DWH concepts like Star schema and Snowflake schema.

Experience on Monitoring and Scheduling jobs in DS management console.

Good experience to work at client location and giving Trainings to Users.

Worked with bug tracking tools like JIRA and Scheduling tools like Tivoli.

Loaded the data to the multiple systems like Dev, QA, Pre-Production and Production and resolved the issues if any.

Good Experience in BODS designer components Projects, Jobs, Workflow, Dataflow, Scripts and Data stores.

Involved in Mock Data Loads, Cutover Planning, hyper care executions and Sprints.

Have knowledge on Data Profiling and Data Cleansing.

Used ABAP DF’S to extract large volumes of data.

TECHNICAL EXPERTISE:

ETL : SAP Business Objects Data Services 4.2X / 3.X, CPI DS

Technology: SAP BW/BI, SAP BODS, HANA, SAP S4 HANA, CPI DS, Azure Cloud storage

Databases: SQL Server 2005/2008, Oracle 11g/10g/9i/8i, Teradata

ERP : SAP R/3, ECC 6.0, S4 HANA

Training Attended/ Conducted: SAP-DATASERVICES

Professional Experience:

Client: Chevron, San Ramon CA MAY 2022 – Till Date

Position: SAP BODS Consultant –Data Warehousing

Project Name: Data & Insights

Background:

SAP data is ingested from source to raw folder of the lake using SAP data services.

Data services move data from CDS view/open hub to a samba drive and from the samba drive moves the file to raw folder of the data lake.

The file format used is JSON file format.

Data sources for S4HANA and ECC will be CDS views and Open hub for BW4HANA.

Monitoring the jobs on Daily basis and provide resolution to the failed the jobs.

We work on the User stories created for the Enhancements.

We use the Charm process to deploy the changes in PROD.

Attending Stand up calls with the clients to discuss on any open issues.

Client: Microsoft, Redmond OCT 2021 – APR 2022

Position: SAP BODS Consultant –Data Migration

Project Name: MCAPI

Background:

Migrating the Business Partners and Contract Accounts data from RMCA to MDG (S4 HANA) through EMIGALL.

Understanding the Mapping document and functional Specification documents Provided by Functional Consultants.

Used Built in functions, Transformations like Query, Validation, Merge and Pivot to complete the Project.

Called Stored Procedures through the script.

Used ABAP DF’S to Extract SAP tables which have huge volume of data and multiple joins involved.

Implemented Reconciliation.

Involved in DEV, SIT, UAT and PRD Deployments and executions.

Worked on CPI DS to create the tasks.

Client: NXP, Chandler NOV 2020 – SEP 2021

Position: Lead SAP BODS Consultant –Data Migration

Project Name: NXP

Background:

Migrating the data from FSL SAP to NXP SAP Platform

Responsibilities

Extract data from source systems like SAP ECC &Flat Files and load the data to S4 HANA system.

Understanding the mappings and Functional specification documents by attending the calls with functional consultants.

Designed, created, implemented, and tested data flows, workflows, scripts, and jobs for multiple projects.

Used Functions, Transformations, Excel files, created Variables and substation parameters to complete the Project.

Implemented the delta logic to get the not loaded records in target.

Implemented Asset Master object, SAP tables as a source, Transform the data i.e. implementing conversion rules given by the functional consultant and validate the data using validation transform also migrated the final data to IDOC as a target into S4 HANA system.

Extensively used Joins and Lookups to complete the project.

Used HANA database for Staging the data. Used Bulk loading options to Append the source data to the target table.

Client Name: Sigma Aldrich, USA Jan 2016 – DEC 2017

Position: SAP BODS Consultant –Data Migration

Project Name: SAP NEXT

Background:

Sigma Aldrich is a life science platform where we are integrating the multiple source system Non-

SAP, Oracle, flat file and SAP ECC 4.7 and Migrating into SAP ECC 6.0.

Responsibilities:

Worked on most of the SAP QM objects like Inspection type, QM work centers, MIC, Inspection plan, Q Info, Certification Profile.

Worked to migrate data both SAP ECC 4.7 and Non-SAP to SAP ECC6.0 data migration.

Worked with different transformations like Query, Merge, Validation, Pivot, Reverse Pivot, Case in Data Services to implement the conversion rules given by the functional consultant.

Implemented Delta mechanism.

Used System configurations to load the data to multiple environments.

Used different code pages to handle Multi byte languages.

Worked on JIRA, to raise any change requests.

Interacting with customer on daily basis and give him the daily update about the progress of the project.

Exporting\Importing different BODS objects through .ATL file concept.

Used Information Steward to profile the data.

Client Name: JCI Mar 2015 – Aug 2015

Position: SAP Consultant –Data Migration

Project Name: JCI

Responsibilities:

Worked on prerequisites of the project. As part of this initiative, they are transforming data with appropriate cleansing, conversion and migration to SAP.

Responsible for data conversion strategy and technical requirements and design for data mapping

Client Name: SP-AUSNET, Australia Sep 2013 – Feb 2015

Position: SAP BODS Consultant –Data Migration

Project Name: SP-AUSNET

Background:

SP AusNet is an Australian energy company, Based in Melbourne. SP AUNET products are Electricity transmission and distribution and gas distribution.

Responsibilities:

Mainly involved in the HR Module.

Used BODS ETL tool for data loading from Source landing zones to Staging area, implemented transformation rules as per the mapping sheet and final loading into the Flat file. The created flat file will be used by LSMW team to load the data into SAP.

Used Functions, Transformations, File formats, Excel files, created Variables and substation parameters to complete the Project.

Worked with different transformations like Query, Merge, Validation, Pivot, Reverse Pivot, Case in Data Services to implement the conversion rules given by the functional consultant.

Involved in implementing reconciliation scripts and also used some built-in functions like Lookup_ext, To_Date, Concat_Date_Time, Add_Months, greatest, NVL, Decode etc.

Involved in preparation of the unit test cases and preparation Technical Specification Document.

Involved in writing Scripts to move the code from one environment to another environment for permanent tables used in the project.

Developed and run the jobs by using Management Console.

Client Name: Unilever, UK June 2011 – Aug2013

Position: SAP BODS Consultant –Support

Project Name: ISCA, ESRA

Background:

Hindustan Unilever Ltd is a multinational consumer goods company headquartered in London.

Responsibilities:

Monitoring the scheduled jobs if any job fails tried to resolve the issue.

Sending the status mails to the clients.

Used Management Console to monitor the jobs.

Working with Tivoli job scheduler using job scheduling console and monitor the jobs in Tivoli.

Need to give the job status to other teams and if we face any issues, we need to connect BODS development team and solve the issues.

Maintain Work History for all the tickets until it is closed.

Interacted with Clients to get the inputs from the user to close the tickets.

Need to prepare the weekly BODS tracker for SLA’s (service level agreement) related to incidents.

Involved in Deploying the code in different environments.

Involved in Bods administration activities related to user id creation and provide the security access as per end user priority.

Used Teradata as a Database and used Bulk loading Options to load the large volume data into Staging Tables.

Contact this candidate