Gaurav Gaira

+•• ••••• •••••••••••@•••••.com

Data Analyst · Drishtee (DBCPL) · 4.3 yrs

As a Data Analyst with 4.5 years of experience, I am driven by a deep curiosity and ambition to achieve mastery in understanding complex data. My autonomous and insightful approach ensures I rigorously apply logical and pragmatic thinking to uncover meaningful patterns and deliver impactful, data-driven solutions.

  • Hybrid, Remote, On-site
  • In 30 days

Ask about Gaurav

Skills

Claimed

Work EfficiencyStructured Work ApproachTeam LeadershipBusiness IntelligenceSales AnalysisStudent Performance AnalysisProfitability AnalysisComparative Performance AnalysisCampaign Performance AnalysisMeta Ads ReportingSupply Chain AnalysisAI Model Configuration

Proof of Experience

Data Analyst

Drishtee (DBCPL) · Aug 2025 – Present

  • Delivered SQL, Power BI, and Python-based analytics and Bl reporting on large, multi-source datasets, generating actionable insights across Sales, Supply Chain, and CSP to support faster business decisions and contributing to an estimated 30% improvement in sales performance.
  • Built and maintained a Python/PySpark ETL warehouse (Bronze-Silver-Gold) on Azure ADLS Gen2, orchestrated via ADF, integrating 10+ source systems and reducing report turnaround from next-day to same-day, while saving around 12 hours/week of manual reporting.
  • Strengthened fraud monitoring by converting transaction data into live operational insights, identifying suspicious SKU/customer/transaction patterns through SQL and Power Bl and contributing to a ~70% reduction in manual fraud-review workload.
  • Conducted root-cause analysis, trend analysis, variance analysis, and KPI monitoring to identify why business performance changed, enabling stakeholders to focus on the underlying drivers rather than simply reviewing historical numbers.
  • Designed a GenAl-powered ETL workflow (Python + OpenAl GPT-40) that auto-cleaned and standardized SCM product master data into structured JSON, improving downstream data quality and cutting manual data-cleaning effort.

Data Analyst

Pinnacle Civil Services · Oct 2023 – Apr 2025

  • Built Power BI dashboards tracking regional and medium-wise KPIs for 1 lakh+ students performance, book sales, and return-rate trends used directly by leadership for business decisions.
  • Built a Python/SQL/Airflow ETL pipeline to ingest and clean student data across sources, resolving duplicate and missing records to improve reporting reliability.
  • Built advanced Excel reporting tools for task tracking and Meta Ads campaign analysis, improving team reporting efficiency by 30%.

Lead SME (Maths)

Pinnacle Publication · Mar 2022 – Sep 2023

  • Managed subject matter expert responsibilities for mathematics education.

Proof-of-Work

No completed sessions yet. Anything Gaurav finishes shows up here with the evidence behind it.

Proof of Education

MCA, AI/ML

Chandigarh University

B.Sc., Mathematics

Kumaun University, Nainital

PG Data Science Certificate, Data Science

IIT Guwahati

Microsoft Azure Cloud Certificate, Azure Cloud

Udemy

A Proof CV — one profile, kept current, with the proof attached. Back to the portal