Expertise Summary

• 7+ years of applications development experience in ERP Systems Implementation, Financials, Manufacturing, custom-applications, and automation of existing business processes using Oracle Applications e-Business Suite
• Extensive design, development, porting, migration, testing and deployment experience in Oracle with successful implementations of Oracle application solutions across the range of Oracle modules (GL, PO, AP, AR, iExpense, iProcurement, OM, INV, Advanced Pricing, iSupplier, Sourcing and Contracts) in a dynamic global environment
• Extensive experience with all aspects of Oracle Applications R12/11i and Oracle Database 11g/10g/9i product versions in large scale environments
• Has extensive knowledge and experience in underlying Oracle Applications database architecture as well as Oracle database and development tools including PL/SQL, SQL*Plus, Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i.
• Experience in Oracle workflow Builder, Designing, Building, extending functionality, debugging and performance tuning
• Worked on oracle XML Publisher for generation of various custom reports and registered them. Strong abilities in authoring AIM documentation including Business Requirements (BR100), Conversion/mapping Documents (CV40), Functional Specs (MD50) and Technical Specs(MD70).
• Well versed in the Migration Process, efficiently utilizing Version control software like Rational Clear Case, Visual Source Safe and creating Promotion/Migration Documents.
• Extensively worked on Developing Interface programs, both Inbound and Outbound. Developed PL/SQL procedures,Packages, Functionsetc. To perform Data Conversion, Migrations, data Manipulations, Custom report Development, Data Extract & Dynamic Insertion.
• Utilized OA Framework, for customizing forms and extending existing Functionality.
• Extensive experience in X Windows, UNIX shell scripts, PERL including a strong understanding of network programming and system programming in various UNIX flavors and Windows
• Extensively delivered multiple enterprise-wide financial application solutions in Oracle R12/11i environments on various Servers like Solaris, HP_UX, IBM AIX, Linux and Windows.
• Possess strong interpersonal, communication and client-facing skills and ability to work closely with users, cross-functional teams, testing teams, external vendors, onsite and offshore teams
• Solid experience in developing, adapting, and using formal and proprietary project and software development methodologies and accustomed to organization specific software quality and SEI/CMM practice requirements

Oracle Applications/Oracle E-Business Suite: R12(12.0.4/12.1.2/12.1/3), 11i(11.5.10.2)

Modules

General Ledger(GL), Accounts Payable(AP), Purchasing (PO), IExpense, Subledger Accounting (XLA), Accounts Receivable(AR),
Order Management(OM), Inventory (INV),
Application Object Library(AOL), Advanced Pricing(QP), Shipping, etc.,

Oracle Tools

Oracle Reports 10g/9i/6i, Oracle Forms 10g/6i, Oracle Discoverer 4i/10g, Workflow Builder, XML Publisher 5.6.2, EIS Reporting

Other Components

Oracle Application Server (OAS), SQL*Loader, Imp/Exp, TKPROF, UTL_FILE, BULK Loader, Dynamic SQL., etc.,

RDBMS/TOOLS

ORACLE 11g/10g/9i/8i, TOAD, SQL Developer, PLSQL Developer, etc.,

Operating Systems

Solaris, HP UNIX,IBM AIX, Linux, Windows

LANGUAGES

SQL, PL/SQL, UNIX, PERL, HTML, XML,C/C++,JAVA

• Bachelors in Information Systems

Professional Experience :

Confidential,Denver, CO Jan-2012 to Till Date

Role:Sr.Oracle Applications Techno-Functional Consultant.
Project Description:The Project involved Customization of Oracle Applications in R12.0.6. I was involved in customizing AR, GL, AP, PO, INV and OM modules including conversion, writing interface programs according to user and business requirements, customizing and developing several reports using Oracle Reports 10g and XML Publisher. During the project tenure, worked various Interface processes designing and developing them, extensively utilizing oracle APIs.
Responsibilities:

