Oracle Project Manager

Vishal Goel

Vishal Goel has about eleven years of experience in techno-functional Oracle Applications implementation, customization, development and support across Asia Pacific and Europe. He combines strong core business knowledge in multiple business areas with expertise in a wide range of Oracle Application modules and a solid Technical Systems knowledge.

He has worked with clients in High Technology, Software, Government, Manufacturing sectors and financial industries; his areas of expertise in the Oracle E-Business Suite extend to: Oracle Financials, Payments, System Adminisration and Self-Service applications. He has experience with Global Roll outs, Multi-org Implementations, customization design, development and testing, user training, production and significant post Go-Live support of Oracle Applications.

Vishal is an Oracle Certified Professional (OCP) - 9i DBA. He has extensive work experience on analysis, designing, development, customization, maintenance, and documentation of RICE components, OA Framework/ Form extension, Workflow customization, and BI/XML Publisher reports. He is also certified Project Management Professional (PMP).

TECHNICAL SUMMARY

Oracle E-Business Suite

Oracle Applications R12, 11.5.10.2, 11i

Oracle ERP Modules

Extensive Experience: AP, PO, AR, GL, CE, PA, HR, Payroll, IBY, Sys Admin

Supplementary Experience: Sourcing, Contracting

Oracle E-Business Components

Oracle XML Publisher, Oracle Workflow, Oracle Financial Statement Generator (FSG), Oracle Approval Manager (AME), Oracle Alerts, SQL*Loader

Databases

Oracle 11g (11.2.0.1), Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools Oracle SQL, PL/SQL, Oracle JDeveloper 10g/11g, Oracle Forms 10g/6i, Oracle Reports 10g/6i, Oracle Workflow Builder 2.6, Oracle Discoverer 10g/4i

General Tools Toad, SQL Developer, Microsoft Office, MS Visio, PVCS Source Control Manager, Microsoft Visual Source Safe, Test Director, HP Quality Centre

OS Platforms HP-UX, Windows NT/XP

WORK EXPERIENCE

Feb-2012- Oracle R12/12.1.3 Implementation Senior Techno

Till Date Order Management, BOM, WIP Functional Consultant

At BIC Graphics USA

This is implementation of Oracle E-Business Suite Release 12i and 11.5.10.2. It also includes reports conversions to XML Publisher.

Responsibilities:

• Review MD 50 documents and liaison with Business Analyst.

• Mentor a team.

• Design various XML publisher in BOM, WIP and Order Management modules

• Manage Project Management Plan and priorities task

• Time Estimation of RICEW components.

• Involved in UAT and BR 100 Setup

• Provide assistance to Project Manager in estimating work efforts

Dec 2006 –

Jan-2012 Oracle R12/ 11.5.10.2 Upgrade and Support on OTC, P2P, Payments, Order Management, Cash Managements, Sourcing and Contracting at NHS UK (Through Steria)

Senior Techno-Functional Consultant

This project involves multiple implementation also includes upgrades of various modules of Oracle E-Business Suite Release 12 and 11.5.10.2. It also includes reports conversions to XML Publisher.

Responsibilities:

• Analyzed various changes and new features of Oracle E-Business Suite R12 that affect custom business flows and application customizations

• Performed E-Business Suite System Administration security audit on Users, Menus and Responsibilities; Clean-up obsolete Workflow/ setup data in preparation for R12 upgrade

• Designed and developed Purchase Order report, AR Invoice reports, Dunning Letters, AP Check and FSG reports using Oracle BI Publisher

• Payment Process Request (PPR) automation in Oracle R12

• OA Framework Extension/ Personalization on Payment Administrator screen

• Implemented Quoting Approval using Oracle AME and PL/SQL as per business requirement

• Customized the fulfillment set defaulting rule process in Sales Order form thru CUSTOM.pll and Forms personalization’s.

• Developed Oracle Forms using Oracle Forms to calculate the balances of GL to prepare the balance sheet

• Design the form for Cash book automation in Cash Management

• Developed concurrent program to auto approve the AP invoices

• Design the form to view the PO/Requisition/Invoice approval/ Sales Order Approval /CMR notifications

• Used OAF personalization/extension to view the notifications to all desired user.

• Integrated Contracting and Sourcing with PO.

• Responsibilities include preparing the user interface, coding, testing and coordination with the other team members for the overall integration of the project.

• Writing Technical specifications and proposals these include various pl/sql packages, concurrent programs.

• Worked on Oracle Applications Forms personalization

• Fixing the bugs/change of request for further enhancement.

• Responsible for release the product/code in the production as per the schedule.

• Provide technical support to application support team

• All work carried out following Oracle AIM methodology i.e. MD70, TE20 etc wherever necessary

• Liaising with Project Management.

• Documented Business Scenarios, Issue Logs, test schedules, instance control logs

