Udathaneni Likar Balaji Likar Balaji
Data Analyst
About
Data Analyst with hands-on experience in SQL, Power BI, Excel, and Python, analysing datasets of 100K+ records. Skilled in data cleaning, KPI tracking, and dashboard development, delivering actionable insights across revenue, customer, and performance metrics.
Skills & Expertise (26)
Work Experience
Retail Sales & Customer Revenue Analyst
BCG Client
Oct 2025 - Oct 2025
Analysed 50K+ retail sales records using SQL to calculate net revenue after return adjustments for revenue and profitability analysis. Identified top 3 regions contributing 55% of total sales and top 20% customers generating 60% of revenue. Measured average profit margins of 12% and flagged product categories with 15%+ return rates. Ranked sales performance, revealing a 30% productivity gap between top and bottom performers.
Digital Payments Transaction Analysis
Phone Pe Dataset
Nov 2025 - Nov 2025
Analysed 100K+ digital payment transactions to track KPIs, monthly trends, and transaction failure patterns. Segmented data across loans, recharges, insurance, and money transfers to compare category performance and user behaviour for business intelligence reporting. Identified failure reasons affecting 20–25% of unsuccessful transactions, highlighting operational inefficiencies.
Healthcare Analytics Solution Engineer
Indian Hospital Management System
Mar 2026 - Mar 2026
Engineered a healthcare analytics solution using MySQL & Power BI on 100K+ patient encounters across 5 years, writing 20+ SQL queries (CTEs, Window Functions, multi-table JOINs) to surface revenue, readmission, and clinical KPIs across a 5-table relational database. Identified ₹331M in outstanding billing across 10 states and uncovered that chronic patients (23.4% of base) drive 2.3× higher cost per encounter, enabling targeted recovery and resource prioritization strategies. Built a 6-page interactive Power BI dashboard with drill-through filters and cross-page slicers, revealing a 51.7% YoY revenue recovery post-COVID and flagging ICU & Cardiology at 94%–89% bed occupancy for capacity planning.
Education
Bachelor of Technology in Computer Science Engineering (AI & ML) - TKR College of Engineering and Technology
2021 - 2025 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Open to Relocation
Skills (26)
Click a skill to find developers with the same skill
