GG

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.

Work style

Hybrid, Remote, Onsite

Availability

Available in 30 days

Contact details — on requestProof of Work — on request

Experience

D

Data Analyst

Drishtee (DBCPL) · Aug 2025 – Present

Not yet confirmed
  • 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.
P

Data Analyst

Pinnacle Civil Services · Oct 2023 – Apr 2025

Not yet confirmed
  • 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%.
P

Lead SME (Maths)

Pinnacle Publication · Mar 2022 – Sep 2023

Not yet confirmed
  • Managed subject matter expert responsibilities for mathematics education.

Skills 0 proven through work

Also works with

Work EfficiencyStructured Work ApproachTeam LeadershipBusiness IntelligenceSales AnalysisStudent Performance AnalysisProfitability AnalysisComparative Performance AnalysisCampaign Performance AnalysisMeta Ads ReportingSupply Chain AnalysisAI Model ConfigurationBatch Processing ImplementationPrompt EngineeringLarge Language Model ConceptsChatGPT UsageTabular Data Cleaning & ValidationMCP Server DevelopmentAI Tools UsageAzure DeploymentETL Pipeline DevelopmentMicrosoft ExcelReport CustomizationReal-time Reporting System DevelopmentSQL ProgrammingPower BIExploratory Data Analysis (EDA)

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 — Builds what holds

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