About Experience Projects Education Contact

Financial Analyst · Guadalajara, MX

Sebastian
Gutierrez
Naranjo

Corporate finance meets modern tools. I build financial systems that clarify decisions — KPI dashboards, CMI frameworks, AI-enhanced analysis, and investment presentations.

Get in touch LinkedIn
4+
Years training
3×
Intl programs
97%
COGS modeled
Sebastian Gutierrez Naranjo
scroll

Who I am

Analyst. Consultant.
Builder.

I'm a financial analyst with hands-on experience in corporate finance, financial reporting, budgeting, and KPI dashboard design — built across real business environments in the geotechnical and construction sectors.

My edge: I combine rigorous financial foundations with AI-forward tools. Completed a 104-hour program in AI Applied to Financial Analysis at Tecnológico de Monterrey, and internationally trained through two programs at IEB Madrid.

Location
Guadalajara, Jalisco, México
Degree
B.S. Financial Administration — ITESO
Languages
Spanish Native · English B2 IELTS
Specialty
AI-Enhanced Financial Analysis
Sebastian Gutierrez Naranjo — IEB Madrid 2024

Graduation Ceremony · IEB Madrid 2024

Where I've worked

Professional
Experience

Nov 2025 – Present
Grupo Sandstorm GAM
Financial Analyst
  • Design and maintain KPI dashboards and financial reporting structures tracking profitability, cash flow, and project-level cost performance.
  • Lead the annual budgeting cycle and monthly financial close, including variance analysis against budget and prior periods.
  • Build financial tools that translate complex operational data into clear, actionable summaries for non-financial decision-makers.
Jan – Oct 2025
Trudeal Asesores
Independent Financial Consultant
  • Delivered financial analysis and decision-support tools to real business advisory engagements.
  • Conducted financial diagnostics and structured KPIs to improve management visibility in client companies.
Sep – Dec 2024
ITESO — PAP Program
Financial Consultant — THP
  • Led the full financial consulting workstream for THP, a manufacturing SME, designing a custom Financial Balanced Scorecard in Excel.
  • Identified COGS at 97% of revenue in 2022 and modeled a pricing strategy projecting recovery to positive net income margin by 2025.

What I've built

Selected
Projects

Financial Dashboard · 2024

Financial Balanced Scorecard — THP

Custom CMI in Excel for a manufacturing SME. 3-year financial analysis, income statements, break-even modeling, KPI tracking, and multi-year projections with adjusted pricing scenarios. Data shown is illustrative.

ExcelFinancial AnalysisKPI DashboardBreak-EvenProjections
Final presentation delivered to THP management team · ITESO PAP 2024
All figures and data shown in this dashboard are entirely fictitious and used for visual demonstration purposes only. They do not represent actual financial results of THP or any real entity.
CMI FINANCIERO · ITESO PAP 2024 1 / 3
CMI Dashboard THP

KPI Dashboard · 2025–Present

Financial Reporting Dashboard — Sandstorm GAM

Operational financial dashboard tracking project-level KPIs, budget execution, billing milestones, and executive P&L summaries for a geotechnical construction firm. Financial data is illustrative.

HTML/CSSKPI TrackingBudget AnalysisData VisualizationExecutive Reporting
Live Preview — Control de Avance de Obra
Escenario ilustrativo · Datos confidenciales ocultos HTML / CSS Excel + SQL

Investment Analysis · 2023

Portfolio Management — IEB Madrid / BlackRock

Comprehensive investment portfolio analysis developed as the final deliverable of the IEB Madrid Specialization. Presented to BlackRock-affiliated professionals. Covers equities, ETFs, REITs, bonds, fundamental & technical analysis, and portfolio construction.

Portfolio ManagementSecurities AnalysisEquities & ETFsREITsFixed Income
Delivered to BlackRock-affiliated panel · IEB Madrid, July 2023
Presentation · IEB Madrid 2023
1 / 30
Slide 1 de la presentación IEB Madrid 2023

Consulting · 2025

Financial Advisory — Trudeal Asesores

Independent financial consulting delivering financial diagnostics, performance analysis, and structured decision-support frameworks for client companies across multiple sectors.

ConsultingFinancial DiagnosticsDecision SupportReporting

Venture · 2024–Present

FinSebra

Financial tools and dashboard frameworks making corporate finance accessible for SMEs and entrepreneurs — templates, decision-support models, and practical financial instruments.

Financial ToolsSME FinanceDashboardsTemplates

Academic background

Education &
Training

2020 – 2025
ITESO – Guadalajara
B.S. in Financial Administration
Corporate Finance · Business Valuation · Cost Analysis · Budgeting & Financial Planning · Financial Statement Analysis
Nov 2025 – Feb 2026
Tecnológico de Monterrey
Diploma — AI Applied to Financial Analysis
104 hours · AI tools · Prompt engineering · AI-enhanced Excel · Dashboard design
Jul 2023
IEB Madrid
Specialization — Portfolio Management & Securities Analysis
Portfolio construction · Fundamental & technical analysis · Equities · ETFs · REITs · Bonds · Presented to BlackRock professionals
Jul 2024
IEB Madrid
Summer Program — International Business Management
Global business strategy · International enterprise management · European business environment

What I work with

Finance
Financial Analysis
Corporate Finance
FP&A & Budgeting
Business Valuation
Financial Reporting
Tools
Excel (Advanced)
KPI Dashboard Design
AI-Enhanced Analysis
Financial Modeling
Dynamic Tables
Analytical
Financial Statements
Ratio Analysis
Break-Even Modeling
Cost Structure
Multi-year Projections
Languages
Español — Nativo
English — B2
IELTS Certified

Get in touch

Let's work
together.

Open to opportunities in Corporate Finance, FP&A, Strategic Finance, and Financial Analysis. Available for full-time roles and consulting projects.

sebastiangtznaranjo@gmail.com
LinkedIn +52 331 990 6221
.docx · No images · ATS-compatible · Available in English and Spanish
Availability
Open to full-time roles
Open to consulting projects
Guadalajara · Remote · Hybrid
What I bring
Financial systems that simplify decisions
AI-enhanced analysis & modern tools
International training · ITESO · TEC · IEB
Spanish native · English B2 IELTS
I typically respond within 24 hours. Feel free to reach out in English or Spanish.
Global Financial Perspective