SUMMARY

• 7.5 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 andContracts) 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.
• Solid 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, Functions etc to perform Data Conversion, Migrations, data Manipulations, Custom report Development, Data Extract & Dynamic Insertion.
• Utilized OA Framework, for developing custom 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

TECHNICAL SKILLS

ERP Business Applications: Oracle Applications/Oracle E-Business Suite R12, R11i

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 Discoverer4i/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

PROFESSIONAL EXPERIENCE

Confidential, Englewood, CO

Oracle ERP Financials/SCM Developer

Responsibilities:

• Involved in customization of the standard forms in oracle applications writing PL/SQL procedures and modifying the trigger routines.
• Extensively utilized FND LOAD for downloading and uploading Concurrent Programs, Value Sets, Lookups, Form personalizations, DFFs, 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.
• Developed various reports with the help of Reports Builder. Created reports using EIS reporting which is integrated with Oracle Applications.
• Generated reports using XML Publisher in Purchasing and iProcurement modules
• Interacted with Business Users, attended meetings and discussions for gathering requirements, analyzed the business system and authored various documents.
• Authored BRDs, Functional Specifications and Technical Specifications for various custom Extensions, interacting with users on a regular basis.
• 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 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
• Worked on delivering enhancements, customizations in accounting modules in E-Business Suite 11.5.10 modules (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management).
• Supported all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting technical and functional issues. Lead development effort of enhancements, patches and upgrades.
• Performed Tier II system troubleshooting in a production support environment for the Oracle Financials application modules.
• Assisted users in solving both functional and system issues within agreed-to service level agreements (SLAs). Provide end-user instruction, training and support to resolve application issues. Manage ORACLE Service Requests (SR's) to resolution effectively.
• Developed new strategies, improving internal processes, and implementing “best practices” through use of technology and business processes.
• Supported the maintenance of the organization's accounting related Oracle ERP Systems through design, develop, code, test, and debug software applications and procedures.
• Developed Technical Specifications. Developed and executed unit test plans. Expected to work closely with business partners, release management
• Server Operations Center staff and other technical teams in order to produce well tested, successfully integrated and fully documented software solutions to business problems.
• 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
• Provided Tier III technical support to work on complex problems of diverse scope and will assist in troubleshooting and fixing system and application problems.
• Monitored effectiveness of systems, policies and procedures and make appropriate recommendations to ensure daily operations are efficient.

Environment: Oracle Applications R11.5.10 - 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

Confidential, Thousand Oaks, CA

Oracle Applications Technical Consultant

Responsibilities:

• Handled Full-life-cycle (Procure to Pay P2P) implementation cycle for multiple Operating Units with Oracle Financials including post implementation support
• Involved in requirements gathering, analysis, design, development, gap analysis, customization, configuration, testing and implementation of Oracle Financials 11i (11.5.10, 12.0.6 and 12.1.3) modules (AR, GL and CE).
• Involved in all technical areas of Oracle Apps (RICE components) like customizations, data migrations, interfaces and new developments/extensions with a fair amount of exposure to reporting through OBIEE.
• 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 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.
• 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 Discovererand 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

Confidential, Birmingham, AL

EBS Technical Consultant

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 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
• 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 builderassigning alerts to the workflowand administered various work flow processes for solving issues.
• Involved in customization of the standard forms in oracle applications writing PL/SQL procedures and modifying the trigger routines.
• Extensively utilized FND LOAD for downloading and uploading Concurrent Programs, Value Sets, Lookups, Form personalizations, DFFs, 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.
• Developed various reports with the help of Reports Builder. Created reports using EIS reporting which is integrated with Oracle Applications.
• Created requisitions in iProcurement.
• Uploaded catalogs in iProcurement
• 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.
• Used Descriptive flex-fields extensively to capture additional information in standard as well as customized forms.
• 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, Cleveland, OH

Oracle Apps Support Specialist

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.
• 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
• UtilizedTEMPLATE.fmbto 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 custom staging 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 Publisher5.6,Discoverer 4i, PL/SQL, IBM AIX 4, Windows NT

Confidential

Oracle Apps Developer

Responsibilities:

• The project involves Analysis, Design and Develop the customization, implementation and Document them as per the business requirement as part of 11i upgrade plan.
• Customized/modified the forms by getting the comparison report (standard to customize) and plugged the comparisons in 11i 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.0.3/11.5.10 (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

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.
• 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