PROFESSIONAL PROFILE:

• 3 Full cycle Oracle Applications implementations of Oracle e - Business Suite Release 11i and R12, numerous Application Development, Support, RICE Implementations, Upgrades with high level of Customer Satisfaction.
• 10+ years of extensive experience out of which 8 years on Oracle Financial Applications/Supply Chain/ including Order to Cash and Procure to Pay. Executed critical projects as Techno-Functional Lead, Onsite lead, Designer on Technical & Techno-Functional roles. Extensive Business Area Expertise & have received great commendations from various Clients for excellent interpersonal & Client interaction skills.
• Possess good experience on interface design with integration of TIBCO with Oracle E-Business suite.
• Possess strong knowledge/expertise of Supply Chain Management & Oracle Financial modules of Oracle applications, with concentration on AP, AR, FA, GL, PO, OM, INV, iProcurement, iExpenses, HRMS combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
• Extensive experience in Upgrade of all Financial modules from 11i to R12 (12.1.3), worked from scratch to implementation.
• Extensive experience in Order Management, Pick Release, Allocation & Ship Confirm Processes.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Extensive experience with the Order to Cash and Procure to Pay Business flows.
• Involved in Implementations, Version Upgrades, Data Conversions, Production Support and Customization of Reports and Forms in Oracle Order Management and Oracle Financials both in 11i and R12.
• Extensive Experience in TCA (Trading Community Architecture). Usage of API for Supplier Creation, Contracts Creation, Supplier Bank, Bank Branches and Accounts creation and whole Architecture.
• Extensively worked in Oracle Front-end programming and Back-end development using tools like SQL*Loader, PL/SQL, SQL*Plus, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle Workflow, XML Publisher and Shell scripting.
• Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), Concurrent Managers, Concurrent Processes and System Administration.
• Experienced in customization of workflows and in fine-tuning code for better performance. Developed multiple complicated XML Publisher reports, used features like XML bursting and conversant with XSLT syntaxes, conditional formatting etc.
• Experience using workflow components like Workflow Builder, Workflow Engine, and Workflow Monitor.
• Experience in development of Packages, Procedures, Functions and Database Triggers using PL/SQL and a good knowledge of using TOAD.
• Extensive expertise in migration of data, Conversion, developing Interface, Customization, mapping.
• Extensive expertise in Multi-Org environment.
• Extensively used Technical Manual and Metalink to debug technical issues.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.
• Good Expertise in Performance Tuning & Optimization of SQL Queries.

TECHNICAL SKILLS:

Oracle Apps Technical on R12 and 11.5.10, Oracle PL/SQL, Oracle Workflow, Oracle BI Publisher Report on R12, Oracle Forms and Oracle Reports.

PROFESSIONAL EXPERIENCE:

Sr. Techno Functional Consultant

Confidential, Atlanta, GA

Responsibilities:

• Working as a Sr. Techno Functional Consultant as well as onsite lead.
• Leading the technical team for pre designing phase of upgrade to R12.1.3 from 11.5.10 including the design approach, end to end impact analysis of all the customization (CEMLI Preparation).
• Interacting with the business users as well as third party system owners to understand the impact and preparing the documentation for smooth running of all the interfaces which involves third party software system.
• Estimation preparation for the efforts including development, testing, CRP1, UAT and code deployment.
• Document preparation for user on the major modified area in the R12 in the financial domain.
• Involved on implementation of iProcurement module with designing of solution approach to meet business requirements.
• Worked on customization on PO Requisition Approval workflow to enable automatic creation of PO as soon as Requisition got generated.
• Worked on customization of PO Requisition Account generator workflow to fetch correct accounting segment from user ps set.
• Actively involved during iProcurement setup and provided design approach to meet business requirements with minimum customization involved.
• Involved on Forms Personalization, XML Publisher Reports Development, Workflow customizations, Complex Interfaces Design and day to day production support.
• Develop technical specifications, process flow diagrams. Translate functional design into technical deliverables. Develop test strategy and author test plans as required for enhancements and patches.
• Directly or indirectly, in conjunction with Business Analysts, work with business users to resolve customer support issues within Oracle EBS within agreed-to service level agreements (SLAs).
• Involved in Development / Bug fixes/ Root cause Analysis of Custom Interfaces / Workflow and Customizations of Oracle Supply Chain System using PL/SQL, Forms & Oracle Reports.

