SUMMARY

• Over 8+ years of IT experience in design, development & maintenance of Oracle E - Business Applications as a Techno-Functional consultant in various modules like General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Order Management (OM), Inventory (INV), Shipping (WSH),Discrete Manufacturing (ODM), Process Manufacturing (OPM), Advanced Pricing (QP), AOL objects and I-Procurement.
• Expertise in system study, development, maintenance, upgrades, production and support of E-Business suite applications using Oracle Applications R11i/R12.1.3 and Oracle databases (10g, 11g).
• Extensive experience in using SQL, PL/SQL, Developer 2000/6i/9i, SQL Loader, Discoverer3i/4i/9i, EDI 810/850/856, Workflow, Oracle 9i/10g/11g, Unix, and Linux.
• Expertise in RICEW - Reports, Interfaces, Conversions, Extensions and Workflow.
• Extensive experience identifying product gaps coordinated with development team by creating, managing and resolving TAR/SR and obtained one-off fixes.
• In depth knowledge in creating complex Procedures/Functions and packages to handle validations for various data loads and Error-Handling packages to handle user-defined errors.
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Future Business Mapping Document (BP-80) and Business Requirements Mapping Documents (BR-100) user training manuals, test procedures document preparation.
• Experience in writing Procedures, Packages, Functions, Forms, Triggers, Views, Records, Constraints and other database objects using SQL and PL/SQL.
• Involved in full cycle implementations with experience in requirements gathering, functional gap analysis, application design, configuration, conversions, module setup, test script generation, writing training guides, training end users, and production support.
• Good knowledge on customizing and personalizing approvals using Oracle Approval Management (AME).
• Proficient in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.,
• Worked on AOL modules for creating Concurrent Executables, Concurrent Programs and Setting Profile Options as per the requirements.
• Strong knowledge of business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles along with the integration between various Oracle Applications modules.
• Experienced in Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing and Trouble Shooting.
• Experience in Oracle interfacing programming, Concurrent Manager, Flexi fields, Value sets and Form Personalization.
• Performed fit gapanalysiswith extended team and documenting thesame. Analyzing the Gaps and fixing the Gaps which also need coordination with Oracle Support.
• Possess excellent communication skills, good team-management and leadership qualities and can work independently or collaboratively in teams.

TECHNICAL SKILLS

ERP Skills: Oracle Applications R12.1.3/11i Application Object Library (AOL), Inventory (INV), Order Management (OM), Bill Of Materials (BOM), Accounts Receivables (AR), Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Sub-ledger Accounting (SLA), Fixed Assets (FA), Cash Management (CM), TCA, Financials, Order-to-Cash(O2C), Procure-to-Pay(P2P), Supply Chain.

Languages: SQL, PL-SQL, Java

Web Technologies: HTML, DHTML, XML, JSP, JavaScript

Data Loading Tools: Data Loader, SQL*Loader, TOAD, SQL Developer

Misc Tools: Kintana, PVCS, VSS, Quality Center

GUI: Oracle Forms, Oracle Reports, TOAD, Oracle Workflow Builder, Discoverer, JDeveloper, UIX, XML Publisher, PL/SQL Developer, SQL*Plus.

RDBMS / DBMS: SQL, PL/SQL, Oracle 10g/11g, SQL Server 2000, MS Access

Operating Systems: Unix, Windows Vista/XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle Apps Techno-functional Consultant

Responsibilities:

• Oracle Financials Enhancement for AP, AR, GL, FA, PA & EBTax.
• Involved in requirement Analysis, Design and Development.
• Involved in Data Migration from Legacy system to oracle application.
• Created Concurrent Programs, Executables, Parameters and Value Sets through backend process (API) development.
• Implemented interface development in Financials Modules. Defined an operating unit using theAccounting Setup Manager of MOACin Oracle General Ledger in oracle inventory.
• Accountable for the entire project lifecycle spanning scope, design, build, test, rollout and warranty support using Oracle's AIM Methodology.
• Developed and maintained productive business relationship with customers.
• Defined Payment terms, Purchasing options, request sets and bank accounts.
• Extensively worked on Fixed Assets FA, Project Accounting PA (Billing, Costing and Management).
• Developed new Extensions, Interfaces and Concurrent Programs in R12OracleApps.
• Involved in effort estimation, consolidation of project plans and participating in status calls.
• Worked on billing/pricing related incidents and service requests, ensuring the tickets are closed within the SLA.
• Focus on mitigation of risks based on requirements, review of documents, designs & deliverables (RDs, MDs, TEs).
• Responsible for functional set up of new modifiers and generic qualifiers as per the business requirement.
• Coordinate testing and rollout of projects with the user community and render post production onsite support for the client.
• Involved in revising and approving Change Requests(CRs), PCOs, and COs .
• Developing RICE components - Reports, Interface, Conversions, Extensions.
• Supporting Iexpenses, iprocurement, transactions, integration. OAF personalization's as per the user requirement.
• Development/modification of custom reports in purchasing and payables.
• Co-ordination with development team on testing and deployment activities.

