Oracle Project

Asit Bhatt, PMP

Orlando, Florida.

Phone: 321-***-****

Email:ablmt8@r.postjobfree.com

SUMMARY

. Over 15 years of techno-functional experience in Oracle Applications

10.6/10.7 /11i/12. Extensive hands on experience in Oracle Supply Chain

Management (Inventory, Purchasing, Order Management), Oracle Projects

Suite (Project Billing PJB, Project Costing PJC, Project Manufacturing

PJM), Oracle Financials (Oracle Account Payables, Oracle Receivables,

Oracle General Ledger), System Administration, Application Object Library

& Oracle HRMS, iPayments, Oracle Configurator, E-Business Tax(Ebtax) &

Sabrix Tax Engine.

. Experience in developing & managing customized forms and reports in

Oracle ERP using Oracle Forms 2.3/4.5/6i, Oracle Reports 2.5/6i,

Discoverer and PL/SQL programs.

. Experience in setups of different applications, customization, system

administration, data-conversion, interface programming, report creation

and concurrent programs in Oracle applications.

. Experience in different hardware like AS400, UNIX, LINUX etc.

. Excellent communication and interpersonal skills.

. Experience in implementation project with R12.

. Excellent coordination & Management skills.

. Project Management Professional (PMP) Certified.

PROFFESIONAL EXPERIENCE

Dell Inc (Dell Computers), Austin, TX

Apr-09 to Current

Project: Global Retail Order to Cash (EMEA, APJ, AMERICAS)

R12 Oracle Order Management, Oracle

Inventory,

Oracle Financials (AR, GL), Oracle Trade

Management, EBTax,

Application Object Library, Forms 6i,

Reports 6i, OA Framework.

Sabrix Tax Software, EDIs, XML Gateway,

HP PPM, ITIL

Role: Global Implementation Project Manager/Techno-

Functional Lead

Environment: R12 Oracle Applications, Oracle 11g, PL/SQL,

Developer Tools 6i (Forms 6i & Reports

6i), UNIX, TOAD, WIN XP,

Microsoft Office, HP Quality Center

(ITG), Project & Portfolio Mgmt.,

Inovis, Tradesphere, Affinity, .Net,

Microsoft Project Server, JAVA

Responsibilities:

. Create a project plan for conference room pilots & Integration

test cycles for Retail Order to Cash Project (ROTC).

. Use the PMBOK (Project Management) methodology to execute the

project.

. Use Microsoft Project to track the project and tasks.

. Work closely with consulting partners & dell employees.

. Coordinate between Business team, Solution Architect team,

Development team, testing team, offshore team, external systems

& external partners.

. Track the project as per project plan with milestones.

. Resolve the risk factors in the project.

. Develop a strategy to create BR100s, setup the applications and

update BR100 with requested changes.

. Track cost on project as well as adjusting the cost according to

project progress.

. Report to PMO about the project progress and risks.

. Use the ITIL process for resolving the defect tickets and

provide the better services to end users.

. Direct communication to the managers & team leads to help

improve the project performance and milestones.

. Liaison between Dell team and the Sabrix tax software to

implement the correct solution at dell.

. Help design and develop a Sabrix tax solution for R12 using E-

business Tax.

. Set up new R12 module E-business tax (Ebtax) for Tax

Calculation.

. Track the development components to develop on time and migrate

through different environments.

. Review MD50s & MD70s for the correctness of the business process

and development standards.

. Help streamline and standardize the naming convention for all

documents and component naming convention.

. Assist in managing the interfaces between DELL.COM .Net based

websites to Oracle Order management system.

. Maintain and update documents using the SharePoint repository.

. Develop a strategy for resolving defects during Conference Room

Pilots (CRPs).

. Work with business to develop a rollout plan in different region

across the globe.

. Develop instance strategy and creation of instance.

. Coordinate with development team to develop dell base coding

standards, Change requirements and maintenance of the documents.

. Create the policies & procedures for testing team for best

quality of the product.

. Develop a plan for knowledge transfer from consulting partners

to dell support.

. Manage & work closely with dell & consulting partner offshore

team.

. Help developer to design the JAVA based Oracle forms.

Masco Contractor Services Daytona Beach, FL

Mar-06 to Mar-09

Project: Oracle Purchasing, Oracle Payables,

Oracle Order Management, Oracle Projects,

Oracle Configurator, Oracle Inventory,

Schedule & Dispatch (Customized Module),

Oracle iStore

Oracle Quoting, Application Object

Library, Forms 6i, Reports 6i,

Sabrix Tax Software

Role: Functional Lead

Environment: Oracle Applications 11i (11.5.10.2), Oracle 10g,

PL/SQL,

Developer Tools 6i (Forms 6i & Reports

6i), LINUX, TOAD, WIN XP,

Microsoft Office, Mercury, PVCS, PERL

Responsibilities:

. Functional Lead PO, AP, OM modules.

. Set up accounts for the PO, AP & OM.

. Set up and convert the suppliers.

. Set up sourcing rules.

. Streamline the Procure to Pay process using PO, AP & OM.

. Use demand management to place PO based on sales orders.

. Set up and use the 3 way matching in payables.

. Use ITIL process for providing the best customer services.

. Production level support for the Order Management.

. Write MD50's for the customize process in OM.

. Set up different kind of Order types.

. Set up the key flexfields and descriptive flexfields.

. Provide the production level support to end users to clear the

stuck Orders.

. Participate and provide the solution of the critical processes

in Order Management.

. Run Pick release, ship confirm processes to balance the

Inventory.

. Create the different types of Orders using the template orders

and also using quotes.

. Production level support for the Schedule and Dispatch custom

modules.

. System testing for the new functionality.

. Regression testing of existing functionality.

. Coordination of the Integration testing with different teams.

. Involved in designing the end to end solution for the company.

. Manage the development team for the implementation of 11.5.10.2

version of the Oracle applications. This covers several areas

like Conversions, Interfaces & Extensions.

. Primary Contact for the initial conversion set up for all

modules like

PO, INV, AP, AR, OM.

. Lead to design the conversion task for migrating legacy data

into Oracle Apps.

. Created custom site using Oracle iStore.

. Give access to pricelist based on individual and/or business

customer.

. Created catalog for use in site using Oracle iStore.

. Created the MODEL for the Oracle Configurator.

. Primary technical resource for the Oracle Configurator.

. Set up the IMPORT SERVER to import BOM.

. Set up the link between two server for the publishing the model.

. Serve as a Configurator administrator.

. Created several UIs for the different models.

. Primary contact for Configurator UI creation.

. Wrote MD70s for different technical documents.

. Lead the interface effort to the PERL based website to Oracle.

. Primary contact between the business users and the technical

resource.

. Involved in set ups for the financial, supply chain modules.

. Functional lead for the Oracle Projects (Project Costing (PJC),

Project Billing (PJB), Project Manufacturing(PJM)) Set ups

. Set up Project Templates, Projects, Different tasks for

divisions and company.

. Set up the Purchasing, Inventory & Order management for the

Oracle Projects Compliance.

. Set up and tested the transactions from requisitions (PO)-

Account Payables (AP) to Oracle Project costing (PJC).

. Set up and tested the transactions from Order Management -

Project Manufacturing (PJM) -Project Costing & Billing.

. Suggest the customizations points to Oracle Projects Suite

modules to fit the current solutions.

. Lead the project to set up the custom credit check engine for

AR.

. Involved in Sabrix Tax engine debug process.

. Customize OAFRAMEWORK (JAVA based oracle form) form for Order

Management.

Priority Healthcare Corp. Orlando, FL

July-04 to Feb-06

Project: Oracle Account Receivables, Oracle Inventory,

Oracle Human Resources,

Application Object Library, Forms 6i,

Reports 6i, SER, sql*loader, iPayment,

Medical Billing

Role: Development Lead/Sr. Oracle Application

Developer & Programmer Analyst.

Environment: Oracle Applications 11i (11.5.9/11.5.10.2), Oracle

9i, PL/SQL, Developer Tools 6i (Forms 6i &

Reports 6i), UNIX, TOAD, WIN XP, Microsoft

Office, Track it, XML

Responsibilities:

. Create an interface using PL/SQL between Account Receivable and

ADP Payroll

Software.

. Create packages to import the employee data in Human resource

application.

. Create and modify forms & reports using developer tools 6i.

. Create LOCKBOX process between BANK and the Oracle applications

to import the payment data using SQL*LOADER.

. Register executable program in UNIX and Oracle Application

object library.

. Integrate ipayment with Oracle Account Receivable application by

creating new tables, Indexes, sequences.

. Set up Import and export of credit card transactions to FDC

North via iPayment.

. Set up ipayment for credit card transactions.

. Modify standard reports to custom reports.

. Production level support to Oracle Account Payables, Oracle

