Hi, I’m Uday Prakash Lakkaraju

Data Analyst and MS Information Systems candidate, graduating May 2026.

Career Summary

I build end-to-end analytics workflows using SQL, Python, BigQuery, Power BI, and Excel - from data preparation to stakeholder-ready dashboards. Portfolio outcomes include a fraud review queue hitting 9.5% precision on 51K+ payments, a 100K-patient care-pathway model quantifying +610 recoverable diagnoses, and $2.31M in profit exposure isolated across 65K+ supply chain orders.

51K+ Payments analyzed
+610 Diagnoses modeled
$2.31M Profit exposure found
4,562 Films analyzed
View My Work Download Resume
Scroll
Projects

Featured Work

A selection of projects showcasing my analytical skills and problem-solving approach.

Abstract payment security motif — decorative card art, not live data
SQL Python Power BI

Payment Fraud Detection

Analyzed 51K+ payments to quantify $500K+ in leakage · built a gradient-boosting fraud risk model that concentrates fraud 1.7× above baseline (9.5% vs. 5.5%) · isolated $232K in retry-recoverable value.

Explore Dashboard
Abstract clinical workflow motif — decorative card art, not live data
SQLExcelPython

Clinical Workflow Analytics

Engineered a Python/SQL pipeline processing a 1.1M+ record EHR dataset into a validated 15,000-patient care-pathway mart · 73.7% pathway attrition · isolated 35.4% and 34.1% drop-offs at referral and specialist-access stages · modeled +610 recoverable diagnoses from two targeted fixes.

Explore Dashboard
Abstract supply chain and logistics motif — decorative card art, not live data
SQLBigQueryPower BIExcel

Supply Chain Prioritization & Risk Analysis

Built a BigQuery ETL pipeline aggregating 180K+ item records into 65,752 distinct orders · uncovered $2.31M in high-value profit exposure from ineffective SLA routing · prioritized the 5 lanes driving 41.2% of breaches, modeling 3,097 addressable breaches and $309K in exposure.

Film and media analytics — decorative card art, not live data
PythonSQLPower BIExcel

Content Investment Analysis

Built a validated Audience Value Index across 4,562 films · Horror is 2x more capital-efficient than any other genre · big budgets buy safety, not efficiency (8.9% vs. 37% loss rate) · sequels fade to 61% of opener value by film 2. Delivered as SQL, Excel, and a 5-page Power BI dashboard.

Live Dashboard

Interactive BI Showcase

Real report pages from each project's Power BI dashboard or analysis output.

Payment Fraud Detection — Power BI Executive Summary
Payment Fraud Detection — Power BI Executive Summary View full report on GitHub →
Skills

Tools & Technologies

Python

Pandas, NumPy, Scikit-learn, predictive modeling, cohort and funnel analysis.

SQL

Advanced SQL with CTEs, window functions, PostgreSQL, and BigQuery analytics workflows.

Power BI

Advanced DAX, Power Query, KPI framework design, and stakeholder-ready interactive dashboards.

Data Engineering

GCP BigQuery, PostgreSQL, ETL/ELT pipelines, data warehousing, and data modeling.

Excel

Pivot tables, XLOOKUP, scenario planners, and stakeholder-ready workbooks.

Analytics

A/B testing, root cause analysis, KPI development, and operational performance diagnostics.

About

Driven by Curiosity, Fueled by Data

I'm Uday Prakash Lakkaraju, a data analyst pursuing an MS in Information Systems at Stevens Institute of Technology (GPA 3.6), graduating May 2026. My work sits at the intersection of analytics engineering and business impact. "What decision does this data enable?" is the question I bring to every project.

My toolkit includes advanced SQL, Python, GCP BigQuery, PostgreSQL, Power BI, and Excel. I've built ETL/ELT pipelines, predictive fraud models, and KPI frameworks that move teams from manual reporting to reliable, self-serve insight.

I enjoy solving analytics problems across fintech, healthcare, and operations domains, with a focus on measurable outcomes. Based in Sacramento, CA, I'm seeking full-time Data Analyst and BI Analyst roles.

Portrait of Uday Prakash Lakkaraju
Timeline

Career Timeline

2020 Started B.Tech CSE
2023 Data Operations Analyst Internship
2024-26 MS Information Systems
Sep 2024 - May 2026

MS, Information Systems | Stevens Institute of Technology

GPA 3.6 | Hoboken, NJ. Coursework focused on Business Intelligence & Analytics, Data Integration, and Database Management Systems.

Business IntelligenceData IntegrationDatabase Management
Jun 2023 - Oct 2023

Data Operations Analyst Intern | Sreyas Institute of Engineering and Technology

Saved 14-17 hours/month by building a Python and SQL reporting workflow, cutting turnaround from 3-4 hours to under 1 hour. Consolidated 85,000+ records from 5 source systems into PostgreSQL with validation controls, improving data consistency across 4 departments. Flagged 500+ at-risk students across 60,000+ records using SQL ranking and Excel pivot analysis, presenting findings to 4 department heads.

SQLPythonPostgreSQLExcelStakeholder Communication
Nov 2020 - Jun 2024

B.Tech, Computer Science | Sreyas Institute of Engineering and Technology

Hyderabad, India. Coursework in Machine Learning, Statistical Methods, and Data Structures & Algorithms - building the technical foundation for a career in data.

Machine LearningStatistical MethodsData Structures & Algorithms
Contact

Let's Work Together

I'm actively looking for data analyst and BI opportunities. Let's connect and see how I can add value to your team.

Email

ludayprakash350@gmail.com

LinkedIn

Connect with me

GitHub

See my code

Resume

Download PDF

Send a Message

Use this form to reach me directly and I will get back to you soon.