Michael Gass Email & Phone Number

Lebanon, TN, US

Nashville, TN, US

Brentwood, TN, US

• Contract position through Rezult Group, LLC.
• Reengineered various reporting projects to break away from legacy data sources and to query data from current Azure Synapse data warehousing solution.
• Upgraded existing Power BI Report Services solution to support multi-facility data needs for supply chain and inventory labeling needs.
• Worked with other team members toward the spin up of self-service data exploration tool for leadership and management using Google Looker.

Nashville, Tennessee, US

• Executed development of data warehouse (DW), operational data store (ODS), and other large-scale solutions in support of business intelligence and reporting requirements for analysts, executive leadership, and clients.
• Developed numerous ETL solutions, data pipelines, and delivery mechanisms to continually load and update databases to maintain current and accurate data for various reporting and data feed products.
• Based on input from QA Analysts, developed automated data quality checking system incorporated into nightly data processes.
• Authored suite of python scripts to dynamically automate critical workflows, including import and export of various Excel spreadsheets, csv files, and similar data products.
• Collaborated with internal teams to understand, monitor, and streamline acquisition of data from various sources, including medical claims files, pharmacy claims files, eligibility files, reference tables and more.

Nashville, TN, US

• Provided routine and ad-hoc reporting and analysis solutions queried from patient accounting, diagnostic, and procedural coding data: ICD-10, CPT, HCPCS, discharge disposition, etc.
• Worked effectively with department leadership and subject matter experts to solve problems and to meet objectives.
• Developed dashboards, interactive reports, forecasting models, and automated solutions for data gathering and report distribution.
• Teradata SQL, Microsoft SQL Server, batch file scripting, Visual Basic for Applications (VBA), Excel dashboards, SharePoint, and MicroStrategy development are among the tools and skills deployed regularly to solve.

Nashville, TN, US

• Created and supported weekly and monthly reports. Developed, implemented and monitored ETL routines. Developed MicroStrategy reports and dashboards. Maintained and updated regular SSRS reports. Some exposure to SSAS.
• Provided extensive reporting and analysis queried from EMR and claims data: A/R, Claims on Hold, Payor Mix, etc.
• Transformed role away from concentrated work in Microsoft Access, Excel, and VBA by developing skills in Microsoft SQL Server, SQL Server Integration Services (SSIS), SharePoint, ETL development and MicroStrategy.
• Completed Microsoft Official Course ‘Implementing a Data Warehouse with Microsoft SQL Server 2012’

Bachelor Of Science (B.S.), Data Management/Data Analytics

Nanodegree, Data Analysis And Visualization With Microsoft Power Bi

Nanodegree, Data Analyst

Certificate, Medical Coding

Academic Diploma