Account Receivables, ipayment, General Ledger.

. Develop OAFRAMEWORK (Java based Oracle form) based customized

form.

Cisco Systems, Inc. (Consulting), San Jose, CA Sep- 03

to July-04

Project: Oracle Account Payables, Oracle Purchasing,

Oracle General Ledger, AOL,

Oracle HRMS, Oracle Order Management,

Oracle Inventory, Developer tools 6i.

Role: Programmer Analyst & Oracle Application

Developer.

Environment: Oracle Application 11i, Oracle 8i/9i, PL/SQL,

Developer Tools 6i/9i, UNIX, Win2k,

Eudora, Test Director, ARIBA, Meeting

Maker, Cisco

Responsibilities:

. Active member as an analyst & developer for the upgrade project

from 10.7 to 11i.

. Modify the interfaces from Legacy application to Oracle Order

Management for upgrade purpose.

. Create & Modify the CISCO Merge Tool (CMT) for the merging of

multiple databases into one global database.

. Analysis of Oracle Purchasing, Oracle Account Payables & Oracle

Human Resources for the merge process.

. Analysis to merge 4 global databases into single database.

. Create scripts for pre-merge, merge; verification and post merge to

reconcile data.

. Execute the scripts during practice runs and verify the merged

data.

. Create documentation, log issues and resolve with business analysts

for upgrade and merge Oracle Applications 11i.

. Create database link, application responsibilities and create

privileges to global users for merge process.

State of Idaho Transportation Department, Boise, Idaho (Consulting)

Aug 98 - Aug 03

Project: Oracle Account Payables, General Ledger,

Purchasing, Inventory, Order Management, Human Resources

Management Systems, Supply Chain Management, Gascard,

Avista, Wright Express, Account Receivables, STARS, Oracle

Developer tools 6i upgrade.

Role: Team Lead.

Environment: Oracle 7.x/8i/9i, PL/SQL, Oracle Applications

10.7SC/11.0.3/11i, Developer Tools (forms, reports etc),

Discoverer, Comptru64 UNIX, Windows 95, NT & 2000,

Mainframe, Abra

Responsibilities:

. Project Leader for implementation of Developer tools 6i, which

involves creating implementation plan, communication with all Users

Company wide, and provide support after implementation.

. Collect requirements from Payables users and provide the best

possible technical or functional solutions using Oracle tools like

FORMS, PL/SQL, and REPORTS etc. for their custom requirements.

. Developed the invoice tracking form, vendor list reports etc. in

Oracle Payables using 6i tools.

. Modified the CUSTOM.PLL for customization of Oracle financials (AP,

GL) & Supply chain (PO, INV) applications.

. Data transfer into Oracle Payables using the interface invoice import

and load the data into AP_EXPENSE_REPORT_HEADERS &

AP_EXPENSE_REPORT_LINES interface tables.

. Create SQL*LOADER file using PL/SQL for different kinds of data

conversions.

. Create the custom package interface for Gascard, Wright Express &

Avista to Oracle Inventory transfer (MTL_TRANSACTIONS_INTERFACE) by

using PL/SQL, TRIGGER & register in Oracle Application as a

concurrent program.

. Create Warehouse Location reports, Active Item list report, and

Catalog label report in Oracle Inventory.

. Create fuel card form, MTL_TRANSACTIONS_INTERFACE modifications form

to edit data in Oracle Inventory.

. Help users to identify correct problems related to setups in Oracle

Applications.

. Create control file using SQL/LOADER for different custom concurrent

programs under UNIX environment and used it in Oracle applications.

. Provide production level support to AP, PO, INV, OM, GL, AR, HR etc.

. Import orders using the open interface ORDERIMPORT in Order

Management.

. Modify, Develop or customize program as a result of users list of

issues related to Order Management.

. Create the custom interface between Purchasing to STARS (Statewide

Accounting & Reporting System) using PL/SQL.

. Create the database trigger using PL/SQL to process 215,220 type

transactions in PO.

. User open Requisition interface to import third party requisitions

into Oracle Purchasing.

. Debug error data in GL_INTERFACE for JOURNAL IMPORT process in

General Ledger.

. Reconciled the GL process and transactions to STARS specially mapping

encumbrance.

. Create database trigger to manually record the ENCUMBERANCE into GL.

. Help user to setup the ACCOUNTING KEY FLEXFIELD.

. Complete knowledge of data flow between different applications like

INV, OM, PO, AP, AR, and GL.

