Data Analytics Intern - Excel, MySQL, Python

MEDAPATI JAGAN MOHAN REDDY

Andhra Pradesh +91-789******* *******************@*****.*** LinkedIn: medapati-jagan-mohan-reddy-497854354 github.com/mohan4567

CAREER OBJECTIVE

Detail-oriented B.Tech Computer Science graduate seeking a Data Analytics Internship to apply strong skills in Microsoft Excel, MySQL, Python, data analysis, and visualization. Experienced in developing interactive dashboards and transforming data into meaningful insights to support data-driven decision-making. Eager to contribute analytical and problem-solving skills while gaining practical experience in a professional data analytics environment. CORE DATA ANALYTICS SKILLS

Data Analysis • Data Cleaning • Data Visualization • Excel Dashboard Development • KPI Reporting • Pivot Tables • Pivot Charts • Data Validation • Sorting & Filtering • Conditional Formatting • XLOOKUP/VLOOKUP • Reporting & Insights • Data Accuracy • Problem Solving • Attention to Detail

TECHNICAL SKILLS

Data Analytics: Microsoft Excel, Data Analysis, Data Visualization, Reporting Excel: Excel Formulas, Pivot Tables, Pivot Charts, XLOOKUP/VLOOKUP, Data Validation, Conditional Formatting Programming: Python

Database: MySQL

Tools: Microsoft Excel, Google Sheets, Microsoft Word, GitHub Web: HTML, CSS, JavaScript, Django, Django REST Framework EDUCATION

B.Tech (Computer Science & Engineering) — Swarnandhra College of Engineering and Technology 2022–2026 CGPA: 7.3

Intermediate (MPC) — Aditya Junior College 2020–2022 CGPA: 5.8 SSC — Bhashyam School 2019–2020 CGPA: 9.5

INTERNSHIP EXPERIENCE

MERN Full Stack Development Intern — SmartBridge (Virtual Internship) Internship

Worked on a rental home platform involving REST APIs and database integration.

Implemented CRUD operations and authentication features.

Collaborated on responsive web interface development.

Applied structured data handling and problem-solving practices during project development. ACADEMIC PROJECTS

Monthly Sales Analytics Dashboard – Awesome Chocolates Microsoft Excel

Developed an interactive Excel dashboard to analyze monthly sales performance, shipments, boxes sold, and salesperson performance.

Created KPI summaries for Total Sales, Total Boxes, Total Shipments, and Sales per Person.

Analyzed sales performance by geography and product category using charts and visualizations.

Created a salesperson performance table to compare sales, boxes sold, and shipments and identify top-performing employees.

Transformed sales data into clear visual insights to support business performance analysis and decision-making. QuickBus – Intelligent Bus Booking Website with Voice Support Python, Django, REST API, JavaScript

Developed a bus booking application with route search and real-time seat availability.

Implemented user authentication and ticket booking features.

Designed REST APIs for booking and user management.

Integrated voice-support functionality to improve accessibility. PROFESSIONAL STRENGTHS

Attention to Detail • Time Management • Problem Solving • Team Collaboration • Quick Learning • Professional Communication

DECLARATION

I hereby declare that the information furnished above is true and correct to the best of my knowledge and belief. Place: Hyderabad Signature: Medapati Jagan Mohan Reddy

Contact this candidate