SUMMARY:

• SAP Data Migration Consultant/BODS Developer with strong ETL background and SAP ERP techno - functional having around 9 years of professional experience.
• Experience in Data Migrations/Conversions for SAP modules SD, PP, PM, FI, CO, MM and QM in SAP ECC and S/4 HANA 1809/1909.
• Experience as Sap Data Services (BODS) Developer in SAP Data Migrations/Conversions.
• Around 7 years strong SAP Data Migration experience of working in 11 Rollout Projects, 5 mini projects involving implementing new solutions, merger and carve-outs.
• Experience in leading the FI/CO, SD, PP and PM module data migrations.
• Experience of participation in Data migration workshops to capture specification in Data Mapping documents.
• Strong Knowledge on SAP LSMW (Legacy System Migration Workbench), IDOCs, BAPI.
• Experience in using SAP Migration Cockpit LTMC (Legacy Transfer Migration Cockpit) to load data using standard objects.
• Experience in customizing templates using LTMOM.
• Proficient in using Data Services for design, creation, and implementation of BODS Jobs by validating logic in Data mapping documents.
• Advanced Proficiency in Microsoft Excel performing Data Analysis and Data Validations.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Implemented Data Cleansing, Transformation Scripts to ensure successful execution of data loading processes.
• Experience in using Address Cleansing transformations in SAP Data Services.
• Experience with both Microsoft SQL server and Oracle with good SQL querying skills.
• Experience in using Information Steward Data Insights, Metapedia (Terms and Categories) and Metadata Management.
• Experience in handling Brownfield migration tasks of ECC to S/4 Hana.
• Conducting Blueprint/Data Migration workshops, requirements gathering, gap analysis, custom object development, data loading, unit testing, integration testing and go-live strategies.
• Good Experience in working parallel on multiple Rollout projects and support on time.
• Ability to work in any SAP module involving Master Data and Transactional data Loads.
• Ability to interact with managers and technical personnel, self-motivated, quick learner, excellent team player with strong interpersonal and communication skills.
• Ability to interact with functional team and work with Onsite/Offshore development teams while validating the technical specifications.
• Experience in debug, optimizing the ETL jobs to increase the performance.
• Provided Hypercare support for Post Go-Live Data Migration Issues.

TECHNICAL SKILLS:

ERP Application: SAP ECC, SAP S/4 Hana On Premise 1709/1809 (HEC)

SAP DM Applications: SAP Data Services (BODS), SAP Information Steward

Databases: Microsoft SQL Server, Oracle11g/10g

Development: ABAP, C, C++, JAVA, SQL

Client Scripting: JavaScript, CSS, HTML5

Server Scripting: Servlets 3.0, JSP 2.3

IDE s: Eclipse 4.3, NetBeans, Visual Studio

Framework s: Apache Struts, Spring, Sencha Touch, Apache Spark (Big Data)

Other Tools: MS Office (Word, Excel, Outlook, PowerPoint), Rational Rose Argo UML, Git Hub, Bitbucket, Pivotal Tracker, Microsoft Visio

WORK EXPERIENCE:

SAP Analyst (Data Migration)

Confidential, Northville, MI

Responsibilities:

