Resume

Sign in

SAP Bods Data Migration Consultant

Location:
Bangalore, Karnataka, India
Posted:
October 30, 2019

Contact this candidate

Resume:

V. Pious Ephphatha

SAP BODS, HANA Data Migration Consultant

Mobile: 914-***-****

Email : adapsz@r.postjobfree.com

Career Objective:

To work in a challenging environment that enables me to utilize my skills and abilities, and strive for the growth & increased value of organization. Looking for a stimulating and challenging career, designed through production phase in SAP technology arena.

Profile Summary

Over 10 Years of experience as a SAP BODS Data Migration Consultant, SAP Information Steward, SAP MDG, SAP HANA, SAP BW, SAP BOIS, SAP BI &SAP S/4 HANAin designing, ETL, development, implementation, data analysis, maintain and support .

10 years of experience on SAP BODS, SAP MDG, SAP HANA, SAP BW, SAP Information Steward, LSMW & SAP S/4 HANA.

Worked on 5 end to end implementations on SAP Data Migration Projects .

Having Good Hands on experience on SQL.

Worked on Data Migration SAP to SAP Systems & SAP to Non- SAP Systems.

Experience in data loading through SAP IDOC, LMSW, BAPI & BADI

Extensive experience on BODS Design and Development for extracting, transform and loading data.

Created complex Jobs, Work Flows, Data Flows, and Scripts, IDOCS, BAPI, Local Repository, Central Management console.

Experience in Data Services Jobs Design, Development using SAP and non-SAP systems

Worked on job, work flow, dataflow and complex queries and relevant transformation.

Worked on transformations table comparison, case, Merge, map operation etc.

strong experience in Data Services and Data Quality transformations

Worked on Master Data & Transactional Data.

Designing complex SAP Data Services job flows to extract from/load to SAP system

Strong experience in data extraction, cleansing, transformation, loading and reconciliation.

Worked on Migrating data from current ERP to SAP, Oracle & SAP Systems.

Experience in writing complex SQL (PL/ SQL) procedures/ functions

Experience in ETL integrating BODS with SAP and non SAP data sources SAP ECC, SAP BIBW, SAP PI, SAP HANA

Technical Expertise on SAP BODS, SAP BOIS, SAP MDG,SAP BW, SAP HANA, SAP S/4 HANA & SAP MM.

Experience in working with SAP Data Management Tools Data Services, Cockpit, MDG, HANA EIM.

Worked on Support Projects resolving Tickets & Change Requests (CR).

Having hands on experience on SQL writing, expertise in Oracle DB Analytics, in Field mapping testing

Experience on S/4 Hana.

Experience in SAP HANA modeling and scripting experience which includes ability to write complex stored procedures and scripted HANA views using SQL. Implement data models with SAP HANA using analytical and calculation views. .

Good Technical Experience in SQL, SAP HANA., experienced with migration of master, transaction, reference and history data migrations

Experience on SAP functional modules FI, CO, HCM, MM, SD, PP, QM, PM

Strong experience with S/4 HANA data structures and knowledge on SAP R/3 ECC

Extensive experience on BODS Design and Development for extracting, transform and loading data.

Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.

Created complex Jobs, Work Flows, Data Flows, and Scripts, IDOCS, BAPI, Local Repository, Central Management console. Using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target

Experience in SAP HANA modeling and scripting experience incomplex stored procedures and scripted HANA views using SQL. Implement data models with SAP HANA using analytical and calculation views.

TECHINCAL SKILL SET

ETL Tools:SAP Data Services 4.2/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), data service management console on development, quality and production.SAP PM, SAP EAM,IDOCS, BAPI,CRM, RAPIDMARTS Objects, data migration from non sap to sap and sap to sap systems.

Reporting tools:- sap bo, SSRS

Databases: DB2, MS Access, MS SQL Server 2008 R2/2005

Languages: SQL

Operating System: UNIX, Linux, MS-Dos, Windows NT 4.0/2000/ 2003/2008r2/XP/Vista/7

WORK EXPERIENCE

Current Company : Compnova Solutions pvt ltd

Duration : From June 2017 to till date

Designation : SAP BODS Data Migration Consultant

Current Company : DXC Technologies

Duration : From June 2016 to June 2017

Designation : SAP BODS consultant

Company :Lobaan software pvt ltd

Duration : From sept 2013 to june2016

Designation : SAP data migration consultant

Company winnow it services pvt ltd

Duration : From April 2009 to sept 2013

Designation : SAP bods consultant

EDUCATIONAL DATAILS:-

Completed Bachelor of computer science and Engineering in Dr Paulraj Engineering College from JNTU University.

Projects:-

CLIENT: Continental

Role: SAP Data Migration lead

Worked on SAP BODS 4.2 version implementation on sap to sap and sap no- sap systems.

Worked on SAP crm 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.

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

Workedon saphcm, hr objects.

CLIENT:marcus

Role: SAP Business Objects Data Services Consultant

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 no- sap 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.



Contact this candidate