SAP Business Objects Data Services Consultant

Projects:-
CLIENT: Continental
Role: SAP Data Migration lead
* Worked on SAP BODS 4.2 version implementation on sap to sap and sap nosap systems.
* Worked on SAP CRM System & Oracle systems for migration of data. Used lookup functions and
validation transformations for migration of data and optimization techniques.
* Hands on experience SAP Ecc& database systems.
* Worked on data migration using IDOCS data transformations.
* Scheduling jobs and doing outage activities.
* Completed the configuration of Data Stores, Local Repository & its Connections
* Created Developer Profile in Management Console and obtained credentials to connect to BODI
* Imported ATL files for Rapid Mart to be used with SAP ECC
* Created the ETL Jobs in BODS in a multi-developer environment maintaining versions in CR
* Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing
in Data Quality.
* Used Data Integrator and Platform Transforms extensively.
* Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension)
Type 1, Type 2 and Type 3.
* Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and
MATMAS.
* Worked on Rapidmarts and IDOCS.
* Working on Non Sap to Sap systems, from sap erp to rapidmart oracle.
* Worked on data services management console and scheduling the jobs in Outage and SLA JOBS.
* Worked on SCD Type1, SCD Type2, SCD Type3 and lookups.
* Worked on Table comparisIon, case transformations to get the pure data.
* Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
* Worked on the IDOC'S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load
into the staging data-base for the multiple projects.
* Worked on the BW open Hub tables to extract the data from the BW.
* Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and
loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
* Worked on the DI scripting & prepared a standard Incremental load template which enables the job
failure/success notifications.
* Created Global variables to read the files from the shared location from the BODS Designer Also
worked on the FTP process to put & get the files on the data-exchange servers.
* Worked on all the standards & guidelines Best practices Documentation, and also the functional &
Technical design specification documentation.
* Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as
part of the Administrator.
* Worked on the Data Quality, Address cleanse transformations for cleansing the data
* Provided the technical guidance & knowledge transfer of effectively using BODS4.0
* Created Repositories, Users & assigned the security in the Multi-Team Environment.


CLIENT: alactel
Role: SAP BODS consultant
Responsibilities:
Best Practices Projects, Data flows, Work flows and transformations and Data Quality (DQM) like
address cleansing and data cleansing process.

Extensive expertise on Data quality management, Global Address cleansing transformations, country
id, real time transformations, US Regulatory address cleanse transform, data assessment.

Relevant Experience on Enterprise Asset Management (EAM) process and maintenance experience in
chemical, oil and gas, and facilities. Highly proficient in EAM/CMMS on point client site
interaction for development, cleansing and enrichment of Assets, Location, Job Plans, PMs,
Classifications, Failure Codes, Items/Inventory, Persons, Labor and Users.
Model and developed EIM Master Data Migration using SAP BODS
* Worked on Data migration Oracle source system to sap hcm.
* Worked on organization management, time management, payroll data migrations.
* Importing the tables from source system to data service designer and get mapping with relevent
transformations.
* using idocs and bapi in the data migrations
* using history preserving transformation and cdc in delta job
* Data migrations done on non sap system to sap legacy systems.
* attaendingkt sessions and documenting the jobs
* Scheduling in the jobs in data service management console.
* giving access from central management console
* Worked on sap hcm , hr objects.

Responsibilities:
* Worked on Rapidmarts and IDOCS.
* Working on Non Sap to Sap systems, from sap erp to rapidmart oracle .
* Worked on data services management console and scheduling the jobs in Outage and SLA JOBS.
* Created custom templates and custom lookups and shell jobs and used them in various business
needs.
* Expertise in fixing production support issues related to multi-provider mapping, data
inconsistency, and job failures.
* Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
* Created Local, Central and Profiler repositories in SQL Server 2008 R2 and configured Local and
Profiler repositories with Job server and Management console.
* Configured the Data services to connect to the SAP R/3, BI and CRM.
* Used Open Hub Services to push data out of SAP BI using BODS.
* Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing
in Data Quality.
* Used Data Integrator and Platform Transforms extensively.
* Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension)
CLIENT: WELLPOINT
Role: SAP Data Migration
* Worked on SAP BODS 4.2 version implementation on sap to sap and sap nosap systems.
* Worked on SAP BW System, SAP HANA & Oracle systems for migration of data. Used lookup functions
and validation transformations for migration of data and optimization techniques.
* Hands on experience SAP Ecc& database systems.
* Worked on data migration using IDOCS data transformations.
* Scheduling jobs and doing outage activities.
* Completed the configuration of Data Stores, Local Repository & its Connections
* Created Developer Profile in Management Console and obtained credentials to connect to BODI
* Imported ATL files for Rapid Mart to be used with SAP ECC
* Created the ETL Jobs in BODS in a multi-developer environment maintaining versions in CR
* Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing
in Data Quality.
* Used Data Integrator and Platform Transforms extensively.
* Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension)
Type 1, Type 2 and Type 3.
* Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and
MATMAS.
* Worked on Rapidmarts and IDOCS.
* Working on Non Sap to Sap systems, from sap erp to rapidmart oracle.
* Worked on data services management console and scheduling the jobs in Outage and SLA JOBS.
* Worked on SCD Type1, SCD Type2, SCD Type3 and lookups.
* Worked on Table comparision , case transformations to get the pure data.
* CLIENT: WALTDISNEY
* Role: SAP Data Migration lead

* Worked on Data migration Oracle source system to sap hcm.
* Worked on organization management, time management, payroll data migrations.
* Importing the tables from source system to data service designer and get mapping withrelevent
transformations.
* using idocs and bapi in the data migrations
* using history preserving transformation and cdc in delta job
* Data migrations done on non sap system to sap legacy systems.
* attaendingkt sessions and documenting the jobs
* Scheduling in the jobs in data service management console.
* giving access from central management console
* Workedon saphcm ,hr objects.