Available for Full-Time

Vaibhav

Data Analyst

Transforming complex datasets into actionable business insights.

Data Analyst specializing in SQL, Python, Excel and Power BI. I build dashboards, automate reporting and uncover insights that help businesses make faster, data-driven decisions.

SQLPythonPower BIExcelPandasNumPy
View ProjectsDownload ResumeContact Me
Vaibhav Chauhan, Data Analyst

Data Analyst

Coerror ’26

Data tells stories.
I write the narrative.

B.Tech Computer Science (Data Science) graduate from Parul University, 2026. I spent my internship at Coerror turning messy product data into Power BI dashboards adopted across 3 teams — cutting report time by 40% and feeding production ML models.

I bridge raw datasets and the boardroom. Whether that’s writing optimized MySQL queries, building anomaly detection systems in Python, or telling a story through a dashboard — I care about the outcome, not just the output.

Currently seeking Data Analyst / ML Engineer roles in Delhi NCR or remote. If you’re working on data problems that matter, let’s talk.

Specializing in

Delhi, IndiaGraduating 2026Open to WorkB.Tech · Data Science

The toolkit behind the analysis

From SQL optimization to BI dashboards and ML systems — a stack built for turning data into decisions.

◆ core focus·linked skills jump to the project that used them

Analytics & BI

Power BIUsed in: Sales & Operations Analytics Dashboard, KPI Reporting AutomationDAX & Data ModelingUsed in: Sales & Operations Analytics DashboardExcelUsed in: Sales & Operations Analytics DashboardGoogle SheetsTableau

Databases & SQL

MySQLUsed in: Sales & Operations Analytics Dashboard, KPI Reporting AutomationPostgreSQLUsed in: LogGuardian — Operational Anomaly DetectionQuery OptimizationUsed in: KPI Reporting AutomationWindow FunctionsUsed in: KPI Reporting AutomationCTEs & Complex JoinsUsed in: KPI Reporting Automation

Programming & Libraries

PythonUsed in: LogGuardian — Operational Anomaly Detection, Data Quality & Imputation Pipeline, Sales & Operations Analytics DashboardPandasUsed in: LogGuardian — Operational Anomaly Detection, Data Quality & Imputation Pipeline, Sales & Operations Analytics DashboardNumPyUsed in: Data Quality & Imputation PipelineMatplotlib & SeabornUsed in: Data Quality & Imputation PipelineC++ / DSA

Statistics & Analysis

Exploratory Data AnalysisUsed in: Sales & Operations Analytics Dashboard, Data Quality & Imputation PipelineDescriptive StatisticsUsed in: Data Quality & Imputation PipelineHypothesis TestingTrend AnalysisUsed in: Sales & Operations Analytics DashboardData InterpretationUsed in: Sales & Operations Analytics Dashboard

Machine Learning

Data Cleaning & ImputationUsed in: Data Quality & Imputation PipelineScikit-learnUsed in: LogGuardian — Operational Anomaly DetectionFeature EngineeringUsed in: LogGuardian — Operational Anomaly DetectionAnomaly DetectionUsed in: LogGuardian — Operational Anomaly DetectionModel EvaluationUsed in: LogGuardian — Operational Anomaly Detection

Workflow & Communication

Data StorytellingUsed in: Sales & Operations Analytics DashboardStakeholder ReportingUsed in: Sales & Operations Analytics DashboardReporting AutomationUsed in: KPI Reporting AutomationFastAPI (data serving)Used in: LogGuardian — Operational Anomaly DetectionGit & GitHub

Where I turned data into outcomes

Data Science Intern

internship

Coerror·Gurgaon, India

Jan 2026 – Apr 2026

  • Designed and delivered 4 Power BI dashboards tracking core product KPIs—adopted by 3 cross-functional teams, replacing weekly manual Excel reports and saving ~5 hrs/week of analyst time.
  • Wrote optimised MySQL queries for reporting workflows, cutting KPI dashboard refresh time by ~40% and enabling real-time business monitoring for the first time.
  • Resolved 30%+ missing-value rate across 5+ raw datasets via Python & Pandas data-cleaning pipelines—directly improving reliability of downstream ML model inputs.
  • Conducted deep-dive EDA across product and operations data, surfacing 3 actionable trends (seasonality, user drop-off, anomaly clusters) presented to senior leadership.
  • Automated weekly analytical reporting workflow, reducing ad-hoc data requests from stakeholders by standardising metrics definitions and delivery cadence.
  • Partnered with engineering to define data schemas and validate pipeline outputs, ensuring analytical accuracy for KPI tracking and business reviews.
