SAP DATA MIGRATION CONSULTANT

(ADM/MDM/ RTR/SQL/SAP/ETL/LSMW/S4Hana/ltmc Migration cockpit)

Accomplished IT professional with over 15 years of success in Data Analysis, Design, Development, and implementation of ETL process.

Expertise in Data Migration process using SAP Advanced Data Migration with extensive experience in data load (including master data and transactional data) techniques like LSMW (IDOC, Batch Input, Direct Input, Recording) / BDC, S4Hana Migration Cockpit. Designed, developed, and implemented DataStage ETL jobs to process very high-volume data sources and HANA Reporting using WEBI.

Excellent hands-on expertise in writing and performance tuning of complex SQL Queries, SSIS packages and Reporting. Experience working with different source databases like Oracle, JDE, North Wind, BAAN, AX, SAGE etc.

Aligned and met expectations of Senior Leadership on the organization and enterprise goals.

Committed to delivering high-quality deliverables on time and within budget. Adept in debugging, troubleshooting, monitoring, and performance tuning of DataStage Jobs and resolving technical issues and positively impacting organizations. Areas of expertise include:

SAP Advanced Data Migration •Syniti. SQL Management Studio •Master data (MDM) Extraction, Transformation and Load process •SAP Load Techniques •LSMW• LTMC Migration cockpit. Hana Reporting (WEBI) •S4Hana – Finance – PTP – OTC - BODS-IDOC •Offshore-Onsite Resource Management •ADM training

Select Highlights

Successfully Completed 15 SAP Data Migration projects (Including Master data and transactional data objects). Out of which 10 projects with ADM (Advanced Data Migration) tool (Syniti) which is helping client for Migrating data from various source systems to SAP, Data cleansing, profiling, and Validation.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Drafted Web Application pages to enable construction of data using Backoffice Associates LLC (now Syniti) ‘Construct’ (Data Construction Server) tool.

Data Profiling and data quality reporting.

Provide training to SMEs, IT and all the relevant team members on ETL process.

Execute data migration in coordination with management and technical services personnel.

Good Team Player with excellent Organizational and Interpersonal skills resulting in excellent Business – user interaction. Understands and evaluates the client requirements effectively.

Excellent written and verbal communication skills.

Dedicated to maintaining high quality standards while meeting deliverables on time.

Maintained projects for different clients across various business Domains.

Received Star award at Client Management and Best Data Factory Consultant Award

CLIENTS Worked with

JCI, Medtronics, Kontoor Brands, Health Care and Family Services (State of Illinois), Advanced Bionics (Sonova), Spectrum Brands, Philips Medical, Bio-Rad Laboratories Inc., PepsiCo, Zuellig Pharma - ROHQ Philippines, BHP Billiton Marketing - Singapore, Chrysler LLC., Danone Asia Pte Ltd -Singapore, Ingram Micro Inc., SABMiller, Merck.

Education

ICAI

Chartered Accountancy (PE-II)

Dr. B. R. Ambedkar Open University

Master’s Degree in Business Administration with specialization in Finance

Andhra University

Master of Arts with specialization in Public Administration

Dr. B. R. Ambedkar Open University

Bachelor of Arts

Certifications

Advanced Data Migration certification from Backoffice Associates LLC (Now Syniti)

Career Track

JCI – Corp Propel

Data Lead – SAP / SQL / LSMW / S/4 Hana Migration Cockpit / LTMC Jan 2022 to till date

Responsible for exaction, cleansing and data migration of Master data and transactional data for all FICO (Record to Report RTR) objects GL – COA, Cost Centers, Profit Centers, AP Open Invoices, AR Open Invoices, Fixed Assets, WBS Elements and Trial Balance and P2P object Open Pos.

Working with RTR Functional team providing support on preparation of various kinds of validation checks.

Formulate various reports (Business relevant / target relevant / configuration checks, etc..) to enable business teams to cleanse data where necessary.

Attend meetings at regular intervals to coordinate the status according to project plan

Support Go-Live

Help providing post-go-live support in resolving the issues raised through Panaya.

Coordinate with other team members at integration areas

