Pranav Pandya

Professional Summary

Pranav has **+ years of experience in IT industry and around 11+ years in Oracle Applications 11i. His skills include gather and document business requirements based on EBS technology, Leverage EBS experience while designing technology solutions based on business requirements. Oversee application test plan development, coordinate application testing and test where appropriate. Ensure that all functional, design, development and implementation artifacts adhere to standards and implement the specified design. Interact with business owners and users throughout the development lifecycle to ensure solutions meet requirements and expectations.

Pranav has Techno functional expertise in Business analysis and developing system applications using Oracle Applications 11i & R12 with expertise in the following modules

1. Oracle Supply Chain management (OCM)

2. Procurement (PO)

3. Inventory (INV)

4. Descript manufacturing (BOM,WIP)

5. Finance (AP,AR,GL)

Email Address: hg59ex@r.postjobfree.com

Education

Degree University Year of Passing

MCA Bhavnagar University (06/1998)

B.Sc (Physics) Bhavnagar University (04/1995)

Experience

Organization Designation Duration

Mastech Inc Sr. Consultant (09/2007) – Till Date

Bearing Point Inc Sr. Consultant (06/2006)- (09/2007)

Satyam Computer Services Ltd., Sr.System Analyst (01/2004) – (06/2006)

Lotus System Integration Pvt. Ltd., System Analyst (06/2000) – (12/2003)

Magnum Ltd., System Analyst (06/1998) – 06/2000)

Technical Skills

Hardware PC-AT x86 compatible

Operating Systems Windows 95 / NT/2000, MS-DOS, UNIX

Languages PL/SQL, C, C++, COBOL, PASCAL, Application Object Library (AOL)

Databases Oracle 7.3/8.0/8i to 11g

GUI Oracle Forms ,Report ,Discoverer Report,

Oracle Business Intelligent (OBIE)

Tools & Utilities SQL Loader, Export, Import, Workflow Builder Discoverer

ERP Oracle Applications versions 10.0/11i – oracle supply chain management, Manufacturing covering Inventory, Purchasing, Order Entry, Financials covering Account Receivables, Account Payables, General Ledger, Inventory and Application Object Library.

MAXIMO

Projects Profile

13. Project Name: Oracle Applications Enhancement & Support)

Client Commercial Metal Company –USA

Role Oracle Application Sr. Consultant

Organization Mastech Inc.

Duration (09/2007) – Till Date

Team Size Project : 50 Module :All Finance & oracle supply chain management

Environment

(with skill versions)

Software

Oracle Applications: 11.5.10 Languages : SQL, PL/SQL

Database : Oracle 11g

ERP : Oracle Applications 11i

Tools : Developer 6i (Forms 6i , Reports 6i), 9iAS, Oracle Workflow Builder, TOAD, Discover Admin & Desktop

O/S: UNIX (Sun – Solaris).

Web Server :9iAS

Project Description

This is an Oracle Applications Implementation ,Enhancement & Support project for Commercial Metal Company (fortune 500 company) –USA client. The Oracle modules covered under this track are oracle supply chain management (Procure to Pay and Order to Cash) Finance (GL, AP AR, FA)

Full cycle Implementation:

While working on this project I have successfully completed 5 full cycle implementation for below business.

• Cometal South Carolina

• Cometal Steel

• Cometal Switzerland

• CMC EMEA

• CMC Germany

Currently working on CMC Singapore implementation.

Involved in

• Functional and Technical analysis & requirement gathering

• Designing the technical document.

• Develop custom (Forms/Reports/PL-SQL scripts) as per the requirement

• Data conversion

• Performance Testing and Analysis

• Tuning assistance to developers

• Develop discoverer reports

12. Project Name: Commercial

Client U.S. Department of Health and Human Services

Role Oracle Application Consultant

Organization Bearing Point Inc,Mclean,Virginia

Duration (06/2006) – Till Date

Team Size Project : 24 Module :All Finance Module

Environment

(with skill versions)

Software

Oracle Applications: 11.0.4,11.5.9 Languages : SQL, PL/SQL

Database : Oracle 9i

ERP : Oracle Applications 11i

Tools : Developer 6i (Forms 6i , Reports 6i), 9iAS, Oracle Workflow Builder, TOAD

O/S: UNIX (Sun – Solaris).

Web Server :9iAS

Project Description

This is a federal project for Health and Human services client. The Oracle modules covered under this track are Purchasing, Receivables, General Ledger, Accounts Payable and Grants.

Involved in

• Technical analysis & requirement gathering

• Designing the technical document.

• Develop custom (Forms/Reports/PL-SQL scripts) as per the requirement

• Performance Testing and Analysis

• Tuning assistance to developers

• Design and develop Financial Interfaces (AR,AP,PO,GL )

• Develop Dashboard using Oracle Business Intelligent

11. Project Name : Oracle Applications Enhancement & Support

Client General Electric (GE Infra Energy) –U.S.

Role Oracle Application Consultant

Organization Satyam Computer Services Limited, India

Duration (08/2005) – (06/2006)

Team Size Project : 10 Module : 2

Environment

(with skill versions)

Software

Oracle Applications: 11.0.4,11.5.9 Languages : SQL, PL/SQL

Database : Oracle 9i

ERP : Oracle Applications 11i

Tools : Developer 6i (Forms 6i , Reports 6i), 9iAS, Oracle Workflow Builder, TOAD

O/S: UNIX (Sun – Solaris).

Web Server :9iAS

Project Description

Oracle Application’s Oracle Purchasing and Oracle Payable modules are integrate with Custom Supplier application/portal (Order to Settlement).

Suppliers can perform the following task from Order to Settlement application, which are integrating with Oracle application.

• View/Accept/Amend the PO’s sent from Oracle applications

• Create Advance Shipment Notice (ASN)

• Create Invoice

• Create Credit Note

Order to Settlement is integrated with below Business each business have different Oracle Application instance

1. Aero

2. Parts

3. NRPS

4. GAS

5. Corporate

6. Reuters -Stokes

7. Oil & GAS

Contribution

As a Technical Leader, responsible during enhancement

• Analyze the requirement

• Interaction with the ERP business analysts Team.

• Design as per the requirement

• Preparation of Integration Design Document

• Allocating and Monitoring work to team members

• Develop Concurrent Program

• Interface Program

Export Site Information

Print PO on OPTI Printer

Import PO Status Through W/F

Export Cancel PO

Import Purchase Receipt (Advance Shipment Notice)

Export Purchase Receipt & Status

Invoice Import (Oracle Payable)

Export Invoice Status

• Preparation of URD’s of the custom components

• Test Case preparation

As a Technical Leader, responsible during Support

• Analyze the Problem & provide a analysis

• Find out the Route Cause for the unique problem & Provide unique solution

• Develop Ad-hoc reports.

• Support Central Activity

10. Project Name : Oracle Applications 11i Implementation

Client QATAR TELECOM -QATAR

Role Technical Lead

Organization Satyam Computer Services Limited, India

Duration (04/2005) – (06-2005)

Team Size Project : 10 Module : 2

Environment

(with skill versions)

Software

Oracle Applications 11.5.9 Languages : SQL, PL/SQL

Database : Oracle 9i

ERP : Oracle Applications 11i

Tools : Developer 6i (Forms 6i , Reports 6i), 9iAS, TOAD

O/S: UNIX (Sun – Solaris).

Web Server :9iAS

Tool: Oracle Configurator

Project Description

Qatar Telecom, a Qatar based telecom company; It is only one company in Qatar which providing the tele connection and other teleservices to the country

Qatar Telecom intends to implement an Oracle sales Management module for Oracle Application the objective of the ERP implementation is to:

• Improve process efficiency

• Integrate business applications

• Replace the majority of home-grown solutions

Implement new systems that will support the business changes and leverage e-commerce opportunities.

Contribution

As a Technical Leader, responsible for

• Analyze the requirement

• Design as per the requirement

• Preparation of Integration Design Document

• Allocating and Monitoring work to team members

• Test Case preparation

• Interface Program

Customer Interface

Customer Account Interface

Item Interface

Bills of Material Interface

• Develop Concurrent Program

• Preparation of URD’s of the custom components for the Account Payables module

• Coordination with the Offshore team

• Interaction with the ERP business analysts Team.

• Designing and firming up specifications for database

• Reports Development and Testing

9. Project Name : Oracle Applications 11i Implementation

Client Balfour Beatty, UK

Role Module Leader

Organization Satyam Computer Services Limited, India

Duration (01/2004) – (04-2005)

Team Size Project : 30 Module : 5

Environment

(with skill versions)

Software

Oracle Applications 11.5.9 Languages : SQL, PL/SQL

Database : Oracle 9i

ERP : Oracle Applications 11i

