Rick Mata
Grand Prairie,TX
Summary
Results-driven professional skilled in analyzing sales and benefits data to enhance business strategies. Strong background in dataset cleaning, validation, and the development of executive reports that convert trends into actionable insights. Proficient in SQL, Tableau, and Power BI, supporting seamless transitions into data analyst positions.
Overview
5
5
years of professional experience
Work History
Benefits Analyst
Brinson Benefits
Remote
05.2024 - Current
- Analyze claims, enrollment, eligibility, billing, utilization, cost, and participation data across 20+ client accounts to identify trends and variances.
- Partner with account executives and senior stakeholders to communicate findings and support renewal recommendations tied to client savings opportunities.
- Cleaned, validated, and standardized Excel datasets, enhancing data quality for recurring analysis.
- Built and maintained Excel reports and charts to effectively track key metrics and year-over-year changes.
- Conducted data reconciliation across reporting files, minimizing errors and ensuring consistency.
Client Service Representative (Reporting and Analysis)
Van's Kitchen
Dallas, USA
06.2021 - 11.2022
- Compiled performance reports and sales summaries for executive leadership and cross-functional teams, providing insights for informed business strategies.
- Examined sales data to identify trends, patterns, and variances in performance, enabling proactive adjustments to sales strategies.
- Utilized pivot tables and formulas in Excel to analyze weekly sales trends, forecasting sales volume, units sold, projected profit, and expenses, supporting strategic decision-making.
- Functioned as a client-facing point of contact for reporting and issue resolution, collaborating with leadership and operations to assist with daily business decisions.
Education
Bachelor of Science - Communication Studies
Texas Christian University
Fort Worth, TXFort Worth, TX
Skills
- Data analysis and visualization
- Trend and variance analysis
- Forecasting and reporting
- Data cleaning and reconciliation
- Data modeling
- Excel, SQL, Tableau, and Power BI
- Stakeholder communication
- Requirements gathering
- Client support
Projects
- NBA Player Performance Analysis, Tableau, Excel, CSV, Analyzed 2021–2022 NBA player statistics to evaluate scoring leaders, 3-point efficiency by position, assist leaders, and MVP comparisons. Built Tableau dashboards using bar charts, heatmaps, treemaps, and bubble plots to visualize scoring, shooting percentages, assists, rebounds, and points.
- Healthcare SQL Analysis, MySQL, SQL, Queried a multi-year hospital readmissions dataset to analyze length of stay, demographics, provider specialties, lab procedures, and medication usage. Used joins, grouping, and aggregations to evaluate relationships between stay duration, procedure volume, medication usage, and ethnicity.
Timeline
Benefits Analyst
Brinson Benefits
05.2024 - Current
Client Service Representative (Reporting and Analysis)
Van's Kitchen
06.2021 - 11.2022
Bachelor of Science - Communication Studies
Texas Christian University