BI Developer & Senior Data Analyst

Turning messy data
into clear decisions

Hi, I'm Gabi — a BI Developer with 7+ years of experience building dashboards, data models, and automated reports across SaaS, fintech, franchise, and logistics. MS in Data Science from Texas Tech.

Oi, sou Gabi — BI Developer com 7+ anos de experiência construindo dashboards, modelos de dados e relatórios automatizados em SaaS, fintech, franquias e logística. MS em Data Science pela Texas Tech.

Power BI SQL DAX & Power Query Data Modeling MS Data Science – Texas Tech
View My Work Resume
GS

About Me

Business Ops background.
BI Developer mindset.

I hold an MS in Data Science and a BBA in Management from Texas Tech University. Over 7+ years I've worked across SaaS, financial services, franchise operations, and shipping — building dashboards that actually change how teams make decisions.

My Power BI and SQL work has cut reporting time by 80%, uncovered $3.5M in revenue opportunities, and supported a 50-store expansion across 10 states. Now at Shippo, focused on variance analysis and operational automation.

Tenho MS em Data Science e BBA em Administração pela Texas Tech University. Em 7+ anos trabalhei em SaaS, serviços financeiros, franquias e logística — construindo dashboards que realmente mudam a tomada de decisão.

Meu trabalho em Power BI e SQL reduziu o tempo de relatórios em 80%, revelou $3,5M em oportunidades de receita e apoiou a expansão de 50 lojas em 10 estados. Hoje estou na Shippo, focada em variâncias e automação operacional.

Shipping & Logistics Franchise Expansion Financial Services SaaS / Software
7+
Years in Analytics
5
Companies
4
Industries
80%
Reporting Time Saved

Work History

Where I've Built Things

Business Operations Analyst Current

Shippo

2024 – Present
  • Building automated variance analysis and BI dashboards for a leading shipping & logistics SaaS platform.
  • Focused on operational automation, reducing manual reporting overhead across key business metrics.
Power BISQLVariance AnalysisAutomation

Senior Business Analyst

Woof Gang

Mar 2024 – Present
  • Power BI + SQL dashboards cut manual reporting time by 80% and improved data accuracy.
  • Capacity dashboard using FranPOS data flagged understaffed stores, reducing service delays by 25%.
  • Supported 50-store expansion across 10 states with SQL site-selection analyses and Power BI forecasts.
  • WordPress campaigns drove a 30% higher booking conversion rate in rollout markets.
Power BISQLFranchise OpsFranPOS

Sales Analyst

Intermex

Jun 2023 – Feb 2024
  • SQL + Salesforce regional reports uncovered $3.5M in untapped revenue and informed Board strategy.
  • Power BI dashboards improved forecast accuracy by 15% and guided executive budgeting decisions.
  • Automated leadership reporting turnaround from 3 days to 6 hours.
Power BISalesforceSQLFinancial Services

Senior Sales Support Analyst

Mirantis

Jun 2022 – Mar 2023
  • Power BI from Salesforce data cut executive reporting time by 70%.
  • HG Insights prospect database generated $1.2M in new business pipeline in under 6 months.
  • SQL + Excel campaign analysis improved marketing ROI by 18%.
Power BISalesforceSaaSHG Insights

Education

MS in Data Science

Texas Tech – Rawls College of Business

May 2022 · Lubbock, TX

BBA in Management

Texas Tech – Rawls College of Business

Dec 2019 · Lubbock, TX

Portfolio

Featured Projects

Featured Project

Store Utilization & Capacity Dashboard

Built on real appointment metrics across 50+ franchise locations, this Power BI dashboard surfaces rolling 4-week utilization rates, flags over- and under-booked stores, and feeds staffing decisions that reduced service delays by 25%. The model combines DAX rolling averages, dynamic thresholds, and drill-through pages by region.

Power BIDAX Rolling AvgCapacity PlanningAppointment DataFranchise Ops
50+
Stores Tracked
25%
Delays Reduced
4wk
Rolling Window
Internal Project — available on request
STORE UTILIZATION — 4 WEEK ROLLING 75% MIA-01 MIA-02 NYC-01 NYC-02 ATL-01 ATL-02 ✓ On Track: 4 stores ⚠ Over-cap: 1 store ↓ Under-cap: 1 store Avg: 74.2% utilization
Power BI 342 headcount Active — 62% At Risk — 23% Churned — 15% 18.4% Turnover Rate 2.3 yrs Avg Tenure HR METRICS DASHBOARD

