Candidates About

 

Sachin Agarwal

SAP Data Migration/HANA/MDM/MDG Lead

SAP Cutover Manager

Cell: 201-699-3600

Email: agarwal.Sachin@hotmail.com  

 

Professional Summary  

 13+ years of experience in SAP Data Migration, Master Data Management MDM, Master Data Governance MDG, SAP Cutover Planning, Data Analysis, Business Intelligence, Business Consulting and Project Management roles, with dual emphasis on business and project management and technology.  His diverse experience includes project successes in the areas of Data Migration using SAP BODS (Business Objects Data Services) and BackOffice Associates Tools and Methodology, new feature development and enhancements, SAP BW/BI, SAP HANA, SAP Information Steward IS, SAP DQM, SAP Finance, SAP SD, SAP MM, SAP MDM, SCM Supply Chain Management, Business Intelligence, Business Objects, SAP MDM (Master Data Management), Data Analysis, DBA Skills, Data Warehousing, Pre-Sales and vendor software implementation.

Candidate has undertaken a Big Data Course from MIT and has knowledge of Professional Services, Pharmaceutical, Finance, Banking, Healthcare, Supply Chain, Vendors, Retail, Materials, Tax, Treasury and Telecom verticals.  He is a motivated self-starter with exceptional team building, leadership, and interpersonal skills.  Candidate possesses excellent communication and organization skills with the ability of adapting to new environments quickly.  Candidate has familiarity with onsite-offshore models and has led a team of offshore and onsite developers.  He is a team player with the aptitude to work in time sensitive environments making him an effective member of any data migration team. 

Specific Expertise  

·         Bachelor's Degree in Computer Science Engineering with 13+ years of IT experience in SAP Data Migration, Data Analysis, Data Audits, Process Management, Business Analysis, ECM, Business Process Re-engineering, RFPs, Quality Assurance, Data Analysis and Modeling and Testing of enterprise wide client/server and Web-based applications and all aspects of Software Engineering and Systems Development Life Cycle (SDLC)

·         Expertise in Master Data Governance MDG and Master Data Management MDM.

·         Certified in BackOffice Associates Data Migration and ETL Tools: Data StagingWarehouse™, DataGarage,EZMap™, DataDialysis, BDCdirect, DataProfiler™, DataConstructionServer™,dDup™, SourceTrack™, CranPort™

·         Extensive experience in Finance, SCM, SRM, Banking, Tax, Treasury, Healthcare, Insurance, Pharmaceutical and Telecom verticals.

·         Expertise in Cutover Planning, Project Planning, Project Design, Gathering Business and Functional requirements, creating functional specifications, and Use case data flow diagrams

·         Worked in SAP Finance, SAP SD, SAP MM, SAP SCM, SAP MDM, SAP Project Systems, Vendors, Business Objects, OBIEE, SAP R/3, Business Warehouse (BW) 7.0, Data Warehousing, Data Governance and Master Data Management (MDM)

·         Extensively used Microsoft Excel, Project, Visio, PowerPoint, Word and MS Office products for data Analysis, Project Schedules, Business process modeling, Requirement/issues documentation and Customer training.

·         Experienced in preparing Test Plans, Test Cases, Test Scripts and Test Summary Reports for Automated and manual testing.

  

Technical Skills  

ERP/ETL	SAP Business Objects Data Services BODS 4.0, SAP Information Steward IS, SAP DQM, SAP MDG 7.0, SAP BW, SAP HANA, SAP Finance, SAP SD, SAP MM, SAP SRM, SAP ECC, SAP MDM, Netweaver 7.1, SAP CRM, Vendors, Business Objects XI, Data Stage, BOBJ, SAP HANA, SAP Information Steward, Webi, Xcelcius, Crystal Reports, Peoplesoft, OBIEE, R/3 4.7, BI (BW) 7.0, Data Warehousing, Crystal Reports, OLAP, Informatica, PowerCenter, PowerStage, IBM DataStage, Big Data Technologies (Beginner)
BackOffice Data Migration Tools	Data StagingWarehouse™, DataGarage, EZMap™, DataDialysis, BDCdirect, DataProfiler™, DataConstructionServer™, dDup™, SourceTrack™, CranPort™, cApps™, cCust™, cMat™, Cransoft
Methodologies	SDLC, Agile, Rational RUP, BABOK, Scrum, XUP,OOAD, OLAP, ETL, ITIL
Business Modeling Tools	ERStudio Data Architect 11.0 (ERWin), UML, MS Visio
Databases	SQL Server 2005, 2008, MS Access, PL/SQL, Oracle, DB2, Teradata
Operating System	Windows 2003 Server, Windows XP/2000 ,UNIX
OS/Platforms	Unix (HP, SCO, Solaris 2.0), Windows 9X/NT/2000/XP
Programming Languages	PL/SQL, Oracle, C, C++, VB, VBA, Java
Applications	MS Office, MS Sharepoint, MS Excel, MS Word, MS-Project, MS Power Point, Toad, Tax Applications: CorpTax ETS, CorpSale, Property Tax, Treasury applications: ResiQ2, Bank Relationship Manager, Treasury Workstation, Clarify, Toad, BMC Remedy, Clear Quest, HP Quality Center QC, SQL Management Studio
Telecom	VoIP, SIP, Switching Technologies
Functional	Vendors, Pharmaceutical, Finance, Tax, Treasury, Brokerage, Healthcare, Supply Change Management, Insurance, Telecom, IT Asset Management, ETL, Data Migration, Master Data Management, Data Governance

   

