Business Intelligence Analyst

Ruben Oceguera

Quick Links LinkedIn
Analytics Reporting and automation built to improve visibility, support decisions, and strengthen operational execution.

Core Skills

  • Dashboarding and performance reporting that improve visibility into operational and business trends
  • Workflow automation that reduces manual effort and strengthens recurring reporting processes
  • Data quality, validation, and cross-functional support for reliable decision-making

About

Business intelligence analyst with 4+ years of experience delivering reporting, automation, and data quality improvements that support leadership visibility and operational performance.

Reporting Stack

SQL Excel Python Tableau Power BI SSRS VBA

My Highlights

Business Intelligence Analyst | Health Advocates

Delivered reporting solutions that improved leadership visibility, streamlined recurring client deliverables, and strengthened data quality controls across operational workflows.

Lead Data Analyst | Health Advocates

Increased report generation efficiency by 86% through standardized reporting and a VBA tracking system that reduced manual follow-up and improved reporting oversight. Maintained productivity and continuity of operations while absorbing the workloads of two additional analysts following their departure.

My Projects

Live AST SpaceMobile Investor Dashboard

Built a live investor dashboard that consolidated market activity, company disclosures, news, and catalyst tracking into a centralized decision-support view.

Expand Preview

VBA Report Tracking System

Created a VBA-based tracking system that improved report status visibility, reduced manual follow-up, and strengthened oversight of recurring reporting workflows.

Expand Preview

Self-Updating SSRS Dashboard

Launched a self-updating SSRS dashboard that provided leadership with a more reliable view of monthly and year-to-date collections performance.

Expand Preview

Payment Entry VBA Interface

Designed a VBA-based payment entry interface that standardized intake, reduced manual effort, and improved consistency across record updates.

Expand Preview

SQL Refresh Validation Report

Produced a SQL validation report that identified stale or missing table refreshes and improved visibility into overnight data update health.

Expand Preview