Environment: Oracle EBS 11.5.10, R12, PO, REQUISITION, OM, INV,SHIPPING, SOURCING, AP, AR, iProcurement, iExpenses, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader, Web center.

Sr. Techno Functional Consultant

Confidential, Foster City, CA

Responsibilities:

• Worked as a Senior Techno-functional Consultant on every module.
• Worked for impact analysis of customizations before upgrade to R12.1.3. Actively involved during design of a custom code to scan all the existing custom objects and make a proper spreadsheet out of that to enlist all the objects (CEMLI) impacted.
• Actively involved on almost all the custom code modifications for R12.1.3 upgrade. Actively involved for unit testing, code review, document preparation.
• Customized iProcurement Self Service Page to make Supplier Name and Site Name as mandatory.
• Actively worked on interfaces integrated with TIBCO Adapter to Oracle E-Business Suite.
• Developed Lots of complicated interfaces and received client accolades.
• Worked on Forms Personalization, Reports, Workflow, Complex Interfaces and Oracle XML Publisher Reports including almost all the RICE objects.
• Actively involved in critical production issues.

Environment: Oracle EBS 11.5.10, R12, PO, REQUISITION, AP, AR, FA, GL, ISUPPLIER, IPROCUREMENT, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader.

Techno Functional Consultant & OM Module Lead

Confidential

Responsibilities:

• Designed the solution designing approach as per client requirement involving custom form design for Pick Release, Ship Confirm.
• Worked on Item Conversion, Customer Conversion.
• Worked on Custom Forms and Reports. Designed different Oracle XML Publisher Reports.
• Worked on OM and SCM modules.
• Worked as a Technical Consultant and solution lead.

Environment: Oracle EBS R12, PO, REQUISITION, OM, AR, INV, GL, IPROCUREMENT, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader.

Technical Lead Consultant

Confidential

Responsibilities:

• Worked as an Application Developer and worked on complicated Interfaces and conversions.
• Developed two conversion objects on Process Manufacturing formula and costing formula for Bill of Material.
• Actively worked on Purchase Order conversion and Blanket Purchase Agreement conversion. Actively worked on 2 custom reports on purchasing and GL using oracle BI publisher.
• Worked on few interfaces on Oracle HRMS and Payroll module.

Environment: Oracle EBS R12, PO, REQUISITION, AP, AR, INV, GL, IPROCUREMENT, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader.

Technical Consultant

Confidential

Responsibilities:

• Worked as an application Developer and worked on multiple complicated Interfaces and conversions.
• Developed one complicated interface for Supplier Creation, Updating as well as TAX Details and Bank Details.
• Worked on 4 reports using Oracle XML publisher on different modules like AP, AR, GL and HRMS.
• Worked on Employee Assignment Interface, Oracle BI Reports.
• Deputed to client site at London, UK for developing as well as defect resolution for RICE objects during pre-go-live testing phases and stayed till go-live and post production support completed.
• Actively worked on all the customizations related to iProcurement modules.

Environment: Oracle EBS R12, PO, REQUISITION, AP, AR, INV, GL, IPROCUREMENT, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Oracle 10g, PL/SQL, TOAD, SQL Loader.

Technical Consultant

Confidential

Responsibilities:

• Worked as an application Developer and worked on lots of complicated Interfaces and conversions.
• Worked on PO conversion, Receipts Conversion, Report on iExpense, Project Conversion and Employee Conversion and Employee Re-hire Conversion. Worked on extensions on employee termination and other objects on HRMS module.
• Worked on AP, PO, PA and HRMS modules.