SUMMARY:

Over 7 years of technical experience in Oracle Applications with excellent knowledge in SQL, PL/SQL, Financials, Manufacturing, XML/BI Publisher, Discoverer, Work Flow,Oracle Forms & Reports.

• Expertise in Application Development and Customization, open Interfaces and Conversions, Development of Forms (Version 10g/9i/6i/4.5), Reports (Version 10g/9i/6i/2.5), Discoverer (version 4i/9i/10g), XML/BI Publisher reporting tool and WorkflowBuilder.
• In depth technical knowledge in flow of Oracle Accounts Payable, Accounts Receivable, GeneralLedger, Order Management, Inventory and Purchasing.
• Experience in setup, customization, interface programming and concurrent programs.
• Extensive experience in data conversion from legacy systems to Oracle Applications.
• Proficiency in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Extensive experience in Order-to-Cash and Procure-to-Pay process with full life cycle implementation.
• Experience in designing and executing test cases and test plans based on business requirements.
• Good Experience in designing, developing and troubleshooting Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Proficient with Discoverer&XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• In depth at working with diverse technical groups and global customers to develop technology solutions that meet or exceed expectations.
• Worked as an active team member in implementing ERP solustions using Oracle Applications.
• Strong analytical, diagnostic and problem solving abilities.

Areas of Expertise:

• Functional and Technical understanding of Oracle Applications including underlying table structures and database procedures and APIs.
• Flex fields: Good Knowledge of Flex field's structure in Oracle Apps.
• Interfaces: - Designed & Developed interfaces for INV, OM, PO, Shipping, GL, Payables, Receivables Modules.
• Conversions: Extensively created mappings and conversions in Oracle Apps to import the data after validations in to ERP.
• Migration: Involved in Migration & Upgradation of data from Oracle Apps ver. 11.5.10 to R12.
• Oracle On-Demand: Involved in development of E-business CEMLIs as per Oracle On-demand standards and compliance to Quality.
• Testing: Very good testing knowledge of Oracle Manufacturing(OM,PO,INV) & Financials(AP,AR,GL)
• Tuning: Extensive experience in Optimization (Tuning) of the Applications at the application level as well as the DBA level.
• Backend: Extensive Experience in Creating Triggers, Packages, Procedures, Functions using PLSQL.
• Client Interaction: Interaction with Clients\\Business to identify the business practices, future requirements, identifying the gaps and designing alternate solution.

TECHNICAL SKILLS

Oracle Applications : Oracle Financials E-Business suite R12/11i, AOL, Sys.Admin.
RDBMS : Oracle 8i/9i/10g, MS Access, SQL Server 7.x, 2000.
Application Tools : Forms 9i/10g and Reports 9i/10g, Discoverer 9i/10g, TOAD, SQL Navigator, SQL*Loader, SQL*PLUS, XML/BI Publisher.
Utilities : Rational Clear Case, Clear Quest, export/import, Winscp, Putty, Humming bird.
O/S : UNIX, Windows NT/XP/2000/98, Linux, MS-DOS.
Languages : SQL, PL/SQL, C, C++, HTML, XML.
Scripting Languages : UNIX shell script.

Education
Bachelors of Technology

Professional Experience:

Client:Confidential, Feb'12 - Present
Role: Oracle Apps Techno_Functional Consultant
Project Description:
Boeing\'s Integrated Materials Management is a supply chain service that links a customer\'s systems and processes with Boeing and its suppliers. It builds on existing materials management programs that Boeing has with several other airlines. This program is the next advance in expanding Boeing\'s supply chain services to provide value to both airline customers and supplier partners.

Responsibilities:

• Developed SQL*Loader scripts to import the data from the csv files sent from the legacy system into the staging tables in Oracle.
• Scripted PL/SQL packages and procedures to validate the data on the staging tables and load the data into Oracle interface tables.
• Used seeded Oracle interface programs (Journal Import) to import journals into GL.
• Developed interface to get the Customer Details and Receivable Invoices from the legacy system to Oracle Accounts Receivables (AR).
• Customized the Oracle standard API's (Customer Interface and Auto Invoice Master Program) to import the customers and invoice data from the interface tables to Oracle Base tables.
• Imported Items from legacy system into Oracle Inventory (INV) using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Performed Extensive Application tuning for Order to Cash Business process
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL).
• Creation of ldt files to load Executables, Concurrent Programs and Request sets from one instance to other instance.
• Involved in development of custom reports and forms for AP, AR, GL, OM and INV modules.
• Created several Business Areas in Discoverer and based on the Business Areas, created many number of discoverer workbooks on OM, INV and AR modules.
• Developed/Converted most of the existing text reports to excel format using XML/BI Publisher.
• Registered the new XML/BI Publisher report as concurrent program.
• In XML/BI Publisher, created a Data Definition with XML data and XSD.
• Used Microsoft Word to create an RTF template with all the required data fields and registered the formatted template in XML/BI Publishers Template Definition.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Developed UNIX shell scripts for coping and moving files to and from the Oracle server.
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc. Created Request Groups for reports.
• Provided support and fixed issues during testing of the products and after go live.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and using indexes
• As a technical consultant, responsible for Communicating with the end users, Requirements analysis, Design (MD070), Coding, Testing, QA, Change Management and support of the Customizations and application extension.
• Worked with technical, functional teams to troubleshoot and resolve issues.

Environment: Oracle Applications R12/11i, GL, AP, AR, PO, OM and INV, UNIX, SQL*Plus, PL/SQL, TOAD, Reports 10g, Forms10g, Discoverer 10g/9i/4i, XML/BI Publisher, SQL*Loader, AIM.

Client:Confidential, Chicago, IL Sep'11 - Jan'12
Role: Oracle Apps Techno_Functional Consultant
Project Description:
The project involved in implementation of inbound and outbound interfaces and customization of reports suitable for the client. Oracle tables were populated from legacy feeder systems using interfaces and SQL*Loader.

Responsibilities:

• Used custom SQL*loader program to load the invoices from other accounting systems to payables staging tables.
• Involved in checking the validityand accuracy of the legacy data by writing PL/SQL packages.
• Developed several Procedures and Database Triggersas per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PO interface to import Purchase Orders from legacy systems.
• Customer & Invoice data Conversion from Legacy System into Oracle Account Receivables (AR) by using Customer and Auto Invoice interface.
• Developed GLInterface for importing journals from legacy systems into GL_INTERFACE table.
• Conducted Interface Testing (Customer Interface and Auto Invoice in AR, Order Import in OM) of application and reported the defects to the development team.
• Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
• Developed interface to update On Hand Quantity for the items upon receiving Shipment Receipt.
• Customized existing custom oracle reports to replace plain text output to PDF format using XML/BIPublisher.
• Worked on XML/BI Publisher bursting to send PDF reports via email.
• In XML/BI Publisher created a data definition from generated XML.
• Created an RTF template with XSL equivalents to group data as of date placed in service and registered to Template definition.
• Designed reports in Discoverer based on the business requirements in AP, AR, and GL modules.
• Customized and developed several reports in AR, AP, OM modules using Reports 9i.
• Customized reports using Reports 9i like Customer Detail/ summary and Aging Bucket reports to suit
• the requirements of customers .
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Prepared MD70 document for inbound interface.
• Analysis of customer reported issues, which could be a code issues, data fix issue, performance issue.

Environment: Oracle Applications R12/11I, Unix, SQL*Plus, PL/SQL, TOAD, Reports 9i, Forms 9i, Discoverer, XML/BI Publisher, SQL*Loader.

Client:Confidential, Atlanta, GA Jan'11 - Aug'11
Role: Oracle Apps Technical Consultant
Project Description:
Cornerstone Financial system is used to manage Company Purchasing and Payments. \

Responsibilities:

• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Developed new program in PL/SQL and Modified old programs for Payables Open Interface (AP) to import invoices from two different sources. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND_REQUEST API to submit concurrent programs from PL/SQL programs
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Created triggers to apply the holds to the Orders on change of statuses & triggers to release the holds.
• Established setups to proceed with the customizations & developed data conversions.
• Created custom packages to return the Order Status on an hourly basis to an indirect customer and on a daily basis to a direct customer and attached them to the concurrent programs.
• Created packages to fetch the item availability status and item price on a requirement basis.
• Created PL/SQL procedure to copy the given drop ship sales order to Standard sales order and to create the ship sets for the standard order.
• Created a database trigger to populate purchase orders descriptive flex field with drop ship order number and legacy system order number if the purchase order is a drop ship purchase order.
• Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders, RMAs.
• Extensively worked on GL, AP, AR and Fixed Assets modules in automating the closing process.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Used SQL *Loader and UTL_FILE Packages for data conversion and interfaces.
• Used Template, sub Template method for a creating single report with multiple Layouts using XML Publisher.
• Created PDF/EXCEL/Word output's for reports based on requirements.
• Used the Totals/Subtotals/group/sort features of XML Publisher/BI Publisher to make data intense operations happen at the template level.
• Involved in Oracle Discoverer installation and Configuration and Oracle Discoverer Administration, Creating EUL Schemas, Discoverer Classes and EUL user Administrations etc.
• Wrote UNIX Shell Scripts for coping and moving files to and from the server.
• Developed a PL/SQL program that is scheduled to submit concurrent programs in a desired sequence as per the functional document. Used standard fnd API.
• Involved in design of AIM (Application Implementation Methodology) document MD050 and MD070.
• Involved in post production support and enhancements of RICE objects in all phases of the project.

Environment: Oracle Applications R11i/R12, LINUX, SQL*Plus, PL/SQL, TOAD, Reports 9i, Forms 9i, Discoverer 10g, SQL*Loader.

Client:Confidential, Aliso Viejo, CA Mar'10 - Dec'10
Role: Oracle ERP Technical Consultant
Responsibilities:

• Deliver solutions to clients in response to varying business requirements.
• Involved in the Development of Customer Conversion (AR) and fixing the bugs that are existing by raising TARs.
• Developed PL/SQL scripts to load order data from external system to OM interface tables (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL) and OEbase tables(OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL).
• 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 Invoice Import and PO Receipts Interfaces using Invoice Open Import and Shipping API's.
• Developed outbound interface to extract Purchase Orders.
• Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
• Worked as Onsite coordinator for couple of months for the customer.
• Customized and created various forms using Forms 9i in INV, OM, AP, and GL and registered and run under custom responsibilities.
• Customized and created various reports using Reports 9i and registered them under the concurrent manager.
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically.
• Deliver various RICE components specifically Conversion/Interfaces, XML Reports.
• Responsible for effective communication to the customer and peers. Provide day to day direction to the peers and provided project status to the customer on a regular basis.
• Translate customer requirements into formal requirements and design technical specifications, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment- Oracle Applications ERP (Rel 11i), Oracle 10g,General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Inventory, UNIX, SQL*Loader, PL/Sql, XML Publisher, Discoverer, Reports 9i, Forms 9i.

Client: Confidential, CA Aug '09 - Feb'10
Role: Oracle Application Technical Developer
Responsibilities:

• Created a Concurrent Program to call the Database Package and also the procedure to load the data from the staging table to the gl interface table
• Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate table GL_DAILY_RATES_INTERFACE.
• Run the Journal Import process to load the data from the gl interface tables to the General Ledger base tables.
• Created an interface to import Order Management data from the legacy system to Oracle Order Management. Used SQL Loader and PL/SQL packages to load and validate the data
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL_SYSTEM_ITEMS table.
• Developed new ftp and SQL loader programs for Auto invoice interface. Developed a request set to ftp, load custom tables, purge auto invoice interface and load auto invoice tables
• Developed PL/SQL and SQL scripts to Transfer Data to non - Oracle systems such as the Intranet, trading partners , data related to payments ,invoices, PO's and Items.
• Provided the users with detailed vendor reports on existing vendors from legacy system.
• Customized suppliers audit report, expected receipts report, contract status reports.
• Resolved complex report issues such as formatting, PDF output, parameters and exceptions.
• Removed the dependency of the printer to generate an XML output for the print statement form (AR)
• Writing UNIX Shell scripts and commands for file management, job automation and administration tasks.
• Documented detail designs for reports that were being developed and customized for company's custom format.