Environment: Oracle E-Business Suite R12/ 11.5.10.2 Financials/ Sourcing/Contracting (GL, AR, AP, OM, IBY, Sys Admin), Oracle Database 11g/10g/9i, Oracle XML Publisher 5.6.3/10g, Workflow Builder 2.6, Developer Suite 10g/6i, JDeveloper 10g, Oracle Application Express 3.2, FTP Putty, Toad, SQL*Plus, SQL*Loader, FileZilla, Visio.

Nov 2004 –

Dec 2006 Oracle Financials, HR and Payroll and Support projects at Carillion, UK (Through Accenture) Oracle Applications Consultant

This project is a fresh full cycle implementation of various modules of Oracle Application E-Business Suite 11.5.10 Financials, Projects, HR, and Payroll across UK.

Responsibilities:

• Created promotion packages to migrate the custom objects to different instances using FNDLOAD and UNIX shell scripts.

• Developed numerous application extensions using Oracle Developer Suite 6i, Forms Personalization/ CUSTOM.pll, Unix Scripting, and PL/SQL Stored procedures.

• Developed several reports using Reports6i; Customized standard AP and AR reports

• Designed and developed AP Check, Purchase Order using Oracle XML Publisher reporting tool

• Proposed solutions for identified GAPs, Issue resolutions, escalations, and Oracle TAR support.

• Involved in gathering and analysis of requirements, building of technical design documents MD70 including Unit Test Case in line with Oracle AIM methodology and bottom line responsibility for getting development completed and delivered.

• Guiding the Technical development team, explaining the requirements and reviewing the technical design.

• Modifying payment format programs in Oracle Payables and testing the check and EFT payment process

• Developed the outbound interface to generate the extracted date file from Oracle Application to third party system.

• Workflow customization – Requisition Approval/ Purchase Order Approval.

• Design interfaces and reports in Payroll.

• Developed new forms in Project Accounting, Purchase and done customization in Requisition, Purchase Order forms through form personalization

• Design and develop the outbound interface for Project costing.

• Design the new pay slip reports in Oracle payroll to print on the pre printed stationary

• Actively involved in release management to release and deploy components in production and other environments. Objects developed at IDC are released by a migration process. This process uses the VSS and PVCS tools.

Environment: Oracle E-Business Suite 11.5.10 Financials/ HRMS/Payroll (AP, PO, GL, PA, HR, Payroll, Sys Admin), Oracle Database 9i, Oracle XML Publisher 5.5, Workflow Builder 2.6, Developer Suite 6i, Toad, SQL*Plus, SQL*Loader, VSS, PVCS, Visio.

Mar 2004 –

Oct 2004 Product Development (FinnOne) for Banking and Financial Services Industry (BFSI) at Nucleus Software Exports, India

Developer Analyst

The scope of the project includes develop product called ‘FinnOne’. FinnOne is an integrated suite of Financial Software Applications, developed to meet the requirements of Banks and Financial Services Companies.

Responsibilities:

• Involved in gathering and analysis of requirements.

• Prepare the program specification (PS) corresponding the functional specification document

• Design the layout of the form (GUI).

• Oracle server installation.

• Database Creation and Maintenance.

• Maintenance Project VSS using Microsoft Visual Source Safe-6.0.

• Design and develop new Forms using Oracle Form 9i

• All the quality procedures as per CMM guidelines were followed so that quality could be maintained

• Involved in techno-functional documentation, key user coordination, pilot and user acceptance (UAT) tests. Performed user trainings on newly implemented applications.

• Worked on Gap Analysis and Solutions design. Performed setup and configurations from development instance to all instances including production instance.

• Created several financial reports.

Environment: Oracle Database, Oracle Developer Suite 6i/2000, Microsoft Access 2000, HP-UX, Toad, SQL Developer, Visio

May 2001 –

Mar 2004 ERP Product Development at 4C Plus Internet Private Limited, India

Oracle Developer

This project is a ERP development project for a Medium and Small Segments industry using Oracle database and development tools.

Responsibilities:

• Installation, configuration Oracle8i in Windows environment.

• Gathering functional requirement from business across the modules for various clients.

• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages; various stored procedures were written to achieve the backend functionality.

• Created Technical and Functional program specifications and documentations

• Data loading using SQL* Loader.

• Design and Create Forms based GUI using Oracle Forms

• Developed Reports using Oracle Report and SQL* Plus scripts

• Prepare and execute Unit Test Plan

• Provide technical Support to Team

• Application tuning which involves evaluating the execution path and cost of execution of SQL Statements and thereby optimizing these SQL Statements either by restructuring the queries or by creating and rebuilding the different kind of indexes.

Environment: Oracle 8i, Oracle Forms 6i, Oracle Reports 6i, Windows NT, SQL*Plus, SQL Loader

Professional Education

Master of computer Applications (MCA)

Bachelor of Science in Mathematics (B.Sc.)

Professional Training/Certifications

Project Management Professional (PMP)

Oracle Certified Professional (OCP) - 9i DBA

Oracle Certified Professional (OCP) - 8i DBO

Certification for Oracle 9i DBA Fundamental 1 from Oracle Education India

Certification for Oracle Application 11i e-Business Suite from Oracle Education India

References

Will be provided upon request.

Contact this candidate