Helped with all the data loads using various load techniques like LSMW / LTMC. Responsible for migrating the data for various objects using S/4 Hana Migration cockpit (LTMC)

Providing preload and post load reports for and helping SMEs in validation.

Helped in preparing managerial reports load statistics across the streams.

medtronics

Senior SAP Data Migration Consultant – SAP / SQL / LSMW / ADM / S4H Migration Cockpit April 2021 to December 2021

Responsible for exaction, cleansing and data migration of transactional data for Inventory, Open Purchase Orders, Source List &Purchase Info Records.

Working with Finance Data Migration Team providing support on preparation of various kinds of validation checks and load files.

Formulate various reports (Business relevant / target relevant / configuration checks, etc..) to enable business team to cleanse data where necessary.

Attend meetings at regular intervals to coordinate the status according to project plan

Help uploading the legacy data to target S/4 Hana system using Migration cockpit (LTMC)

Support Go-Live

Help providing post go-live support in resolving the issues raised through HPALM.

Coordinate with other team members at integration areas

Helped for all the data loads using various load techniques like LSMW / BDC / IDOCs / BODS

Providing preload and post load reports for and help SMEs in validation.

Helped in preparing managerial reports like source track, mapping changes, load statistics across the streams.

Kontoor brands

Senior SAP Data Migration Consultant - ADM February 2021 to April 2021

Responsible for exaction, cleansing and data migration of Finance transactional objects including GL balances, P & L balances, GL Open Items, AR Open Items and AP Open Items along with assisting on Fixed Assets using latest Advanced Data Migration tool (Syniti’s tool – formerly Backoffice Associates).

Working with Finance Data Migration Team providing support on preparation of various kinds of validation checks and load files.

Formulate various reports (Business relevant / target relevant / configuration checks, etc..) to enable business team to cleanse data where necessary.

Attend meetings at regular intervals to coordinate the status according to project plan

Support Go-Live for North America and in parallel working on EMEA wave.

Help providing post go-live support in resolving the issues raised through HPALM.

Coordinate with other team members at integration areas

Helped for all the data loads using various load techniques like LSMW / BDC / IDOCs

Providing preload and post load reports for and help SMEs in validation.

Helped in preparing managerial reports like source track, mapping changes, load statistics across the streams.

Health Care and family services (state of Illinois)

Senior SAP Data Migration / Business Analyst August 2019 to January 2021

Conduct an analysis of the migration to the SAP solution of the client’s accounting system, the Programmatic and Administrative Accounting System (PAAS) and related subsystems.

Work with the client’s team members on Asset Management (AM), Project Systems (PS), Controlling Operation (CO), and Public Sector Collections and Disbursements (PSCD) modules emphasizing knowledge transfer regarding functionality of the SAP system and procedures.

Review SAP design documents and identify functional and technical gaps in the prior design activities

Support development of programming logic to convert legacy data into SAP

Assist in the development of extracts for data cleansing for interfaced systems and support the design of interfaces and reports.

Work with client’s personnel to develop SAP user procedures, training materials, review policies and accounting procedures and process and prepare end user documentation for SAP modules.

Work with the client’s ERP SAP team to identify problems with SAP programs and offer technical solutions, and facilitate project rollout and implementation.

Coordinate with client’s staff during the rollout and implementation (Go-live) of ERP.

Participate in post implementation activities and tasks that are developed jointly by client’s ERP project management team.

Review workflows within the department evaluate alignment with SAP processes and provide suggestions for improvements.

Identify backlogs and bottle necks related to accounting functions and activities and recommend solutions prior to and after Go-live.

Assess staffing needs based upon SAP systems impact on general operations and provide recommendations.

Support Data Load team in migration the legacy data to target S/4 Hana system using Migration cockpit (LTMC) for various master / transactional data objects.

Work directly support Go-Live and Post Go-Live activities by triaging user issues to provide immediate assistance to production issues, providing continued training and education for client’s staff, evaluating performance in each SAP functional area, and providing work around solutions to issues encountered during Go-live or Post Go-live operations.

Provide the first line of support for client during Go-live.

Assist in the evaluation of the SAP system’s performance after Go-live including, but not limited to data integrity, responsiveness of system-speed, business, procedural, financial control, and legal and regulatory requirements.

