• Built data structures that integrate patient medical record data across source systems and allow seamless analysis over time• Created interactive PowerBI choropleth map to visualize patient population by geographic origin• Developed data marts to support the analysis of ERP data sourced from multiple platforms

• Integrated data from 10+ source systems into data warehouse to simplify Tableau dashboard data sourcing• Created custom conformed dimensions to support reporting on health equity initiatives

• Provided ETL and analytics support for regional health systems using SSIS and SSRS

• Redesigned cost benchmarking data model, ETL, and analytics to support Pharmacy in identifying factors that drive cost variance, resulting in $250K annual savings from first test case• Automated all data warehouse file imports and extracts to/from collections agencies using SSIS and stored procedures • Developed interactive data visualizations in Webi to support operational and historical analytics for Jail Health ServicesSoftware/technology used: T-SQL, PL/SQL, SAP Crystal Reports, SAP Web Intelligence, SQL Server Data Tools, SQL Server Integration ServicesEpic Certifications: Caboodle Development, Caboodle-Clarity Development, Caboodle Administration, EpicCare Ambulatory Data Model

• Designed interactive data visualizations with drill-down capabilities in WebI to allow Metro Transit staff to understand the factors affecting overall transit performance • Created dashboards for leadership to review restricted Human Resources data at various levels of detail while securing/presenting that data based on the employee’s role• Trained transit analysts on how to use and build custom Webi reports and dashboards• Software used: SAP Web Intelligence, Lumira, Crystal Reports, Dashboards

• Redesigned regulatory data submission system used by all Allina and many affiliated hospitals to be automated, contained entirely within SQL Server platform, and supported by fewer staff• Built ETL and data model to move inpatient and outpatient visits through 3M Potentially Preventable Events grouping software, allowing Allina to see variances in cost and care• Developed data pipelines that allowed Blue Cross Blue Shield to incentivize follow-up care for members identified as at-risk for specific conditions• Redesigned diagnosis and procedure data models and trained analysts, developers and report writers to ensure seamless transition to ICD-10 code-sets

• Managed automation of payroll data reporting features in order to eliminate manual, error-prone report creation• Developed reports to identify potential billing discrepancies to allow Finance department to proactively rather than retroactively adjust invoices• Designed major components of platform redesign needed to support Bloom’s first employers moving into their second billing year on the private insurance exchange

• Created and managed brand-new user acceptance testing process• Led small teams to develop standardized rules for data sourced from multiple platforms• Implemented framework to measure data consistency, validity, timeliness, and completeness• Managed communication process to ensure that analysts receive critical information in a timely manner• Trained data analysts to understand and employ new system features

• Developed, unit tested and migrated PL/SQL code, conducted code reviews, set up batch jobs and automated file transfers• Gathered requirements for moving disparate consumer loyalty systems into a common, service-oriented architecture• Created and maintained a variety of documentation including risk and issue logs, disaster recovery plans, user guides and weekly team status reports