Professional Summary

• Over all 10 years of SAP Data Migration experience and have been a DM Lead for several projects for past 7 years.
• Over Seven years of development experience SAP BODS - Data Services
• Worked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment, LSMW, BDC, BAPI IDocs.
• Configured and installed SAP BODS, Job Server, Central and Local repositories.
• Experienced in different SAP BODS BPDMs, Transforms Functions.
• Proficient in creating Jobs, Workflows, Dataflows, Query and other Transforms in SAP Data Services
• Excellent in implementing and testing of Stored Procedures, Views, Packages, Database triggers, cursors and functions at database level.

Core Competencies Expertise

SAP Data Migration Lead

Professional Experience

Confidential

• Configured and trained junior consultants in several applications in CranSoft for optimal performance as well as SAP Tools such as BODS and Information Steward.
• Created rules for several fields including zRelevant, zSource, and zLoaded zInSAP .
• Created several WebApps to accommodate data construction for many objects.
• Expert in creating DTS and SSIS packages in SQL Server.
• Worked extensively with several SAP Transactions in FICO.
• Created Target Export to be used by BDC and LSMW in SAP ECC 6.0.
• Worked with DataGarage to manage the Legacy sources.
• Created Remediation rules at target level.
• Created target and source rules and validation reports for multiple sources for all assigned objects.
• Created Hierarchies for Profit Center, Cost Center, Statistical Key Figures, Cost Elements, Activity Types, and Account Groups SETHEADER, SETHEADERT, SETNODE SETLEAF .
• Used several BackOffice functions to modify data.
• Expert in SQL Server 2005/2008.
• Worked in creating Profit Center, Cost Centers, Cost Elements, Activity Types, Statistical Key Figures, and Internal Orders.
• Expert in BDC and LSMW.
• Worked extensively with EZMap , CranSoft DataConstructionServer WebApp development , BackOffice Data StagingWarehouse DSW , and BDCdirect .
• Developed ETL jobs, Work Flows, Data Flows and other Data Services components.
• Designed and developed ETL solutions using SAP Data Services as well as Cransoft.
• Expert in CranSoft tools and security.
• Proficient in LSMW, IDOC, ALE, BAPI, batch input, direct input, SQL Views, MS Access Excel.
• Provided guidance to PM in grasping data migration concept and processes.
• Provided immediate support / guidance for bug fixes or data issues.
• Able to design any LSMW loaders with full consistencies checked.
• Designed and developed data conversion programs using conventional LSMW, BDC and IDocs.
• In depth and hands-on development experience of using SAP BODS 4.1, LSMW, BDC IDocs across all areas of SAP FI, SD, MM, PP, QM and PM
• Migrated legacy system to SAP ECC 6.0 and SAP MDG platform for master and transactional data.
• Capable of overcoming any project delays, apply proper strategies to ensure the project schedules are on track.
• Capable of managing unstructured data team to a professional high performance data team.
• Developed cutover plan
• SAP Data Migration Lead Confidential
• Worked extensively with SQL Server 2008, SSIS Packages, Stored Procedures, and Views.
• Provided business and junior consultants with knowledge of Data Profiling Information Steward , Sourcing, Cleansing, Construction, Migration, Transformation and Reporting Cransoft and SAP Data Services .
• Conducted meetings with Business, Functional consultants and Legacy experts for data mapping sessions.
• Implementing the business rules, validations and restructuring the data into target SAP.
• Used various De-duplication techniques Data Quality Transforms and other logics.
• Expert at Information Steward for Data Profiling.
• Initial data loads and data migrations from Legacy to SAP MDG systems
• Provide the business and IT users with the pre-load and post validation reports after validation on source data and transformation.
• Creating jobs using SAP Data Services to extract and transform data from the source systems to the target SAP.
• Migrated data for IS OIL PRA , Joint Ventures, Base DOI, Business Associates, Valuation, Delivery Networks and Well Data.
• Designed and developed ETL solutions for SAP PRA IS OIL using SAP Data Services as well as Cransoft.
• Experience in Setup and maintenance of Production Allocation networks pertaining to operated facilities in North American upstream Oil Gas PRA customers.
• Implemented SAP PRA MMS 2014 software. Instrumental in ensuring that the software worked properly and was compliant with the MMS regulations.
• Knowledge of Finance, Contractual Allocation and Sales and Balancing modules of SAP PRA.
• Worked on design and configuration of revenue recognition and development of revenue recognition custom program integrated with SD.
• Experience in configuring PRA module business processes of Production Allocation, Regulatory Reporting, Ownership, Tax and Royalty Reporting.
• Over two plus years of experience in working on SAP's Oil and Gas industry solution in the upstream area which consists of PRA and JVA modules.
• Gathered business requirements from key stakeholders and translate them to a comprehensive data solution design.
• Confidential Sr. SAP PRA Techno-Functional Consultant
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for master data, and the calculation views as the final model in SAP HANA studio.
• Gathered and analyzed the requirements to replicate the ECC content in HANA using Data Provisioning.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, and hierarchies.
• Works with project managers, SAP's offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
• Migrated code from Local/Central repository to different environment repository.
• Responsible for developing complex SAP Data Services Data flows / Workflows using different types of transforms like Query transform, Table compare transform, Case transform, Map operation, Merge, History preserve and key generation transform based on the business requirements.
• Resolves technical issues and implement code modification needed to support changing user requirements for multiple data services jobs.
• Utilizes Rapid Deployment Solution, BPDMs and customized Jobs to migrate data with SAP Data Services for following items: Purchase Orders, DMS, Inventory, PIRs, Misc. PRTs, Batch Master, Work Centers, EWM Stock Transfer, Product Master, Storage Bins, and Inspection Rules.
• Works with Information Steward to profile legacy data.
• Gathers business requirements from key stakeholders and translate them to a comprehensive data solution design.
• Responsible for performing Industry and process-oriented MDM/MDG consulting for key customers.
• Responsible for coordinating with various teams and resolving any incidents/requests/issues related to SAP MDG. SAP MDG Implementation and support including Data modeling, Process modeling, UI Configuration Data Replication techniques.
• Responsible for full Migration cycle of objects across modules including SAP technical and Functional assistance on the project.
• Builds ETL architecture and helps junior developers with best practices for data conversion.
• Provides guidance and advice on SAP Data Migration methodology.
• Provides weekly update reports and measured the data KPI.
• Advises and assists in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Drive data migration strategy and process to enable quality data delivery without delays.
• Escalates cross functional issues and identified SMEs required for resolution.
• Proactively identifies project risks and created feasible solutions.
• Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data. Developed data migration approach and strategies. Provides guidance to internal IT key users to design and develop data loaders / templates to fit the business requirements. Developed validation programs to cross check all the data before and after the data loading. Identifies problematic areas and conducts research to determine the best course of action to correct data.

Confidential

SAP Data Migration Lead

• Migrated all customer master objects from R3 into ECC including, Customer Contacts, Sales Information, Loading Points, Tax Grouping, Tax Indicator, Bank Details, Partner Functions, Shipping Data and Sales Data.
• Utilized SAP Data Services as an ETL tool for various objects.
• Conducted several meetings with clients to help them formulate conversion rules for each field.
• Used LSMW as the standard data loading method.
• Created complete set of rules for the objects where EZMap was not used.
• Utilized EZMap 5.3.1 extensively to generate automated rules and modified the complex ones as well as created several target level rules.
• Researched to find out the errors in customer master configuration.
• Created reports for customer address cleansing, including de-duplication, finding inconsistencies between addresses.
• Created several Web-apps to support client in their data cleansing activities.
• Created many Cranport packages for movement of data.
• Optimized DataGarage for automation and ease of use.

Confidential

SAP Data Migration Lead

• Created views and Stored Procedures, as well as other BackOffice Functions in SQL Server 2005 for many different Rules and Validation reports.
• Worked extensively with BackOffice Data StagingWarehouse DSW , DataGarage , BDCdirect , and LSMW.
• Scheduled batch process to run on weekly basis.
• Created detailed documentation with extensive data analysis for every procedure to help client better manage their data.
• Imported tables from the legacy to the source in DataGarage .
• Created all validation reports for General Ledger, Accounts Payable, and Accounts Receivable.
• Provided expertise in testing the training server, Software, and Training documentation.
• Expert in SQL Server 2008, New CranSoft Tool 4.5, CranPort , SSIS Packages to replace DTS packages , Stored Procedures, and editing DTS Packages in SQL Server 2008.
• Involved in every aspect of Data Conversion from start to Go-Live.
• Implemented/supported Data Cleansing activities to reduce data redundancy.
• Data Construction activities to make sure data is SAP ready and consistent with the requirements.
• Worked extensively with CranSoft and SAP.
• Expert in AdeptSQL for CranSoft instance replication.
• Managed Vendor / Quality / APO / CRM objects for data conversion.
• P2P - Extensively worked with P2P objects PIR, Vendor Contracts, Quality Info Records, Master Inspection Characteristics, etc. .
• Worked with SAP Data Services in conjunction with DSW.
• BW/BI Sales History and Obligation data conversion lead
• SCM APO Extensive knowledge of Supply Chain SCM and Advanced Planner and Optimizer APO including Location Master, Product Master, Transportation Lanes, and Product Interchangeability.
• Monitored Core Interface CIF process that replicates Materials and PIRs into APO.
• Inherited other objects including Contact information for complete overhaul and revamp of all sources, targets, rules, and reports.
• Worked with SD Objects, loading Sysco Contacts into CRM and replicating over to ECC.
• Worked with Functional team to update and finalize Functional Specs.
• Led high level meetings to accomplish tasks and derive resolutions.
• Performed CranSoft Toolset training for BackOffice employees and clients.
• Worked with DataFactory associates to bring them up to speed with team objectives.
• Communicated / created messages with SAP to resolve issues related to APO Transportation Lanes.
• Created many Super Sources to accommodate for multiple companies with similar data structure.
• Worked extensively with EZMap , CranSoft DataConstructionServer WebApp development , BackOffice Data StagingWarehouse DSW , and BDCdirect .
• Created SSIS packages in SQL Server 2005 to bring in construction data from disparate sources.
• Developed MS Access application to collect data from business and transport it directly in to DCS tables, minimizing time and effort to populate web applications.
• Extensively utilized BAPI to create and modify LSMW to load object.
• Recorded transactions using SHDB to create a load program for BDC.
• Created many remediation rules at target level.
• Developed Excel documents to collect data from disparate sources to centralize in CranSoft DataConstructionServer .
• Created complex web application in CranSoft DataConstructionServer to collect data for quality objects.
• Expert in CranSoft tools and security.
• Worked extensively with SAP Application Development team to debug SAP programs, including Transportation Lanes BAPI.
• Worked with Security and Basis teams with related issues.
• Created many validation and reconciliation reports for vendors.
• Expert in SQL Server 2000/2005. Used several BackOffice functions to modify data.
• Skilled in HPQC defect management.
• Performed Knowledge Transfer to other BackOffice employees and Sysco counterparts.