kavvampalli srinithya

Data Analyst

Cognizant Technologies

Jan 2024 - Jan 2026

Project 1: Analyzed 100K+ e-commerce orders across 9+ relational datasets covering customers, products, sellers, payments, reviews, and delivery performance. Cleaned, joined, and transformed multiple datasets by handling missing values, inconsistent date fields, and data-quality issues to prepare analysis-ready data. Performed SQL-based analysis to identify sales trends, customer behavior patterns, product performance, seller efficiency, and marketplace insights. Conducted diagnostic analysis of estimated versus actual delivery dates to identify delay patterns and their impact on customer review scores. Developed KPI-driven dashboards and visual reports covering sales, orders, delivery metrics, product analysis, and customer feedback. Performed comparative analysis across customer, product, and delivery dimensions to identify key performance patterns and support business reporting requirements. Project 2: Analyzed structured advertising-review datasets to identify patterns in ad accuracy, relevance, landing-page consistency, and content quality. Performed data validation using filtering, sorting, conditional formatting, and structured categorization to improve reporting quality. Conducted root-cause analysis on inaccurate and UTV records to identify recurring issues related to grammar, spelling, professionalism, and content relevance. Tracked quality and productivity KPIs through periodic reporting to monitor review performance and operational trends. Converted review-level observations into actionable insights to support process consistency and improvement initiatives. Prepared structured quality analysis reports by consolidating review findings and performance observations to improve visibility into advertising operations.