Gaurav Gaira
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.
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.
Skills 0 proven through work
Also works with
Proof of Work
Proof of Work
Gaurav shares this with people who ask. You'll hear back either way.
Education
MCA, AI/ML
Chandigarh University · NaN — NaN
B.Sc., Mathematics
Kumaun University, Nainital · NaN — NaN
PG Data Science Certificate, Data Science
IIT Guwahati · NaN — NaN
Microsoft Azure Cloud Certificate, Azure Cloud
Udemy · NaN — NaN
Contact details
Contact details
Gaurav shares this with people who ask. You'll hear back either way.
What drives their work
The Architect
You build robust systems and structured processes to drive clear, measurable outcomes.
Gaurav's superpower
You excel at transforming complex, unstructured data into actionable insights through systematic design and implementation.
How Gaurav works
You would excel in a team that values structured approaches, data-driven decision-making, and continuous innovation, especially in roles with increasing product ownership.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal