From a four-tier markup structure and customer segmentation model
~82%
Forecast accuracy
F3+9 rolling forecasts and reforecasts for commercial planning
267,000
SKU catalogue
Multi-brand pricing data kept clean for Dynamics 365 uploads
01
Selected work
Flagship analytical work from after-sales pricing and forecasting. Confidential volumes, margins and customer lists are omitted; the method is not.
Professional work
Catalogue Automation Pipeline
Python workflow that ingests multi-brand parts catalogues and emits XML for ERP loading, replacing a manual prep loop.
A repeatable Python-to-XML path now used for catalogue loads instead of one-off spreadsheet surgery.
Catalogue Automation Pipeline
Python
pandas
openpyxl
XML
Professional work
Customer Segmentation Model
Sales-history cohorts that give commercial and inventory planning a shared view of who buys, how often, and how recently.
Planning conversations use the same customer map instead of competing spreadsheet cuts.
Customer Segmentation Model
Python
Segmentation
Inventory Analysis
Professional work
GPM & Sales Performance Tracker
Power Query and Excel reporting that compares gross profit margin and sales with budget and prior-year performance for management review.
Leadership can read margin and sales against budget and last year from one workbook, without a reconstruction each cycle.
GPM & Sales Performance Tracker
Power Query
Excel 365
OLAP
KPI Reporting
More work (2)
Professional work
Price / Volume / Mix Bridge
Revenue and gross-profit analysis in DuckDB and Python, separating period-over-period variance into price, volume and mix effects.
A movement in the P&L can be explained as price, volume or mix instead of a single unexplained delta.
Price / Volume / Mix Bridge
DuckDB
Python
Pricing
Professional work
Car Market Forecasting Workbook
A rolling-forecast workbook comparing forecasting methods against out-of-sample observations.
Method choice is judged on holdout error, not on which curve looks smoothest in-sample.
Excel
Forecasting
F3+9
02
Experiments
Personal software I ship in public: exact arithmetic, edge-native AI, and exploratory analysis.
Personal project
Health Analytics SQL Case Study
Debugged a broken SQL script and answered nine board questions on 43,891 health-app log rows. Anonymised real data from the Serious SQL course, with no personal information.
Every answer cross-checked by a second query. Five users (0.9%) produce 62% of all logs, so a mean of 79 logs per user hides a median of 2.
Expense splitting with a Python CLI, a Cloudflare-hosted web PWA and an Expo client. Integer-cent arithmetic keeps equal and weighted splits exact; a greedy settlement pass produces who pays whom.
Public at fair-share-trips.pages.dev. No accounts. Link-and-PIN sharing only. Money never uses floats.
A public oracle on Cloudflare Pages. The temple is a single static file; replies come from Workers AI on the free tier, rate-limited at the edge, with conversation memory only in the visitor's browser.
Live at pythia-oracle.pages.dev. Zero build step, no provider API keys, graceful shutdown when the free neuron budget is spent.
A personal Python exploration of catalogue and engagement patterns, presented as dashboards. Learning project, not a client engagement.
Practice in shaping a messy catalogue into questions a dashboard can actually answer.
Python
Dashboards
03
Work history
Pricing analytics, ERP operations and commercial reporting at Saracakis, built on earlier customer-operations experience.
Spare Parts & Pricing Analyst
Saracakis Group S.A. · Athens
CVM After Sales — Volvo Construction Equipment
Nov 2025 – Present
Own pricing data integrity for a 267,000-SKU multi-brand catalogue (~40,000 active SKUs), validating monthly catalogue releases and preparing structured price uploads into Microsoft Dynamics 365.
Co-designed and implemented a four-tier markup structure and customer segmentation model (85 accounts), delivering a 9.2-point blended GPM improvement.
Deliver VP-level management reports for Volvo CE and Komatsu from OLAP cube sales data, with trend analysis of YTD turnover, gross profit and GPM% vs budget and prior year.
Build and maintain F3+9 rolling forecasts and reforecasts for commercial planning at ~82% forecast accuracy.
Run catalogue price comparisons, Part No supersession analysis and GPM% checks on high-value lines.
Developing an Excel demand forecasting and reorder model (Croston-based, service-level and lead-time driven) to support stock ordering decisions.
Automated catalogue processing and XML data generation in Python, replacing ad-hoc and VBA-based workflows with repeatable processes (pandas, openpyxl).
Resolve master data, pricing and catalogue issues in Microsoft Dynamics 365, and support B2B sales (quotations, orders, client communication) for dealer and key accounts.
Earlier roles (3)
Client Experience Associate
Customer-experience services provider · Athens
Jul 2025 – Nov 2025
Supported a financial-services client in the Canadian market, with CRM documentation and customer-insight analysis for process improvement.
Customer Service Representative
Customer-operations provider · Athens
Sep 2023 – May 2025
Handled customer operations for the UK and Greek markets using Salesforce and Zendesk, with a focus on resolution and customer satisfaction.
Administrative Secretary
Military logistics unit · Athens
Oct 2022 – May 2023
Supported materials control and logistics through inventory records, inspections and supplier deliveries.
04
About
Analyst with an applied mathematics background, working across pricing, forecasting and after-sales operations.
My work connects commercial requirements with pricing data integrity, ERP master data and management reporting. I use Python, Excel and SQL to make analysis repeatable and useful for business decisions.
I'm completing a Diploma in Applied Mathematics & Physical Sciences at NTUA part-time alongside full-time employment.
Certified Bridge Tournament Director (Greek Bridge Federation), directing ~70 tournaments a year; Silver Medal, Europe U25 Bridge Tournament.