Experience

Data Analyst Intern – KultureHire

Dec 2023 – Feb 2024

  • Utilized Excel (VLOOKUP, INDEX, MATCH, Pivot Tables, Conditional Formatting, Macros) to create multiple dashboards and PowerBI (Measures, Power query) to develop dashboards using extensive data from multiple tables, each containing 3000+ records.
  • Managed end-to-end data analysis, including data collection through Google Forms, MYSQL-based analysis, dashboards in Power BI and storytelling for insightful presentations. Provided meaningful employer recommendations with a narrative emphasis.
See Internship Projects here!

DATA ANALYST INTERN – CognoRise InfoTech

Jan 2024

  • Analyzed nutritional content in a cereal dataset using Python (pandas, matplotlib, seaborn), extracting key insights and communicating findings through effective data visualization.
  • Utilized SQL skills for data manipulation and analyzed 8500+ rows of dataset, utilizing CASE statements, aggregations, window functions, and CTEs in a complex retail dataset.
  • Designed and implemented an interactive Power BI dashboard to visualize unemployment trends in India, transforming raw employment data into meaningful visualizations.
See Internship Projects here!

Data Analyst Intern – Psyliq

Dec 2023 – Jan 2024

  • Analyzed a 100,000+ row diabetes dataset using PostgreSQL, extracting key insights for enhanced healthcare data understanding.
  • Manipulated a 4000-employee dataset in Excel, utilizing VLOOKUP, INDEX, MATCH, and Macros to streamline processes and boost efficiency.
  • Conducted detailed analysis of a 4400+ row HR dataset with Excel and Power BI (DAX, Relationship Establishment, Data Visualization). Delivered actionable insights for informed decision-making.
See Internship Projects here!

Data Analyst Intern – MeriSkill

Nov 2023 – Dec 2023

  • Analyzed 185,000+ rows of sales data using Power BI, identifying trends, top-selling products, and calculating revenue metrics. Used data manipulation for effective visualizations, aiding strategic decision-making.
  • Cleaned and transformed HR data in Power BI, including data grouping, column operations and duplicate handling. Utilized Power BI for visualizing correlations between HR factors, enhancing talent management and organizational performance.
See Internship Projects here!

Student Researcher – Lovely Professional University (Part-time)

Jun 2020 - May 2023

  • Published two impactful scientific papers in international journals during undergraduate and postgraduate studies.
  • Conducted rigorous mathematical analysis using MATLAB and Excel, presenting findings at global conferences like RAFAS 2021 and RAFAS 2023.

Publications

Private Tutor (Self Employed)

Jan 2019 – May 2021

  • Empowered 15-20 high school students (grades 9-12) through targeted Mathematics tutoring, achieving a noteworthy 15-20% improvement in academic performance.
  • Applied data-driven insights to customize lesson plans, resulting in consistent marks between 75-90 and earning positive feedback from students and parents, showcasing adept analytical and communication skills.

But, How these pieces fit into your puzzle?

  • Data Analyst Intern at KultureHire:

    I can transform your data into clear, actionable insights, empowering you to make smarter hiring decisions, reduce turnover, and build a high-performing team.

  • Data Analyst Intern at CognoRise InfoTech:

    I can unlock hidden gems in your data, like uncovering previously unknown customer segments or optimizing pricing strategies, to boost your bottom line and gain a competitive edge.

  • Data Analyst Intern at Psyliq:

    I've worked on healthcare, employee, and HR data (100k+ rows!). By wielding SQL, Excel and Power BI, I can uncover cost-saving opportunities, optimize patient care, and build a healthier workforce.

  • Data Analyst Intern at MeriSkill:

    I can turn your sales and HR data into a powerful growth engine, helping you maximize revenue, identify top talent, and build a thriving, efficient organization.

  • Student Researcher at Lovely Professional University:

    My proven ability to tackle complex problems and communicate findings effectively will translate into solving your toughest data challenges and driving innovation within your business.

  • Private Tutor:

    My experience tailoring solutions to individual needs ensures I can create customized data analysis strategies that address your unique business challenges and optimize performance.

About Me

Dive into my world where numbers meet colors – come, get to know me!

Learn more

Projects

Every dataset tells a story. Let's dive into mine and discover how I bring data to life!

Learn more