Project lead / SAP Data migration/Bods Consultant

Project # 5 August 13th 2019 To Jan30th 2020
Project Name SWCC
Client SWCC
Technology SAP BODS 4.2, SAP .
Role Data Management consultant
Project Responsibilities:
* Sap data migration project loading using LSMW workbench.
* Working with sap best practices methods and jobs with reference to current project with all
modules.
* Creating modification of Jobs, Workflows, data flows and scripts in Data Integrator to pull
data from the legacy systems and load the data into target database
* Writing SQL Statements in DI scripts to modify data. Created initial and delta loads
* Responsible for creating mapping and transformation specifications based on the business
requirements from various business teams and implemented in Data Integrator jobs
* Validate and execute batch jobs, Test data flows and scripts against sample data and real
data.
* Prepare the Business/Technical Requirements, Design Templates, Development Standards document,
and detailed design documents
* Developed number of Complex data integrator Mappings and Reusable Transformations to
facilitate Daily, Weekly & Monthly Loading of Data

Project # 4 April 8th 2019 to Aug 11th 2019
Project Name Keystone SUPPORT
Client Kellogg's
Technology SAP BODS 4.2
Role APPLICATION DEVELOPMENT ANALYST
Project Responsibilities:
* Monitoring jobs related to project with console.
* Worked on assigned tickets with service now and resolving jobs with failed errors within
timeline.
* Creating modification of Jobs, Work flows, data flows and scripts in Data Integrator to pull
data from the legacy systems and load the data into target database
* Writing SQL Statements in DI scripts to modify data. Created initial and delta loads
* Responsible for creating mapping and transformation specifications based on the business
requirements from various business teams and implemented in Data Integrator jobs
* Validate and execute batch jobs, Test data flows and scripts against sample data and real
data.
* Prepare the Business/Technical Requirements, Design Templates, Development Standards document
and detailed design documents
* Developed number of Complex data integrator Mappings and Reusable Transformations to
facilitate Daily, Weekly & Monthly Loading of Data

Project # 3 April 5th, 2017, to March 31st 2019
Project Name REGTECH
Client Citi Bank
Technology SAP BODS 3.2/4.0, SAP Business Objects XI 3.1
Role BODS CONSULTANT and Report Developer
Project Responsibilities:
* Gather requirements from the Business and applied the look-up functions to meet their
requirements, used if then else function
* Creating Jobs, Workflows, data flows and scripts in Data Integrator to pull data from the
legacy systems and load the data into target database
* Writing SQL Statements in DI scripts to modify data. Created initial and delta loads
* Responsible for creating mapping and transformation specifications based on the business
requirements from various business teams and implemented in Data Integrator jobs
* Validate and execute batch jobs, Test data flows and scripts against sample data and real
data.
* Prepare the Business/Technical Requirements, Design Templates, Development Standards document,
and detailed design documents
* Developed number of Complex data integrator Mappings and Reusable Transformations to
facilitate Daily, Weekly & Monthly Loading of Data
* Involve in creation of WebI Reports using launch pad and implemented Various features like
Drilling, Input Controls & Graphs like Line, Bar & Stacked bar line Charts
* Loading data from source system to target in two stages staging area and target side.
* Loading data from views, flat files, xl sheets to target on oracle database.
* Maintaining history data for all the view using scd type 1 transformation.
* Also used various Aggregate functions, string functions, date functions.
* Created local repositories and central repositories configured them in CMC.
* Extensively used all scd type 1, 2, query, merge, case, validation, table comparison lookups
and sql transformations.

Project # 2 Oct 16th 2016 to April 3rd 2017
Project Name Hamilton
Client NESTLE GLOBE SWISS
Technology SAP BODS 4.1 SP1, SAP BW 7.3, SAP ECC 7.0, MS Excel 2010, Windows 2008 server R2

Role BODS CONSULTANT
Project Responsibilities:
* Created Data stores for Source, staging area and target systems.
* Imported SAP BW Master Data and Transaction Data Info sources using SAP BW Target.
* Performed mappings between source and target applying different functions as provide in
mapping documents.
* Loaded source data into SAP BW Info Objects and Info cubes using DI generated Info Packages.
* Used query, merge, Joins, validate transforms for data integration purposes.
* Also used various Aggregate functions, string functions, date functions.
* Created local repositories and central repositories configured them in CMC.
* Involved in maintaining RFC Connections in Management console.
* Used Try Catch to collect the errors and sent the job status to user's email using SMTP
function.
* Involve in solving the defects for Reports, Universes

Project # 1 Aug 10th, 2012 to Oct 12th 2016
Project Name ECC, Data Migration
Client JANUS CAPITAL GROUP INC
Technology SAP BODS 4.1 SP1, SAP BW 7.3, SAP ECC 7.0, MS Excel 2010, Windows 2008 server R2

Role BODS CONSULTANT
* Project Responsibilities:
* Involved in complete life cycle of a data migration from DEV TO PROD.
* Involved in data migration from legacy systems to SAP using AIO methodology and also LSMW.
* Extensively used SAP Best practices to load the data.
* Worked with most complex, medium and as well as low level objects while loading the data.
* Involved in meetings with the process team to help the process team work effectively. And
accurately completely the mapping of data from legacy system to the SAP system.

* Involved in configuring SAP Applications data store to import SAP tables for SAP Extraction.
* Involved in configuring SAP BW Source data store to import SAP BW third-party Open Hubs for BW
extraction.
* Imported API of process chain RSPC_API_CHAIN_START and used to start SAP BW process chains in
data services designer using new function calls.
* Created the Data Flows, Workflows, Jobs and Projects following the Client Specific Naming
Convention.
* Working on loading Master Data and Transaction Data.
* Prepared the technical specification documents and unit test plans for the components that are
being developed for the migration effort.
* Involved in configuration of post installation steps of SAP Business objects data services 4.1
SP1.
* Used Try Catch blocks for error handling and email alerts.
* Used Performance optimization techniques at query level and source and target object level.

Project Name Terumo Medical USA
Client Terumo Medical
Technology SAP BODS 4.2
Role Sap Bods Consultant
Project Responsibilities:
* Involved in complete life cycle of data migration.
* Handled low to high level of codes from legacy to sap system.
* Worked in two objects data load for GL accounts and contracts.
* Prepared transform valid and invalid reports and validations.
* Load through idoc process with segments and generate post load reports.
* Prepared Reconciliation reports.