Portfolio - Sai Krishna Chaitanya Bontha

Sai Krishna Chaitanya Bontha

Data Analyst

Resume

1

SQL Project

1

Excel Project

1

PowerBI Project

About Me

Step into the world of data-driven discovery, where every piece of information has the potential to spark meaningful change. With five years of experience as a skilled Data Analyst and System Support Engineer and customer support, I specialize in unraveling the complexities of data analysis. Using powerful tools like Power BI, SQL, and MS Excel, I transform raw data into actionable insights that drive decision-making. But my journey isn't just about technical expertise—it's about a relentless pursuit of learning and innovation. With a passion for growth and a commitment to excellence, I thrive in fast-paced environments, always staying ahead of the curve with the latest technologies. Whether crafting interactive dashboards or providing top-notch customer support, I bring dedication and precision to every task. Welcome to my world of dynamic data, where possibilities are endless, and the journey of discovery is just beginning.

Key Skills

power bi

excel

Tableau

Python

SQL

My Projects

SQL Movies dataset Project

Bank Loan Analysis

Business Insights 360

Amazon E-commerce Insights Dashboard Tableau Project

Domain/Function: E-Commerce Analytics | Retail Business Intelligence | Sales & Operations Analysis

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

Key Performer of the month - May 2022

Most Valuable Performer of the month - September - October 2021

Key Performer of the month - April and May 2022

Amazon stores customer service (RISING STAR)

Amazon 5-STAR RECOGNITION CERTIFICATE

Lean & Quality Management, Six Sigma, Continuous Improvement

Management Mastery: Lead with Impact, Succeed with Clarity

HackerRank SQL (Basic) Certificate

HackerRank SQL (Intermediate) Certificate

Agile Project Management+Scrum

Storytelling with Data: Unlock Insights, Drive Results

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/bontha-s-563639131/

Call Me

+91 7989356728

GitHub

https://github.com/SaiKrishnaChaitanya7

SQL Project

SQL Movies dataset Project

"Analyzing IMDb movie dataset using MySQL for insights into ratings, genres, and actor appearances. Queries, analysis, and visualization showcase MySQL skills."

View Project
on GitHUB

Screenshot-1

Screenshot-2

Project Details

This project explores a dataset containing information about movies sourced from IMDb. Leveraging MySQL, the project involves data analysis, querying, and visualization to extract insights and patterns from the dataset.

Excel Project

Bank Loan Analysis

The primary objective of the Details Dashboard is to provide a comprehensive and user-friendly interface for accessing vital loan data. It will serve as a one-stop solution for users seeking detailed insights into our loan portfolio, borrower profiles, and loan performance.

View Project
on GitHUB

Screenshot 1

Screenshot 2

Project Details

The Details Dashboard is designed with the primary objective of offering users a comprehensive and intuitive interface to access essential loan data. Serving as a centralized hub, it provides a one-stop solution for users to gain detailed insights into our loan portfolio, borrower profiles, and loan performance metrics. Through this dashboard, users can easily navigate and explore vital information, enabling informed decision-making processes. With its user-friendly design and comprehensive data presentation, the Details Dashboard aims to enhance accessibility and streamline the analysis of our loan portfolio, ultimately facilitating better management and optimization strategies.

PowerBI Project

Business Insights 360

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
on GitHUB

ss-1

ss-2

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics.

Live Interactive Dashboard

Amazon E-commerce Insights Dashboard Tableau Project

Domain/Function: E-Commerce Analytics | Retail Business Intelligence | Sales & Operations Analysis

Interactive Tableau dashboard analyzing Amazon e-commerce performance through KPIs like revenue, profit, units sold, and shipment days. Includes region, country, sales channel, cost, and product-level insights for data-driven decision making.

View Project
on GitHUB

View Project
on Tableau Public

Welcome Page

Executive Page

Project Details

This project presents an end-to-end Tableau dashboard that analyzes Amazon’s e-commerce performance across multiple business dimensions. The dashboard highlights key KPIs such as total revenue, total profit, units sold, and average shipment days. It provides detailed insights through region-wise and country-wise profit analysis, sales channel performance, yearly order trends, and cost evolution. Additional visualizations include revenue vs shipment days, priority-wise orders, and revenue/cost/profit/order splits. The dashboard is organized into four pages—Homepage, Executive Insights, Revenue Analysis, and Item Analysis—offering a comprehensive view of business operations, customer behavior, and product performance. This project enables stakeholders to identify growth opportunities, optimize operations, and make data-driven decisions.