Senior SAP BODS / Data Integration Specialist

Summary:

Over **+ years of work experience in the IT industry and 15+ years of experience with SAP Business object data service and BOBJ.

Extensive ETL and data integration experience in developing Data warehouse solutions using SAP Business objects Data Integrator/Data Services 3.x, 4.2 (Designer, Management console).

Experienced domain knowledge in the areas of manufacturing industry, telecommunications, waste management, automobile, Oil & Gas, Banking, Retails, Utility, and Wholesale.

Experienced in requirement gathering, gap analysis and developed functional specifications, technical specifications and design and development of various Data Warehousing /Data Migration projects using SAP BODS.

Extensive experience in SAP Business object data service (BODS) ETL tools and actively involved in identifying data to be transferred from Legacy to SAP S/4 HANA, SAP CRM and Vice versa to Salesforce.

Experienced SAP HANA smart data integration and SAP HANA smart data quality.

Extracted data from Teradata Database through Business object data service and Generate XML outputs.

Extracted Customer Master, Customer Account, and Service Account from DB2 and done Transformation in BODS then migrated to SAP CRM system Through BAPI structure.

Experienced in Extracting data from BW through BODS and loading into SAP ECC system.

Worked extensively with Data Extraction, Data Parsing, Data Cleansing, LSMW, and BAPI IDocs.

Worked with Finance (R3) release to design data migration from Legacy system to SAP.

Expert-level in designing and developing complex mappings to extract data from sources including flat files, RDBMS tables and legacy system.

Exposure on loading data into SAP HANA, S4/HANA database from Non-SAP and SAP Systems using RFC Connection.

Expert level knowledge and hands on experience in using SAP Business Objects Data Services for Data Migration, Address Cleansing and Validation in large projects.

Extensive SQL experience with relational databases (SQL Server 2000/2005/2008).

Designing, developing, implementing, and testing of BOBJ 4.0.

Trained on data migration cockpit.

Actively participated in testing cycle, Integration testing and User Testing.

Technical Skills:

ETL TOOL

SAP BO Data Services 4.0, 4.2, Data migration Cockpit

SAP

ECC 6.0, SAP BI 7.3, SAP BI 7.0

Reporting Tools

BOBJ 4.0,Crystal Reports, Dashboard

SW Development

Web and Windows applications

Web Technologies

HTML, DHTML

Databases

HANA Studio, MS SQL Server 2000/2005/2008,Oracle SQL Developer

Education:

M.S in Software System - Birla Institute of Technology & Science (BITS), Pilani India

MCA in Computer Science - Madras University India

B.Sc. Computer Science – Madras University India

Certification:

SAP Data Integration with Data Services 4.2

SAP Business Objects Web Intelligence 4.0

Professional Experience:

DELOITTE: Mar 2019 – Till Date

Client: HD Supply GA Sep 2025 – Till Date

Role: Sr. SAP Data Services Consultant

Migrated the data from Snowflake to ECC CRM S4 HANA using BODS and HANA DB.

Worked on Customer Master and Open AR data conversion.

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from source system to SAP S/4 Hana.

Coordinated with offshore team and leading various development activities.

Loading data from source files into SAP S/4 Hana using IDOC's, DMC and BAPI's.

Working with the IDOC, BAPI, S4 HANA, SQL Server, LTMC – DMC.

Client: Global Foundries NY Feb 2025 – Aug 2025

Role: Sr. SAP Data Services Consultant

Migrated the data Oracle to S4 HANA using BODS and HANA DB.

Worked on Material master Classification data conversion, and Fixed Assets.

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from source system to SAP S/4 Hana.

Extracted data from Oracle system and migrated S4 Hana system using SAP BODS.

Coordinated with offshore team and leading various development activities.

Loading data from source files into SAP S/4 Hana using IDOC's, DMC and BAPI's.

Working with the IDOC, BAPI, S4 HANA, SQL Server, LTMC, MDG, Fiori app – DMC.

Client: Aramco Trading US __Sep 2024 – Jan 2025

Role: Sr. SAP Data Services Consultant

Migrated the data source file to S4 HANA using DMC tool.

Worked on customer and vendor master data conversion and responsible for data migration and conversion activities.

Cleanse data to correct inaccuracies and remove duplicates.

Map data fields from source systems to the target S/4HANA system for preparation.

Loading data from source files into SAP S/4 Hana using SAP Data Migration Cockpit. Coordinated with offshore team and leading various development activities.

Loading data from source files into SAP S/4 Hana using IDOC's, DMC and BAPI's.

Working with the IDOC, BAPI, S4 HANA, SQL Server, LTMC, MDG, Fiori app – DMC.

Client: Weyerhaeuser Seattle WA Jan 2023 – Aug 2024

Role: Sr. SAP Data Services Consultant

Migrated the data ECC and CFIN to S4 HANA using BODS and HANA DB.

Worked on Material master data conversion, Open AP, Open AR, Pricing conditions Source list, work order confirmation and Open Planned Orders.

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from source system to SAP S/4 Hana.

Extracted data from ECC and CFIN system and migrated to MDG and S4 Hana system using SAP BODS.

Coordinated with offshore team and leading various development activities.

Loading data from source files into SAP S/4 Hana using IDOC's, DMC and BAPI's.

Working with the IDOC, BAPI, S4 HANA, SQL Server, LTMC, MDG, Fiori app – DMC.

Client: Google LLC California CA Jun 2020 - Dec 2022

Role: SAP Data Services Consultant

Migrated the data from Oracle to S4 HANA using BODS and HANA DB.

Involved in R3.1 and R3.2 releases. Worked on HR employee master & org data conversion, Asset master, Asset balances, Open AP, Open PO, Pricing conditions and Inventory.

Worked on customer master and Open order objects.

Responsible for customer master design, develop solutions for Order to cash management team using SAP BODS.

Extracted data from Oracle and B3 system and migrated to MDG system using SAP BODS.

Develop Reconciliation reports to business for source target data comparison.

Extensively supported Open Order Team on Transactional Data migration from Oracle system to SAP S4 system.

Designed and developed ETL jobs in BODS, modified or created new Data services Jobs to meet project requirements.

Involved in cut-over activities in Pre and Post go -live phases.

Client: Carpenter Reading PA Feb 2020 – Jun 2020

Role: SAP Data Services Consultant

Migrated transactional object data from source file and stage into SQL server then transformed and load into SAP S/4 Hana system.

Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.

Extensive experience in using BODS as an external system for ETL between Source file and S/4 Hana.

Worked extensively with Plant Maintenance objects, Source to Pay objects to migrated from Legacy system to S/4 HANA.

Loading data from source files into SAP S/4 Hana using IDOC's and BAPI's.

Created SAP Data Services jobs for the following objects: Open AR, Open AP, Fixed Assets, PIR, BOM and Routings.

Enhanced the Standard Best Practices Data Flows based on the Clients need.

Extensively used Data Services Management Console to execute jobs.

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from source system to SAP S/4 Hana.

Validate and Enriched the Data flows and resolved the issues based on the validation from source system fields, formats, and lookups to target system.

Executed Reconciliation flows and steps to validate the migrated master and transactional data from the target systems.

Coordinated with offshore team and leading various development activities.

Client: Verizon Lake Mary FL Oct 2019 – Feb 2020

Role: SAP Data Services Consultant

Worked on data migration Objects (Bank Master, Equipment, Functional Location, Fuel card, Purchase info record).

Developed data migration approach and strategies using SAP best practice methodology.

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data from Source file to SAP S/4 Hana.

Loading data from source files into SAP S/4 Hana using IDOC's and BAPI's.

Extensively worked on management console.

Identified bugs in existing mappings by analyzing the data flow, evaluating transformations, and fixing the bugs and redesign the existing mappings for improving the performance.

Involved in complete life cycle of a data migration from DEV TO PROD.

Skilled in creating Design Documents, Coding Standards, Best Practices and Error and Exception Handling Strategies.

Client: Stericycle Chicago IL Jul 2019 – Sep 2019

Role: SAP Data Services Consultant