Environment: Oracle R12.1.3, Oracle AP, AR, GL. FA, CM, PA, EBtax, Iexpenses, purchasing OM, PO, INV, MOAC, Oracle 10g, SQL, Pl\Sql, JAVA, Unix OS, Toad, Action Request system Remedy, Quality center, Version Control tool: PVCS, Issue Track

Confidential, Englewood, CO

Oracle Apps Techno-functional Consultant

Responsibilities:

• Created technical design, coding, prepared unit test plan, configuration guide and unit testing for RICE (Reports, Interfaces, Conversions and Extensions) components.
• Customized various forms in Oracle Payables (AP), Oracle Inventory (INV), and Oracle Receivables (AR).
• Built custom forms from TEMPLATE to invoke the “ZOOM” functionality and Multi-Zoom functionality for INVIDITM form in the Inventory module for the multi-zoom functionality.
• Developed various Discoverer reports in Discover Plus and granted access to users, so that users can access the reports directly from the view integrated in oracle applications.
• Implemented single responsibility to multiple operating units using MOAC’s MO Security profile.
• Responsible in creating new suppliers, supplier groups, lookup codes, Pay groups, and Payment terms as per payable options along with Bank Accounts in Accounts Payables (AP).
• Developing various Interfaces, both inbound and outbound and implemented various Data.
• Performed code migration across different instances like Production, Development and Testing.
• Defined flex fields using Application Object Library (AOL). Registered Concurrent Programs and standard request submission in AOL during the process of development.
• Worked on Purchase Order Import Interface, the interface validates Purchasing & inserts into Interface Tables & calls Import Standard Purchase order program & creates Purchase Orders.
• Responsible for implementation of Order Management (OM), Account Payables (AP), Account receivables (AR), General Ledger (GL).
• Analysis of Functional (MD050) & Technical (MD070) Specifications and appropriate modification on modification of concerned object.
• Involved in Analysis of Requirements document & also in complete Order to Cash(O2C) cycle.
• Responsible for developing Custom Packages, Procedures and Functions using PL/SQL.
• Configured financial, purchasing and receiving options in oracle purchasing (PO) module.
• Developed Interfaces for data migration from Legacy System to Open system in GL, using SQL*loader, UTL File.
• Worked on Version Control software to check-in codes and integrated with Kintana for file migration. Used FND LOAD to migrate Concurrent programs, Request sets, form menus and personalization, by downloading the LDT files.
• Viewing, Sorting, Updating, and Managing of Query Tickets on Kintana.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Involved in various client weekly status meetings, providing updates on the existing development work and future scheduled work.
• Created Test Scenarios, Test Cases, Use Cases and suggested changes as required ensuring proper functionality testing.
• Also worked as an Oracle System Administrator for the project with major activities including Viewing Concurrent Programs, Managing Users, Responsibilities, and Profile Settings, Running weekly scripts, and managing with the DBAs.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, OM, INV, BOM, WIP and PO), purchasing, MOAC, Oracle 10g, Forms 6i/10g, Reports 10g, Discoverer 9i/10g, Workflow Builder 2.6.3.5, TOAD and Forms Data Loader.

Confidential, Chicago, IL

Oracle Apps Techno-functional Consultant

Responsibilities:

• Actively participated in the requirement gatherings phase.
• Designed and developed OA Framework Screens for Invoices from 4 different source like Service Contracts, Service Requests, Repairs and Deposits.
• Worked on fixing the performance issues in Auto Invoice.
• Has customized the Invoice Print Program in AR for Weekly & Daily Billing Customers
• Has built Custom Consolidated billing Program according to the client requirements in AR.
• Worked on developing Custom reports using XML PUBLISHER and Report6i.
• Responsible for setting up approval rules for Vacancy and Offer letter processes in iRecruitment using Approval Management AME.
• Developed 3 custom concurrent programs to process the requests and print the invoices based on the source.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, Invoice and Expense reports using Reports 6i, Discoverer 10g.
• Developing PL/SQL code to obtain the required functionality.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Involved inManufacturingand SCM track enhancements, developments and issues mainly dealing with modules OM, INV, PO, AP, BOM, WIP, Planning and Quality.
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS, and GL JE LINES tables.
• Developed custom reports in GL: Journal Batch Summary Xml Report, Account Analysis Xml Report and AP: Invoice on Hold Xml Report, Supplier Paid Invoice History Xml Report etc.
• Developed SQL scripts to create temporary tables andSQL*Loadercontrol files to load theitem legacy datainto the temporary tables in R12.1.3.

