We provide IT Staff Augmentation Services!

Senior Sap Consultant - Data Quality And Master Data Management Resume

0/5 (Submit Your Rating)

St Louis, MO

SUMMARY

  • 8 years of progressive experience in IT Industry having extensive experience in Master Data Management, Data Quality, Data Migration, Data Integration and Data Conversion.
  • Good understanding of Software Development Life Cycle models like Waterfall, Iterative, Spiral & Agile with over 9 complete SDLCs till date.
  • Expertise in Master Data Management & Data Governance, involved in RFP preparations, GAP Analysis and Business Requirements Analysis with recommendations and best practices.
  • Experienced in SAP MDM implementation that includes custom data model design (Console), version upgrades, DB Views, Work Flow design, enhancements, creation of Syndication & import maps, etc.
  • SAP MDG implementation that includes custom data models, Re - Use/Flex mode changes, Process enhancements, Rule Based Work Flows (BRF+), complex validations & derivations, WebDynPro FPM design, DRF & DIF.
  • Expert in Data Migration projects having 3+ years’ consulting experience in migrating/integrating data from acquired company legacy system to existing clients IT system and vice versa.
  • Data Quality management using SAP IS & SAP BODS for all migration projects and existing MDM system.
  • Working knowledge on SAP Netweaver MDM Adapter, PI Adapters, RFC, IDOC, Flat Files, Web services (SOAP/REST), XML, XSDs.
  • Worked on enhancing existing Enterprise Data warehousing (EDW) with BODS changes.
  • Excellent technical skill taking up role of lead consultant managing team onsite and off shore with perfect coordination and progressive results.
  • In addition to SAP IS, SAP BODS, SAP MDM & MDG which are my primary expertise I have had continuous experience on tools like TOAD, SQL Developer & MS Server Studio for RDBMS like Oracle (10g/11g/12c) & MS SQL Server (2008/2012/2014 ) and MS Excel for creating various graphical and urgent based analytics and MS PowerPoint for slide shows presentation.
  • Experience on SAP SD enhancements implementations.
  • I have closely worked with ERP (SAP ECC) team and CRM (Salesforce.com) team and have a good understanding of the business.
  • Experience with Idocs/LSMWs/Winshuttle scripts, also familiar with SalesForce.com development environment, familiar with working of Web methods and SAP NW Portal.
  • Extensive experience in client interactions during meetings, status calls, requirement gathering and also efficient in managing team.
  • Strong analytical and problem solving skills with ability to quickly grasp and deliver client's business needs.

TECHNICAL SKILLS

Primary Expertise: SAP MDG 7.0/8.0/9.0 (ECC 6.0), SAP MDM 5.5 / 7.1 with SP4, SP6 & SP9 (MDM Console, MDM Data Manager, MDM Import Manager, MDM Syndicator), SAP BODS 4.1 / 4.2 SP1, SP2), SAP Information Steward 14.2

Secondary Expertise: SAP ABAP, IBM Datastage, Talend DI, Talend DQ, HP Quality Center, SAP Hana

Tools: & Utilities: Toad for Oracle, SQL Developer, MS Office (Excel, Powerpoint, Word), Google Drive (Sheet, Doc, Slides), Textpad, Notepad++, PUTTY, FileZilla

Databases: Oracle 9x,10g,11g/12c, MS SQL Server 2008/2014, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior SAP Consultant - Data Quality and Master Data Management

Responsibilities:

  • Workshops and meetings with Energizer Business team and Gems/Prime ECC users to understand their architecture, requirements and identification of any challenges faced in existing process.
  • Gap analysis, recommendations to improve their existing MDM/ERP system and best practice recommendations.
  • Business rule based profiling of existing data, also implementing data governance check using SAP IS.
  • Setting up SAP’s new cloud based address cleansing system called DQM Microservices in client’s infrastructure.
  • Design and implement address cleansing using hybrid SAP BODS strategy that involves on-prem address cleansing engines and cloud based DQM Microservices.
  • Helping client with Master Data Governance strategy - impact & long term benefits
  • Helping Basis team setting up MDG environment.
  • Phase wise implementation of MDG as hub application to govern and manage Master Data entering ERP.
  • Responsible for managing MDG implementation for Material Master Data object that includes Customization of standard data model, custom FPM based UI design, Rule Based Work Flows, complex validations & derivations, DRF & DIF.
  • Integration strategy of MDG-M data with SAP ERP, iScala and Go-To Market systems.
  • Set-up HANA based material search UI.
  • Managing MDG onsite and offshore team.
  • Enhancement of existing Customer Master & Vendor Master winshuttle interface using BODS jobs to include real-time Data/Address cleanse before processing them in ERP.
  • Deployment of codes to QA and preparation of documents for support team.
  • UAT with testing teams and BA team
  • Smooth transition of knowledge transforms to support teams.

Environment: SAP MDG 9.0, SAP BODS 4.2, SAP IS 4.2, Oracle RDBMS 12c, MS Excel, MS PPT, ECC 6.0 with EHP 7

Confidential, Lexington, KY

SAP Consultant - Master Data Management & Data Migration

Responsibilities:

  • Requirement gathering with different teams including Confidential ERP, Confidential CRM and Kofax IT (ERP).
  • Gap analysis and recommendations based on my past Data Migration experience.
  • Providing data integration solution based on Kofax IT and Confidential IT systems - MDM, ECC and SFDC.
  • Other teams impacted by MDM changes are: SAP ES Portal & Webservices, coordinating the changes to overcome any gaps.
  • Leading the team and helping in development of IBM Datastage jobs to extract data from SAP ECC using ABAP program.
  • BODS staging tables is also used for analyzing data quality and integrity of existing Confidential data. Cleansing of the same and then exporting of cleansed data to Kofax in batches.
  • Helped with documentation and help the end user for test cases during UAT. After UAT handing over the documents and complete KT to the support team.
  • Daily status call with client and discussion of any challenges faced by respective teams.
  • Helped team with documentations and creating test cases for end users.
  • Coordinating with users during UAT for any failures and fixing bugs, once UAT phase is successfully over helping support team with necessary KT and documents.

Environment: SAP MDG 8.0, SAP MDM 7.1 SP12, SAP BODS 4.2, MS SQL Server 2008, Oracle RDBMS 12c, MS Excel, MS PPT, ECC 6.0 with EHP 7, SalesForce.Com, SAP Enterprise Portal, IBM Datastage 9.1.2

Confidential, Lexington, KY

SAP Consultant - SAP MDG, SAP MDM & SAP BODS

Responsibilities:

  • Conduct workshops with Confidential ERP (SAP ECC) Team and CRM (SalesForce.com) Team to understand their architecture and any challenges faced in their existing process.
  • Gap analysis and recommendations report based on information gathered during workshops and meetings.
  • Implementation of SAP MDM and SAP MDG Data Model enhancements to track ESS and ISS Customer/Vendor processing.
  • Other teams impacted by MDM changes are: SAP ES Portal & Web services, coordinating the changes to overcome any gaps.
  • Implementing SAP MDM BP repository enhancements that includes all integration enhancements to SAP ECC, Siebel and SFDC systems.
  • Helped team with documentations and creating test cases for end users.
  • Coordinating with users during UAT for any failures and fixing bugs, once UAT phase is successfully over helping support team with necessary KT and documents.

Environment: SAP MDM 7.1 SP12, SAP BODS 4.2, SAP MDG 8.0, MS SQL Server 2008, Oracle RDBMS 12c, MS Excel, MS PPT, ECC 6.0 with EHP 7, SalesForce.Com, SAP Enterprise Portal

Confidential, Lexington, KY

SAP Consultant - SAP BODS