Work Experience 

 SAP/ETL Project Experience

____________________________________________________________________________ 

Client: MathWorks Inc. , Boston MA                                                                       Feb’16 to Present

Role: SAP Data Migration/MDM/ETL/Data Warehousing Architect

Working as part of Mathworks’s Data Wahousing/ETL/ERP team to design, develop and implement SAP BODS solutions. Mathwork’s is very early adapter of SAP BODS solution and have been using it for over 12 years and put lot of emphasis on high quality design and coding.

 

Responsibilities

·         Responsible for driving the entire ETL/data migration effort to migrate data from several legacy applications to new Data Warehousing implementation.

·         Responsible for formulating the Data Migration strategy for various objects.

·         Responsible for understanding client requirements and coming up with the best possible design.

·         Developing, coding and implementing the SAP BODS solutions in Test, UAT and Prod environments.

·         Responsible for development of reports, jobs and rules in SAP Information Steward IS.

·         Responsible for Developing solutions for full data loads, delta data loads, Master Data Loads and Transaction Data Loads.

·         Responsible for Data Provisioning into SAP HANA using SDA and other Data Provisioning methods.

·         Used SAP Data Services built in Functions to transform the data, created SAP Data Services Jobs scripts to automate data loads and variables with Parameters.

·         Use ERStudio Data Architect 11.0 for developing Logical and Physical Data Models and take care relationships and foreign keys.

·         Developed SAP Data Services ETL and SAP Information Steward jobs to pull data from applications hosted on Oracle, Microsoft SQL Server 2008.

·         Providing expert level knowledge in creating Project Plans, Mapping documents, Data Load Plan, Mock Load Plans, MDM, and Business Rules plan.

·         Taking part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Responsible for Pre-Load and Post Load data validation and for creation and distribution of preload and post load reports related to legacy data.

·         Also responsible for updating the Universe using universe design tool.

 

Client: Capgemini US                                                                                                                     Aug’14 to Jan’16

Role: SAP MDM/Data Migration/MDG Lead

 Working as part of Capgemini’s SAP Implementation team in a new SAP Implementation project for a global client. Go-Live is scheduled to take place in Nov/Dec’15 time frame

 

Responsibilities

·         Responsible for driving the entire data migration effort to migrate data from several legacy applications to new SAP implementation.

·         Responsible for Planning, strategizing, executing and driving the entire Cutover Planning and strategy.

·         Responsible for formulating the Data Migration strategy for Business Partners, Vendor Master (Company Code, Purchasing and other views), Customer Master (Company Code, Sales Area and other views), Material Master, BOM, Cost Center, Profit Centers and other objects.

·         Responsible for leading the development of SAP BODS ETL jobs, workflows, dataflows and loading of data using IDOCs and LSMW.

·         Responsible for Data Provisioning into SAP HANA using SDA and other Data Provisioning methods.

·         Responsible for doing some configuration changes like number range updates, moving transports.

·         Responsible for development of reports, jobs and rules in SAP Information Steward IS.

·         Responsible for setup of SAP DQM Data Quality Management tool for address cleaning, deduping and matching and its integration with SAP ECC and SAP MDG.

·         Used SAP Data Services built in Functions to transform the data, created SAP Data Services Jobs scripts to automate data loads and variables with Parameters.

·         Developed SAP Data Services ETL, Informatica and SAP Information Steward jobs to pull data from applications hosted on Oracle, Microsoft SQL Server 2008, DB2 and load to the PSA using InfoPackages.

·         Providing expert level knowledge in creating Project Plans, Mapping documents, Data Load Plan, Mock Load Plans, SAP MDM, and Business Rules plan.

