SUMMARY:

• Over Seven years of experience as Oracle Applications Developer in Implementations, Upgrading and Supporting of Oracle E-Business Suite.
• Worked on versions 11i/11.0.x, R12. Experience in Oracle Applications Implementation and Upgrade.
• Efficient programming skills in PL/SQL, Stored Procedures, Functions, Database Triggers,Packages, UNIX Scripts.
• Expertise in technical components Conversions, Reports, Interfaces, Extensions, Forms personalization, Shell scripting.
• Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API's.
• Complete understanding in customization and workflow procedure for Oracle Apps Order to Cash (OTC) and Procure to Pay (P2P) life cycles.
• 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, SQL*Loader etc.
• Good knowledge in AOL modules like System Administrator and Application Developer in registering concurrent programs, forms, functions, menus, reports and creating value sets, DFF's, profile options, printersin providing support to Business Users in resolving technical issues.
• Extensive knowledge in working with the utilities like TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS_PACKAGE.
• Expertise in maintenance of tables, indexes, views and optimizing queries.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
• Experience in creating and customizing existing reports using BI and Reporting Tools like Reports 10g/6i/4i and XML/BI Publisher tools.
• Good debugging skills and good at using Exceptions and Error Handling.
• Experience in working with AIM methodology and is very proficient in working with MD050, MD070.
• Good interpersonal skills, the ability to interact with people at all levels, and good communication.

TECHNICAL SKILLS:

Applications : Oracle EBS 11i/R12
Application Modules : Inventory (INV), Purchasing (PO), Order Management (OM), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL)
Operating System : UNIX, Linux, DOS, Windows XP/2003/Vista/7
Programming Languages : C, C++, SQL, PL/SQL, XHTML, UNIX Shell Scripting
Tools : TOAD, Oracle SQL Developer, SQL Loader, MS Office
Database : Oracle 10g, 9i/8i
ERP : Oracle Applications ERP (Rel 12, Rel 11i)

Education:

Bachelors of Technology

Professional Experience

Client: Confidential, WA Feb 2012 - Present
Role: Oracle Apps Technical 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:

• Involved in development of custom reports and forms for AP, AR, GL, OM and INV modules.
• Developed a BI Publisher report that can be run manually or scheduled to extract the Part Transfer Notification data to inform the supplier that parts are being moved from one facility to another facility.
• Involved in writing Package to extract data from Legacy System, validated and imported into Journal Import Interface tables and submitted a concurrent request to populate base tables.
• 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.
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on oracle applications.
• Experience in working with AIM methodology and is very proficient in working with MD050, MD070.
• Oracle data loading into oracle database from flat files using SQL loader.
• Extensively worked on Cursors, PL/SQL Tables on TOAD in the interface development and used exception wherever necessary to improve the performance.
• Worked on creation of report and email the output using shell script.
• Worked on Consolidation of procedures which have same functionality.
• Creation of movesheets to move the code to development to other instance.
• Creation of ldt files to load Executables, Concurrent Programs and Request sets from one instance to other instance.
• Worked with technical, functional teams to troubleshoot and resolve issues.

Environment: Oracle Applications 12I, AP, AR, PO , OM and INV, Unix, SQL*Plus, PL/SQL, TOAD, Reports 10g, SQL-Loader.

Client: Confidential, Chicago, IL Sep 2011 - Jan 2012
Role: Oracle Apps Technical 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:

• Developed interface to update On Hand Quantity for the items upon receiving Shipment Receipt.
• Developed inbound interface to create sales order lines.
• Developed PL/SQL programs to dump the data from staging tables into Base Table.
• Imported data from flat files located in legacy system into database table using SQL * Loader.
• Worked on outbound interface to load the data from base tables to staging tables.
• Developed an outbound interface to extract out the goods receipts information by weekly from Oracle to upload into Reject DB system.
• Prepared MD70 document for inbound interface.
• Worked with business analysts to identify requirements.
• Responsible for writing several pl/sql procedure, functions, triggers.
• Create reports such as payment status report, Negative open AR balance to meet the business needs.
• Responsible for Customizations of OM Reports.
• Analysis of customer reported issues, which could be a code issues, data fix issue, performance issue.

Environment: Oracle Applications 11I, AP, AR, PO , OM and INV, Unix, SQL*Plus, PL/SQL, TOAD, Reports6i, SQL-Loader.

Client: Confidential, Atlanta, GA Jan 2011 - Aug 2011
Role: Oracle Apps Technical Consultant

Project Description:
Cornerstone Financial system is used to manage Company Purchasing and Payments.

Responsibilities:

• Involved in the scope and technical requirement gathering for the Procure to Pay Process.
• Involved in design of AIM (Application Implementation Methodology) document MD050 and MD070.
• Developed reports from scratch and also customized standard oracle reports according to business requirements which include Order detail Report, Order Tracking Report, Outstanding PO Report, and Inventory details by Retail Location Report.
• 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.
• Involved in post production support and enhancements of RICE objects in all phases of the project.
• 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.

Environment: Oracle Applications R12, AP, AR, PO and INV, LINUX, SQL*Plus, PL/SQL, TOAD, Reports6i, Forms6i, Discoverer 10g, SQL-Loader.

Client: Confidential, Aliso Viejo, CA Mar 2010 - Dec 2010
Role: Oracle ERP Technical Consultant

Responsibilities:

• Deliver solutions to clients in response to varying business requirements.
• Worked as Onsite coordinator for couple of months for the customer.
• Deliver various RICE components specifically Conversion/Interfaces, XML Reports.
• Worked in GL data conversions in R12.
• 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 12), Oracle 10g,General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Inventory.

Client: Confidential, CA Aug 2009 - Feb 2010
Role: Oracle Application Technical Developer

Responsibilities:

• Created interface vendor validation program and also Created Initial vendor load program and Procurement New Vendor Load program.
• Customized the Standard Payment Batches form (check run form) and Invoice Entry form through custom.pll.
• Mapping of fields of CSV file to columns and imported the reconciliation data into the Oracle Cash Management Using UTL_FILE.
• Developed a script for Oracle custom Payment Format program in AP for check formatting and printing.
• Development of inbound interface custom package to validate and import invoices data into oracle applications AP Payables open interface tables from external system.
• Performed reconciliation of payables transactions through Cash Management module, which involves monitoring of bank statement interfaces from banks into Cash management module, resolved any issues with upload.
• Customized Forms and Developed Alerts.

Environment:
Oracle Applications 11.5.7, Oracle 8i, Forms 6i, Reports 6i, SQL*Loader, Discoverer 4i and UNIX.

Confidential, Atlanta, GA Sep 2008 - July 2009
Oracle Developer

Description:
The main purpose of this project is to provide ISS product (Internet Security appliances) updates to customers through appliance's console and download center as part of this system. And this project involves development of Interfaces and reports for AP, AR, GL, PO, OM and INV modules.

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 Report 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 representation and drill-down features.

Environment: Oracle E-Business Suite 11i , 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 2007 - July 2008
Role: Oracle Applications Developer

Responsibilities:

• Designed technical directions for implementing the reports and documenting them into MD070 (Technical documents).
• Designed, created and maintained the DiscovererEnd 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 personalization.
• 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 Applications 11.5.10, Oracle 9.2.0.4, Forms, Reports, SQL*Loader, Discoverer 4i, Windows XP and UNIX.

Client: Confidential, India Aug 2005 - Aug 2007
Role: PL/SQL Programmer

Responsibilities:

• Responsible for creating and modifying the PL and 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, Oracle Forms/Reports 6i, SQL, PL/SQL and HTML.