SUMMARY

• SAP CERTIFIED HANA, BODS, MDM Lead consultant with 14 years of experience in IT as a Data Warehouse Professional with very strong SAP Business Objects Data Services 3.x/4.x, HANA, S/4 HANA 1610, 1809, LTMC, Object Modeler(LTMOM) and EMIGALL with a primary focus on SAP Data Migration, Data Integrations, and Conversions with SAP Data Quality Management of Legacy Data into SAP using SAP Data Services with BPDM in RDS methodology.
• Configured and installed SAP BODS, Job Server, Central and Local repositories.
• Experience in Installation, server configuration, patch upgrades, application Security, User and Groups management, Folders, Back - up and Recovery, Performance Tuning of BO Servers, Disaster Recovery, Promotion, Auditing and Monitoring all the landscapes.
• Implemented 4 full life cycle implementations on SAP Migration projects, starting from Blue printing stage to Production. Experience in migrating all the Master Data Objects (Customer, Material, Vendor) along with transactional data by referencing the RDS Methodologies using IDOCS and LSMW When needed. Expert in delta records on both source and target level CDC (change data capture) on type1, type2 and type3 SCD (slowly changing dimension). Experience in profiling the data using Information Steward 4.0 (Data Insight), Worked with all the Inbuilt transforms in BODS like Platform, Integrator and Data Quality transforms.
• Expert in analysis and development of ETL data flow design using Business Objects Data Services XI 3.x/4.x(SAP BODS). Experience in SAP Data Migration using BODS BPDMs and Data & Address cleansing using Data Quality and Pro-Active Data Validation. Data Object Planning, Definition, Mapping, Migration & Consolidation with LSMW, ALE, BDC, IDOCs, BAPI’s, EMIGALL, Migration Cockpit LTMC/LTMOM(Object Modeler) and Uploading Data Object to SAP
• Experience IS-Migration Workbench EMIGALL, Extensive experience in SAP ISU for Confidential solutions. Designed Technical specifications for all the uploaded and extraction programs and tools which also use IS-Migration Workbench EMIGALL
• Worked on all the IS-U Objects like, Installations, Premise, Business Partner, Device, Tech Install, Bill Install, Meter Reading, Move-In, Installation Facts, Profile, Disconnection Objects…
• Experience of HANA provisioning to create attribute views, analytical views and graphical calculation views utilizing functional knowledge of various SAP modules. Implementing data level security and model level security using analytical privileges and package privileges using Information modular in HANA modeling studio. Practical expertise in utilizing SLT and BODS for data provisioning from various sources, and SAP Landscape Transformation (SLT) to perform real-time data replication, SDA, SDI, SDQ, DXC, SAP ODP-ODQ, and Text analytics.
• Expertise in SD, MM, PP, FICO, HR, CRM, PS, WM and CIS, EAM, SCM & FICA in IS-U Confidential industry
• Worked with US Regulatory Address cleansing, English North American Data Cleansing, Name Address match transforms as part of Customer, Vendor Data cleansing.
• Worked on data profiling and analysis. Provided technical leadership on the use of tools to perform ETL and data profiling. Identified the business rules embedded in the legacy data flow. Cross reference value changes, Data standardization, De-duplication, USPS based Enrichment, Experience in profiling and metadata management using information steward
• Worked on performance tuning using caches, parallel execution, using bulk loading and using dataflow execution and etc.
• Experience Back Office Migration methodology, Created view in SQL and used them in BODS
• Experience in configuring using APIs and SFDC adapters, to configure BODS with Salesforce
• Experience in Integrating SAP BW with BOBJ and worked on all reporting tools (WebI, Crystal Dashboards) in the BOBJ suite and Universes according to requirements. Involved in multiple end to end Implementations, up gradations and Production Support
• Expert in building SAP BW based BOBJ solutions and also using Oracle and SQL Server as a backend for - Universe Designer, IDT, Web Intelligence, Crystal Reports 2011 and Enterprise, Xcelsius/Dashboard Designer, Live Office, QaaWS, InfoView/BI LaunchPad, Data Federator
• Industry experience: Personal Care, Media, Electronics, Pharmaceutical, Public Sector, Retail, Financial services, Confidential, Health Care, Handicraft, Telecommunications, Locomotive Equipment Manufacturer & Paper Industries
• Strong analytical skills and has experience in executing large projects with waterfall and Agile methodologies, Seeking a suitable opportunity as a SAP Data Migration Lead / SAP BO DS Data Integration Architect in a challenging environment.

