Pranay Miriyala

Data Analyst

Bengaluru, Karnataka 1+ yrs exp 83 · Excellent

About

Data Analyst with 1.8 years of hands-on experience in SQL, Power BI, Excel, and Python. Built automated reporting pipelines and KPI dashboards for fmcg and e-commerce clients, reducing manual reporting time and improving operational visibility. Strong background in root cause analysis, Funnel analysis, and cohort analysis — focused on turning raw transactional data into clear, business-ready findings.

Skills & Expertise (25)

SQL Intermediate

7.2/10

1.8

Years Exp

Power BI Intermediate

7.0/10

1.8

Years Exp

Python Intermediate

6.5/10

1.8

Years Exp

Excel Intermediate

6.5/10

1.8

Years Exp

Marketing Analytics Intermediate

6.0/10

1.8

Years Exp

Data Visualization Intermediate

6.0/10

1.8

Years Exp

Business Intelligence Intermediate

6.0/10

1.8

Years Exp

Customer Analytics Intermediate

6.0/10

1.8

Years Exp

Aggregations Intermediate

6.0/10

1.8

Years Exp

Subqueries Intermediate

6.0/10

1.8

Years Exp

CASE Statements Intermediate

6.0/10

1.8

Years Exp

Window Functions Intermediate

6.0/10

1.8

Years Exp

CTEs Intermediate

6.0/10

1.8

Years Exp

Joins Intermediate

6.0/10

1.8

Years Exp

Cohort Analysis Intermediate

5.5/10

1.8

Years Exp

Customer Segmentation Intermediate

5.5/10

1.8

Years Exp

KPI development Intermediate

5.5/10

1.8

Years Exp

Root Cause Analysis Intermediate

5.5/10

1.8

Years Exp

Trend Analysis Intermediate

5.5/10

1.8

Years Exp

BigQuery Beginner

5.0/10

1.8

Years Exp

MySql Beginner

5.0/10

1.8

Years Exp

Git Beginner

5.0/10

1.8

Years Exp

GitHub Beginner

5.0/10

1.8

Years Exp

Pandas Beginner

5.0/10

1.8

Years Exp

NumPy Beginner

5.0/10

1.8

Years Exp

Work Experience

Data Analyst

LTIMindtree

Dec 2024 - Jul 2026

Automated SQL and Excel-based reporting workflows for e-commerce clients, reducing reporting effort by 25% and enabling faster access to business performance insights. Developed Power BI dashboards tracking customer acquisition, conversion funnel, revenue, retention, and engagement KPIs, supporting performance monitoring across marketing and operational teams. Evaluated 100K+ transactional records using SQL, CTEs, Window Functions, and aggregations to uncover customer behavior trends, conversion opportunities, and revenue drivers. Investigated KPI anomalies and data discrepancies across customer and revenue datasets; identified and resolved recurring data quality issues.