. Design generic error handling modules using Oracle Forms 6i for both

users and developers.

. Develop forms using forms2.3 according to user's requirement.

. Create DISCOVERER REPORT for the users by using discoverer tools.

. Provided complete support and maintenance of Oracle Financials System

(Account Payables, Account Receivables & General Ledger) to STARS

system at state controller office.

. Worked extensively on Account Payables, Account Receivables, register

forms, reports, create descriptive flex fields; value sets and write

interface programs.

. Customized standard Lockbox interface for Account Receivables

. Developed and modified interface scripts for STARS system.

. Supported and maintained Oracle Supply Chain Management system

(Inventory, Purchasing & OM). This included developing custom forms,

reports and interface scripts. Wrote custom interface from non-oracle

systems. Debugged demand inventory problems.

. Use Order Import interface in Order Management to import orders.

. Extensive experience with Oracle System Administrator. Performed

registration/migration of concurrent programs, registered custom

applications and processes, set up of user accounts, set up of

flexible fields, created customized functions, mapped with UNIX

systems, created menus, value sets, document sets, request sets,

report groups and installed new printer styles using corresponding

drives, registered custom forms and reports into Oracle Applications

modules.

. Convert data from AS400 system to UNIX based OS.

. Developed forms, reports using developer tools forms & reports

version 4.5, 2.5, 6.0 & 6i.

. Maintained on as needed basis Oracle modules like Project Accounting

and Oracle Training.

. Developed, modified and supported Employee Safety Services customized

module using developer tools 6i (forms & reports). Also created

special reports for Civil Rights division.

. Developed and modified database triggers to deliver required

functionality

. Use EXPLAIN PLAN, TKPROF SQL & PL/SQL for tuning.

. Opened bugs (iTAR) with Oracle Technical support.

Shah Inc. New York, NY

Sept 96 -Aug 98

Project: Supply Chain Management, Human Resources Management, Financials

Management and System Administration

Role: Team Lead.

Environment: ORACLE 7.x, SQL, PL/SQL, Developer 2000, Oracle

Applications 10.7 SC, SQL*LOADER, Solaris

Description: The scope of the project was to develop a system that

keeps track of all the orders in various branches of a

multinational Diamond company.

Responsibilities:

. Designed logical and physical database.

. Install Oracle on Solaris based system.

. Created Oracle database to track Orders for all branches for

multinational diamond company

. Designed and developed front end in Developer 2000 for data manipulation

and navigation.

. Create menu based reporting system that provided analysis for scheduling

and profitability.

. Created Stored Procedures using PL/SQL to improve performance.

. Created triggers to enforce database consistency and integrity.

. Supported Supply Chain Management, Human Resources Management &

financials modules.

Sun Holographic Inc, India

July 94-Sep 96

Project: Create the customer and item database, forms &

Reports

Role: Developer

Environment: Oracle 7.x, Oracle Developer Tools, Microsoft Access

Responsibilities:

. Create PL/SQL program/interfaces.

. Create/Modify new forms and reports using Oracle Developer

tools

. Import data into Oracle from MS Access.

. Maintenance related to Oracle and MS Access data.

Technical Summary

Languages: C, SQL, PL/SQL

Applications: Oracle Applications 10.6/10.7 SC & E-Business Suite11i

Oracle HRMS, Oracle Supply Chain Management (INV, PO, OM),

Oracle Financials (AP, AR, GL), Oracle System

Administration,

Oracle Application Object Library, Oracle Projects

Government Custom Interfaces: STARS (Statewide Accounting &

Reporting System), Gascard, Avista, and Wright Express,

Employee Safety Program

Oracle Application R12, Sabrix, Trax

Database & Tools: ORACLE 7.X/8i/9i, Oracle Developer 2000 (Forms 4.5,

6.0& 6i and Report 2.5, 6.0 & 6i, Query builder, Procedure

builder etc)

SQLFORMS 2.3, DISCOVERER, Microsoft Access, SQL*LOADER,

TOAD, PL/SQL Developer, Microsoft Project Server, Microsoft

Office Tools.

Environment: Windows 95, 98, 2000, NT & XP, and UNIX,

Hardware: IBM and IBM - PC Compatibles, Comptru64 UNIX, LINUX,

SOLARIS, AS400

EDUCATION

Master of Science in Electronics

Post Graduate Diploma in Business Administration

Certified Project Management Professional(PMP)

References available upon request

U.S. Legal Status: U.S. CITIZEN

Contact this candidate