Forecasting & Pricing Analyst

Sotirios Goulas

I turn commercial data into clearer forecasts, reliable pricing and practical reporting tools.

Athens, Greece · Supply chain · Pricing · Business intelligence

  • Catalogue integrity

    Repeatable Python-to-XML paths for after-sales parts data

  • Rolling forecasts

    Planning views that separate signal from noise

  • Variance reporting

    Price, volume and mix explained for management review

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.

  • 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.

  • 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.

  • 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.

  • 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

Fair Share

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.

  • Python
  • TypeScript
  • Expo
  • Cloudflare
View Fair Share on GitHub Open Fair Share demo

Personal project

PYTHIA — The Oracle of Delphi

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.

  • HTML/CSS/JS
  • Workers AI
  • Pages Functions
View PYTHIA — The Oracle of Delphi on GitHub Open PYTHIA — The Oracle of Delphi demo

Personal project

Apple TV+ Data Exploration

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 · Athens

Nov 2025 – Present

  • Own pricing data integrity and ERP master data for a multi-brand after-sales parts catalogue in Microsoft Dynamics 365.
  • Prepare management reporting on turnover and gross profit margin against budget and prior-year performance.
  • Translate commercial requirements into rolling forecasts, customer segmentation and reporting tools used in planning.
  • Automate catalogue processing and XML generation with Python so catalogue loads are a repeatable path, not a manual ritual.
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 tournament director with the Greek Bridge Federation. Competitive bridge stays off the CV; it is how I think in constraints, partnerships and incomplete information.

Location

Athens, Greece

Focus

Supply chain · Pricing · Business intelligence

05

Education & credentials

Degree in progress, then the credentials that map to pricing, demand and SQL.

Education

  • Diploma in Applied Mathematics & Physical Sciences

    National Technical University of Athens (NTUA) · Expected 2028

Completed credentials

  • Pricing Strategy

    University of Virginia Darden / BCG · Completed

  • Demand Analytics

    Rutgers University · Completed

  • Generative AI Data Analyst

    Vanderbilt University · Sep 2025

  • English Language Proficiency — ECPE (C2)

    University of Michigan · Certified

In progress

  • IBM Data Analyst Professional Certificate — SQL module

    IBM · In progress

  • 8 Week SQL Challenge

    Data with Danny · In progress

06

Let's talk

Open to roles in pricing, forecasting, supply chain and business intelligence. Tell me what you're hiring for.

Your name, email and message are processed by Cloudflare so I can respond. Please do not include confidential information. For deletion requests, email sotirios.k.goulas@gmail.com.