Vaishali Idate

Project Manager Managed Services (Production Support and Enhancements)

Green Card Holder

New Jersey

ac9hsl@r.postjobfree.com 732-***-****

Manager of projects with 13+ years of extensive experience in “Data warehousing and Production Support Models” targeting Pharmaceutical and Banking industry. 6 years of experience at onsite for leading the deliverables of projects including technologies like Informatica Power center and Infrastructure, Oracle, Data Stage, Netezza, Teradata. Proficient in delivering projects which includes Software development lifecycle starting from Requirement Analysis, Implementation and production support along with production support with the use of streamlined ITIL processes. Possess assertive attitude and proficient in professional communication. Experience managing onshore (8+ associates) and offshore teams (20+ associates) from project management & execution perspective.

Summary:

Project Management experience in project estimation, planning, implementation and execution. Proven ability to support multiple projects with medium to high complexity. Consistent track record of on-time and on-quality delivery.

Overall experience of 13+ years of which includes 6+ years of Project Leading, management and 4+ years of Development of Data warehouse projects in Banking, Life science sectors.

Experience in Production support of Oracle/Informatica application interfaces with effective use of streamlined ITIL processes like Problem/Incident/Change management, Operations/Knowledge management with Oracle PL/SQL, Informatica with 150 + application interfaces.

Write, assist and execute the new project proposals and statement of works and formally present the same to client

Identify new opportunities / assignments which will contribute to the growth of the account and ensure revenue targets are met

Meet revenue and profitability targets for the project

Identify risks at the Project level and formulate mitigation plans, business continuity plans

Working with finance team to ensure timely invoices and revenue collection for the project

Creation of appropriate project metrics to monitor the cost, effort, quality and customer satisfaction

Performance appraisals, Career planning, Promotions and Salary increase recommendations for all direct reporters

Enthusiastic team player, with excellent communication and interpersonal & team coordinating skills. Can take up individual responsibilities and ownership. A keen communicator with problem solving & analytical abilities.

Resource on boarding/off boarding/utilization/billing management at onsite and offshore

Technology:

Data warehouse/ETL – Oracle SQL, PL/SQL, Unix Shell Scripting, Informatica 9.6/10, DataStage 8.1 Px, Oracle Forms 9i

Tools : Microsoft Visual Source Safe, Toad, SQL Developer, Visio, Remedy, JIRA

Analytics/Reports – Oracle Reports 9i

Logistics Solutions Jun 18– Aug 18

Merck Pharmaceuticals

As Project Manager, I was responsible to manage delivery of enhancement project for PSO applications based on Informatica/PL SQL, Spotfire, UNIX, and Oracle for Merck Manufacturing Division.

Mange onsite team of 4 associates

Deliver deployment projects as per client contracts by working with different vendor teams

Status reporting, estimation, planning, and execution of project

Identify risks at the Project level and formulate mitigation plans

Problem management/conflict management within the team

Review project status reports on a weekly/monthly basis with the client.

Infosys Technologies Apr 18– Jun 18

Bayer Pharmaceuticals (Apr 18 – Jun 18)

As a Senior Project Manager, I was responsible to manage production Support / Change Requests for Bayer Sales & Marketing Commercial Datawarehouse ABBI (A Better Business Intelligence) for different Business Units such as Women’s Healthcare, Oncology, Neurology, Hematology, Cardio, Radiology including technologies such as Informatica, Teradata, Unix etc. ABBI has different parts such as Code, MDM Hub, Verix reporting (A Web Based Reporting Tool) for Home Office & Field Sales & Marketing Users.

This datawarehouse handles data such as Field Force, Alignment, Sales – Retail/ Non-Retail/ Ex-Factory, Call Plan (Target), Call, Samples, Events, Contracts.

Deliver deployment projects as per client contracts with considerable FTEs

Status reporting, estimation, planning, and execution of project

Handling coordination between client (business, IT) and Infosys BAs and ensure deliverables on time.

Identify the continual service improvements as a part of value adds and cost savings to customer and enhance the system

Expand the business within the profitability and win-win situation to both client and Infosys

Present monthly metrics to the account management and operations team regarding the health of the projects

Write or assist in the writing of new project proposals and statement of works

Leading and managing onsite team (8 +) including technical leads, business analysts with personal effectiveness

Periodic reviews of all the project level metrics with client

Identify risks at the Project level and formulate mitigation plans

Performance appraisals, Career panning, Promotions and Salary increase recommendations for all directs reports

Onsite offshore daily handshake

Resource on boarding/off boarding management at offshore/onshore

Problem management/conflict management within the team

Recruit onsite Infosys resources for Bayer

Cognizant Technology Solutions Junl’06– Apr17

Merck & Co., Inc., NJ, (Mar ’14 – Apr 17)

As Project Manager, I was responsible for to manage 150+ application interfaces based on Informatica, UNIX, and Oracle PL/SQL for APAC, US and EMEA regions across the globe with below Roles & Responsibilities.

Mange onsite team of 8-10 associates

Deliver deployment projects as per client contracts based on SLA

Status reporting, estimation, planning, and execution of project

Periodic reviews of all the project level metrics with client

