Michael Gass

Michael Gass Email and Phone Number

Business Intelligence Analyst @ HCA Healthcare
Lebanon, TN, US
Michael Gass's Location
Lebanon, Tennessee, United States, United States
About Michael Gass

Experienced business intelligence analyst, ETL developer, and provider of automated solutions.SQL – Teradata, PostGreSQL, Oracle, MySQL, Microsoft SQL Server (Advanced T-SQL, Stored Procedures, Dynamic SQL, SQL Server Agent, System Catalog, Integration Services Catalog, etc.), Azure SynapseIntegration - SQL Server Integration Services (SSIS), Python, PETL, some exposure to AWS GlueAutomation - Python, Batch files, PowershellVisualization, Reporting, and Exploratory Data Analysis - PowerBI, Tableau, MicroStrategy, Visual Insights, Pandas, Jupyter Labs, R, Machine Learning, SSRS, Power BI Report Services, LookerDevelopment - SSMS, Azure Data Studio, PGAdmin4, Visual Studio Code, Visual Studio, Github, TFS, Redgate SQL CompareProductivity - Microsoft Teams, Jira, Smartsheet, Microsoft Excel, Microsoft Access, Visual Basic for Applications, SharePoint, Azure DevOps

Michael Gass's Current Company Details
HCA Healthcare

Hca Healthcare

View
Business Intelligence Analyst
Lebanon, TN, US
Michael Gass Work Experience Details
  • Hca Healthcare
    Business Intelligence Analyst
    Hca Healthcare
    Lebanon, Tn, Us
  • Sarah Cannon
    Data Analyst
    Sarah Cannon Dec 2021 - Present
    Nashville, Tn, Us
  • Lebanon Breakfast Rotary Club
    Member
    Lebanon Breakfast Rotary Club Jul 2022 - Present
  • Lifepoint Health®
    Data Analyst
    Lifepoint Health® Aug 2021 - Nov 2021
    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.
  • Adherehealth, Llc
    Sql Developer
    Adherehealth, Llc Jun 2018 - Jun 2021
    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.
  • Parallon
    Business Intelligence Analyst, Health Information Management (Him)
    Parallon Sep 2015 - Sep 2017
    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 problems and provide various ETL solutions, automated routines, reports, interactive dashboards, and visualizations.
  • Parallon
    Business Analyst
    Parallon Feb 2011 - Sep 2015
    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 dashboard development.• Completed Microsoft Official Course ‘Implementing a Data Warehouse with Microsoft SQL Server 2012’

Michael Gass Skills

Sharepoint Business Intelligence Microsoft Sql Server Access Visio Business Analysis Microsoft Office Mysql Icd 9 Html Visual Basic Powerpoint Microsoft Excel Healthcare Database Admin Etl Windows Server Php Business Objects Cpt Data Analysis Ssis Vba Mobile Applications Database Management Databases Process Improvement Ms Excel Pivot Tables Excel Barcode Project Management Healthcare Information Technology Microstrategy Reporting Ms Office Automation Vbscript Powershell Batch Files Teradata Icd 10 Cm

Michael Gass Education Details

  • Western Governors University
    Western Governors University
    Data Management/Data Analytics
  • Udacity
    Udacity
    Data Analysis And Visualization With Microsoft Power Bi
  • Udacity
    Udacity
    Data Analyst
  • Nashville State Community College
    Nashville State Community College
    Medical Coding
  • Castle Heights Military Academy
    Castle Heights Military Academy
    Academic Diploma

Frequently Asked Questions about Michael Gass

What company does Michael Gass work for?

Michael Gass works for Hca Healthcare

What is Michael Gass's role at the current company?

Michael Gass's current role is Business Intelligence Analyst.

What is Michael Gass's email address?

Michael Gass's email address is mi****@****non.com

What is Michael Gass's direct phone number?

Michael Gass's direct phone number is +161529*****

What schools did Michael Gass attend?

Michael Gass attended Western Governors University, Udacity, Udacity, Nashville State Community College, Castle Heights Military Academy.

What are some of Michael Gass's interests?

Michael Gass has interest in Visual Basic, Ms Access, Ios, Sql Server Integration Services, Sql Server, Microstrategy, Sharepoint, Evernote, Business Intelligence, Powerpivot.

What skills is Michael Gass known for?

Michael Gass has skills like Sharepoint, Business Intelligence, Microsoft Sql Server, Access, Visio, Business Analysis, Microsoft Office, Mysql, Icd 9, Html, Visual Basic, Powerpoint.

Who are Michael Gass's colleagues?

Michael Gass's colleagues are Tracy B., Matlaba Jerida Magwai, Monique Weber, Kelly Persons, Charlaine Crocker, Carlos Cruz, Gilmiery Crasto.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.