SUMMARY

• Oracle Techno - functional consultant wif Manufacturing and Financials experience.
• Over 9 years of Oracle e-Business Suite experience (version 11i and R12).
• Experience in multiple full life cycle implementation projects, production support and upgrade projects.
• Worked in various modules of Procure-to-Pay and Order-to-Cash cycle.
• Extensive knowledge in Distribution modules (OPM, INV, WIP, CST, ASCP, PO, OM, BOM)
• Strong knowledge in Finance modules (AP, AR, GL).
• Have good working experience in HR and CRM modules.
• Proficient in Oracle Workflow Builder 2.6, Discoverer, Alert.
• Used AIM Methodologies for preparation of functional and technical specification of custom solutions.
• Skilled in requirements gathering, functional specifications, design reviews, writing and executing unit and integration tests.
• Good experience in writing user manuals and end user training.
• Strong experience in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components.
• Developed custom packages using APIs and hooks.
• Experience in performance tuning of custom objects (views, stored procedures, reports).
• Performed the roles of team lead, onsite coordinator.

TECHNICAL SKILLS

ERP Modules-: Order management (OM), Receivables (AR), Oracle Shipping, Inventory (INV), Bill of Material (BOM), Oracle Payment, iProcurement, iExpenses, Work in Process (WIP), Payables (AP), Purchasing (PO), Process Manufacturing (OPM), Cost Management (CST), ASCP, Core HRMS

CRM Modules-: Installed base (CSI), Customer Support, Customer Care and Service (CS), Field Service, Teleservice and Telesales suite.

LANG/ TOOLS: SQL, PL/SQL, Discoverer, Workflow Builder 2.6, Forms, Reports, Oracle Alerts, XML Publisher, SQL Loader, PVCS, CVS, TOAD, Data loader

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale CA

Techno Functional Consultant

Responsibilities:

• Modifying the order related interfaces as part of Mobile Item Restructuring process change.
• Developed a process to delete obsolete BOM based on certain criteria.
• Developed a process to create orders for spare parts for service requests created from Contact Center.
• Provide production support to Oracle Ecommerce interface (ECOM). ECOM process involves order fulfillment on oracle end from various portals. me is responsible for the resolution of Ordering & Shipping issues.
• Involved in support of various EDI interfaces (850 Purchase Order /855 Process Order Acknowledgement/856 Advance Shipment Notice /944 Warehouse Stock Transfer Receipt Advice).
• Resolving production issues and bug fixes in Distribution modules (INV, BOM, OM) and CRM (Depot Repair, Field Service and Service Request) via Triole for Services (TfS) process.
• Developed various reports and customized reports according to business requirements using oracle report builder/discoverer reports/SQL reports.
• Developed Oracle alert notifications to send mail messages to customers/business users based on event and other notification.
• Tuning the custom concurrent programs/database objects having performance issues.

Environment: OM, BOM, Depot Repair, INV, CS, PL/SQL, XML Publisher, Discoverer 5i, Forms 10g

Confidential

Technical Lead

Responsibilities:

• Developed interfaces for creation of OPM Batches from legacy planning system.
• Developed interface for creation of AP Invoice from custom module for meat procurement
• Modified the standard the Check printing report to suit the business requirement
• Developed custom Account Definition Rule used in Inventory transactions and OPM financials.

Environment: Oracle Applications 12i - OPM, AP, PO, AR, GL, HRMS, PL/SQL, SQL*Plus, SQL*Loader, XML Publisher

Confidential, Milwaukee WI

Team Lead

Responsibilities:

• Developed interface program for outbound supplier and data migration program for stock locators.
• As a P2P BI reporting tracks lead, implemented and supported reporting solution.
• The responsibilities includes analysis of existing BO Object report, new requirement gathering from the business users, identifying the new BI reports, design of Business Areas, coordinating wif offshore report development team.
• Developed interface to identify the routing number based on the operation and resource availability.

Environment: OM, BOM, AP, PO, INV, OPM, PL/SQL, Discoverer 5i, XML Publisher

Confidential

Technical Lead

Responsibilities:

• The primary responsibility is to impart production support for report.
• Design of ASCP Business Area based on existing BO Object, development of business area, migration and support for discoverer reports (10g) in ASCP module
• Real Time Support of Discoverer reports in Apps modules( ASCP, INV, OM, PO, BOM, AP) and Discoverer Administration

Environment: ASCP, OM, BOM, AP, PO, INV, Discoverer 5i using Noetix views

Confidential, Fort Wayne IN

Technical Consultant

Responsibilities:

• The primary responsibility being technical developer developed conversion code for Item, Item Categories, Catalogs, and Item Cost Onhand Quantities.
• Worked on interface program for PO to SO cycle and for forecast publish and merge.
• Worked on XML Publisher Reports
• Developed automation of demand planning cycle and customized ODPCYCLE workflow.

Environment: INV, CST, WIP and Demand Planning, PL/SQL, XML Publisher, Workflow 2.5

Confidential

Technical Consultant

Responsibilities:

• Converted customer data from legacy system to 11.0.3