Sr. Project/ Program Manager
Resume:
YASHADA RAORANE
Phone: +1-908-***-**** E - mail: *******.**@*****.***
PROFESSIONAL PROFILE
IT Project Lead / Technical Project Manager with 21+ years of a consistent track record of leading & delivering enterprise level applications. Excellent analytical, problem-solving and documentation skills. Experienced in SalesForce.com project implementations. Result oriented, with a strong aptitude for learning and can maximize resources while possessing a sense of urgency. Team player with excellent interpersonal communication skills. An enthusiastic and out-going individual with good ability to interact with colleagues. Committed to professionalism, highly organized and excellent communication skills.
SUMMARY OF SKILLS
• Experienced on the in house portal Data as a Service (DaaS) for delivering Pharma data (Xponent, Xponent Plantrak, DDD, LAAD, APLD, DRM45, OneKey, Managed Care) to client environment via Snowflake, S3, Azure, Databricks, etc.
• Experienced on Salesforce.com platform solutions Veeva, “CentrisEvents” and involved in requirements gathering for updating the Configuration, Customization, Implementation, Data Migration and Support of Salesforce.com Applications.
• Contribute to the PMO Initiatives for the team progress as a Team and Project Lead.
• Complete understanding and Solid experience in SDLC Methodologies like Waterfall & Agile Models.
• Proficient in working on multiple projects simultaneously.
• Managed Off-shore developmental team and coordinated with the US team and the management.
• Proficient in project management tasks and ensure proper Project Management practices are followed throughout the project lifecycle
• Experienced in working with cross-functional groups toward a common goal. Solid team empowerment, motivation, and leadership skills.
• Experienced working in Manufacturing Industries, Government Agencies, Export-Import Houses, IT Consulting Companies. Designed & supported ERP, MRP, Manufacturing, and Export-Import Systems. Worked with small to large teams and multiple projects at same time.
• Excellent planning, scoping, scheduling, and delivery skills.
• Thorough knowledge of the company products and designs helps provide the client with an overview of the product enhancement options to upgrade their current product.
• Worked with people at various levels in the organization handling various Business Processes and core solutions. Expertise in the management of User Request Change, and handling of User Conflicts.
• Experienced in participating on daily SCRUM meetings and guiding or answering questions to QAs and Developers regarding the defects, Technical Specification Documents, Mapping Documents.
• Microsoft products implementation and integration (MS Project, Visual Source Safe).
• Knowledge in the ETL (Extract, Transform, and Load) of data into a data warehouse/ data mart and Business Intelligence (BI) tools like Business Objective Modules
• Knowledge in Business Analysis, SWOT Analysis, Impact Analysis, Gap Analysis, Cost-Benefit Analysis, Risk Analysis, Disaster Recovery Planning, Return On Investment (ROI) Analysis, Testing and Project Planning
• Expert in SQL, PLSQL, T-SQL and Oracle Database Performance Tuning. Worked on various projects with Oracle, MS SQL Server, MS Access as back end. Experienced using Oracle 10g/11g & SQL Server 2005/2008. Proficient in Data Profiling and Visualization, ER Diagrams, Data Integration tools, Data Modeling tools like ERWIN. Working knowledge of Toad, PLSQL Developer 7.1.5 and SQL Navigator.
• Experienced in developing n-tier applications, full life cycle development using Microsoft .NET technologies (Webforms, WinForms, ASP.NET, ADO.NET, Entity Framework, XML, Web Services).
• Proven experience in Analysis, Design, Development, Implementation, Maintenance, Migration and Support of application systems in Web Application, Windows Application and Enterprise Application environments at application developer, Programmer Analyst and Team/Project Lead levels.
• Proficient in Relational Database Management Systems with excellent knowledge of PL/SQL Scripts, Stored Procedures, Triggers, Views, Functions, DB Jobs Scheduling, Data Loading.
• Functional expertise in developing reports using SQL Server Reporting Services (SSRS), Crystal Reports, MS Access Reports, and Oracle Reports.
EDUCATION
• Project Management Professional (PMP) - 2021
• Bachelor of Science (Life Sciences) 1998 – Mumbai University, Ramnarain Ruia College, Mumbai, India
• 3 years Advanced Diploma in Software Engineering - 2001, APTECH - Mumbai, India. Awards and Recognition:
• Manager recognition for Collaborate to deliver services in 2018 (Syneos)
• Manager recognition for People development award in 2018 (Syneos)
• Team Spirit award for being Passionate to change lives in 2018 (Syneos)
• Received Outstanding Performance award in 2016 (AHM)
• Received AHM Values Award in 2016 (AHM)
PROFESSIONAL EXPERIENCE
IQVIA, Bridgewater, NJ. Jan 2022 - Present
Role: Sr. Project Manager
Environment: SalesForce.com, MS Project, Smartsheet, MS Office, JIRA, DaaS, MDM, CDW, Concur, Learning Management System, Confluence, Product owner (DaaS systems), Master Data Management (MDM), CDW (Customer Data Warehouse), Product: DaaS (Data as a Service) – Implementation of Data elements Clients supported:
- Sanofi
- Novartis
- Amgen
- Otsuka
- UCB
- Doximity
- LivaNova
- Kabi
- Neurocrine
- Dexcom
- Sobi
- Valinor
Responsibilities:
• Manage the Project Plan, RAID log, JIRA, Meeting notes, JIRA, Product enhancements
• Point of contact for all External and Internal Stakeholders
• Collaborate with client’s 3rd party vendors.
• Worked with the Product development team to manage the Enhancements requests. Used Confluence to document the enhancements and related story
• Performed and documented requirement analysis, impact analysis, Data analysis and Gap Analysis to check the compatibility of the existing system infrastructure
• Communicated with stakeholders to understand business requirements.
• Interacted and communicated with Client on regular basis to maintain a strong relationship.
• Lead and managed the Client and Internal Core team Weekly Status Meetings and provided the Status Reports for both the teams.
• Managed the offshore resources.
• Lead the Product Reviews and demos for the client.
• Lead and managed daily Status Meetings with the offshore and onshore Technical Teams.
• Performed the project management tasks and ensure proper Project Management practices are used throughout the project lifecycle
• Worked extensively with the Internal Core teams to successfully complete the System Integration Testing.
• Managed budget and resource allocation for the internal and offshore teams.
• Managed change control process. Worked with the Sales and Account teams to provide SOWs and Change requests to the client.
• Logged and managed the defects in JIRA and coordinated with the respective teams for resolving issues.
• Manage and Lead UAT, Production Deployment and Hyper Care. Product: DaaS (Data as a Service) – Implementation of Data elements (Product Owner) Responsibilities:
• Manage the Project Plan, Resource allocation, Roadmaps, Backlog items, Release notes, RAID log, JIRA, Confluence
• Collaborating with prospective users and clients to understand and anticipate their needs and translate them into product requirements
• Defining the vision for the product
• Creating a product road map based on this vision
• Managing the product backlog and prioritizing them based on changing requirements
• Overseeing all stages of product creation including design and development
• Developing user stories
• Monitoring and evaluating product progress at each stage of the process
• Liaising with the product team and end-users to deliver updates
• Participating in Scrum meetings and product sprints Syneos Health, Somerset, NJ. Jan 2018- Feb 2022
Role: Project Manager
Environment: SalesForce.com, MS Project, Smartsheet, MS Office, Tele Solutions, JIRA, VEEVA CRM, MyInsights, Concur, Learning Management System,
Clients supported:
- Eli Lilly and Company
- CeQur Corporation
- Zoll LifeVest
- Bayer
- Aerie Pharmaceuticals
Responsibilities:
• Manage the Project Plan
• Point of contact for all External and Internal Stakeholders
• Collaborate with client’s 3rd party vendors.
• Worked with the Product development team to manage the Enhancements requests. Used Confluence to document the enhancements and related story
• Performed and documented requirement analysis, impact analysis, Data analysis and Gap Analysis to check the compatibility of the existing system infrastructure
• Communicated with stakeholders to understand business requirements.
• Interacted and communicated with Client on regular basis to maintain a strong relationship.
• Lead and managed the Client and Internal Core team Weekly Status Meetings and provided the Status Reports for both the teams.
• Managed the offshore resources.
• Lead the Product Reviews and demos for the client.
• Lead and managed daily Status Meetings with the offshore and onshore Technical Teams.
• Performed the project management tasks and ensure proper Project Management practices are used throughout the project lifecycle
• Worked extensively with the Internal Core teams to successfully complete the System Integration Testing.
• Managed budget and resource allocation for the internal and offshore teams.
• Managed change control process. Worked with the Sales and Account teams to provide SOWs and Change requests to the client.
• Logged and managed the defects in JIRA and coordinated with the respective teams for resolving issues.
• Manage and Lead UAT, Production Deployment and Hyper Care. Advanced Health Media, New Providence, NJ. Oct 2013 - Jan 2018 Role: Senior Business Systems Analyst/ Project Lead Role/ Technical Project Manager Environment: SalesForce.com, Centris Event Planning, VB.Net, C#.Net, Webforms, WinForms, ASP.NET, Web Services, ASP. Net, Entity Framework, MS SQL Server reporting Services, MS SQL Server, MS Project, MS Visual Source Safe. Product: CentrisEvents, CentrisDirect, CentrisMobile. – AHM launched a new Product developed on the SalesForce platform and is in the process of Globalization.
Clients supported:
- Sanofi
- Avanir Pharmaceuticals Enhancements Implementation
- Sanofi Global Solutions – China
- Teva Pharmaceuticals
- Alkermes, Inc.
- Avanir Pharmaceuticals.
- Acorda Therapeutics Inc.
Responsibilities:
• Leading the project as a Technical Project Manager.
• Manage the Project Plan
• Point of contact for all External and Internal Stakeholders
• Collaborate with client’s 3rd party vendors.
• Worked with the Product development team to manage the Enhancements requests. Used Confluence to document the enhancements and related story
• Performed and documented requirement analysis, impact analysis, Data analysis and Gap Analysis to check the compatibility of the existing system infrastructure
• Communicated with stakeholders to understand business requirements and translate them into business flows.
• Interacted and communicated with Client on regular basis to maintain a strong relationship.
• Lead and managed the Client and Internal Core team Weekly Status Meetings and provided the Status Reports for both the teams.
• Lead the Product Reviews and demos for the client.
• Lead and managed daily Status Meetings with the offshore and onshore Technical Teams.
• Performed the project management tasks and ensure proper Project Management practices are used throughout the project lifecycle
• Worked extensively with the Internal Core teams to successfully complete the System Integration Testing.
• Managed budget and resource allocation for the internal and offshore teams.
• Managed change control process. Worked with the Sales and Account teams to provide SOWs and Change requests to the client.
• Logged and managed the defects in JIRA and coordinated with the respective teams for resolving issues.
• Manage and Lead UAT, Production Deployment and Hyper Care.
• Completed Phase 1 and 2.
Centris Support: Supported the Internal teams on other clients namely Sanofi, Alcon, and GSK during different phases of the project. Have also supported Centris data integration with VEEVA interface for some of the clients. AHM In-house Applications: Worked as a Sr. Business Analyst on the AHM In-house Applications like, Portal Framework Exchange (PFX), Third Party Exchange (TPX), Speaker Resource Exchange (SRX), Event Framework Exchange (EFX). – These applications were customized as per the Client needs.
Clients:
• Sanofi Aventis
• Novo Nordisk
• Merck
• Actelion
• Schering Plough
• Pfizer
• Novartis
Environment: SQL Server Management Studio, PFX, SRX, TPX, EFX, MS Project, MS Visio, MS SharePoint. Responsibilities:
• Performed and documented requirement analysis, impact analysis, and Gap Analysis to check the compatibility of the existing system infrastructure
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement Documentations (BRD) and Functional Specification Documentations (FRD)
• Conducted interviews, meetings, and JAD sessions during the process of Requirement Gathering
• Planned and documented procedures for data processing and prepared data flow diagrams
• Designed and developed project templates based on SDLC AGILE Methodology, which also included requirements specifications, analysis, and testing
• Troubleshoot Production Issues, coordinated with the Helpdesk when required. Gave on-time solutions to critical issues and provided full production support.
• Analyzed the User Requests, did the Impact Analysis and proposed a solution that would best fit the needs of the company.
• Planned and implemented the solution in Production. I was responsible for Execution/Monitoring/Meeting deadlines of the project.
• Designed, handled, and evaluated application testing and coordinated with the Testing Team.
• Managed the Off-shore development team and coordinated with the Management and the US team. Department of Homeless Services, NYC, NY. Nov 2007- Sep 2013 Role: Project Lead/ Project Manager
Environment: Oracle 10g/11g, VB.Net, C#.Net, Webforms, WinForms, ASP.NET, Web Services, ASP. Net, Entity Framework, MS SQL Server reporting Services, MS SQL Server, MS Project, MS Visual Source Safe. Projects:
• Apartment Intake and Inspections
This project was built around the different standards of safety/hygiene as prescribed by the NYC council from time to time. NYC regularly updates its regulations and DHS must comply with Apartment Inspection Standards and this software caters to the Intake and Inspection needs of the apartments.
• Rehousing
Rehousing module was used for managing the movement of families from shelters to permanent housing. Scheduling for Inspection clearance of the units used for permanent housing was an essential component of Rehousing application. Assisting families by providing training to achieve self-employment was also managed by this module.
• Homebase
Application aimed at automating the registration and verification of homeless people. Referral and financial assistance modules allow for cross referencing between departments and to assist the individuals requiring financial help. This module helps the staff to speed up the process of moving the homeless to shelters.
• Rehousing Computer Applications (RCA).
RCA was used for managing the movement of families from shelters to permanent housing. It comprises of different modules representing the different departments (namely Apartment Intake, Clearance, Inspections, Lease, ICU and Quality Assurance) in DHS. It integrates all the departments and centralizes the data which maintains accuracy and integrity. In-house development, enhancements, production support for the application Environment: Oracle 11g/10g, MS SQL Server 2005, MS Access 2002, Visual Basic, Access Reports, MS Project, MS Visual Source Safe.
Responsibilities:
• Performed and documented requirement analysis, impact analysis, and Gap Analysis to check the compatibility of the existing system infrastructure
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement Documentations (BRD) and Functional Specification Documentations (FRD)
• Conducted interviews, meetings, and JAD sessions during the process of Requirement Gathering
• I worked on Database design, Data Mining, Data Scrubbing especially when data has been imported from other sources. Designed using Data Modeling tool ERWIN
• Developed several utilities for quick creation of tables, insertion of bulk data and application documentation.
• Database optimization and Performance tuning to improve application response time.
• Captured Audit trails of User activity using Database Triggers and collaboration with the Presentation Team
• I was responsible for Application Design and coordinating with the development team and hands on development of certain critical modules.
• I worked on developing and enhancing the Gateway application which works as the API/framework for all basic functionalities of the applications developed for the organization.
• Developed custom user controls with properties for all basic validations and data formatting as a part of the API
• Planned and documented procedures for data processing and prepared data flow diagrams
• Designed and developed project templates based on SDLC AGILE Methodology, which also included requirements specifications, analysis, and testing
• Worked extensively on Management Reports using SQL Server Reporting Services and MS Access Reports.
• Troubleshoot Production Issues, coordinated with the Helpdesk when required. Gave on-time solutions to critical issues and provided full production support.
• Analyzed the User Requests, did the Impact Analysis and proposed a solution that would best fit the needs of the company.
• Planned and implemented the solution in Production. I was responsible for Execution/Monitoring/Meeting deadlines of the project.
• Designed, handled, and evaluated application testing and coordinated with the Testing Team.
• Managed the Off-shore development team and coordinated with the Management and the US team. Mitra Systems
Jul 2004 – Nov 2007
Role: Programmer Analyst - Business Analyst
Environment: Oracle 10g/11g, VB.Net, C#.Net, Webforms, WinForms, ASP.NET, Web Services, ASP. Net, Entity Framework, MS SQL Server reporting Services, MS SQL Server, MS Project, MS Visual Source Safe, Documentum 2.0. Project: Customer Service Portal
This project is aimed at reengineering the Customer Service Request module of the Public Service suite of products already developed in legacy systems. This project was built as an n-tier application, to perform the required service request processing and tracking. Resource Management, Process Management, Security, System Administration, Audit History, Citizen Web, Map Viewer, Location Entry Component (GIS), Directory and Knowledge base search modules were parts of the project along with Contact Center management.
Responsibilities:
• Involved in all phases of software development life cycle (SDLC) for system implementation
• I was responsible for participating in technical discussions with the offshore and onsite Architect teams and coordinating the efforts of the design team based on that understanding.
• Created Use cases, activity report, logical components, and deployment views to extract business process flows and workflows involved in the project to track the progress of test case planning
• Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and monitored these revisions
• Involved in compatibility testing with other software programs, hardware, Operating systems, and network environments
• Member of Design and Design Review teams & involved in Team Code Reviews.
• Responsible for complete Resource Management & Project Planning.
• Worked on Database design, Data Mining, Data Scrubbing especially when data has been imported from other sources.
• Developed several utilities for quick creation of tables, insertion of bulk data and application documentation.
• Database optimization and Performance tuning to improve application response time. Projects:
• Payroll System.
The application was responsible for storing the employee profile Information and maintained their payroll. Analyzed, Developed, and implemented this application and later migrated to Oracle database. It also interfaces with the Time Scheduler System and calculates the Payroll based on the Time sheet & Billable hours. It also allows the user to preview & print related reports.
• Time Scheduler System.
It is a time tracking system developed in-house. Time Scheduler system helps employees to keep track of their time spent on various projects and activities. System also helps management in scheduling and planning of employees at various workstations, generates weekly time sheets with hours worked and billable hours. System interfaces with the Payroll System for generating employee payroll. This application is available to all workstations. Time scheduler also interfaces with central database. The main modules in the system are Employee information, Billing, and Accounts payable.
• Catalog Manager
This product was designed for easy maintenance of an online store’s catalog of products. It has easy to use interface like windows explorer. It has features such as context sensitive menus, cut, copy, and paste of categories and products. This is a module that is developed to work in tandem with others like Inventory Manager, Customer Manager, Preferences Manager and the like, that form a backbone to an online store. Environment: VB6, ADO, MS SQL Server
Responsibilities:
• Responsible for complete Team Allocation & Management.
• Independently handled and interacted with the client.
• Organizing JAD sessions, interviews, and surveys in the process of collecting requirements
• Created Use cases, activity report, logical components, and deployment views to extract business process flows and workflows involved in the project to track the progress of test case planning
• Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and monitored these revisions
• Involved in compatibility testing with other software programs, hardware, Operating systems, and network environments Zee Tech Solutions, NJ. Aug 2003 - Jul 2004
Role: Business Analyst.
Project: Cost Operations Network
An in-house ERP project, it automates the cost and operational functions of the client, as well as providing an interface for the employees and management. The employees could apply for leave, loan etc., online and can also know the status of the same. The management can know the status of their various projects and their details and the financial counterpart of the same. Have a discussion forum for the employees with diverse topics. Environment: C#.Net, ASP. Net, Entity Framework, MS SQL Server reporting Services, MS SQL Server, MS Project, MS Visual Source Safe, MS Visio.
Responsibilities:
• Involved in all phases of software development life cycle (SDLC) in AGILE framework and
• Analyzed and collected business requirements, identified system interfaces, and created the requirements specification document
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis. Performed user interviews.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow
• Developed UML Use Cases for the application and prepared the detailed Workflow diagram based on the proposed enhancement for the system
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project Nufab India Ltd., India Jan 2001 – May 2003
Role: IT Manager.
Environment: Oracle 8, Visual Basic 6.0, MS Office, MSI Wise, MS Project, Crystal Reports, MS Visual SourceSafe, UNIX. Responsibilities:
• Worked as the Project Manager for their Garment Manufacturing System Application.
• Responsible for complete Team Allocation & Management.
• Created and designed the database, plan, and flow chart.
• Designed the Manufacturing system. Supported the company’s ERP/MRP system.
• Demonstrating the architectural implementation through code and design.
• Designed the Database using Data Modeling tool ERWIN
• Building reusable best practice code examples.
• Participate in architecture, design, and code reviews.
• Design tables, stored procedures, views, functions, triggers, queries using SQL Server, VB 6.0, SQL, PL/SQL and other tools.
• Provide Production Support. Test and debug the program. EDCOM InfoTech, India. Aug 1998 - Dec 2000
Role: Sr. Programmer.
Project:
• Discount Card System
Environment: Oracle 8, VB 6.0, Crystal Reports, MS Excel.
• www.Buddhiman.com
For this website, I was responsible for creating the tables in MS SQL Server 7.0, writing queries, stored procedures, triggers and maintaining the backend server. www.buddhiman.com was the company’s portal, which provided information about books, universities, colleges, etc. This website also lets the user search for a particular book from an exhaustive database and buy books at discounted prices. It also took care of maintaining information and data in tables created in MS SQL Server 7.0.
Environment: MS SQL Server 7.0, Visual Basic 6.0, Crystal Report, ASP. TECHNICAL EXPERTISE
• Sales Force
• Oracle 8, 8i, 10g, 11g
• Webforms
• WinForms
• MS Office
• MS Access, MS Excel
• Entity Framework
• SDLC
• Project Management
• ERWIN
• VB.Net, C#.Net, ASP. Net
• AJAX, CSS
• LINQ
• Web Services
• ADO.Net
• XML
• JavaScript, VB Script
• Macros, VBA
• MS SQL Server
• MS SQL Reporting Services
• MS Visual Studio 2005/ 2008
• MS Project, Visio
• MS Visual SourceSafe
• MS Visual Basic 6
• WCF/ WF/ WPF
• Crystal Reports, Access Reports,
Oracle Reports
Contact this candidate