Attend regular team meetings as well as meetings with the state-team, the Program Manager (PM) and the systems integrator.

Use advanced technical skills in Microsoft Excel, Access, Web Intelligence (WEBI) and SQL software to develop queries and reports using s/4 HANA views

Map changes to support s/4 HANA views, interface designs and system components

Plan, develop and implement processes and procedures to effectively implement the fixed asset module of the ERP system and conversion from Warehouse Asset Management System (WAMS) to S/4 Hana.

Provide assistance during User Acceptance Training (UAT) and Operational Readiness Training (ORT), including support for HFS staff.

Perform an analysis review post implementation and provide recommendations.

Provide functional consulting support for client

Identify SAP defects and gaps for input into the Problem Resolution Log.

Provide Transition Support; post-implementation documentation, monitoring and assessment.

Evaluate system performance after Go-Live

Identify SAP defects and gaps for Input into the Problem Resolution Log

Advanced Bionics (Sonova)

SAP Data Migration & Cutover Coordination Consultant October 2018 to April, 2019

Develops detailed cutover checklist and project plan incorporating both technical and operations

or business tasks.

Responsible for creating and maintaining the Cutover Project Plan as per the cutover standards

Responsible for detailed project management of the cutover and conversion deliverables to the

new system, resolving discrepancies or process issues related to cutover

Responsible for ensuring successful planning and execution of integrated release cutover

activities

Plans the human and physical resources required for cut-over activities.

Develops the command center logistics, communication and escalation plan and command center

documentation. (policies, procedures, downtime processes)

Provides cutover status reporting to project leadership and key stakeholders involved in

coordination of legacy shut down activities prior to application activation

Ensures entry into and exit out of cutover stage gates are met including the final Go/No-Go

meetings

Acts as the final point of escalation for all cut-over issues.

Coordinate cutover activities for Pre-Go-Live, Go-Live, and Post Go-Live

Work closely with the workgroups to document the cutover plan for each application

Develops back out / contingency plans for cutover

Work on data migration for various streams like Purchasing, Manufacturing and Finance from

various source systems to SAP. Objects include Vendors, Purchase Info Records, Open POs,

Fixed Assets, Material BOMs, Routings, Production Version, Inventory, etc.

Develop various load programs using LSMW (IDOC / BAPI / DirectInput / Batch Input / Batch

Input Recording)

Maintain Load Statistics

Reporting data issues to Business and help them getting it cleansed.

Spectrum Brands

Data Quality Reporting Consultant April 2018 to September 2018

Formulate various Data Quality reports enable business people to cleanse data where necessary

Provide comparison reports across the source systems (SPX, MAUI) and SAP

Schedule Jobs using SQL Server for Auto-processing the reports and uploading to Share point and then triggering emails to respective users on weekly basis.

Helping the team to create new LSMWs for Pricing conditions and Product Hierarchy as they were identified as the pain points for the business team.

Participate in legacy centralization of pricing process discussions across different systems.

Identifying various criteria to determine the relevancy of data and providing Relevancy reports for active materials and customers.

Support Documentation on entire Data Quality Reporting, naming convention, step-by-step process flow, etc.

Knowledge Transfer to the identified resource, train, transition, support for ongoing activities.

Philips Medical (Project Volcano)

Senior Data Migration Consultant May 2017 to March 2018

Responsible for exaction, cleansing and data migration of Finance transactional objects including GL balances, P & L balances, GL Open Items, GRIR Open Items and assisting on Fixed Assets.

Independently responsible for loading all these objects for two waves simultaneously.

Formulate various reports enable business people to cleanse data where necessary along with many validations reports.

Attend meetings at regular intervals to coordinate the status according to project plan

Coordinate with other team members at integration areas

Responsible for all the data loads using various load techniques like LSMW / BDC / IDOCs

Providing preload and post load reports for and help SMEs in validation.

Helped in preparing managerial reports like source track, mapping changes, load statistics across the streams.

Bio-Rad Laboratories Inc

Data Lead for RTR Feb 2016 to April 2017

Lead (currently in SFO, CA) for RTR. Responsible for exaction, cleansing and data migration of all RTR objects including GL Master, Cost Centers, Cost Elements, Internal Orders, Fixed Assets & GLBalances.

