SUMMARY

• Over 8+ years of experience in IT Services industry as SAP BODS Developer in HR, Pharma and Finance Domains.
• Performed end to end Data Migration Implementation Projects with SAP ERP, Non - SAP Systems and S4 HANA.
• Experience in Asset Master and QM Objects like Inspection Type, Work Centers, Certification Profiles, Inspection Plans Objects.
• Experience in HR Module Objects like All Employees, Active Employees. Terminated Employees, Addresses, Contract Employees and Personal ID’s.
• 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 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 on 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 on DWH concepts like Star schema and Snowflake schema.
• Experience in Code promotion activities, coordinating with deployment team for successful deployments.
• Experience on Monitoring and Scheduling jobs in DS management console.
• Good experience to work at client location and giving Trainings to Freshers.
• 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.
• Involved in Cutover Planning, hyper care executions and Sprints.
• Used ABAP DF’S to extract large volumes of data.
• Used Information Steward for profiling the data.

TECHNICAL SKILLS

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

Technology: SAP BW/BI, SAP BODS, HANA, SAP S4 HANA, Information Steward

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

Trainings Attended: SAP-DATASERVICES (BODS).

Trainings Conducted: SAP-DATASERVICES (BODS- Corporate Trainings).

PROFESSIONAL EXPERIENCE

Confidential

SAP BODS Consultant - Data Migration

Responsibilities:

• Extract data from source systems like SAP ECC &Flat Files and load the data to ECC 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 and validate the data using validation transform also migrated the final data to IDOC as a target into the SAP ECC
• Extensively used Joins and Lookups to complete the project.

Confidential

SAP BODS Consultant - Data Migration

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.
• 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.

Confidential

SAP BODS Consultant - Data Migration

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.
• 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.

Confidential

SAP BODS Consultant - Support

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.