Lochanreddy MallakuntaAnalytics portfolio

Project library

Filter by role, tool, domain, or project type. Cards stay usable without JavaScript. Detailed evidence lives on each case-study page.

Filter projects

Combine filters. State stays in the URL.

1 activeReset

Showing 6 projects.

Placeholder for DigiPae funnel analytics evidence
FeaturedFintech

DigiPae Payment and Product Analytics

Problem: Where do users and merchants encounter friction across signup, identity verification, bank linking, payment initiation, and successful completion—and which issues should be prioritized?

Outcome: A measurement framework for identifying friction across onboarding, verification, bank linking, and payment completion.

Tools: SQL · Excel · Power BI · Python

Placeholder for tax filing analytics evidence
FeaturedTax / Finance

H&R Block Tax Analytics & Automation

Problem: Where do filing workflows bottleneck, which error patterns need attention, and how can ETL and reporting automation improve processing efficiency and leadership visibility?

Outcome: Analyzed filing patterns and bottlenecks, restructured ETL pipelines for about 40% faster processing, and delivered Power BI dashboards with automated validation.

Tools: Excel · Power BI · SQL · Power Query · Python · DAX

Placeholder for healthcare anomaly detection evidence
FeaturedHealthcare

AI-Driven Healthcare Analysis & Reporting

Problem: Which health-metric patterns should receive additional review, how can anomaly detection reduce time-to-insight, and what access controls are required for trustworthy monitoring?

Outcome: Built an AI-powered anomaly detection and reporting workflow for critical health-metric patterns, paired with role-based BI dashboards for faster monitoring.

Tools: Python · SQL · Excel · Machine Learning

Placeholder for SaaS RevOps funnel evidence
IndependentSaaS

SaaS Revenue Operations Analytics

Problem: Where are qualified prospects being lost, which channels create valuable opportunities, and is the current pipeline sufficient to meet revenue goals?

Outcome: A decision-support dashboard framing that identifies funnel bottlenecks, pipeline risk, and opportunities to improve sales prioritization using synthetic CRM data.

Tools: SQL · Power BI · Excel · DAX · Power Query

Placeholder for marketing attribution evidence
IndependentMarketing

Marketing Attribution and Customer Segmentation

Problem: Which channels and customer segments create valuable, retained customers rather than inexpensive but low-quality conversions?

Outcome: An analysis framework that distinguishes channel quality and retained customer value from low-quality inexpensive conversions using synthetic campaign data.

Tools: SQL · Python · Excel · Power BI

Placeholder for operations inventory evidence
IndependentOperations

Operations and Inventory Performance Analytics

Problem: How can the organization reduce delayed orders, stockouts, and excess inventory while maintaining service levels?

Outcome: A monitoring and decision framework for balancing inventory availability, fulfillment performance, and working capital using synthetic operations data.

Tools: SQL · Excel · Power BI · Power Query · Python