Yesaswi Kolla

About Me

Data Analyst with a Master's in Business Data Analytics and 4 years of experience supporting operational reporting and data-driven decision-making. Proficient in SQL, Excel (Power Query, Pivot Tables, VBA), and Power BI, with a strong focus on data validation, dashboard development, and process improvement.

Proven ability to deliver accurate, actionable insights and improve reporting efficiency by 30% through automation and analytical problem-solving.

4+

Years Experience

30%

Efficiency Improvement

Master's

Business Data Analytics

Technical Skills

Building robust data solutions with modern tools and technologies

Data Analysis & Querying

SQL (data extraction, joins, aggregations, query optimization)
Advanced Excel, Pivot Tables, Power Query
XLOOKUP / INDEX-MATCH, VBA basics

Business Intelligence

Power BI (DAX, dashboard development, data modeling)
Tableau (interactive dashboards, data visualization)
Report publishing and automation

Programming & Automation

Python (Pandas, Matplotlib/Seaborn, data analysis)
Data Cleaning & Automation
Basic Python for analytics & AI-driven projects

Tools & Platforms

CRM/Data tools (Google Operations systems)
Microsoft Word and Excel (process clarity)
Quality Operations workflows

Professional Experience

Delivering data-driven solutions at scale

January 2018 - November 2022

Senior Analyst

Teleperformance (Google Operations - MOKA Platform)

Supported Google Shopping operations by reviewing and analyzing high volumes of seller and product data processed through the Moka platform, ensuring accuracy and policy compliance
Performed database data analysis and validation on product listings prior to final submission, maintaining high accuracy standards and minimizing client escalations
Monitored key performance metrics including productivity, accuracy rate, SLA adherence, and error trends; prepared weekly and month-based reports for internal leadership and client review
Built and automated recurring dashboards using Excel (Advanced Formulas, Pivot Tables, Power Query), reducing manual reporting effort by approximately 30% and improving reporting turnaround time
Conducted root-cause analysis on recurring data errors and process deviations, identifying improvement opportunities to reduce rework and enhance workflow efficiency
Collaborated with Quality, Operations, and Client teams to resolve data discrepancies and strengthen process compliance across multiple operational queues
Served as a Subject Matter Expert (SME) for Moka workflows, supporting onboarding, training new analysts, and troubleshooting process-related issues
Documented standard operating procedures (SOPs), data definitions, and reporting guidelines using Microsoft Word and Excel to improve process clarity and consistency
Identified inefficiencies in data processing cycles and recommended workflow improvements, contributing to improved turnaround time and overall operational consistency

Featured Projects

Showcasing analytical thinking and technical execution

AI-Driven Job Market Analytics Dashboard

Power BI | Excel | Power Query | DAX

Developed an interactive Power BI dashboard analyzing job market trends, in-demand skills, and salary patterns using structured job posting data. Applied Excel (Power Query) for data cleansing and DAX measures for advanced insights to identify skill gaps and hiring trends.

NBA Performance Analytics Project

Python | Pandas | Matplotlib/Seaborn

Developed a Python-based data analysis project to evaluate NBA team and player performance trends using structured game statistics. Performed data cleaning with Pandas, conducted exploratory data analysis (EDA), and visualized scoring patterns, win rates, and efficiency metrics using Matplotlib/Seaborn to identify performance insights.

Transforming Data into Intelligence