José Galvão

José Galvão

Business Data Analyst

Business Management student at ISCAC & self-taught programmer.
I turn manual, repetitive processes into automated systems — from ETL pipelines to ML models that drive real business decisions.
Python SQL Power BI Machine Learning Financial Modeling

By the Numbers

0
End-to-End Projects
Each with a public GitHub repo & documented case study
0
Data Processed
Warehouse: 1.2M transactions · E-Commerce: 100k · Real Estate: 95k
0
Avg. Model Accuracy
Across 4 ML projects (AUC/MAPE)
0
Fastest Automation
Financial reporting: month-end close from 2 days to under 5 seconds

My Methodology

I don't just write code — I solve business problems. Here's how I approach every engagement.

01

Discovery

Identify the real bottleneck — manual hours, inaccurate reports, missing signals. I map the current workflow and quantify the cost of inaction before touching a single line of code.

Stakeholder interviews · Process mapping · KPI audit
02

ETL & Cleaning

Real-world data is messy. I build robust pipelines that handle duplicates, nulls, encoding issues, and schema drift — so the analysis is always grounded in clean, trustworthy data.

Python · Pandas · SQL · Star Schema
03

Modeling & Automation

I choose the right tool for the job — ML model, ETL pipeline, or Power BI dashboard. The goal is always the same: deliver a system that runs itself and improves over time.

Scikit-Learn · LangChain · Power BI · Streamlit
04

Validation & ROI

Every output is validated against ground truth and backtested where possible. I document the measurable business impact — time saved, accuracy gained, revenue at risk identified.

AUC · MAPE · Backtesting · Business case

⭐ Featured Projects

🔍 FILTER BY SKILLS

Experience & Education

🎓 Education

2024 - Present
BSc in Business Management
Coimbra Business School (ISCAC)
Focus: Financial Control, Data Analytics.
2021 - 2024
Management Informatics
Escola Secundária Avelar Brotero
Specialized High School Diploma covering Programming Logic, Databases, and Business Admin.

💼 Experience

Sept 2025 - Present
Business Data Analyst & Automation Consultant
Freelance / Independent Projects
  • Specialized in architecting financial workflow automation and robust data structures to eliminate operational bottlenecks.
  • Engineering end-to-end ETL pipelines to centralize fragmented data from ERP systems and decentralized legacy files.
  • Deploying AI & Machine Learning models for predictive analytics, focusing on risk mitigation and high-accuracy demand forecasting.
  • Strategic Power BI Consultancy, delivering executive-level dashboards focused on ROI, profitability, and data-driven decision making.
Mar 2024 - Aug 2024
Junior Operations Associate (Trainee)
Liquilentes | Coimbra
  • Optimized inventory accuracy by supporting daily administrative controls and logistics tracking.
  • Enhanced supplier reconciliation processes through rigorous data verification and auditing.

Languages

Portugal flag
Portuguese
Native Speaker
United Kingdom flag
English
Advanced
Spain flag
Spanish
Intermediate

Technical Expertise & Proficiency

🐍 Programming

Python logo Python
C# logo C# / .NET
JavaScript logo JavaScript
HTML5 logo HTML & CSS

📊 Data Engine & BI

Power BI logo Power BI (DAX)
SQL logo SQL (ETL)
Microsoft Excel logo Excel (VBA)
🏗️ Data Architecture

🤖 AI & Data Science

Scikit-learn logo Machine Learning
LangChain logo LangChain / RAG
Streamlit logo Streamlit Apps
Pandas logo Pandas & NumPy

💰 Finance & Ops

📈 Financial Modeling
⚖️ Valuation (DCF)
📓 SNC Accounting
🛡️ Risk Management

Professional Soft Skills

Problem Solving
Analytical approach to complex financial bottlenecks.
Communication
Bridging the gap between data and business stakeholders.
Efficiency
Focus on automation to maximize output and accuracy.
Continuous Learning
Always up-to-date with latest AI and Data tools.

Live on GitHub

Real activity. Public repos. Every project is open-source and verifiable.

Github is Having Trouble Loading The Data...
Github is Having Trouble Loading The Data...

Professional Endorsement

"

"His ability to learn and apply acquired knowledge in new situations truly impressed me, predicting a promising professional career. José will surely be an asset to any company."


Original Letter (PT)

Business Efficiency Impact

Financial modeling of automated workflow returns

🚀 Annual Financial Recovery
€168,960
Automation optimizes 4,992 hours yearly.
Equivalent to 2.4 full-time strategic roles.
Monthly €14,080
Daily Recovery 17.0h
Efficiency Increase +85%


Knowledge Stack

Lessons learned from real projects — not tutorials.

Machine Learning

Why I default to Random Forest for credit risk scoring

Logistic regression is interpretable but breaks on non-linear interactions — which are everywhere in financial data. Random Forest handles correlated features gracefully, gives you feature importances for free, and rarely overfits with basic hyperparameter tuning. The Banker AI project validated this: 85% accuracy vs 71% for a tuned logistic baseline.

Data Engineering

The most common mistake I see in Excel automation projects

Everyone automates the calculation. Nobody automates the validation. The Financial Reporting project taught me that 70% of errors come from silent data-type mismatches between source files. I now always build a validation layer that halts execution and surfaces the exact row and column that failed — before writing a single output cell.

AI & RAG

Chunk size is the most underrated RAG hyperparameter

Building ChatCFO, I found that 512-token chunks with 15% overlap outperformed 1024-token chunks for financial PDFs. Larger chunks dilute the dense numerical context that embeddings need to stay precise. The sweet spot depends on document structure — tabular data needs tighter chunks than narrative prose.

Business Intelligence

Why RFM segmentation beats raw revenue as a retention signal

In the E-Commerce project, a customer generating €5k/year in revenue appeared healthy — until RFM revealed they hadn't purchased in 9 months. Raw revenue is a lagging indicator. Recency is a leading one. That single insight unlocked a €96k revenue-at-risk identification that would have been invisible in a standard sales report.

AVAILABLE FOR OPPORTUNITIES

Let's Connect

I'm always open to discussing data-driven projects, automation workflows, or potential roles in Finance & Tech.