Saurabh Gupta

Saurabh Gupta

Data Analyst Intern

Followers of Saurabh Gupta3000 followers
location of Saurabh GuptaBengaluru, Karnataka, India

Connect with Saurabh Gupta to Send Message

Connect

Connect with Saurabh Gupta to Send Message

Connect
  • Timeline

  • About me

    Data Analyst | Expert in SQL, Power BI, Python & Excel | Driving Data-Driven Decisions | Passionate About Transforming Data into Insights

  • Education

    • Nehru Balodyan Inter College, Jaunpur

      2013 - 2015
      Intermediate Physics, Chemistry, Mathematics
    • Modern Children Higher Secondary School

      2012 - 2013
      High School Diploma Mathematics and Computer Science
    • Veer Bahadur Singh Purvanchal University, Jaunpur

      2015 - 2018
      Bachelor Of Science Mathematics
    • International Institute of Information Technology Bangalore

      2021 - 2022
      Executive PG in Data Science
  • Experience

    • INeuron.ai

      Aug 2021 - Jun 2022
      Data Analyst Intern

      As a Data Analyst intern at iNeuron.ai, I worked on a comprehensive FIFA World Cup Analysis project, using historical data from 1930 to 2014 sourced from Kaggle. The project aimed to uncover insights on match outcomes, player patterns, cup holders, and home ground advantages.Key Responsibilities and Achievements:* Developed modular, testable, and maintainable code for data analysis, hosted on a public GitHub repository.* Maintained detailed project documentation, including High-Level and Low-Level Documents, Architecture, Wireframes, and Detailed Project Reports.* Created and shared a project demo video and LinkedIn post to showcase the project's findings and methodologies.* Utilized SQL, Excel, Power BI, and Python to analyze data and generate actionable insights.Skills Gained:* Advanced data analysis techniques* Effective code documentation and GitHub management* Enhanced presentation and communication skills through LinkedInProject Link:GitHub Repository - https://github.com/Saurabhgupta301/FIFA-World-CUP-Analysis Show less

    • LetsGrowMore

      Sept 2021 - Oct 2021
      Data Science Intern

      During my internship at LetGrowMore, I engaged in project-based work that honed my skills in SQL, Excel, Power BI, and Python. I analyzed datasets, developed dashboards, and collaborated with team members to achieve project goals. Additionally, I learned to effectively present my work on LinkedIn and added completed projects to my GitHub portfolio. This experience enhanced my technical skills and professional online presence.

    • The Sparks Foundation

      Sept 2021 - Sept 2021
      Data Analyst

      During my project-based internship at The Sparks Foundation, I utilized my skills in SQL, Excel, Power BI, and Python to analyze large datasets and develop interactive dashboards. I collaborated with the project team to define objectives, conducted research, and presented findings to stakeholders. My efforts resulted in enhanced data accuracy, improved decision-making processes, and positive feedback from supervisors.

    • C5i

      Oct 2022 - Jan 2025

      As an Analyst at C5i, I leverage my expertise in data analysis and business intelligence to drive data-driven decision-making and optimize business processes. With a strong foundation in SQL, Excel, Power BI, and Python, I manage and analyze large datasets to uncover actionable insights and support strategic initiatives.Key Responsibilities:* Develop and maintain comprehensive dashboards and reports using Power BI to provide real-time insights and track key performance indicators (KPIs).* Utilize SQL for querying databases, extracting data, and performing complex data manipulations to support various business functions.* Conduct in-depth data analysis using Excel to identify trends, patterns, and opportunities for process improvements.* Collaborate with cross-functional teams to understand business requirements and deliver data-driven solutions.* Present analytical findings and recommendations to stakeholders to facilitate informed decision-making.* Automate repetitive tasks using Python to enhance efficiency and accuracy in data processing and reporting.Achievements:* Improved data accuracy by 20% through strategic data cleansing, enhancing the reliability of monthly reporting.* Assisted in design and maintenance of Power BI dashboards for accurate and real-time data visualization.* Automated repetitive data extraction tasks, reducing processing time by 20%.* Streamlined data analysis by contributing in a new data management process, cutting down on processing time by 30%.* Utilized Excel and Power BI to transform raw data into meaningful business insights, leading to an increase in revenues by 15%. Show less As a Junior Analyst at C5i, I supported the data analysis and business intelligence functions by assisting in the management and analysis of large datasets. My role involved utilizing SQL, Excel, and Power BI to generate reports and insights that informed business decisions.Key Responsibilities:* Assisted in the development of dashboards and reports using Power BI to monitor key performance indicators (KPIs).* Used SQL to query databases and extract data for various analytical needs.* Performed data analysis in Excel to identify trends and generate insights for process improvements.* Supported cross-functional teams by providing data-driven insights and solutions.* Created and maintained documentation for data processes and analyses.Achievements:* Contributed to the development of a reporting system that improved data accessibility for stakeholders.* Played a key role in a project that enhanced data validation processes, reducing reporting errors by 10%.* Received positive feedback for my attention to detail and analytical skills. Show less

      • Analyst

        Apr 2024 - Jan 2025
      • Junior Data Analyst

        Oct 2022 - Mar 2024
  • Licenses & Certifications