Looking for a job

Mario Roberts

@marioroberts

Business Intelligence Engineer at MemorialCare who built a Tableau dashboard that raised opioid discharge compliance from 63% to 80%.

United States

Message

At MemorialCare, I built the Discharge Opioid Days Supply dashboard in Tableau, with org-to-order drill-down, Pareto analysis, heat maps, and peer benchmarking. The analysis identified handwritten orders as the key compliance driver, and compliance rose from 63% to 80%.

I served as a technical authority on Epic Clarity, Caboodle, and Cogito reporting, delivering decision-support products and maintaining reporting data flows with SSIS. I also rewrote a failing stored procedure after execution-plan analysis, cutting its runtime from 15–30 minutes to about 30 seconds.

At Roberts M. Solutions LLC, I established a recovery-rate baseline for a gold processing operation and led phased process improvements, including instrumentation, operator training, and KPI dashboards. Recovery rose from 16% to 84% over the two-year engagement.

Experience

Work history, roles, and key accomplishments

Owner / Principal Consultant

Roberts M. Solutions LLC

Jul 2024 - Aug 2026 (2 years 1 month)

Founded an independent data and process consulting practice, engaged by OGS Minerals LLC to improve a gold processing operation. Established recovery-rate baselines, led phased implementation of process improvements, and raised recovery from 16% to 84% over two years.

Data Analysis Process Improvement KPI Dashboards AI Tools Bilingual Documentation

Healthcare Analyst Developer III

MemorialCare

Nov 2019 - Jul 2024 (4 years 8 months)

Served as technical authority on Epic reporting for a large health system, delivering end-to-end decision support products. Built key dashboards including Discharge Opioid Days Supply and COVID-19 executive dashboards, and optimized a legacy stored procedure reducing runtime from 15-30 minutes to 30 seconds.

Epic Clarity Epic Caboodle Epic Cogito Tableau SQL SSIS Stored Procedures Performance Optimization Mentorship

IT & BI Consultant

Self-Employed / Freelance

May 2019 - Nov 2019 (6 months)

Delivered Power BI, Tableau, and SSRS reporting solutions for clients across healthcare, technology, and professional services. Designed ETL pipelines, CRM integrations, and front-end reporting interfaces for custom B2B dashboard portals.

Power BI Tableau SSRS ETL CRM Integration JavaScript XML RDL Reports

Systems Business Analyst

Illumina

Mar 2014 - Apr 2019 (5 years 1 month)

Worked with SAP ERP and Snowflake across Supply Chain, building star schema data models and supporting integrations. Built and maintained 167 active reports/dashboards across Power BI, Tableau, and SSRS, and led BI platform implementations and upgrades.

SAP ERP Snowflake Star Schemas Power BI Tableau SSRS SQL Data Migration UAT

Product Support Manager / Team Lead

MaintenanceNet

May 2011 - Jun 2013 (2 years 1 month)

Promoted twice from Data Analyst to Team Lead to Product Support Manager. Led a team of 10 data analysts and 1 DBA responsible for SSIS package development, ETL data imports, SSRS report delivery, and SQL query optimization for enterprise clients.

SSIS ETL SSRS SQL T SQL Performance Optimization Agile Scrum Jira Confluence Microsoft Project

SQL Programmer / Direct Sales Operations Manager

GreatCall, Inc.

Jan 2009 - Feb 2011 (2 years 1 month)

Promoted from SQL Programmer to Direct Sales Operations Manager. Developed SSRS reports for call center sales analytics and redeveloped the full reporting infrastructure in-house.

SSRS SQL XML RDL Reports Sales Analytics