We provide IT Staff Augmentation Services!

Mdm Consultant Resume

Ny

SUMMARY:

  • Over 15 years of strong IT Industry experience in diversified technologies.
  • Over 10 years experience in implementation, customization/extension of Oracle Applications (R12.2.5,R12.1.3,11i, 11.0.3).
  • Involved in multiple Oracle MDM/PIM/PDH End to End project implementations with various clients.
  • Experienced professional in strategizing and managing large scale product tranformation engagements in varied industries.
  • Provide complete solution delivery with strong proven resource pool in Oracle PIM/PDH.
  • Expertise in establishing MDM Governance model and alignment to change management process of the enterprise.
  • Strong technical and functional knowledge of other Oracle Applications ( TCA, AR, AP, PO, Inventory,O2C,P2P, OM)
  • Experience with various tools for version control and code promotion.
  • Experience in handling teams with onsite - offshore model.
  • Strong Knowledge of Oracle Business Events, Service Oriented Architecture principles and related technologies.
  • Experience in Development, Customization of WRICE (Workflow, Reports, Interfaces, Conversions ) Objects and creation of Functional/Technical Design Documents.
  • Experience in full life cycle projects including phases like analysis, design, coding, testing and implementation.

TECHNICAL SKILLS:

DATABASE: Oracle 12c,Oracle11g, Oracle10g, Oracle 9i, Oracle 8i, Oracle 8, Oracle7 (7.2, 7.3)

OPERATING SYSTEMS: Sun Sparc Solaris, Linux, SCO Unix 3.2, DOS, Windows 3.x/95/NT/98/XP

HARDWARE: Sun Sparc Solaris, Linux, SCO Unix 3.2, DOS, Windows 3.x/95/NT/98/XP/2000, SUNSPARC 1000, IBM RS/6000, HP 9000/750, IBM PC AT/XT

TECHNOLOGIES/METHODOLOGIES: Oracle s Applications Implementation (AIM), Complete SDLC.

PROGRAMMING SKILLS: SQL, PL/SQL, Oracle.

ERP: Oracle Applications (R12.2.5, R12.1.3,Release 11, Release 11i), Application Object Library (AOL), Order Management, Inventory, Accounts Receivables (TCA), CRM, Accounts Payables, Purchasing, ipayment, General Ledger, Inventory, Bills of Material (BOM).

TOOLS: Oracle Workflow, SQL, PL/SQL, Jdeveloper, TOAD, Sql*Plus, Sql*Loader, Developer/2000 (Forms 6i, Reports6i)

PROFESSIONAL EXPERIENCE:

Confidential,NY

MDM Consultant

Responsibilities:
  • Managing over all MDM Program for Supplier and Product Master.
  • Design the solution for phase2 PIM implementation.
  • Capture and validate business requirements.
  • Participating and solution design for MDM optimization programs.
  • Configure ICC,attributes, change mangment workflows,business rules and security for a new target system.
  • Coordinate and manage offshore development team.

Confidential, St.Louis

PDH Architect

Responsibilities:
  • Lead requirement and solution design workshops with business users/SME’s.
  • Design overall end2end process in the implemention of Oracle PIM.
  • Design integration with EDQ/EDQP for contract and item master matching records and de duplication.
  • Configure EBS instances for PIM
  • Build the ICC Structure.
  • Design conversions/interfaces in PIM.
  • Design the critical contract and item master integration with PeopleSoft.
  • Preparing the test strategy and roll out plans.
  • Preparing the data governance charter for product and alignment to the corporate governance policies.

Confidential,Dallas

Oracle MDM Consultant

Responsibilities:
  • Perform/Lead Master Data Conversions in Supply Chain (PO, INV,OM), Pricing, BOM,AR,AP for various business organizations across multiple rollouts.
  • Design new changes to the existing ECO/PIM workflows.
  • Design validation rules for bringing the legacy data and importing into Oracle Applications using APIs and various Open Interface programs.
  • Responsible for doing the multiple conversion to support clients migration from legacy system to Oracle ERP.
  • Uploaded all the concurrent programs,valuesets and responsiblities to another instance using FNDLoad.

