Project Oracle

Joseph

Mobile: 408-***-****

Email: abhwh4@r.postjobfree.com

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 - Oracle Application R12 Customization - Arcsight Inc, Lead Developer

Till Date Cupertino, CA

Arcsight Inc 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 - Oracle Application 11i Customization and R12 Upgradation Technical

Jan-2010 - Rosendin Electric Inc, Sanjose Consultant

Rosendin Electric 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 - Oracle Application 11i Customization - General Electric, Technical

Aug 2006 Atlanta Consultant

GE Energy 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 Oracle Application 11i Customization - Fuji Xerox Consultant Oracle

2004 Company - Ness Global, Singapore 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

V Projects Worked before Mar 2004 are available upon request.

Education:

. Master of Computer Applications (MCA) from University of Madras,

Chennai.

Contact this candidate