Project Oracle
Resume:
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: ***********@*****.***
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