SUMMARY:

• Confidential is an enthusiastic team leader and player, a dynamic individual having Nineteen years Consulting and Project Implementation Experience (Project Management and Technical) with a primary focus on Data Integrations, Migrations and Conversions with SAP Data Quality Management of Legacy Data into SAP using SAP Data Services with Best Practices.
• Confidential has extensive experience in the migration of the Legacy Data into SAP ECC and S4HANA, Extraction and Loading of the SAP Data (using SAP Extractors/Application Tables) and Legacy Data into SAP BW, Extraction of the Data from SAP BW (Open Hubs) into Analytical Data Warehouses and Design of the ETL / ELT Framework for Population of Analytical Data Warehouses using SAP Data Services.
• Also has extensive experience on the Complete BI Project Life Cycle - Analysis, design, development, testing, and implementation of Enterprise Data Warehouses, Data Marts with Data Modeling, Analytical & Transactional Reporting, and Master Data Management. Confidential has strong analytical and project management skills and has experience in executing large projects with waterfall and Agile methodologies.
• Confidential also has good coordination & organizing abilities, excellent communication and presentation skills, believes in conviction and teamwork, and has 10 Years of Experience in Setting up, Leading & Executing large projects in on site / off shore / near shore models in a Multi-Vendor Teams in a Distributed Environment. Confidential has an expertise in recovering and executing troubled and complex off shore projects. Confidential seeks a suitable opportunity as a SAP S4HANA Data Migration Leader / Data Integration Architect in a challenging environment.

TECHNICAL SKILLS:

Data Conversion / Integration Tools: SAP Data Services 4.2 / 3.x, TalenD, DataStage 7.x, Informatica 6.x, SSIS

Data Quality: SAP Data Services 4.2/3.x, SAP Information Steward, SAP Data Quality Management

Big Data Analytics: SAP HANA, Hadoop

Master Data Management: SAP MDM 7.1/5.5

Enterprise Planning: Cognos Planning 8.x (Analyst, Contributor & Manager), Logility Demand Planning.

Business Intelligence: Cognos 8.x, Cognos 7.x, MS Analysis Services, SAP BW, TIBCO SpotFire 5.5, Jodex 5.0

Reporting Tools: Business Objects XI R1/XI R2/V3.1, Xcelcius, Cognos 8.x - Report Studio, Query Studio, Cognos 7.x, KPI Business Packs, Crystal Enterprise 9.5 & Oracle D2k Reports.

Databases and Modelling: Teradata, Oracle, SQL Server 2008, ER Studio, MS Visio, and Erwin..

PROFESSIONAL EXPERIENCE:

Confidential, Wauwatosa, WI

Sr. SAP Data Migration Leader

• Responsible for the design and development of the Data Migration Framework for the migration of the Data from Legacy SAP into S4HANA.
• Lead the Data Migration Team for the design and development of the Data Services extraction jobs for the extraction of the Data from the Legacy SAP and other Legacy system and application of the Relevancy Rules
• Performance Tuning of the Legacy Data Extraction Jobs for Optimal Performance to ensure that the Data is extracted within the SLA in the Cutover.
• Lead the Data Migration Team for the design and development of the Data Services Jobs with Relevancy Rules and create a data set with active records for the Master Data Objects.
• Profiling of the Legacy SAP Data and Conducted the Legacy workshops with the Business and the Functional Team.
• Assisted the functional teams with the mapping documents for the conversion objects.
• Actively involved in the design of the system architecture for Data Migration landscape with the Client, SAP and hosting provider (IBM).
• As a part of the Data Migration Framework, designed the reports on the Inactive records, Invalid Records, Pre-load and Post-Load Reports to provide the visibility and accountability to the business at every phase.
• Designed and Developed the Fit for Use Metrics for the Conversion Objects and Present to the Leadership on the Quality of the Data at each Mock.
• Leading the Team for the design and development of the OTC, STP & R2R Conversion Objects like Customer Master, CMIR, Credit Master, Output Types, Material Determination, Vendor Master, PIR, Source Lists, Open Sales Orders, Open Purchase Orders and AR/AP.
• Worked with the Functional and Master Record Owners on the Pre-Load and Post-Load Approvals for each Load.
• Mentor the Team Members on the data migration and ensure that the team adheres to the Data Migration Framework.
• Loading of the Legacy Data into S4HANA for various Mocks and ensured that the Fit for Use Data always exceeded the Target Goals.
• Worked with the Business and Functional Users to fix the Legacy Data based on the Invalid Reports.
• Reported to the Functional and the Business Users on the Good Row, Good Data and Fit for Use Metrics for each RICEF Objects.
• Worked as a Liaison between the Data Migration Team and the Infrastructure Hosting Provider(IBM).

Confidential,Decatur, IN

SAP Data Migration Consultant

• Profiling of the Legacy Data in JDE and Siebel for Critical Master Data Objects like Customers, Vendors, Vehicles, Routings and Transactional Data for Sales Orders and Purchase Orders.
• Conducted the Legacy Workshops with the Business Analysts, SAP Functional Team and Business users to complete the Mapping Documents, Extraction and Conversion Rules for the Data Migration.
• Design and Development of the SAP Data Services Jobs for the Migration of the Legacy Data for Customers, Vendors, Vehicles, Routings, Pricing Conditions, and Purchase Orders.
• Analyzed the available BPDM Jobs (RDS), de-bugged the Issue and suggest the alternate loading methods for loading the Legacy Data into S4HANA.
• Data Standardization and Harmonization of the Customer and Vendors and de-duplication of the Data.
• Preparation of the Run Books for Loading the Data and peer review of the Documents.
• Worked closely with the Offshore Team for the on time delivery of the Conversion Objects.
• Migration of the Legacy JDE and Siebel Data into S4HANA system in various Mock Loads.
• Validation of the migrated Data with the Functional Team and Business Users.

Confidential, Falls Church, VA

SAP Data Migration Consultant

• Profiling of the Legacy Data for Ship to Delivery Addresses, Vendors, Functional Locations, Equipment, Contracts, Purchase Orders and Customers
• Conducted the Legacy Workshops to understand the requirements for the Conversion of the Legacy Data into SAP.
• Worked with the SAP Functional and Legacy Users to Create the Mapping Documents and Conversions Specifications for the Migration of the Legacy Data into SAP.
• Design and Development of SAP Data Services Jobs for Ship To Addresses, Vendor, Customers Functional Locations, Equipment, Internal & Capital Projects and Purchase Orders following the SAP best practices for Data Migration and the BPDM Framework...
• Responsible for fixing the Defects and Development based on the Change requests for Ship To Addresses, Vendor, Customers, Functional Locations, Equipment, Contracts, Capital Projects and Purchase Orders.
• Responsible for Loading the Data into the New SAP Systems for Various Mocks.
• Worked with the SME of the Legacy Systems to get the Legacy Data Corrected in the Legacy Systems based on the Profiling of the Data and monitor the quality improvements..
• Responsible to Create the Data Quality Metrics to the Leadership Team to demonstrate the Improvement in the Data Quality by Mock Loads.
• As a SME for SAP Data Services and Data Quality, Suggested Number of Improvements that needs to be incorporated so that Data Quality can be maintained while converting the Global Data in subsequent Waves.
• As a SME, Trained the SAP Data Services Developers in the Team on the Best Practices to be followed so that the BODS Code is Scalable and easy to Maintain.
• Analyzed and Customized the real time jobs based on the FLDQ Logic and Customer requirements
• Responsible for the Peer Review of the Code and ensure that the Best Practices were Maintained.
• Responsible for the Testing of the SAP Data Services Jobs for Ship To Addresses, Vendor, Customers, Functional Locations, Equipment, Contracts, Capital Projects and Purchase Orders.
• Customization of the Real Time DQM for SAP Jobs based on the specific needs of the Client.

Confidential, Mundelein, IL

SAP Data Services Lead & Architect

• Analyzed the Existing SAP Data Services Landscape and suggested the Changes so that it adheres to the SAP Best Practices.
• Analyze the Requirements for Distribution and Marketing Divisions of Medline for Implementing the SAP Data Services - Data Quality. .
• Work with the Business SME to identify the Key Elements in the List Files sourced from External Vendors.
• As a SME of SAP Data Services, Lead the Data Services Offshore Team of Medline in various projects,
• Design and Development of the Data Services Jobs to Cleanse the Customer Address Data from the External List Files and Match them against the Existing Medline Customers in SAP.
• Design and Development of the Data Services Jobs to Cleanse the Customer Address Data from the External List Files that do not exists in Medline SAP and Match them against the Existing Medline CRM Customers in MS SQL Dynamics to create the Prospects in CRM.
• Assign the Percentage Match for the Customer Addresses in the External List Files for the Business to take Corrective Action.
• Analyze the Existing Data Services Jobs to Improve the Performance and implemented the required changes.
• Created the Custom Packages in SAP Information Steward to standardize the Product Data for Medline.
• Customized the Existing Real Time Jobs for Address Cleansing, Matching and Suggestions based on the Business Requirements.
• Worked with the Medline - India offshore team for the development of the required Interface screens in SAP for the Data upload, download and preview.
• Liaison with the Business SME’s for any Potential enhancements to the existing Data Services Jobs.
• Work on Multiple Assignments concurrently, Co-ordinate the Design and Development efforts across assignments and handle Interdependencies.
• Designed and Developed the Data Services Jobs to Cleanse, De-Dup and Load the Data into SAP using iDocs and BAPI’s.
• Train the Client Personal on the SAP Data Services - Data Quality for the solution support by the Run and Maintain Team.

Confidential, Marlborough, MA

SAP Data Services Lead / SAP HANA Modeler

• Analyze the Requirements for the Enterprise Performance Management Scorecards of Confidential .
• Work with the Business SME to identify the Various Sources of Data.
• Profiling of the Source Data and identify the Gaps if any
• Conduct the Workshops with the Source SME’s to identify the Data Elements required and the Business Rules to derive the KPI’s in the Scorecards.
• Design the ETL Framework for the Data Services Jobs (Landing, Staging, Harmonization, Validation, Enrichment and Load) to Load the Dimensional and the Factual Data from Hyperion into SAP HANA.
• Creation of the Source to Target Mapping Documents with the Business Rules for the ETL Team for Developing the Jobs.
• Development of the Data Services Jobs to Load the Dimensions and the Facts Tables with the various stages into SAP HANA
• Worked closely with the SAP HANA Architect and designed the Dimensional and Fact Tables in SAP HANA and Loaded the HANA Tables using Data Services.
• Creation of the Attribute Views, Analytical Views, Calculation Views & Restricted Measures in SAP HANA to make the Data Suitable for the Reporting.
• Creation of the Test Cases for the Unit and System Testing for the ETL.Jobs.
• Worked the SAP Data Services Team of 3 in Onsite/Off Shore Model.