Portfolio - Pavan Siva Kumar Valeti | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Pavan Siva Kumar Valeti

Software engineer

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

My name is Pavan Siva Kumar Valeti, and I am currently working as a Software Engineer at the University of Louisiana at Lafayette (ULL). In this role, I focus on analyzing institutional data, generating meaningful insights, and developing reports that support data-driven decision-making across the university. My work involves transforming raw data into actionable intelligence, ensuring accuracy, and providing valuable inputs for academic and administrative planning.Previously, I worked as a Software Engineer at HCL Technologies in the Data Analyst domain, where I gained strong experience in data analysis, reporting, and business intelligence. During this time, I worked with diverse datasets, applied analytical techniques, and collaborated with teams to deliver data solutions that supported client operations and strategic goals.I bring a strong foundation in data analysis, reporting, and software engineering, with a keen interest in leveraging data .

Key

Skills

Machine learning

SQL

Python

Tableau

Stakeholder Management

Regression Analysis

My

Projects

Sales and Finance Analytics

Sales and Finance Analytics

Created dynamic Excel reports analyzing sales and finance data. Revealed key trends, profit drivers, and strategic insights, aiding data-driven decision-making.

Business Insights 360

Business Insights 360

AtliQ Hardware, a consumer electronics firm, faces tough competition due to limited data usage, mainly relying on Excel for reports. My objective is to implement a robust Power BI analytics solution, enabling the company to gain crucial insights for smarter decision-making.

Awards

& Certificate

Agile Project Management with Jira Cloud

Agile Project Management with Jira Cloud

Lean Six Sigma Foundations

Lean Six Sigma Foundations

Tableau Essential Training

Tableau Essential Training

microsoft dynamics 365

microsoft dynamics 365

Become a data analyst

Become a data analyst

AWS SOLUTIONS ARCHITECT

AWS SOLUTIONS ARCHITECT

Oracle data science certified professional

Oracle data science certified professional

Contact Me

Email

[email protected]

Github

https://github.com/Pavan200000

Linkedin

https://www.linkedin.com/in/pavan-siva-kumar-valeti-36b693291/

Call

+1 3372956120

Pavan Siva Kumar Valeti

Software engineer

Download Resume

Resume

Excel Project

Sales and Finance Analytics

Created dynamic Excel reports analyzing sales and finance data. Revealed key trends, profit drivers, and strategic insights, aiding data-driven decision-making.

View Project
on GitHUB

Sales and Finance Analytics

Country-wise net sales for 2019-2021, 2021 net sales targets, and corresponding target percentages.

Sales and Finance Analytics

Yearly Profit and Loss analysis with a comparison of the last two years for financial insights.

Project Details

This Excel project focuses on sales and finance performance analysis and reporting, aimed at providing valuable insights into business operations.

Sales analysis:
🔸 Customer Performance: Dynamic pivot table for customer sales analysis, including 2019-2021 net sales and % growth.
🔸 Market Performance: Country-wise net sales for 2019-2021, sales targets, and target percentages.
🔸 Top 10 Products: Identify products with the highest % increase in net sales from 2020 to 2021.
🔸 Top & Bottom 5 Products: Identify top and bottom 5 products by quantity sold.
🔸 New Products in 2021: Find and track new products introduced in 2021.

Finance analysis:
🔸 Profit & Loss Analysis: Created dynamic chart of yearly and quarterly profit & loss data.
🔸 Market-Specific Profit: Analyze profit & loss data by market segments.It helps identify which markets drive profits and where improvements may be needed.
🔸 Gross Margin by Quarter: Calculate and analyze gross margin percentages quarterly.

PowerBI Project

Business Insights 360

AtliQ Hardware, a consumer electronics firm, faces tough competition due to limited data usage, mainly relying on Excel for reports. My objective is to implement a robust Power BI analytics solution, enabling the company to gain crucial insights for smarter decision-making.

Business Insights 360

Home page dashboard

Business Insights 360

Finance view

Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Live Interactive Dashboard