SUMMARY

• 9 years of experience as a Techno/Functional Oracle EBS Consultant.
• Expert in Oracle Applications R11i /R12 using Oracle SQL/PLSQL, Oracle Developer Suite (Forms and Reports), Oracle XML/BI Publisher and Oracle Workflow.
• Experienced in working with the Business to gather requirements.
• Multiple full Life Cycle implementations, rollouts and upgrade projects from 11i to R12.
• Experienced in: Order to Cash, Procure to Pay, Operations and Record to Report - GL, AP, AR, CM, SLA, iExpense, PO, Service Contracts, EAM, FAH etc.
• Proficient in RICEWF - Reports, Interfaces, Conversions, Forms, Workflow development and customizations
• Expertise in Report Development and customization, XML/BI Publisher and Discoverer
• Gathered detailed requirements, designed, developed complex interfaces. Developed conversion programs (with external packages) to import data from various legacy systems into Oracle Applications using PL/SQL, SQL*Loader
• Experience in UNIX and shell scripting.
• Proficient in Oracle Fusion, Forms 10 g, Workflow
• Experience in preparing AIM documents like MD050, MD070, CV040, CV060 etc.

TECHNICAL SKILLS

Technology Experience: Oracle Fusion, RDF, BI Publisher, XML Publisher Reports, Conversions, Extensions, Interfaces, Forms, Workflows, Shell Scripting and UNIX functions.

Functional Experience: Order to Cash, Procure to Pay, operations and Record to Report - GL, AP, AR, CM, iExpense, PO, Service Contracts

Databases: Oracle 11g, Oracle10G & Oracle 9i, SQL Server

Tools: Oracle Reports Developer, Oracle Forms Developer, Oracle Workflow Builder, SQL Developer, TOAD, SQL Loader, Clear Quest, Clear Case, Kintana, Visual Source Safe, HP Quality Centre

PROFESSIONAL EXPERIENCE

Confidential, Folsom CA

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• Analyzed legacy data, identified gaps, interacted with business, completed functional setups, technical design, development and implementation.
• The areas of development were in the Financials domain across the modules of General Ledger, Sub Ledger Accounting, Accounts Payables, Accounts Receivables and Cash Management.
• Lead Mock conversions, SIT and UAT confirming sign off from business.
• The RICEF components worked on are Conversions, Interfaces and Reports (Discoverer and XML) using SQL, PLSQL, advanced PLSQL, UNIX and Public and Private API.
• Solution design for master and sub ledger data and period wise reconciliation framework coupled with wrapper programs for performance enhancement of Create Accounting.
• Reconciled data across modules for a period of 20 years with numerous challenges including 11i data anomalies, historic undocumented account changes and business operations permissible in very old versions of Oracle Applications.
• Extensively worked on accounting principles, account analysis and account reconciliation between 11i and R12 in accordance to Trial Balance reports and other accounting methodologies.
• Detailed analysis of explain plan, trace files and tk profs for performance tuning along with use of parallel hints, gather statistics and customized wrapper for standard programs for performance enhancement.