• Handled Data Migration of PM, PP, SD, MM, FI and CO module related objects.
• Worked with the GLOBAL Data Management team while defining the Data Governance rules.
• Analyze and develop the load data migration programs in LTMC (Legacy Transfer Migration Cockpit) for Business Partners.
• Worked with key stakeholders in data profiling and data clean-up activities.
• Developed SQVI reports object wise for extract and Post Load reports.
• Extensively used BODS, LSMW, IDOC, BAPI to complete Data loads.
• Developed custom LTMOM objects to Reclassify the products - commodity codes.
• Designed Mapping sheets for all PM objects (Equipment Master, Functional Location, General Task List, Equipment BOM, Equipment Task List, Functional BOM, Functional Task List, Maintenance Plan and Items based on business requirements.
• Worked with Master Data Management teams in defining strategies to improve/ensure data quality
• Develop and validate Post-load reports for all modules for business sign-off.
• Designed and developed load programs to load all PM Objects using LSMW, LTMC.
• Handled Business Partner (Customer and supplier), CMIR, Cost Centers, Internal Orders, G/L Account, Source List, Fixed Assets, FI Transactions through LTMC.
• Experienced in LTMC migration objects debugging through LTMOM to fix conversion and load errors.
• Analyzed the Customer/Vendor data for smooth CVI of Business Partners
• Involved in Data correction of all mock loads based on CVI errors to support the migration.
• Identify the new functionalities in HEC and support the business in modifying the data such as Production versions update.
• Improved the performance of data load jobs to help business in reducing the downtime.
• Develop job to extend Credit Management for unmigrated customers.
• Analyze and develop report of mismatch commodity codes across all the regions and help business in cleaning up the data through LSMW.
• Migration of Data from Legacy Systems (non-SAP & SAP) to SAP ERP Application.
• Provided Functional Mapping Specs defining extraction, transformation and loading rules in align with target system and business requirements.
• Developed ETL Jobs to read data from Excel files and load into ECC thru IDOC, BAPI, LSMW.
• Analyzed Pre-Load reports to make sure data transformed as per mapping sheets before loading into SAP.
• Designed technical strategy in automating the complex transformation logics.
• Developed technical post-load reports using SQVI for business analysis on loaded data.
• Worked on improving the existing programs performance based on lessons learned in unit cycles to reduce load times.
• Worked on migrating SD, MM and FI modules data from Legacy SAP to SAP.
• Involved in successful re-creation of SSAs based on new developments.
• Loaded all active demand from old Customer Scheduling agreement (SSA) to newly created SSAs with the help of new Recording LSMWs.
• Correction of Cumulative Quantities thru LSMW job in SSAs based on extract.
• Performed tweaks to LSMW code to handle complex recordings.
• Involved in testing the newly modified ISM value configurations thru BAPI and provided test results to core configuration team for bug fixes
• Analysis to business on custom table to fix the duplicate values updated by third party interface and ABAP program.
• Coordinated with business for maintenance of customer master data to avoid issues in dependent objects
• Extensive Extract and Post Load validation of packing instructions and determinations to achieve smooth go-live.
• Active participation in defining prechecks between objects to forecast the errors in extract.
• Maintenance of Post Load Error catalog for developing new pre-checks which could decrease the duration of data migration cycles.
• Worked with business to control duplicate data in Customer Material Info Record (CMIR) Loads.
• Coordination with technical team to ensure the loading of old, current and future sales pricing conditions.
• Supported all LSMW tasks related to Data Migration during load cycle and Post Go-Live.
• Development of automated jobs to extract the data from SAP, transform and Load into SAP based on business requirements.
• Provided Hypercare (Go-Live) support in dynamic data fixes.
• Export/Import of all newly developed LSMWs into the new client before the start of Load cycle.

SAP Data Analyst

Confidential, Auburn, IN

Responsibilities:

• Worked with SD, MM, PP and FI Functional teams in migrating Data from Legacy systems such as Vanguard, Visual Enterprise systems to SAP.
• Monitored DM activities in Daily status sheet and reported to PMO team.
• Follow up with the team to work on errors in Pre-Load/Post-Load reports.
• Developed SQL scripts in transforming the Legacy data according to Business rules.
• Involved in Mapping workshops with Business to gather requirements.
• Validated every object Data load by using rules defined by core defendant Team.
• Extracts Cleansing and Validations based on System and Business Requirements
• Involved in Profiling data and data metrics maintenance based on extract analysis.
• Implemented the Data Quality checks at Pre-Data Migration level.
• Analyzed and Fixing the Post-Load errors thru LSMW.
• Participated in status calls and providing status to Leadership team.
• Provided Functional Mappings specs to technical team for developments.
• Performed Unit Testing on Pre-Load reports and providing the feedback to technical team.
• Handed all modules Post-Migration support with the help of LSMW.
• Maintained the required DM configuration checks in the cutover and maintained follow-ups with the functional team.
• Worked with EDI team for automation of Customer data report for EDI configurations.
• Developed LSMWs to load EDI related data for the T-codes OVAI, OVA9 and PUMA.
• Performed balance validations in FI open transactions loads such as Open AP, Open AR, Open GL.
• Co-ordinated to extract the data from SAP tables using SQVI queries and used the custom ABAP programs for the complex extracts programs.
• Handled all month end Loads such as inventory and open balances.

Data Analyst

Confidential, Auburn, IN

Responsibilities:

• Developed BODS Jobs and LSMW Projects to support Data loads.
• Acted as SPOC for all Data Migration activities.
• Developed BODS automated job for SAP extract and conversion to reduce the manual work which helped in exceeding the business expectation.
• Executed the Proof of Concepts (POC) for the new scenarios.
• Gathered all Data mapping requirements and designed Mapping specifications.
• Developed BODS Job to Load Customer and Material Extensions thru IDOCs.
• Complete involvement in handling Customer Partner Links from Extract analysis to Post Load Analysis.
• Designed Pre-load Valid and invalid reports through BODS jobs to provide Business to Validate the data.
• Involved in Profiling data using Data insight in Information steward.
• Involved in writing DS scripts and used some built-in functions like Search, Replace, Lookup Ext and Custom Functions whenever an exception is raised.
• Designed BODS Job to handle changes in Customer Partners using Change Data Capture (CDC) transforms.
• Involved in Loading FI and CO objects such as Bank Master, Chart of Accounts, Cost Centers, Activity Prices, Internal Orders and Credit Management using LSMW.
• Performance tuning of Post Load Report Jobs.
• Reload of existing Sales Orders to support new enhancements.
• Provided Support for all tickets related to Data Migration activities.

SAP Data Services Developer

Confidential, Hercules, CA

Responsibilities:

• Worked with MDM, OTC, P2P and RTR Teams on developing SAP Data Services ETL Jobs.
• Worked on the Materials, Customers and the corresponding dependent objects Sales Order, Service Plans, Quantity Contracts and Fixed assets data loads by using IDOCs thru SAP DS.
• Handled data loads for QM objects such as Work centers, Inspection Method, Master Inspection characteristics and Inspection Plans.
• Handled data loads for PM Objects such as Equipment Master, Functional Location and Maintenance Task Lists.
• Worked with BackOffice team and designed/modified Extract/IDOC Loader jobs according to their requirements.
• Worked with Functional Teams to Cleanse Customer Address Data.
• Proposed use of ABAP Data flows and implemented in Extract jobs from SAP system to improve Performance.
• Worked on Address cleanse and Data Cleanse Transforms for Cleansing US, Europe and Global Data.
• Designed Plans and proposed business to deal with inconsistent Address Data.
• Built custom functions to Cleanse Complex Data and handling complex Transformations
• Developed Jobs to cleanse data from both SAP and Non-SAP Systems.
• Worked on Mapping in DSMA - Data Service Migration Accelerator (BackOffice Tool).
• Worked on Extracting Long Text for Sales Orders, Purchase Orders and Customer Info Records.
• Involved in Training Business on Data Services Management console to execute IDOC Loader Jobs.
• Created user guidance documents for business to work on Data services console.
• Tested all the BODS ETL Jobs in DEV environment by loading sample data, validated and fixed the defects.
• Created different BODS repositories and manage the security for different user level.
• Involved in resolving configuration issues for ABAP Data Flow Execute upload to generate Transport Request in respective client system.
• Designed Batch jobs using BODS features like Query, Merge, Row Generation, Validation, Key Generation, SQL and Table Comparison.
• Extensively used Lookup Ext functions in Data Services to pull data from Source X-Ref Tables.
• Developed jobs with standard IDOC's for transformation of SAP extracted data and loading into SAP with status 64.
• Generated IDOCs thru SAP DS for Material Master, Vendor Master, Customer Masters and BOMs, ROUTINGs, PCON, PIR, PSA, SSA and Inventory.
• Created Metapedia Terms and categories for SD, PP, FI objects in information steward.
• Involved in analyzing data quality, data profiling (column, redundancy) using information steward.
• Validated and tested the IDOCs by using the T-codes: WE05/WE09 & WE19.
• Involved in setting up Data Stores for SAP and Non-SAP systems such as Oracle, Microsoft SQL Server.
• Worked on IDOC segment inconsistency in Job level for better understanding of Pre-Load reports and avoid errors in IDOC executions.
• Deployed all the BODS ETL Jobs from DEV to PRD after testing all the Jobs with the provided test scripts.
• Maintained the Data Migration functional specs (Excel) with the updated field mapping and transformation rules.
• Created the LSMWs recordings based on the requirements and SAP QUERIES for Business (Key Users) validation and maintained all Training documentation for Key user purpose.
• Used MS Excel (VLOOKUPS / ADVANCED Filters) & MS Access (SQL Queries) to change the Data File Formats and prepared the ERROR LOGS.
• Provided the support in all levels while doing the MOCK Migrations including cutover level.
• Involved in testing cycles (Integration Testing / UAT) throughout the Data migration.

Graduate Research/Teaching Assistant

Confidential

Responsibilities:

• Assisted Dr. Jin Soung Yoo for two semesters in her Research work.
• Learned Apache Spark, a Big Data technology faster than Hadoop and implemented Moran’s Law using it. Documented complete Project to help future research students.
• Other activities include grading assignments and tutoring.
• Conducted Help sessions with undergraduate students individually and in small groups.
• Supervised CS 160 - Introduction to Computer Science lab for undergraduate students under the guidance of Dr. Gyorgy Petruska in final semester.
• Provided tutoring sessions for Undergraduate students.
• Activities include grading assignments and helping undergraduates in the lab assignments and projects.

Assistant System Engineer

Confidential

Responsibilities:

• Configuration, Development, Workflow design, Process design, Analysis, Quality assurance and Administration.
• Working on SAP ERP application modules SD, MM, HR and FI and supporting business users in data and other process related issues.
• Managing SAP Basis administration activities and ABAP Programming code deployments includes LSMW, IDOC, BAPI, Roles across the SAP ECC and SAP BW system landscape.
• Responsible for Supporting, training the business users in SAP roles and access issues as part of SAP GRC (Governance, Risk and Compliance) team.
• Designed and Developed ETL (Extract, Transform, Load) Jobs in SAP BODS, LSMW Jobs to load data from legacy ERP systems, SQL Server to SAP ECC.