SUMMARY:

• More than 19 years of experience in Information Technology, Financials, Federal Financials, Manufacturing and Service Industries
• More than 18 years of Technical/Functional experience as a lead/developer in Oracle ERP/CRM. 11i/12 environment involved in complete 5 full life cycle implementations
• Very good implementation experience in Oracle Applications Release 12
• Strong in Oracle Financials, Federal Financials, Manufacturing, Supply Chain(SCM) and CRM modules.
• Excellent experience in Customizations, Conversions, Interfaces and Extensions(RICE)
• Strong in Order to Cash, Procure to Pay, Manufacturing, Supply Chain(SCM) and Project Accounting (Billing & Costing) modules
• Worked on Discover EUL in 10g
• Good Experience in customizing Oracle Workflows.
• Experience in converting business user requirements into functional and technical design documents
• Experience in developing interfaces and conversions using Oracle API’s
• Good Experience working with Developer 2000 tools(Forms and Reports)
• Ability to work effectively either independently or as part of the team
• Strengths include excellent Programming/Trouble shooting skills, communications skills and interpersonal skills
• Good working knowledge using web services

TECHNICAL SKILLS:

Operating Systems: Sun OS/Solaris 2.x, HP - UX, Linux and Windows NT, Windows 95, 98, 2000 and XP

Oracle tools & Utilities: T.O.A.D, SQL Station 4.1, DB Artisan, ADI,SQL, PL/SQL, Pro C, Developer 2000,Forms 4.5,5.0,6.x and 10g Reports 2.X, 5.0,6.x and 10g, SQL* Loader, Discoverer, Workflow Builder and XML/BI Publisher, JDeveloper, OBIEE 10.x

Databases: ORACLE 7.x, 8.x, 9.x and 10g

Oracle Applications: GL, AP, AR, PO, OE, OM, INV, FA,PA, WIP and BOM Release 10.6/10.7 Char, 10.7 SC, 10.7 NCA, 11.0.3, 11i and 12

Oracle Financials: General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), iExpenses, Fixed Assets (FA), Project Costing and Billing (PA) and Cash Management (CM)

Oracle Manufacturing: Order Entry (OE), Order Management (OM), Purchasing (PO),iProcurement, Inventory (INV), Bill of Materials (BOM)Work In Process (WIP) and Process Manufacturing (OPM)

Oracle CRM: Installed Base, Service Contracts, Depot Repair and Field Services

EXPERIENCE:

ORACLE APPLICATIONS ERP eBusiness SUITE CONSULTANT

Confidential, Colorado Springs, CO

Responsibilities:

• Responsible for analyzing and re-developing all the existing RICE components in AR,AP,GL,PO,OM,INV,BOM,WIP,FA,PA
• Responsible for analyzing, modifying several inbound and outbound interfaces as per new release standards like using new tables, views and APIs
• Responsible for analyzing, modifying several packages, procedures.
• Responsible for analyzing and developing several custom forms, reports and workflows
• Responsible for converting existing custom reports and developed brand new reports using BI Publisher reports.

Environment: Oracle Applications 12.1.3 Oracle 11g, AOL, Forms 10g, PL/SQL, Reports10g,BI Publisher

Confidential, Sacramento, CA

Responsibilities:

• Involved in Data conversion like Bill of Materials, Routing, WIP Job conversions, Projects, Project Billing Agreements using oracle standard APIs and interface tables
• Developed several custom processes and complex reports in Project Accounting (Costing and Billing) and Project Manufacturing modules
• Developed several custom reports using BI Publisher in PO,BOM,WIP,INV, PA and Project Manufacturing modules
• Developed several packages and procedures for data conversion and for custom processes.
• Developed several brand new reports using BI Publisher

Environment: Oracle Applications 12.1.3 Oracle 11g, AOL, Forms 10g, PL/SQL, Reports10g,BI Publisher

Confidential, Parkersburg,WV

Responsibilities:

• Responsible for all the production support issues, bug fixing and enhancements in AR,AP,PO, GL iExpenses and PA
• Developed few brand new custom forms
• Worked on Form personalization on AR Transactions Screen
• Developed Purchase Orders and Invoice interface in PO and AR
• Developed on Projects Conversion in Project Accounting
• Developed and modified several standard and custom reports using BI Publisher in PA, PO modules

Environment: Oracle Federal Financials 12.1.3 Oracle 11g, AOL, Forms 10g, PL/SQL, Reports10g,BI Publisher

Confidential, Indianapolis, IN

Responsibilities:

• Responsible for analyzing and re-developing all the existing RICE components in AR,AP,GL,PO,OM,INV,BOM,WIP,FA,PA
• Responsible for analyzing, modifying several inbound and outbound interfaces as per new release standards like using new tables, views and APIs
• Responsible for analyzing, modifying several packages, procedures.
• Responsible for analyzing and developing several custom forms, reports and workflows
• Responsible for converting some of the custom reports to BI Publisher reports.
• Responsible for documenting MD070 using AIM methodology for every object that have been modified
• Involved in discussions with users during the business requirement process.

Confidential, Dallas,TX

Responsibilities:

• Involved in Data conversion like On hand Quantity conversion, Inventory locators, Bill of Materials, Routing, WIP Job conversions, Receivable Invoice Conversion, PO conversion, Projects and Resources conversion, Project Billing Agreements using oracle standard APIs and interface tables
• Developed several custom processes and complex reports in Project Accounting (Costing and Billing)
• Developed several custom reports using BI Publisher in AR,AP,GL,PO,BOM,WIP,INV,OM, Project Costing and Billing modules
• Developed two new extensions like Inventory Asset Tracking System and Financial Cycle Counting systems using Custom forms and Reports as per Oracle Standards.
• Developed several packages and procedures for data conversion and for custom processes.
• Customized some standard forms using personalization in INV
• Developed several brand new reports using BI Publisher

Environment: Oracle Applications 12.1.3 Oracle 11g, AOL, Forms 10g, PL/SQL, Reports10g,BI Publisher

Confidential, Phoenix, AZ

Responsibilities:

• Responsible for all the production support issues and enhancements in AP,AR,OM,PA,FA,PO,GL and INV modules
• Worked on several enhancement projects like creating 1098 email notification to all the customers for year ending using web services
• Developed and modified several interface programs in AP,AR,OM,PA,FA,PO,GL and INV modules
• Involved in discussions with users to gather/understand the requirements.
• Responsible for doing gap analysis based upon the business requirements..
• Developed and modified several standard and custom reports using BI Publisher.
• Developed and customized several custom forms
• Involved in discussions with business group and IT group to upgrade Rel 12 implementation
• Worked as a team lead for R12 upgrade project

Environment: Oracle Applications 11.5.10 Oracle 10g, AOL,, PL/SQL, Forms 6i,Reports6iJdeveloper,OBIEE 10.x SOA Suite, 10.1.3.1, Jdeveloper 10.1.3.1.0 and BPEL

Confidential, Evansville, IN

Responsibilities:

• Responsible for data conversion in Bills and routing conversion in BOM, Sales order conversion OM, Purchase orders conversion in PO ,Item instances in Install Base, Invoice conversion, Customer conversions in AR using customer APIs and Asset conversion in FA
• Responsible for developing brand new custom reports and customizing standard reports in BOM, WIP, AP, AR, OM, PO,FA,INV,PA and GL using BI Publisher and Oracle Reports
• Developed complex GL reports using new sub-ledger tables
• Developed complex project management reports in Project Billing module using XML Publisher.
• Populated project classifications in PA using Project APIs
• Developed several packages, procedures to implement custom lock box process in AR using cash receipts APIs
• Writing ad-hoc reports using Oracle discoverer

Environment: Oracle Financials Application R12.0.3 Oracle 10g, AOL,, PL/SQL, Forms 10g,Reports10g,Workflow and Discoverer

Confidential, Denver, Colorado

Responsibilities:

• Responsible for outbound interfaces like customer and supplier information
• Responsible for AR,AP,GL,PA and PO data conversion
• Responsible for developing brand new custom reports and customizing standard reports in AP,AR,PA and GL using BI Publisher
• Responsible for resolving issues as they arise as part of the post implementation production support.
• Responsible for participating in discussions with analysts and business users during the requirement gathering.
• Prepared technical design documents using functional documents

Environment: Oracle Financials Application R12.0.3 Oracle 10g, AOL,, PL/SQL, Forms 10g,Reports10g,Workflow and Discoverer

Confidential, Denver, Colorado

Responsibilities:

• Responsible for analyzing and re-developing all the existing RICE objects(300 objects) developed in AR,AP,GL and PO
• Responsible for analyzing and modifying several inbound and outbound interfaces from mainframe and several other 3rd party applications
• Responsible for analyzing and re-writing several packages and procedures to populate interface table in GL, AR, AP and PO
• Responsible for analyzing and developing several custom forms, reports and workflows in AP,AR,GL and PO
• Responsible for optimizing 30 discoverer reports
• Responsible for documenting MD070 using AIM methodology for every object that have been modified
• Involved in discussions with users during the business requirement process.

