SUMMARY

• More than 10 years of Experience in Software Development in Oracle Tools Including 8 years of experience in Oracle Applications R12 (12.1.3,12.0.6) and 11i (11.5.10, 11.5.9, 11.5.8) E - Business Suite.
• More than 9 years’ Experience in Oracle Applications (Enterprise Asset Management (EAM), General ledger (GL), Payables (AP), Receivables (AR), Order Management (OM), Purchasing (PO), Oracle Inventory (INV), Sys Admin and Application Object Library (AOL).
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Very Good understanding of Trading Community Architecture (TCA).
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Expertise working with Oracle 10g/9i, Developer 2000, PL/SQL, Forms 10g/6i, Reports 10g/6i, SQL * Loader, Discoverer 10g/6i and BI Publisher.
• Experience working on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Experience configuring Intelligence Dashboards with drill-down capabilities using global and local Filters, Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Good experience in working with UNIX Shell scripting and running interfaces with third party systems with Oracle.
• Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.
• Strong experience in software development principles and methods (Agile, RUP, OUM etc).
• Solid Knowledge and understanding of AOL/FND architecture and Applications.
• Strong Knowledge in Oracle Cursor Management and Exception handling.
• Expert in using UTL FILES, Export, Import, SQL*Loader Utilities, CONCSUB Utility, FTP, TOAD.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Oracle Applications ‘Business Flows’ are well known and plan detailed test cases and scripts based on the Business Flows to conduct conference room pilots, system integration and user acceptance testing.

TECHNICAL SKILLS

ERP: Oracle applications R12 and 11i (Financials and SCM modules like AP, AR, GL, OM, PO, BOM, WIP, WSH, INV, O2C Cycle etc.), Oracle APEX

Databases: Oracle RDBMS, Oracle 9i/10g

Languages: SQL, PL/SQL, C, C++, Java, JSP, PERL

Web Technologies: HTML, JAVASCRIPT, ASP and PHP

Tools: Forms 9i/10g, Reports 9i/10g, Toad, SQL Navigator, SQL*Plus, SQL*Load, Discoverer 9i/10g, Developer 2000, XML Publisher and BI Publisher

Operating System: UNIX, Linux (Red hat enterprise) and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked as part of conversion team to move data from MSS system into new Oracle EBS R12 system.
• Worked on interfaces ad API’s to convert Data from Legacy systems (MSS and P6) to Oracle EBS system like Work Orders, Assets, PO’s and other custom Data.
• Working on Upgrade as part of EAM team to move current system from Oracle EBS R12.1 to R12.2.
• Worked on developing different types of daily timesheet reports for crews depending on the area number and parameters.
• Designed and developed Bank Branches and Bank Accounts Conversion Programs to load bank information to Oracle.
• Worked onAuto Invoice Interface Programto validate and load credit memos, debit memos and invoices from legacy system.
• Developed PO Receipts and Returns from BOS inbound interface which will be used to load receipts made in legacy system into Oracle.
• Customized AP workflow which involves creating a new top level custom process for the Standard PA Account generator and Project Expense Report Account Generator.
• Developed AP Supplier contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Worked on creating different BI Publisher and XML reports for Assets and Work Order in the Enterprise Asset Management system.
• Customized various transactions inAccounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Worked on Creating Work Order Job packet to enable the crews to Auto Print different Work Orders based on Crew Types and Work Order Types.
• Worked with STR Software team to implement the AventX software in the Oracle EBS system which enables the crews to print Job packets from EAM.
• Working on Oracle Apex forms for Work Order Details in the Enterprise Asset Management team.
• Worked with Users to setup the printers to the Confidential Network and Oracle and created Programs which enables the crews to auto print Maintenance Work Orders.
• Worked as part of a team to move the EAM from Oracle Primavera6 to Oracle EBS.
• Working on developing interfaces and API’s to move inspection data to and from Shelby County to our Oracle EBS system.
• Developed and created different Extensions and Interfaces in EAM based on the user requirements to customize various Oracle screens and processes.
• Customized standard reports by adding new frames, repeating frames and columns (placeholder, formula, summary) to transform the user requests to achieve the desired format.
• Extensively worked on CUSTOM.pll to handle various form customizations to meet the requirements of the client to meet their business requirements.
• Responsible for creating the custom value sets and values required for the additional parameters while defining the programs.
• Responsible for registration of reports and forms in the development, testing and production instances.
• Testing and documenting modules under AIM standards for different application functionality.
• Developed design and implementation documents such as MD050, MD070, Code Review Checklists and user-documentation.

Environment: Oracle Applications R12, EAM, INV, PO, AR, Oracle 10g, Forms 10g, Reports 9i/10g, XML/BI Publisher, Oracle APEX, SQL*Loader, SQL Developer and UNIX.

Confidential, Windsor Mill, MD

Oracle EBS Techno Functional Consultant

Responsibilities:

• Designed and developed AP Invoice Conversion program to load AP open invoices from legacy system to Oracle.
• Designed and developed Bank Branches and Bank Accounts Conversion Programs to load bank information to Oracle.
• Involved in Development of import and Validation Program of Journal Import & Budget Upload Interfaces (GL).
• Designed and developed AR Invoice Conversion (Auto Invoice) program to load open transactions from legacy system to Oracle.
• Customized various transactions inAccounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Developed interfaces to import payable invoices andiExpensesrelated invoices.
• Developed custom upload price list interface program that uploads the new price lists into Oracle from legacy system.
• Developed new Runoff Depreciation summary and detail discoverer reports, which shows the depreciation value of the assets to company.
• Designed and developed Supplier Bank Conversion program to load supplier bank information to Oracle.
• Designed and developed Bank Statement Interface program to load bank statements to Oracle.
• Developed Finance Reports like: Comparative Sales Report, Daily Sales Report.
• Extensively worked on CUSTOM.pll to handle various form customizations to meet the requirements of the client in AR and CM modules to meet their business requirements.
• Responsible for creating the custom value sets and values required for the additional parameters while defining the programs.
• Responsible for registration of reports and forms in the development, testing and production instances.
• Testing and documenting modules under AIM standards for different application functionality.
• Developed design and implementation documents such as MD050, MD070, TE020, Code Review Checklists and user-documentation.

Environment: Oracle Applications R12, GL, AR, AP, PO, INV, OM, WSH, Oracle 10g, Forms 6i/10g, Reports 6i/10g, Discoverer 10g, Workflow, XML/BI Publisher, SQL*Loader, TOAD and UNIX.

Confidential, Irvine, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked onAuto Invoice Interface Programto validate and load credit memos, debit memos and invoices from legacy system.
• Designed and developed the Journal Import Conversion program to Import Journals into General Ledger using SQL*Loader, PL/SQL package and Journal Import Concurrent program.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables.
• Designed and developed AP Vendor (Supplier) conversion program to load suppliers into Oracle.
• Designed and developed AP Invoice Conversion program to load AP open invoices from legacy system to Oracle.
• Designed and developed Bank Branches and Bank Accounts Conversion Programs to load bank information to Oracle.
• Worked on Reconciliation of Sub-Ledger modules with GL and Accounting Setup Manager.
• Developed PO Receipts and Returns from BOS inbound interface which will be used to load receipts made in legacy system into Oracle.
• Worked on creating Oracle Grants for the Payables and Receivables modules.
• Developed several Procedures and Database Triggers as per Business requirement.
• Worked on generating additional accounting entries in GL, which are generated in the legacy system. Developed several extracts using Oracle UTL FILE functionality.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Customized Supplier Open Balance Report in Accounts Payables (AP) using XML/BI Publisher.
• Customized AP Invoice on Hold Report, AP Payment Register Report using Discoverer 10g.
• Defined Descriptive Flexfield’s in various forms of AR, CM and AP.
• Developed PL/SQL scripts to populate a table with application rates of employees for 3 months (Custom Database)
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle Applications R12 GL, AP, PO, INV, AR, OM, Oracle 10g, Reports 10g, Discoverer 10g, BI Publisher, Forms 10g SQL*Loader, TOAD and UNIX.

Confidential, Evansville, IN

Oracle EBS Technical Consultant

Responsibilities:

• Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Imported Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in GL using Journal import.
• Developed several Procedures and Database Triggers as per Business requirement.
• Worked on generating additional accounting entries in GL, which are generated in the legacy system. Developed several extracts using Oracle UTL FILE functionality.
• Extensive experience in XML/BI Publisher, which included working on report development objects like data templates and RTF’s.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client
• Involved in customizing the forms for adding extra information through DFF’s.
• Developed queries for summaries of AR Aging reports.
• Involved in the workflow extension so that additional holds on orders can be applied through the workflow.
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables.
• Developed PL/SQL scripts to populate a table with application rates of employees for 3 months (Custom Database)
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle Apps 11.5.10.2, R12 (AP, AR, GL, PO and FA), Oracle 10g, Forms 10g, Reports 10g, Discoverer 10g, SQL*Loader, Workflow Builder 2.6, XML Publisher, TOAD, WINDOWS XP, UNIX.

Confidential, Irving, TX

Oracle Developer

Responsibilities:

• Expected Purchase Order Receipts
• Internal Order Summary
• Purchase Order Requisition report
• Supplier summary Report
• Bank Reconciliation Extract
• General Ledger, Payables
• Electronic Funds Transfer (EFT) Purchasing, Payables
• Logiroute Extract Order Management, Shipping Execution
• PO Receipt Extract Purchasing, Receivables
• Sales Order Extract Order Management
• Developed the reports and interfaces using Multi-Org and Multilingual concept.
• Worked on development of Outbound Interfaces/Extracts and new reports using Reports 6i, XML/BI Publisher and Discoverer 10g.
• Worked on debugging and fixing defects of Custom Forms using Forms 6i.
• Developed new reports and outbound interfaces in various modules such as Order Management, Inventory, Purchasing, Receivables, Payables, General Ledger, Shipping Execution, Bill of Material and Work in Process.
• Developed new and customized existing reports using custom business areas, Item Classes, Work-sheets, conditions, database functions and calculations in Discoverer 10g.
• Reports developed in Discoverer 10g:
• Interfaces/Extracts developed:
• Worked on fixing the defects on the Forms based Views, Triggers (Form level, Block level, Item level) using Forms 6i.
• Customized Sales Order form using Form Personalization.
• Documented all my work in the form of MD70s, MD120s and Unit Test Plan (UTP) documents.
• Improved the performance of developed objects using performance tuning the SQL and PL/SQL scripts.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, OM, INV, PO, BOM, WIP), Oracle 10g, Discoverer 10g, Forms 6i, Reports 6i, XML/BI Publisher.