Skip to content
View arghavanas's full-sized avatar
🎯
Focusing
🎯
Focusing
  • Germany
  • 07:31 (UTC +02:00)

Block or report arghavanas

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 is supported. This note will only be visible to you.
Report abuse

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

Report abuse
arghavanas/README.md

πŸ‘‹ Hi, I’m Arghavan

I work at the intersection of data engineering, database systems, ERP analytics, business intelligence, and applied data science.

My focus is simple: turning messy operational data into reliable pipelines, analytical models, and decision-ready systems.

I am especially interested in modern data platforms, including Databricks, Data Lake, Lakehouse architecture, Delta Lake, and scalable analytics workflows.


🧠 Core Focus

  • Data Engineering & ETL pipelines
  • SQL Server, ERP data, and operational databases
  • Power BI semantic models and business reporting
  • Databricks, Delta Lake, and Lakehouse architecture
  • Time-series forecasting and demand prediction
  • Python-based automation and analytics
  • Data storytelling for business decision-making

πŸ—οΈ Data Platform & Lakehouse Interests

I am building my skills around modern data architecture, especially:

  • Data Lake and Lakehouse design
  • Bronze / Silver / Gold medallion architecture
  • Delta Lake concepts
  • Parquet-based data pipelines
  • Batch and incremental data processing
  • ERP β†’ Lakehouse β†’ BI / ML workflows
  • Scalable analytics beyond traditional data warehouses

My goal is to connect legacy enterprise systems with modern analytical platforms.


πŸš€ Projects

πŸ“¦ Demand Forecasting for Retail & ERP Data

A forecasting-oriented project focused on product-level demand prediction using ERP-based transactional data.

Main scope:

  • SQL-based data extraction
  • Python data preparation
  • Time-series aggregation
  • Feature engineering
  • Forecasting with statistical and ML-oriented methods
  • Business-aware exception handling

🌊 Lakehouse Retail Pipeline

A modern data platform prototype inspired by Databricks and Lakehouse architecture.

Main scope:

  • Raw ERP-style data ingestion
  • Parquet-based storage
  • Bronze / Silver / Gold transformation layers
  • Delta Lake-ready design
  • BI-ready and ML-ready output datasets

⚑ SQL Performance & Query Optimization

A technical project focused on SQL diagnostics and performance improvement.

Main scope:

  • Query analysis
  • Indexing strategy
  • Execution-plan thinking
  • Optimization patterns
  • SQL Server-focused performance tuning

πŸ“Š Power BI KPI & Decision Dashboard

A business intelligence project focused on operational KPIs and decision support.

Main scope:

  • Power BI semantic modeling
  • Dynamic KPI comparison
  • Period-over-period analysis
  • Warehouse / logistics / employee-level metrics
  • Dashboard storytelling

🧾 ERP Documentation & Business Logic Mapping

A documentation-focused project for understanding and structuring ERP configuration and reporting logic.

Main scope:

  • Reverse-engineering ERP workflows
  • Mapping business rules
  • Documenting configuration hierarchy
  • Translating operational logic into analytical logic

πŸ› οΈ Tools & Technologies

Area Tools / Concepts
Programming Python, SQL, VBA, Shell scripting
Databases SQL Server, PostgreSQL, Oracle, MySQL, Cassandra
Data Engineering ETL, ELT, Parquet, data pipelines, batch processing
Lakehouse Databricks, Delta Lake, Medallion Architecture
BI & Analytics Power BI, Power Query, DAX, Excel
Data Science Pandas, Scikit-learn, Statsmodels, time-series forecasting
DevOps Git, GitHub, Docker
Enterprise Systems ERP systems, WMS, logistics data, operational reporting

πŸŽ“ Currently Learning

  • Databricks and Lakehouse architecture
  • Delta Lake and medallion pipelines
  • Snowflake and modern cloud data platforms
  • IBM Data Engineering pathway
  • Advanced forecasting and anomaly detection
  • MLOps and model monitoring

🧩 What Defines My Work

I like building systems that are:

  • Practical
  • Explainable
  • Business-aware
  • Technically structured
  • Scalable enough to survive real-world messiness

I am not interested in data work that only looks impressive in theory.
I care about pipelines, models, and dashboards that can actually support decisions.

Thanks for visiting my GitHub.

Popular repositories Loading

  1. arghavanas arghavanas Public

    Config files for my GitHub profile.

    1

  2. ml-intern ml-intern Public

    Forked from huggingface/ml-intern

    πŸ€— ml-intern: an open-source ML engineer that reads papers, trains models, and ships ML models

    Python 1

  3. homo_silicus homo_silicus Public

    Forked from johnjosephhorton/homo_silicus

    Replication code for https://www.john-joseph-horton.com/papers/llm_ask.pdf

    TeX 1

  4. Practical-Machine-Learning-with-LightGBM-and-Python Practical-Machine-Learning-with-LightGBM-and-Python Public

    Forked from PacktPublishing/Practical-Machine-Learning-with-LightGBM-and-Python

    Practical Machine Learning with LightGBM and Python, published by Packt

    Jupyter Notebook 1

  5. Dolle Dolle Public

    Python

  6. programming_with_python_DLMDSPWP01 programming_with_python_DLMDSPWP01 Public

    This folder includes all python assignments respective of scopes of the course:1-Task assignment to found the idea functions 2- sales forecasting

    HTML