Tools : Developer 6i (Forms 6i , Reports 6i), 9iAS, TOAD

O/S: UNIX (Sun – Solaris).

Web Server :9iAS

Project Description

Balfour Beatty, a UK based business group serves the market for rail, road and power systems, buildings and complex structures and is active in four main business sectors which are

• Building, Building Management and Services

• Civil and Specialist Engineering and Services

• Rail Engineering and Services

• Investments and Developments

Balfour Beatty intends to implement a tightly integrated backend ERP System for Finance, Human Resources, Procurement, and Project Management across their operating companies in the UK. The initial implementation will be for 5 operating companies – Balfour Beatty Construction Limited, Balfour Beatty Civil Engineering Limited, Raynesway Construction Southern, Stent Foundations and Balvac/RailFirst/Testal. The objective of the ERP implementation is to:

• Improve process efficiency

• Integrate business applications

• Replace the majority of home-grown solutions

Implement new systems that will support the business changes and leverage e-commerce opportunities.

Balfour Beatty Invoice Gateway (BBIG) is being developed to act as the single point of Invoice input for Material, Plant and PNPO Invoices (both Paper and Electronic).Invoice may come in different format i.e. XML, CSV. The functionality of automatic matching of supplier material invoices with the supplier tickets will also be handled in BBIG and these invoices will be transferred to Accounts Payable (AP) module only after they are fully matched in BBIG, BBIG is also linked with Document server which stored the scanned image of invoice, User can select the document and enter the invoice accordingly and after saving they can retrieve the same for reference purpose.

Contribution

As a Module Leader, responsible for

• Analyze the requirement

• Design as per the requirement

• Designed and Developed Custom BBIG Entry Screen ,BBIG Error Work bench and BBIG Enquiry Screen similar to standard screens to facilitate quick data entry

• Preparation of Integration Design Document

• Allocating and Monitoring work to team members

• Test Case preparation

• Customization of Forms and Reports

• Interface Program

• Develop Concurrent Program

• Preparation of URD’s of the custom components for the Account Payables module

• Coordination with the Offshore team

• Interaction with the ERP business analysts Team.

• Designing and firming up specifications for database

• Reports Development and Testing

8. Project Name : Oracle Applications 11i Implementation

Client Lubi Electrical Ltd

Role System Analyst

Organization Lotus System Integration Pvt. Ltd.,

Duration (01/2003) – (12/2003)

Team Size Project : 16 Module : 6

Environment

(with skill versions)

Software

Oracle Applications 11.5.4 Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : Window 2000

Project Description

Lubi Electrical ltd., is an India base company having branches in U.S.A, Europe, Singapore and other medal east country. It is an electrical motors and submersibles manufacturing company.

Lubi Electrical ltd., intends to implement a tightly integrated backend ERP System for Manufacturing, Finance, Procurement, Project Management and Commercials.

Contribution

• Preparation of URD’s of the Manufacturing and Finance Module

• Preparation of the IDD’s of the custom components and data migration scripts for the Manufacturing module

• Customize the reports, forms and workflow

• Create Interface

• Develop New report and Workflow

7. Project Name: Oracle Applications 11i Implementation

Client Alps Chemical Ltd

Role System Analyst

Organization Lotus System Integration Pvt. Ltd.,

Duration (06/2002) – (12/2002)

Team Size Project : 12 Module : 5

Environment

(with skill versions)

Software

Oracle Applications 11.5.4 Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : Window 2000

Project Description

Alps Chemical Ltd., is an India base company having branches in U.S.A & Canada , and medal east country. It is dyestuff-manufacturing company.

Alps Chemical Ltd., intends to implement a tightly integrated backend ERP System for Manufacturing, Finance, Order Management and Commercials.

Contribution

• Preparation of URD’s of the Manufacturing and Finance Module

• Preparation of the IDD’s of the custom components and data migration scripts for the Manufacturing module

• Customize the reports, forms and workflow

• Create Interface

• Develop New report and Workflow

6. Project Name : ‘NEURON’ an ERP

Client 1. Hi-tech Investment Casting Ltd. (Shihor)

2. 20 Microns Ltd (Baroda) and 24 locations across the India.

3. Mira Electrical

4. Lubi Submersible Ltd.

5. Lubi Motor & Pumps Ltd.

Role Project Leader

Organization Lotus System Integration Pvt. Ltd.,

Duration (08/2001) – (05/2002)

Team Size Project : 5 Module : 16

