Profile:
Oracle Applications Professional with 10+ years extensive experience in user requirement study, analysis, solution Design, Project Planning, Development, Implementation, Testing, Customization, Maintenance, Support, and Migration by using Oracle Applications Project Accounting(Project Billing , Project Costing), Order Management, Shipping, TCA, Inventory, Receivables, Purchasing, Payables, ENCE(Engineering and Constructions), Oracle Financials, System Administration, Oracle Projects, and Application Object Library (AOL) modules (R12,11i, 11.0.x). Have strong conceptual, business and `analytical skills. Expert in SQL, PL/SQL, Reports 6i/2.5, XML Publisher, Forms 6i/4.5, Workflow2.6, SQL Loader, Forms Personalization, SQL Tuning Packages and Triggers by using Oracle 8i/9i.

ERP Expertise:

• 10+ years of experience with Oracle Applications R12/11i/11.0.3/10.7.
• Implementation experience and Technical, Functional expertise in Project Accounting (Project Billing, Project Costing), Order Management, TCA, Shipping, Oracle Projects,Inventory, Purchasing, Payables, ENCE, Accounts Receivables, Oracle Financials modules.
• Extensive experience in the EDI transaction programming of Ecommerce Gateway using GENTRAN/ CYCLONE.
• Specialized in Oracle Applications (Oracle Projects/Oracle Manufacturing/Oracle Distribution/Oracle Financial) skills with sound knowledge of their integration.
• Good Conceptual and working knowledge on Oracle Workflow2.6.
• Designed, developed & customized Workflows, Open Interfaces, Forms and Reports in Oracle Distributions / Manufacturing / Financial applications.
• Strong analytical and technical skills with good programming experience in SQL, PL/SQL, Developer 6i/2000 (Forms 6i/4.5, Reports 6i/2.5), SQL*Loader, UTL_FILE, Oracle Workflow 2.6, XML Publisher , IMAGENOW, Discoverer Reports, RXI Reports, FSG Reports,MD50 and MD70.
• Application tuning using TK-Prof and explain plan.
• Used Standard processes, Application Implementation Methodology (AIM), Six-Sigma Quality initiatives.
• Experience in Unit testing and System Integration testing.
• Strong Conceptual, Business, Analytical skills & highly motivated team player.
• Experience in working under software development methodology and is very proficient in Gathering Specs, Application design, development, customizations and coding.
• Extensive Experience in Process Flow and Requirements Analysis for the project and implementation of CMM Level.
• Post Production support, bug fixing and enhancement.
• Excellent verbal, written, communication and presentation skills.

Programming Languages: SQL , PL / SQL, Unix Shell Scripting, AWK programming and make utilities

Software used: Oracle 9i/8i/8.x/7.x, Oracle Forms 6i, Oracle Reports 6i, Workflow Builder 2.6, PL/SQL, Sql*Plus, SQL*Loader, Toad, PVCS, Smart Term, Telnet, Harvest, WSFTP, putty, Discoverer 4i, IMAGENOW.

System Development: Business Process Analysis, Testing, Documentation and Implementation.

Operating Systems: Sun Solaris , Windows 95/98/NT/XP and MS-DOS, UNIX.

Work Experience:

• Jan 2010 – Till Date

Oracle Application R12 Customization – Confidential,Cupertino, CA

• Lead Developer

Confidential,is a security company. Arcsight uses Oracle Applications to cater there software needs. This project involves customization of Oracle Applications using Oracle Forms, Oracle Reports and Oracle Interfaces, RXI Reports, FSG Reports and Oracle Discoverer.

Responsibilities Included:

• Order Management to Projects Interface (OM to PA Interface)

Developed an interface to pick the eligible lines from OM and create Project based on the Order. This interface creates Projects and tasks based on the Order Lines. Based on the grouping rules orders are grouped and formed as individual tasks for the associated projects. Project Name and Number are created dynamically based on the rules. This interface creates projects, agreement for the project and creates budgets and baselines the same.

• PO Account Generator Workflow

Customized the seeded workflow to generate the department, location, division and account based on the project and task.

• Projects Security Form & Security Extension

Designed and developed this custom form to capture the user access level of Region, Division, Project, Corporate based on the username and job title. PA Security Client Extension was modified to give access based on the user access level from the Projects security form.

• Projects Conversion

Designed and developed an api to convert the projects, agreements, create draft budget for approved cost and approved revenue, baseline the successful draft budget, fund the budgets, create agreements, convert the project costs and create events.

• Reports Developed

ARST Balance Sheet (FSG Report)
ARST Income Statement (FSG Report)
ARST AR Applied Receipt Register (RXI Report)
ARST AP Aging 7 Buckets (XMLP Report)
ARST AR Waterfall Report (Discoverer)
ARST GL Account Analysis Report (Discoverer)
ARST PA Weekly Labor Report (XMLP Report)
ARST PA Monthly Job Cost Report and XMLP bursting (XMLP Report)
ARST AR Invoice Printing (XMLP Report)

• Reports Developed

Responsible for supporting Custom Forms , Reports , Interfaces and fixing of day to day issues.

• Aug 2006 – Jan-2010

Oracle Application 11i Customization and R12 Upgradation – Confidential,Sanjose

• Technical Consultant

Confidential,is a major player in Engineering and Constructions Industry. Rosendin uses Oracle Applications to cater there software needs. This project involves customization and upgradation of Oracle Applications using Oracle Forms, Oracle Reports and Oracle Interfaces.
Responsibilities Included:

• R12 Projects Upgrade

Upgraded the existing custom reports, custom forms, custom interfaces and custom workflows from 11.5.10 to R12.Was involved in upgrading the existing Projects, Templates and Approved Cost Budgets and Approved Revenue Budgets to R12.

• Kronos Rates Override Form & PA Client Extension for Project Costing

Designed and developed this custom form to capture the override rates based on Employee, Project and Job title. This rate in turn will get picked when the standard costing program runs.

• Work Order Download

Designed and developed a program to download the work order details. Details include Key members for the work order, commitments, labor, non labor and retention. This download helps the project managers to review the status and expenditures for the project.

• Purchase Orders Conversion

Converted the Open Purchase Orders from legacy system to Oracle by using Oracle Open Interfaces.

• Supplier Conversion

Used the oracle open interface to convert the supplier, supplier sites and contact from the legacy system into oracle.

• Invoice Interface

Used Invoice Open Interface to bring in Invoices from external source into oracle.

• Zero Billed and Non Zero Billed Report

This report will show all the projects which have been zero/non zero billed to date.

• Imagenow Development and Support

Was involved in development and support of bringing in physical invoices into Oracle by using Imagenow. Also involved in designing and developing of programs to cold store reports by using image now.

• Jul 2005 – Aug 2006

Oracle Application 11i Customization – Confidential,Atlanta

• Technical Consultant

Confidential,delivers various products to its variety of customer’s worldwide. They have variety of Oracle Applications instances for their business. This project involves Customization of Oracle Application by developing Custom Forms and Custom Reports.
Responsibilities Included:

• Billing Extension for Project Billing

Developed an Interface to create billing assignment, create retention billing and to create draft invoice and draft revenue.

• Project Supplier Invoice Account Generator Workflow

Customized the seeded workflow to generate the account based on department, location, division and account based on the project and task.

• Usage and Miscellaneous Costs for Project Costing

Developed a Interface to bring in Usage and Miscellaneous cost from Payroll to Projects.

• EDI-943 Sub Inventory Transfer Notification

Sub inventory Transfer Information from the In-Transit Sub inventory to the Warehouse are sent to the Warehouse through the Ecommerce gateway.

• Custom Form Development:
• OSB Billing Form for Projects
• Billing Slab Form for Projects and Agreements

• Order Import Interface

Designed and developed the Order Import interface, to load the entire legacy orders in booked status into Oracle. Assigned the Order lines to Inventory organization based on the Business logic.

• Customer Import Interface

Used TCA HZ API’s to load the new customer details that come through order import program. HZ API’s were used to load party information like party sites, customer account, customer account sites, site uses and location details.

• Web Cash Interface

GE uses Webcash for the payments. This program extracts data from Accounts Payables and gives in the format of XML to webcash for the payments. This is an outbound interface that sends data in the format of XML for processing of payments.

• Developed the following reports using Reports :
• Amortization Report
• Job Activity Report for Projects

• Jul 2005 - Mar 2004

Company – Confidential,Singapore

• Consultant Oracle Applications

Fuji Xerox delivers value to clients worldwide by using its expert technical and professional services to implement effective document information solutions. The project involves Customization of Oracle Application by developing Custom Forms and Custom Reports.
Responsibilities Included:

• Item Master Conversion Program:

Designed and developed Item master conversion program to map the various types of legacy Items Spares, Equipments, and Consumables, and importing them into the respective inventory organizations..

• Vendor Import program:

Developed the vendor import program to convert the existing legacy vendors along with their respective sites and imported them into Oracle System.

• AR Invoice and Credit Memo Import

Developed a conversion program to upload Account Receivables Invoices and Credit memos using Auto-invoice program.

• Designed and developed the following Reports:
• Sub Inventory Transfer Report
• Sales Order Detailed Report
• Projects Worked before Mar 2004 are available upon request.

Education:

• Master of Computer Applications (MCA)