Skip to content

Navigation Menu

Sign in
Sign up
@ecastillo081
ecastillo081
Follow
Strategic Finance & Analytics Professional SQL • Python • dbt • Supabase • Mode Analytics Building data-driven finance tools and forecasting models

Highlights

  • Pro

Block or report ecastillo081

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ecastillo081 /README.md

Efrain Castillo

Finance professional focused on FP&A, forecasting, financial modeling, and finance analytics across SaaS, fintech, and marketplace environments.

🌐 Finance Portfolio: https://efrainfinance.com/

My work combines driver-based forecasting, financial analysis, accounting discipline, and finance-grade data validation to turn operating data into decision-ready financial insights.

Selected Finance Projects

SaaS Growth Economics

Recurring-revenue analysis covering ARR, retention, churn, acquisition economics, cohort behavior, and finance-grade reconciliation controls.

Repository: https://github.com/ecastillo081/SaaS-KPI-Dashboard

Merchant Revenue Forecasting

Benchmarked nine forecasting methods across 50 synthetic merchants. Holt produced the strongest average out-of-sample performance at approximately 8.64% MAPE.

Repository: https://github.com/ecastillo081/Merchant_Revenue_Forecasting

Marketing Investment Economics

Marketing Finance case connecting acquisition spend to CAC, contribution-margin economics, payback, and downside sensitivity.

Repository: https://github.com/ecastillo081/Marketing-Finance-Dashboard

Integrated Financial Model

Driver-based three-statement financial model covering revenue, headcount, operating expenses, scenarios, cash flow, and investment analysis.

Repository: https://github.com/ecastillo081/Financial_Model

Credit Risk Analytics

Credit-risk modeling case focused on the trade-off between approval volume, modeled default risk, and financial outcomes.

Repository: https://github.com/ecastillo081/Loan_Defaults

Focus Areas

  • Corporate FP&A
  • Driver-based forecasting
  • Budget vs. actual analysis
  • Rolling forecasts
  • Revenue and contribution-margin modeling
  • SaaS / fintech unit economics
  • Scenario analysis
  • Finance data validation and reconciliation
  • Excel, SQL, Python, Power BI

More

For management-ready case studies and additional finance work:

https://efrainfinance.com/

Popular repositories Loading

  1. Loan_Defaults Loan_Defaults Public

    Objective: Reduce default rate among approved loans while maintaining healthy approval rates.

    Python

  2. Merchant_Revenue_Forecasting Merchant_Revenue_Forecasting Public

    Objective: Forecast monthly merchant revenue across 50 merchants (5 years of data) and compare multiple forecasting methods.

    Python

  3. Marketing-Finance-Dashboard Marketing-Finance-Dashboard Public

    An analytics project that combines Google Ads + Meta Ads data and translates it into finance metrics.

    Python

  4. Financial_Model Financial_Model Public

    Traditional 3-statement financial model (startup) with CapEx ROI & PDF export.

    Python

  5. SaaS-KPI-Dashboard SaaS-KPI-Dashboard Public

    SaaS Financial Analytics Dashboard built in SQL and Mode Analytics. Tracks ARR, NRR, GRR, CAC, LTV, ARPU, and Payback to show how retention and customer acquisition efficiency drive growth in a sub...

    Python

  6. ecastillo081 ecastillo081 Public

    GitHub profile for Efrain Castillo — FP&A and finance analytics.

AltStyle によって変換されたページ (->オリジナル) /