SUMMARY:

• Over 7+ years of Extensive experience in Analysis, Design, Development, Testing, Implementation,
• Supporting and upgrading Oracle Applications/EBS 11i, R12 modules.
• Extensive experience in Procure to Pay and Order to Cash business flows.
• Sound Technical/Functional knowledge in Oracle Financials (AP,AR,&GL), Supply Chain Management
• ( SCM ) including Order Management ( OM ) and Inventory ( INV ), Purchasing ( PO ) and AOL .
• Extensive experience in TCA architecture, MOAC
• Extensively worked on Oracle back end programming and Front end development using tools like
• Oracle Forms 10g/6.0, Oracle Reports 10g/6.0, XML/BI Publisher, Oracle Alerts, Forms
• Personalization, Custom.pll, Performance Tuning, SQl, PL/SQL, SQL Developer, TOAD.
• Extensive experience in RICEW/CEMLI components (Reports, Interfaces, Conversions, Extensions).
• Experience in debugging, testing and deploying the applications, designed and developed interactive
• GUI screens and reports using oracle forms/reports and creating LDT files
• Strong programming experience in creating Procedures, API’s, Packages, Functions, Triggers and Other d Confidential base objects using SQL, PL/SQL, UTL File and UNIX etc.
• Tuned SQL queries and performed refinement of the d Confidential base design leading to significant improvement in system response time and efficiency by using Explain Plan and TKPROF
• Experience in Application Object Library ( AOL ) such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, lookups, list of values, FlexFields etc.
• Experienced in preparing Technical specs (MD070), Installation Documents (MD120), User Documents, Test procedures documents (TE020) and Conversions (CV060) using SDLC/AIM & Agile methodology.
• Excellent in team collaboration (Onsite Offshore), quick adaption and problem solving with good communication and interpersonal skills.
• Proven ability to lead and manage multiple end to end project implementations.

TECHNICAL SKILLS:

Oracle Applications (EBS): Oracle Apps 11i, R12 Financials, GL, AP, AR

SCM: PO, OM, INV, CEMLI Components (OR)

RICEW Components: Configuration, Extension, Modification, Localization, and

Integration: Reports, Interfaces, Conversions, Extensions and Workflow.

Development Tools: Reports 6i & 10g, XML/BI Publisher, Oracle Forms 6i, 10g

D Confidential base: Oracle 9i, 10g, 11g and r12

Utilities: SQL * PLUS, TOAD, Putty, Winscp

Operating Systems: Windows XL and Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer

Implementation Areas: ERP Modules: (R12 upgrade) Financials (AP, AR, GL) Supply Chain Management (PO, OM, INV)

Responsibilities:

• Designed, developed, and tested the new ERP solutions, while upgrading the existing solutions
• Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.
• Extensively used Standard API’s of OM, INV and GL Modules for various requirements.
• Responsible for creating Alerts, BI Publisher Reports in different modules.
• Responsible for preparing MD70, CV60, TE20 and MD120 documents.
• Developing functions, procedures and packages for the new and existing components.
• Responsible for creating LDT files for concurrent programs.
• Created guidelines for System Integration Testing(SIT) and User Acceptance Testing(UAT)
• Providing the production support to the business users.

Confidential

Oracle Technical Consultant

Implementation Areas: Supply Chain Management (PO, OM, INV)

Responsibilities:

• Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.
• Extensively used Standard API’s of OM, INV, PO, AP & AR Modules for various requirements.
• Responsible for creating interfaces, BI Publisher Reports in different modules.
• Responsible for preparing MD70, CV60 and MD120 documents.
• Developing functions, procedures and packages for the new and existing components.
• Providing the production support to the business users.

Confidential

Oracle Technical Consultant

Implementation Areas: R12 Implementation) Supply Chain Management (PO, OM, INV

Responsibilities:

• Rationalized and enhanced the Confidential order management processes and systems
• Improved customer experience, process efficiency and operational margins
• Identifying the best approach towards offering customers flexibility, maintaining
• Improved operational efficiency while reducing complexity of various product offerings.
• Worked on development, customization, and personalization of custom forms
• Worked on Extensions track for various standard processes
• Worked on POC requirements for OM, Purchasing, and Inventory modules
• Worked on Sales Order Interfaces using process order API
• Worked on concurrent programs creation
• Tested and reviewed code, and documented the various deliverables

Confidential

Oracle Technical Consultant

Implementation Areas: ERP Modules: Supply Chain Management (PO, OM, And INV)

Responsibilities:

• Re implemented, upgraded, and supported Oracle RICE components and D Confidential conversion for Grupo Industrial Saltillo.
• Leveraged my design and development skills to re implement Oracle EBS in R12 from 11i, ahead of schedule
• D Confidential conversion design and implementation from R11 to R12, Developed Item Conversion and Item Onhand Conversion.
• Retrofit and upgrade the RICE components from 11i to R12.
• Led the component migration on the Kintana Workbench
• Judicious understanding of the Oracle EBS 11i and Oracle EBS R12 systems led to the creation of systems that offer improved customer experience, process efficiency, and operation margins
• Unit testing and code review guidelines for existing and new members on my team
• Led the design and requirement gathering meetings with the business users for RICE components
• Preparation of MD070, CV060, TE020 and MD120 Documents.
• Post Production Support.