SUMMARY:

• Over 7+ years of extensive experience as Oracle Applications Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Finance Suite.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), I-Expenses, I-Procurement,
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Worked with the business functional areas to research and identify the best technical solution to support business processes.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Interaction with the offshore development team for development of reports and changes needed in the requirements.

EDUCATION & CERTIFICATION:

Confidential

ERP: Oracle E-business suite R12/11i/11.0.3/11.5.10.2 version Modules worked on: Accounts Payable (AP), Accounts Receivable (AR), Oracle General Ledger (GL), Oracle Purchasing (PO), Bills of Materials (BOM), Order Management (OM), Shipping and Oracle Inventory
Languages: SQL, PL/SQL, C, C++.
Databases: Oracle 8i, 9i, 10g MS Access, MYSQL.
Others: PowerPoint, MS-Word, MS-Excel, MS-PowerPoint.
Tools: Oracle - Developer 2000/6i (Forms, Reports), Toad 6.0/8.0/9.0, Oracle Utilities Oracle Workflow 2.6, XML reports
Operating Systems: Windows NT, Windows 95/98/2000/XP, HP UNIX, MS-DOS.

WORK EXPERIENCE:

Confidential,Glendale,AZ Oct’11 to Till Date
Oracle Apps Technical Developer

Responsibilities:

• Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such asINV, OM, SHIPPING, AR, PO and AP.
• 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 PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import programand populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed Discoverer Reports to get the employees information Period wise, monthly and yearly.
• Developed workbooks using Discoverer to develop custom reports for business analysis.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Developed new reports using Report Builder 9i and also customized seeded reports in purchasing (PO) module.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Creation of new custom reports using Oracle XML/BI Publisher.
• Developed AR Credit memo and AR Customers forms.
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Developed several forms using TEMPLATE.fmb& Customized standard forms through custom.pll.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages, Procedures and Reports developed.
• Developed technical design and test documents complying with Oracle AIM standards.

Environment: Oracle Applications R12, 11.5.10.2 (GL, AR, AP, Purchasing, OM, INV, BOM), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad , Workflow , UNIX, XML Publisher,Discoverer

Confidential,colombus OH Nov’10 to Sep’11
Oracle Apps Technical Consultant

Responsibilities:

• Migrated GL and AP custom interfaces and reports from 11i to R12.
• Developed Data Conversions and Interface Programs. Used SQL * Loader to Load Data into Oracle Database
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger)
• Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar.
• Imported Legacy Journals data into GL using Journal import interface
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Designed and Developed and Outbound Interface to send the Order details for a given customer
• Created requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Create standard purchase order, BPA and blanket releases.
• Developed PL/SQL scripts to load order data from external system to OM
• Developed Order Management, Inventory,Receivables queries to compare summary information of the standard and custom reports.
• Have done mapping 11.5.10 reports to R12XML/BI templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Customized Standard AR Receipt Register Report using Reports6i/10g.
• Designed and developed data storage procedures, functions and underlying views used for discoverer reports and developed discoverer Reports as per the requirement.
• Designed and developed ad-hoc Oracle Discoverer workbooks and reports and
  also trained the End Users.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP, FA and GL.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Developed various reports as of the user specifications using XML/BI Publisher.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Conversant with both offshore and onsite development models.
• Involved in post-production support.
• Created UNIX shell scripts to automate interface programs on daily basis.

Environment: Oracle Applications R12, 11.5.10.2(PO, GL, AR, AP, CM, FA, OM, INV), Reports 6i/10g, Forms 6i/10g, Oracle 9i, SQL*Loader, Toad, UNIX, Oracle Workflow 2.6, Explain Plan, XML Publisher, Discoverer 10g.

Confidential,Pennsylvania Nov’09-Oct’10
Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Developed SQL Loader scripts to populate staging tables.
• Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
• Part of the Implementation team for Order to Cash life cycle.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Customized various transactions in Accounts Receivables(Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Developed Code for Custom AP Invoice Import Program. This interface reads invoices from ASCII data file and loads the standard Oracle Payables invoice Interface tables.
• Involved in Performance tuning of various queries and stored procedures.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Involved in Customization of Standard Trail balance Report usingReports builder as per the businessRequirements.
• Customized Inactive Item Report and Cancelled Sales Order Report.
• Extensively worked on Report Triggers and Formula Columns.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Developed various reports using Discoverer according to business needs.
• Created custom folders, item classes in DiscovererAdministration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 9i/10g.
• Developed Technical design document using AIM methodology.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Register generated reports, forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Designed the frame work which would evaluate the details collected for customer instances and then generate various reports.
• Worked on Tuning of queries of the Custom Reports to improve the performance utilizing diagnostic tools (Explain Plan, TK Prof).

Environment: Oracle Applications 11i, Oracle9i, SQL*Loader, PL/SQL, TOAD, UNIX, Windows 2000, Reports 6i, Forms 6i/10g, Discoverer 10g.

Confidential,Memphis ,TN March’08- Oct’09
Oracle Applications Technical Consultant

• Implementation and up gradation of Oracle financials Suit. (AP, GL, AR)
• Written a Segment extraction program to extract the Chart of Accounts segment values and related information. This program Written in PL/SQL and made it as concurrent program.
• Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports.
• Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project.
• Imported Invoices using Auto-invoice program and applied receipts using Auto-Lock Box
• Developed test cases and templates to test the custom report migration process.
• Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels.
• Evaluation of organization structure, reporting needs, business needs to plan the chart of accounts as well as defining them
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developing Adhoc reports using Discoverer to analyze data and compare with General Ledger.
• Helping financial service people to understand and reconcile data between custom module and Oracle financials. Also designing and developing custom procedures and Reports (Pl/SQL, Reports 6.0).
• Writing scripts to automate reports to run in batch for given time period.

Environment: Oracle9i, Developer 6.i, Oracle Financials 11.5.9, Reports 6i, Forms 6i.

Confidential,AP India Sep’05- dec’07
Oracle Applications Technical Developer

Responsibilities:

• Involved in the customization of reports as per the clients requirement.
• Creation of value-sets, registering the reports and running the reports using the System Administrator Module.
• Developed Technical documents for the modifications performed as per the requirement.
• Modified Inventory item Locator report, Sub inventory quantities report, Receiving Transactions Register report and many more.
• Defined Executables, Concurrent Programs, Request Groups, Users, and Responsibilities.
• Designed reports in Discoverer based on the business requirements in AP, AR, and GL modules.
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Migrated the Oracle Forms 4.5 to Oracle 6i and made necessary changes to the PL/SQL Code and made necessary changes to the tables.
• Perform changes to meet 11i application coding standards.
• Design and Development of the application using Java, J2ee, Servlets and JDBC.
• Preparation of Test Cases and Test Plans and System Testing.
• Perform required manual changes.
• Migrated the Oracle Reports 4.5 to Oracle 6i.

Environment: Oracle Applications 11.5.9, AOL, INV, BOM, WIP, AP, AR, GL, PL/SQL, Oracle 9i, Java, J2EE, Servlets, JDBC, SQL plus, Developer 2000, UNIX.