Portfolio - Yaswanth Kumar Reddy

1

Excel
Project

4

PowerBI
Projects

About

Welcome to My Portfolio!

I am a Software Engineer and Data Analyst at HCL Technologies, with expertise in Python, SQL, Excel, Power BI, and Google Cloud Platform (GCP). I specialize in transforming complex data into actionable insights to drive business decisions and optimize operations.

Key Skills:
• Python: Building data pipelines and performing analysis.
• SQL: Extracting, transforming, and analyzing large datasets.
• Excel: Advanced data manipulation and reporting.
• Power BI: Designing interactive dashboards for clear data visualizations.
• GCP: Leveraging cloud tools for scalable data solutions.

I’m passionate about solving business challenges with data and delivering solutions that add measurable value. Let’s connect and explore how I can help unlock the potential of your data.

Best regards,
Yaswanth.

Key

Skills

Python

Power BI

SQL

Excel

Splunk

GCP

My

Projects

Sales and Finance Analytics for AtliQ Hardware

Domain/Function: Sales and Finance

Developed actionable insights through in-depth sales and financial analytics within the FMCG sector. Enabled businesses to drive growth and expansion with data-driven strategies. Gained expertise in ETL processes, Power Query, Power Pivot, DAX, and creating user-focused reports.

UK National Rail Dashboard

Domain/Function: Public Transport

I developed a Power BI dashboard to analyze the UK National Rail network. It features revenue, journey, and station insights, with interactive navigation and filtering. Key skills include advanced visualization, data transformation, and tracking metrics for strategic decision-making.

The Great American Coffee Challenge

Domain/Function: Consumer Goods

The Great American Coffee Taste Test dashboard provides insights into consumer coffee preferences, spending habits, and demographics from a nationwide survey. It analyzes roast preferences, consumption patterns, and customer feedback, helping coffee shop owners optimize products, marketing.

Electric Vehicle (EV) Market Analysis

Domain/Function: Automotive

Conducted market analysis for AtliQ Motors to support expansion into India’s EV sector. Using Power BI, analyzed EV trends, penetration, and charging infrastructure. Delivered insights on high-demand regions, 2-wheeler focus, and R&D investment to drive data-driven decisions.

Goodcabs Operations Dashboard

Domain/Function: Transportation

An interactive analytics tool for optimizing cab operations across Indian cities. Tracks key metrics like revenue, trips, and passenger satisfaction, with actionable insights via dynamic visuals. Designed to drive data-driven decisions and growth, focusing on tier-2 city markets.

My

Experience

HCLTech, Chennai – Data Analyst

Oct 2022 - Present

•Optimized Data-Driven Processes: Led the implementation of data automation systems for invoice processing and document creation, reducing processing times by up to 85% through the development of custom analytics models and workflow automation.

•Advanced Analytics & Visualization: Developed and deployed dynamic Power BI dashboards and AI-driven recommendation systems, delivering actionable insights across multiple domains (finance, sales, operations) to enable real-time, data-backed decision-making for key stakeholders.

•Predictive & Prescriptive Analytics: Applied predictive analytics for contract renewals and device maintenance, improving renewal rates by 25%, driving 30% upsell revenue growth, and minimizing device downtime by 20%, directly impacting business outcomes and customer retention.

•Big Data Management & Integration: Automated the integration and transformation of large-scale data sets, centralizing data from multiple sources (bots, databases, Excel) for efficient management and analysis, significantly improving reporting timelines by 3 days and ensuring scalability.

•Tailored Analytics Solutions for Clients: Delivered client-specific analytics solutions by leveraging data transformation and visualization techniques, providing insights that improved operational workflows and enhanced client satisfaction with more informed business strategies.