Skip to content
View shadow-byte-warrior's full-sized avatar

Block or report shadow-byte-warrior

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
Profile Views Followers Focus Open to Work
Public Repos Stars PRs Opened Open Source Contributor

🖥️ ~/arun-pandian $ whoami

class DataAnalyst(DataEngineer):
    def __init__(self):
        self.name        = "Arun Pandian"
        self.role        = "Data Analyst | SDE"
        self.location    = "Tamil Nadu, India 🇮🇳"
        self.core_stack  = ["Python (Pandas/NumPy)", "Advanced SQL", "DAX"]
        self.ecosystem   = ["Power BI", "Tableau", "Snowflake", "BigQuery", "n8n"]
        self.current     = "Architecting Local LLM Automation & Real-time Metrics Streaming ⚙️"

    def execute_workflow(self) -> str:
        return "Transforming unstructured data into predictive, actionable intelligence. 📊"

    def __repr__(self) -> str:
        return f"<{self.name} | {self.role} | building in public>"

print(DataAnalyst().execute_workflow())

🎯 Current Mission

  • 🔭 Dimensional Data Modeling & API Ingestion: Architecting scalable ETL pipelines and real-time dashboards.
  • 🌱 Deep-diving SQL Window Functions, CTEs, Power BI DAX Optimization, & Snowflake.
  • 🤝 Open to collaborate on Predictive Cohort Analysis, A/B Testing, & Data Storytelling.
  • 💼 Seeking my first Data Analyst / Data Engineer role — referrals welcome!

⚡ Quick Facts

  • 🧠 Engineered 13+ end-to-end analytics pipelines focusing on statistical significance and data normalization.
  • 🏗️ Mastered Zero-Macro Excel Engineering & Dynamic Array Dashboards for robust, maintenance-free reporting.
  • 🤖 Integrating Local LLM Data Automation (n8n, LangGraph, Ollama) directly into data workflows.
  • 💬 Ask me about ETL Optimization, Query Performance, & Interactive BI.

🧰 ~/arun-pandian $ ls ./tech-stack

💾 Data Engineering & Analytics


🤖 Applied AI / ML


🌐 Cloud & Automation

🛠️ Architecture & Workflow


📊 ~/arun-pandian $ analytics --dashboard

GitHub Stats Streak Stats Top Languages WakaTime

🏆 GitHub Trophies

Trophies

📈 Contribution Activity Graph

Activity Graph

🐍 Contribution Snake

Snake animation

🌍 ~/arun-pandian $ opensource --contributions

Open Source Stats



Merged PRs Issues Filed Repo Stars

🚀 ~/arun-pandian $ git log --featured-projects

📊 Unstructured Data Normalization

Reverse-engineered 90,000+ job postings utilizing advanced SQL Window Functions, CTEs, and cohort aggregations to decode the highest-ROI skill combinations for the modern tech stack.

PostgreSQL Window Functions Dimensional Modeling Data Storytelling

🧠 EEG Seizure Detection (Research)

Architected a DA-GRL framework on the CHB-MIT dataset implementing SHAP/LIME explainability for deep learning interoperability in healthcare AI (IEEE/Scopus publication pending).

PyTorch SHAP LIME Signal Processing

🤖 Local LLM Data Automation

Engineered an end-to-end API data ingestion pipeline using n8n and local GenAI models to automatically parse, score, and optimize resumes against live ATS metrics without compromising data privacy.

n8n API Ingestion Ollama / GPT-4o Automation

📈 Dynamic Array Dashboards

13+ enterprise-grade portfolio pipelines showcasing Power BI DAX optimization, Zero-Macro Excel Engineering, and actionable real-time BI deployment.

Power BI DAX Optimization Dynamic Arrays Python EDA


⚙️ ~/arun-pandian $ system --monitor

💻 Technical Domain 📊 Proficiency 🎯 Specialization
Advanced SQL ██████████ Advanced Window Functions & CTEs
Python (Pandas/EDA) █████████░ Advanced Unstructured Data Normalization
Power BI / DAX ████████░░ Proficient Interactive Data Storytelling
Excel Architecture ██████████ Advanced Dynamic Arrays & Zero-Macro Build
Snowflake / BigQuery █████░░░░░ Learning Dimensional Data Modeling
GenAI / Local LLM ████████░░ Proficient Privacy-first Automation (n8n)

🎓 ~/arun-pandian $ cat certifications.log

Swap these placeholders for your real credentials (e.g. Microsoft PL-300, Google Data Analytics, Snowflake SnowPro) — verified badges add real weight with recruiters.


✍️ Dev Quote of the Day

Dev Quote

🌐 ~/arun-pandian $ connect --with-me


💡 "Data is the new oil, but actionable insights are the refinery."

Pinned Loading

  1. Email-summarizer Email-summarizer Public

  2. XAI-Seizure-predicion-dashboard XAI-Seizure-predicion-dashboard Public

    Python

  3. Project_Analystics Project_Analystics Public

  4. Salary_Dashboard Salary_Dashboard Public