Esra esramogulkoc-dev

Hello, I'm Esra! 👋

Quality Engineer & Data Analyst | 14 Years of Automotive Expertise | Bridging Industrial Quality with AI

Languages

Data Analysis & Visualization

Advanced Data Platforms & Cloud

Workflow & Automation

🔍 Uncovering the "Why": I love turning messy data into clear, actionable stories that drive business decisions.
🧠 Analytical Curiosity: I'm passionate about exploring patterns and finding the hidden logic behind the numbers.
🧩 Visual Clarity: I enjoy building intuitive reports and systems that make complex information easy to digest.
🤖 Automation Mindset: I'm interested in using AI Agents and automated workflows to streamline data analysis tasks.

Break Down Complexity: Deconstructing large business problems into small, manageable analytical questions.
Data Transformation: Cleaning and restructuring data to ensure a reliable "source of truth".
Exploratory Data Analysis (EDA): Identifying trends, correlations, and outliers to guide the strategy.
Insight Delivery: Presenting results through Python-based visualizations and evidence-based recommendations.

🎓 Preparing for the Microsoft PL-300: Power BI Data Analyst certification.
🏗️ Deepening my SQL proficiency, with a focus on CTEs, advanced joins, and window functions.
🏗️ Mastering Microsoft Fabric and Databricks for scalable data processing.
🤖 Exploring AI Agents to automate repetitive data analysis workflows.

🔗 LinkedIn Learning Agent — An AI-powered tool that transforms weekly learning journals into professional LinkedIn posts.

🧠 AI Generation: Uses Google Gemini API (gemini-2.5-flash-lite) to craft 3 post variations from raw notes.
📝 Prompt Engineering: Structured prompts extract topics, insights, and generate hashtag-rich content.
📤 LinkedIn Integration: Optional direct publishing via the LinkedIn UGC Posts API.

📊 Retail Analytics Dashboard — Built with Claude Code — A production-ready interactive dashboard built in one session using Claude Code.

📈 Scale: Processes 541,909 e-commerce transactions across 37 countries.
🖥️ Dashboard: 6-tab Streamlit + Plotly app with live KPIs, product analysis, and geographic breakdowns.
🎯 Claude Code Mastery: Demonstrates Levels 1–3 (Commander, Planner, Context Engineer) of the 6-level framework.

🏠 Immo Eliza — End-to-End Real Estate Analysis
An end-to-end machine learning solution to predict property prices in the Belgian real estate market.
Full Pipeline:

🔍 Analytics: Executed Advanced SQL queries to uncover market trends.
📈 Visuals: Generated insights using Python libraries (Matplotlib/Seaborn/Geospatial Maps (Folium)).

🏥 HR Sick Leave Analysis — Identifying patterns in sick leave data to provide HR with actionable workforce insights with Power BI.

📊 Analytics: Pattern recognition in sick leave data for HR optimization.
📈 Visualization: Created an interactive Power BI Dashboard to deliver actionable insights to stakeholders.

☁️ Azure Data Challenge — Managing data workflows and infrastructure automation within the Azure ecosystem.