April J. Mumpower
Blountville
Summary
Results-driven QA Manager with a strong focus on test automation, process improvement, and risk management. Demonstrated ability to lead teams and implement efficient solutions that exceed quality standards. Proven expertise in statistical analysis, predictive modeling, and data visualization as a Healthcare Data Analyst, driving operational improvements and enhancing patient care. Career objectives include leveraging data-driven insights to further optimize healthcare operations and policy planning.
Overview
22
22
years of professional experience
Work History
BI & Business Analyst | Administration
MetricVantage Analytics Freelance
06.2024 - Current
- Predictive Analytics Development: Enhanced client revenue forecasts by 30% through comprehensive analysis of historical sales data and predictive modeling techniques
- Standardized Reporting & Automation: Developed automated data pipelines for Tableau and Power BI, significantly reducing manual data entry and improving accuracy
- Documented business requirements, translating them into user stories and acceptance criteria to support data solution development
- Tableau Implementation for Prosthetics Industry: Spearheaded the transition from manual reporting to an automated Tableau-based system using PostgreSQL, decreasing reporting time by 67% and enabling real-time monitoring of production and patient outcomes
- Conducted quantitative analysis on historical sales data to identify key trends
- Payroll System Implementation: Worked with small retail business to optimize payroll and workforce management processes, ensuring seamless automation and compliance
- Innovative Solutions: Empowered care teams to proactively identify non-compliant patients and implement targeted outreach strategies, resulting in a 15% improvement in preventive screening compliance within six months
- Collaboration Tools: Utilized Confluence and Slack for documentation and cross-team coordination, ensuring seamless project execution
Business Intelligence Manager | Solutions Developer
Glytec Systems
Greenville
04.2021 - 05.2024
- Dashboard Development: Created ERDs and data flow diagrams for system integration between Glucommander and EHRs
- Built interactive dashboards with Power BI and Tableau, enhancing diabetes management insights and patient care
- Salesforce-Tableau Integration: Led requirements sessions with IT, sales, marketing, and operations
- Developed Tableau and Power BI dashboards integrating Salesforce and Glucommander, providing real-time sales trends and pipeline forecasting
- Strategic Reporting & Visualization: Translated complex sales performance metrics into executive and client-level Tableau dashboards, enabling data-driven decision-making
- SQL Optimization: Partnered with DevOps to enhance data retrieval accuracy using optimized SQL scripts, improving reporting speed by 50%
- Research Analysis: Conducted statistical analysis supporting publications on diabetes management
- Team Leadership & Collaboration: Conducted gap analysis between current reporting capabilities and business needs, identifying key areas for improvement
- Successfully led diverse teams to exceed goals through collaboration, clear communication, and strategic leadership using JIRA, Confluence, and GitHub for agile project management
- Mentored junior BI developers, guiding them in best practices for data visualization, performance optimization, and SQL scripting
BI Product and Data Science Manager | Data Strategy & Governance
Ballad Health
Johnson City
02.2016 - 04.2021
- COPA Implementation Leadership: Played a crucial role in merging two hospital systems under the Certificate of Public Advantage (COPA), ensuring the seamless integration of analytics to support regulatory compliance and operational alignment
- Predictive Analytics: Employed QI Macros and Excel for predictive modeling and regression analysis, achieving accurate forecasting of patient care risks and optimizing operational planning
- Project Leadership: Directed data projects by managing daily standups, planning, scoping, goal setting, and reviews using JIRA
- Conducted requirements sessions with hospital staff to enhance performance tracking and mentored data analysts on improvement methodologies and BI best practices
- Data Governance & QA: Evaluated project outputs to enhance QA practices and guide continuous improvement of data team processes and technical development
- Advanced Analytics & Operations Research: Utilized predictive analytics to forecast patient care risks and refine operations
- Developed optimization models to improve clinical and financial performance
- Created interactive mockups and wireframes in Power BI and Sigma, enhancing usability and data storytelling
- Documentation & Storytelling: Created comprehensive project documentation using Confluence and presented analytical insights through Google Analytics to support data-driven decision-making
- Developed detailed user stories and acceptance criteria for hospital analytics projects, including patient readmission rate reporting and infection control dashboards
Senior Business Analyst
Ballad Health
Johnson City
06.2007 - 04.2016
- Predictive Analytics & QI Macros: Utilized QI Macros in Excel to generate control charts, run charts, and regression models for real-time monitoring and predictive analysis
- Operational Dashboards: Created Power BI dashboards based on QI Macros analysis, offering insights for leadership decision-making
- Process Optimization: Implemented Lean Six Sigma principles to improve workflows, resulting in a 20% reduction in surgical delays and increased overall efficiency
- Developed data dictionaries and standard operating procedures (SOPs) for analytics tools to maintain consistency in hospital performance metrics
- Data Analysis: Conducted assessments of healthcare performance against benchmarks, identifying areas for improvement in patient care and provider adherence
- SharePoint Integration: Enhanced document management and collaboration by establishing and maintaining SharePoint sites
Payroll Specialist
Ballad Health
09.2003 - 06.2007
- Processed Payroll: Managed payroll for 21+ facilities with a large workforce, ensuring accuracy and compliance with labor laws
- Oversaw payroll cycles, reconciled discrepancies, and implemented process improvements to enhance efficiency
- Kronos Workforce Management: Utilized Kronos to manage time and attendance tracking, workforce scheduling, and payroll integration
- Configured system settings to align with company policies and labor regulations, improving overall payroll accuracy
- Kronos Education & Training: Designed and conducted comprehensive Kronos training sessions for employees and payroll staff, enhancing system adoption and efficiency
- Created user guides and troubleshooting resources to support ongoing learning and reduce common errors
- Collaboration: Worked closely with HR, Compliance, and Finance teams to streamline payroll processes, reducing processing time and minimizing errors
- Assisted in audits and policy updates to ensure adherence to federal and state regulations
- Reports & Data Analysis: Provided data-driven insights and customized payroll reports to optimize workforce costs, track labor trends, and ensure compliance
- Developed dashboards and automated reporting processes for leadership review
- Tax Preparation & Compliance: Managed tax preparation, including 990 forms and all associated filings for businesses and non-profits
- Ensured timely and accurate tax submissions while staying updated on changing tax laws to mitigate financial risks
Education
Bachelor of Science - Advanced Information Technology of Health Informatics
Kaplan University
Associate of Applied Science - Business Administration in Management
Kaplan University
Skills
- Strategic Transformation
- Advanced Methodologies
- Continuous Improvement
- Healthcare Expertise
- Data Engineering
- Quality Improvement
- Technical Proficiency
- Project Management
- Communication
- SQL optimization
- Predictive analytics
- Data governance
- Business analysis
- Project management
- Team leadership
- Process optimization
- Statistical analysis
- Performance evaluation
- Corporate governance
- Product development
- Teamwork and collaboration
- Reporting and documenting
Publications
- Characteristics of and Mortality Associated with Diabetic Ketoacidosis Among US Patients Hospitalized With or Without COVID-19., JAMA Netw Open, 03/01/21
- Comparison of an Electronic Glycemic Management System Versus Provider-Managed Subcutaneous Basal Bolus Insulin Therapy in the Hospital Setting., J Diabetes Sci Technol, 01/01/17
Certifications And Tools
- Kronos Workforce Management
- SQL Server
- Power BI
- Tableau
- Advanced Excel (Power Pivot, Macros, VBA)
- Microsoft Dynamics 365
- QuickBooks
Timeline
BI & Business Analyst | Administration
MetricVantage Analytics Freelance
06.2024 - Current
Business Intelligence Manager | Solutions Developer
Glytec Systems
04.2021 - 05.2024
BI Product and Data Science Manager | Data Strategy & Governance
Ballad Health
02.2016 - 04.2021
Senior Business Analyst
Ballad Health
06.2007 - 04.2016
Payroll Specialist
Ballad Health
09.2003 - 06.2007
Bachelor of Science - Advanced Information Technology of Health Informatics
Kaplan University
Associate of Applied Science - Business Administration in Management
Kaplan University
Similar Profiles
ONKAR BELGAMWARONKAR BELGAMWAR
Architect at Fractal Analytics, Formerly Neal AnalyticsArchitect at Fractal Analytics, Formerly Neal Analytics
Ankush CHAUHANAnkush CHAUHAN
Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)
Badria AlghamdiBadria Alghamdi
Resume writter at Freelance (Self employed) · FreelanceResume writter at Freelance (Self employed) · Freelance