Junior Data Analyst with experience in SQL, Python, Power BI, Tableau, and Excel. Founder building DigiPae at CEIVIS, with additional analytics work across research, nonprofit operations, and cloud data environments.
This portfolio positions Lochanreddy Mallakunta for analyst roles across data, BI/reporting, business, operations, marketing, product, RevOps, and financial data analysis. Those titles share one foundation: turn complex information into decisions stakeholders can use.
01
Translate a decision need into a measurable question with clear success criteria.
02
Assess coverage, quality, and definitions before drawing conclusions.
03
Compare segments, trends, and exceptions to isolate what drives outcomes.
04
Present the few charts and tables that help stakeholders decide quickly.
05
Propose next steps with owners, expected signals, and follow-up metrics.
As Founder & Full-Stack Developer at DigiPae (Ceivis LLC), the work includes Mixpanel product analytics, payment and KYC funnel tracking, KPI dashboards, multi-vendor data reconciliation, and stakeholder-ready reporting. That experience supports analyst positioning; it does not replace project evidence and does not include unverified traction claims.
Based in St. Louis, MO.
DigiPae (Ceivis LLC) · Oct 2025 – Present · St. Louis, MO
Building DigiPae, a payments and verified-identity platform. Instrumented product analytics with Mixpanel for payment funnels, onboarding drop-off, KYC conversion, and retention; designed KPI dashboards for transaction volumes, error rates, and compliance metrics; reconciled multi-vendor data flows (Stripe, Socure, Plaid, Firebase) into consistent reporting views.
Smart-City Research Project · Saint Louis University · Aug – Dec 2025 · St. Louis, MO
Led backend data systems and BI reporting for an urban analytics prototype monitoring real-time traffic and PM2.5 air quality across 5+ city junctions. Built Python ETL pipelines with forecasting models and a responsive BI dashboard with live telemetry, scenario testing, and early-warning signals.
Gateway Region YMCA · May – Oct 2024 · St. Louis, MO
Wrote complex SQL against SQL Server for membership, program, and financial reporting. Built Power BI dashboards and Excel reports with validation checks. Automated recurring extraction and reporting with Python (Pandas), reducing manual reporting effort by approximately 35% per resume.
TVM Infotech Private Limited · Oct 2023 – Dec 2024 · Chennai, India
Developed and optimized SQL against PostgreSQL and MySQL; built Python ETL across AWS (S3, RDS, Lambda, EC2); wrote stored procedures and cursors for recurring reporting workflows, reducing manual data preparation time by approximately 30% per resume.
Saint Louis University · St. Louis, MO
Graduate study in Information Systems, including master’s research work on smart-city analytics.
Sree Vidyanikethan Engineering College · Undergraduate degree
Computer Science & Engineering foundation supporting data systems, cloud, and analytics work.
Start with the featured case studies, then filter the library by the role you are hiring for.