Environment: Oracle Applications E-Business, Oracle R12, Oracle Financials (GL, AP, AR, CM, Sub Ledger Accounting (SLA), BI (XML) Publisher, Discoverer, SQL, Pl/SQL, RICE, Reports, Data Conversion, Extensions, Interface, API.

Confidential, Chicago IL

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

• Hands on Technical Lead for defect handling team and delegated work to team members and helping them resolve issues and conducted reviews on their deliverables.
• Lead detailed analysis of requirement gathering, assistance in preparation of functional POC documents, preparation of technical definitions, development of components coupled with detailed testing and preparation of test scripts and migrations across environments.
• Oversaw the development activities including Technical Designs, Data Conversion, Interfaces integrating application to third party systems (Concur, ADP, and GLOBE), Extensions and Reports.
• Gathered requirements and developed conversion designs for Invoice to Asset.
• Coordinated with the Bank for Integration activities for the Automated Payment Interfaces
• Developed Check printing Function directly from R12 Oracle.
• Developed Lockbox Integration for both the EDI and the Check Lockboxes with Bank of America design and development.
• Developed Bank statement Integration
• Worked on BI (XML) Publisher aligned with bursting functionality for Remittances Advices and other custom reports.
• Developed shell scripting for automating multiple file process in conversions and interfaces, encrypt and decrypt files, automate email functionalities. Developed Web ADI templates for GL Conversion
• Developed Discoverer Reports for various Supplier Bank Details and Custom Inbound Interfaces details capturing
• Customized SLA per client future needs
• Wrote Test Cases, Test Scripts, and Test Data and perform the testing using automated tool (Rational Quality Manager)
• Lead the System Integration Test, User Acceptance Test, Regression Test and any other future test cycles.
• Onsite lead for Offshore & Oracle Support to resolve defect identified during testing.

Environment: Oracle Applications E-Business, Oracle R12, Oracle Financials (GL, AP, AR, FA, CM, Sub Ledger Accounting (SLA), POC, EDI, BI (XML) Publisher, SQL, Pl/SQL, RICE, Reports, Data Conversion, Extensions, Interface.

Confidential, Long Island NY

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• Lead the development activities: including Technical Designs, Data Conversion, Extensions and Reports.
• Lead the development team for Data Conversion, Extensions and BI (XML) Publisher Reports.
• Gathered the requirements for the developments of custom components.
• GL conversion,
• Supplier Conversion,
• Payables related BI (XML) Publisher Reports (Supplier Bank Account, Invoice Register), General Ledger (Currency Rate, Audit AR Transaction)
• General Ledger related custom interfaces (ADP to GL, Concur to GL),
• General Ledger related custom extensions
• Developed shell scripting for automating multiple file process in conversions and interfaces, encrypt and decrypt files, automate email functionalities
• Designed and developed Web ADI templates for GL Conversion.
• Built multiple new RTF templates for Standard Purchase Order, Blanket Purchase Agreement and Release Blanket and attach to the respective operating units using BI (XML) Publisher
• Developed multiple Public and Private API’s for Supplier, Supplier Sites, Bank Account Assignments Creation
• Preparation of unit test cases and installation guides.
• Worked with project team, Offshore & Oracle Support to resolve defect identified during testing.

Environment: Oracle Applications E-Business, Oracle R12, Oracle Financials (GL, AP, AR, FA), RICE, BI (XML) Publisher, SQL, Pl/SQL, Reports, Data Conversion, Extensions.

Confidential

Senior Oracle Applications Technical Consultant

Responsibilities:

• Developed Technical Designs, Data Conversion, Interfaces integrating application to third party systems, Extensions and Reports.
• RICE Development include:
• Conversions
• Lockbox Integration for both the EDI and the Check Lockboxes.
• Custom Extensions to integrate various modules within Oracle.
• Worked on (part of the team) that implemented Fusion Accounting Hub (FAH) and involved in end to end data flow from external systems and Oracle to Fusion through various extensions and supporting reports.
• Converted the GL and Supplier information
• Developed Payables (AP) related BI (XML) Publisher Reports (Supplier Bank Account, Invoice Register).
• Developed Receivables (AR) related BI (XML) Publisher Reports (Open Invoices Aging, Transaction Register Detail)
• Developed General Ledger related BI (XML) Publisher Reports (GL Journals and Sub Ledger, Trial Balance Detail).
• Worked on Enterprise Asset management (EAM) related custom interfaces (Revit Space Management).
• Worked on Fusion Accounting Hub related custom design (Create Events, FAH detail Error Framework)
• Lead for General Ledger related custom interfaces & extensions
• Developed Payables related custom interfaces (Concur Supplier, Concur Payment)
• Developed HRMS and Payables integration related custom extensions through IExpenses
• Developed PO Approval Workflow

Environment: Oracle Applications E-Business, Oracle R12, Oracle Fusion, FAH, Oracle Financials (GL, AP, AR, FA, CM, Sub Ledger Accounting), IExpenses, HRMS, Enterprise Asset management (EAM), RICE, BI (XML) Publisher, SQL, Pl/SQL, Reports, Data Conversion, Interfaces, Extensions, EDI.

Confidential, Pittsburgh, PA

Oracle Apps Technical Consultant

Responsibilities:

• Analysis of functional specifications and evaluating the technical feasibility.
• Lead in detailed analysis of requirement gathering, preparation of technical definitions, and development of components.
• Designed Conversions, Custom Reports, Custom Extensions to integrate various modules within Oracle Custom Interfaces to integrate various third party systems to Oracle
• Worked on Transfer to Base Approval Workflow.
• Developed Cost Breakdown Report and Revit Space Management Interface in Enterprise Asset Management (EAM) module
• Developed shell - scripting for automating multiple file process in conversions and interfaces, encrypt and decrypt files, automate email functionalities.
• Worked on functional areas of Procure to Pay, Order to Cash and Record to Report
• Prepared unit test cases and installation guides and Migration of components across various instances.

Environment: Oracle Applications E-Business, R11i, Supply Chain Management (SCM), Enterprise Asset management (EAM), RICE, BI (XML) Publisher, SQL, Pl/SQL, Reports, Forms, Data Conversion, Interfaces, Extensions, Workflow, Shell Script.

Confidential

Oracle Applications Developer

Responsibilities:

• Developed PL/SQL procedures to get the legacy data into oracle staging tables
• Developed triggers to perform the validation as and when the data comes into staging tables
• Reviewed Technical Design Documents and Code. Developed the SQL script to do the proper validations on the data from Legacy in staging table.
• Developed PL/SQL procedures and functions to run the Process Order API after successful validation of the data from legacy system
• Unit testing of developed Components. Gave support for the developed components after implementing in production and fixed the issues that were discovered.

Environment: Oracle Applications E-Business, SQL*Plus, SQL*Loader, TOAD, PL/SQL Developer and Test Director.