Hello, I'm

Radwan Hefny

Data Analyst & Business Intelligence

An NTI-Certified Data Analyst with a Mechanical Engineering foundation — I treat business problems the way engineers treat broken systems: find the failure point, measure the cost, and fix it with precision.

Radwan Mohamed — Data Analyst
Scroll
“

Creativity is seeing what others see, and thinking what no one else ever thought.

”

Engineering Data Into Decisions

When a dataset lands on my desk, I start by building a clean, structured foundation — engineering ETL pipelines, modeling schemas, and auditing every assumption before a single KPI gets calculated.

From there, I dig into the numbers with one question in mind: what is the business actually losing or missing here? That means understanding how the operation works, not just how the data looks.

The output is always an interactive dashboard and a clear narrative — precise enough so that a non-technical stakeholder can make a real decision without needing to trust the math blindly.

0 Records Analyzed
0 Cost Savings Found
0 Top 10% on Kaggle
0 Students Impacted

🧭 Career Objective

To decode the 'why' behind consumer decisions and market trends using engineering logic, ultimately building more sustainable and intelligent business models for rapidly scaling businesses.

Skills & Technologies

Analysis & Modeling

Excel Data Cleaning Statistical Analysis EDA SQL PostgreSQL MySQL Star Schema Data Modeling

Visualization

Power BI DAX Power Query Dashboard Design Matplotlib Seaborn Storytelling with Data

Programming & ML

Python Pandas NumPy Scikit-Learn Feature Engineering OOP

Tools & Workflow

Git GitHub VS Code Jupyter Notebook

Featured Projects

02

Chinook Business Intelligence

Reversed growth stagnation by eliminating non-performing assets and reallocating budgets to pivot toward high-value customer acquisition.

SQL BI Strategy Data Modeling
03

Kaggle — Advanced Regression

Ranked in the Top 10% (589/5000+) globally by implementing advanced predictive models with rigorous feature engineering.

EDA XGBoost Random Forest Scikit-Learn

Experience & Leadership

Mar 2026 – May 2026

Data Analysis Professional Track (Intern)

National Telecommunications Institute | Ministry of Communications

  • Engineered robust ETL pipelines using SQL and Python to ensure data integrity and streamline workflows under governance standards.
  • Developed complex Star-Schema models and Power BI dashboards to track business KPIs and facilitate data-driven decision-making.
Oct 2022 – Jul 2023

Team Lead – Solar Tracking System

Faculty of Energy Engineering | Aswan University

  • Led a 5-member team to design a real-time data processing system, successfully achieving an "Excellent" grade.
  • Analyzed sensor performance metrics to calibrate mechanical errors and optimize overall system efficiency.
Nov 2021 – Jul 2023

Student Union President

Faculty of Energy Engineering | Aswan University

  • Managed budgets and cross-functional teams to execute 20+ academic and social initiatives for a community of 1,000+ students.
  • Spearheaded a "Knowledge Management" initiative to digitize and archive academic resources, significantly streamlining data accessibility.

Services

Supply Chain Analytics & Optimization

End-to-end analysis of logistics data to reduce costs and maximize operational throughput.

E-commerce Growth Strategy & BI

Data-driven insights that unlock growth levers and break revenue ceilings for digital businesses.

Technical Dashboard Design

Executive-grade Power BI dashboards with DAX measures that tell a clear data story.

Predictive Modeling & Machine Learning

Building reliable prediction systems using advanced regression, classification, and feature engineering.

Let's Work Together