SUMMARY

• 7+ years of experience in Oracle E - Business suite 11i & R12.
• Extensively worked in several full life cycle R12 Implementations, 11i to 12i Upgrade with Financials (AR, AP, GL), iReceivables, Manufacturing, TCA, iProcurement, iExpenses, SCM (QP, BOM, and Inventory), CRM (iStore), Oracle Sales, Oracle projects and HRMS modules. Basic understanding on ASCP module and Demantra.
• Very good understanding of Order to Cash (O2C) and Procure to Pay (P2P) life Cycles.
• Experience in Design, Development and Production Support of Forms, Reports, XML Publisher Reports, Workflows, Forms Personalization and development of new forms.
• Expertise in implementing Multi-Org structure using MOAC (Multiple Organization Access Control).
• Extensive experience in Design, Development and Production Support of Interfaces (Inbound/Outbound) Open Interfaces, APIs, web services, Business events, SQL, PL/SQL, and UNIX Shell Scripts.
• Extensive experience in set up of Concurrent Programs, Executables, Request Sets, Value Sets, Lookups and Flex Fields.
• Technical and Functional expertise in Order Management (OM), Inventory (INV), Account Receivables (AR), General Ledger (GL), Trading Community Architecture TCA, AOL and Alerts Framework .
• In-depth knowledge on AOL (Application Object Library), AME (Approvals Management), Oracle Public APIs (Applications Program Interfaces), FNDLOAD and Oracle Integrated SOA gateway.
• Worked on Invoking and generating webservice from Oracle applications through Business events.
• Implemented Oracle Integration SOA Gateway for R12.1.3 release.
• Basic understanding of SOA, BPEL processes and components.
• Expertise in SQL and PL/SQL programming. Extensive experience in developing Stored Procedures, Functions, Packages, Triggers, Indexes and SQL Queries using SQL*Plus, TOAD and PLSQL Developer development tools.
• Skilled in Designing Business Process and Notification mailers, customizing and developing new workflow as per the business requirement using Workflow Builder 2.6
• Expertise in Oracle RICE technologies.
• Preparing High Level Design and Detailed Design documents, Test Case and Test Data Documents, Migration Scripts (using FNDLOAD) and Implementation Plans.
• Excellent communication and presentation skills.
• Ability to identify root causes of problems and consider both long and short-term impact of proposed solutions and develop workable solutions along with excellent communication and interpersonal skills.
• Participation in all phases of Software Development Life Cycle including analysis, design, coding and testing.
• Oracle Certification on “Oracle EBS R12: Inventory and Order Management Fundamentals (1Z0-226)”

TECHNICAL SKILLS

Packages (Incl Versions): Oracle 11.5.10, R12.1.1, R12.1.3

Modules: Inventory, OM, iProcurment, AP,GL,AR,PO,WIP

Database: Oracle 9i,10g

Operating System: Windows, XP,UNIX,LINUX

Tools: XML Publisher, SQL*PLUS, Toad, Workflow, SOAP UI

Application Server: Web Logic

Others: Oracle ISG

PROFESSIONAL EXPERIENCE

Oracle EBS Technical Lead

Confidential, San Jose, California

Responsibilities:

• Understanding the current Confidential Process for Oracle incentive compensation
• Analyzing the Support incidences.
• Guiding the team to analyze the technical components for OIC module.
• Fix errors in production and issue reporting document for any exception that arise.
• Supporting the Confidential compensation payout process for sales agents.
• Provide the solutions for the problems/issues faced in production.
• Discuss the enhancements with solution team, then prepare technical design document, functional design document.
• Discuss the design with offshore team and complete the development with in SLA provided.
• Provide the technical guidance to the team to develop the change request or in fixing the issues
• Providing the updates to the business on the issues.
• Monitoring Jobs in $U.

Oracle EBS Integration Lead

Confidential

Responsibilities:

• Designed and developed the integration between the legacy systems like prepaid management system, Dealer Management system, Point of Sales, Primavera P6, E-Live, Post-paid billing system, Reuters, E-Live, Wholesale Billing system with Oracle E-business Suite as a global template.
• Integration touch points between legacy systems with Oracle E-Business Suite—Prepaid management system with Oracle Purchasing & Inventory management; dealer management system with Oracle Order Management; Point of sales with Oracle Inventory, AR, GL and OM. Primavera with Oracle Item Hub, HRMS and Projects; Post-paid billing system - AR ; Reuters for daily rates ; E-Live with Oracle HRMS and E-learning; Wholesale Billing system with AR for creating customer invoices.
• Ensure that all quality standards are met by all projects & departments by educating the importance of maintaining industry wide quality standards and benchmarks.
• Created the Mapping Documents to map the legacy Customer record fields to Oracle TCA Registry fields for Customer, Product and Inventory as part of MDM integration.
• Designing and Developing PL/SQL Packages, Shell scripts and SQL Loader Control files for interfaces
• Designing and Developing Work Flow Processes for various integrations.
• Setting up and scheduling Concurrent Programs, Request Sets and Alerts
• Preparing High Level Design and Detailed Design documents, Test Case and Test Data Documents, Migration Scripts and Implementation Plans.
• Generating Trace files and TKPROFs and analyzing them to tune the performance of the conversions and interfaces.
• Involved in designing the solutions for integration to EBS vice-versa with middleware (SOA) and third party teams.
• Involved in business discussion with the third party vendors of legacy systems.
• Designed and developed integrations using Oracle Integrated SOA gateway.
• Involved in enhancing the interfaces based on the business requirements.

Oracle Technical Lead

Confidential

Responsibilities:

• Understanding Business requirement and functional design document for implementation.
• Creating Technical Design Documents for reports, workflows, OAF & form personalization.
• Designed and developed approval hierarchy in Oracle Approvals Management Engine(AME).
• Supporting offshore team by providing the clarifications related to Technical and function aspects.
• Worked on managed attachments in E-business suite integration with webcenter.
• Enable to view managed attachments from AR Invoices.
• Designing the customizations for the item approval workflow in product hub.
• Providing the technical analysis on the gaps identified during CRP sessions.

Confidential

Responsibilities:

• Understanding Business requirement and functional design document for implementation.
• Involved in bug fixing during UAT and SIT and post production support phases.
• Involved in technical design documentation.
• Given KT sessions to the client.
• Forms personalization on sales order form to default the freight terms and submit the concurrent programs.
• Developed and configured defaulting rules in order management.
• Worked on End to End cycle (Order to Cash).
• Creating PL/SQL functions, packages, procedures, Forms & Reports
• Customizing Workflows for accounting, Order Management and oracle Projects.
• Customizing iStore JSP pages.
• Worked on BI Publisher reports.
• Development of Forms and Reports from Scratch.
• Developed the oracle forms from scratch for production scheduling for items based on assembly of items based on Bill of Materials(BOM).
• Created LOB in Dematra, monitoring the workflows.

Senior Project Engineer

Confidential 

Responsibilities:

• Upgrade impact analysis.
• Implementing the customizations
• Creating the Oracle Alerts
• Forms personalization;
• Customizing the Account generator and AP workflows.
• Testing the business flows.
• Bug fixing and resolving technical issues.