SAP data conversion is used for loading Contract data load from Legacy system (HCS USA, HCS CAD and SHR to S/4 HANA and Sale Force.

Extracted contract data from Legacy system and staged in SQL server then transformed and load into SAP S/4 Hana system and sale force system.

Involved in requirement gathering and gap analysis activities.

Developed reconciliation reports to business for source target data into SAP S/4 HANA.

Extensively used Data Services Management Console to execute jobs

Used technical transformation document to design and build (ETL) modules.

Client: Toyota Plano TX Apr 2019– Jun 2019

Role: SAP Data Services Consultant

Extracted data from People Soft legacy system and loaded data into S/4 HANA using SAP BODS.

Extensively used LSMW and BAPI to load data into S/4 HANA.

Implementing the business rules, validations and restructuring the data into target SAP.

Extraction from Legacy System, Transformation done through informatica, then data loaded in to targeted system via BAPI or LSMW.

Responsible for both sides of a data reconciliation.

Extensively working on Data load using BAPI and LSMW.

Data comes in a file format; we will be loading data through custom IDOC.

Supported in all the phases Dev, QA, and Production of Project.

IBM: Aug 2017- Sep 2018

Client: Schlumberger Houston TX Feb 2018 – Sep 2018

Role: Sr. SAP Data Services Lead Developer

Migrated legacy vendor master data (MFGPRO) to SAP ECC 6.0 IS-Oil & Gas.

Creating jobs using SAP Data Services to extract and transform data from the source systems to the target SAP.

Implementing the business rules, validations and restructuring the data into target SAP.

Involved with Business and Functional Resources while creating Mapping Documents for Data Migration for MM and PTP transaction objects.

Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Integrator.

Extracted Vendor Master from Legacy System done Transformation in BODS then migrated to SAP ECC system Through IDOC.

Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS and BAPI.

Extensively used SAP Data Services Designer and Management Console.

Involved in complete life cycle of a data migration from DEV TO PROD.

Migrated code from Local/Central repository to different environment repository.

Extensive experience in migrating the data in three cutover sessions and involved in three GoLive’s.

Responsible for full Migration cycle of objects across modules including SAP technical and Functional assistance on the project.

IBM (Chemical Industry) Baton Rouge Aug 2017 – Jan 2018

Role: Business Object Data Service/HANA (SDI&SDQ) Consultant

Migration of Vendor Master Material Master, GL Open items, Purchasing Order, Contracts from Legacy system to S4 HANA.

Responsible for Gather Business requirements, data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data.

Utilizes Rapid Deployment Solution, BPDMs and customized Jobs to migrate data with SAP Data Services for following items: Purchase Orders, Vendor Master, Material Master and Contracts.

Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS and BAPI.

Managed the central and local repositories using the Management console and Repository Manager

Migrated the dataflows to the production environment for Go Live of the Web Intelligence business Reports which used the underlying ETL.

Used SAP BODS to extract data from Legacy system did transformation, and to load to S/4 HANA system

Worked on SDA (Smart Data Access)/SDI (Smart Data Integration) in SAP HANA.

Used SDA/SDI for data cleansing, data convert, Deduplicate, and data quality and loaded data in schema

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Zenaide Technology Inc.: Oct 2016 – Feb 2017

Client: Silicon Valley Bank, CA Oct 2016 – Feb 2017

Role: SAP BODS Migration Consultant LEAD

Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data. Developed data migration approach and strategies.

Extracted data from IAT-related NACHA flat file from source then processed ACH transactions in SAP BODS and consolidated the data then loaded to Actimize.

Understand the Requirements and Functionality of the application from specifications did data analysis, validation, cleansing, collection and reporting.

Prepared data Extract from legacy system on Sybase and DB2 and Loading to SAP target systems.

Used Business Objects Data Integrator for ETL extraction, cleaning transformation and loading data from heterogeneous source systems such as excel, IDOCS and flat files.

Define various audit points and rules to ensure that a data flow loads correct data into the data warehouse.

Capgemini America Inc.: Apr 2016 – Aug 2016

Client: American Greetings OH Apr 2016 – Aug 2016

Role: SAP BODS Migration Consultant LEAD

Gather Business requirements.

Worked with CSH team closely to understand the business process, coordinate with business analyst on specific business rules.

Generated ETL documents for existing Business object data service jobs for analyzing Workflow and Data Flow.

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Analyzed the new changes that need to be implemented into existing BODS project.

Created new mappings and updated old mappings according to changes in Business logic.

Extracted POS Data, Remittance Data from Flat file and loaded onto CSH database using data services.

Involved in data analysis, data mapping, data extraction, data verification and data validation.

Migrated code from Local/Central repository to different environment repository.

Actively involved in the production support and transferred knowledge to the other team members.

Co-ordinate with the offshore team to assign tasks, guiding them and clarifying the technical queries.

MYTECH US LLC: Dec 2013 – Apr 2016

Client: Southern California Edison CA May 2015- Feb 2016

Role: Business Objects Data Service Migration LEAD

Migration of Customer Master, Customer Account, Service Account from DB2 to SAP CRM.

Interacted with Business Users and Managers in gathering business requirements.

Improved performance for outage communications of residential customers by implementing CRM and HANA.

Involved in data analysis, data mapping, data extraction, data verification and data validation.

Extracted annual reporting of power consumption data by LEA’s from Teradata Database through Business Objects Data Service and generate XML outputs to the California Energy commission.

Extracted Customer Master, Customer Account, and Service Account, Profile attributes from DB2 and done Transformation in BODS then migrated to SAP CRM system through BAPI structure.

Extracted unassigned contacts from the legacy CRM as flat file and loaded to NEW CRM system using data services.

Used Business Objects Data Service for ETL extraction, transformation and loading data from source systems like DB2, Legacy CRM and then loaded into SAP CRM systems.

Extensively utilized BAPI to create and modify LSMW to load object.

Optimized SAP Data Service batch jobs using performance tuning techniques like parallel processing and bulk loading.

Provided the technical guidance & knowledge transfer to business user.

Client: COSTCO WHOLESALE WA Dec 2013 - Apr 2015

Role: Data Migration Developer

Interacted with Business Users and Managers in gathering business requirements.

Migration of vendor master Data, Fixed Assets, GL balances, PO Data from legacy system to SAP.

Extracted Fixed assets data from AS400 migrated to SAP with separate loading strategies based on the type of assets.

Experience in Extracting vendor partner functions data from trading partner legacy system to SAP with the relevant vendor account group for different vendor Partner functions.

Used Business Objects Data Service for ETL extraction, transformation and loading data from source systems like Iseries, DB2 and then loaded into Oracle SQL staging tables and populating to SAP target systems.

Using Data service Extracted Purchase order creation and PO changes data from the Legacy system then transformed and loaded into SAP system.

Provided the technical guidance & knowledge transfer to business user.

MYTECH INDIA PRIVATE LTD: Dec 2007- Nov 2013

Client: EMC MA Jan 2011 - Nov 2013

Role: Data Migration Developer

Migration of master Data, Delivery, and Billing data from legacy databases to SAP ECC. Gathered requirements from the business users, analyzed and build necessary specifications for transferring data from legacy to SAP ECC 6.0 system in the areas of Sales, Delivery, Billing and Master Data.

Used Business Objects Data Service for ETL extraction, transformation and loading data from heterogeneous source systems such as excel and flat files into SAP ECC.

Experience doing extracts from SAP source systems using dataflow and loading into SQL server for the downstream applications.

Used technical transformation document to design and build (ETL) modules.

Developed the flows (work and data) where the data is extracted from the sources like Oracle 11g, and then loaded into staging tables to support the enterprise Data warehouse needs using SAP Business Objects Data Service.

Executed Reconciliation flows and steps to validate the migrated master and transactional data from the target systems

Order Management System:

Migration of open orders data from the legacy SQL Server Order Management System (OMS) to the new SAP ECC 6.0

Staging the source data into Data Services Engine from SQL server, flat files and Excel spread sheets into Data Services and implemented necessary transformations to transform as per the target SAP architecture and loaded into the SAP R/3 system using the Idocs and custom load files.

Created Jobs specifications based on analysis of source data, user requirements and business Rules.

Used the case, validation, merge transforms to validate the Sale Transactional data.

Experience in debugging execution errors using Data services logs (trace, statistics and error) and by examining the target data.

Implemented various error recovery mechanisms to recover missing rows and values in target database.

Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Services (SAP BODS).

Involved in performance issues while doing Full load and delta load using data services.

Client: Luxottica Retail, Mason, OH Dec 2007 – Jan 2011

Role: SAP WEBI Developer

Order to Cash

Involved in requirements gathering from the business users to build the reporting application.

Developed WEBI reports to the Project Management, time sheet for resources to track each WBS element and Actual vs. Budgeted cost for the project.

Developed WEBI reports on Order to Cash scenarios related to invoice discount analysis and contract value and value used.

Create WEBI reports by using Business Objects functionalities like Alerter, Drill Down/up, Sorting, Ranking, Sections, Data Tracking, Cross tab and Calculations etc.

Developed reports based on Actual Revenue Accrual Reports vs Forecasted Accrual Reports.

Unit and integrated testing of developed solutions in the Business Objects Designer and reporting.

Inventory aging

Involved in gathering, analyzing and documenting business requirements, and data specifications for Business Objects universes and reports.

Extensively involved in client interaction & co-ordination from Offshore.

Designed and developed inventory aging report based on plant and storage location.

Worked on WEBI reports, Prompts and Report Layout and re-formatting.

Developed reports/ad hoc reports which run on weekly and monthly basis/user defined reports respectively.

Defined many formulae, variables, sorting, ranking as required by the report requirements

Worked with several features like Scope of Analysis, Data Tracking and Drill functionality.

Extensively worked on Integration Testing, User Acceptance Test (UAT)

Searock InfoTech Technology Services Dec 2005 – Nov 2007

Role: VB Developer

Hospital Management Software is designed and developed in Visual Basic multi-user environment. The software includes Registration of Outpatient and Inpatient, Billing, and Lab Testing.

LAB reports generated with Crystal Reports and automated MS Word document generation.

Gestalt Technology Services Bangalore Jul 2005 – Dec 2005

Role: VB Developer

Pharmacy Management System: The product is developed using Visual Basic which the system handles procurement process for stock materials which includes creating a purchase requisition, generating purchase order, receiving the materials, processing the vendor's invoice, paying the vendors, sales order.

Contact this candidate