Open to opportunities

Francine Brivio

@francinebrivio

Senior Business Analyst specializing in strategic analytics, KPI design, and data-driven decision support through scalable models and automation.

Brazil

Message

What I'm looking for

I’m looking for a senior business analytics role where I can partner with commercial and operational teams, build scalable KPI-driven analytics, automate reporting with BI/SQL/Python, and deliver scenario-based, risk-aware decision support that improves performance.

I’m a senior business analytics professional with 8+ years of experience solving complex, open-ended business problems through structured analysis, scenario evaluation, and data-driven decision support. I build analytical functions from scratch—defining KPIs, designing scalable data models, and turning fragmented information into clear recommendations for leadership and cross-functional teams. I’m known for identifying non-obvious patterns, investigating root causes, and translating data into concrete action that improves performance across commercial and operational environments.

Most recently, as Senior Business Analyst (Strategic & Commercial Analytics) in Brazil, I replaced manual Excel reporting with automated Power BI and SQL solutions, reducing data preparation time by 75%. I built end-to-end automation workflows with Power Automate, designed and maintained 19 analytical dashboards, and developed a forecast accuracy model in DAX to compare projections against realized market prices. Earlier, I built the company’s commercial BI function from scratch, supported pricing and contract decisions with scenario-based analysis, and developed cost and margin models to influence pricing and supplier agreements—complemented by current MBA research using Python, BigQuery, and time-series volatility modeling.

Experience

Work history, roles, and key accomplishments

Current

Senior Business Analyst

Current

Samarco Mineração

Sep 2024 - Present (1 year 7 months)

Partnered with sales offices and commercial stakeholders to analyze market/performance questions, compare scenarios, and deliver decision-ready recommendations. Automated Power BI and SQL reporting, cutting data preparation time by 75%, and built 19 analytical dashboards plus DAX-based forecast accuracy models to support pricing and shipment performance decisions.

Power BI SQL DAX Power Automate KPI Design Forecasting Scenario Modeling Data Modeling Master Data Management

Data Science & Analytics Research

Universidade de São Paulo (USP)

Jan 2024 - Jan 2026 (2 years)

Conducted data science research applying sentiment analysis to financial news using VADER and FinBERT, with Python and BigQuery-based extraction and processing workflows. Built volatility and regime time-series models (GARCH, VAR, Markov Switching) and developed analytical pipelines using pandas, statsmodels, and transformers to produce testable, business-interpretable insights.

Python BigQuery Sentiment Analysis VADER FinBERT GARCH VARs Hypothesis Testing Pandas Statsmodels Transformers

Senior BI & Commercial Analyst

Porto Sudeste

Jun 2020 - Aug 2024 (4 years 2 months)

Built the company’s commercial BI function from scratch, establishing structured SQL-based datasets and executive reporting to support pricing and contract decisions. Designed performance dashboards tracking shipped vs. received quality and volume, produced decision-ready reporting in English for leadership, and improved invoice issuance compliance with customs deadlines.

SQL Dashboard Design BI Reporting Executive Reporting Benchmarking Performance Analysis KPI Tracking data transformation

Commercial & Data Analyst

Trafigura

Jan 2019 - May 2020 (1 year 4 months)

Built cost models and margin analysis to support commercial negotiations and influence pricing and supplier agreements. Monitored contractual performance via financial KPIs, validated data consistency across global contract portfolios, and aligned financial and operational data for daily reporting to global stakeholders.

Financial Modeling Margin Analysis Benchmarking KPIs Data Validation Contract Performance Stakeholder Management Reporting

Commercial & Data Analyst

Grupo Sunset

Dec 2016 - Dec 2018 (2 years)

Built the commercial reporting and analytics function from the ground up, creating executive dashboards that became the foundation for sales strategy and performance monitoring. Developed Power BI and Excel dashboards for pricing and contract prioritization, and presented structured process-improvement recommendations to the board.

Power BI Excel Dashboard Design Executive Reporting Data Extraction Operational Analytics Pricing Analytics Process Improvement