Environment:
Oracle Applications 11i, Oracle 9i, Forms 6/9i, Reports 6i/9i, SQL*Loader, Report Builder, Forms Builder, XML Publisher, Discoverer 4i and UNIX.

Client: Confidential, Atlanta, GA Sep '08 - Jul'09
Role: Oracle Application Technical Developer
Responsibilities:

• Migrated the existing reports and developed new reports as per business requirements using Oracle Reports.
• Actively involved in ongoing day to day Production Support activities / issues and providing problem resolving solutions to Tickets.
• Responsible for implementation of RICE (Reports, Interfaces, Conversions, Extensions) elements in Oracle EBS 11i environment.
• Developed interfaces like Inventory interface, Items interface, Categories interface, OM interface, Receiving Open interface and using OM, Shipping, Inventory, Installed Base APIs.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Imported data from flat files located in legacy system into database table using SQL * Loader. Designed temporary interfaces to view the loaded data. This data existed in the form of spreadsheets and access database.
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Reports 10g).
• Used PL/SQL to validate data and to populate billing tables.
• Created and manipulated stored procedures,functions, packages and triggers using TOAD 9.5.
• Involved in migrating database from oracle 9i to 10g database.
• Involved in developing screens and generating reports.
• Developed Forms and Reports using Oracle Forms and Reports 6i.
• Used Discoverer to support querying, reporting, and the graphical multidimensional analysis of the central Repository. Mainly performed graphical representations and drill-down features.

Environment:
Oracle E-Business Suite 11i, AP, AR, PO, GL, OM and INV, Oracle 9i/10g, PL/SQL Developer, UNIX, Windows 2008, Forms builder 6i, Reports Builder 6i, HTML, SQL * Loader, SQL Navigator, Oracle Discoverer, QTP, Toad 9.5.

Client: Confidential, MN Oct '07 - July'08
Role: Oracle Applications Developer
Responsibilities:

• Designed technical directions for implementing the reports and documenting them into MD070
• Designed, created and maintained and Discoverer End User Layer.
• Developed several Oracle Discoverer workbooks using Discoverer Admin, Discoverer Desktop and Discoverer Viewer.
• Created custom responsibilities, menus, and functions using System Administrator.
• Developed reports using Oracle BI Discoverer, Reports Builder 6i.
• Designed and developed custom forms using Template.fmb.
• Worked on AP Conversions, loading the Vendors and Open Invoices.
• Worked on AR Interfaces(Transactions and Receipts) from AS400 to Oracle AR.
• Customized the form functionality using form personalizations.
• Used FNDLOAD to move concurrent programs, menus, and forms personalization between instances.
• Defined the descriptive flex fields on sales orders, and Invoices forms to facilitate additional information.

Environment:
Oracle E-Business Suite 11i, AP, AR, PO, GL, OM and INV, Oracle 9i/10g, PL/SQL Developer, UNIX, Windows 2008, Forms builder 6i, Reports Builder 6i, HTML, SQL * Loader, Oracle Discoverer, QTP, Toad 9.5.

Client: Confidential, India Aug'05 - Aug'07
Role: PL/SQL Programmer
Responsibilities:

• Responsible for creating and modifying the PL/SQL procedure, function according to the business requirement.
• Used SQL LOADER to upload the information into the database tables.
• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Extensively analyze the security holes in the PLSQL. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file's of the Sql*loader.
• Created and used XML for data management and transmission.
• Worked extensively on C for low level programming and embedded work.
• Involved in analysis, design, coding and Testing.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• UNIX Shell Scripting to automate procedure execution from UNIX box.

Environment:
Oracle 8i/9i, Oracle Forms/Reports 6i, SQL, PL/SQL and HTML.