SUMMARY:

• Over 6+ years of proven track record of IT systems implementation experience, specializing in multiple full life cycle implementation of Oracle E - Business Suite from requirement gathering, setup & configuration, building RICE components, conducting CRP, UAT Support, user training, post production support and upgrades on a continual basis.

TECHNICAL SKILLS:

Primary Skills: Oracle EBS Technical Development (RICEF Components), Interface (Inbound and Outbound), Conversions, Extensions, Forms, Form Personalization, Workflow builder, XML & Discoverer Reports

Packages: (Incl ver) Oracle EBS 12.1.3, 12.1.2, 11.5.9

Modules: Order Management (OM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Inventory (INV), OPM Inventory, Fixed Assets (FA), Install Base (IB), HRMS, Payroll, Time and Attendance Modules

Operating Systems: Win 7, XP, 98, UNIX

Languages: Oracle SQL, PL/SQL, C, CPP, Java, UNIX Shell Scripting

Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, Forms, Reports, BI Publisher, Putty

Database: Oracle 10g, 9i, 8i

Configuration Tools: PPM Clear Case, Clear Quest, VSS, Kintana

Documentation: MD70, MD120, CV60, CV70

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• As a Senior Oracle EBS Technical Consultant, contributed in analysis and design of the Implementation of Oracle R12 Procure to Pay, from end to end.
• Worked in implementation, Upgrade and Support of Oracle ERP Applications/EBS (12i/11i /11.0.3) across various modules which includes Order Management, Inventory, Purchasing, Quoting, Advanced Pricing, BOM (Bill of Material), Oracle Configurator, Oracle iStore, Receivables, General Ledger, Payables, AOL and System Administrator modules.
• Implemented custom process to adjust sales order request date based on warehouse inventory levels.
• Designed and developed multiple Interfaces to and from third party systems (e.g. Warehouse management systems, Demand Planning systems, etc.) by integrating with following Oracle modules: Inventory (INV), Purchasing (PO) and Pricing (QP)
• Successfully implemented seven full life cycle ERP & CRM packages in the Office Equipment, Data Center, Leasing, Manufacturing, Financial, Service, and Postal industries.
• Involved in development of complex reports like Gross Sales Report, Tax Reports (1099 Pre-printed material) XML Report, and Supporting XML Bursting reports.
• Involved in customization of reports in SCM Modules - PO, WIP, INV such as Printed Purchase Order Report, Material Account Distribution Report and WIP Account Distribution Report using Reports6i.
• Developed a process which automatically integrates company home grown customer CRM system and warehouse shipping system to complete entire O2C transactions in Oracle EBS.
• Experience on integration between Oracle ERP and Supplier Collaboration Tool (E2OPEN) to communicate the Net Demand, Booked Sales Orders (BOC), Purchase Orders, PO Receipts
• Strong knowledge of SQL, PL / SQL, Forms 10g/6i, Reports 10g/6i, Discoverer 10g/4i, and XML Publisher.
• Responsible for the Technical Analysis, Design and technical documents for Financial modules and Supply Chain Management (SCM) Modules.
• Restricting the sub inventory form to read only and to enable only when sub inventory validates against the custom requirement using form personalization in warehouse management system (WMS).
• Developed various Inbound Interfaces to include Item Master, Material Transactions, Purchase Orders, Requisitions and PO Receipts.
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system.
• Worked extensively in Interface tables and Import programs (e.g. Import standard PO, PO Req Import, Receiving Transaction Processor, etc.) to meet the requirements of Inbound interfaces.
• Worked in Payables Interface tables and Supplier Open Interface Import programs to meet the Conversion requirements of Supplier records from legacy to Oracle.
• Involved in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Experienced in EDI mapping for PO Outbound Interface to EDI 850 and EDI 860 standard formats.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR's) on seeded performance Issues

Environment: Oracle Applications R12.2.2 - Purchasing (PO), Inventory (INV), Payables (AP), Sub-Ledger Accounting (SLA), General Ledger (GL), Oracle Application Framework (OAF), BI Publisher Reports, Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting.

Confidential, Costa Mesa, CA

Oracle EBS Financial Techno Functional consultant

Responsibilities: -

• Implementation and technical expertise in Oracle Applications R12/11i, across the Discrete and Financials Modules such as General Ledger (GL), Payables (AP), Receivables (AR), Manufacturing Modules, Purchasing Order (PO), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work in Progress (WIP), System administration (AOL) .
• Customized reports in OM and Inventory such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report.
• Support of the existing SCM and Finance system which includes Functional modules like INV, BOM, WIP, MRP, Costing, OM, AR, PO, AP and GL
• Conducted one full life cycle new implementation projects and one R12 upgrade project as a CRM and Supply Chain/Distribution Functional consultant.
• Experience in developing inbound and outbound Interfaces for Oracle General Ledger, Accounts Receivables, Purchasing, Quoting, Order Management and Inventory modules
• Implemented CRM modules such as: Sales, Depot Repair, Tele-Service, Service Contracts, Installed Base, TCA, Quoting, Teleservice and Universal Work Queue.
• Experience in Customizing standard Oracle Reports using Reports 10g/6i in GL, AP, INV, OM, AR and PO modules as per business user requirements.
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle.
• Designed and developed PLSQL based customizations in R12 Order to Cash process to improve Sales compensation process.
• Provided IT Technical mentorship for Oracle ERP Manufacturing Modules including but not limited to programs around Technology Upgrades, Customizations, Root Cause fixes & Long-term system stabilization.
• Visit Client location to gather requirements in building SCM interfaces via EDI with the trading partners.
• Designed and developed multiple Interfaces to and from third party systems (e.g. Warehousemanagement systems, Demand Planning systems, etc.) by integrating with following Oracle modules: Inventory (INV), Purchasing (PO) and Pricing (QP).
• Experience in converting the standard Oracle reports to more fancier reports using XML publisher
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Customized the report Invoice Purchase History Report in Purchasing (PO) Module according to the business requirements.
• Experience in developing custom Oracle Forms using Oracle Forms 10g/6i. Used CUSTOM.pll to customize the standard oracle Forms.
• Developed customization of OTS Invoice Outbound transactions Interface for SOA Integration Projects from ERP.

Environment: Oracle Applications R11 - Purchasing (PO), Account Payables (AP), Order Management (OM), Account Receivables (AR), Inventory (INV) and WIP Modules, BI/XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Forms 10g, Form Personalization, Kintena, VSS

Oracle EBS Techno Functional Consultant

Responsibilities:-

• Experience in Oracle Apps techno functional consultant with 2 full life cycle implementation for international clients.
• Strong understanding of Procure to pay, Source to Pay and Order to Cash cycle.
• Good hands on experience on Oracle Purchasing, I-Procurement, Accounts Payables, Order Management and I-Supplier.
• Setups in CRM for new business processes as well as new acquisitions of the company and setups of value sets, flex-fields and concurrent programs.
• Understanding of Sourcing, Cash Management, Account Receivable and General Ledger modules.
• Inventory Setup Setting up the Inventory Organization Structure, Organization Parameters, Subinvenotries and Locators, Transaction Types, Defining Counting, ABC Analysis, Cycle Counting, Physical Inventory
• For this sales application, provided the design and logic for integrating the application with the Oracle E-Business Suite.
• Gathered Requirement for Conversion programs for SCM modules OM, INV, PO modules.
• Updated production data from ERP to data warehouse tables by developing various packages and procedures.
• Worked on multiple upgrade projects from Oracle 11i to Release 12 (12.1.3 and 12.2).
• Developed custom program to create orders SCM (Supply Chain Management) Orders
• Analyzed requirements and delivered a fit analysis document. Fit & gap performed between Oracle CRM, Service Contracts; Subscription Billing; Recurring Revenue & Accrual reporting.
• Experience in designing and developing RICEW components and developing reports using Oracle Reports and XML/BI Publisher. xtensive experience in development of components using PL/SQL, Shell Scripting.
• Worked on an ERP consolidation project where two different Oracle ERP systems were merged into one single ERP system.
• Have acquired experience in Oracle Apps Manufacturing, Inventory, Order Entry, Shipping, and Finance modules from both a technical and functional perspective
• Experience with cross validation security rules and developing oracle alerts, AOL Setups.
• Extensive working experience in Global Single Instance using Multi-Org Access Control (MOAC) feature of R12 Oracle Applications.
• Implemented Simplified Approval System for requisition and purchase order by customizing standard approval process of Oracle. This was to eliminate redundant steps in approval process and reducing approval time by 60%.
• Experience in conducting CRP-1/2/3, SIT and UAT with business power users/end users
• Strong experience on EBS system administration functionalities such as user maintenance, concurrent manager maintenance and workflow administration.
• Provided support for existing ERP system and implementing enhancements/customizations according to user requirements.

Environment: Oracle Applications R11 - Install Base (IB), Order Management (OM), XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting