Business Intelligence Data Analysis

Theresa Bullard

Highly analytical and detail-oriented Healthcare Business Intelligence Developer with over 20+ years of experience in data analysis, reporting, and visualization. Possesses the ability to translate complex data into clear and meaningful key performance indicators and metric measures to support evidence-based decision making and improve operational efficiency. I am committed to solving problems through data analysis to improve patient care and provide leadership the information they need to make intelligent business decisions. Known for meeting tight deadlines and working successfully with stakeholders. I carry myself in a professional manner and understand the importance of communicating with customers and coworkers in a way that says, “I respect you and I value what you have to say”. I am seeking a position with a company where I can contribute and continue to grow my skills.

Experience:

●Business Intelligence Developer III (September 2019 - October 2024)

●Sutter Health - 916-***-****

●Manager: Wendy Robinson

Create complex SQL queries and reporting solutions from various clinical and financial databases to extract, summarize and analyze data. Work closely with Program Managers and Affiliates to produce KPI and metric measurements. Successfully implemented Oncology, ClinicalPath, Diagnostic Imaging, Mental Health, Opioid Stewardship, Neuroscience, and Telestroke reporting and visualizations. Including creating KPI and metrics for Utilization, Volume, Turnaround Time, Trends, Readmissions, Length of Stay, Admissions/Discharges, Emergency Services, Performance, and various process metrics. Responsible for providing analytical and operational support for Sutter Health’s Variation Reduction program by providing reporting, analytics, and visualizations. Create actionable data tools (Tableau dashboards/SSRS reports) to help executive leadership identify and explain variations in physician practice patterns and make appropriate data-driven recommendations for improvement. In addition, develop ad-hoc reports to meet the needs of interdepartmental requests, including interpretation of requirements/specifications. Extract and transfer Clarity data extracts to outside vendors using SSIS. Create and maintain monthly, quarterly, and ad hoc reports. Use of Epic as source for data validation.

●Business Intelligence Analyst II (June 2016 – September 2019)

●Sutter Health - 916-***-****

●Manager: Richard Jenkins

Provided analytic reporting for Sutter Select, Sutter Gould, Sutter Medical Foundation, Central Valley Medical Group and Sutter Independent Physicians. Responsibilities included creating complex SQL code to extract and summarize data, research, interpret, and validate data for managed care, billing, reimbursement, and scheduling. Reports included Membership, Compensation, Unique Patient Quartiles/Referrals, Bed Days, Missing Charges, ER Utilization, Health and Healing, Charity Care, ER Frequent Flyer, Untimely Filings, Hospitalist Notes Without a Charge, Registration Denials, Non-Billable Write Offs, Reoccurring Bad Debt, Urgent Care, High Value Patients, and Division of Financial Responsibility (DOFR). Automated reports using SQL Server, SSRS, SSIS, and Microsoft Access.

●Clinical Informaticist (January 2011 – June 2016)

●Dignity Health Medical Foundation - 916-***-****

●Manager: Neil Pearl

Responsible for compiling and preparing data of a highly complex nature into various reports for, but not limited to, Finance, Managed Care, Quality, Operations, Executive Leadership, Billing and Accounts Receivables. I provided automated reports to heighten report access and usability. Developed user-report flexibility by creating conditional parameters, matrixes, report tabs, charts and interactive features such as drilldowns and sorting using SSRS. Prepared reporting deliverables for the various Medical Groups within the foundation, such as Post Lags, Inpatient SNF, Charges and Payments, Third Next Available, Provider Productivity, and Summary of Visits. Automated Billing Invoice Database, DOFR Comparison reporting, Patient Complaint reports, Patient Satisfaction Survey Scores, Utilization, and Out-of-Group Claims reporting.

●Accounting Analyst – Finance Department (May 2005 – December 2010)

●Sutter Health - 916-***-****

●Manager: Michele Smith

Duties included creating the Capitation monthly financials and analytical reporting for Sutter Health Sacramento Sierra Region (SHSSR). This consisted of producing reports and then recording journal entries into Lawson. Some of the reports were Membership, PMPM Revenue Allocation, Outpatient and Inpatient IBNR, Recovery Receivables, Internal Transfers, and Allocated Capitation Revenue. Along with also booking Interest Income and Case Management Fees into Lawson. Other job duties included monthly Profit and Loss Variance Analysis, Outpatient Surgery Utilization, Quality Improvement Payout (QIP) reports, Bed Days and Admits Utilization report, Capitation Performance packet, and PCP Utilization reports, along with various Ad Hoc reporting. When I started in this position, most of the processes consisted of manually cutting and pasting data into Excel. I made huge contributions to the department by automating numerous manual processes into Microsoft Access reports. This eliminated man hours and increased proficiency and accuracy.

Skills:

20+ years of experience analyzing data and producing reports and visualizations in a Healthcare environment.

13 years of experience writing complex SQL queries, using Microsoft SQL Server Management Studio, to extract, summarize and analyze data. Stored Procedures, SQL User Defined Functions

13 years of experience creating SSRS interactive reports, matrixes, charts, tabs, and the use of sub reports.

13 years of experience developing and maintaining ETL processes using SSIS to transfer data to outside vendors.

13 years of experience using Team Foundation Server (TFS).

3+ years of experience creating dashboards using Tableau.

20+ years of experience using Microsoft Access including designing user applications.

EPIC/Clarity experience.

General Accounting Principles, Lawson, IDX, and Allscripts

Strong analytical and problem-solving skills. Ability to translate data analysis into meaningful reports for identifying data issues and help customers make sound business decisions.

Ability to process report requests with a consistently high level of accuracy and prioritize workload to meet deliverables within a timely manner.

Extremely respectful and professional when interacting with others within and outside the organization.

I am a great listener and communicator with a high interest in representing the company well when interacting with others.

Contact this candidate