Environment: Oracle Applications R12.1.3, OM, CRM Foundation, TCA, Service Contracts, MOAC, Tele-service, Field Service, AR, Oracle 10g/ 9i, Linux, TOAD 8.0, Shell Script, Oracle Discoverer, Java, JSP, JDeveloper, OA Framework.

Confidential, Columbus, OH

Oracle Applications Technical Consultant

Responsibilities:

• Developed code for Conversions to extract legacy journals and to load them to GL Interface tables using Journal import.
• Built custom forms using Oracle Forms 10g Builder to fulfil the business requirements of the client.
• Experienced in validation and defaulting, processing constraint checks and releasing order holds and scheduling of shipments using Order Import interface on OE ORDER HEADERS ALL, OE ORDER LINES ALL.
• Populated data into table OE HEADERS IFACE ALL which is a multi-org table for Sales Order Headers Open Interface.
• Worked on the customization of forms, which included development of new forms and customization of the existing forms in Order Entry and Inventory, AP and PO.
• Designed and developed a single interface program to import invoices into Oracle Payables from three different sources and registered this as a single concurrent program which was used by these sources.
• Expertise in implementation of order to cash life cycle. Implemented newly introduced MOAC standards for allowing single responsibility to multiple operating units.
• Involved in customization of several standard reports to serve important business processes very specific to the client which include Invoice on hold report, vendor, payments, and analysis reports in AP, and also Customer receipts, invoice, and adjustment reports in AR.
• Used the features of BI Publisher such as Sort, Group, Total, Subtotals to make data intense operations happen at the template level.
• Created customer invoices, credit memos, debit memos and account credits using auto invoice interface in account receivables
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed a report, which showed requisition details, purchase order details, receiving details, invoicing details and payment details in Oracle Procure to Pay Cycle (P2P).
• Implemented interfaces to a third party application using application API’s. These interfaces where used to provide seamless access to a third party application from within our application. This resulted in utilizing the processing abilities of another application without modifying it or redeveloping it.
• Developed data entry forms, complex and template forms in Forms 10g.
• Developed control files to transfer data to staging table using SQL*Loader and validate the date for the Standard Items in INVENTORY and load the data using item import interface to MTL SYSTEM ITEMS B table.
• Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best performance. These were used in large data conversion scripts, to process records within a procedure or package before updating them to the database.
• Tested Interface and conversion objects and trouble shouted many issues in testing phase and documented the whole process to report to management.
• Developed RICEW development matrix to support cutover plan and project management planning and status Reports to executives.
• Worked extensively to import sales orders to oracle applications using sales order conversion i.e., order import interface.
• Enhanced performance of large complex SQL queries using SQL performance tuning methods such as explains plan and hints. Based on the results of explain plan, appropriate Index were created and joining clauses used.

Environment: Oracle Applications Suite R12.1.3 (AP, OM, QP, AR, GL, INV, PO and AOL), MOAC, Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, Oracle BI Discoverer 10g, SQL*Developer, SharePoint and UNIX.

Confidential, Carlsbad, CA

Oracle Applications Technical Consultant

Responsibilities:

• Wrote script to import customer information from legacy system into Receivables using SQL*Loader and PL/SQL.
• Developed program to load external data from legacy system using SQL*Loader into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables.
• Worked on customizing standard Lockbox Interface for Receivables.
• Customized multiple reports and forms in GL, AP, AR and OM modules according to the requirements.
• Interacted with users and analyzed their requirements to develop custom code, forms and reports as per their need and registered with application.

Environment: Oracle APPS 11.5.10, Oracle, PL/SQL 2.3, SQL* Loader, TOAD

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Implementation involved various modules like AP, AR, PO, GL, OM and INV.
• My role included developing conversions for modules PO, AP and several reports and other enhancements.
• Developed an extract script for the uninvoiced receipts data from legacy system.
• Worked on AP Invoices Conversion to convert the paid invoices data.
• Designed and developed Staging tables, Conversion routines and Custom PL/SQL API’s for Customer Import, Order Import, Open AP Invoices and Item Import.
• Designed, Documented and Developed an interface between third party billing system to General Ledger, to post the journal every week from the billing system.
• Developed an UNIX shell script which calls SQL Loader program to load data into custom staging tables and checks for uniqueness of the files in UNIX directory to avoid duplicate data and to archive the same.
• Worked on Discoverer Administrator, Desktop, Plus and Viewer as part of the development of the above reports.
• Created new business areas, custom views, new folders, custom folders, complex folders, conditions, materialized views and joins in discoverer according to user requirements.
• Worked with Oracle Workflow Builder to develop new processes and customized the existing workflow process.

Environment: Oracle Applications 11.5.10 (AR, AP, GL, OM, PO, INV, BOM, WIP), Reports 6i, Forms 6i, Discoverer, Toad, SQL Loader, XML Publisher, PL/SQL Developer, SQL*Plus, TOAD, Workflow Builder.