Independently responsible for loading all these objects for multiple Business Units

Provide training to IT team and SMEs

Develop web applications data construction pages

Formulate various reports enable business people to cleanse data where necessary along with many validations reports.

Attend meetings at regular intervals to coordinate the status according to project plan

Coordinate with other team members at integration areas

Responsible for all the data loads using various load techniques like LSMW / BDC / BODS (IDOC)

Providing preload and post load reports for validation

Help business team in mapping source values to correct target fields

Providing metrics about % completion of Mapping, development of an object, data cleansing reports, etc.

PepsiCo

Senior Data Migration Consultant & Offshore Manager Feb 2015 to Jan 2016

Offshore lead for FI, MM & PP Objects from BackOffice (now Syniti) Global Delivery Center, India.

Responsible for exaction, cleansing and data migration of these areas.

Independently responsible for loading all these objects for multiple Business Units using relevant load techniques like LSMW / BDC.

Prepared several Business Validation Reports to aid client in resolving data issues

Overseeing data load issues

Providing preload and post load reports

Coordinating with other team members at integration areas

Attending calls to update PMO about the status, risks according to the schedule

Providing IT / Business team with reconciliation reports about Source extraction, transformation, load and post load, record counts and details for variations, if any.

Senior Data Migration Consultant /Offshore manager-BOA Nov 2014 to Jan 2016

Served as the offshore manager leading a team of 20 people who are assigned to multiple projects.

Guiding the team in design their objects, providing necessary trainings, make sure communication is well established between offshore and onsite team members, ensure quality of deliverables, etc.

Also responsible for conducting interviews, to hire consultants and arrange base camp workshops, cross functional trainings (in-house), etc.

Actively participated in conducting toastmaster sessions to establish right platform for all the team members for healthy interaction and develop communication skills.

Zuellig Pharma Asia Pacific Ltd, ROHQ Philippines

Senior Data Migration Consultant July 2013 to Oct 2014

Onsite Lead for data migration of MM, PP, PM, QM & PM Objects

Responsible for exaction, cleansing and data migration of these areas.

Cross team coordination at integration areas

Coordinating with offshore team to ensure quality of deliverables

Independently responsible for loading all these objects for multiple Business Units using various

load techniques like LSMW (IDOC, Direct Input, Batch Input) & BDC.

Attending the meeting regularly and update PMO about the status, challenges, etc.

Training SMEs and IT team who are involved in migration periodically

Providing various business validation reports to aid Client in data cleansing

Providing various validation reports like Target Readiness, SAP ready and business relevancy reports.

Participated in Mapping workshop along with representation from Business, IT

BHP Billiton Marketing, Asia Pte LTD., Singapore

Data Quality Consultant Dec 2012 to Jun 2013

This was a Data Migration project focusing on SAP Data Cleansing.

Worked onsite (Singapore) – offshore model project.

Helping the onsite team with the following tasks in Materials, Vendors, Customers, and Finance

Building Reports (using Data Construction Server and Data Dialysis)

Preparation of Exports enabling IT team to proceed with loads.

Helping the onsite resource to close most of the defects effectively.

Helping FI team in building reports and closing many defects to meet their deadlines.

Preparing metrics on defects like open / resolved / in progress.

Chrysler, LLC

BackOffice (now Syniti) Global Delivery Center TM - Migration Consultant Dec 2011 to Oct 2012

Work closely with the onsite team on the FICO Objects (BankMaster, GL Accounts (COA), GL

Accounts (CoCode), Cost Centers, Profit Centers, Cost Elements, Internal Orders, GL Open Items, GL Balances, AR Open Items, AP Open Items and COPA Characteristics).

Preparation of data mapping from Source systems to SAP

Transformation rules in Data Staging platform

Providing reports including Relevancy, preload validation, load data & provide post load reports

Create various load programs necessary to support Finance data upload using LSMW IDoc, LSMW Direct Input, and BDCdirect®.

Help Fixed Asset Team and facilitate data load

Independently worked on loading the objects

Created Pre-load and Post-load Reports

Prepared several Business Validation / Target Readiness Reports to aid client in resolving data issues

