Lochanreddy MallakuntaAnalytics portfolio
FintechStartupOct 2025 – Present

DigiPae Payment and Product Analytics

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

Tools: SQL · Excel · Power BI · Python

Analytics instrumentation

Mixpanel funnels live

Reporting view

KPI dashboard designed

Data integration

Multi-vendor reconciliation

Overview

As Founder & Full-Stack Developer at DigiPae (Ceivis LLC), designed product analytics and KPI reporting for payments and verified-identity workflows—covering Mixpanel funnel instrumentation, onboarding and KYC conversion tracking, multi-vendor data reconciliation, and executive-ready summaries—without publishing confidential production records here.

Business 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?

Analysis and approach

  • Instrument Mixpanel analytics for payment funnels, onboarding drop-off, KYC conversion, and retention
  • Design KPI dashboards for transaction volumes, error rates, and compliance metrics
  • Reconcile Stripe, Socure, Plaid, and Firebase data into one validated reporting view
  • Document data mappings and technical logic for cross-functional stakeholders

Skills: Funnel analysis · KPI development · Payment lifecycle analysis · Stakeholder communication

Evidence and visuals

  • Placeholder for DigiPae funnel analytics evidence

    Evidence placeholder — add a sanitized Mixpanel or KPI dashboard export.

Findings and outcome

  • Onboarding, KYC conversion, payment completion, and retention need to be measured as a connected lifecycle.
  • Vendor data must be sourced, normalized, and validated before executive KPI summaries are trustworthy.
  • Error-rate and compliance metrics belong beside growth metrics so conversion is not optimized in isolation.

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

Recommendations

  1. 1

    Keep a consistent event taxonomy across signup, verification, bank linking, and payment states.

  2. 2

    Review top failure reasons weekly with product and operations owners.

  3. 3

    Prioritize fixes by expected funnel recovery and operational risk, not volume alone.

Project details

Dataset / source
Internal DigiPae product analytics (Mixpanel) and vendor integrations. No production financial, identity, or merchant records are published here.
Data classification
Confidential — sanitized methods only in this portfolio
Limitations
  • Production payment and identity records are not published.
  • DigiPae marketing-site traction figures are not reused as portfolio results.