Vaishali Idate
Project Manager Managed Services (Production Support and Enhancements)
Green Card Holder
New Jersey
********@*****.*** 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