Pragati Patil

Introduction

Consultant with 10+ years of IT experience including International Onsite project experience in United Kingdom, Hong Kong and United States.

My specialization is in the area of Supply Chain Management and Order Management in ERP (Enterprise Resource Planning) implementation and support across a variety of business structures internationally.

I have been working as Functional Consultant for around 8 years. My prime functional skill sets are in the field of Implementation of OracleApps (ERP) (3 years experience) and MOVEX (ERP) (5 years experience). MOVEX is Intentia's proprietary product in the ERP Business (Movex as an ERP solution has been successfully implemented at more than 4500 sites worldwide). 

Currently I'm working with iGATE Global Solutions Ltd, Bangalore and I'm involved in various projects with Cummins Inc. and General Electric, implementing different modules in OracleApps. Prior to OracleApps I was involved in rollout project in Movex in different Cummins entities worldwide as a Distribution and Logistics Consultant.

Employment History

•  iGATE Global Solutions Ltd, Bangalore - Currently working as a Sr. Consultant Manager grade, since Oct 2002. iGATE is a CMM Level 5 leading global IT Services company based in Bangalore with major US/UK based clients.

•  Camlin Ltd, Mumbai - Worked as System Analyst since July'96 - Oct' 2002

A multidivisional company having presence in Consumer products - art material, stationary & office products, Pharmaceuticals & fine chemicals.

•  Sekhsaria Chemicals Ltd, Mumbai. - Worked as a Consultant.
  Leading manufacturers of Bulk drugs and Fine chemicals.

Personal Details:
Full Name   : Ms. Pragati Patil

Address  : Flat no. F16, Tulip block, Paramount Raghavendra Arisht,

 Kundanahalli Gate, Air Port to Whitefield road, Next to Bhageecha

 Hotel, Marathahalli, Bangalore - 560 037. India.

Mobile number   : +91 ********** (Bangalore)

Email Id   : pragati.patil@gmail.com

Date of Birth    : 30th September, 1974

Marital Status   : Single

Passport number  : A******* (valid till 7th February, 2009)

International Assignment : United Kingdom, Hong Kong and United States

Professional Details with regards to Current Organization:
Name of the Organization : iGATE Global Solutions Ltd.

Designation   : Sr. Consultant

Grade    : Manager

Department   : Enterprise Solutions

Division    : Oracle Application

Professional Qualifications and Industry Certifications:

•  Bachelor Degree in Science (Mathematics), University of Bombay, India. (Graduated in June 1996)
•  Professional Diploma in Software Technology & Systems Management, NMIMS, India. (2 years) (Completed in Dec. 1995 with Honors)
•  Certified DOEACC 'O' Level Examination in July 1995
•  CPIM from APICS (Cleared BSCM)

Project Summary:

1. Major Project with iGATE Global Solution Ltd, Banglore. Duration: Oct 2002 - till date

•  Implementation of Demand Planning Module in Oracle Application

Oracle Demand Planning is a Web-based application that enables organizations to produce unconstrained forecasts for future demand and generate tactical, operational, and strategic business plans. Demand Planning captures and processes information from multiple sources and consolidates demand so that it can be summarized by item, product line, region, time, and organization

Project mainly involves the standalone implementation of Oracle Demand Planner v 11.5.10 which includes four Business units spread in three different regions (America, Asia Pac and Europe)

The main objectives of the implementation are :

•  Facilitate accurate and rapid planning cycles
•  Provide Global visibility of demand
•  Develop and provide accurate component level demand forecast to external vendors and

Internal customers

•  Improve & Provide measurement for global forecast accuracy
•  Manage Forecast by exception

The demand plan generation basically involves collection of data in a particular template and from different application instances and then putting the data in the staging/fact tables in Demand planning Server and then the demand planning engine executes and the Plan is generated.

Role / Responsibilities in the Project

•  Leading offshore team and responsible for defect free and timely deliveries from offshore
•  Involve in Solution Design and Development
•  Business requirement definitions & functional mapping
•  Translating client requirements into design documents using AIM methodology
•  Solving recurring issues during implementation