Environment

(with skill versions)

Software

Neuron Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : Window 2000

Project Description

Neuron is an ERP, which covers the following modules.

1. Marketing & Sales

2. Purchase & Purchase Order Processing

3. Store / Inventory

4. Account

5. Design / Engineering

6. Production

7. Quality Control

8. Job Work (From / To/ Both)

9. Production Planning

10. Maintenance Work

11. Maintenance

12. ISO Documentation

13. Excises Documentation

14. Export Documentation

15. Administration

16. Data Integration

Neuron design such a way that it can be configured for any type organizational requirements. Like we can increase or decrease the steps in marketing module (Enquiry->Quotation->Sales Order -> Sales Order Acceptance ->Dispatch -> Non-conformity Rejection -> Actual Rejection).As per client requirement we can change the route of module without changing one line of source code. Neuron is especially design for Investment Casting industries and mechanical engineering industries. For whom Production and Production planning is very important. In terms of configuration and implementation it is very easy process in Neuron. In Gujarat we have more than five implementations of Neuron.

Client Type: Investment Casting, Microns, Chemical, Foundry, Mechanical Engineering, Etc.

Contribution

Functional Responsibility:

• System Study and Design the Neuron

• Conceptualize the ERP

• Understand the client’s business requirement

• Generate the requirement documents (As per ISO Standard), which are useful in further configuration of ERP.

• Configure the System as per client’s requirement.

Technical Responsibility:

• Tune the application for better performance.

• Data base Designing as per Data volume

• Tablespaces creation.

• Setup the database for Replication.

• Made Schedule to Replicate the data

• Replicate the data with the use of Dial-up Network.

• Planning & Database Administration

• Set the back-up strategy for client

• Security management for Neuron

5. Project Name: ERP for Chemical Industries

Client Dytint Chemical Ltd.

Role Project Leader

Organization Lotus System Integration Pvt. Ltd.,

Duration (07/2000) – (07/2001)

Team Size Project : 4 Module : 10

Environment

(with skill versions)

Software

Neuron Classic Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : WindowNT

Project Description

Company is geographical divided in to more then two location and mainly engaged in Chemical Export business; we developed different Modules like Order Processing, Sales, Purchasing, Work Order Processing, Job Work, Sampling, Batch Processing, Export Documentation, and Inventory with RMC Costing. Basically company wants to maintain their database centrally, every day they want to transfer data from remote location to Head Office. To achieve the challenge, Replication of Data is required. Every day data automatically update the Head office Database. We replicate the database with the use of Dial-Up Network.

Contribution

• System Analysis and Design

• Data base Designing as per Data volume

• Installation of Oracle V8.1.5, Developer 2000 V2.1

• Setup the database for Replication.

• Made Schedule to Replicate the data

• Replicate the data with the use of Dial-up Network.

• Planning & Database Administration

• User Management, Connectivity of client and server using SQL*Net V8

• Assisted team members in optimizing of SQL statements, Trouble shooting

4. Project Name : Integration Between Oracle Apps & MAXIMO

Client Gujarat Chemical Port Terminal Company Ltd.,

Role Team Leader

Organization Magnum Ltd.,

Duration (04/2000) – (06/2000)

Team Size Project : 5 Module : 5

Environment

(with skill versions)

Software

Oracle Applications 10.0.4, MAXIMO Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : Window NT

Project Description

Gujarat Chemical Port Terminal Company Ltd. is a Chemical Port owned by Gujarat Government. Wanted to Implement Oracle apps and MAXIMO in there organization and also wanted to integrate both the ERPs and wanted to developed on One billing which is going to integrate with Oracle Apps’s AR Module.

Contribution

My role and responsibilities as an ‘Oracle Database Administrator’ & ‘System Analyst’ in a team of 5, database initial size of 15GB includes, Primarily responsible to shoulder the total Integration of Oracle Applications And MAXIMO. Major role comprised of identifying the areas of interfaces, integrate them, test the interface & make the necessary changes into the procedures & triggers as & where required. Also involved in the design and development of Billing System in D2k (V1.6.1) as a front end, which is integrated with AR Module of Oracle Applications.

For Implementation & Interface with Oracle Apps I took Training from PSDI People. :

MAXIMO Implementation & Interface with Oracle Application.

• Create large Database size of 15GB including multiple databases running simultaneously. The Database includes

1. Demo Version.

2. C.R.P Version.

3. Production Version

• Installation of MAXIMO V4.0.1 at each client,