TECHNICAL SKILLS

ETL Tools: SAP BI, SAP BODS 3.x/4.x, EMIGALL, Migration Cockpit LTMC/LTMOM, MDM, MDG, Win shuttle, Informatica

Databases: SAP S/4 HANA, Oracle 11i/10g/9i, MS SQL Server 2008/2005, MS Access 2000, My SQL and Oracle DBMS, Sybase

Analytics: SAP HANA SP9, SLT, HANA Design Studio

Reporting Tools: BOBJ BI Reporting Tools, Integration Option for Microsoft SharePoint - IOMS

SAP ERP: SAP ECC 6.0/5.0, R/3, 4.7/4.6c, S/4 HANA 1610

Operating Systems: Windows, UNIX, LINUX

Languages: ABAP/4, C, C++, HTML, SQL, PL/SQL, XML, Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

SAP S4 HANA Data Migration Lead

Responsibilities:

• Conducted review and approval of the functional specifications, technical transformation requirements document. Performed source data assessment and identified the quality and consistency of the source data
• Conducted the Workshops with the Source SME’s/Business owners/Stake holders to identify the Data Elements required and the Business Rules to derive the KPI’s.
• Working with Functional Consultants on analyzing the data gathering requirements and collected the requirements for the data mapping, Created the Mapping Documents between Legacy and Target Systems
• Designed and Developed the Data Services Jobs to Extract, Stage, and Address Cleanse, Standardize, Match and De-Dup the Master Data Objects
• Downloaded and Reviewed the out of box Rapid Deployment Solution for S/4 Hana 1809 and created the technical and functional specs.
• Created the Mapping Documents between Legacy and target system data objects
• Analyzed Current VS S4 Hana data models, identifying and mitigating the challenges from tradition data model to S4 HANA 1809
• Developed data migration approach and strategies, provided guidance to internal IT key users to design and develop data loaders / templates to fit the business requirements.
• Created BODS frameworks to extract load data from heterogeneous source systems and load into target systems, extensively used LTMC Migration cockpit for data loads into S4 HANA
• Developed validation programs to cross check all the data before and after the data loading, developed and generated Pre load reports & Post load reports for Business users to validate.
• Identified problematic areas and conducts research to determine the best course of action to correct data. Proactively identified project risks and created feasible solutions.
• Escalated cross functional issues and identified SMEs required for resolution. Drove data migration strategy and process to enable quality data delivery without delays.
• Experienced S4 HANA 1809 Migration/ Compatibility issues and addressing them to SAP,
• Integration of S4HANA1809 with SAP Data Services by setting up connections and loading the data, build custom programs for the objects that are missing in the SAP S4HANA 1809 release in LTMC or in BPDMs from SAP RDS package
• Worked closely with the SAP EIM support team to bridge the gap between the available objects and missing objects in SAP S4HANA BPDM release,
• Working with code promotion and version control using Central Object Repository
• Utilized RDS, BPDMs to migrate data with SAP Data Services for following items: Business Partner for Customers & Suppliers, Material Master, Inventory Balances, Batches, G/L Accounts, Profit Centers, Cost Centers, and Groups, Activity Types, Bank Master, Work Centers, Fixed Assets, Open AR & AP, BOMs, Routings, Production versions, PIRs, Internal Orders, Functional Locations and SD Pricing Conditions, Material BOMs, Equipment BOM, Source List, Task list, Purchase Orders in Target S4 HANA 1809 using LTMC Migration cockpit, LSMW and IDOCS

Environment: SAP S/4 HANA 1809, SAP BODS 4.2, SAP ECC 7.0, HANA 2.0

Confidential - ALEXANDRIA, LA

