# Harsh Kumar Dixit - Data Analyst | Product Management | Business Intelligence
Source: https://hello.cv/harshdixit
Bengaluru

## Links
- LinkedIn | https://www.linkedin.com/in/harshkumardixit96/

## About
Highly analytical and results-oriented professional with a strong foundation in data analysis, product management, and business intelligence. Proven ability to leverage data-driven insights to optimize performance, drive strategic growth, and enhance user experience. Adept at leading cross-functional teams, developing innovative solutions, and delivering quantifiable impact, as demonstrated by optimizing ad performance by 30%, reducing loan defaults by 40%, and boosting creator acquisition by 25%.

## Work
### Data Analyst Intern | RIGI
Collaborated cross-functionally to optimize marketing efforts within a Sequoia Capital-backed startup, earning a letter of appreciation for outstanding contributions.
- Optimized digital ad performance by 30% through real-time analysis of Google and Meta Ads data using PostgreSQL.
- Developed interactive Metabase dashboards to monitor over 20 key performance indicators (KPIs) and critical ad metrics (L0, L1, L2), enhancing data-driven decision-making.
- Reduced query execution time by 50% by optimizing PostgreSQL queries and implementing materialized views, significantly improving system performance and cost efficiency.
- Decreased webinar costs by 20% through comprehensive analysis of license usage data and strategic resource allocation.
- Enhanced user tracking capabilities by recommending Google Analytics parameters to monitor over 10 key metrics, leading to improved behavioral and user flow analysis.
### Analyst | YG Bridging Platform LLP (YourGuide - Mentorship platform)
Conducted remote analysis to identify feature gaps and optimize development priorities for a mentorship platform.
- Conducted in-depth analysis of user flows across 25+ competitor platforms to identify critical feature gaps and inform product development priorities.
- Proposed and designed user flow enhancements and new features, significantly improving user experience (UX) and strengthening cross-functional product strategy.
### Business Analyst Intern | P2P Microfinance & Allied Services
Reported directly to the Managing Director and conducted extensive on-ground research, earning a letter of recommendation for outstanding contributions at an NBFC offering small loans.
- Developed an NPA (Non-Performing Asset) Reduction Model for cattle loans, leveraging supply chain insights to potentially reduce loan defaults by 40%.
- Mapped the end-to-end milk supply chain by engaging over 15 diverse stakeholders, from cattle farmers to distributors, to identify critical cash flow gaps.
- Proposed strategic interventions to stabilize earnings for cattle farmers and enhance loan repayment capacity.
### Consulting Project | RIGI
Collaborated with the CEO in a team to present insights to stakeholders for a startup focused on creator monetization, earning a letter of recommendation.
- Conducted a comprehensive analysis of the Creator Market, researching over 10 competitors, identifying strategic gaps, and contributing to a 20% market share increase.
- Developed and proposed over 9 growth strategies, resulting in a 25% increase in creator acquisition and improved user engagement metrics.

## Volunteer
### Elected Hostel Representative | Birla Institute of Technology and Science, Pilani (Implicit)
Elected representative, spearheading hostel initiatives for over 200 students.
- Led welfare and cultural initiatives for over 200 students, organizing successful hostel events and serving as the Point of Contact for an inter-hostel festival.
- Drove significant infrastructure and engagement improvements through the successful execution of festive contests and student-focused initiatives.
### Product Strategy & Market Consulting (Leadership Cohort) | DWDG (formerly ShARE)
Led a cross-cultural team of 6 to ideate, pitch, and develop a startup, ranking among the top 6 out of 40 global teams.
- Conducted over 90 surveys and analyzed 4+ distinct market segments to identify strategic opportunities and refine go-to-market strategies.
- Designed a scalable revenue model, addressing 3 key user needs and targeting 2 growth areas through comprehensive market research.

## Education
### Birla Institute of Technology and Science, Pilani | Electronics and Communication
6.89 CGPA
### City Montessori Inter College, Lucknow | ICSE
95.5% (top 4% of 440)

## Certificates
### Google Data Analytics Professional Certificate
Google | 2025-01-31
### Product Management Fellowship
Next Leap | 2024-09-30

## Skills
### Programming & Databases
Expert
- SQL
- PostgreSQL
- Python
- Pandas
- NumPy
- BeautifulSoup
- R Programming
- MySQL
### Data Analysis & Visualization
Expert
- Tableau
- Metabase
- Excel
- Dashboarding
- Data Cleaning
- ETL Pipelines
- Data-Driven Decision Making
- Business Intelligence
### Product & Analytical Skills
Proficient
- User Research
- KPI Definition
- Problem Structuring
- Hypothesis Testing
- Market Research
- User Experience (UX)
- Product Strategy
### Machine Learning
Proficient
- Random Forest Classifier
- SMOTE
- Scikit-learn
- Cross-validation
- Confusion Matrix
- Classification Reports

## Projects
### BookMyShow Product Case
Enhanced user experience for high-demand events through comprehensive product case study.
### Customer Churn Prediction (Machine Learning)
Developed an ML-based customer churn prediction model.
### ETL-Driven Sales Data Analysis and Visualization
Conducted comprehensive data analysis and business intelligence to visualize sales data.

## Source
Read this profile on Hello.cv: https://hello.cv/harshdixit
Create your free profile at https://hello.cv