Responsibilities:

  • Requirement gathering with Confidential PLM, BA and Web methods which will be used to channel translation files to and from 3rd party.
  • Providing solutions based on issues faced by BA and to overcome PLM’s limitation using BODS.
  • Leading the team of 2 BODS developer, helped them building bods jobs making sure changes are being implemented as per decided time line.
  • Coordinating with PLM team and web method team with their code changes, before going ahead with UAT phase.
  • Daily status call with client and discussion of any challenges faced by respective teams.
  • Helped team with documentations and creating test cases for end users.
  • Coordinating with users during UAT for any failures and fixing bugs, once UAT phase is successfully over helping support team with necessary KT and documents.

Environment: SAP BODS, Oracle RDBMS 11g, MS Excel, MS PPT, PLM, Webmethods

Confidential, Lexington, KY

SAP Consultant - SAP MDM, SAP MDG, SAP IS & SAP BODS

Responsibilities:

  • Prepare SAP Basis team for setting up MDG environment.
  • Preparation of governance & configuration assessments based on existing SAP MDM system & SAP ERP system, these will be used to setup MDG configuration.
  • Preparation of existing SAP MDM Business Partner work flows document needed to be implemented in MDG as BRF+ WF.
  • Data Quality check using SAP IS rule based profiling and enhancements using SAP BODS Data Quality transforms before loading them in MDG.
  • Configured and implementation of Rule based workflow for client framework.
  • SAP MDM Data model changes to include MDG CR details.
  • Creation of syndication maps for bulk export for MDG system.
  • Designed custom DIF solution for loading materials data to MDG.
  • Customization of standard data model, CVI mappings, process model enhancements and custom FPM based UI design.
  • Involved in data quality analysis, testing and hyper-care Support.

Environment: SAP MDG 8.0, SAP MDM 7.1 SP12, BODS 4.2, SAP IS 14.2.2.412 , Oracle RDBMS 10g, ECC 6.0 with EHP 7, Webmethods, SFDC and Siebel.

Confidential, Lexington, KY

Technical Lead - SAP MDM and SAP BODS

Responsibilities:

  • Recommendations and gap analysis based on profiling results.
  • Implementation of recommended changes in SAP MDM Business Partner data model according to the new incoming data from the legacy systems.
  • Improve Customer and Vendor data quality using SAP BODS Data Quality transforms, this involves: Name & Address standardization and enhancements.
  • Data enrichment with DUNS & Bradstreet database as part of data quality enhancement process using BODS jobs.
  • Fine-tuned SAP MDM import maps and syndication maps based on changes in incoming data.
  • Generated load file using BODS in a specific format and placed the template in SAP MDM’s ready folder for the Auto-Import process.
  • Monitor IDOC and Web Methods integrations from SAP MDM for any failures during the postings to SAP ERP and SFDC systems.
  • Involved in testing and hyper-care Support.

Environment: SAP MDM 7.1 SP12, BODS 4.2, Oracle RDBMS 10g, ECC 6.0 with EHP 7, SFDC and Siebel.

Confidential, Lexington, KY

Technical Lead - SAP Data Quality

Responsibilities:

  • Worked with the Business team and created changes reports required in MDM Business Partner data model according to the new incoming data from the legacy systems.
  • Presentation of Profiling results to the respective Business teams of ReadSoft and Confidential with actions to be taken before initiating for Data Migration project for the same.

Environment: SAP MDM 7.1 SP12, Oracle RDBMS 10g, SAP IS 14.2, MS Excel, MS PPT.

Confidential, Lexington, KY

Technical Lead - SAP MDM and SAP BODS

Responsibility:

  • BODS (ETL) jobs design changes for cleansing and standardizing newly acquired Pacsgear as per new business rules.
  • Single point of contact for all the counts and status of migrated data.
  • Improved the Customer and Vendor data quality using validations/ standardization/ address cleansing / zip code formatting using SAP BODS.
  • Did Data enrichment with DUNS & Bradstreet database as part of data quality enhancement using BODS jobs.
  • SAP MDM Import maps development for loading enriched Pacsgear data.
  • Responsible for creating necessary load files for SAP ECC team and Salesforce teams for loading in their respective systems.
  • Post go-live fixes of data in MDM and then syncing the same to respective ERP and CRM system using the existing integration work flows.

