DEEPANSHU GARG

DEEPANSHU GARG

Lead Data Analyst
India
English, Hindi
Full-time On-site

About Me

Lead Data Analyst with nearly 8 years in business intelligence, SQL development and reporting for banking and financial-services, healthcare and enterprise clients, including reporting for Standard Chartered, HDFC Bank a…

Experience

Lead Data Analyst

Decision Tree Analytics · Gurugram
Jan 2023 - Present · 3 years 10 months

<p>Own SQL development on client enterprise data warehouses in Snowflake: write and tune complex SQL (CTEs, window functions, stored procedures) for transformation, reporting and validation.</p><p> Ran customer analysis whose findings informed strategy and reduced customer churn by 15%.</p><p> Built Power BI and Tableau dashboards that integrate multiple data sources and are tuned for performance.</p><p> Deliver end-to-end operational dashboards for a US food-distribution client, from wireframe and SQL data model to deployed Streamlit-in-Snowflake app.</p><p> Enforced data-quality checks and SQL validation rules that improved the consistency of reporting across sources.</p><p> Built a Lineage & ER Explorer (Streamlit in Snowflake) that maps table relationships and data lineage across a production EDW, so teams can trace data to source and assess the impact of changes.</p><p> Built and optimised SQL-based ETL pipelines on Snowflake, with Python (Pandas, NumPy) for data processing and automation.</p><p> Automated backup of all Tableau Server dashboards and data sources in Python on the Tableau REST API, preserving project structure, exporting views to PDF and logging every run.</p><p> Built reusable LLM-driven workflows (AI skills) that turn dashboard wireframes into working Streamlit apps, cutting build time for new dashboards.</p><p> Mentor junior analysts on SQL, visualisation and performance tuning.</p>

Senior Data Analyst

CRG Solutions · Gurugram
May 2021 - Jan 2023 · 1 year 8 months

<p>Led BI and data-prep teams delivering for clients in technology, finance and healthcare.</p><p> Designed star schemas and cubes on SQL Server, using indexes and stored procedures to improve query performance.</p><p> Extracted and joined data from multiple sources with SSIS.</p><p> Migrated SQL Server workloads to AWS (S3, Lambda, EC2).</p><p> Defined key metrics and built the Tableau dashboards and reports that tracked them for business-transformation work.</p>

Data Analyst

MN&BI · Gurugram
Dec 2018 - Apr 2021 · 2 years 4 months

<p>Produced transaction and account reports for Standard Chartered, Axis Bank and HDFC Bank.</p><p> Built dashboards used by media relations, HR and legal teams for decision-making.</p><p> Analysed large datasets using advanced querying and visualisation tools.</p>

PROJECTS

ICU Mortality Prediction with Explainable AI

Liverpool John Moores University (MSc Data Science)
Duration : 01-Jan-2026 - 31-Mar-2026

<p>• Built machine-learning models (XGBoost and LSTM) to predict mortality risk for ICU patients, achieving an AUROC of about 0.89.</p><p>• Applied Explainable AI methods (SHAP and LIME) to show which patient factors drive each prediction, so the results can be interpreted and not just scored.</p><p>• Handled the full workflow in Python: data preparation, feature engineering, model training, evaluation and explanation.</p><p>• Published the research as part of my MSc in Data Science (completed 2026).</p>

Certifications

Tableau Desktop Certification

Tableau · Delhi , Delhi , India · 2021

Skills

Power BI Tableau Streamlit in Snowflake Alteryx Excel KPI Reporting Management Reporting SQL Advanced SQL CTEs Window Functions Stored Procedures Query Optimisation Snowflake SQL Server Dimensional Modelling Star Schema Facts & Dimensions Cubes ETL ELT SSIS Data Integration Data Validation Data Reconciliation Data Lineage Python Pandas NumPy scikit-learn REST API Automation LLM Workflow Automation Machine Learning Explainable AI SHAP LIME AWS S3 Lambda EC2 GCP Team Leadership Mentoring Client Delivery Stakeholder Reporting
Report this Profile?