Major Modules Handled Demand Planning

Duration  Jun'05 - till date (Project is likely to get over by April' 06)

Platform  Oracle database, D2K front-end

Employer  iGATE Global Solutions

Client  Cummins Power-Gen

Team size   6

Role   Offshore Team Lead plus Functional Consultant

•  Implementation of Advanced Supply Chain Planning Module in Oracle Application

Standalone implementation of Oracle Advanced Supply Chain Planning v 11.5.10 which includes four Business units spread in three different regions (America, Asia Pac and Europe)

The main objectives of the implementation are :

•  Extend the existing demand layer solution to enable supply chain planning process
•  Lay the foundation for accurate order promising across the various manufacturing locations considering various supply chain constraints
•  Enable management by exception
•  Become an enabler for more accurate and rapid planning cycles
•  Provide accurate component level demand to internal and external suppliers

The demand plan generation basically involves collection of data in a particular template and from different application instances and then putting the data in the staging/fact tables in Demand planning Server and then the demand planning engine executes and the Plan is generated.

Role / Responsibilities in the Project

•  Leading offshore team and responsible for defect free and timely deliveries from offshore
•  Involve in Solution Design and Development
•  Business requirement definitions & functional mapping
•  Translating client requirements into design documents using AIM methodology
•  Solving recurring issues during implementation

Major Modules Handled Advanced Supply Chain Planning

Duration  Dec'05 - till date

Platform  Oracle database, D2K front-end

Employer  iGATE Global Solutions

Client  Cummins Power-Gen

Team size   6

Role   Offshore Team Lead plus Functional Consultant

•  Implementation of Movex ERP across Cummins Inc.  (Onsite - UK/HK)

Movex implentation in Cummins Inc. is an umbrella project which involves implementation and Production support of Movex ERP in Europe (UK, Germany, Ireland, Italy and Holland) and South East Asia (Singapore, Philipiness, Japan,. Korea, Hong Kong, China  and 9 other Regional offices in China).

Movex rollouts in Cummins are through Cummins IDPO (Cummins Internation Distributor Program Office) which  operates in three locations Wellingborough, UK, ODC at iGATE Global Solution, Banglore, India and ODC at KPIT, Pune India.

Cummins IDPO is solely responsible for implementation of Movex ERP for its Engine Distributors and Power Generation Companies worldwide.

Role / Responsibilities in the Projects with iGATE Global Solutions

•  Current role in the project is as a Business Consultant (Distribution and Logistics), leading the onsite and offshore team to work together and achieve the deliverables, defect free and on schedule.
•  Studying the Business requirement and processes of the client and preparation of scope documents.
•  Suggesting beneficial changes in the business processes based on the above study and Re-designing the business processes.
•  Mapping the Business processes with the ERP package and performing GAP analysis.
•  Preparing Functional specification as per need for the modifications.
•  Preparing Test plan and Test cases for the modification as per Functional specification.
•  Submitting the modification requirements to the Technical support team and get the work done from the team and provide any functional support to the technical team as needed.
•  Implementation of Enterprise solution, which involves Configuration, Training of users, Performing pilot-runs and finally productive start-up.
•  Providing Business Consulting support to ongoing projects by reviewing the implementation at different phases of implementation.

Other Responsibilities

•  Providing helpdesk support to various locations and performing site visits as and when required.
•  Ensure Timely response and resolution of problem tickets within the SLA.
•  Preparing and presenting different types of monthly reports and presentations on performance, appreciation from client, achievements of the team, defect tracking, VOC (Voice of customer) and many others to the organization and client.
•  Providing functional support to the R & D team as and when required, for deciding scope of market specific modification. Local laws modification and, testing.
•  Worked on Data warehousing solution - Impromptu and Power play

Major Modules Handled Distribution and Logistics, Procurement, Manufacturing

Duration  Two Years Five Months

Platform  AS400, DB2 database

