SUMMARY

• Over 8+ years of experience in Design, Development and Implementation of Oracle Applications. Worked extensively as Oracle Apps Techno - Functional Consultant in modules Oracle General Ledger (GL), Oracle Account Payables (AP), Oracle Account Receivables (AR), Oracle Fixed Assets (FA), Order Management (OM), Purchasing (PO), Projects (PA), Workflow, forms and System Administration.
• Experience in ERP Oracle Application E-Business suite (12.0.3, 12.0.6, 12.2.2)/11i (11.5.8, 11.5.9,11.5.10)/11.0.3.
• Proficient in developing Procedures, Functions, Packages, Triggers, Materialized Views, Synonyms, Sequences and other database objects using SQL and PL/SQL.
• Strong analytical and technical skills with good programming experience in SQL, PL/SQL and UNIX shell scripting.
• Excellent skills in Application Development using Oracle Developer (Forms 10g/11g and Reports 10g/11g), TOAD, SQL Loader utilities.
• Extensively Worked on Custom Reports as per business requirement by using the XML publisher/BI Publisher Reports.
• Developed various reports using Discoverer 10g in different Oracle Financials modules.
• Experienced in developing and customizing new/existing Forms and Reports according to client specification to suit improvised business processes forms personalization and customizations.
• Involved on Upgrading of R11i to R12.
• Worked on End to End in R12 implementation.
• Good Exposure on Approval Management system (AME).
• Strong experience in designing, developing and troubleshooting developing Reports, Interfaces (Inbound & Outbound), Conversions, Extensions & Workflow (RICEWF) in Oracle Applications.
• Running different type of Interface programs like Auto-Invoice, Auto-Lock Box etc in Financials.
• Modified packages, procedures, functions and triggers for designing user interface.
• Strong Technical consultant in implementing, supporting and maintaining procure to pay (P2P) and records to reports (R2R) process.
• Good understanding Business Flows like in P2P and O2C.
• Running different type of Interface programs like Auto-Invoice, Auto-Lock Box etc in Financials.
• Experienced in creating Functional and Technical documents (MD 50, MD60 and MD70).
• Have very strong analytical and communication skills. Structural and methodical in approaching a problem.
• Work closely with business process owners to prepare, conduct CRP/UAT, and address any Technical or functional issues.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications EBS R 12/11.5.10/11.5.9/11.5.7/11.0.3 , Oracle Financials (GL, AP, AR), PO, INV, OM, Application Developer, System Administrator.

Tools: Reports 11g/10g/6i, Forms 11g/10g/6i, Workflow Builder 2.0, TOAD, SQL*PLUS, SQL*LOADER, Discoverer, XML Publisher.

Databases: Oracle R12/10g/9i/, SQL Server.

Languages: C, SQL, UNIX Shell, PL/SQL, HTML.

OS: Windows XP/2000/NT/9x

PROFESSIONAL EXPERIENCE

Confidential, Belmont, CA

Sr. Oracle Application Techno Functional Consultant

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation to implement the Oracle R12.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Financial Modules (AP,AR,GL,FA,PO & PA).
• Worked on Technical and Functional design documents (MD70, MD50 & MD120).
• Extensively Worked on Custom Reports as per business requirement by using the XML publisher/BI Publisher Reports.
• Worked in processing of Approval management Engine (AME).
• Implemented and Testing of P2P, O2C and R2R process.
• Worked in developing Interface loading scripts extensively.
• Worked in QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
• Established effective communications with Client personnel.
• Knowledge on OA Frame work.
• Created and executed the test plans and test scenarios to validate systems design against business requirements.

Environment: Forms 10g/11g, Reports 10g/11g, SQL, PL/SQL, Oracle R12 (GL, AP, PO, FA, PA and AR), R2R, P2P), O2C, Windows 2000,UNIX, SQL*Loader, Toad.

Confidential, Monroeville, PA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Supported all go-live activities and post-production troubleshooting in Oracle R12 Environment.
• Worked as a member of the Production support system to address day to day issues.
• Worked on Technical and Functional design documents (MD70, MD50 & MD120).
• Worked in processing of Approval management Engine (AME).
• Extensively Worked on Custom Reports and forms in AP, AR, GL, PO, FA, OM modules as per business requirement by using the XML publisher/BI Publisher Reports.
• Understanding the functional requirements of the client, analysis and review of high level document mainly MD50 Functional specification and resolve the issues through functional walkthroughs.
• Coordinated with the offshore team to get the request done.
• Worked in QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
• Created and executed the test plans and test scenarios to validate systems design against business requirements.

