I design and implement end-to-end process, data and AI solutions around ERP (especially SAP Business One & Netsis), WMS, SQL Server and Python.
My work blends business analysis, data engineering, and productized automation: alerting pipelines, IoT label printing, FastAPI data services, multi-page Dash dashboards and NL2SQL / LLM-based report assistants.

• 🌱 Currently focusing on AI-assisted ERP reporting (NL2SQL) & operational dashboards
• 🛠 Daily stack: Python, SAP B1, Netsis, SQL Server, Excel/VBA, Dash/Plotly, FastAPI, OpenAI
• 📫 Contact: yigiteroglu7@gmail.com • 🌐 https://yigiteroglu.pythonanywhere.com

• Featured Projects
• Results & Impact
• ERP & Business Solutions
• Dashboards & Analytics
• AI, NL2SQL & SQL Assistants
• Automation, APIs & Desktop
• Finance, Costing & Manufacturing
• Blog
• Awards
• References
• Education & Career
• Tech Stack
• GitHub Stats
• Contact

• **NETSIS — SQL Tool Set (Reporting & Analysis Queries)** A curated and structured **SQL query library for NETSIS ERP** covering master data checks, stock/serial-lot tracking, sales–purchase analysis and finance summaries. Built with an **ERP consultant mindset**: reusable queries, consistent naming, clean CTE structure and parameter placeholders—ready for Excel, Power BI and dashboard datasets. → https://yigiteroglu.pythonanywhere.com/projects/netsis _{Repo: https://github.com/YigitErogluTr/Netsis • Tech: T-SQL (SQL Server), NETSIS ERP, Reporting Standards}

• **Mail Report Bot — IMAP → SQL → Excel (SAP B1)** Natural-language mail commands → SAP B1 (SQL Server) queries → auto-formatted Excel/CSV attachments. Idempotent, multi-scenario, size-aware, and weekday-scheduled. → https://yigiteroglu.pythonanywhere.com/projects/mail-report-bot _{Tech: Python, SQL Server (pyodbc), Pandas, XlsxWriter, Gmail API (yagmail), python-dotenv}
• **ERP-Independent OpenAI-Based SQL Report Assistant (SAP B1 Example)** Uses selected ERP core tables’ schema to generate **safe, focused `SELECT` queries** from Turkish natural language prompts. Token-optimized schema prompt, ERP-aware joins and strict **read-only** SQL guard. → https://yigiteroglu.pythonanywhere.com/projects/erp-ai-sql-assistant

• ERP Notify | Audit & Operational Email Reports (SAP B1 + Gmail API)
  Scheduled, idempotent notifications for PRQ→PO conversions, shipments/deliveries, GR/IR mismatches, stock anomalies (multi-system), inter-warehouse transfers, Like-for-Like sales, and daily activity (ALL/DIFF).
  Weekdays 08:00–18:00, every 30 minutes, role-based recipients and duplicate-suppression logs.
  → https://yigiteroglu.pythonanywhere.com/projects/erp-notify

• SAP B1 | Automated Email Notifications
  Event-driven HTML emails (idempotent, noise-free) to the right owner at the right time.
  → https://yigiteroglu.pythonanywhere.com/projects/sap-b1-bildirim-otomasyonlari

• IoT | Scale → ZPL Labeling (9100 RAW)
  Reads net/gross/tare + serial/ticket from local scales (HTTP/XML), generates ZPL, and prints over TCP.
  → https://yigiteroglu.pythonanywhere.com/projects/iot

• FastAPI | SQL-Based Data Service
  REST endpoints for stock, dispatch orders/monitoring, and inventory counts with OpenAPI/Swagger.
  → https://yigiteroglu.pythonanywhere.com/projects/sql-fastapi

• Dash | Operations Dashboards (Multi-page + Auth)
  Sales, returns, stock, profit, finance, regional & geo analysis—print/PDF ready.
  → https://yigiteroglu.pythonanywhere.com/projects/ecommerce-analytics-dashboard
  → https://yigiteroglu.pythonanywhere.com/projects/dash-analyzer
  → https://yigiteroglu.pythonanywhere.com/projects/dash-stock

• ABC / Pareto for SAP B1 (T-SQL + Excel/VBA)
  One-year net sales, 80/95 guide lines, Excel Pareto chart via macro.
  → https://yigiteroglu.pythonanywhere.com/projects/abc-pareto-sapb1

• Desktop | Organization Chart (Excel → PNG/PDF)
  Drag & drop Excel/CSV, role-based color mapping, zoom, search & auto-center, one-click PNG/PDF export.
  → https://yigiteroglu.pythonanywhere.com/projects/orgchart

• Dash | Financial Statements Analysis (Demo)
  Income statement, balance sheet, cash flow, ratios; last 5-year comparison; multi-sheet Excel export.
  → https://yigiteroglu.pythonanywhere.com/projects/finance

A selection of tangible outcomes from real-world deployments (ranges vary by context).

• WMS & Inventory Excellence (award-winning)

  • 📦 Inventory accuracy: ~96% → 99.5%+
  • 👣 Pick-path distance: −20–35% (optimized routing)
  • ⏱ Dock-to-stock time: −40% (receiving to put-away)

• SAP B1 Automated Email Notifications

  • 🔕 Inbox noise: −70% (single grouped email per owner)
  • ♻️ Duplicate alerts: −100% (idempotent logging)
  • 📬 Response SLA adherence: +20–30% (owner-targeted routing)

• IoT Scale → ZPL Labeling

  • 🧾 Mislabel/entry errors: −90% (machine-read + validation)
  • 🖨 Print cycle time: ~45s → ≤5–8s per label
  • 🔗 Traceability coverage: End-to-end (ticket/serial → barcode)

• Dash / E-commerce & Operations Dashboards

  • 📊 Report prep time: ~60 min → < 1 min (self-serve)
  • 👥 Adoption: 20+ internal users (role-based)
  • 🖨 Meeting-ready: one-click print/PDF workflows

• ABC / Pareto (T-SQL + Excel/VBA)

  • 🅰️ A-class service level: +8–12 pp (stock policy by class)
  • 💸 Working capital tied in stock: −8–15% (SKU focus)
  • 🎯 SKU prioritization: “Top-N + Other” clarity for decisions

• FastAPI Data Service (SQL-backed)

  • 🔌 Integration lead time: days → hours (Swagger-first)
  • 🗄 Single source of truth: consistent JSON across apps

• Time Series Forecasting

  • 📈 MAPE: ~8–12% on stable series (with model selection & seasonality)
  • 🗓 Planning cadence: monthly & weekly horizons supported

• BoM Costing / Cost Estimate

  • 🧮 Costing cycle: ~2h → ~10–15 min (automation + export)
  • 📑 Auditability: structured Excel/PDF outputs

• SQL-First ERP Reporting

  • 🧾 Ad-hoc SQL requests/week: −50–60% (parameterized reports)
  • ⚡ Query time: tuned indexes & caching for heavy tables

_{※ Figures reflect representative deployments; actual results depend on data quality, scope, and operating model.}

• SAP B1 | Full Business Processes
  Live operations: Warehouse, Production, Sales, Purchasing, Finance, Accounting.
  → https://yigiteroglu.pythonanywhere.com/projects/sap-b1

• WMS | Warehouse Management System
  ERP integration, pick-path optimization, IoT-assisted flows.
  → https://yigiteroglu.pythonanywhere.com/projects/wms

• NETSIS | Add-On Development
  Custom modules for Netsis ERP.
  → https://yigiteroglu.pythonanywhere.com/projects/netsis-addon

