Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

My Experience

Certificates

Contact

sumit kumar

sumit kumar

Student , looking for opportunities

[email protected] +91 8054991472
Resume

Hello, I am

sumit kumar.

1

PowerBI
Project

1

Python
Project

About Me

Welcome to my portfolio! I'm a dedicated aspiring Data Analyst with a robust foundation in Electrical Engineering, holding a degree in this field. My journey in data analysis began when I discovered my passion and natural abilities in uncovering actionable insights from complex data sets. My proficiency spans across Excel, PowerBI, SQL, and Python, allowing me to deliver precise and impactful data-driven solutions.

My experience with Mondelez International has honed my analytical skills, providing me with the practical know-how to tackle real-world business challenges. Beyond my professional role, I have successfully completed several business projects, demonstrating my ability to apply analytical techniques to drive strategic decision-making.

In my portfolio below, you'll find a showcase of these projects, each highlighting my analytical prowess and commitment to excellence. I am excited about the opportunity to bring my skills to a dynamic team and contribute to data-driven success

Key Skills

SQL

Python

Business Analyst

Data Analyst

Project Management

Problem Solving

My Projects

Business Insights 360
Business Insights 360
Hotel Domain Analysis using Python
Hotel Domain Analysis using Python

Domain/Function: Hotel Domain Analysis using Python

My Experience

Jan 2024 - May 2024
Mondelez International, Baddi – Engineering Intern

  • Developed Monitoring and Data Entry System: Designed and implemented a website and mobile application to digitize data collection for departments  transitioning from manual logbooks to a digital platform. Utilized HTML, CSS, JavaScript, and Firebase for development.

    • Outcome: Improved data accuracy and operational efficiency, with real-time data access enhancing decision-making processes.
  • Electricity Consumption Analysis: Conducted a comprehensive electricity load mapping exercise to analyze and optimize energy consumption across the plant.

    • Methodology: Collected data on electrical equipment, measured load using power analyzers, and analyzed patterns to identify inefficiencies.
    • Outcome: Identified outdated motors and inefficiencies, leading to recommendations for equipment upgrades, load balancing, and the implementation of an energy management system. Achieved a detailed understanding of electricity distribution, paving the way for significant energy savings.
  • Motor Replacement Project: Analyzed the potential benefits of replacing existing motors with IE4 energy-efficient motors. Contacted ABB for requirements, calculated payback periods, and performed ROI analysis.

    • Outcome: Projected significant energy savings and reduced operational costs by adopting more efficient motor technology. Presented findings to senior management, demonstrating a clear path to operational improvements.

Awards & Certificate

SQL for Data Science

SQL for Data Science

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.