Power BIMySQLPythonPandasEDAReporting Automation
View Internship Certificate

Shipped, not just sketched

Real builds with measurable outcomes — from BI dashboards to ML anomaly detection.

Sales & Operations Analytics Dashboard cover
Power BI

Sales & Operations Analytics Dashboard

End-to-end analytics pipeline from raw transactional data to a multi-page interactive Power BI dashboard.

Power BI·DAX·MySQL·Python
Code Live
LogGuardian — Operational Anomaly Detection cover
Machine Learning

LogGuardian — Operational Anomaly Detection

Hybrid ML anomaly detection (Isolation Forest + Autoencoder) on system logs, with a PostgreSQL analytics layer and FastAPI endpoints.

Python·Scikit-learn·Autoencoder·PostgreSQL
Code
Data Quality & Imputation Pipeline cover
Python

Data Quality & Imputation Pipeline

A Python/Pandas pipeline that profiles missing-value patterns and applies targeted imputation to make datasets ML-ready.

Python·Pandas·NumPy·Matplotlib
Code
KPI Reporting Automation cover
SQL

KPI Reporting Automation

Automated the weekly analytical reporting workflow with optimized SQL and standardized metric definitions.

MySQL·Window Functions·CTEs·Power BI
Code
India General Election 2024 Dashboard cover
Power BI

India General Election 2024 Dashboard

Interactive Power BI dashboard visualizing India's 2024 General Election across all 543 constituencies — seat distribution, alliances, and vote margins.

Power BI·DAX·Data Modeling
Code
Financial Risk & Fraud Detection Dashboard cover
Power BI

Financial Risk & Fraud Detection Dashboard

Executive Power BI dashboard that flags suspicious transactions and tracks fraud KPIs, alerts, and high-risk customers in real time.

Power BI·Power Query·DAX
Code
Netflix Content Analytics cover
Tableau

Netflix Content Analytics

Tableau dashboard exploring Netflix's movie and TV catalog by genre, rating, country, and release year.

Tableau·Python·Pandas·SQL
Code
Blinkit Sales Performance Dashboard cover
Excel

Blinkit Sales Performance Dashboard

Interactive Excel dashboard turning 8,523 Blinkit grocery-sales records into outlet, inventory, and customer-rating insights.

Excel·Pivot Tables·Slicers·Conditional Formatting
Code
Sales & Revenue Analysis Dashboard cover
Power BI

Sales & Revenue Analysis Dashboard

Power BI dashboard tracking sales, profit, and customer behavior with dynamic slicers across regions and product categories.

Power BI·Power Query·DAX·Data Modeling
Code

Validated, not just claimed

Every credential links to the verifiable certificate — tap to open, or hover to expand on desktop.

Data Analytics & Visualization Job Simulation
Verified

Data Analytics & Visualization Job Simulation

Accenture · 2023

View Certificate
Data Structures & Algorithms
Verified

Data Structures & Algorithms

CodeHelp · 2023

View Certificate
Tableau Workshop
Verified

Tableau Workshop

Parul University · 2025

View Certificate

Academic foundation

Parul University

Data Science

B.Tech in Computer Science & Engineering

Vadodara, Gujarat, India

2022 – 2026

Questions, answered

Currently based in Delhi. Open to remote roles or relocation for the right opportunity — especially within India (Bangalore, Hyderabad, Mumbai) or hybrid in Delhi NCR.

Let's Build Something with Data

Whether it’s a job opportunity, freelance project, or just a conversation about data — I’m reachable below.

vaibhav1chauhan12353@gmail.com
+91 9867732204
Delhi, India
Home
About
Projects
Contact
Resume
Theme