MSB
Türkçe

Audit & Financial Analysis

Mustafa Sezer Başar

Audit & Financial Analysis · Business Administration Graduate

Ankara, Türkiyemustafasezerbasar@gmail.comgithub.com/mustafa-sezer-basarlinkedin.com/in/mustafa-sezer-başar

One-page PDF

Professional Summary

Business Administration graduate of Hacettepe University (full-time, English-medium). Built the rule engine of a field audit system for an audit firm: rules are stored with their statute reference and validity period, pass a human review gate, and every audit run stays reproducible. Works on data reconciliation and reporting at a retail group; ran the cash flow, break-even and NPV/IRR analysis of the 15-person business he founded.

Highlights

  • 95% reduction in operational errors
  • 15-person team built from scratch
  • 200% ad ROI (profit over spend)

Education

  1. August 2022 – July 2026

    Hacettepe University

    BA in Business Administration

    GPA 3.12/4.00 · English-medium · Graduated

  2. September 2018 – August 2022

    Middle East Technical University (METU)

    Civil Engineering

    English-medium · Transferred to Business Administration at Hacettepe University

Experience

  1. June 2026 – PresentAnkara

    Paulmark

    Database Analyst — Business Development & Strategy

    • Leads a three-person technology team, moving a Nebim V3 and Power BI retail stack off Excel-based processes.
    • Automated the monthly employee-commission calculation: sales data loaded from Nebim V3 or by manual entry runs through a single computation flow. Also added a machine learning model that produces suggestions from past sales.
    • Closed the gap between the teams' own Excel files and the master data; inconsistencies used to surface only once they had grown.
    • Automated the Excel-based data reconciliation of the Kazakhstan operation; scheduling it is in progress.
    • Builds department-level solutions on POS and accounting data; in a family company, agreeing on definitions comes before the technical work.

  2. September 2024 – February 2025Cappadocia

    Myrco Spa Center (Barceló Cappadocia)

    Co-Founder / Operations Lead

    • Ran the spa centre inside the Barceló Cappadocia hotel as a subcontractor; built the 15-person team from scratch.
    • Managed cash flow, break-even analysis and financial projections to keep the business sustainable.
    • Cut team-caused errors 95% in two months with a Spa Management app he built; error = an unauthorised entry counted on camera, or a session off the sold duration by ±5%.

  3. April 2023 – July 2024Cappadocia

    Cappadocia High Travel Agency

    Sales & Marketing Lead

    • Ran the allocation of the marketing budget across channels, the break-even calculation and cash-flow tracking.
    • Planned and ran the digital advertising campaigns; the return on advertising investment came close to 200%.
    • Moved the average Google local search rank across a Cappadocia keyword pool ('travel', 'travel agency' and similar) from 72 to 2 in three months through data-driven SEO.

Projects

Tax Audit System with Rule Extraction from Legislation

The rule engine of a field audit system built for an audit firm: an end-to-end working component that reads legislation with RAG and turns it into audit rules. The corpus is self-sourced: a collector he built pulls statutes and high-court rulings into a database, and the RAG layer works on top of it. Rules are held as JSON with their statute reference and validity period, pass a human review gate, and are then applied deterministically by a Go service. The LLM is not in the hot path — it runs offline — so every audit run stays reproducible and auditable. Taxpayer data never leaves the system: the external language model only ever sees public legislation.

  • Python (LLM)
  • Go
  • Next.js
  • MySQL

KVKK Compliance Engine

Full-stack system encrypting employee PII field by field with AES-256-GCM: a key per subject makes erasure the destruction of that key (crypto-shredding); plus role-aware masking, a hash-chained audit log and 64 adversarial tests generated from the policy table. Compliance claims come from an evidence report that fails the build when dirty.

  • TypeScript
  • Express
  • node:sqlite
  • Node crypto (AES)

Data Quality Audit & Reporting Tool

Tool that cleans messy tabular data into a multi-sheet Excel report — and, more to the point, measures the cleaner's own error rate. It generates a synthetic file with known defects and scores against ground truth, which makes two outcomes visible that cleaning tools never report: errors missed in silence, and correct cells destroyed. Against an ordinary twenty-line pandas cleaner: 10 silent errors versus 361. The measurement found three defects in the tool itself (61 correct salaries multiplied by twelve, 28 required fields silently blank, 8 malformed emails with no log entry), none of them visible in the output. A pay-gap analysis reads 3.37% on dirty data and 3.86% after cleaning, against a true 3.85%. 134 tests.

  • Python
  • pandas
  • openpyxl

Skills

Finance & Strategy
Financial modeling, forecasting, ROI/NPV/IRR analysis · Break-even analysis, risk management · Portfolio optimization (Markowitz), Monte Carlo simulation
Data Analytics & Reporting
Data quality and reconciliation checks · Metric definition and shared dictionary (consistency across reports) · Source-to-report data flow (ingestion, transformation, publication) · Nebim V3 (retail ERP) data model · Measurement design: control group, placebo, pre-registered hypothesis
Security & Compliance
AES encryption, RBAC, PII masking · Audit logging, KVKK/GDPR compliance

Leadership & Communities

  • Founding team member, Hacettepe Management Consulting Club (HMCC)
  • Debate competitor at METU; special speaker award at the novice tournament

Languages

Turkish (Native) · English (Advanced — English-medium undergraduate education)