• ERP Reports | Cost, Finance, Inventory, Logistics, Production, Purchasing & Sales Queries
  SQL-first reporting with PBI/Excel integration and parameterized filters.
  → https://yigiteroglu.pythonanywhere.com/projects/erp-reports

• Odoo | Help Desk & Project Management
  Modular configurations and tailored flows.
  → https://yigiteroglu.pythonanywhere.com/projects/odoo

• NETSIS — SQL Tool Set (Reporting & Analysis Queries)
  → https://yigiteroglu.pythonanywhere.com/projects/netsis • Repo: https://github.com/YigitErogluTr/Netsis

• E-Commerce Analytics Dashboard | Multi-Page, Auth, Print/PDF
  Marketplace consolidation (Trendyol, Hepsiburada, Amazon, N11) with interactive charts.
  → https://yigiteroglu.pythonanywhere.com/projects/ecommerce-analytics-dashboard

• Dash | Operations Dashboard – Sales, Purchasing, Warehouse & Production
  Role-based access, mobile-friendly, KPI cards & comparative analysis.
  → https://yigiteroglu.pythonanywhere.com/projects/dash-analyzer

• Dash | Stock & Production Dashboard — PBI-Themed, SQL Server-Backed
  Aging, turnover, sleepers, monthly sales trends; production views.
  → https://yigiteroglu.pythonanywhere.com/projects/dash-stock

• Dash | Financial Statements Analysis (Demo)
  Income statement, balance sheet, cash flow, ratios; Y..Y−4 comparative charts; Excel multi-sheet export.
  → https://yigiteroglu.pythonanywhere.com/projects/finance

• Time Series Analysis | Sales Forecasting & Trend Modeling
  SARIMAX, Holt-Winters, and ML baselines with confidence intervals & exports.
  → https://yigiteroglu.pythonanywhere.com/projects/time-series-analysis

• SQL | Reporting & Data Mining
  Complex T-SQL for actionable insights.
  → https://yigiteroglu.pythonanywhere.com/projects/sql-raporlama

• ERP-Independent OpenAI-Based SQL Report Assistant (SAP B1 Example)
  Natural language → safe SELECT queries over a curated SAP B1 schema (OITM, ITM1, OITW, OPOR, ORDR, OINV, OCRD, OWOR, BOM1…).
  Token-optimized schema prompt, ERP-aware joins and strict no INSERT/UPDATE/DELETE rules.
  → https://yigiteroglu.pythonanywhere.com/projects/erp-ai-sql-assistant

• (Design & POC) Netsis SQL AI Report Bot (Local LLM)
  Planned architecture for GPT-free, local LLM-based Netsis reporting:
  IMAP/Gmail inbox → natural language → local model (Llama/Qwen/Mistral) → SQL → Excel report.
  Focus on read-only schemas, config-based scenario routing and on-prem data governance.

• Mail Report Bot — IMAP → SQL → Excel (Natural-Language Rules)
  Natural-language email commands (ALL/NONE/ANY + synonyms) → SAP B1 SQL queries → auto-formatted Excel/CSV attachments.
  Idempotent (UID log), size-aware (CSV fallback), domain/whitelist control, weekday scheduler.
  → https://yigiteroglu.pythonanywhere.com/projects/mail-report-bot

• ERP Notify | SAP B1 → Email Automation (Idempotent, Role-based)
  Weekday 30-min scheduler, grouped HTML emails, duplicate suppression, audit logs.
  → https://yigiteroglu.pythonanywhere.com/projects/erp-notify

• FastAPI | SQL-Based Data Service
  Stock, dispatch orders/monitoring, and count documents as JSON APIs with Swagger UI.
  → https://yigiteroglu.pythonanywhere.com/projects/sql-fastapi

• Python, SQL, VBA | Automated Reporting
  Scheduling, templated exports, and email distribution for operational and management reports.
  → https://yigiteroglu.pythonanywhere.com/projects/python-oto-rapor