Technology: Oracle Inventory, AR, AP,OM,PIM, BOM, EDQP, Application Object Library (AOL), AIM Methodology, SQL, PL/SQL.

Confidential,Milwaukee,WI

Oracle Applications PDH Technical Lead

Responsibilities:
  • Assist Architect in overall MDM architecture and design.
  • Design the meta data model.
  • Lead a team of offshore resources in implementing the PIM.
  • Design in extracting and transforming data from source systems using middleware.
  • Design data distribution strategy and creation of data extracts to pull data out of Oracle PIM as per requirments specified.
  • Design outbound Interface from PIM to Spoke systems.
  • Design Inbound integrations and Conversions of Product data into PIM.
  • Preparation of configuration documents BR100.
  • Coordinate and manage Offshore Development team.

Technology: Oracle Inventory, PIM, EDQP, Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.

Confidential,Dallas

Oracle Applications PIM/PDH Techno-functional Consultant

Responsibilities:
  • Lead PDH design and configuration PIM for the doors division to bring legacy JDE items data into PIM.
  • Drive and got the business approval for the corporate wide ICC structure to support various business units.
  • Design outbound Interface from PIM to Spoke system
  • Develop functional design documents MD50 and CV40.
  • Preparation of configuration documents BR100.
  • Work with offshore developers in Conversion activities.
  • Supporting the end to end system testing.
  • Development of test scripts for QA and User Interface testing.

Technology: Oracle Inventory, PIM, Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.

Confidential,NY

Oracle Applications PIM Consultant

Responsibilities:
  • Architect the product integration strategy across brands in their effort to support the single of source of truth for all FG, rawmaterial, Bulk and parts involving Agile PLM systems, Legacy part masters in AS400 and the product data hub.
  • Develop road map and rollout plan for transitioning manufacturing process from AS400 to Oracle.
  • Design and Develop conversion programs to extract and load all the legacy data into PIM.
  • Design and Develop various extensions needed to implement PDH.
  • Customize the NIR workflow in Product Data Hub.
  • Design and Develop outbound publish interface to publish item and uda information from product data hub to spoke systems.
  • Preparation of MD70.
  • Support for the cut over activities and golive.

Technology: Oracle Inventory, PIM, Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.

Confidential,IL

Oracle Applications PIM Technical Consultant

Responsibilities:
  • Customize the seeded engineering change order workflow to support various business requirement in establsihing a comprehensive data governance.
  • Customize the seeded ECO’s to send parallel notifications.
  • Customize Def and Approval WFT to filter the notifications based on the part type in the ECO.
  • Design and Developed escalation programs to send escalatation notifications for timeout.
  • Design and Develop conversion programs to extract and load all the legacy UDA data into PIM.
  • Create various reports on product data using XML Publisher as per the needs of the business.
  • Supporting the offshore team in conversions of the user defined attributes.
  • Helping the business to extract the configurator data for conversions.
  • Creating various custom database views as per the needs of the business for the publication framework.
  • Supporting the inbound and outbound Agile PLM to PIM interfaces through PIP.
  • Migration of custom configurator reports from 11i to EBS R12.

Technology: Oracle Inventory, PIM,Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.

Confidential,Fortwright,KY

Oracle Applications PIM Technical Consultant

Responsibilities:
  • Design and Develop conversion programs to bring all the legacy data into PIM.
  • Design and Develop various interfaces to push the data to various spoke systems.
  • Design the changes to the approval workflows in PIM.

Confidential,Dayton

Oracle Applications PIM Technical Consultant

Responsibilities:
  • Design and Develop inbound interfaces from Content System to PIM.
  • Design and Develop various outbound interfaces to integrate the PIM data to spoke systems.
  • Customization of the existing seeded change management work flow .
  • Preparation of the technical design documents.

Technology: Oracle Inventory, PIM,Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.SOA

Confidential,Chicago,IL

Oracle Applications Technical Consultant

