About
Data Analyst with 3+ years of experience in SQL, Power BI, and Snowflake, specializing in query optimization, ETL automation using Snowpipe, and data modeling across EV and EdTech domains. Experienced in building scalable data pipelines on Snowflake using AWS S3 and cloud platforms, and developing interactive dashboards in Power BI and Tableau to deliver actionable business insights. Strong expertise in performance tuning, window functions, stored procedures, triggers, and ensuring data quality and integrity across enterprise applications. Proven ability to analyze operational and product data to track KPIs, improve reporting efficiency, and support data-driven decision making.
Skills & Expertise (30)
Work Experience
Data Analyst
OLA Electric (Payroll at Scatterpie Analytics & Orcapod)
Nov 2024 - Present
Automated data ingestion from AWS S3 into Snowflake using Snowpipe, later migrated to Krutrim cloud. Designed star schema models and optimized SQL queries for EV service and product datasets. Built interactive Tableau dashboards (migrated from Power BI) for leadership reviews. Tuned queries using clustering keys, window functions, and caching to reduce refresh time by 40%. Delivered daily KPI dashboards tracking service TAT, customer satisfaction, OTA success rate, and vehicle performance trends. Monitored vehicle charging behavior, repeated service issues, and GTM rollout impact using Snowflake analytics.
Data Analyst
NxtWave Disruptive Technologies
Mar 2024 - Nov 2024
Automated ingestion of CRM and marketing datasets into Snowflake using Snowpipe, enabling near real-time reporting. Developed optimized SQL queries to analyze demo session attendance, counselor performance, and enrollment conversion trends. Designed and maintained Power BI dashboards to track lead quality, attendance rate, and conversion KPIs for management reporting. Automated daily reporting workflows, reducing manual reporting effort and improving data availability for business teams. Implemented triggers and validation logic to improve accuracy of attendance and student activity data. Delivered actionable insights on conversion patterns and lead quality to support sales and marketing decisions. Improved reporting turnaround from 1 day to 2 hours.
Associate Data Analyst
Focus Edumatics
Jan 2023 - Jan 2024
Implemented Snowpipe pipelines to ingest student progress and tutor quality data into Snowflake. Created fact and dimension tables in Snowflake to monitor academic performance trends. Added basic PL/SQL procedures and triggers for attendance validation and opt-out record backups. Automated weekly and monthly academic summary reports using SQL workflows. Built Power BI dashboards to visualize tutor efficiency and student outcomes. Delivered daily metrics: student attendance %, tutor efficiency scores, subject wise performance improvement.
Education
Bachelor of Engineering – Electronics & Communication Engineering - Hindusthan Institute of Technology
2014 - 2018 · Afghanistan
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
