Post Job Free

Resume

Sign in

Sap Bods Data Services

Location:
Morrisville, NC
Salary:
140000
Posted:
November 11, 2023

Contact this candidate

Resume:

Beeram Srinivas Rajesh

Email- ad015h@r.postjobfree.com

Contact- +1-945-***-****(USA)

● SAP BODS Data Migration Consultant ● S/4Hana Implementation Lead

LinkedIn - linkedin.com/in/srinivas-beeram-6b25a9197

Career Objective:

To seek a strong IT career in an organization that encourages continuous learning and provides exposure to new technologies, to achieve professional and personal growth to the international standards.

Professional Summary:

11+ years of IT experience in SAP BO Data Services Development and Data Migration and Integration.

Focused on developing several reusable interfaces in SAP BO Data Services (BODS).

Expertise in Syniti ADM for Migration of Master data Objects from SAP ECC to SAP S/4 HANA.

Experience in handling Syniti Collect, Map and Enrichment Construct.

Real time expertise in Data Cleansing, Profiling, Harmonization and Migration, Cutover Planning and Data Analysis.

Strong expertise in Handling Article Master, Vendor and Customer Master as Business Partners.

Strong knowledge on using BAPI, IDOC, LSMW and LTMC to facilitate loading data into SAP S/4 HANA.

Worked on Six End to end S/4 HANA implementation Projects and lead four of them. (Greenfield, Brownfield)

Experience in handling multiple legacy systems including SAP ECC, Oracle ERP, and other Third-party ERP Systems.

Strong knowledge on SAP Data Services management console for Scheduling and Monitoring SAP BODS Jobs.

Lead and Contribute to the Data Scoping meetings with PMO and business and develop Migration Strategy and Design flow.

Organizing necessary workshops with Functional team and create technical mapping documents.

Strong experience in planning and leading Cutover activities from client location especially during black out phase.

Real time experience in Installation of SAP BODS, Creating and providing access to repositories.

Strong Knowledge in debugging/handling run time errors in SAP BODS Jobs and interpret test scenarios using SQL scripts.

Enhanced Data Services execution/Runtime performance by enforcing relevant code optimization techniques.

Setting up Data Stores for Legacy Systems, Back-end staging Data Base and Target Systems.

Setup Architecture to handle multiple Connection within same Data Store to process multiple mock cycles in parallel.

Controlling code migration activities of SAP BODS jobs to higher environments using Central Repository, Manual code moment and SAP CTS+.

Expertise in generating data profiling reports using SAP Information Steward (SAP-IS).

Knowledge on SDI, SDQ to enable data replication and transformation services within HANA

Expertise in creating SLT connections for source and target data access (SDA) in HANA.

Expertise in Crystal Reports with CR chart Macros add on, SAP BO Web Intelligence.

Developed several SAP Web Intelligence reports for providing reporting solutions to client.

Strong SDLC knowledge including entire life cycle of analysis, design, build, test, and deployment.

Capable of understanding the business environment and translate business requirements into technical solution.

Around 4 years of working experience in Agile (SCRUM) methodology an using tools like JIRA.

Technical Skills:

ETL Tools

SAP BO Data Services (SAP BODS), Rapid Data Marts, Syniti ADM.

SAP Systems

SAP ECC, SAP BW, S/4 HANA, HANA Studio, SAP Logon.

SAP Load Methods

LSMW, IDOC, BAPI, LTMC.

Reporting Tools

Crystal Reports XI, Actuate Reporting tool 6.0, SAP BO Info View,

SAP BO Web Intelligence XI.

Database

SQL DB, HANA DB, Oracle DB, Sybase DB

Operating Systems

Linux (Fedora, RHEL, CentOS), Windows, MacOS.

Professional Achievements:

Received in name appreciation from Vice President of WMG (client).

Received 7/7 rating as a team from client for our work in Data Services.

Received BRAVO award, an award of appreciation within Infosys.

Published several Documents on reporting tools in Infosys Intranet.

Received Quarterly ACE-award in Accenture

Projects Summary

Project: Gilead Sciences (Project Blue stream)

Team: HCL Data AMS (May 2023 – Till Date)

Role: Senior Technical Specialist

Location: Raleigh, NC.

Leading the Development activities in Syniti ADM and Ongoing Maintenance of Essential Data Migration Modules Encompassing Master Data and Core Finance Objects

Work Done:

1.Designed and maintained scheduled jobs for seamless data synchronization between Oracle EBS legacy and SAP CFIN system.

2.Played a pivotal role in enhancing the Magnitude Enterprise Suite to facilitate the migration of core finance data, including Accounts Payables, Receivables, and General Ledgers data.

3.Leveraged native HANA expertise to establish SLT connections, enabling efficient data transfer to the SAP CFIN system.

4.Actively resolved critical hyper care issues post go-live, ensuring uninterrupted business operations.

5.Managed and monitored scheduled SAP BODS jobs responsible for data synchronization between SAP CFIN and Oracle EBS until the legacy system's decommissioning.

6.Successfully migrated SAP BODS jobs to higher environments following the CHARM (Change Request Management) process.

7.Collaborated with business stakeholders to develop SOX-compliant reports.

8.Created Load ready files for Master Objects using Syniti ADM and generated Post Load using Collect.

9.Developed construct pages to facilitate Validation and load file generation through Syniti ADM.

10.Handled critical transformation to pivot source data of PLM registration specification objects in Syniti ADM make the nested source data compatible for BAPI load program.

Environment: SAP BODS Ver 4.2, SQL DB, Magnitude, SAP S/4 HANA, SAP CFIN, Native HANA, Syniti ADM.

Project: Takasago

Team: Takus Data Migration Team (January 2023 – May 2023)

Role: Data Migration SME

Location: Rockleigh, NJ.

Subject matter expert for the Takasago US Migration project (Takus) for setting up the process for ETL and building master data Objects along with several down stream objects to migrate to already existing live system. (Brownfield Implementation).

Work Done:

1.Subject matter expert for Migrating SAP ECC data to S/4 Hana.

2.Preparing field Mapping documents specific for each object and build SAP BODS jobs to handle ETL process.

3.Work closely with Functional team to understand the business process and build corresponding migration solutions.

4.Identify and report missing configuration to facilitate new data loads into target system.

5.Involve in calls with clients from design phase and planning the cut over activities.

6.Setting up number range to handle deduplication of master data and reassign descoped master data extensions to surviving master records.

7.Designed the solution to keep track of legacy and descoped Master data details.

8.Create end to end solution for each object starting from extract till Load using LTMC, BAPI and IDOCS.

Environment: SAP BODS Ver 4.2, SQL DB, SAP S/4 HANA, LTMC

Project: Stellantis

Team: Data Migration Team (September 2022 – December 2022)

Role: Data Migration Manager

Location: Remote

Migrate the Master data from eight different Legacy SAP ECC system into SAP MDG system. Data included master objects like Business Partners (Vendor Master).

Work Done:

1.Create extract jobs to pull data from eight distinct sources and merge them in to one staging table.

2.Identifying potential duplicates among vendors from different systems and determine main vendor based on business rules.

3.Setting up the data stores for all legacy systems, staging tables and target MDG system.

4.Creating pre-validation programs to identify the missing configurations in target system in correspondence to legacy systems.

5.Creating customized load program to handle non sap standard fields (Customized) fields from Legacy.

6.Setting up number range to handle deduplication of vendors and reassign descoped vendors extensions to main vendors.

7.Designed the solution to keep track of legacy and descoped vendor details in identification tables.

8.Preparing field Mapping documents specific for each individual source system.

9.Creating design documents to conduct workshops on the process and flow of migration to end client.

10.Actively involved in calls with clients from design phase and planning the cut over activities.

Environment: SAP BODS Ver 4.2, SQL DB, SAP MDG, SAP Logon.

Project: ENOC

Team: Data Migration Team (February 2021 – September 2022)

Role: Data Migration Lead

Location: Dubai

Migrate the data from Legacy Oracle ERP and Maximo systems which holds the data of client’s retail business of Auto pro and in store sales of their products to SAP S/4 HANA 1909 system. Data included master objects like Article Master, Business Partners Vendor and Customers along with critical finance downstream objects like AP, AR, GL Balances along with Sales and Purchase orders creation, Fixed assets and Real estate master, Business entity and its corresponding rental unit’s data.

Work Done:

1.Preparing necessary Data mapping documents based on the Functional documents which are required to identify the functionality of Oracle, MS Dynamics & Maximo systems and integrate it with S/4 HANA System.

2.Setting up the migration architecture with Sybase as back-end DB across multiple environments.

3.Preparing data profiling reports using SAP IS to manage and define better cleansing rules during transformation.

