PROFESSIONAL SUMMARY:

• Around 8 years of Professional experience on Oracle Applications (10.7 / 11.0.3 / 11 i/ R12) as an Oracle Applications Functional & Technical consultant involved in Analysis, design, development and customizations.
• Expertise in Design, Development of RICE (Reports, Interfaces, Conversions and Enhancements) components.
• Excellent Live experience in Implementation and Production Support of Oracle Applications Advance Supply chain planning (ASCP), Order Management (OM), Inventory (INV), Shipping, Work in Process (WIP), Account Receivables (AR), Account Payables (AP), Purchasing (PO),Fixed Assets, Project Accounting (PA), and thorough knowledge of how the various sub ledgers post into the General Ledger (GL).
• Worked with new implementation and data migration projects in supply chain, manufacturing and financial modules. Worked with the implementation team of Order To Cash and Procure To Pay cycles.
• Excellent experience in complete project life cycle implementation involving Pre - Implementation Analysis & planning, business requirement analysis, gap analysis & resolution.
• Excellent experience in developing Reports using OracleReports 6i/10g and XML Publisher .
• Excellent experience in customization and development, Forms and Workflows using Forms 6i/10g and Workflow Builder, Experience with Oracle Applications Framework 5.10.
• Experience in using Oracle Discoverer 4i/9i/10g Administrative Edition and Discoverer Plus and Viewer, configuring discoverer and End User Layer (EUL).
• Excellent programming skills in Stored Procedures, Packages and Oracle(PL/SQL including Triggers and Functions).
• Excellent experience in Design and development of Interfaces and Data Migration using SQL*Loader, Oracle open interfaces, database triggers, procedures, interface tables, APIs and UTL Files Good experience in Oracle Applications 11i Application Object library (AOL).
• Experience in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus, reports and printers.
• Responsible for various phases of OracleApplications like Technical Design and Development, Testing, Documentation, post implementation support.
• Great Learning skills to adapt the rapid changing technologies and implementing the same at work.
• Excellent Inter-personal skills. Ability to get along with the team well, and can handle client issues at all stages of the development process.
• Good Knowledge of Multi organization Access control (MOAC) architecture.
• Good understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Adequate knowledge of R12 technical stack.

TECHNICAL SKILLS:

Packages: Oracle E-Business Suite 11i

ERP/Modules: AR,AP,PO,GL,OM,FA,INV,SYSADMIN,AOL,WIP,MRP,BOM

Processes: Order to Cash and Procure to pay processes

Programming Languages: C,C++,SQL,PL/SQL,HTML,XML,JAVA

Development Tools: Reports 10g/6i,Forms 10g/6i,Workflow Builder 2.6,BI (XML) Publisher, Discoverer 10g/4i

Database: Oracle 8i/9i/10g, SQL,MS Access

Operating System: Windows 98/NT/2000/XP/VISTA/7, UNIX,MS-DOS

Programming Tools: SQL*PLUS, SQL* Loader, TOAD 11.0, Putty

Office Tools: MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Technology Lead

Environment: Oracle Application E-Business Suite 11.5.10.2, R12 (ASCP, OM, PO, AR, AP, BOMINV) Oracle 9i/10g, 11g, XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10g, Oracle Forms 6i/10g, Workflow Builder, TOAD 11.5.0.8, PL/SQL Developer.

Responsibilities:

• Understanding the Business Requirements to do Fit Gap Analysis and Feasibility Analysis.
• Analysis of existing system functionality of processes that would push out/pull in schedule ship dates, impact analysis and cross functional integration requirement analysis.
• Functional Solution Design and Authoring of MD50 documents.
• Technical Solution Design and Authoring of MD70 documents.
• Coordinating with Cross Functional teams like Order Management, Make, Deliver and BI.
• Coordinating with ADF technical team in providing the requirements and following up on the same to closure.
• Reviewing UAT test cases prepared by QA/Business.
• Hands on development of creating views, Materialized views, all database objects and PL/SQL Packages and code review
• Handling complex codes and designs in improving the performance by using required tune ups.
• Driving functional/technical Offshore teams for above mentioned tasks by assigning work and reviewing the same.
• Support UAT testing and defect resolution.
• Working with support teams during the release and normalization processes
• Training end users for effective usage of developed processes
• Handling Change Requests.

Confidential, Denver, CO

Techno Functional Consultant