• Designed, developed interface process to import invoices information from various sources into Oracle payables from third party legacy system on a Daily Basis. Automated the process of file handling, data validation and load into the interface tables and created request sets to submit import process along with the File handling, SQL*LOADER, Data validation and loading.
• Developed various inbound and outbound interfaces, which are run on the periodic basis, including Journal Import in GL, Supplier Outbound extract, PO and Invoice Import, Payments Extract, Bank Reconciliation, Item Import in Inventory, Sales Order Import, Requisitions Import fromOrder Management for Back to Back sales Orders, etc.,
• Developed Custom Reports in various financial modules utilizing XML Publisher. The XML file generation is performed using PLSQL procedures.
• Customized many seeded oracle reports using Oracle Reports Builder as per the Business requirement in Payables and Purchasing Modules.
• Involved in implementing custom processes around Advanced Pricing and Shipping Modules. Developed custom process for Delivery Status Notification and transaction processing, based on the Status of Sales Order, item Shipment.
• Extensively worked on iProcurement requisition approval customizations. Personalized ISupplier Invoice Entry screen to enable Tax information processing, by changing the Misc line type to Tax line.
• Generated various custom forms that reflect the client’s custom application and registered these forms in oracle applications.
• Authored BRDs, Functional Specifications and Technical Specifications for various custom Extensions, interacting with users on a regular basis.
• Prepared Deployment/Promotion and integration documents for moving custom developed reports and forms from the development instance to production after code testing. Extensively used Rational Clear Case for Version control and Kintana for code Migration.
• Authored User manuals and gave training to business users, on the custom application generated according to the client’s needs.
• Performed various system administrator tasks such as defining custom menus and responsibilities, values sets, lookups, registering concurrent programs, request sets, Custom applications, registering forms, Profile Options and assigning request groups, etc.,
• Utilized FND_LOAD utility, for migrating AOL objects from one instance to other, including menus, responsibilities, Form Personalization, Flex-fields, lookups and Concurrent Programs.
• Involved in customizing workflows in Purchasing (PO) and Order Management (OM), especially on Back to Back Sales Orders and RMA Process flow.
• Personalized Oracle Core Forms by using Form level, Item Level and Block Level Triggers in several modules such as GL, AR, AP, FA and OM, as per the Business requirements.
• Involved in validations to the customized forms.
• Designed various reports in Discoverer and published them for User Utilization. Used Discoverer Administrator to define folders using SQL scripts and Views. Created workbooks in Discoverer Plus and published them. Exported the workbooks form development instance and imported in Production using Discover administrator.
• Opened Service Requests with Oracle Support in different scenarios, for providing Solutions to the Bugs identified during Production Support. Resolved various bugs, working in collaboration with Oracle Support.
• Extensively worked on Bug tracking and Ticketing Systems like SYSAID.

Environment:Oracle Applications R12.0.6 - GL, AP, PO, AR, OM, INV, WSH, QP, ISupplier and IProcurement, AOL, Workflow, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Forms 10g, Reports 10g, XML Publisher, TOAD, Discoverer 10g, HP_UX, Windows XP Professional

Role:EBS Technical Consultant
Project Description:This project is an implementation of Oracle Applications R12 over existing 11i Applications. During the tenure, extensively involved in designing and developing conversion programs, interfaces, developing Custom reports, building custom forms and Workflow Processes and writing UNIX shell scripts based on the functional specifications provided.
Responsibilities:

• Interacted with Business Users, attended meetings and discussions for gathering requirements, analyzed the business system and authored various documents.
• Involved in a team working on the complete life cycle implementation of oracle financial applications and developed custom modules according to the client’s specification.
• Created temporary tables and developed SQL*Loader control files to load the legacy Customer and Transaction data into the temporary tables. Developed Shell scripts to automate data loading Jobs.
• Developed various interfaces, which are run on the periodic basis. The working modules include GL, AP, AR, PO and FA.
• Extensively worked on Advanced Pricing module, by converting Pricing headers, lines, Qualifiers and Modifiers information from 11i application into Oracle R12.
• Worked on oracle TCA architecture for analyzing and loading party or customer information into oracle system.
• Involved in creating custom workflow using workflow builder assigning alerts to the workflowand administered various work flow processes for solving issues.
• Registered various custom reports, PLSQL Procedures, UNIX scripts, in oracle applications using system administrator responsibilities and involved in administering concurrent managers/transaction managers (activate/deactivate, request priorities). Defined Value Sets and Lookups for the custom Design.
• Extensively utilized FND_LOAD for downloading and uploading Concurrent Programs, Value Sets, Lookups, Form personalizations, Menus, Responsibilities, etc.,
• Extensively worked on Oracle System Administrator for defining Custom Profile options and enabling them at various levels, which is a base for automation of Custom extensions.
• Performed user level Printer setup in Oracle System Administrator according to the specifications defined by the client.
• Generated reports using XML Publisher in Purchasing and iProcurement modules
• Involved in Application Integration Methodology (AIM- MD070/MD120) for document preparation and analysis.
• Worked in collaboration with oracle support for solving various issues in the financial system and documented the changes for future reference.
• Extensively worked on production support, testing and planning the user routines for day to day business transactions.

Environment:Oracle Apps 11.5.8/R12.0.4, GL, AP, AR, PO, FA, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Forms 6i/10g, Reports 6i/10g, UNIX, TOAD, Discoverer 4i/10g, Workflow Builder, XML Publisher.

Confidential, New York, NY Dec-2008 to Mar-2010
Role:Oracle Apps Support Specialist
Project Description: MultiPlan is the industry’s most comprehensive provider of healthcare cost management solutions. MultiPlan is the only company that provides medical reimbursement services through a single electronic submission. The project is designed to support existing Oracle Applications Production System, monitoring and maintain Daily interfaces and building custom extensions as of when required.
Responsibilities:

• Supported various financials interfaces especially in GL, AP, AR and OM modules.
• Design and development of Auto Lockbox interface so that the bank file will be automatically imported into Accounts Receivables.
• Developed Aging Report and Settlement / Discounts bill report.
• Developed various crucial financial analysis reports (for all modules) written for AP, GL, OM, PO, and AR using Oracle Discoverer 4i. Developed PL/SQL packages and procedures.
• Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems. Wrote PLSQL Procedures, Packages, and Functions as of when required
• Used Descriptive flex-fields extensively to capture additional information in standard as well as customized forms.
• Involved in customization of several standard reports to serve important business processes very specific to the client. These Reports were developed since the already existing Oracle Report was not friendly enough to suit the client needs. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, vendor, payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR
• Utilized TEMPLATE.fmb to develop forms in accordance with Oracle coding standards
• Performed Sales Order Form Customization. Involved developing new forms to display Item Information, Delivery Information.
• Extensively used Workflow to build and launch business processes around Invoice Approval and Expense Approval.
• Designed and built a custom API with PL/SQL packages, procedures and functions to interface to Oracle Purchasing. The interface program is run as scheduled concurrent program.Created lookup sets and concurrent program and automated the interface process. Interface allows more robust error reporting like summary and aged reporting.
• Developed mapping, designed and built electronic billing file interface with Payables open interface. Invoices from the billing files are loaded into custom staging table through SQL*Loader. Created customstaging tables that store billing file records and PL/SQL packages consisting of procedures and functions that validate the billing file record and loads them into Payables invoice open interface tables. Validation of data includes Vendor, Project, Task, expenditure org name, expenditure type etc. Imported data from Interface tables by calling the Concurrent Program of the AP Invoices Import Process (APXIIMPT) from Interface Program.
• Developed billing file import report using Oracle Reports Builder, listing default project and task usage. This report runs as concurrent request and prints report in PDF format.
• Worked on XML PublisherTemplate Builder for generating report templates. Registered the template files and Data files in XML Publisher Administrator after registering concurrent programs.
• Extensively used Forms Builder 6i, to customize Oracle Core Forms, then register them to the Applications.
• Developed various FSG reports for reporting Income Statements and Balance Sheets, Cross Periods and Fiscal Years. Defined Row sets, Column Sets and even Report sets as required.
• Worked with oracle support by raising TAR. Worked on Sev1 issues providing 24/7 support to resolve various Production issues.
• Extensively worked on VSS version control software for code Check in and Check out. Worked with HP Service Center Client for creating tickets and assigning them within the group.
• Extensively worked on Oracle SQL/PLSQL and UNIX for developing adhoc reports.
• Designed and Developed new Outbound Interfaces utilizing Oracle UTL_FILE utility.
• Tuned the various programs by enabling Trace and decoding the raw trace file using TK_PROF utility. Performed performance tuning with the help of Explain Plan and enabling Hints and Indexes as of when required.