Environment: SAP MDM 7.1 SP08, BODS 4.1, Oracle RDBMS 10g, ECC, SFDC

Confidential

Senior Developer - SAP Master Data Management and SAP BODS

Responsibility:

  • BODS (ETL) jobs design changes for cleansing and standardizing newly acquired companies as per new business rules.
  • Single point of contact for all the counts and status of migrated data.
  • Improved the Customer and Vendor data quality using validations/ standardization/ address cleansing / zip code formatting using SAP BODS.
  • Did Data enrichment with DUNS & Bradstreet database as part of data quality enhancement using BODS jobs.
  • SAP MDM Import maps development for loading cleansed and standardized data.
  • Responsible for creating necessary load files for SAP ECC team and Salesforce teams for loading in their respective systems.
  • Post go-live fixes of data in MDM and then syncing the same to respective ERP and CRM system using the existing integration work flows.

Environment: SAP MDM 7.1, SAP BODS 4.1

Confidential

Senior Developer - SAP BODS

Responsibility:

  • Requirement gathering for SAP BODS related changes.
  • Development of SAP BODS enhancements.
  • Creating design documents for end users and support team.
  • Test cases for UAT

Environment: SAP BODS

Confidential

Senior Developer - SAP Master Data Management

Responsibility:

  • Requirement gathering for SAP MDM related changes.
  • Development of SAP MDM requirements.
  • Creating design documents for end users and support team.
  • Test cases for UAT

Environment: SAP MDM 5.5 SP05

Confidential

Senior Developer - SAP Master Data Management

Responsibility:

  • Production Support of SAP MDM based Applications (Console, Syndicator, Import Manager, Data manager)
  • Responsible for issues related to SAP MDM data.
  • MDM Maps exceptions fixing.
  • Data fixing using data manager.
  • Incident Management - first line of attack for any Issues.

Environment: SAP MDM 5.5

Confidential

Senior Developer - SAP Master Data Management

Responsibility:

  • Requirement gathering for SAP MDM related changes.
  • Development of SAP MDM requirements.
  • Creating design documents for end users and support team.
  • Test cases for UAT

Environment: SAP MDM 5.5

Confidential

SAP Master Data Management developer

Responsibility:

  • I was responsible for developing SAP MDM extraction process, built maps for syndication.
  • Also responsible for delivering weekly BAU web services files to the client after development phase.

Environment: SAP MDM 5.5

Confidential

SAP Master Data Management developer

Responsibility:

  • Requirement gathering for SAP MDM related changes.
  • Development of SAP MDM requirements.
  • Creating design documents for end users and support team.
  • Test cases for UAT

Environment: SAP MDM 5.5

Confidential

Developer - SAP Master Data Management, SAP BODS, IBM Datastage

Responsibility:

  • Loading of SFA and VISTEX customer and vendor data into staging area.
  • Using IBM Datastage jobs for ETL and using SAP BODS jobs for data quality enhancements.
  • Loading of cleansed and enriched SFA/Vistex records from staging area to SAP MDM.
  • Keeping track of SFA and VISTEX records and provide daily status to the client.
  • Single point of contact for Data Analyst and business users for all updates on the SFA and Vistex customers.
  • Client interaction that includes emails, calls and meetings on SFA and VISTEX processing.
  • Responsible for weekly SFA file deliverables.
  • Work with client data stewards on record exceptions.
  • Fixing of issues related to the SFA and VISTEX manual load in staging area as well as SAP MDM.

Environment: IBM Datastage, SAP BODS, SAP MDM, Oracle DB 9g, Toad for Oracle

We'd love your feedback!