Headline

Data Analyst · SQL · PostgreSQL · Python · Power BI · Tableau · dbt | Google Advanced Data Analytics Certified | 9 portfolio projects · 15 certifications (7× Google, 2× IBM) | Open to work

About

Data Analyst with ~1.5 years of hands-on experience delivering KPI dashboards, statistical anomaly detection, and root-cause investigations in logistics and operations. 🏆 Google Advanced Data Analytics Certified (May 2026) — completed all 7 courses of Google's Professional Certificate: Foundations of Data Science, Go Beyond the Numbers (EDA & Storytelling), The Power of Statistics, Regression Analysis, The Nuts and Bolts of Machine Learning, Capstone, and AI-Assisted Job Search. At Logistics Integrators Pvt. Ltd., I built SQL-based anomaly detection and threshold alerting on operational data, owned weekly Power BI dashboards tracking 10+ KPIs across freight operations as the single source of truth, and led root-cause analysis on shipment delays, turnaround drops, and cost overruns — partnering with 3–5 cross-functional teams to validate data, document SOPs, and ship corrective actions. Earlier, as an Operations Intern at Vrun Minerals, I performed inventory reconciliation and built deviation-highlighted dashboards on distributor data. What I bring beyond the job title: → 9 end-to-end portfolio projects on real datasets (1.2M+ records) — fraud detection (Z-score + IQR on 284K credit card transactions), RFM segmentation (800K retail rows), churn prediction (3 ML models, AUC 0.84), cohort analysis, ELT pipelines, financial integrity validation, and an Automatidata EDA capstone on 408K NYC taxi trips → 15 verifiable certifications — 7× Google (full Advanced Data Analytics Professional Certificate) · 2× IBM Credly badges (Python for Data Science, Data Analysis Using Python) · 2× Udemy (PostgreSQL Complete Developer's Guide 22 hrs, Mastering dbt 8 hrs) · 4× LinkedIn Learning → Stack: SQL · PostgreSQL · Python (Pandas, NumPy, scikit-learn) · R (tidyverse, randomForest) · Power BI · Tableau · dbt Core · Streamlit · Plotly · Excel · data integrity workflows · process automation Open to Data Analyst, Business Analyst, BI Analyst, Operations Analyst, and Analytics Engineer roles in India — remote, hybrid in NCR/Dehradun, or on-site for the right team. Immediately available. 📍 Dehradun, India · IST (UTC+5:30) · Americas-shift compatible 📧 joshisubham442@gmail.com 🔗 github.com/Zolow-kuni

Location

South West Delhi

Work experience

Management Trainee at Logistic Integrators (I) Pvt Ltd, Feb 2025 - Present · 1 yr 5 mos, Delhi, India, • Built SQL-based statistical anomaly detection and threshold-based alerting on operational and sales datasets, surfacing outliers before they impacted SLAs • Owned weekly Power BI dashboards tracking 10+ business KPIs across freight operations; established the single source of truth for cross-team reporting • Led root-cause analysis (RCA) on performance spikes — shipment delays, turnaround drops, cost overruns — partnering with 3–5 cross-functional teams to validate data and ship corrective actions • Designed conversion, funnel, and drop-off analysis on shipment journeys (start-to-delivery), informing operational interventions and process redesigns • Drove data quality and data integrity workflows: validation, reconciliation, ETL audit — eliminating reporting discrepancies across reporting systems • Automated recurring reporting workflows in Python (Pandas, NumPy), reducing manual effort and improving turnaround on weekly business reviews

Operations Intern at Vrun Minerals Pvt. Ltd., Mar 2024 - May 2024 · 3 mos, Mumbai, • Cleaned and validated distributor and sales datasets using Excel and Python (Pandas); built dashboards with deviation highlighting on inventory and sales trends • Performed inventory reconciliation and data accuracy checks across daily operations, reducing reporting errors and improving stock visibility • Documented data workflows and measurement requirements, improving transparency of metrics definitions for non-technical stakeholders • Conducted business trend analysis to generate actionable insights for supply-chain decisions

Education

Master of Business Administration - MBA, Operations Management and Supervision, IBS Mumbai

Bachelors in computer application, Shri guru ram rai Institute of technology