• Installation of MAXIMO’s Data Dictionary Tables.

• Customize the MAXIMO’s Module as per client requirement

• Data Configuration As per Requirement

• Define MAXIMO Security

• Create Customize LOV

• Create Customize Report with the use of MAXIMO’s Report Creation Tools.

• Make a Setting for G.L

• Make the required changes in Database Configuration (e.g. Data type, Data width, Set LOV etc.). As per requirement for Interface with Oracle Apps.

• Create User for MAXIMO & Give Rights To User

• Set Multilevel Security In MAXIMO

• User Management, Connectivity of client and server using SQL*Net

• Security: System, Data & Password management

• Create multiple database links with Oracle Application.

• Make Some Required Changed into API Given by PSDI As per Our requirement.

• Creating MAXIMO’s API for interfacing MAXIMO with Oracle Application.

• Import / Export, SQL*Loader, Backup / Recovery

• Configuration of space storage parameters for types of segments.

Billing System Interface with Oracle Application’s Account Receivable Module and TAS (Terminal Automation System).

• Create Database size of 3GB including multiple databases running simultaneously.

• User Management, Connectivity of client and server using SQL*Net

• Security: System, Data & Password management

• Create multiple database links with Oracle Application and TAS.

• Creating Billing System’s API for interfacing Billing System with Oracle Application’s AR Module and TAS.

• Import / Export, SQL*Loader, Backup / Recovery

• Configuration of space storage parameters for types of segments.

3. Project Name : MIS

Client Gujarat Motor Vehicle Department

Role System Analyst & Database Administrator

Organization Magnum Ltd.

Duration (11/1999) – (04/2000)

Team Size Project : 6 Module : 13

Environment

(with skill versions)

Software

Languages : PL/SQL

Database : Oracle 8

Tools : Developer 2000

O/s : Window NT

Project Description

Gujarat Motor Vehicle Department is a government organization. Having there offices in all over the Gujarat.

Contribution

• Study the project, designing and coding the system.

• Installation of Oracle v8.0.5, Developer 2000 v2.1.

• User Management, Connectivity of client and server using SQL*Net

• Tuning of rollback segments, latches, buffer cache, redo cache, shared pool, library cache etc.

• Security : System, Data & Password management

• Assisted team members in optimizing of SQL statements, Trouble shooting

• Import / Export, SQL*Loader, Backup / Recovery

• Configuration of space storage parameters for types of segments.

2. Project Name : Integrated MIS

Client Gujarat Electricity Board (GEB)

Role System Analyst and Database Administrator

Organization Magnum Limited

Duration (11/1998 – (11/1999)

Team Size Project : 20 Module : 13

Environment

(with skill versions) Software Languages : PL/SQL

Database : Oracle 8i

Tools : Developer 2000

O/s : Window NT

Project Description

Generation and Distribution of electricity is lifeline of any country. In Gujarat state, these responsibilities are handled by GEB. It has a very large database of its all systems and integration of this data is also a big job. This system will totally manage this work. In this system different modules are Meter lab, Transformer history and performance analysis, sub-judice cases, HT billing, Inventory, Accident and compensation, etc...

Contribution

Working as a System Analyst & Database Administrator, I performed the following tasks viz. Study , Designing ,Development, Testing, Installation, configuration of Oracle Server, creation of the database, user management, import & export, backup & performance tuning of an 5GB at 74 Different location and at H.O 20GB database.

• Installation of Oracle V8.0.5, Developer 2000 V2.1

• Planning & Database Administration

• User Management, Connectivity of client and server using SQL*Net V8

• Tuning of rollback segments and data segment.

• Assisted team members in optimizing of SQL statements, Trouble shooting

• Import / Export, SQL*Loader, Backup / Recovery

• Configuration of space storage parameters for types of segments.

1. Project Name : Financial Accounting System

Client 1. Meghmani Organics Ltd.

2. Sky Net Cable.

Role Programmer

Organization Magnum Ltd

Duration (06/1998) – (11/1998)

Team Size Project : 5 Module : 5

Environment

(with skill versions)

Software

Languages : PL/SQL

Database : Oracle 8.0

Tools : Developer 2000

O/s : Windows NT

Project Description

Magnum wanted to develop a Financial Accounting System especially for Chemical Company.

Contribution

Working as a Programmer, I performed the following tasks viz. Study and Design the sales Module, Development, Testing, and Installation of software.

Contact this candidate