Veera Venkata Sumanth Medisetty

Data Analyst

[email protected] +91 9493182514

Resume

Hello, I am

Veera Venkata Sumanth Medisetty.

1

Excel
Project

3

PowerBI
Projects

About Me

I am an aspiring Data Analyst with a Bachelor’s degree in Computer Science and a passion for transforming raw data into actionable insights. Proficient in Excel, Power BI, SQL, and Python, I specialize in data cleaning, visualization, and analytical problem-solving.

While I haven’t worked in an organization yet, I have completed several business-focused projects that showcase my ability to analyze real-world data, identify trends, and drive data-backed decisions. My portfolio highlights my expertise in handling complex datasets, building insightful dashboards, and delivering meaningful conclusions.

I thrive on solving challenging problems, paying attention to detail, and continuously learning to stay ahead in the evolving data landscape. I am eager to apply my analytical skills and technical expertise in a forward-thinking organization that values data-driven decision-making.

Let’s connect and explore how I can contribute to your team!

Key Skills

Power BI

SQL

Advanced Excel

MySQL

Python

Data Modelling

Data Visualization

Data Cleaning

Microsoft Fabric

Numpy Library

Pandas Library

Matplotlib Library

Data Analysis

My Projects

Sales Analytics

Domain/Function: Finance Analytics

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Brick & mortar and ecommerce

IPL Players Insights

Domain/Function: Sports Analytics

Auto Insurance Claim Analysis using Microsoft Fabric

Domain/Function: Insurance Analytics

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

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.

Mail Me

[email protected]

https://www.linkedin.com/in/sumanthmedisetty/

Call Me

+91 9493182514

GitHub

https://github.com/sumanthmedis

Excel Project

Sales Analytics

Domain/Function: Finance Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I developed a comprehensive sales report using Excel Pivot Tables, Power Query, and DAX to help businesses make data-driven decisions. This report enables organizations to identify effective customer discounts, enhance consumer negotiations, and uncover expansion opportunities in high-potential markets. By analysing sales data, businesses can refine their strategies, optimize revenue generation, and improve overall customer satisfaction.

Technical Skills Gained:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

By leveraging sales data analytics, this project equips businesses with actionable insights to monitor, evaluate, and enhance their sales performance. The ability to interpret and act upon sales trends empowers organizations to unlock new opportunities, maintain a competitive edge, and drive sustainable growth in a dynamic marketplace.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Brick & mortar and ecommerce

AtliQ Hardwares, a rapidly expanding consumer electronics company, faces challenges in leveraging data for decision-making due to reliance on Excel-based reports. My goal is to implement an advanced analytics solution using Power BI to provide actionable insights and improve decision-making.

View Project
Engagement

View Project
on GitHUB

user-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the objective was to create a unified report accessible to stakeholders from sales, marketing, finance, and the executive team. The focus areas included:

1)Robust Data Modeling
2)User-Centric Report Design
3)Drillable Insights

Throughout the project, I gained valuable skills, including:

1)Power Query (basic and advanced operations)
2)Creating basic and complex DAX formulas
3)Data modeling with over 10 tables
4)Selecting appropriate visuals and formatting
5)Understanding dashboard design principles
6)Implementing bookmarks for enhanced user experience
7)Deploying reports to Power BI Service
8)Incorporating stakeholder feedback to refine the report
9)Analyzing key metrics across sales, marketing, finance, and supply chain

This project allowed me to enhance my technical expertise while developing an impactful, user-friendly analytics solution that empowers stakeholders to make data-driven decisions.

Live Interactive Dashboard

PowerBI Project

IPL Players Insights

Domain/Function: Sports Analytics

Identified top-performing IPL players (2021-2023) using advanced analytics. Designed interactive visualizations and a user-friendly dashboard for seamless navigation. Developed a Final Playing XI featuring the best players in their positions.

View Project
Engagement

View Project
on GitHUB

A dashboard showcasing the Best Openers

The top players in their respective roles make up the final 11 team.

Project Details

I developed a project analyzing IPL seasons (2021-2023) to identify the best openers, anchor batsmen, finishers, all-rounders, and bowlers using advanced analytics. By leveraging data-driven techniques, I evaluated player performances and categorized them based on their impact in matches. Designed interactive visualizations to enable easy comparison and insights. Built a user-friendly dashboard with a dedicated home page for seamless navigation, ensuring an intuitive user experience. Finally, I created a Final Playing XI, selecting the top players for each role based on performance metrics. This project showcases my ability to transform raw data into meaningful insights, enhancing decision-making in cricket analytics.

Technologies Used: Excel | Power BI | Data Visualization

Live Interactive Dashboard

PowerBI Project

Auto Insurance Claim Analysis using Microsoft Fabric

Domain/Function: Insurance Analytics

Developed an insurance analytics solution in Microsoft Fabric using Lakehouse and Dataflow Gen2. Created semantic models and Power BI dashboards to analyze claims, risk profiles, and policy performance.

View Project
on GitHUB

Other Tools

Microsoft Fabric

Analyzed insurance claim trends across vehicle years, customer education, marital status, and family demographics. Built interactive visualizations to identify claim patterns, evaluate risk profiles, and support data-driven underwriting decisions.

Created an executive insurance analytics dashboard showcasing KPIs, claim distribution, customer demographics, vehicle insights, and coverage analysis. Enabled stakeholders to monitor performance and identify high-risk segments effectively.

Project Details

Developed an Auto Insurance Risk & Claims Analysis solution using Microsoft Fabric, leveraging a Lakehouse for centralized data storage and Dataflow Gen2 for ETL and data transformation. Built a semantic model with KPIs and measures, and created interactive Power BI dashboards to analyze claim trends, customer risk profiles, and policy insights using DAX, Power Query, and data visualization techniques.