HR Metrics Dashboard

Headcount, retention, and turnover trends with drill-down by location, tenure, and hire date. Identifies flight-risk employee segments for HR leadership.

DAXTime IntelligenceHR Analytics
View Dashboard
Power BI Forecast → $1.4M 6-Month Forecast Jan Feb Mar Apr May OCTOBEAN KOFFEE — REVENUE TREND

Octobean Koffee – 6 Month Review

Multi-store performance with time-series trends, peak-hour heatmaps, and a $1.4M revenue forecast using DAX what-if parameters.

DAXForecastingWhat-If Parameters
View Dashboard
Power BI $485k Downtown $362k Midtown $298k East $241k South Top Price Drivers Sq Footage +0.72 School Rating +0.58 Zip Code +0.44 Year Built +0.31 AUSTIN HOUSING — PRICE MAP

Austin Housing Market Insights

Interactive map with price-per-sqft clustering and an AI-assisted model revealing top pricing drivers in Austin's real estate market.

Maps VisualAI InsightsPower Query
View Dashboard
Power BI COUPON PERFORMANCE — ROI TRACKER SAVE20 4.2x ROI FIRST15 3.1x ROI LOYAL10 2.0x ROI FLASH25 0.9x ⚠ ⚠ 1 code flagged below breakeven by Power Query 62.4% Redemption Rate $124k Revenue Lift

Coupon Performance Analysis

Promotional ROI tracker measuring redemption rates, discount depth, and incremental revenue lift. Power Query auto-flags underperforming promo codes.

DAXPower QueryPromo AnalyticsROI
Internal Project
Power BI STORE UTILIZATION — ROLLING 4-WEEK Wk1 Wk2 Wk3 Wk4 MIA-01 MIA-02 NYC-01 NYC-02 ATL-01 78% 85% 96% 72% 41% 81% 83% 93% 69% 38% 74% 88% 98% 76% 33% 82% 90% 97% 73% 35% On Target Over Capacity Under-utilized

Store Utilization & Capacity Dashboard

Rolling 4-week utilization heatmap across 50+ stores. Surfaces over/under-utilized locations and booking gaps to drive staffing decisions.

DAX Rolling AvgCapacity PlanningAppointment Data
Internal Project
SQL BOOKING FUNNEL — CONVERSION ANALYSIS Page View — 12,840 sessions Service Selected — 9,030 (70%) Cart Add — 6,240 (69%) Checkout — 3,850 (62%) Booked — 2,980 23.2% Overall Completion 38% Drop @ Checkout Same Day highest conv. cohort

Booking Completion & Conversion Funnel

Multi-step SQL analysis correlating cart conversion with lead time. CTEs, window functions, and cohort logic surface drop-off points and rank stores by completion rate.

CTEsWindow FunctionsCohort AnalysisFunnel
View on GitHub

Technical Skills

Tools & Expertise

Core BI Stack

Power BI (DAX & Power Query) Advanced
SQL (T-SQL / PostgreSQL) Advanced
Data Modeling (Star Schema) Advanced
Excel & Power Pivot Advanced
R & Python (data wrangling) Intermediate
Tableau Intermediate

Business & Analytics Tools

SalesforceAnaplanAirtableLooker StudioHG InsightsFranPOSCertinia / FinancialForceJira

BI Development Concepts

Star & Snowflake SchemaETL / ELTRow-Level SecurityIncremental RefreshKPI DesignVariance AnalysisRevenue Recognition

Languages

🇺🇸 English — Fluent🇧🇷 Portuguese — Native🇪🇸 Spanish — Conversational

Get In Touch

Let's build something
data-driven together.

Open to BI Developer roles, consulting, and freelance projects. Bilingual EN/PT. Based in the US with ties to Brazil.

Aberta a vagas de BI Developer, consultoria e projetos freelance. Bilíngue EN/PT. Baseada nos EUA com vínculos no Brasil.

gabisalviatti@gmail.com +1 (806) 283-3219 +55 (19) 99235-5476