Initializing Portfolio Engine...

About Me

I am a Data & Analytics Engineer specializing in real-time data pipelines, cloud data warehousing, ETL/ELT automation, and advanced SQL engineering. My expertise lies in BigQuery, GCP Dataflow, Apache Kafka, and Elasticsearch — helping businesses build highly scalable, intelligent, and automated analytical systems.

I transform raw datasets into powerful insights through well-engineered data models, automated workflows, and performance-tuned pipelines. My work blends engineering precision with analytical thinking to solve real-world business problems.

  • Python – Automation, Pandas, NumPy
  • SQL – Optimization, Stored Procedures
  • GCP – BigQuery, Cloud Functions, Dataflow, Pub/Sub
  • Kafka – Real-Time Streaming Pipelines
  • Elasticsearch – Indexing, Analytics
  • ETL/ELT – Pipelines & Automation
  • Power BI – Dashboards, KPIs
  • DevOps – Docker, Git
  • Contata Solutions — Data & Analytics Engineer
    Feb 2024 – Present

    • Engineered cloud warehouse for Jersey Mike’s used across 2,500+ stores.
    • Built real-time pipelines with GCP Dataflow, Pub/Sub & Cloud Functions.
    • Delivered BI dashboards & optimized SQL for enterprise clients.
    • Reduced ETL runtime by 40% via automation.
    • Implemented Kafka streaming integration.
    • Enhanced ISMS portal with RBAC, cutting reporting time by 60%.
    • Architected MIMS database with multi-filter reporting.

  • Schneider Electric — Global Student Experience Remote
  • GirlScript Summer of Code — Contributor
  • YBI Foundation — Data Analytics Intern
  • B.Tech CSE — KIET Group (CGPA 7.9)
  • Class 12 — 82%
  • Class 10 — CGPA 10
  • REIGN'23 – Finalist
  • DESIGNEX 2.0 – Finalist
  • NIRMITI IDEATHON – Finalist
  • GS1 US Hackathon – Winner
  • Sporjo Hackathon – Winner

My Services

Python Automation

ETL automation, workflow scripts, bots & analytics pipelines.

Data Engineering

BigQuery, GCP, Kafka, Elasticsearch, Cloud Functions, Dataflow.

Analytics

Power BI, KPIs, dashboards, statistical insights & reporting.

Web Development

Interactive, responsive websites with modern UI/UX.

My Work

Martis Photography

Premium portfolio for photographers.

Data Science Projects

Analytics on real-world datasets.

Telegram Chatbot

Real-time automated conversation bot.

Virtual Assistant

Python voice assistant with automation logic.

Contact Me

ayushsiloiya@gmail.com

+91 94******

Download Resume