UMER SHAH
MBA (Finance), MSc (IT), PMP, ITIL
Ph: 647-***-**** (Toronto, Canada), Email: ac69fa@r.postjobfree.com CAREER OBJECTIVE
To contribute towards the growth of an organization by implementing IT projects with my knowledge, skills and expertise while continuing to enhance my professional development through continuous learning. COMPETENCIES
University degrees with major in Information Technology, Business Management and Certification in Project Management.
8+ years of Project management and change management experience. Progressive experience in Business/System Analysis, Intelligence, Analytics and Reporting. Experienced in managing stakeholder communication and expectations at all levels. Expert in developing and presenting continuous improvement initiatives, business and operational plans. Experience with the full project life cycle from initiation to project close out. Worked on many IT projects such as Information System Implementation and client’s technology implementation. Developed and communicated all project documentation (Detailed Project Plans, Issues and Actions Logs, Communication Plans, Status Reports, Post Implementation Reviews, etc.). Project planning, prioritization, scheduling, progress reporting and risk management. Project Portfolio Management (PPM) management of projects and resources in Plan View. Management of project documentation on Project SharePoint site.
Expert at Microsoft SQL Server & its Business Intelligence layers (SSRS), database & data warehouse modeling. Thorough knowledge of various methodologies/frameworks such as SDLC, iterative and incremental project management methods (Agile), RUP and ITIL.
PROFESSIONAL EXPERIENCE
Project: Bayshore Healthcare Information Services Nov 2015 – Present Senior BA/PM (Bayshore Healthcare - Toronto)
Bayshore HealthCare is one of the Canada's largest providers of health care services with over 100 Locations in Canada. The function of the Bayshore Information Systems (IS) is to provide leadership and direction related to the selection, design, development, testing and technical support of business systems. IS is continuously involved in identifying opportunities for business system enhancements, integrations and Data Warehousing/Business Intelligence solutions. Responsibilities
Developed key project management deliverables and processes including Gantt charts, high-level and detailed project and communication plans and documenting and assessing risks to change management strategies.
Executed project implementation including management of scope, project timelines, data mapping, validation, ETL execution, data migration, QA testing, planning and design, deployment.
Delivered all project documentation (Detailed Project Plans, Issues and Actions Logs, Communication Plans, Status Reports, Post Implementation Reviews, etc.).
Solicited feedback and consensus from the committee members on open items to finalize recommendations.
Provided recommendations to the Information Systems Steering Committee for business system enhancements.
Provided Project Manager Support to the PMO department and successfully managed Stakeholder by meeting their expectations. Delivered artifacts such as Overall and Intake Project Management process, Projects estimation, Risk Assessment documents and BRD for PMO’s SharePoint site. Managed resources and activities for the implementation of Plan view.
Created and coordinated project plans and UAT test plan in MS Project, management of project budget and resources in Planview, change requests, maintaining/enforcing processes, standards and managing project documentation on Project SharePoint site.
Responsible for full end to end project delivery of MS Dynamic CRM and its implementation: from concept to requirements, along with business case development, design, development, testing and implementation.
IT project lead for ETL and integration initiatives (such as extracting of Customer’s and Sales order data to the data mart and uploading to the SFTP sites) that involved integration of CRM to ERP to eCom website. Delivered Project plan, BRDs, deployment plan and Issue tracking log. Implemented Change Management process. 2
Led integration project required for Fills fulfillment by carefully analyzing pharmacy management system (Kroll), ERP (MS Navision) and Ms Dynamics CRM systems and the processes.
Liaised between leadership and technology team to accurately gather, analyze, document and deliver business application requirements and draft functional/non-functional designs as a part of the integration program.
Participated in the Business Requirement Gathering and Analysis process with key stakeholders and end users and delivered Process documents for the key MS Dynamics CRM enhancements.
Conducted Gap analysis and process mapping and delivered Gap/Fit Analysis documents for the Outbound and Self Scheduling system.
Source and target system fields mapping and data analysis by creating and executing SQL queries.
Conducted Failure mode and effects analysis (FMEA) for Interface Report Failures. Environment: KROLL, MS Dynamics CRM/Navision, MS SharePoint, MS SQL Server, MS Office, MS Project 2010, MS Visio, Planview.
Project: Information Handling Services Sep 2014 – Nov 2015 Senior Business Solutions Analyst/PM (IHS - Toronto) IHS acquired R. L. Polk & Co., including Polk Canada and CARFAX. This partnership combines IHS's cross-industry expertise and global network with R. L. Polk & Co.’s market research, advanced analytics, software tools and extensive vehicle histories for a complete picture of the automotive industry. This provides greater visibility into the complete vehicle value chain, from product inception to sales, marketing and the aftermarket, helping OEM's to empower strategic planning, enhance aftermarket solutions, galvanize sales and marketing initiatives, build measure and increase customer loyalty. Responsibilities
Provided project management and Subject matter expert (SME) support to various Internal Improvement projects. Delivered: Project Plan and Status update reports. Developed and implemented Test Plans to ensure project accuracy. Resource planning activities.
Accountable for estimating the work to be done, identify dependencies, critical path activities, & the resources needed for each project. Led various IT enabled initiatives in a fast paced team.
Subject matter expertise (SME) support to automate Work Request Form (WRF) and its implementation in the Salesforce CRM application. Analyzed the WRF submission process in VIS projects. Delivered: WRF process documentation, power point presentation and training to the Sales Engineers, Production Programmers and Developers.
Developed and communicated project documentation for MY13 predictive model enhancement: Delivered Detailed Project Plans, Issues and Actions Logs, Communication Plans, Status Reports, Post Implementation Reviews, etc.
Analyzed and assigned Product Life Cycle (PLC) Jobs and Job Tasks for new projects and Cases for defect investigation to the Production Programmers and Developers.
Led Development team while managing complex Business Intelligence and Analytics project. Collaborated with stakeholders to identify opportunities where analytics can impact and accelerate results across the business.
Successfully delivered analytics projects to drive business decisions and sales for Retail clients. Collaborated with the team of Database Architects, statisticians and BI developers for designing and delivering products that are strategically aligned with the goals of the organization. Also developed and deliver the actionable insight to the business user through the use of BI tools such as Tableau.
Performed functional testing and root cause analysis on internal and external identified issues by using Oracle/MS SQL.
Managed resources and activities for the implementation of Project share Point site. Environment: Oracle, MS SQL, VB, Java, .Net, Salesforce, The Source, SharePoint, Tableau, OneView 360/ReFuel, MS Project 2010, MS Visio, MS Excel.
Project: Client’s Health Related Information System (CHRIS) Oct 2007 – Aug 2014 SME BA/Application and Data Analyst (OACCAC - Toronto) CHRIS is not just one application! It is an EMR, CRM, Scheduler, workflow management, Document Management, Resource and Referral management, Administrative tracking and Reporting tool. CHRIS is a highly integrated system with multiple internal and external integrations (including provider system to system integration). The system allows the user to order services, equipment and supplies.
Responsibilities
Provided Subject Matter Expert (SME) support for the successful deployment of modules, new functionalities and integrations.
Involved in various initiatives to perform all relevant tasks from business analysis planning, going through elicitation, analysis and documentation to supporting, training and implementation. 3
Spearheaded JAD sessions to identify and document requirements during elicitation. Performed gap analysis and produced documentation for business processes and training material during team building activities.
Participated in data migration from legacy systems to CHRIS and migration from IBM’s Rational Clear Quest tool to Microsoft’s Team Server Foundation system.
Involved in release preparation activities as a member of CRB (Change Review Board) and UAT Planning.
Conducted daily review meeting as a member of incident / problem management group and assigned issues to other team members and developers.
Led problem management activities that became projects by working closely with Users, Business Leads and Development team.
Formulated Provincial communication reports that highlighted the issues, risks, workarounds, and resolution. Also responded to queries on these issues as a SME.
Produced reports and updated Senior Management by sending out stats on KPIs.
Ensured compliance with service-level agreement (SLA). Environment: C# (C Sharp), .NET, SSRS, Ms Visio, Ms Office 2007, IBM Rational Clear Quest, Team Foundation server, SMA Tool, SQL Server 2005 and 2008, Ms Excel, MS Visio Project: United Healthcare Premium Designation (UHPD) Jan 2007 – Oct 2007 Business Analyst (Cognizant Technology Solutions - Toronto) Ingenix is transforming organizations and improving health care through information and technology. Facility Designation enables United Healthcare to identify, designate, and leverage providers (hospitals) that meet certain quality and cost/efficiency benchmarks and subsequently steer customers to utilize high quality and cost efficient providers and facilities. This directed change in utilization will ultimately allow United Healthcare to improve the level of quality, efficiency and affordability of care for its members, which will in turn ultimately reduce overall health care costs. Responsibilities
Led weekly project status update meetings (as part of CTS Toronto near shore team).
Created/coordinated project plans and UAT test plan in MS Project, management of resources, change requests, maintaining/enforcing processes, standards and managing project documentation on Project SharePoint site.
Performed analysis of business requirements for Healthcare Applications (Front End) and backend processes, to deploy a quality and efficiency criterion that nets a Designation result for Cardiac Hospitals and Orthopedics that is fed to downstream Portals for display.
Engaged in various internal and client-facing change requests that involved elicitation, analysis, documentation, development & QA support.
Utilized UML Models (use cases, activity diagrams), data models and ER diagrams, to develop detailed and complete Functional Specification and System Design Documents.
Created Process Flow Diagrams and screen mockups using Ms Visio.
Conducted and managed Technical and Business walkthrough sessions and updated Project plan in Ms Project 2007.
Created Test plan and in depth Test cases based on the Functional Specifications. Loaded and executed test cases using Mercury Quality Centre. Identified defects and performed regression testing.
Wrote technical specifications such as ETL Mapping documents for feeds from one database to another for analytics efficiency scores (to create a bridge from the Analytics database to the Designation Data Base (DDB) and Hospital Administration Application (HAA).
Used SQL Query Analyzer/Enterprise Manager for data mapping and validation of requirements.
Conducted Training session for off shore application support team in the maintenance and support phase of the project. Environment: Microsoft SQL Query Analyzer/Enterprise Manager, Ms Excel, Mercury Quality Centre, Visual Basic, ASP.Net, VB.Net, Visual SourceSafe, UML, Ms Visio
Project: Bell Canada Quality of Service (QOS) Sep 2006 – Jan 2007 Business Analyst (BELL Canada - Toronto)
This Bell Quality of Service (QOS) project is to Extract the auditable data elements (Customer Order Information) from Bell’s Database (Field Work Force Management), perform some ETL processes and forward it to another Database (Operations Data Mart) in the EDW (Enterprise Data Warehouse) in order for the CMA group to conduct a proper analysis of Bell’s compliance to CRTC rulings.
Responsibilities
Performed analysis of feed created from ODM DB to FWFM DB in order to meet requirements.
Worked closely with Project/Program Managers, ETL Developers and QA testers, by conducting JAD sessions and conference call meetings.
4
Wrote System Requirement Specifications (SRS), ETL Mapping documents and Data Dictionaries.
Performed extraction of Data for Analysis by merging and matching of months Data by running SQL queries and preparing Analysis Report for that time period.
Prepared UAT plan and reviewed System Test Cases to confirm incorporation of Matched Data. Environment: Oracle 9i, Teradata, Client Server, SQL, Ms -Excel, JAD and Enterprise Data Warehouse Technical
Expert proficiency with Microsoft Office Suite, Microsoft Project, Ms Visio, UML and Rational rose. SQL Server 2008, 2012 and 2014, Oracle 11i, Teradata, Ms Excel, SQL Service Reporting System (SSRS). Proficient with Test-Director 6.0, Win-Runner, QTP, IBM Rational Clear Quest (CQ), Team Foundation Server (TFS), Service Management Application (SMA) Tool, Microsoft Project, Salesforce, The Source, SharePoint, Tableau, OneView 360/ReFuel, KROLL, MS Dynamics CRM/Navision. Plan View.
Interpersonal skills: Strong analytical and problem solving skills; detailed-oriented; fully dedicated to delivering a project to client’s satisfaction, strong client interaction, easy to get along with; patient, consistent, honest, hardworking and strong work ethic.
EDUCATION
MSc (Information Technology) from University Of East London, UK 2002 MBA (Finance) from Institute of Management Studies, Pakistan 1999 CERTIFICATION
ITIL 2011 (Information Technology Infrastructure Library) foundation Certificate, Canada 2012 PMP (Project Management for Professional) Certificate, Canada 2006 TRAINING
Information Technology Project Management (Ryerson University, Toronto) SQL Server 2008 (Ryerson University, Toronto)
Training of Master-Trainers by ISCOS-CISL (a European funded organization) References available upon request