Skip to content
View scripts-and-tables's full-sized avatar
🙂
coding
🙂
coding

Sponsoring

@curl

Highlights

  • Pro

Block or report scripts-and-tables

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
scripts-and-tables/README.md

Oleksandr Tverdokhlieb

Data Analytics Manager | SQL • Python • Power BI | Dubai, UAE

I build reliable analytics products end-to-end: from messy source files and databases to automated pipelines, governed datasets, and decision-ready dashboards. My work typically sits at the intersection of business operations and engineering—turning manual reporting and fragmented processes into scalable, auditable systems.


What I do

  • Analytics leadership: manage and coach analysts, set SLAs/KPIs, improve delivery quality and ownership.
  • Data engineering (pragmatic): ingestion from Excel/CSV/APIs, cleaning, validation rules, automation, scheduling.
  • BI & semantic models: Power BI models and reports used by management and large user groups.
  • Automation: Python orchestration scripts, monitoring, email notifications, and repeatable refresh workflows.
  • Process digitization: lightweight web tools (often Python/Django) that replace manual inputs and spreadsheet chaos.

Core skills

Languages & Querying

  • Python (pandas, automation, APIs, web scraping)
  • SQL (performance tuning, complex queries, data modeling)

BI / Reporting

  • Power BI (DAX, modeling, governance, report performance)

Data & Storage

  • SQLite / Postgres (and other relational concepts)
  • File-based pipelines (Excel/CSV/JSON), data quality checks, reproducible transformations

Automation & Tooling

  • CLI tools, schedulers, Windows-based automation
  • Git / GitHub workflows (branching, pull requests, repo hygiene)

Selected project themes (what you’ll find across my repos)

  • Synthetic data generation for demos, testing, and analytics prototyping when real data cannot be shared
  • CRM / sales analytics: customer segmentation, cohort behavior, basket logic, retention signals
  • Operational reporting automation: consolidate multi-source inputs, validate, load, publish, notify
  • Data quality tooling: rule-based validation, anomaly detection, consistent column normalization for “real-world messy Excel”
  • Web interfaces for business processes: controlled inputs, approvals, audit logs, and API access

How I work

  • Prefer simple, maintainable solutions over over-engineering.
  • Value data quality and auditability: clear transformations, repeatable runs, and traceability.
  • Focus on business outcomes: reduce manual effort, accelerate decisions, and improve reliability.
  • Write documentation so others can onboard quickly and operate with confidence.

Repository navigation (typical)

Most of my projects follow a simple pattern:

  • src/ – core code (pipelines, business logic, utilities)
  • data/ – sample inputs (or placeholders if data cannot be shared)
  • output/ – generated exports (often gitignored)
  • README.md – usage, assumptions, and examples

If a project uses a local database (*.db, *.sqlite), it is usually excluded from Git history unless it is fully synthetic and reproducible.


Getting in touch

  • LinkedIn:
  • GitHub:
  • Location: Dubai, UAE

Notes

If you are reviewing this repository for hiring or collaboration:

  • I’m happy to clarify assumptions, dataset design decisions, or architecture trade-offs.
  • Where real company data cannot be shared, you will see synthetic datasets that preserve structure and realism without exposing confidential information.

Popular repositories Loading

  1. crm-analytics-system crm-analytics-system Public

    Production-oriented CRM analytics system with lifecycle segmentation and RFMT-based customer analysis for FMCG businesses.

    PLpgSQL 9

  2. erp-synthetic-data-generator erp-synthetic-data-generator Public

    ERP Synthetic Data Generator: a configurable Python package that generates realistic synthetic master data (customers, items) and sales transactions for ERP/analytics demos and testing, with reprod…

    Python 6

  3. scripts-and-tables scripts-and-tables Public

    Config files for my GitHub profile.

  4. bic-apiecom bic-apiecom Public

    Python

  5. vcg vcg Public

    Video Content Generator aka VCG

    Python