SUMMARY

• Over 18 years of experience as Senior Oracle Applications Functional Analyst and Solution Architect.
• Very good experience in design and implementation of Oracle PIM, Oracle MDM, Oracle Product Data Hub (Oracle PDH), Oracle Supplier Hub, Oracle Customer Data Hub, Oracle TCA & Oracle Supplier Lifecycle Management / Oracle SLM modules.
• Done multiple full cycle implementations of Oracle MDM/PIM modules including Big 4.
• Implemented Oracle MDM/PIM for Retail, Technology and Healthcare/Medical industries.
• Designed and configured Oracle MDM/Product Data Hub instance integrated with Oracle EBS, Siebel Product Master, Mainframes and Data Warehouse.
• Used data integration/publishing technologies like SOA, AIA PIP and Informatica ETL tools.
• Designed and configured Workflow for setting up Business Events, designing Event Subscriptions, Change Management workflows, NIR workflows and setting up Approvals.
• Good experience in designing and creating Advanced Product Catalog (APC), creating product hierarchies and creating Item Catalog Categories (ICCs). Designed and setup User Defined Attributes (UDAs), Multi - row Attributes & Attribute groups.
• Setup Oracle PIM to integrate with Oracle OM/Advanced Pricing and Oracle Configurator.
• Good understanding of Oracle TCA, Oracle Customer Hub & Oracle Supplier Hub.
• Good experience in New Product Introduction (NPI) process and Change Management Process.
• Designed and setup data governance using privileges, roles and responsibilities.
• Good experience with bulk item upload/attribute upload tools like Web ADI, APIs and Import Workbench.
• Excellent communication skills and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential, New Hampshire

Solution Architect & Lead Functional Analyst

Responsibilities:

• Conducted requirement gathering workshops to business users and IT professionals.
• Prepared future state of the new Hub & Spoke architecture, prepared implementation roadmap, project mile stones, rollout plan and instance strategy.
• Evaluated integration technologies like Oracle AIA PIP, SOA etc. for outbound and inbound integration.
• Configured Workflow for Change Request/Change Orders with workflow Approvals and New Item Request.
• Configured Workflow Business Events & designed Event Subscriptions for real time data integration.
• Designed and implemented customizations for item import and data enrichments using APIs and Interfaces.
• Designed data governance using Privileges, Roles and Responsibilities.
• Explained and setup Oracle PIM integration points with Oracle OM/Advanced Pricing & Configurator.
• Designed & setup Change Request and Change Orders with approvals. Setup Business Rules.
• Worked with different format of GTIN and UPC coding specific to retail industry.
• Enforced data quality for data cleanup and de-duplication using Match Rules.
• Designed Item bulk import using Web ADI and APIs.

Environment: Oracle Applications R12.1.3 on Oracle Database 11.2

Confidential, Southern California

Lead Functional Analyst & Solution Architect

Responsibilities:

• Implementation Oracle Supplier Hub/MDM modules for the company. The company has vast supplier base and multiple Oracle ERP instances.
• Presented MDM/Supplier Hub module capabilities and product demos to Business users & IT staff.
• Implemented Supplier Lifecycle Management (SLM). Worked with iSupplier & Sourcing Supplier modules.
• Designed and configured Workflow for setting up Business Events and Event Subscriptions.
• Designed and setup User Defined Attributes (UDAs) & Multi-row Attributes.

Environment: Oracle Applications R12.1.3 on Oracle Database 11.2.

Confidential, Bay Area, CA

Lead Functional Consultant and Solution Architect

Responsibilities:

• Implemented Oracle Product Hub / MDM / PIM modules as a fresh implementation.
• Presented Oracle PIM module capabilities and product demos to Business Users and IT professionals.
• Studied & assessed current state, analyzed business requirements and prepared future state. Prepared implementation roadmap, project mile stones and rollout plan.
• Assessed data integration/publishing technologies like SOA, AIA PIP and Informatica ETL and recommended best solution for each integration points.
• Designed and created Advanced Product Catalog. Studied the product ranges and services company markets. Setup catalog hierarchies and created ICCs (Item catalog categories).
• Used WEB ADI and APIs to upload/import Items and their Attribute values.
• Designed and setup user defined attributes (UDAs), multi-row attributes & attribute groups.
• Designed data security features and created Privileges, Roles and Responsibilities.
• Setup up Oracle PIM to integrate with Oracle OM/Advanced Pricing and Oracle Configurator.
• Designed New Product Introduction (NPI) process Workflow, with data enrichment & approval process.
• Designed and configured Change Request and Change Order process with Workflow approvals.
• Worked on Oracle Customer Hub

Environment: Oracle Applications R12 (12.1.2) on Oracle database 11.2

Confidential, Wilmington, NC

Project Manager and Lead Solution Architect

Responsibilities:

• GE Nuclear Energy, Wilmington, NC: Supervised and Implemented Oracle Inventory and Purchasing modules.
• Lead a team of up to 12 members consisting of Functional Analysts and Developers.
• GE Oil & Gas, Houston, TX: Designed and Prototyped Oracle MES system, the newly released manufacturing module. Created prototype and demonstrated module capabilities to Business users and IT staff for evaluation.
• GE Aviation, Cincinnati, OH: Worked on Oracle Inventory. Designed a stock replenishment and stock transfer system for partner Snecma of France. Supervised development and implementation.

Environment: Oracle Applications R12 and 11i (11.5.10.2)

