FOLLOW THE SIGNAL · MUTED PREVIEW
Find the pattern behind the numbers.
A visual pause that reflects the questions, measures, and connections at the heart of analytics.
DATA → INSIGHT → DECISION
I build clarityfrom complex data.
I'm Ray Resurreccion, a senior data analyst and business intelligence professional with a SQL-first background spanning analytics, reporting, data modeling, and data engineering.
15+
Years in data & analytics
20M+
Enterprise records analyzed
40+
Operational KPIs
35%
Measured performance improvement
SELECTED WORK
Real problems. Practical data solutions.
Not just screenshots. Each case study will document the business question, architecture, data model, analysis, decisions, and lessons learned.
ANALYTICS IN CONTEXT
Turn analysis into shared understanding.
Clear reporting gives teams a practical way to see what is changing and decide what to do next.
FLAGSHIP PROJECT01
Personal Data Platform
An evolving data platform for ingesting, organizing, and analyzing personal operational data using modern data-engineering patterns.
PythonFastAPIPostgreSQLDocker
Coming soonCOMING SOON
LIVE CONSULTING PROJECT02
Connect2U Data Solutions
A live data consulting business focused on helping organizations solve SQL, reporting, data cleanup, automation, and analytics problems.
SQLData AnalysisReportingAutomation
LiveVisit site
ANALYTICS PROJECT03
Job Search Analytics
A structured analytics system for application activity, recruiter communication, follow-ups, outcomes, and job-search performance.
SQLPythonAnalyticsAutomation
Coming soonCOMING SOON
BI SHOWCASE04
Executive Analytics
A portfolio of KPI design, dimensional modeling, reporting, and data storytelling patterns built around business decision-making.
Power BITableauSQLKPI Design
Coming soonCOMING SOON
SENIOR PROJECT • REAL CLIENT05
FARR Shipping & Receiving System
A 2002 DeVry senior project built for Anaheim Marriott to replace a manual package-tracking process with a Microsoft Access/VBA database, barcode-supported workflows, operational reporting, and delivery tracking.
Microsoft AccessVBADatabase DesignRequirements Analysis
Anaheim Marriott • 2002Case study
EARLY SOFTWARE PROJECT06
Super Lotto Machine
A 2004 Microsoft Access/VBA project that grew from a six-number classroom assignment into a database-backed lottery application with animation, duplicate handling, Quick Picks, stored results, printing, and frequency statistics.
Microsoft AccessVBADatabase DesignApplication Logic
Original project • 2004Case study
ORIGIN STORY
1997It started with a Dragon.
Before dashboards, data pipelines, and cloud platforms, I was already trying to make complicated technology easier for people to use.
As a Cerritos College student, I created The Dragon, a menu-driven interface that simplified access to early Internet and VMS services. The project was featured in the college newspaper, Talon Marks, and continued evolving for years.
“I'm driven by hunger for information.”
Explore The Dragon ↗VMS • Internet Tools • Usability • Self-taught
RESUR001 > THE DRAGON
Original interface artifact • Cerritos College AlphaServer / VMS
TECHNICAL TOOLKIT
Select a technology to see what it does and how it can create business value.
SQL+
WHAT IT IS
The core language I use to retrieve, join, validate, aggregate, and transform business data.
BUSINESS VALUE
Helps companies turn raw operational data into reliable answers, reporting, and decision support.
T-SQL+
WHAT IT IS
Microsoft SQL Server's SQL implementation, including stored procedures, CTEs, window functions, and database-side processing.
BUSINESS VALUE
Moves complex processing closer to the data, improving repeatability, automation, and performance.
PostgreSQL+
WHAT IT IS
A powerful open-source relational database I use in modern application and data-platform projects.
BUSINESS VALUE
Provides a dependable, flexible foundation for applications, analytics, integrations, and structured business data.
Snowflake+
WHAT IT IS
A cloud data platform for storing, transforming, and analyzing data from multiple business systems.
BUSINESS VALUE
Helps organizations reduce data silos and scale analytics around a consistent source of trusted information.
Python+
WHAT IT IS
A general-purpose language I am expanding for data engineering, automation, APIs, and analytical workflows.
BUSINESS VALUE
Automates repetitive work and connects databases, files, APIs, cloud services, and analytical processes.
Pandas+
WHAT IT IS
Python's data-analysis toolkit for cleaning, reshaping, validating, and exploring structured datasets.
BUSINESS VALUE
Makes repeatable data preparation and exploratory analysis faster than manual spreadsheet-heavy workflows.
Power BI+
WHAT IT IS
A business-intelligence platform for data modeling, KPI reporting, dashboards, and interactive analysis.
BUSINESS VALUE
Gives leaders and operational teams accessible, consistent views of performance and business trends.
Tableau+
WHAT IT IS
A visual analytics platform for exploring data and communicating patterns through interactive dashboards.
BUSINESS VALUE
Makes complex information easier for business users to understand, explore, and act on.
dbt+
WHAT IT IS
A modern analytics-engineering framework for building documented, testable SQL transformations.
BUSINESS VALUE
Brings software-engineering practices to analytics so business logic is easier to maintain, test, and trust.
AWS+
WHAT IT IS
Cloud services I am expanding for data storage, processing, integration, and modern data-engineering workflows.
BUSINESS VALUE
Allows organizations to build scalable data solutions without depending entirely on traditional on-premises infrastructure.
Data Modeling+
WHAT IT IS
Structuring entities, relationships, facts, dimensions, and business rules so data represents the organization clearly.
BUSINESS VALUE
Creates a dependable foundation for reporting, analytics, integration, and consistent KPI definitions.
ETL / ELT+
WHAT IT IS
Processes for extracting data from source systems, transforming it, and loading it into analytical platforms.
BUSINESS VALUE
Combines information from disconnected systems into dependable, repeatable datasets ready for analysis.
A practical toolkit built through years of SQL, analytics, and business intelligence work—and continually expanded through modern data engineering technologies.
CAREER PATH
Built on SQL. Expanded through analytics.
My career has moved across business analysis, SQL development, enterprise analytics, business intelligence, and modern data engineering.
2025 — Present
Data Engineer Academy
Senior Data Analyst / Business Intelligence
Sales and marketing analytics, KPI reporting, CRM analysis, workflow automation, and modern data-engineering development.
2019 — 2025
PIH Health
Senior Data Analyst / Business Intelligence
Enterprise analytics, SQL, governed reporting datasets, operational KPIs, data modeling, dashboards, and stakeholder decision support.
2015 — 2019
SD&A Teleservices
SQL Developer
SQL Server ETL, stored procedures, reporting automation, query optimization, data validation, and operational analytics.
2007 — 2015
Zenith Education Group • UnitedHealth Group • Countrywide
Business Analyst
SQL-driven reporting, KPI analysis, automation, forecasting, operational reporting, and business requirements.
ABOUT
Business context meets technical depth.
I've spent my career close to both the data and the people who need to make decisions from it. That means understanding the business question, building trustworthy data, and communicating the result clearly.
Today I'm extending that foundation through Python, modern cloud data platforms, dbt, APIs, and end-to-end portfolio projects.
LET'S CONNECT