Business Intelligence Analyst

Ruben Oceguera

Business intelligence analyst with hands-on experience building reporting systems, automating recurring workflows, and improving data quality for operational teams. I use SQL, Python, Excel, Tableau, and Power BI to turn raw data into usable dashboards, cleaner processes, and faster decisions.

Core Skills

  • Data analytics with SQL, Excel, Python, Tableau, and Power BI
  • Dashboard development, SSRS reporting, and trend analysis for business performance tracking
  • Report automation with VBA and workflow improvements for recurring operational reporting
  • Data quality review, compliance support, and cross-functional reporting collaboration

Education

BS in Cybersecurity and Information Assurance, Western Governors University.

Certifications

CompTIA A+, Network+, Security+, PenTest+, CySA+, and Associate of (ISC)2 to SSCP.

Selected Experience

Business Intelligence Analyst, Health Advocates

Developed reporting platforms with SQL, Python, and Tableau for organizational and client needs, while helping management track key trends, improve report automation, and maintain stronger data quality through audits and compliance checks.

Lead Data Analyst, Health Advocates

Increased report generation efficiency by 86% through standardized reporting formats and built a VBA-based tracking system that checks file directories and returns updated report run dates automatically.

Dashboarding, Ownership, and Data Quality

Created a self-updating SSRS dashboard using SQL CTEs and PIVOT functions, managed additional analyst workload during team transitions, and partnered with departments and directors to resolve missing data and incorrect data types affecting reporting accuracy.