Employer  iGATE Global Solutions

Client  Cummins

Team size   12

Role   Team Leader Offshore (Functional consultant team), plus Functional     Consultant

Award Reworded with MR2 (Management Review Recognition) award in March 2003 for best performance.

2. Major Project with Camlin Ltd, Mumbai (Reverse Chronological Order)

Duration: July'96 - Oct' 2002

•  Implementation of Movex ERP in Camlin Ltd.  (Mumbai & Tarapur)

Activities handled / Role in ERP

•  To understand Movex in totality, and define and configure Camlin's Business Processes in Movex with Intentia Business consultant and to carry out modifications in the system if required.
•  To validate the process flows, helping the process owners in checking the flows and the outputs from MOVEX, plus training the end users.
•  Designing customized reports that were not available in the package. Guiding the technical team to develop the same.
•  Attending queries of process owners while building data for live company.
•  Documenting Business process for all modules.
•  Designing and scooping output format e.g. Invoice format, Purchase Order, Manufacturing Order.
•  Conducting & Evaluation of Pilot Run.
•  Giving Presentations, Holding Sessions and Group discussions whenever required, to the process owners and end users.
•  Regularly coordinating with Consultants and Process owners for smooth flow and completion of various activities in time.
•  Designing Depot software and ensuring it to be compatible with Movex, testing the functionally, checking if it meets the requirement.
•  Gap Analysis between Depot software and Movex
•  Designing Solution to Gap analysis
•  Finalizing Scope of Branch Interface with Process owners and Intentia Consultants, documenting same for development. Functionality covered in Interface - Customer order, Invoicing, Depot Transfer, Purchase Receipt and Accounts Receivable.
•  Finalizing Scope of Outstanding Interface with Process owners and Intentia Consultants, documenting same for development. Functionality covered in Interface - Stock on-hand, Supplier Outstanding and Customer outstanding.
•  Testing Outstanding and Depot Interface.

Milestones Achieved in the Project

Finance Module has 'Gone Live ' and other core areas have been configured and Full Scale test where under Progress.

Major Modules Handled Distribution and Logistics, Manufacturing, Procurement

Role   Project Leader 

Duration  Two Years

Platform  AS400, DB2 database

Employer Camlin Ltd.

Client Camlin Ltd.

Team size   7

•  Document Management System (Head Office and Mother Depots)

Activities handled in the Project.

•  Phase I - System Study of Head Office.
•  Phase II - Design and flow approved from Top management.
•  Phase III - Functional support to the Developers as and when required.

The objective to implement Document Management System is to make paper less office and fast communication. My role is to give functional support to the system. To study the requirements of different departments, document the flow and get verified and approved from department heads. Design the system and present it to top management. Integrating the System with ERP. Once development is completed, to implement the system in all the depots all over India.

Role   Project Leader

Duration  Six Months

Platform  MS SQL

Front End  VB

Employer Camlin Ltd.

Client Camlin Ltd.

Team Size  5

 

   Conversion Of Existing Unify System to Oracle 7.0

Designing of Inventory control System consisting of Purchase and Invoicing Modules with online updation of stocks. Financial Accounting System Involving all types of voucher entries and on line ledger Updations for day to day transactions.

 I was involved in requirement study, Analysis and designing of databases, Creation of users, tablespaces, allocation of database rights, fine-tuning. Importing of Data From existing Unify system to Oracle. Plus coding of Supplier Outstanding module of Financial Accounting System. Plus coding for online Updation of stocks, Generating Stock analysis Reports, Comparative Reports such as RMC/VOP report in Stocks maintenance  module.

Role   Designing and coding

Duration  One Year Six Months

Platform  Oracle 7.0 with Forms 3.0,Reports 1.1,Pro 'C' 1.5 on SCO UNIX.

Employer Camlin Ltd.

Client Camlin Ltd.

Team Size Project Leader + 4

•  Financial Accounting System

