SUMMARY:

• Over 8 years of experience in IT Industry of which5 years in SAP BODS (4.0 & 4.1) 2 Years in SAP MDM(7.1 & 5.5) and 1 yrin SAP R/3 (MM, SD).
• Experience in leading the cross - functional master data management solutions.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various source systems to Target systems using SAP BODS
• Expertise in Cleansing, Data Profiling, Transformation and Validating of Master Data.
• Strong Exposure toSQL,PL/SQL,RDBMS,Oracle8i/9i/10gandMSSQL Server 2005.
• Expert in SAP MDM Import / Syndication Process &Automation Process with the SAP and non-SAP systems using PI/XI.
• Worked on ALE/IDOC Interfaces for both Inbound and Outbound Data Transfers.
• Experience with Search UI, Configuration UI, and mapping.
• Experience onASAP Methodologies, Data Modeling, Change Management, Presentation (SAP Portal & API),Data Extraction,Performance Tuning and Authorizations/Roles.

TECHNICAL EXPERTISE:

SAP BODS / MDM: SAP BODS 4.0, 4.1 SP1, SP2, ETL, Data Integration, Data Profiling, Workflow, Dataflow, Transformation, Scripting.MDM 5.5 / 7.1 with SP4, SP6& SP9 (MDM Console, MDM Data Manager, MDM Import Manager, MDM Syndicator, MDM Portal Business content, MDM PI Adapter, MDM Standard Portal iView, Trusted Connection (SSO)

SAP ERP: ABAP Workbench, Data Dictionary Object, LSMW, BDC, Dialog Programming, ALE, IDOC.

Languages: WD4AABAP/4, JAVA, HTML, HTMLB.

Databases: Oracle 10G, Microsoft SQL server 2000/2005/2008,MaxDB.

PROFESSIONAL EXPERIENCE

Confidential, Calgary, CA

SAP BODS Consultant

Responsibilities:

• Integrated BODS 4.1 and Information Steward to migrate the data from SAP and NON-SAP to ECC 6.0 EP5.
• Worked with SAP Functional Consultants, Business & IT Subject Matter Experts and responsible for analyzing and mapping existing Legacy System Material Data to SAP MM.
• Handled the Data Inconsistencies using Data Profiler, which includes Improper Formatting, invalid values and missing / null data.
• Responsible for creating mapping and transformation, including Query, Merge, Row generation and Validation Transformations.
• Involved in debugging the ETL processes and applied various business validations before loading the data into the target System.
• Prepared unit test cases and tested Data Flows and Scripts. Involved in the entire test cycles.
• Provided the Data quality and Comparison reports of every single load.
• Worked extensively with data profiling tools (sap information steward 4.0) for on-going project to understand the quality of data KPI reports.
• Actively involved in the production support and worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.

Confidential, MI

SAP BODS / MDM Consultant

Responsibilities:

• Worked as an ETL Developer to migrate the data from ECC and Non-ECC system and loaded it to SAP MDM as a single source of truth using SAP BODS 4.1
• Extracted Customer and Vendor Master Data from the source systems into SAP MDM.
• Defined Transforms, Jobs, Workflows, Data flows, cleanse and load into target Database.
• Developed the BODS scripting to validate certain fields in both customer and Vendor master tables.
• Worked on XML Pipeline Transformation and converted Nested Structure into Flat structure and then loaded them along with the other flat files into SAP MDM.
• Performed System, Unit, Performance, Load and data interface testings. Prepared unit test cases and involved in the entire test cycles.
• Worked on Source to Target mapping in MDM Import Manager such as Key Mapping and Value Mappings.
• Imported Customer Master Data into SAP MDM 7.1 using Import Manager which includes Main table, Lookup tables, Tuples and Hierarchy Tables.

Confidential, St Marys, OHIO

SAP BODS Consultant

Responsibilities:

• Responsible for analyzing the Data Modeling, Data extraction, Data Loading, Scheduling, Monitoring and Reporting processes.
• Set up Datastores to connect the source system. Configured SAP ECC Datastore to connect with Tables in ECC.
• Provided Data Mapping between ECC and NON ECC (Source system) for Material & customer Master data.
• Configured inbound IDOC batch process to process all incoming MATMAS and DEBMAS and CLFMAS
• Built up the central repository for the development team.
• Performed source data assessment using Data Quality & data profiler transforms and validate data by validation transform.
• Involved in the documentation of technical specifications, data validation and test cases.

Confidential, Houston, TX

SAP MDM Consultant

Responsibilities:

• Implemented Centralized customer master maintenance and automated distribution across all ECC and third party system using MDM 5.5.
• Enabled and configured portal content in Enterprise portal which allows users to login securely using SSO and maintain customer in MDM using Portal screens and trusted connection to MDM.
• Designed the Data Model by adding the fields, which are in scope and also the custom Supply Chain related fields to the repository.
• Developed custom Validations and Assignments for Master record.
• Developed MDM workflow to approve any record before syndicating to ECC and Configured portal UWL to display all workflow items in Portal.
• Extracted the master data from ECC into a flat file and imported those flat files in to MDM 5.5 using Import Manager.
• Developed auto syndication Maps to syndicate records after the approval process. Auto import maps were created to utilize number range generation.
• Configured ALE IDOCS in all ECC system for inbound process.
• Created SAP Transaction iviews, URL iviews, MDM search, resultset and Item details iviews. Customized STD MDM portal content to make sure the iViews are users-friendly.

Confidential, CA

MDM Consultant

Responsibilities:

• Implemented and Centralized the Material Master Data from Legacy systems and ECC and maintained the master data in MDM.
• Gathered all the Business Data from ECC and mainframe systems and Designed the Data Model in SAP MDM as Zcustomer Repository.
• Worked on data Sync-up between MDM and ECC systems and consolidate data for future usealso classified historical and current usage of Data.
• Built the MDM portion of Interface to create / update Materials from ECC and mainframe servers.
• Worked on an enhancement to update the real-time material feeds from MDM to ECC.
• Hands on experience in configuring the Search rule engine in EAI Webservice for secondary search in MDM repository.
• Developed the auto syndication maps to syndicate the materials back to ECC.
• Configured ALE IDOCS in all ECC system for inbound process.

Confidential

SAP ECC ABAP Consultant

Responsibilities:

• Worked on designing ALE/IDOC interfaces for various systems to facilitate data transfer. The application areas include MM and SD. Testing of inbound and outbound process while dispatching IDOC'S from one system to another system. Created ZMATMAS Message type from MATMAS while reduce the IDOC type. Created sales order using standard IDOC (orders05). Distributed material master data pertaining to particular plant/company code across multiple R/3 systems using filter object type.
• Developed LSMW project for loading Material master production data into SAP R/3 system.
• Developed BDC programs to load material pricing master data from external dataset into SAP R/3.
• Developed RFC enabled function modules in ABAP different R/3 transactions and published them on the SAP EP as Java iViews.
• Developed ABAP/4 report programs for sales analysis Interactive Reports, Includes Extraction Sales promotion.
• Developed ABAP/4 report, which extracts Customer Master Long Texts