Responsibilities:
  • Confidential Distribution Inc (PDI) is implementing Product Information Management in order to effectively streamline the definition, collection, management and distribution of its product information to different marketing channels such as E-Catalog, Punch-out, Web stores etc.
  • Design and Developed inbound interface between Dataware house and PIM.
  • All the contract informaton with contract items and their price has to be updated in PIM on daily basis.
  • Design and Developed an outbound interface to publish the item and attributes information to Web Sales.
  • All the newly and updated items and their relative attribute information has to be published to WSC.
  • Various business events have been subscribed and created multiple DB views.
  • Design and Developed outbound interface between PIM and Webstore . The contract information has to be published to WSC on a daily basis. Various BOM Business Events have been subscribed and created DB views.
  • Preparation of the Technical Design for the conversion of items and attributes from DW to PIM.

Confidential,Chicago,IL

Oracle Applications PIM Technical Consultant

Responsibilities:
  • Design and Developed the inbound interface between Peoplesoft and Oracle MDM( PIM)
  • Prepare technical design for the outbound integration between MDM (PIM) and local systems in an SOA Environment.
  • Writing various stored procedures/api’s to convert the data into Oracle EBS.
  • Extensively handled data conversion of complex Multi row UDA.
  • Fine tune the batch process to process high volume data to support global data processing.
  • Customise the workflow to support various business requiremnt in establsihing a comprehensive data governance.
  • Create various reports on product data using XML Publisher as per the needs of the business.

Technology: Oracle Inventory, PIM,Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Workflow.SOA

Confidential,San Diego, CA

Oracle Applications Technical Consultant

Responsibilities:
  • Developed conversion programs, interfaces for Oracle PIM ( Product Information Management) module which stores Inventory related attributes for all the phones/modems/devices offered as products by Confidential . This module will allow business and downstream to effectively categorize and maintain the entire range of devices and services being offered to customers. This implementation was done on top of the existing inventory modules in 11.
  • MDM Publish Interfaces - The Inventory data will be pushed onto internal and external subscribers through TIBCO integration layer on real time basis. Multiple DB views have been created to publish the data supported by Business events basis as a triggering mechanism.
  • Conversion - Data conversion in Inventory Module for Item Catalogs, Categories, User Defined Attributes (UDA), Cross reference values, BOM component information, Master Item Details and attributes.
  • Customized the seeded Engineering Workflows for Item approval process.

Technology: Oracle Receivables, Inventory, Application Object Library (AOL), AIM Methodology, Kintana, SQL, PL/SQL, Sql*Loader, Workflow.

Confidential,Santa Clara,CA

Oracle Applications Technical Developer

Responsibilities:
  • Develop various custom reconciliation scripts to reconcile converted data (Install Base, Service Contracts and TCA)
  • Design and developed complex integrations between various legacy/partner systems and Oracle 11i (TCA, OM, Quoting,OTC)
  • Responsible for design, build and deploy in integration of applications with Oracle BPEL and JDeveloper.
  • Worked on Oracle BPEL Process Manager and developed Web services for Quote Integration with Order Processing.
  • Developed Web services in TCA (Customer Management) and Integration from Quote to Cash Cycle.
  • Supported two cutover activities (D1, D3) and provided production support during warranty period.
  • Completed knowledge transfer of various RICE objects to Support Team (CSC).
  • Responsible for technical documentation (MD070, MD120) and unit test scripts (TE20) using AIM methodology.
  • Developed most of the objects under Scrum methodology.
  • Defined Release process for various RICE components using Kintana tool.

Technology: Oracle Receivables,CRM,OM, Inventory, Application Object Library (AOL), AIM Methodology, Kintana, SQL, PL/SQL, Sql*Loader, Workflow

Confidential,Denver,CO

Oracle Applications Technical Developer

Responsibilities:
  • The scope of the project is to create the following:
  • 4 Custom forms integrated with Oracle Applications to enter/query various compensation details (Employee salary, Deal details, Company/Group Details).
  • 6 Custom reports (XML Publisher) to calculate/report various compensation at different levels.
  • 5 Concurrent programs (PL/SQL) to calculate complex compensation at various levels (Deal, Group, Company).

Technology: Oracle Applications (11.5.9), Application Object Library (AOL), AIM Methodology, SQL, PL/SQL, Sql*Loader, Oracle Forms/Reports 6i, XML Publisher.

Hire Now