Mark Garza
Vail,AZ
Summary
Results-driven Business Intelligence Analyst with expertise in Epic Cogito report writing and data analysis at El Rio Health Center. Successfully led complex projects, enhancing reporting capabilities and decision-making processes. Proficient in SQL programming and skilled in collaborating with cross-functional teams to deliver actionable insights and drive continuous improvement.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
El Rio Health Center
08.2023 - Current
- Created Epic dashboards with custom metric reports that helped the Clinical and Operation teams in their decision-making while ensuring data accuracy and quality results.
- Design, build, and maintain data imports/exports, ETL pipelines across Clarity/Caboodle and Microsoft SQL Server using SSIS Packages.
- Epic upgrade support, implementing new functionality based on organizational strategy, and assisting with the development of training materials and analytics within the Epic Cogito application
- Owned highly complex projects, such as multiple AI module implementations and complex geocoding mapping feature integration that changed how the organization approached reporting.
Business Analyst
Gracia LLC
11.2021 - 08.2023
- Used Python to perform ETL API calls from the companies sales platform to a Postgres Database. That sales database was used to feed multiple Google Looker Dashboards for sales insights.
- Generated monthly billing and posting reports for management review.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Identified patterns and trends in large data sets and provided actionable insights.
Business Analyst
Community Health Systems, CHS
11.2015 - 03.2020
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Collaborated with upper management to implement continuous improvements and exceed team goals.
- Collaborated cross-functionally with headquarters, regional and other teams nationally to maintain consistent message and experience.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Utilized data visualization tools to effectively communicate business insights.
Education
High School Diploma -
Pima Community College
Tucson, AZ07.2007
Skills
- Epic Cogito Report Writing
- BI model development
- Data analysis
- KPI monitoring
- SQL programming
- Advanced Excel
- BI tools expertise
- ETL development
- Python programming
- Custom reporting
- KPI tracking
- Business intelligence analysis
Certification
- Epic Cogito
- Epic Caboodle
- Epic Clarity
Languages
English
Timeline
Business Intelligence Analyst
El Rio Health Center
08.2023 - Current
Business Analyst
Gracia LLC
11.2021 - 08.2023
Business Analyst
Community Health Systems, CHS
11.2015 - 03.2020
High School Diploma -
Pima Community College