• TCMB FX Rates Automation — Tkinter Desktop + Excel/CSV Export
  XML fetch, resampling, FFill for holidays, and one-file EXE packaging.
  → https://yigiteroglu.pythonanywhere.com/projects/tcmb-kur

• LetApp | Python Tkinter ERP Mini-App
  Sales, purchasing, income/expense tracking; optional Google Sheets/cloud usage.
  → https://yigiteroglu.pythonanywhere.com/projects/python-thinker

• Organization Chart | Tkinter Desktop
  Build org charts from Excel/CSV; position-based color themes, search with auto-centering, PNG/PDF export.
  → https://yigiteroglu.pythonanywhere.com/projects/orgchart

• Custom Sales Offer Application
  Tailored quotation flows & exports for SME scenarios.
  → https://yigiteroglu.pythonanywhere.com/projects/ozel-uygulama

• MRP BoM | Production Module
  Work orders and manufacturing flows.
  → https://yigiteroglu.pythonanywhere.com/projects/uretim-modulu

• Cost Estimate — SAP B1 BoM Costing
  Materials + labor + overhead; Excel/PDF export; packaged with PyInstaller.
  → https://yigiteroglu.pythonanywhere.com/projects/cost-estimate

• Actual Cost Project
  Real cost tracking & analysis.
  → https://yigiteroglu.pythonanywhere.com/projects/fiili-maliyet

• BRL Textile | Credit P&L Tracking
  Deferred vs. normal credit P/L monitoring.
  → https://yigiteroglu.pythonanywhere.com/projects/kredi-kar-zarar

• Financial Statements Analysis (Demo)
  Income statement, balance sheet, cash flow, ratios; Y..Y−4 comparative charts; Excel multi-sheet export.
  → https://yigiteroglu.pythonanywhere.com/projects/finance

I write about ERP integrations, WMS, analytics, IoT, AI-assisted reporting and delivery practices.
Read all posts → https://yigiteroglu.pythonanywhere.com/blog

• Ege Logistics Region Award (2022) — WMS Warehouse Management System project
• DEU Econometrics Honor Student (2021)

More → https://yigiteroglu.pythonanywhere.com/awards

Clients & collaborators (selection): Egemen Group, Sempotech, Letra Water, H1, FS Software, BRL Tekstil, Green Lojistik, ELODER, Mim Danışmanlık.

More → https://yigiteroglu.pythonanywhere.com/references

• MSc, Management Information Systems — Dokuz Eylül University (2023–2025)
  Term Project: Stock Traceability & ERP Management (Netsis → SAP B1 migration, WMS & IoT integration)
• BSc, Econometrics (Honors) — Dokuz Eylül University (2016–2021)

Business Analyst Specialist @ Egemen Group (Sep 2021 – Present)
ERP/WMS/production projects, SQL analytics, BI dashboards, IT integrations, automation & AI-backed reporting.

→ Career: https://yigiteroglu.pythonanywhere.com/career
→ Education: https://yigiteroglu.pythonanywhere.com/education

ERP: SAP Business One, Netsis, Odoo, Akınsoft ERP
DB/BI: SQL Server, Power BI, SPSS
Python: Pandas, NumPy, FastAPI, Dash/Plotly, Tkinter, OpenPyXL, Requests
AI & LLMs: OpenAI GPT models (NL2SQL, classification, extraction), prompt engineering with ERP schemas
Automation: VBA/Excel, Gmail API, IMAP/SMTP bots, schedulers, ETL-style pipelines
Patterns: Idempotent email alerts, CSV/Excel/PDF outputs, authenticated dashboards, role-based routing

• Email: yigiteroglu7@gmail.com
• Website: https://yigiteroglu.pythonanywhere.com
• LinkedIn: https://www.linkedin.com/in/mustafa-yiğit-eroğlu/

I connect business operations with reliable data, automation and AI — designing measurable, maintainable solutions that scale.