Environment: Forms 10g/11g, Reports 10g/11g, SQL, PL/SQL, Oracle R12 (GL, AP, PO, FA and AR), P2P, O2C Windows 2000, Windows XP, UNIX, SQL*Loader, Toad.

Confidential, Houston, TX

Sr. Oracle Application Technical Functional Consultant

Responsibilities:

• Customized the Sales Order Line and Header Workflow to meet the business requirement.
• Developed Test scripts to perform business flow testing in Inventory and Order Management.
• Worked on order import interface for sales order conversion.
• Worked on PLSQL packages, procedures, and functions according to the client requirement.
• Creation of new custom reports using Oracle XML/BI Publisher in AR and AP.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, AP, AR and PO.
• Responsibilities, Menus and User Security system. Created Concurrent Programs and Concurrent executable along with Value Sets, Flex Fields.
• Studied the existing system, prepared the Technical (MD70), Migration matrix, Test results design documents.
• Meet service level agreements and performance targets related to the R2R (records to reports) process.
• Involved in Performance tuning of various queries and stored procedures.
• Worked on Tuning of queries of the Custom Reports to improve the performance utilizing diagnostic tools (Explain Plan).

Environment: Oracle Applications R11i (GL, AP, PO, FA and AR), P2P, R2R OM, PLSQL, SQL loader, SQL*Plus, BI Publisher and Reports 10g, TOAD and Oracle Discoverer.

Confidential, Montvale, NJ

Sr. Oracle Application Techno-Functional Consultant

Responsibilities:

• Experience on working of Developing New XL and PDF based Reports using BI publisher as per the Client Requirement in AR, GL, AP, HR, FA and PO modules.
• Worked On Inbound and Outbound PL/SQL Interface Programs.
• Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL FILE Package.
• Good Experience on Customization of Oracle Forms and Report 10g.
• DevelopedData ConversionsandInterface Programs. UsedSQL * Loaderto Load Data into Oracle Database.
• Worked On creating the Data Template and Date Definition in XML Publisher.
• Created some custom tables using TOAD or SQL* Plus, developed control files to load the data into the Oracle system using SQL*Loader.
• Good working Knowledge on BI Publisher or XML Publisher.
• Worked R12 Schema on Financial Modules like AP, AR, PO and GL.
• Worked on forms and reports on P2P and R2R cycles.
• Experience on Working of PVCS Tool.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70), Migration matrix, Test results design documents.
• Worked on PLSQL packages, procedures, and functions according to the client requirement.
• Experience on Working of Oracle Discoverer Reports 10g.

Environment: Oracle Applications R12 (GL, AP, PO, FA and AR), PLSQL, SQL loader, SQL*Plus, BI Publisher, P2P, R2R, Oracle Forms and Reports 10g, TOAD and Oracle Discoverer.

Confidential, Parsippany, NJ

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked on the complete Auto lockbox setup process in Account receivables.
• Worked with creating executable, concurrent programs, request set, Request Group, Value set in Account Receivables (AR).
• Worked on creating the control file and UNIX shell script program.
• Involved in analysis, design, coding, testing and implementation of the entire project.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70), Migration matrix, Test results, Business requirement (BR100) design documents.
• Worked on lockbox process steps like how to import the data, validation and post quick cash in AR.
• Created the UNIX shell script program in such a way that schedule the process and send the notifications from the concurrent program.
• Worked on Supplier remit advice file (SRAF) configuration settings, File transmission information and file specifications.
• Performed problem analysis, debugging and coding as part of production support and new development.
• Involved in documenting user requirements, technical specification and reporting manuals.

Environment: Oracle Applications R11i (GL, AR), PLSQL, SQL loader, SQL*Plus, BI Publisher, AOL, TOAD and Workflow Builder.

Confidential, Denver, CO

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in analysis, design, coding, testing and implementation of the project.
• Used various Triggers and Procedures to validate data at each level.
• Created some custom tables using TOAD, developed control files to load the data into the Oracle system using SQL*Loader.
• Developed Forms and Customized Forms to meet the Client requirement mainly in Financial Modules (GL, AP, AR and FA) using Oracle Forms.
• Worked with creating executable, concurrent programs, request set in General Ledger (GL) module, Account Receivables (AR).
• Worked on the complete Order to Cash cycle modules including Order Management, Inventory and Shipping.
• Worked on order import interface for sales order conversion.
• Customized Application by creating Menus, Request Groups and Setting up Forms, Form Functions and attaching to menus. Reports by registering in Concurrent Executable and Concurrent Programs.
• Developed oracle forms, PL/SQL stored procedures, SQL scripts and functions to provide customers.
• Involved in design, development & implementation of Oracle Application modules AR, AP & PO.
• Studied the existing system, prepared the Functional (MD50), Technical (MD70) design documents.
• Developed interface program to close old Purchase Orders in the ERP system.
• Developed PL/SQL Packages and Database Triggers.