Identify risks at the Project level and formulate mitigation plans

Identify new opportunities / assignments which will contribute to the growth of the account and ensure revenue targets are met

Performance appraisals, Career planning, Promotions and Salary increase recommendations for all directs reporters

Setting up Business Continuity Plan for project

Onsite offshore daily handshake

Resource on boarding/off boarding/utilization/billing management at onsite and offshore

Problem management/conflict management within the team

Working with finance team to ensure timely invoices and revenue collection for the project

Present monthly metrics to the Cognizant account management regarding the health of the projects

Review project status reports and project metrics on a weekly/monthly basis with the client.

Meet revenue and profitability targets for the project

Write or assist in the writing of new project proposals and statement of works and formally present the same to client

Creation of appropriate project metrics to monitor the cost, effort, quality and customer satisfaction

Merck & Co., Inc., Pune, (Jun ’12 – Mar 14)

As Project Manager & Offshore Lead, I was responsible for manage 150+ odd application interfaces based on Informatica/PL SQL, Unix, Oracle for APAC, US and EMEA regions across the globe with below Roles & Responsibilities.

Deliver deployment projects as per client contracts

Mange offshore team (20+ ) associates

Status reporting, estimation, planning, and execution of project

Periodic reviews of all the project/account level metrics with onshore and offshore management team

Identify risks at the Project/Account level and formulate mitigation plans

Performance appraisals, Career panning, Promotions and Salary increase recommendations for all directs reports

Onsite offshore daily handshake

Resource on boarding/off boarding/utilization/billing management at offshore

Problem management/conflict management within the team

Working with finance team to ensure timely invoices and revenue collection for the project

Present monthly metrics to the Cognizant account management regarding the health of the projects

Write or assist in the writing of new project proposals and statement of works

Eli Lilly & Company Indiana, (Nov ’10 – May 12)

As an onsite technical project lead, I was involved in supporting Sales & Marketing datawarehouse called POLARIS. This involves collection of Activity, Plantrak and product sales data from IMS and other sources with below roles responsibilities.

Estimation of work items

Preparation of KT document, Standard Operating Guide, Communication Plan, On boarding document, Checklists for monthly loads

Development and Unit Testing of the various business requirements using Informatica 8.6.1, Netezza 6, Unix

System testing and review of the system

Co-ordination with offshore team members and knowledge transition

Deployment of the system in production

Postproduction support of the application

Responsible for end to end development till production deployment for DDD data mart build for US Business Reporting (This was mini development project for 3 months) as an onsite Lead.

Production Support for daily, weekly and monthly loads (Monitoring and fixing the jobs)

Review and Submission of metrics (weekly and monthly), monthly capacity planning, status reports (weekly and monthly) to client

Knowledge Transition to other vendor for all support modules: Preparation of KT plan, KT docs

Novartis Pharmaceutical Limited, Pune, (Sep ’09 – Nov 10)

As a developer I was responsible to develop downstream reporting DataMart for Commercial Sales & Marketing Data Warehouse for Novartis

Design and review of the system

Development and Unit Testing of the various business requirements using Datastage 7.5.1, Oracle 10 g

System testing and review of the system

Co-ordination with offshore team members and knowledge transition

Deployment of the system in production

Managing the compliance of the project using C 2.0 and documentation of the project.

Defect tracking and Risk assessment in C2.0

Schering plough - Safety reporting, NJ, Pune (Feb ’07 – Apr 09)

Designated Team Leader of the offshore team. Moved to Onsite team to work as an Onsite Technical Lead to ensure compliance with SP standards and quality assurance procedures. Responsible for

Understanding System’s requirement from Client & creating specification document

Designing of reports and developing packages using PL/SQL and Reports 9i to review the AERS reports as per the requirements.

Knowledge Transfer to Offshore team.

Effort estimation of work units.

Unit Testing, SIT and Verification of the Report Outputs

Quality Metrics and Status Reports to client

Authoring Technical Design documents, Test Scripts and capture test results

JP Morgan Chase, Pune, (Jun ‘06 – Dec ‘06)

I was involved in migration of existing Oracle 6i Forms and Reports which are running off the Transfer Agency production Oracle database to Cognos Report Net 1.1.As an offshore developer I was responsible for

Understanding System’s requirement (existing Oracle Forms and Reports) and analysis of the same

Designing reports and developing PL/SQL procedures, packages

Preparing Test Cases

Unit and Integration Testing

FWL Technologies, Pune, (Jun ‘04 – Feb ’06)

As part of Fulfillment Shipping project for clients China Shipping, CMA CGM, Pacific International Line, Samskip, Yang Ming to manage fleet of containers cross USA, as a Team Member I was responsible to

Developing Forms, Reports, Functions, Procedures and Packages using Oracle Forms & Reports 9i

Bug Fixing, Enhancement.

Preparation of Unit Test Cases

Unit and Integration Testing.

Certifications

oInformatica: PowerCenter Data Integration 8.x:Developer Specialist

oOracle Certified Associate

oITIL V3

Education

Bachelor of Engineering (Computer Science & Engg.), Walchand College of Engg, Sangli, Maharashtra India

Contact this candidate