PepsiCo, Inc

BackOffice (now Syniti) Global Delivery Centre Analyst Dec 2010 to Aug 2011

Worked closely with the onsite team on the following: AR Open Balances; AP Open Balances;

GL Open Balances, WBS Elements, Planned Amounts; Budgeted Amounts, Routings, Pricing conditions, Product Group Load, COPA Sales Volume

Independently worked on loading the Objects

Created Preload and Post load Reports

Prepared several business validation reports to aid client in resolving data issues

Load methods used included LSMW IDoc, LSMW Direct Input, and BDC Direct.

Danone Asia Pte Ltd, Singapore

BackOffice (now Syniti) Global Delivery Centre Analyst July 2010 to Sep 2010

Worked onsite at Danone’s Singapore office on Extraction of data, Filtering of Data and set up of Query Reports

Internal Validation of query reports regarding completeness of extraction

Prepared the list of blocked orders / Billing documents

Open Debit/Credit Memos; Open Debit/Credit Memos Excluding Line Items Rejections, List of GR/IR Balances, Plant Receipts/Issues, Plan Inventory turnover, Purchasing documents by Vendor/Material/Account Assignment, List of stock values/balances, Customer Balances in local currency

Lists of Customer Open Items, Vendor Open Items, GL Open Items; Customer/Vendor cleared items; Customer/ Vendor/ GL Balances, Due Date analysis for all open items and summarization Down Payments open at a key date

Ingram Micro, Inc.

BackOffice (now Syniti) Global Delivery Centre Analyst Aug 2009 to Jun 2010

Worked on FICO objects like G/L Accounts, Accounts Receivable, Budget and Planning.

Involved in preparing pre-load and post-load reports on GL Balances, Budget, and Planning, etc.

Involved in creating reports to aid client in resolving data issues

Worked on SD objects like Customer Master, Condition Records, Long text, Partner Functions, etc.

Used load programs such as BDCdirect®, LSMW Direct input, LSMW IDOC and LSMW BAPI

SABMiller, plc.

BackOffice (now Syniti) Global Delivery Centre Analyst Mar 2009 to Jul 2009

Independently worked on loading FI objects: Bank Data; GL Accounts; Cost and Profit Centers; Employee; Organization Structures; Fixed Assets; GL, AR, and AP Open Balances

Created several Business Validation Reports to aid the client in resolving data issues

Created Pre-load and Post-load Reports

Australia Project:

Responsible for loading Fixed Assets, GL Open Balances, AR Open Balances and AP Open Balances

Created Business Validation Reports, Pre-load and Post-load Reports.

Merck

BackOffice (now Syniti) Global Delivery Centre Analyst Jan 2008 to Feb 2009

Worked on FI objects – Cost Centers, Cost Elements, G/L Accounts, Profit Centers and Internal Orders

Created source rules and target rules as per the business requirements

Created data reports, validation reports, post load reports as per the business requirements

Created tables/views/stored procedures per BackOffice (now syniti) standards

Imported data from different source locations and files into the SQL database.

Kept master data in development environments (2 to 6 SAP clients) in sync with Production and DataConstructionServerTM.

Created BDC and LSMW programs for data loads.

Developed configuration pages in DataConstructionServerTM which helped the administrator to centrally manage/control the field selections based on business rules.

Uploaded specs into EZMapTM tool and administered/monitored for day-to-day changes

Gayatri Projects Limited

Assistant Manager (Finance & Accounts) Apr 1999 to Jan 2007

Managing the finance functions involved in determining financial objectives, designing and implementing systems, policies and procedures to facilitate internal financial control

Supervising overall MIS activity by giving specific inputs as per requirement and assisting Top management in strategic decision making.

Assisting in Cost-Financial Analysis, preparing cash budget as well as making working capital statement for obtaining necessary finance.

Sankurathri Foundation

Associate Administrator Mar 1995 to Mar 1999

Handling all the receivables and managing payables, internal financial records, preparing for audit (both quarterly and yearly), maintaining the day-to-day statements, cash budgeting, forecasting, planning and maintaining various books of account and various stock records & preparation of funds flow and cash flow statements.

Contact this candidate