4.Performing data cleansing and validation on the extracted data as per business rules and prepared load ready files based on the field mapping documents derived from requirement gathering from business.

5.Responsible for migration of complex and go live critical objects by converting the functional inputs into technical transformation solution.

6.Created custom functions in SAP BODS to handle certain technical scenarios which do not have direct approach in terms of tool functionality.

7.Responsible for creating transform used to identify potential duplicates in customer and Vendor master data across different legacy systems.

8.Responsible for end-to-end migration of Article Master, Customer, and vendor master as Business Partners.

9.Handled complex transactional objects like AP, AR and GL balances which are critical for System go live.

10.Migrated Finance historical data to SAP BW system

Environment: SAP BODS ver 4.2, Oracle DB, LTMC, Sybase IQ data Base, SAP S/4 HANA 1909, SAP Logon.

Project: ADNOC

Team: Data Migration Team (March 2020 – February 2021)

Role: Data Migration Specialist

Location: Abu Dhabi

Migrate the data from Legacy to SAP S/4 HANA 1709 system. Data included master data along with major downstream objects like AP, AR and GL Balances.

Work Done:

1. Responsible for migration of the data from Legacy system to S/4 HANA.

2. Preparing necessary field mapping documents based on the Functional documents.

3. Performing data cleansing and validation on the extracted data as per business rules and prepare Load file.

4. Handled data transformation from distinct Legacy ERP systems like SAP ECC and Oracle.

5. Handled complex Business Partner module in terms of Vendor, Customer and Treasury master.

6. Created data Profiling reports to manage data in more effective way using SAP IS.

7. Created reusable custom functions required to validate Bank data and for other turn around technical solutions.

8. Responsible for delivery of transactional objects like AP, AR and GL balances which have financial impact.

9. Responsible for creating the Post Load reports and consolidate with load counts for business data audit.

Environment: SAP BODS ver 4.2, SAP ECC, SAP S/4 HANA 1709, SAP Logon.

Project: FMC

Team: Data (MAY 2018 – March 2020)

Role: Data Migration Team Lead

Location: Bengaluru

Migrate the data from 5 different legacy systems which Include SAP ECC and Non-SAP to SAP S/4 HANA 1709 system. Data included all the master data along with the downstream objects. It is a Multi rollout country specific migration where multiple mocks were handled in Parallel.

Work Done:

1.Preparing necessary Functional mapping documents based on Technical Design documents by interacting with cross work stream functionals.

2.Used Rapid data mart package provided by SAP to create jobs to Extract, Transform,

Enrich and load the data into target system.

3.Used data quality Transforms to Handle Duplication of records in Vendor and Customer Master data.

4.Applied Deduplication logic to identify Potential duplicates among Master data across different Legacy Systems.

5.Used IDOC to handle Business partner data loads as RFC is obsolete in S/4 HANA 1709 FPS2.

6.Created Preload and Post load reports on top of Calculated views created in HANA Studio.

7.Handled Multiple Rollout Out Executions in Parallel.

8.Created SLT connections to avail live replication of data from source and target in HANA.

9.Actively involved in Cutover Planning for Mock Cycles from client location.

Environment: SAP BODS ver 4.2, HANA Studio, SAP ECC, SAP S/4 HANA 1709, SAP Logon.

Project: Versum

Team: Data (MAY 2017 – MAY 2018)

Role: Senior Migration Consultant

Location: Bengaluru

Migrate the data from SAP ECC to SAP S/4 HANA 1610 system. Data included all the master data along with the downstream objects.

Work Done:

1.Preparing necessary Functional mapping documents based on the Functional documents.

2.Leveraging Rapid data mart package provided by SAP to create jobs to Extract, Transform,

Enrich and load the data into target system.

3.Performing data cleansing and validation on the extracted data as per business rules and prepare Load file.

4.Handled complex Business Partner module which is made mandatory to maintain for Vendor and Customer master in S/4 HANA 1610 system.

5.Used RFC Function to handle Business partner data loads.

6.Created Preload and Post load reports to ensure quality of data before and after data loads.

Environment: SAP BODS ver 4.2, SAP ECC, SAP S/4 HANA 1610, SAP Logon.

Project: Cargill

Team: ECHO (SEP 2016 – May 2017)

Role: Senior Migration Consultant

Location: Bengaluru

Migrate the data from SAP TC3 to SAP TC2 ECC system. Data included all the master data along with the necessary contract’s information.

