Skip to content
View carlosmhenao's full-sized avatar

Block or report carlosmhenao

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.

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
Carlosmhenao/README.md

Hi, I'm Carlos Moreno Henao

Business Management Professional | Marketing Analytics | Data Strategy

Transforming complex datasets into actionable business growth and strategic ROI.


Technical Ecosystem

Category Tools & Technologies
Data Science Python Pandas NumPy
Databases SQL PostgreSQL
BI & Viz Tableau Seaborn

Strategic Projects

  • Business Problem: How to optimize marketing spend in a 400k+ transaction dataset?
  • Solution: Developed an RFM model in Python to identify high-value "Champions" and "At-Risk" segments.
  • Result: Provided actionable insights for a 20% targeted retention campaign.
  • Tech: Python, Pandas, Matplotlib, Marketing Analytics.
  • Business Problem: Minimize financial loss from loan defaults in a high-risk portfolio.
  • Solution: Built a Logistic Regression model with Scikit-Learn, optimizing for Recall to detect potential defaulters.
  • Result: Increased detection of toxic loans from 27% to 71%, potentially saving millions in bad debt.
  • Tech: Python, Machine Learning, Risk Management Strategy.

Description: Analyzed 8,000+ digital marketing campaign records to audit ad spend efficiency, maximize Return on Investment (ROI), and identify high-converting customer acquisition channels. Tools: Tableau, Data Analysis, Business Intelligence, Logical Modeling, Financial KPIs. Key Achievements:

  • Engineered core financial KPIs (Net Profit, ROI) using calculated fields to translate raw transactional data into actionable business metrics.
  • Identified the Referral channel as the primary revenue driver, generating $14.1M in net profit and outperforming paid channels with a 162.9% average ROI.
  • Formulated a data-driven strategy to reallocate 15% of underperforming social media ad budgets toward scaling high-yield customer loyalty programs.

Portfolio Insights & Activity

Status Primary Focus Main Goal
Active Customer Intelligence Driving ROI through Data

🛠️ Proficiency Level

Python Data Analysis Business Strategy


Let's build something data-driven together

LinkedIn Email


"In God we trust; all others must bring data." — W. Edwards Deming

Popular repositories Loading

  1. E-commerce-RFM-Analysis E-commerce-RFM-Analysis Public

    Customer Segmentation Analysis using RFM model in Python to optimize marketing ROI.

    Jupyter Notebook

  2. Carlosmhenao Carlosmhenao Public

  3. Credit-Risk-Prediction-Banking Credit-Risk-Prediction-Banking Public

    Jupyter Notebook

  4. digital-marketing-profitability-analysis digital-marketing-profitability-analysis Public

    Interactive Tableau dashboard analyzing 8K+ digital marketing records to optimize ad spend, maximize ROI, and identify high-converting acquisition channels.

  5. AB-Testing-ROI-Analysis AB-Testing-ROI-Analysis Public

    Statistical A/B Testing & ROI analysis using SQL and Advanced Excel (Two-Proportion Z-Test) to evaluate the profitability of digital marketing campaigns.