Environment: Oracle Application E-Business Suite 11.5.10.2, R12 (APU, AR, AP, PO, GL, BOMOM, PA) Oracle 9i/10g, 11g, XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10g, Oracle Forms 6i/10g, Workflow Builder, TOAD 10.1.1.8,PL/SQL Developer.

Responsibilities:

• Oracle Applications Techno Functional consultant for Oracle R12 Advanced Pricing Unification Implementation and Production support project.
• APU is a project funded outside of the normal production support efforts.
• As Confidential is rolling out a Pricing unification initiative. We took an initiative that will require additions to the existing implementation of the Advance Pricing Module.
• Worked on the Advanced Pricing for Flight Planning product for the Commercial segment but will be adaptable to Military, Business and General Aviation.
• Developed a Flight Planning Pricing Report that will show the original list price versus selling price for orders/contracts with Flight Planning items on it.
• For the new pricing module as such the Flight planning contracts will now be entered directly into Order Management or as a contract in the Contract Module.
• Developed a new pricing module will derive a list price based on the pricing logic. The Order or contract can be changed to allow for further discounts or up charges.
• Developed a DFF Program that can be run ad-hoc or on a schedule to copy any DFF values from the line level DFF on the sales order to the sub-line on the contract for orders that originate from Order Management. Once the contract is created the concurrent program will take Orders that meet the following criteria like Context =’Flight Planning’ If attribute 10 or Attribute 11 on oe order lines all is populated then the program needs to copy the value in these fields to the contract line.
• Worked Extensively on XML Publisher Administrator for Developing the Flight Planning Pricing Report Layout for Printing Solution in Advanced Pricing Unification.
• Worked on Oracle QP CUSTOM Pricing Package and made the modifications as per the new pricing requirements.
• Developed a Custom Package for Advanced Pricing Unification (APU).
• Interacted with end users to gather requirements and draft specifications for the development phase.
• Developed a concurrent program “ Confidential AR Delete inactive bill to site use relation on ship to sites” that needed to switch out bill to reference on ship to’s when bill to is no longer valid. Occasionally, customers move their bill to locations, requiring that all ship to locations which reference this bill to must be updated. This can be a mountainous task when the customer has several hundred ship to's that reference the obsolete bill to. So I have Developed a concurrent program which can either be run by ITS or by Aviation Supervision which will either replace the bill to with a chosen new one, or can be nullified out completely.
• Developed a Custom Report “ Confidential NI RMS - Urgent Label Report” to overcome the process where the current output of the Urgent Label report is Excel and the file is modified manually and to be loaded by using word mail merge wizard. Otherwise printing is not possible on the Tally printer and that was very time consuming.
• Worked on XML Publisher Administrator for “Developing the Confidential NI RMS - Urgent Label Report Layout” for Printing Solution.
• Worked on the Account Generator workflow to Update Project Budget Account Generator to include Intercompany AutoAcctg Rule, The values should be pulled from the lookup set 'Interco Segment from Exp Type'.
• Modified Confidential Purchase Order Report Layout as such Confidential Purchasing requires that the PO output be modified to better support our internal processes and the information interfaced to the customer.
• Worked on Sales Order Zoom Form for the ship-to contact field on the sales order header and on the line should only show contacts for the account that has an active relationship to the party. This is necessary for the fix to the OM Zoom form to go into Production.
• Designed and Developed a Custom Oracle to Show BOM with cross references and Categories. The Report is a text file, comma delimited for import into Excel.
• Worked on the Development and layout of the Blanket PO and Release XML Document Errors on Item Text Attachments.
• Worked on the Custom Trigger which allows to Change Tax Code for Customers in UK org: site Trigger is firing in the time where location is not deactivated, but user need to change tax code in tax profile window.
• Developed a SQL Query to restrict the customer party name (legal entity) to 50 characters, where a global decision was made to restrict the amount of characters entered as a Party legal entity name to 50.Once the user enters 51 characters the system should not allow the user to continue. Also the new SQL query works such that no current customers have over 50 characters prior to updating production.
• Worked on Sales Order Form personalization’s to Prevent inactivation’s of bill to address if contracts exist Renewals are failing to create commitments because the bill to address on the contract has been inactivated. The customer logs in there and changes the address, which inactivates the existing address in Oracle, without regard for the services with that address.
• Involved as a team member that worked on the Oracle (APU, AR, AP, PO, GL, BOM, OM, PA) modules for the Production Support.
• Worked on the IBM rational tools such as Clear Quest and Clear Case for Data Migration and Storage into the Data Base.
• Developed Several Customized Tables, Functions, Views.
• Involved in development of Order To Cash process (credit analysis, customer billing, cash application, collection, GL posting and reporting) and Procure To Pay process (requisition, purchase order, acceptance, goods receiving, invoice, payment and reconcile).
• Customized and developed several reports in APU, AR, AP, PO, GL, BOM, OM, PA modules using Reports 10g.
• Customized and Developed Forms in AR, AP, BOM, QP modules using Forms 10g.
• Worked with DBA’s in Defining all the Custom Top’s and Migrated all the Customized Files to their respective $ TOP.
• Involved in Post Production Support for APU module and bug fixing process. Fixed bugs based on SME’s feedback and QA’s team.
• Performed the system administrator role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Request Groups for reports, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

Confidential, Miami, FL

Techno Functional Consultant

Environment: Oracle Application E-Business Suite 11.5.10.2, R12 (AR, AP, GL, FA, IEX, XTR)Oracle 9i/10g, XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10gOracle Forms 6i/10g, Workflow Builder, TOAD 10.1.1.8.

Responsibilities:

• Oracle Applications Techno Functional consultant for Oracle R12 Up gradation and Production support project.
• Involved as a team member that implemented the Oracle AR, AP, IEX, PnG, GL modules.
• Worked Extensively on XML Publisher Administrator for Eliminating the Functionality legacy presentation Formscape System for Printing Solution in R12 Upgrade Retrofit.
• Designed and Developed a custom PL/SQL Program for Printing Dunning Letters in Oracle IEX Collections using Oracle Standard Dunning Letter Print Package IEX DUNNING PUB.SEND DUNNING CONCUR.
• Customized the IEX: Send Dunnings for Delinquent Customers Program, Defined new Executable, Parameters, Value sets as per the user requirements for Upgrade.
• Customized standard Report RAXINVR for Printing New Invoices, maintaining the functionality of 11i.
• Customized Standard Report RAXINVRT for Printing Selected Invoices using Real Time Data, maintaining the functionality of 11i.
• Customized Standard Report RAXINV for Printing Selected Invoices and Print/Reprint Selected Invoices maintaining the functionality of 11i.
• Customized Standard Report ESTPLLTR for Printing Estoppel Letters for customers.
• Customized FA Period end Report for the R12 Up gradation as per the user requirement and functionality of 11i.
• Worked on setup of the new Advanced Collections module in R12 for Sending Dunning letters for Delinquent Customers.
• Customized Standard Treasury Allocation Workbench Form for calculating the Interest and Gain/Loss Allocation.
• Designed and Developed Custom Report Templates in XML publisher for Printing Invoices, Pay Checks, Estoppel Letters, Dunning Letters, FA period Report by eliminating the Legacy presentation Formscape Software for printing solution.
• Designed and Developed Single Custom Template Which can handle the Printing of Selected, New, Selected Real Time, Print/Reprint Selected Invoices all together in one using XML Publisher.
• Developed a Custom Template Query which is used for Printing Dunning Letters as per the Dunning Plan created, This functionality is new in R12 Collections.
• Designed and Developed Single Custom Template which can handle Printing all kinds of dunning letters and can be assigned to all 7 staged buckets by replacing Standard Oracle Templates as per the user requirements as such this functionality is new in R12 Collections.
• Developed GL Interface for importing journals from legacy systems into GL INTERFACE.
• Development of Interface Programs involving AR Customers Interface and Conversion programs included GL code combination Conversion program.
• Developed Several Customized Tables, Functions, Views for Upgrade Retrofit.
• Involved in development of Order To Cash process (credit analysis, customer billing, cash application, collection, GL posting and reporting) and Procure To Pay process (requisition, purchase order, acceptance, goods receiving, invoice, payment and reconcile).
• Customized and developed several reports in AR, AP, FA, PO modules using Reports 10g.
• Customized and Developed Forms in AR, AP modules using Forms 10g.
• Worked with DBA’s in Defining all the Custom Top’s and Migrated all the Customized Files to their respective $ TOP.
• Involved in Setting up the new Oracle Collections responsibility.
• Involved in Post Production Support for IEX, GL, AP, AR modules and bug fixing process. Fixed bugs based on SME’s feedback and QA’s team.
• Worked on Documentation of all the R12Upgarde Retrofit processes maintaining the standard MD70 format and training end users for effective usage of developed processes.
• Performed the system administrator role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Request Groups for reports, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

Confidential, San Francisco, CA

Technical Consultant