Confidential, Bay Area, CA

Oracle Functional Consultant implemented Oracle

Responsibilities:

• Implemented Oracle Product Hub / PIM. Studied Product master data flow and mapped product master table structures of various systems which uses Product master data.
• Designed and setup Advanced Product Catalog. Designed I Catalog hierarchies and Item catalog categories (ICCs). Setup user Roles, Group Roles and Privileges
• Designed User Defined Attributes, multi-row attributes & attribute groups and added role based security.
• Setup Product Data Hub instance. Setup Publishing/integrating of Items & Item attribute values to Transactional instance, Seibel Product Master & various other legacy systems.
• Setup New Product Introduction (NPI) workflow, SKU generation, Item Attribute value changes with approval workflow.
• Trained users for Data Stewardship and to use Product Data Librarian and Import Workbench utility.
• Used WEB ADI to import new Items and update User Defined Attributes values.
• Setup Business events and event subscriptions to publish Attribute value changes to external systems.
• Designed interface to transfer UDA data from Data Hub instance to ERP instance.

Environment: Oracle Applications R12 (12.0.4) on Oracle database 10g (10.2)

Confidential, Salt Lake City, UT

Oracle Functional Consultant

Responsibilities:

• Implemented Oracle Inventory. Client has multi-org discrete manufacturing environment. Studied and setup legal entity, operating unit, inventory organizations and sub-inventories. Created item-templates and created data-mapping document to migrate items and on-hand stock.
• Implemented Oracle BOM. Setup standard boms, ATO Model BOMs and Routings.
• Implemented Oracle PO. Setup Approval Hierarchies and Approval groups. Setup approved vendors and sourcing rules, Purchasing options and Receiving options.
• Implemented iProcurement. Done Analysis, Design and complete setup. Imported supplier catalogs. Customized Workflow to generate correct Charge Account.
• Implemented iSupplier. Setup and trained users. Created functionality and Training document for Vendors to login to iProcurement and query POs, enter Shipments and ASNs.
• Implemented Oracle Cost Management. Studied and setup standard cost and cost elements.

Environment: Oracle Applications 11i (11.5.10.2) on Oracle Database 10g (10.1)

Confidential, Kingston, RI

Oracle Functional Consultant

Responsibilities:

• Worked on implementation of Oracle Inventory. Client has multi-org discrete manufacturing environment. Studied, analyzed and prepared BR100 setup document. Setup legal entity, operating unit, inventory organizations, sub-inventories, locations and locators. Designed item-templates and item Categories.
• Worked on Oracle BOM. Setup standard BOMs, ATO Model BOMs and Routings. Worked on Oracle WIP. Client has discrete manufacturing environment.
• Implemented Oracle Advanced Product Catalog (Oracle 11i version of PIM Data Hub). Designed and setup Product Catalog hierarchies and Item Catalog Categories (ICCs)
• Designed user defined attributes & attribute groups and added role based security.
• Designed Item Change Management process for Item lifecycle Change Orders. Setup Change Management Approval Workflows. Setup user Roles, Group Roles and Privileges.
• Implemented Product Lifecycle Management. Studied Product development process for various Product types. Designed Product lifecycles, Lifecycle phases and Item Statuses for each product types.

Environment: Oracle Applications 11i (11.5.10.2) on Oracle Database 10g (10.1)

Confidential, San Diego, CA

Oracle Functional consultant

Responsibilities:

• Implemented Oracle Order Management. Client has multiple Order Sources. Orders are downloaded from custom front-end system and Web. Client has Standard Orders and Drop-ship orders. Studied, designed and done complete OM Setup/documentation, user training, prepared test scripts and cutover plan.
• Designed a customization for a custom front-end Order Entry system which integrates with Oracle OM to accept over the counter Sales Orders and receive Cash/ Check/Credit Card payments. Integrated Advanced Pricing for the custom Order Entry system.
• Designed a Customization to integrate Partner Systems with Oracle OM for Sales Orders & Customers. Partners include Amazon.com and other sports internet retailers.
• Implemented Oracle Advanced Pricing. Defined Qualifiers for different customer membership classes. Setup Modifiers for periodic campaign related discounts and promotional discounts.
• Implemented Oracle Shipping. The company uses packing and container features. Setup Pick Slip grouping rules and Release sequence rules. Done user training.

Environment: Sun OS 5.6, Oracle 9i, Oracle Applications 11i (11.5.10)

Confidential, San Jose, CA

Oracle Functional Consultant

Responsibilities:

• Worked on implementation of Oracle Inventory. This was a multi org implementation. Studied the existing legacy system, done inventory setups and done data mapping for conversion. Created organizations, Item templates, designed item segments and category segments.
• Implemented BOM/Engineering. Client has standard boms, ATO boms and routings. Created data mapping for conversion of BOM. Implemented Engineering. Setup ECO categories and Approvals. Trained users to create ECO approve and implement.
• Implemented Oracle WIP. Client has discrete manufacturing. Designed and done complete setup. Trained users to do WIP transactions.
• Implemented Oracle Configurator. Worked on Configurator for requirement gathering for product modeling, setup of ATO BOMs, rules definition like logic, compatibility, Numeric and Statement, and UI setup.
• Implemented Oracle Cost Management. Setup Cost Types and cost elements. Prepared conversion document for Cost upload. Worked on cost rollups and cost update.

Environment: Oracle Applications 11i (11.5.5) on Oracle Database 8i.