Pranav Nigam | Data Analytics Graduate

Pranav Nigam

Data Analytics Graduate

About

Hi, I'm Pranav Nigam – a recent data analytics graduate, data enthusiast, and problem-solver. I’m passionate about turning complex data into actionable insights that drive real-world results. With experience in data analytics, I’ve worked on streamlining processes and building interactive dashboards that make data more accessible and meaningful. I’m always eager to learn new skills and push the boundaries of data-driven innovation.

Skills

Projects

Financial Performance Analysis

Created an Excel dashboard for cash flow and revenue tracking, identifying a $60K projected decline by 2024. Developed a growth strategy to recover $100K through optimized pricing and upsell opportunities.

Executive Sales Analytics Dashboard

Developed a Tableau dashboard consolidating 10,000+ rows of data, enabling visualisation of key metrics. This led to a 36.2% YoY sales increase, 30.9% profit growth, and a 50% reduction in KPI review time. Delivered data-driven insights and strategic recommendations, driving faster decision-making.

Digital Marketing Strategy Optimization

Analyzed website traffic using SQL to identify sales funnel drop-offs, reducing abandonment rates by 18%. Investigated a 40% drop in mobile engagement, leading to a 25% increase in retention and higher conversion rates. Established a systematic SQL analysis approach, driving improved sales.

Strategic Marketing Insights via A/B Testing

Developed a testing framework for Facebook and AdWords ads, improving click-through rates and conversions. Conducted statistical analysis, including t-tests and linear regression, boosting engagement rates by 15%. Established benchmarks showing Facebook as the top platform for engagement.

Master's Thesis(Forecasting EPL Team Points)

My master's thesis focuses on leveraging predictive modeling to analyze and forecast outcomes in the English Premier League. This research underscores the potential of machine learning in sports analytics, offering valuable insights for football clubs, analysts, and enthusiasts.

Spotify User Music Preference

Developed a machine learning model to predict Spotify user preferences based on musical features like danceability and energy. Utilized data analysis and feature selection to implement Logistic Regression, achieving 84.6% accuracy with balanced precision and recall.

Experience

Jan, 2023 - April, 2023

Data Analyst Intern

Developed a web application that automated invoicing, reducing processing time and handling 1,000 additional invoices monthly. Optimized invoice data analysis workflows, improving finance collaboration and query resolution speed. Leveraged predictive analytics to enhance on-time payments and streamline cash management. Improved data collection processes, cutting processing time by 25% and boosting team efficiency.

Education

2023-2024

Master's in Data Analytics- Queen Mary University of London, UK

Queen Mary University of London is a leading institution known for innovation in research. My MSc program focuses on data manipulation, machine learning, and statistical analysis, with key modules like Python programming and financial data analytics.

2019-2023

Bachelor's in Electronics and Computer Science Engineering- KIIT, Bhubaneshwar, India

Completed a comprehensive B.Tech program with a focus on electronics and computer science, gaining strong technical skills in programming, data analysis, and engineering fundamentals.