Designed end-to-end analytics infrastructure — from ETL pipelines to executive dashboards — delivering real-time business intelligence across property management and gaming verticals.
PythonPower BIAzure SynapseSQLDatabricksDash
Client
MRI Software · Gimme Games
Role
Data Analyst / Data Engineer
Duration
Sep 2019 – Present
Industry
PropTech · Gaming
Analytics Platform · Executive Dashboard
REVENUE MTD
$4.2M
↑ 12.4%
ACTIVE USERS
84.3K
↑ 8.1%
RETENTION
68.4%
↑ 10.2%
// monthly revenue trend ($K)
// revenue by segment
Property
Gaming
Other
// pipeline status
azure-etl-propertiesLIVE
game-telemetry-ingestLIVE
synapse-warehouse-syncRUNNING
powerbi-refresh-jobLIVE
0
Reporting speed improvement
0
Dashboards built & maintained
0
Player retention improvement
0
Revenue increase from insights
Tools & Platforms
Analytics Stack
⚡
Azure Synapse
Cloud data warehouse for enterprise property management analytics at scale
📊
Power BI
Executive dashboards for revenue, engagement, and operational KPIs
🔥
Databricks
PySpark-powered ETL and data transformation on Azure infrastructure
🐍
Python + Dash
Real-time interactive dashboards for game analytics and player insights
🏭
Azure Data Factory
Automated ETL pipelines connecting 10+ enterprise data sources
🗄️
PostgreSQL + MSSQL
Relational data modeling and optimized query design for reporting
Overview
🔴 The Problem
Property management reports took 24hrs+ to generate — decisions made on stale data
No unified data warehouse — analysts queried raw transactional databases directly
Game player data scattered across systems with no engagement or retention visibility
Executives lacked self-serve dashboards — every report required developer time
🟢 The Solution
Built Azure Synapse data warehouse with automated ETL via Azure Data Factory
Designed Power BI dashboards enabling self-serve analytics for 50+ stakeholders
Developed Python/Dash real-time dashboards for game telemetry and player behavior
Implemented A/B testing analysis framework improving player retention by 10%
Outcomes & Impact
📈
15% Reporting Speed GainOptimized SQL queries on Azure Synapse reduced report generation time from hours to minutes.
🎮
10% Player Retention LiftA/B testing analysis and player segmentation insights directly improved game retention metrics.
💰
$120K Revenue ImpactStatistical analysis of auction data at Online Auction LLC improved revenue strategies by $120K.
🔗
Unified Data InfrastructureSingle source of truth across property, gaming, and auction verticals — zero manual reconciliation.
Technology Stack
PythonSQLAzure SynapseAzure Data FactoryDatabricksPySparkPower BIDashPostgreSQLMSSQLAWS S3Redshift