Vaibhav Prakhar
Noida
Summary
I am an analytical Data/Business Analyst skilled in SQL, Excel, Power BI, KPI reporting, and insight generation. With experience working with large datasets, automating reports, performing root cause analysis, and collaborating with business teams, I improve processes and decision-making. I possess strong problem-solving skills and hands-on experience across analytics, reporting, and research
Overview
4
4
years of professional experience
Work History
Assistant Software Engineer
Qualix Information System LLP
07.2024 - Current
- Built & automated 25+ SQL/Excel dashboards for ATCC & VIDS, improving traffic insight visibility & incident monitoring.
- Analyzed 5M+ sensor records to uncover congestion patterns, improving anomaly detection response by 20%.
- Designed KPI frameworks for incident accuracy, reducing reporting discrepancies by 30%.
- Created BRDs, SOPs & reporting templates that reduced team onboarding time by 50%.
- Cleaned & validated large datasets from sensors & camera feeds, improving accuracy by 25–30%
Management Trainee
Jaro Education
01.2024 - 06.2024
- Conducted market & competitor research across 40+ EdTech programs to identify pricing gaps & product positioning.
- Analyzed applicant funnel data and improved conversion insights by 15–20%.
- Created structured insight reports on demand patterns, competitor trends, and ROI perceptions.
- Designed a repeatable research framework reducing turnaround time by 40%.
Business Operations
RentBro
06.2022 - 07.2022
- Analyzed customer behavior, rental cycles & demand trends to optimize product availability.
- Conducted competitor benchmarking (Furlenco-style) to assess category-level pricing & consumer patterns.
- Cleaned operational datasets & improved reporting accuracy by 25–30%.
- Built onboarding workflows & SOPs while supporting founders on process improvements.
Education
Integrated M.Tech -
Jaypee Institute of Information Technology
06.2024
Skills
- SQL
- Excel
- Pivot
- XLOOKUP
- Power Query
- Power BI
- Python
- Dashboarding
- KPI Reporting
- RCA
- Data Cleaning
- Market Research
- Funnel Analysis
- BRDs
- SOPs
- Process Mapping
- Cross-Functional Collaboration
Project
Product Analytics Project, User Engagement and Funnel Optimization,
- Built an end-to-end product analytics pipeline using SQL, Excel, and Power BI to analyze user behavior across signup, course view, application, and payment stages.
- Analyzed 50,000+ activity logs to identify bottlenecks, revealing a 14% drop-off between course views and cart additions.
- Developed 4 interactive dashboards (Engagement, Funnel, Revenue, RCA) showcasing DAU/WAU, funnel conversions, churn signals, and revenue
Training
NISM Series XV: Research Analyst, Ongoing, 2026
Timeline
Assistant Software Engineer
Qualix Information System LLP
07.2024 - Current
Management Trainee
Jaro Education
01.2024 - 06.2024
Business Operations
RentBro
06.2022 - 07.2022
Integrated M.Tech -
Jaypee Institute of Information Technology