Environment:Oracle Applications 11.5.10.2, OM, PO, AR, AP, GL, Forms & Reports 6i,XML Publisher 5.6,Discoverer 4i, PL/SQL, IBM AIX 4, Windows NT

Confidential, Pune, India Mar-2007 to Aug-2008
Role:Oracle Apps Developer
Project Description:This project is an upgrade from Oracle Applications 11.5.10.2 to 12.0.4. Involved in developing conversion programs, interfaces, customizing reports, building custom reports, building custom forms and writing UNIX shell scripts based on the functional specifications provided.
Responsibilities:

• The project involves Analysis, Design and Develop the customization, implementation and Documentation as per the business requirement as part of R12upgrade plan.
• Mainly involved in upgrading the system by performing the pre upgrade and post upgrade steps. Based on the TUMS (The Upgrade Manual Script) necessary steps are done in pre upgrade and post upgrade process by eliminating the steps that are not necessary.
• Customized/modified the forms by getting the comparison report (standard to customize) and plugged the comparisons in R12 standard and saved the form as customized according to the client’s requirement. Created concurrent programs for all the custom reports. And PL/SQL is extensively used for Procedures and Reports
• Worked on various open interfaces of different modules like AP, OM, INV, PO, AR, PA and GL
• Involved in Legacy Accounts Receivable Invoice Conversion and loading Receipts
• Auto Invoice: Imported Regular, Debit memo, Credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program
• Developed SQL*Loader control files and PL/SQL Programs for loading data into interface tables from data files for all the financial modules. Defining Concurrent Program Reports Using SQL * Loader
• Worked on Purchase Order Interface and Receiving Interface in purchasing by loading data into staging tables from legacy system, validating data using pl/sql by loading into interface tables and running import programs to load them into main tables
• Responsible for developing various reports like sales data collection, check register, store lists etc.
• Customized printed purchasing report (Landscape) in PO, check printing report (formatting checks)-Laser in AP. Creation of Set of Books. Generated various Reports using Financial Statement Generator (FSG). Developed new Forms and Reports in PO, AP, and AR
• Responsible for developing database procedures to support remittance creation, void remittance, stop remittance and adjustments. These procedures are developed to call from forms and as a concurrent batch job
• Responsible for Unit Testing, System Testing. Responsible for bug fixing and enhancements
• Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters are extensively used in the process of development

Environment:Oracle Applications 11.5.10.2/R12 (OM, AP, AR, GL, PO & FA), Oracle 8i, Forms 4.5, Reports 2.5, PL/SQL, SQL*Loader, SQL*Plus, Solaris 2.5, Windows 2000

Confidential,Hyderabad, India Aug-05 to Feb-07
Role:Oracle Developer
Responsibilities:

• Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System.
• Developed following reports: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, issue of Material, Material Utilization.
• Developed various reports with the help of Reports Builder.
• Involved in writing stored procedures in PL/SQL to validate, select, insert and update data in material procurement module. Material procurement module enables shop floor engineers to requisition and procure items involved in production and maintenance of machinery from central stores as well as from company vendors.
• Designed and developed reports in Oracle reports 2.5 for tracking Preventive Maintenance of machinery (pumps, motors, heat exchangers, dryers etc.) involved in day-to-day production activities.

Environment:Oracle Applications 11.5.9 (OM, AP, AR, GL, PO & FA), Oracle 8i, Forms 4.5, Reports 2.5, PL/SQL, SQL*Loader, SQL*Plus, Solaris 2.5, Windows 2000