Umut Mengu

Umut Mengu

Data Analyst
Turkey
English, Turkish

About Me

Data Analyst with a Software Engineering background, specializing in end-to-end data pipelines, statistical analysis, and business-facing dashboards. Proven track record of turning real-world data into decisions — across…

Experience

ML & Data Intern

Arch of Sigma
Mar 2026 - Apr 2026 · 1 month

<p>Built a full pipeline from data collection through cleaning, modeling, and automated PDF reporting, cutting manual overhead by 70%.<br>
Trained a scikit-learn regression model for real-time CO2 emission prediction with 80%+ accuracy.<br>
Delivered a Streamlit dashboard enabling stakeholders to identify a 15% emissions reduction pathway.</p>

ML & Data Intern

Arch of Sigma
Mar 2026 - Apr 2026 · 1 month

Built a full pipeline from data collection through cleaning, modeling, and automated PDF reporting — cutting manual overhead by 70%., Trained a scikit-learn regression model for real-time CO2 emission prediction (80%+ accuracy); delivered a Streamlit dashboard enabling stakeholders to identify a 15% emissions reduction pathway.

Data Analyst Intern

METROSAN
Jun 2025 - Oct 2025 · 4 months

<p>Built an end-to-end Python ETL pipeline ingesting live sensor data.<br>
Validated 1,000+ data points in real time.<br>
Reduced reporting effort by 60%.<br>
Eliminated a key manual bottleneck.<br>
Analyzed visual inspection data to track defect metrics at ±0.2 mm precision.<br>
Identified root causes that improved safety scores by 80%.<br>
Directly informed engineering corrective actions.<br>
Designed operational dashboards used daily by the engineering team to monitor production KPIs across cross-functional stakeholders.</p>

Data Analyst Intern

METROSAN
Jun 2025 - Oct 2025 · 3 months

Built an end-to-end Python ETL pipeline ingesting live sensor data, validating 1,000+ data points in real time — reducing reporting effort by 60% and eliminating a key manual bottleneck., Analyzed visual inspection data to track defect metrics at ±0.2 mm precision; identified root causes that improved safety scores by 80%, directly informing engineering corrective actions., Designed operational dashboards used daily by the engineering team to monitor production KPIs across cross-functional stakeholders.

Reporting Intern

FLO
Aug 2025 - Sep 2025 · 1 month

<p>Wrote and optimized complex SQL queries to extract and analyze operational data across 500+ retail stores.<br>
Surfaced patterns that informed executive-level reporting.<br>
Translated stakeholder business requirements into data models and reporting structures.<br>
Architected the data layer of an internal reporting tool.<br>
Significantly reduced manual report preparation time.</p>

Reporting Intern

FLO
Aug 2025 - Sep 2025 · 1 month

Wrote and optimized complex SQL queries to extract and analyze operational data across 500+ retail stores, surfacing patterns that informed executive-level reporting., Translated stakeholder business requirements into data models and reporting structures; architected the data layer of an internal reporting tool, significantly reducing manual report preparation time.

Web Analytics Intern (Volunteer)

Sanctuary of the Arts
Jan 2025 - Apr 2025 · 3 months

<p>Restructured the nonprofit’s digital data flow and information architecture.<br>
Laid the groundwork for traffic and engagement analytics across performing arts programs.<br>
Received a formal recommendation letter.</p>

Web Analytics Intern (Volunteer)

Sanctuary of the Arts
Jan 2025 - Apr 2025 · 3 months

Restructured the nonprofit’s digital data flow and information architecture, laying the groundwork for traffic and engagement analytics across performing arts programs. (Formal recommendation letter received.)

PROJECTS

customer-segmentation-rfm

Duration : 01-May-2026 - 10-May-2026

<p>•Analyzed 500,000+ e-commerce transactions; built an RFM scoring pipeline (Pandas) to segment 4,338 customers into 6 behavioral groups — identifying the 'At Risk' segment as the top recovery opportunity.</p><p>•Delivered a Power BI dashboard visualizing segment distribution, monetary value, and recency to guide targeted marketing decisions.</p><p></p>

Skills

Google Analytics MySQL Python Google Sheets NumPy Power BI Statistical Analysis Tableau Pandas scikit-learn SQL SQLite ETL Pipelines Data Cleaning & Wrangling Streamlit Matplotlib Seaborn Automated Reporting Advanced Excel Google Ads Search Git Jupyter Notebook Data Cleaning Data Wrangling
Report this Profile?