SAP S4 HANA Data Migration Specialist

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Responsible for interacting with various business stakeholders for creating and finalizing data migration strategy, creating the migration plan and procedures and performing the data migration
• Responsible for creating and presenting the status reports to clients on data migration
• Responsible for executing data migration activities from various sources to target applications
• Downloaded and reviewed the out of box BPDM Solution for SAP S4 HANA and created the technical and functional specs
• Mainly working on Finance, SD and MM Master Data Loads and Transactional loads
• Worked on objects Bill of Materials(BOMs), Routings, Batch, Open Sales Orders, Inventory Balances, Material classification, Bath class and characteristics, Open Purchase orders, customers, vendors, Fixed assets, A/R past due balances and Purchase info records etc.
• Worked with Functional Consultants and collected the requirements for the data mapping (key fields, mandatory fields, formatting etc.)
• Performed hands on SAP ISU system and conversion configuration including setting up EMIGALL configuration
• Create functional unit and integration test plans and test data for ISU data conversion, Analyzed the Existing SAP Data Services Landscape and suggested the Changes so that it adheres to the SAP Best Practices,
• Participated in the review and approval of the technical transformation requirements document. Performed source data assessment and identified the quality and consistency of the source data
• Conduct the Workshops with the Source SME’s to identify the Data Elements required and the Business Rules to derive the KPI’s.
• Designed and Developed the Data Services Jobs to Extract, Stage, and Address Cleanse (For Business Partner Address using USA Regulatory Address cleansing Transform).
• Downloaded and Reviewed the out of box Rapid Deployment Solution for S/4 Hana 1610 and created the technical and functional specs.
• Experienced implementing SAP Activate Methodology to load data from Legacy to S/4 Hana as Target, Involved in Prepare, Explore, Realize and Activate phases of the project
• Analyzed Current VS S4 Hana data models, identifying and mitigating the challenges from tradition data model to S4 HANA 1610
• Created BODS frameworks to extract load data from source systems and load into target systems, Extracted Business Master Data & Technical Master Data and staged in BODS stage Environment (HANA DB), loaded into S/4 HANA 1610 using EMIGALL IS-U Solution.
• Working with Functional Consultants on analyzing the data gathering requirements and collected the requirements for the data mapping, Created the Mapping Documents between Legacy and Target Systems using EMIGALL for CIS Objects and using Migration cockpit (LTMC/LTMOM) for EAM and FICA data Objects
• Developed validation programs to cross check all the data before and after the data loading.
• Identified problematic areas and conducts research to determine the best course of action to correct data. Proactively identified project risks and created feasible solutions.
• Escalated cross functional issues and identified SMEs required for resolution. Drove data migration strategy and process to enable quality data delivery without delays.
• Experienced S4 HANA 1610 Migration/ Compatibility issues and addressing them to SAP
• Integration of S4HANA1610 with SAP Data Services by setting up connections and loading the data, build custom programs for the objects that are missing in the SAP RDS release
• Worked closely with the SAP EIM support team to bridge the gap between the available objects and missing objects in SAP S4HANA BPDM release, build mapping templates to map the Legacy to Target fields for SAP S4 HANA
• Working with code promotion and version control using Central Object Repo.
• Utilized RDS, BPDMs to migrate data with SAP Data Services for following items in CIS Data, Business Partner, Account, Premise, Installation, Device, Device Location, Characteristics, Property, Tech Install, Bill Install, Meter Reading, Move-In, installment Pan, Disconnection Objects etc. into Target S4 HANA 1610 using EMIGALL for all IS-U objects
• Involved in all phases of testing (unit/Integration) and resolved all the critical issues

Environment: SAP S/4 HANA 1610, SAP BODS 4.2, HANA DB, SAP CRM, FIORY & EMIGALL

Confidential - YORK, PA

SAP S4 HANA Data Migration Lead

Responsibilities:

• Analyzed the Existing SAP Data Services Landscape and suggested the Changes so that it adheres to the SAP Best Practices, using Activate methodology
• Participated in the review and approval of the technical transformation requirements document. Performed source data assessment and identified the quality and consistency of the source data
• Conduct the Workshops with the Source SME’s/Business owners/Stake holders to identify the Data Elements required and the Business Rules to derive the KPI’s.
• Designed and Developed the Data Services Jobs to Extract, Stage, and Address Cleanse, Standardize, Match and De-Dup the Master Data Objects
• Downloaded and Reviewed the out of box Rapid Deployment Solution for S/4 Hana 1610 and created the technical and functional specs.
• Created the Mapping Documents between Legacy and RDM’s
• Experienced implementing SAP Activate Methodology to load data from Legacy to S/4 Hana as Target, Involved in Prepare, Explore, Realize and Activate phases of the project
• Analyzed Current VS S4 Hana data models, identifying and mitigating the challenges from tradition data model to S4 HANA 1610
• Developed data migration approach and strategies, provided guidance to internal IT key users to design and develop data loaders / templates to fit the business requirements.
• Created BODS frameworks to extract load data from heterogeneous source systems and load into target systems, Extracted Material, Batch, Inventory balances from Oracle IFS system and staged in BODS Environment and loaded into S/4 using BPDM for MAT & Batch for INV.
• Developed validation programs to cross check all the data before and after the data loading.
• Identified problematic areas and conducts research to determine the best course of action to correct data. Proactively identified project risks and created feasible solutions.
• Escalated cross functional issues and identified SMEs required for resolution. Drove data migration strategy and process to enable quality data delivery without delays.
• Experienced S4 HANA 1610 Migration/ Compatibility issues and addressing them to SAP
• Experience working on SAP S4HANA 1610 using SAP RDS (BPDM) templates/ Data Services,
• Integration of S4HANA1610 with SAP Data Services by setting up connections and loading the data, build custom programs for the objects that are missing in the SAP S4HANA 1610 release
• Worked closely with the SAP EIM support team to bridge the gap between the available objects and missing objects in SAP S4HANA BPDM release, Build mapping templates to map the Legacy to Target fields for SAP S4 HANA
• Working with Functional Consultants on analyzing the data gathering requirements and collected the requirements for the data mapping, Created the Mapping Documents between Legacy and Target Systems
• Working with code promotion and version control using Central Object Repo.
• Utilized RDS, BPDMs to migrate data with SAP Data Services for following items: Business Partner for Customers & Suppliers using RFC (BP RFC), Material Master, Inventory Balances, Batches, G/L Accounts, Profit Centers, Cost Centers, and Groups, Activity Types, Bank Master, Work Centers, Fixed Assets, Open AR & AP, BOMs, Routings, Production versions, PIRs, Internal Orders, Functional Locations and SD Pricing Conditions in Target S4 HANA 1610 using RFC, LSMW and IDOCS
• Involved in all phases of testing (unit/Integration) and resolved all the critical issues

Environment: SAP S/4 HANA 1610, SAP BODS 4.2, SAP ECC 7.0, SQL server 2008/2012 & Oracle

Confidential - Portland, OR

Sr. SAP Data migration consultant

Responsibilities:

• Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data.
• Involved in understanding the key business requirements/KPI’s and prepared the list of ECC tables. Worked in the agile environment to meet the project time lines.
• Worked with Functional teams to understand the Business requirements and documented the BRD’s. Involved in Design/Architecture discussions and provided inputs for the project design.
• Created and configured BODS repositories, Data Stores (HANA. Non-HANA), proactively identified project risks and created feasible solutions. Designed and developed data conversion programs using conventional LSMW, BDC and IDocs.
• Responsible for developing complex SAP Data Services Data flows / Workflows using different types of transforms.
• Involved in Managing Dev, Quality and Prod environments. Created schema mappings, HANA data provisioning, Import, Export, Migrate and Mass copy features.
• Involved in interacting with end users to understand the issues and provide the solutions.
• Utilized Rapid Deployment Solution, BPDMs and customized Jobs to migrate the data with SAP Data Services for following items: Vendor Master, Customer Master, PIRs, QIRs, PPOs, BOMs, Routings, Source list, Work Centers, Internal Orders, and Pricing Conditions.
• Loaded data for the above mentioned objects into HANA, and Monitored the Replication status. Worked closely with business to gather new business requirements.
• Resolved technical issues and implement code modification needed to support changing user requirements for multiple data services jobs.
• Ran the post load validation reports and compare the loaded data with source and approved by the Business users

Environment: SAP BODS 4.2, SAP ECC 7.0, SAP HANA, SQL server 2008/2012, IBM AS-400