·         Responsible for creation and execution of Cutover plan. Working as Cutover manager for all the phases of Go-live.

·         Taking part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Responsible for Pre-Load and Post Load data validation and for creation and distribution of preload and post load reports related to legacy and SAP data.

  

Client: NTTDATA, Inc.                                                                                                    Jan’2013 to Aug’14

Role: SAP Data Migration Manager

SAP Cutover Manager

NTTDATA is sixth largest software company in the world. Project is to implement SAP in the entire NTTDATA Corporation comprising America, Canada and India geographical territories.

  

Responsibilities

·         Responsible for driving the entire data migration effort to migrate data from several legacy applications, Peoplesoft, and legacy SAP environments to new SAP implementation.

·         Responsible for Planning, strategizing, executing and driving the entire Cutover Planning and strategy.

·         Responsible for formulating the Data Migration strategy for SAP FICO, SAP HCM, SAP SD,SAP MM, SAP Project Systems, SAP BI and SAP HANA.

·         Responsible for the development of SAP BODS ETL jobs, workflows, dataflows and loading of data using IDOCs and LSMW.

·         Used SAP Data Services built in Functions to transform the data, created SAP Data Services Jobs scripts to automate data loads and variables with Parameters.

·         Responsible for doing some configuration changes like number range updates, moving transports.

·         Developed SAP Data Services ETL and SAP Information Steward jobs to pull data from applications hosted on Oracle, Microsoft SQL Server 2008 and load to the PSA using InfoPackages.

·         Providing expert level knowledge in creating Project Plans, Mapping documents, Data Load Plan, Mock Load Plans, SAP MDM, and Business Rules plan.

·         Responsible for creation and execution of Cutover plan. Working as Cutover manager for all the phases of Go-live.

·         Taking part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Responsible for Pre-Load and Post Load data validation and for creation and distribution of preload and post load reports related to legacy and SAP data.

 

Client: Amgen (Thousand Oaks, CA)                                                                                       Nov'2012 to Jan’2013

Role: SAP Data Migration Lead

Responsibilities

·         Providing expert level knowledge for conversion of complicated legacy and SAP Business Reports and guiding client managers in SAP implementation and configuration.

·         Providing expert level knowledge in creating Project Plans, Mapping documents, Data Load Plan, Mock Load Plans and Business Rules plan.

·         Creating Jobs, Work flows and Data Flows in SAP BODS, creating Source Tables, Target tables, refreshing tables with data loaded into SAP and performing basic DBA jobs.

·         Responsible for configuration, data migration and reporting from legacy applications to SAP for SAP BW/BI, SAP  FICO, SAP SRM, SAP SD, SAP MM modules.

·         Taking part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Liaising with client SAP team, users and Functional Consultants, and provided answers to their questions.

·         Responsible for creation and maintenance of Jobs, Data Flows and Source and Target tables in BODS. 

·         Creating and providing preload and post load reports related to legacy and SAP data.

·         Performing data refresh of SAP tables before Mocks and Integration Testing loads.

·         Solved defects assigned in Quality Center and provided detailed explanation for solutions.

 

Client: EPRI (Electric Power Research Institute, Palo Alto, CA)                     June'2012 to Oct'2012

Role: SAP Data Migration Lead

Responsibilities

·         Client requested to join this project as they were facing critical Data Migration and Data Validation issues and wanted an experienced consultant to guide them for Oct 2012 go-live date.

·         Worked in enterprise Data Migration project of various modules of SAP (Go live: Oct 2012) from legacy applications and older version of SAP.

·         Worked on the conceptual model of integrating SAP HANA with SAP BW/BI and creation of SAP HANA data mart.

·         Providing expert level knowledge for validation of data loaded and guide client managers in SAP implementation and configuration.

·         Created Jobs, Work flows and Data Flows in SAP BODS, creating Source Tables, Target tables, refreshing tables with data loaded into SAP and performing basic DBA jobs.

·         Responsible for configuration, data migration and reporting from legacy applications to SAP for SAP BW/BI, SAP Finance, SAP SD, SAP SRM, SAP MDM,  SAP HR, SAP Project Systems. 

·         Loaded data to SAP using SAP Business Objects Data Services BODS 4.0.

·         Used SAP Data Services built in Functions to transform the data, created SAP Data Services Jobs scripts to automate data loads and variables with Parameters.

·         Took part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Liaised with client SAP team, users and Functional Consultants, and provided answers to their questions.

·         Responsible for creation and maintenance of Jobs, Data Flows and Source and Target tables in BODS. 