System involved all financial transactions, AR (Accounts receivable), AP (Accounts Payable), Fixed Asset, Cash Accounting with all finance reports - debtors/creditors & MIS reports. Plus Budget Module.

I was involved in requirement study, Analysis, designing of databases, Creation of users, Coding of Sales module, Purchase module, Credit Notes and Debit Notes module, Supplier Outstanding module,  Generating registers & Ledgers for the same. Ageing of AR/AP. Generating MIS reports such as Profit & Loss Account and Balance Sheet including Comparative reports of current financial year and previous financial year. Generating Budget reports too, with comparison of Actual verses Budgeted figures Annually / Quarterly / Monthly.

Role   Requirement study, analysis, designing and coding

Duration  One Year Six Months

Platform  Unify 10.2 H.P UX 9000 with 'C' as the program interface.

Employer Camlin Ltd.

Client Camlin Ltd.

Team Size  Project Leader + 3

•  Raw Material System

System involved manufacturing of bulk colors.  It gives a picture of supply & stock analysis of raw & packing materials.  Includes Lab Inspection for raw material, packing material & bulk color with respective reports. This also includes costing of products in different stages, & finally for finish products.

I was involved in Requirement study, Analysis, designing & Coding of Stock & Consumption analysis, Lab Inspection Module for RM, PM and Bulk color. RG23 Part I Module & Costing of Semi-finish products (Bulk color) & Finish Products.

Role   Requirement study, analysis, designing and coding

Duration  One year, Two Months

Platform  Unify 10.2 H.P UX 9000 with 'C' as the program interface.

Employer Camlin Ltd.

Client Camlin Ltd.

Team Size  Project Leader + 2

•  Y2K Compatible Systems

Making all the Systems of the Organization Y2K Compatible.

I was involved in Loading Unify 10.2 on the Server. Importing data from Unify 5.0 to Unify 10.2.  Analyzing and designing changes to be carried out in existing SQL / RPT & C Programs to Y2K compatible system.

Role   Project Leader, which involved requirement study, analysis and designing.

Duration  Eight Months

Platform  Unify 5.0 H.P UX 9000 with 'C' as the program interface.

Employer Camlin Ltd.

Client Camlin Ltd.

Team Size  Project Manager + 6

3. Major Project with Sekhsaria Chemicals Ltd, Mumbai (Reverse Chronological Order)

Activities handled / Role as a Consultant

•  Understanding & Designing client's business requirements and processes.
•  Identification of business improvements especially in the area of Procurement, Sales & Distribution
•  Construction of sample database
•  Design, Coding and conduct workshops.
•  Conducting Pilot Run & Evaluation of tests performed on the system.
•  Training the end users to handle the system.
•  Implementing the systems.

System Developed and Implemented Successfully

1.  Order Processing and Billing System with Inventory management system
2.  Payroll System.
3.  Purchase System, which take care of Local and Import Purchases.

Platform  FoxPro 2.6 for Dos / Windows.

Technical Skills:

Operating Systems  : Novell Netware, MS-Windows 95/98/NT 4.0,

HP UNIX 9.X, MS-Dos 6.22.

Programming Language : Java, C, COBOL (Ver. 2.20)

Database Languages   : SQL, PL/SQL, and DBA

Databases   : Oracle 7.1, Unify 10.2, FoxPro 2.6 for dos &

windows

GUI Tools   : Developer 2000 (Ver 1.5), VB

ERP    : Movex (Worked on TG/NG)

Corporate Training:

•  Oracle 7.1 with Developer 2000, Forms 4.5, Reports 2.5 from Concourse Information Technology International Limited during my tenure with Camlin Ltd.  
•  Course in Java & J2EE from Concourse Information Technology International Limited  

Java Programming, Multithreading, Input / Output streams, Networking, Java Database

Connectivity (JDBC), Socket Programming, Remote Method Invocation (RMI), Swings, Servlets,

Java Beans, Corba, Java Script.

•  Cognos Training in iGATE on Impromptu and Power Play
•  Oracle Demand Planning Training in Oracle premises

Page of