PROFESSIONAL EXPERIENCE:

Principal Planning Analyst

Confidential, Detroit, MI

• Developed a corporate and site profile of potential acquisition targets for the Henry Ford Cancer Institute, including the history of the parent corporation, its partnerships in the Southeast Michigan market, and a summary dashboard of key metrics (age, payer mix, forecasted population growth, median household income) for the surrounding area of each target site
• Illustrated population demographics and areas of Confidential care coverage and demand in Southeastern Michigan using database - driven geomaps of the region to plan the placement of ambulatory centers and ensure the correct mix of healthcare services relative to the local population
• Managed a forecasted $9M portfolio of short-term, cancer-related projects across five hospitals to ensure the system-wide adoption of best practices, the development of a “pitchbook” for facilitating system-to-system oncology partnerships, and the hiring and deployment of clerical and administrative staff to increase throughput at oncology practices throughout the Confidential
• In partnership with the Strategic Support Services team, developed and maintained requirements documentation, project plans, use cases, and other artifacts in support of assigned projects
• Developed and deployed automated reports that summarized Confidential and competitor activities and market share in strategic planning markets
• Coordinated annual certificate of need surveys required by the state and the annual American Hospital Association Survey used to create the U.S. News and World Report Top 100 Hospitals annual report
• Developed automated reports and dashboards that summarized Certificate of Need compliance by site and by market for the Confidential

Sr. Data Information Analyst

Confidential , Confidential, WA

• Developed and maintained project documentation in support of the development of the BHO Data Warehouse, including but not limited to: Raintree EMR data dictionary, process decomposition diagrams, entity text templates, process workflows and procedural narrative, stakeholder lists, use case models, and risks/issues/resolution logs
• Illustrated geographic areas of mental Confidential care coverage and demand in Eastern Washington using geo-maps of the region to ensure continued state and federal funding
• Coordinated project deliverables to ensure their timely delivery and quality from vendors
• Supported operations with ad hoc and monthly operational reports developed in SQL and Excel/PowerPivot

Sr. Medical Informatics Analyst

Confidential

• Assumed role and job functions of departing Medical Informatics Manager, including responsibility for the Physician Group Incentive Program (PGIP) and supervision of two junior analysts and an offsite application development team
• Led successful overhaul and update of the PGIP forecasting model, slashing development time from six months to four, a 33% decrease from the previous year
• Using Excel, PowerPivot, and Sharepoint, developed a series of dashboards and reports tracking directorate-level performance metrics and progress towards completion of departmental and individual manager and team leader-level goals

Project Manager

Confidential

• Identified, evangelized, and implemented strategic and operational reforms in the areas of customer service, appeals and grievances, legislative and regulatory compliance, and individual product sales that ensured NCQA accreditation for BCBSM and the ability to sell millions of dollars of Confidential insurance products on Healthcare.gov
• Coordinated a $22M portfolio of healthcare reform projects, reporting spend and preparing change requests on behalf of my director to executive leadership
• Served as project manager for the consolidation of multiple, client-based customer service and appeals departments, operational policies, and support systems under a single, enterprise-wide department and set of NCQA-compliance standards

Market Research Manager

Confidential

• Identified and eliminated a 15% price differential between Confidential Alliance Plan individual Confidential insurance products and those of its competitors, resulting in a 30% increase in sales over a period of 12 months
• Revitalized the members’ affinity discount program, growing the number of participants from three to thirty-three and enrolling more than 150 chiropractors into the program over a period of 12 months

Lead Systems Analyst

Confidential

• Using Lean Management tools including, but not limited to FMEAs, fishbone diagrams, and Kanban, successfully re-engineered and trained the end-to-end Small and Reform Group Renewal process across four departments over a period of 6 months, reducing the number of renewals lost due to handling and processing errors by 85%
• Managed the ongoing maintenance and development of the company’s small group Confidential insurance product sales portal in accordance with the vendor contract through the development of requirements documentation, project plans, external interactions templates, decision tables, and use cases developed in partnership with the Sales and Marketing and Underwriting and Rating departments
• Developed an Access-based CRM application for the Sales and Marketing team that standardized and automated book of business maintenance and reporting

Analyst/Project Manager Consultant

Confidential

• Using Lean Management tools, Vision, and Word, coordinated successful ISO-9001/Ford Motor Company Q1 certification projects for Tier I automotive suppliers, including automotive marketing company CCA/HA-LO and transportation and logistics company OJ Transport
• Using Visio and Word, documented policies and procedures governing the operation of the Ford Confidential Oval and Chrysler Pentastar dealership certification programs