Further use the data to use for reporting as per the specs provided by Clients.

Work Done:

1.Preparing necessary mapping documents based on the Functional module documents and build jobs to extract data from SAP TC3 system.

2.Performing data cleansing and validation on the extracted data as per business rules and prepare Load file.

3.Loading the file into SAP TC2 system by means of LSMW and IDOC programs using SAP logon.

4.Using data further to provide load stats reports to client based on ADHOC requirements by means of crystal reports tool.

Environment: SAP BODS ver 4.2, Crystal Reports 2013, SAP ECC, SAP Logon.

Project: Phillip Morris

Team: Global Reports and Analytics (SEP 2015 – APR 2016)

Role: Report Analyst

Location: Hyderabad

Create WEBI and Crystal Reports and send corresponding reports to different users in different territories.

Create BODS Jobs to pull data required for reporting from different sources to our database.

Work Done:

1.Analyzing the data needs of our newly acquired client and generating reports with the required data.

2.Developed BODS modules to pull data from different sources into our system to generate reports.

3.Providing support to the developed BODS modules and continuous monitoring by using auto triggered mails from these modules in case of Job fail.

4.Creating BODS jobs to segregate data required for different KPI’s.

5.Providing new reporting solutions which helped business to analyze region wise growth.

Environment: SAP BODS, SAP BOBI ver 4.0 SP 4, Crystal Reports XI

Client: Warner Music Group

Project Name: SAP OPS (MAR 2013- SEP 2014)

Role: Data Services Developer

Location: Hyderabad

Create BODS data interfaces to process newly acquired label sales. Generate and send corresponding reports to different users in different territories.

Work Done:

1.Created BODS interfaces to process sales and product related data of newly acquired music label from different sources and environments to our staging tables.

2.Developed curtail month end run interfaces using BODS to consolidate and save the monthly sales data.

3.Designed BODS interfaces to process data from non-sap systems and post them to SAP BW.

4.Worked on SAP Universe designer and created several objects to meet the new business logic needs.

5.Worked on SAP BO Info view and designed several SAP BO WEB Intelligence reports to provide sales reports and other audit related reports to the corresponding users.

6.Created and automated several Crystal Reports and BODS interfaces and worked on several adhoc requests for Crystal Reports from business users.

7.Worked on SAP CMC to provide proper access on WEB Intelligence and Crystal reports to corresponding users.

Environment: SAP BODS XI version 3.2, SAP BO WEB Intelligence XI, SAP BO CMC, Universe designer, Crystal Reports

Client: Warner Music Group

Project Name: Data Services (APR 2012 – MAR 2013)

Role: BO Developer

Location: Hyderabad

Replace the old Constellar Hub jobs with SAP BODS interfaces for setting up data stores and generating reports and automating the interfaces in Appworx.

Work Done:

1.Recreated several interfaces in BODS based on the Business logic used in constellar Hub Interfaces.

2.Optimized several DS interfaces to improve the performance.

3.Used the management console to manage repositories and to schedule the BODS interfaces.

4.Designed several interfaces to generate reports as per the business needs and automated them using Appworx.

5.Performed end to end testing and user acceptance testing and quality check of Developed Crystal reports.

6.Created custom lookups and shell Scripts and used them in various business needs.

7.Expertise in job monitoring and providing production support to the issues related to low performance, data inconsistency and Interface failures.

Environment: SAP BODS XI ver. 3.2, Data service designer 12.2, Appworx scheduler

Client: Warner Music Group

Project Name: Actuate (FEB 2012-MAR 2012)

Role: Software Developer

Location: Hyderabad

Project involves developing and enhancing .NET application having Crystal reports as integral part of web page

Work Done:

1.Enhanced preexisting Actuate reports to generate and provide reports to the client as per the changed business needs

2.Developed Crystal reports which fetches Data as per the given input criteria by the user and gets displayed within the web page.

3.Enhanced .NET applications to get the Crystal reports displayed within the web page.

4.Developed several packages in PLSQL that helped the business users to upload bulk data into database. This development nearly saved 10 days of effort every Quarter to upload data from business user side.

5.Played key role in migration .NET applications from Windows server 2000 to Windows server 2008 and provided solution for several issues faced during and after the migration.

Environment: MS Visual Studio 2010, Crystal reports XI, Actuate reporting Tool 6.0.



Contact this candidate