Environment: Oracle Application E-Business Suite 11.5.10.2,R12 (GL, FA, AP, AR, PO,OM)Oracle 9i/10g,XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10gOracle Forms 6i/10g, Workflow Builder 2.6,TOAD.

Responsibilities:

• Oracle Applications Technical consultant for Oracle R12 implementation and Production support project.
• Involved as a team member that implemented the Oracle GL,AP,AR,PO,OM modules .
• Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.
• Developed GL Interface for importing journals from legacy systems into GL INTERFACE .
• Development of Interface Programs involving AR Customers Interface and Conversion programs included GL code combination Conversion program.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Customized and developed several reports in AR, AP, PO modules using Reports 6i.
• Development of Interface Programs involving AR Customers Interface and Conversion programs included GL code combination Conversion program.
• Developed Customer Invoice, Purchase Order Report using XML Publisher.
• Implemented OAF forms personalization in iReceivables.
• Worked on iprocurement requisition and PO related workflow product related issues in with Oracle.
• Developed Vendor and Purchase order summary report.
• Customized report to obtain details on Purchasing, Receiving and Payables with in specified dates.
• Used Forms and Reports exhaustively for viewing the data extracted or uploaded into the staging tables.
• Developed Forms like invoicing, Delivery order.
• Worked on Sales Order Booking, Releasing, Ship Confirm, View Sales Invoice, Create Receipt, Remittance and View Account Balance in Order to Cash and Procure to Pay cycle.
• Involved in Post Production Support for GL, AP, AR modules and bug fixing process. Fixed bugs based on user feedback and QA’s team.
• Performed the system administrator role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Request Groups for reports, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

Confidential, Santa Clara CA

Technical Consultant

Environment: Oracle Application E-Business Suite 11.5.10.2,R12( GL, AP, OM, PO, AOL) Order to Cash, Procure to Pay.Orcale9i/10g,TOAD,PL/SQL,SQL*Loader, Reports 6i, Forms 6i, Discoverer 4i, Workflow Builder 6i.

Responsibilities:

• Developed and customizedOracle Applications Modules GL, AP, OM, PO, AR, INV.
• Interacted with end users to gather requirements and draft specifications for the development phase.
• The development includes the interface and conversion of the data from legacy systems to theOracle database and customizing reports for the client.
• Converted flat files from Excel to Data files and developed the SQL*Loader program to load the data to staging tables for Order Import program to import orders.
• Wrote packages to validate and populate the interface tables.
• Loaded the Requisitions and the Open Purchase Orders data from the legacy system to Oracle Purchasing, Developed PL/SQL program to perform data validation.
• Designed and developed the Order Import Concurrent Program in Oracle Order management to load the external order data from flat files into Oracle Order Import Interface tables. SQL* Loader.
• Developed Customer Conversion to load historical data into Oracle base tables.
• Developed Sales Order Conversion to load Historical Orders Data into Oracle Base.
• Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report.
• Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL FILE package.
• Customized Invoice Aging Report in Accounts Payable (AP) module to view the invoices unpaid in the specified time period instead of all the four time periods.
• Purchase Report Detailed Item wise allows you to have a detail study of purchases Made during a given period using XML publisher.
• Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.
• Developed Supplier Payments Report using XML Publisher.
• Designed and created custom form using Forms 6i tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU TOP on forms server of client, Customized Sales Order Form.
• Performed the whole Sales Order Cycle which includes Booking, Pick Release, Ship Confirm and Interfacing to Receivables, Inventory.
• Extensively worked on INV API's and Enhancement.
• Registered Inbound Interfaces and Reports in Concurrent Executables and Concurrent Program.
• Used Forms and Reports exhaustively for viewing the data extracted or uploaded into the staging tables.
• Customized the following Concurrent Programs and registered them in Oracle Applications using Application Object Library and System Administration modules: Physical Inventory adjustments report, Sub Inventory Listing in INV Module.
• Edited existing reports so as to add additional functionality (calculations, parameters, sorting, conditions).
• Involved in documentation and training end users for effective usage of developed packages.

Confidential, Greensboro, NC

Technical Consultant

Environment: Oracle apps 11.5.10.2(PO, AP, AR, OM, INV, GL), Developer 2000 and Oracle 9i PL/SQL,UNIX, Discoverer 9i, Reports 6i, Forms 6i, Toad.

Responsibilities:

• Involved in development of Order To Cash process (credit analysis, customer billing, cash application, collection, GL posting and reporting) and Procure To Pay process (requisition, purchase order, acceptance, goods receiving, invoice, payment and reconcile).
• Solved some of the production issues and helped the team members with the resolutions.
• Developed some custom reports that generates CSV report without using shell script.
• Personalized custom forms restricting the updating of certain fields for some users.
• Worked on registration of custom tables, programs, request sets, value sets, reports, forms.
• Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL FILE Package.
• Developed supplier Conversion to load vendor details from legacy system into Oracle Applications base tables.
• Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote PL/ SQL Procedures for all the business validations.
• Program validates the data and loads it into interface table (po requisition interface all, po req dist interface all) the PO Requisition Open Interface loads the data from interface tables to base tables (po requisition headers all,po requisition lines all, po requisition distributions all).
• Have developed PL/SQL procedures as per the business requirements.
• Developed reports by combining the multi-dimensional analysis with advanced report building skills.
• Involved in the development of technical documentations, Release notes of reports and interfaces.
• Development and customization of reports based on Customer requirements.
• Involved in the development of interfaces and Conversions to import the data from legacy systems into oracle application base tables.
• Custom report to obtain details on Purchasing, Receiving and Payables with in specified dates.
• Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved.
• Customized Invoice History Report by adding few more details related to Bank (Bank Name, Branch Name and Account Number).
• Customized the sales Order Form using Personalization. It should not raise sales order on weekends or public holidays.
• Customized PO Form using Personalization. Whenever user enters data on Sunday, Form should get Exit.
• Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price.
• Involved in sys admin activities related to all Concurrent Processing and Programming, Custom Application Development, System Administration, Flex field, Value sets etc.

Confidential, Houston, TX

Technical Consultant

Environment: Oracle apps 11.5.10.2(PO, AP, AR, INV), Developer 2000 and Oracle 9i, UNIX Forms 4.5, Reports 2.5, Oracle 7.3 and PL/SQL Toad.

Responsibilities:

• Working as team member in the offshore technical development team.
• Responsible for technical deliverables--Reports, Data Conversions, etc including documenting the same.
• Involved in the evaluation of the existing software developed using Access and the migration of this to Oracle as required by the business.
• Preparation of technical specifications.
• Worked on Purchase Order Interface to upload the Purchase Order data into Oracle apps Database Tables.
• Prepared functional requirements and Technical requirements document and developed modules in the package.
• Developed and tested the interface and conversion scripts.
• Developed several reports based on user specified criteria.
• Setting up of profile options including selecting primary set of books for each operating unit.
• Material Transaction Report using XML Publisher.
• Customized Print Requisition Report by adding one more field Accounting Id Description. Only then End User may identify under which the Account is distributed.
• Customized Incomplete Invoice Report, Previously the report was working only with Incomplete, after modification the report works for both Complete & Incomplete by taking as bind parameter.
• Developed PO Report, in order to get vendor wise cancel details using XML Publisher.
• Defining Executable Concurrent Program and assigning in to Request Group.
• Delivering the code and Related Documents.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.8(GL,AR,AP,FA), Oracle8i, Forms 4.5i, Reports 2.5I, XML Publisher, Windows XP, UNIX, SQL*Loader, pl/sql Toad.

Responsibilities:

• Defined executables, concurrent programs, Request Set of Concurrent Programs, Creating Staging Table, and Journal Import procedure etc. in Account Receivables (AR) General Ledger (GL), Fixed Assets (FA) modules.
• Worked on General Ledger Interface Tables like GL INTERFACE table and imported data via Journal Import into GL JE HEADERS, GL JE LINES, and GL JE BATCHES. Working experience with FA module system testing.
• Worked on interfaces like RA CUSTOMER INTERFACE ALL, RA INTERFACE DISTRIBUTIONS ALL in Account Receivables (AR) module.
• Designed and developed various packages and procedures which can be used in various programs.
• Developed control files for SQL*Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system.
• Register reports & schedule reports as per requirement on Account Receivables (AR) and General Ledger (GL).
• Created and customized reports in GL like Trail Balance Sheet Reports and AR like Aging Reports, Account Status report, Billing History Report.
• Good working experience in System Administration like defining executables, concurrent programs, User set up, defining responsibilities, adding menus, forms, reports etc.
• Enabling Descriptive and Key flex fields for vendor and Invoice.
• Involved in data loading. Used SQL*Loader to load data into the database using pl/sql.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Written PL/SQL code for packages, procedures, functions, triggers and views.
• Customized Reports and Forms to meet users requirements mainly