Harsh Kumar Dixit

Data Analyst | Product Management | Business Intelligence
Bengaluru, IN.

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

RIGI
|

Data Analyst Intern

Summary

Collaborated cross-functionally to optimize marketing efforts within a Sequoia Capital-backed startup, earning a letter of appreciation for outstanding contributions.

Highlights

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.

YG Bridging Platform LLP (YourGuide - Mentorship platform)
|

Analyst

Summary

Conducted remote analysis to identify feature gaps and optimize development priorities for a mentorship platform.

Highlights

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.

P2P Microfinance & Allied Services
|

Business Analyst Intern

Summary

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.

Highlights

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.

RIGI
|

Consulting Project

Summary

Collaborated with the CEO in a team to present insights to stakeholders for a startup focused on creator monetization, earning a letter of recommendation.

Highlights

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

Birla Institute of Technology and Science, Pilani (Implicit)
|

Elected Hostel Representative

Summary

Elected representative, spearheading hostel initiatives for over 200 students.

Highlights

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.

DWDG (formerly ShARE)
|

Product Strategy & Market Consulting (Leadership Cohort)

Summary

Led a cross-cultural team of 6 to ideate, pitch, and develop a startup, ranking among the top 6 out of 40 global teams.

Highlights

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

B.E. (Hons.)

Electronics and Communication

Grade: 6.89 CGPA

City Montessori Inter College, Lucknow

Class XII

ICSE

Grade: 95.5% (top 4% of 440)

Certificates

Google Data Analytics Professional Certificate

Issued By

Google

Product Management Fellowship

Issued By

Next Leap

Skills

Programming & Databases

SQL, PostgreSQL, Python, Pandas, NumPy, BeautifulSoup, R Programming, MySQL.

Data Analysis & Visualization

Tableau, Metabase, Excel, Dashboarding, Data Cleaning, ETL Pipelines, Data-Driven Decision Making, Business Intelligence.

Product & Analytical Skills

User Research, KPI Definition, Problem Structuring, Hypothesis Testing, Market Research, User Experience (UX), Product Strategy.

Machine Learning

Random Forest Classifier, SMOTE, Scikit-learn, Cross-validation, Confusion Matrix, Classification Reports.

Projects

BookMyShow Product Case

Summary

Enhanced user experience for high-demand events through comprehensive product case study.

Customer Churn Prediction (Machine Learning)

Summary

Developed an ML-based customer churn prediction model.

ETL-Driven Sales Data Analysis and Visualization

Summary

Conducted comprehensive data analysis and business intelligence to visualize sales data.