Matthew Ellinger Email & Phone Number

Washington, Dc, Us

Washington, Dc, Us

Bluffton, Sc, Us

Tableau subject-matter expert (SME) for the UMDSS Data Strategy & Solution Excellence team. Concentrated on Tableau Administration, Development and Training.- Performed administrative and support activities across Tableau infrastructure including security administration, installation and configuration of Tableau Server.- Developed and maintained BI solutions in Tableau that impacted daily workflow of the business.- Migrated single node on-premise production servers to a server cluster in the cloud (Azure).- Provided guidance to site administrators on how to manage their environments effectively.- Authored documentation and hosted training sessions to educate the business on best practices.- Established roadmaps and associated timelines that outlined key BI initiatives.- Automated server maintenance events, including backup, cleanup and archival.- Streamlined various tasks using Python to interact with the Tableau REST API.- Created dashboards to monitor relevant server metrics using the Tableau PostgreSQL DB.- Updated server topology and configuration based on business usage to improve performance and utilization of resources, ultimately decreasing server job delays by 95%.- Queried databases from several platforms, including Oracle, Azure Synapse and Databricks.- Worked with cross-disciplinary teams using Kanban and Agile methodologies (Azure DevOps)

Phoenix, Arizona, Us

Risk Adjustment subject matter expert (SME) for Reporting and Analytics and lead SQL developer for Specialty Analytics. Focused on BI development for Risk Adjustment, Eligibility and Enrollment.- Implemented on-premises and cloud-based enterprise BI solutions.- Established MA Risk Adjustment analytics architecture.- Developed SQL Server Analysis Services (SSAS) tabular models using Visual Studio.- Applied row-level security to datasets to adhere to HITRUST standards.- Created dashboards and interactive reporting solutions using Power BI and Reporting Services (SSRS).- Led development for CMS (RAPS/EDPS) submission and reconciliation efforts.- Conducted mid-year and final year financial projections for MA health plans.- Performed ETL in SQL Server Integration Services (SSIS) to migrate data from OLTP product databases to a central data warehouse (OLAP).- Coordinated SSAS deployments and user access across development environments (QA, UAT and Prod).- Managed tabular model metadata using TMSL (JSON/XMLA) scripts.- Assisted in the implementation of CI/CD pipeline for SSAS solutions.

Phoenix, Arizona, Us

Risk Adjustment subject matter expert (SME) for Reporting and Analytics and lead SQL developer for Specialty Analytics.- Developed automated data extractions for various clients.- Wrote stored procedures to support reporting, analytics and back-end applications.- Queried SQL Server databases and tabular models using T-SQL and DAX.- Met with customers to respond to technical inquiries and suggest solutions.- Created formal documentation, best practices and process specifications within a growing company.- Built and loaded reference data tables for CMS HCC Models into a SQL Server database.- Combined industry and technical knowledge to develop scalable solutions for identifying incremental HCCs, providing MA financial accruals, and creating supplemental submission files.- Worked with cross disciplinary teams using Kanban and Agile methodologies (JIRA, Azure DevOps, TFS).- Provided recommendations to improve functionality within Centauri's medical coding application.- Advised project managers on development timelines.- Interviewed candidates for the Reporting and Analytics team.

Bloomfield, Ct, Us

Member of the Medicare Data Quality team providing risk adjustment and financial analytics. Supported risk adjustment and coding initiatives in addition to serving as lead analyst for the Mid-Atlantic in-home assessment program.- Performed risk adjustment and quality analysis that implemented CMS and HEDIS guidelines.- Owned SQL-based processes that triggered payments for provider incentive programs.- Analyzed trends within large and complex datasets using T-SQL.- Met with internal customers to gather requirements and develop specifications.- Generated reporting that helped drive business decisions across various levels of the organization.

Bloomfield, Ct, Us

Member of the Medicare Data Quality team providing risk adjustment and financial analytics. Primarily supported the in-home assessment program for the Mid-Atlantic region.- Utilized T-SQL and advanced Excel formulas to perform data analysis.- Produced ad-hoc and standard reporting to meet business requests.- Maintained business logic in place to reconcile provider incentive payments.- Identified process inefficiencies and implemented improvements.- Employed workflow automation macros using VBA to create self-service reporting solutions in Excel.

Bloomfield, Ct, Us

Member of the Provider Network Operations team for the Mid-Atlantic region. Assisted in the processing of provider contracts and incentive program agreements.- Reviewed and verified provider applications.- Interacted with provider credentialing contacts to obtain supporting documentation.- Incorporated new providers into the claims processing system QNXT.- Assembled welcome documents.