·         Created and provided preload and post load reports related to legacy and SAP data.

·         Performed data refresh of SAP tables before Mocks and Integration Testing loads.

·         Solved defects assigned in Quality Center and provided detailed explanation for solutions.

  

BackOffice Associates, Boston, MA                                                                         Nov. '10 to Jun. '12

SAP Data Migration/ETL Consultant 

 Providing SAP consulting services for the following clients:         

Client: American Waters, Voorhees NJ                                                                   Jan'2012 to June'2012

Role: SAP Data Migration Consultant

Responsibilities 

 

·         Working on Business Transformation project related to the implementation of SAP to migrate data from Legacy systems and older versions of SAP to new one.

·         Responsible for configuration, data migration and reporting from legacy applications to SAP for SAP Finance, SAP SD, SAP P2P, SAP HR, SAP BW and SAP OTC modules and MDM.

·         Loaded data to SAP using SAP Business Objects Data Services BODS, DataStage, Informatica, BDCdirect and LSMW.

·         Took part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Liaised with client SAP team, users and Functional Consultants, and provided answers to their questions.

·         Responsible for creation of Targets, Sources, Rules and Reports in DataStagingWarehouse™ (DSW) and performed Data Audits.

·         Responsible for creation and maintenance of DataConstructionServer™ (DCS) WebApps. 

·         Created and provided preload and post load reports.

·         Performed routine DBA jobs and data refresh in DataGarage before Mocks and Integration Testing loads.

·         Solved defects assigned in Quality Center and provided detailed explanation for solutions.