Environment: Oracle Federal Financials Application 11.5.10 Oracle 10g, AOL,, PL/SQL, Forms 6i,Reports6i,Workflow and Discoverer

Confidential, Quantico, VA

Responsibilities:

• Involved in Data conversion like Sales orders, price lists in (OM) and AR invoices,
• Developed several custom reports in Project Accounting
• Customized Sales Order Form to display certain special instructions for a customer while entering the order.
• Customized the Order Management COGS account generator workflow to pull the account segment using order type.
• Developed a custom process to create in invoices based upon the Project Billing events in Project Billing Module..
• Developed several packages and procedures to implement the custom lockbox and invoice interface.
• Developed few custom forms using forms template. Customized some standard forms using personalization.
• Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists).
• Developed custom PSR(Product Status Report) report using Sales Orders data and customized several standard reports in OM and AR
• Developed several packages and procedures to implement the custom lockbox and invoice interface.
• Involved in discussions with users during the business requirement gathering.

Environment: Oracle Applications 11.5.10 Oracle 10g, AOL, Forms 6i, PL/SQL, Reports6i,Workflow2.6,XML Publisher, Discoverer 10g

Confidential, Livermore, CA

Responsibilities:

• Worked on AP invoice conversions and Purchase Order conversions for PO. Customized several forms in AP, PO and custom application (Effort System) registered in APPS using form personalization’s and CUSTOM.pll.
• Customized several standard and custom reports in AP, PO, PA and GL using AIM methodology.
• Developed several packages and procedures to populate project classifications in Oracle Projects - Project Accounting using Projects APIs.

Environment: Oracle Applications 11.5.10 Oracle 10g, AOL, Forms 6i, PL/SQL, Reports 6i, Discoverer 10g

Confidential, Los Alamos, NM

Responsibilities:

• Extracting Booked Sales Order and Sales Order Changes
• Extracting Purchase Order and Receipt Information
• Extracting Items and Items Changes
• Responsible for customizing reports, customer facing documents (CFD) like Invoice, Pick-Slip and Pack-Slip.

Environment: Oracle Applications 11.5.10 Oracle 9i, AOL, Forms 6i, PL/SQL, Reports 6i, Unix Shell Scripts

Confidential, Colorado Springs, Colorado

Responsibilities:

• Developed several procedures, packages and new custom reports in BOM, WIP and OPM modules
• Designed and developed interface (conversion) programs to import invoices and customers information into AR. Involved in implementation of Lock box. Developed several triggers, procedures and packages to populate the application data into custom data warehousing application (Keynet System).
• Developed generic shell scripts to load different formats of data into staging tables as part of the conversion.

Environment: Oracle Applications 11.5.9 Oracle 9i, AOL, Forms 6i, PL/SQL, Reports 6i, Unix Shell Scripts

Confidential, Golden, Colorado

Responsibilities:

• Developed several brand new custom reports including custom invoice (bitmapped) report and customized many standard reports.
• Designed and developed interface programs to import invoices, Journals and customers/vendors information from the custom billing system.
• Developed database triggers/stored procedures to populate the interface tables in the process of importing customers’ information into AR and suppliers’ information into AP. Enabled descriptive flex fields to store additional custom information to develop the complex reports based upon several different custom applications as well as Oracle applications.
• Registered Concurrent Program Executables, Defined Concurrent Programs attached to Request Groups and attaching Request Groups to Responsibilities.
• Developed and Maintained several reports and journal entries import process using ADI.
• Involving DBA related tasks to some extent like applying patches, refreshing database instances.

Environment: Oracle Applications 11.0.300 Oracle 8.1.6, AOL, Forms 4.5,6.0, PL/SQL, Reports 2.5,6.0, Unix Shell Scripts

Confidential, Englewood, Colorado

Responsibilities:

• Responsible for customizing Sales Order Form to process on-line credit card requests from Order Entry module.
• Developed a custom screen to process credit card authorization against Invoices from Receivables module.
• Developed database triggers to communicate with the Credit Card server. Involved in the development and customization of standard reports for application modules, viz., Accounts Receivable, Order Entry, Purchasing, Inventory and Fixed Assets.

Environment: Oracle Applications 10.7 NCA / Multi Org. Enabled Oracle 7.3, AOL, Forms 4.5, PL/SQL, Reports 2.5, Unix Shell Scripts