SUMMARY

• 9 Years and 6 months of total IT experience in design, development, implementation, upgrade and post production support of Oracle Applications E - business Suite 11i/R12.
• Expert technical and functional noledge of Oracle Master Data Management(MDM) - Product Information Management/Product Data Hub 12.1.1, 12.1.3
• 2.5 Years of International experience (UK, USA).
• Helping Wipro competency team by working on multiple clients (Citi, Cisco).
• Expert on Oracle Fusion Product Hub and Customer Hub 11g.
• Good understanding in Oracle Discrete Manufacturing - Items, Bills of Material (BOM), Engineering (ENG).
• Handling a team of 8 across different geography. Responsible for their work allocation, trainings schedule and project deadlines.
• Proficient wif Oracle Application Object Library (AOL) Coding Standards for debugging Forms, Reports, OAF, BI Publisher, Concurrent Programs/Requests.
• Experience in Design & Development of Oracle Applications Modules using SQL, PL/SQL, Forms, OAF and BI Publisher (formerly XML Publisher).
• Worked extensively on reconciliations issues for Oracle PIM/PDH, Inventory - Items, BOM, and Inventory.
• Experience in transforming BRD documents into FRD/FDD and TSD and developing applications enhancements accordingly.
• Familiar wif Project and Product Development Lifecycles.

PROFESSIONAL EXPERIENCE

Confidential

Oracle E-business Master Data Management

Responsibilities:

• Solution Architect/Functional Lead responsible for end-to-end functional configuration and design.
• Involved in teh design, development, implementation and maintenance phases of PIM/PDH Implementation Project. Phase by phase Implementation. Already gone live wif 2 phases.
• Work closely wif business users. Understand business requirement and model teh same in PIM system.
• Responsible for preparing Business Requirement Document/Functional Design Document as per business requirement.
• Prepare Proof of Concepts/Demos as per business requirements.
• Coordination wif Offshore teams. Assigning work, Status Updates.
• Work wif Oracle Support/Dev on P1 SRs. Involved into regular status meeting wif Oracle management.

Confidential

Oracle Master Data Management

Responsibilities:

• Worked closely wif customers such as Fidelity, Toshiba, NCR, Emerson, GE, Schuitema, Place Maker, Korean Air, British Telecom in implementing their MDM(PIM/PLM) solution.
• Successfully deployed “PIM for Retail” and “PIM for Telco” Projects for Retail and Telecom customers.
• Participating in customer calls along wif Product Management to gather teh details for new enhancements in PIM/PLM logged by customers.
• Preparing FDD, TDD documents as per Customer’s requirement.
• Lead a global team of 5 engineers and fully responsible for their work allocations, trainings, meeting project deadlines and day to day work.
• Working wif Support Teams/Customers in order to analyze teh P1/P2 issues reported by teh customers and to provide teh required solution, enhancement, work around wifin teh customer’s time constraints and in accordance wif associated ERP modules.
• To design and develop new functionalities for PIM/PLM in accordance wif teh customer needs.
• Functional exposure in implementation, development, end user support for Oracle Master Data Management (PIM Data Hub).
• Hands on experience wif various Oracle Applications Release like 11i, R12, R12C (PIM for Retail), R12.1, R12.2, PIM 4 Telco.
• Item Catalog Administration, Item Structure Setup, Change Management Expertise, People and Role Administration.
• Product Workbench, Import Workbench - Import from Excel, Batch Processing, Using API/Interface, Business Events, Rules Setup, Publication Framework.

Confidential

Oracle Applications Discrete Manufacturing

Responsibilities:

• Worked wif teh Support Teams/Customers in order to analyze teh P1/P2 issues reported by teh customer and to provide teh required solution, enhancement, work around wifin teh customer’s time constraints.
• Worked extensively on Item, Bills (Header, Component, Substitute components) Routings creation/updation/deletion interfaces, Import Concurrent Programs and Public APIs.
• Worked on ECOs (Engineering Change Order), Prototypes Creation/ Updation/ Deletion Interfaces, Import Concurrent Program and Public APIs.
• Worked on Delete Constraints for deleting Items, Bills and Routings and Interfaces, Import Concurrent Program to delete teh same.
• Worked on Item Categories Sets, Categories, Catalogs, Cross References, Revisions, and Manufacturing Part Numbers.
• Worked on Bills, Routings and Alternate/Copy Bills Routing functionalities.

Confidential

PDH Business Events Implementation

Responsibilities:

• Worked on teh existing interface packages. Has developed new error handling Packages for handling all teh errors generated by most of teh existing interfaces.
• Worked on Import program for Items, Categories, Cross references, Catalogs.
• Created a common error handling utility package by using Oracle seeded message dictionary
• Created custom forms to display teh information for both error scenarios and resolutions for a particular error created by teh interface to teh user by using PLSQL tool kit and Java Script.
• Developed a Custom Satyam Interface Names form by using TEMPLATE.fmb Oracle seeded form.
• Created test cases and test scripts for testing teh existing interfaces.
• Created migration scripts by using shell scripts. Migrated all teh objects from DEV instance to UAT, QA1 and PROD by using Satyam DBA’s.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Interacting wif super users, participating in discussions for collecting teh required information and its analysis for teh design and development of customizations.
• Helped teh users in performing their daily transactions. Worked and resolved on their logged issues.