Summary
Overview
Work History
Skills
Timeline
Generic

Ryan Pinkowski

Plainfield,IL

Summary

Creative and technically skilled analytics developer with a proven record of providing impactful data solutions. Collaborates well with users to develop applications that serve as key tools in optimizing clinical outcomes and revenue cycle integrity. Agile team member with demonstrated ability to communicate effectively within all levels of an organization.

Overview

9
9
years of professional experience

Work History

Senior Data Analyst

Everly Health
01.2022 - Current
  • Owned data and reporting functions while serving as the domain expert for multiple internal and external EMR platforms which were critical in lab processing and telehealth workflows. Partnered with product and engineering teams to build and implement system features necessary for enterprise initiatives.
  • Crafted robust data models, dashboards, and visualizations in Looker using data from upstream EMR platforms in addition to Salesforce and Delighted which provided key insights into enterprise operations as well as member satisfaction.
  • Partnered with the product and accounts team to create bespoke data products which tracked member lifecycles and quantified member engagement for enterprise clients.
  • Engaged with product managers and internal stakeholders in the inception and design of key performance indicators to track and monitor the efficacy of enterprise initiatives via custom Looker dashboards.
  • Lead collaboration between analytics and operations in the enterprise CRM migration to Salesforce. Performed system analyses to identify downstream dependencies, updated pertinent reporting content and data sources, and created net new tables and views in Snowflake.
  • Extracted data from Snowflake via advanced SQL queries to create content in Looker and Redash used to monitor lab testing performance, order lifecycles, and customer outreach via Salesforce.
  • Onboarded new employees and participated in knowledge transfer of internal systems and applications.
  • Mentored internal employees interested in the field of analytics.

Business Intelligence Developer

Advocate Aurora Health
Oakbrook Terrace, IL
08.2019 - 01.2022
  • Led the enterprise analytics team in a multi-state go-live of the Epic EMR and subsequent modules. Performed knowledge transfer with other team members, evaluated and migrated content from legacy systems, and developed critical net new content prior to go-live for clinical and operational stakeholders.
  • Responded agilely in the face of the COVID-19 pandemic and collaborated with operations across the enterprise to develop custom reports and PowerBI dashboards to efficiently allocate resources to testing and vaccination centers in addition to monitoring the vaccination rate of the enterprise's priority patient populations.
  • Realized a PowerBI dashboard that identified physicians who chronically overprescribed opioids as well as at-risk patients and co-prescription trends.
  • Developed and maintained custom data pipelines to adjacent departments as well as external vendors.
  • Chaired an internal committee that developed departmental best practices and standards for report and dashboard publication as well as code development and optimization.
  • Onboarded new employees and reviewed departmental procedures and standards with them in addition to training them in various application data models.

Senior Business Intelligence Analyst

Advocate Aurora Health
Downers Grove, Illinois
05.2019 - 08.2019
  • Managed data pipelines from The Center for Medicare and Medicaid Services (CMS) to the enterprise data warehouse.
  • Produced presentations for quarterly CMS Overall Hospital Quality Star Ratings and HCAHPS Star Ratings that reflected the current performance for 22 hospitals, their change from previous ratings, and their scores' impact on federal reimbursement.
  • Designed and implemented tools that allowed hospitals to see how hypothetical changes to their scores in a given domain would impact their ratings as a whole.
  • Processed and disseminated rules and updates to various government programs such as Hospital Value Based Purchasing (HVBP), Hospital Readmissions Reduction Program (HRRP), Hospital-Acquired Conditions Reduction Program (HACRP), and others

Business Intelligence Analyst

Palos Health
Palos Heights, Illinois
05.2015 - 05.2019
  • Collaborated with end users from the clinical to executive level to build Qlik Sense dashboards that fill crucial roles such as the monitoring of readmission rates, documentation compliance, clinical throughput, and denial volume and trends.
  • Served as Qlik Sense admin and oversaw the deployment of dashboards, management of user security, and regular upgrades.
  • Led and coordinated long-term projects across multiple business areas using the agile project management tool Jira.
  • Adept at navigating through workflows and source records to track data lineage.
  • Opened, troubleshooted, and resolved help desk tickets submitted by end users.

Skills

  • Technical Skills: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Snowflake, Redash, Athena, Salesforce, PowerBI, Qlik Sense, Looker, Business Objects, Crystal Reports, Azure DevOps, Jira, GitHub, and Microsoft Office Suite
  • Certifications: Epic Clinical Data Model, Epic Caboodle Data Model, Epic Clarity Data Model, Epic Cogito
  • Leadership/Behavioral skills: Supervision and leadership, knowledge transfer, agile project management, self-motivator, creative, communicative, and accountable

Timeline

Senior Data Analyst

Everly Health
01.2022 - Current

Business Intelligence Developer

Advocate Aurora Health
08.2019 - 01.2022

Senior Business Intelligence Analyst

Advocate Aurora Health
05.2019 - 08.2019

Business Intelligence Analyst

Palos Health
05.2015 - 05.2019

Similar Profiles

CREATE PROFILE
Ryan Pinkowski