·         Extensively used BackOffice Data Migration and ETL tools (i.e. EZMap™, DataStagingWarehouse™, DataGarage,CranPort™, DataConstructionServer™, dDup™, cApps™,cCust™, cMat™ and Cransoft

 

Client: Pfizer Inc., Collegeville PA                                                                                Dec'2010 to Jan'2012

Role: SAP Data Migration Consultant

Responsibilities 

·         Worked on SAP Data Migration project for the Vendors, SAP Finance, SAP BW, SAP PTP, SAP MM, SAP SD modules and MDM from legacy systems and older version of SAP.

·         Loaded data to SAP using SAP Business Objects Data Services BODS, Data Stage, Informatica, BDCdirect and LSMW.

·         Took part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.

·         Liaised with client SAP team, users and Functional Consultants, and provided answers to their questions.

·         Responsible for configuration, creation of Targets, Sources, Rules and Reports in Data Warehouse and performed Data Audits.

·         Responsible for creation and maintenance of Jobs and Data Flows. 

·         Created and provided preload and post load reports and performed routine DBA jobs.

·         Performed data refresh of SAP Tables and legacy Tables before Mocks and Integration Testing loads.

·         Solved defects assigned in Quality Center and provided detailed explanation for solutions.

·         Provided expert level knowledge related to various SAP modules to clients to guide them in Data migration process.

 

Client: Merck, Sharp & Dohme, Corp., Lebanon NJ                                           Nov'2010 to Dec'2010 

Role: SAP Data Migration Consultant

Responsibilities

·         Responsible for data analysis and data migration using BackOffice Associates tools and methodologies in a global SAP Implementation project.

·         Worked extensively on Vendors, Data Governance and Master Data Management MDM.

·         Involved in Data Mapping process using BackOffice Associates tool, EZMap™.

·         Worked on configuration, Data Extraction, Cleansing, and enforcement of data rules and identification of Business- Ready Data™.

·         Involved in Data Load of millions of records and in resolving various data issues using SAP Business Objects Data Services BODS, Informatica, BDCdirect and LSMW.

·         Provided in-depth analysis of key metrics and meaningful insight to other data management tasks.

·         Worked with Technical Team members from the client side as well as other BackOffice Associate team members.

·         Worked on improvement of training scripts created to simulate work flow of various SAP processes related to SAP Finance, SAP SD, SAP MM, MDM, SCM, SRM, OTC and Finance.

  

Client: JP Morgan Chase & Co., Columbus NJ                                                     Oct'2007 to Oct'2010

Role: Senior Business Analyst    

Responsibilities

·         Responsible for Data Analysis, Data Migration, Business Analysis and Project Management of a firm-wide cross-continental Data Migration project.

·         Involved in the configuration and data migration of more than one million corporate hardware and software items servicing over 2,000 users and Vendors.

·         Ensured accurate and timely availability of IT Asset information by verifying target data according to business rules and reporting requirements.

·         Created Data Mapping documents, Business Rules documents, Data Dictionary documents and Functional Requirement documents

·         Created complex SQL queries to pull data from various tables and compare data among various tables and performed routine DBA jobs.

·         Worked extensively in designing tables using Data Warehousing and in Data Governance and Master Data Management.

·         Involved in extensive Reporting and generation of automated scorecards using SAP BW, SAP Business Objects, SQL, MS Access, and Microsoft Excel.

·         Performed in-depth analysis of key metrics and data to provide meaningful insight and other data management tasks.

·         Conducted interviews with the clients located in US, UK and elsewhere for gathering requirements and for evaluation and analysis of their data.

·         Validated the system End-to-End Testing to meet the Approved Functional Requirements and Wrote and reviewed scenarios, test cases, and test scripts.

·         Participated in weekly meetings and discussed modification requests with the management team.

·         Worked extensively in designing RDBMS tables using normalization concepts and data warehousing.

 

Client: Cardinal Health, Inc. (CareFusion, Inc.), Dublin OH                                           May'2006 to Oct'2007

Role: Senior Business Analyst

Responsibilities

·         Conducted interviews with the clients for gathering requirements and evaluation and analysis of their data. Converted their business requirements into IT specifications.

·         Created Data Mapping documents, Business Rules documents, Data Dictionary documents, and Functional Requirement documents.

·         Managed a team of developers, determined feasibility of requirements, and developed project documentation for signoff.

·         Involved in the development and enhancement of jobs related to a Data Warehousing project that managed a large portion of Cardinal's Vendors, Financial and Sales data.

·         Coordinated daily, weekly, and monthly meetings with developers and project leads to keep track of development tasks in the onsite offshore model.

·         Involved in generation of reports once data was loaded onto the SAP servers.

·         Worked closely with Operations, Data Centre, and Unix DBA teams.

·         Worked with MS Visio to create detail workflow diagrams.

·         Worked in onsite-offshore model and led offshore team.

  

Client: Avaya, Inc., Denver CO                                                                                                   Aug'2003 to April'2006

Role: Business Analyst/Lead

Responsibilities

·         Created SRAD (System Requirement, Analysis, and Design) document after conducting JAD sessions with SMEs, Project sponsors, and client representatives.

·         Created DTP (Developer's Test Plan) after discussion with developers and executed test cases.

·         Created Data Mapping documents, Data Dictionary documents and Business Rules documents.

·         Worked as a developer and was involved in coding, bug fixing, and enhancement of software and database related to call records and subscriber's information.

·         Coordinated daily, weekly and monthly meetings with developers and project leads to keep track of development tasks in the onsite offshore model.

·         Developed training schedule and technical documents for new team members, as well as a training website.

  

Client: HCL Perot Systems, Dallas TX                                                                         June-2002 to Sep'2002 

Role: SAP BW Analyst (Intern)

Responsibilities

·         Conducted interviews with clients located in US, UK and elsewhere for gathering requirements and for evaluation and analysis of their data. Converted the business requirements into IT specifications.

·         Developed cube design documents to establish relationships between dimension tables and fact table.

·         Involved in Data Migration, Data Governance and Master Data Management.

·         Involved in creation of Universes using Universe Designer based on Business Requirements; also worked on CMC for administration.

·         Documented the business content Queries, ODS, and Cubes required for reporting.

·         Worked extensively on Administrator Bench and configured and created update rules, transfer rules.

·         Involved in the generation of reports in SAP BI 3.0 and Business Objects and by creating complex SQL queries.

·         Prepared weekly and monthly status reports and presented reports to higher project management and client teams.

  

Education  

1.       Big Data certificate course titled: “Tackling the Challenges of Big Data”, from Massachusetts Institute of Technology (MIT)

2.       Management Certificate from Fisher College of Business, The Ohio State University

3.       B.S. in Computer Science Engineering (80.4% among the top three Students in Computer Science Engineering Department)  

 

Professional Trainings  

1.       Certified in BackOffice Associates Data Migration and ETL Tools: Data StagingWarehouse™,DataGarage,EZMap™, DataDialysis, BDCdirect, DataProfiler™, DataConstructionServer™,dDup™, SourceTrack™, CranPort™, cApps™, cCust™, cMat™

2.       PMP training from Project Management Institute

3.       Six Sigma Green Belt and CMM training in Wipro Ltd. ($5 Billion Software major. Joined Wipro Technologies through campus selection interview after B.E.)

4.       FMP (Future Managers Program) Certified: 6 months training in Wipro Ltd.

 

Professional Memberships  

1.       Member of Project Management Institute and PMI Central Ohio Chapter

2.