Environment: Oracle Applications R11i (PO, AP, GL, AR), OM, INV, Oracle 10g, Forms, Reports, PLSQL, SQL loader, SQL*Plus, BI Publisher, XML, TOAD.

Confidential, Carlsbad, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in design, development & implementation of Oracle Application modules AR, OM, INV & PO.
• Customized the Sales Order Line and Header Workflow to meet the business requirement.
• Developed SQL * Loader programs to load data from flat file to stage tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.
• Worked on order import interface for sales order conversion.
• Worked on Sales Order API for editing sales order data.
• Worked on Upgrading of R11i to R12.
• Performed problem analysis, debugging and coding as part of production support and new development.
• The Pharmacist Verification stage of workflow has an additional option to Verify the Patient, Drug/Mixture, Doctor and Rx individually
• Customized sales order form based on the business requirement.
• Providing troubleshooting assistance to all issues and concern related to oracle forms.
• Modified packages, procedures, functions and triggers for designing user interface.
• Written interface programs for AR customers, AR invoices.
• Involved in the complete Order to Cash (O2C) and Procure to pay cycle (P2P).
• Studied the existing system, prepared the Functional (MD50), Technical (MD70) design documents.
• Wrote common Packages and Procedures, Registering them as Concurrent Programs in Oracle Applications which helped the team members.

Environment: Oracle E-Business Suite R12 (OM, INV, AR and PO), Oracle 10g, Oracle Developer 10g (Forms 9i/10g, Reports 9i/10g), BI Publisher, Workflow Builder 2.6, TOAD, SQL*Loader, SQL*Plus, PL/SQL.

Confidential, South Park, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for validation of the invoices and payment information from the legacy system to import into Oracle Application.
• Worked on customizations of custom reports, XML reports, packages, functions, and triggers, workflows in the areas of OM, INV, PO, and AR.
• Worked on the complete Order to Cash cycle modules including Order Management, Inventory, Shipping and Receivables.
• Designed and Developed PL/SQL Packages to import AR Invoices and AR Receipts legacy information into Oracle.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * Loader.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Modified, maintained and developed the SQL codes to develop new enhancement in oracle forms.
• Involved in preparing technical and functional documentation (MD50/MD70) for Packages, Procedures, Reports, and Workflows, etc.
• Registration of customized Reports through creation of concurrent executables, concurrent programs, assigning to Request Group.
• Involving in the complete Order to Cash and Procure to pay cycle.
• Reports and using various templates to publish the reports as per user requirements.
• Involved in AP Invoices Conversion, Customer Conversion, and Vendor Conversion and AR Invoice Conversion.
• Responsible for design and development of screens/reports using Oracle Forms/Reports.
• Developed Interface programs to load order information from legacy system-to-system tables. Interim Tables created to hold the data from the flat file. This was done to load data in CSV file obtained from the External system..
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Developed oracle forms, PL/SQL stored procedures, SQL scripts and functions to provide customers.
• Tested and Fixed bugs in existing Forms & Reports.
• Developed interface program to close old Purchase Orders in the ERP system.
• Defined payment terms, locations, and Invoice approvals and setting up account information in Oracle Financials AP.
• Customized Requisition Approval and PO Approval workflow for Procurement.

Environment: Oracle Applications R12/11i (PO, AP, OM, GL, AR), Iproc, PLSQL, SQL loader BI Publisher, XML, Discoverer, TOAD, forms and Workflow.

Confidential

Software Programmer - Oracle Developer

Responsibilities:

• Involved in analysis, design, coding, testing and implementation of the project.
• Creation of the database objects like tables, views, constraints, procedures, packages using Oracle tools like SQL*Plus and PL/SQL.
• Developed expense reports for monthly and yearly salary comparison reports using Oracle Reports 6i.
• Responsible for stored program development using PL/SQL packages, procedures, functions and triggers.
• Extensively involved in designing the project and coordinating a highly professional team.
• Provided training to end users on FORMS and REPORTS.
• Implemented the business logic by Oracle Stored Procedures/Functions in the backend.
• Responsible for requirements analysis, creating E-R diagrams, table design, database creation, preparation of program specifications, GUI design.
• Used various Triggers and Procedures to validate data at each level.
• Involved in upgrading from Oracle 7.x to Oracle 8i. Involved in technical and user documentation.

Environment: Oracle 7.x/8i, SQL, PL/SQL, Forms 6i, Reports 6i, Windows 98.