Summary

Overview

Work History

Education

Skills

Websites

Timeline

Lakshmi Prasanna Lolla

Redwood City

Summary

Business Intelligence & Data Analytics 5+ years of experience in BI development and advanced analytics, specializing in ETL, KPI design, statistical modeling and performance tracking. Adept at converting business requirements into automated, scalable insights via intuitive dashboards and self-serve tools. SQL, Python & Data Engineering Extensive experience using SQL for data transformation in OLTP/OLAP systems and Python (Pandas, NumPy, SciPy) for wrangling, statistical analysis and end-to-end reporting automation. Executive Dashboards & BI Automation Built enterprise-grade dashboards in Tableau and Amazon QuickSight with advanced UX (LODs, sets, table calcs, filters, drilldowns) and performance tuning. Delivered repeatable, modular BI systems with AI-powered automation and query optimization. Cross-Functional Strategy & Stakeholder Enablement Collaborated across Engineering, Finance, Product and Marketing to drive data governance, budget planning and operational improvements. Skilled in strategic storytelling and translating data into actionable insight for executive stakeholders. Dimensional Modeling & Scalable Pipelines Hands-on experience with Star and Snowflake schemas, building robust pipelines for structured and semi-structured data across enterprise platforms. Agile BI Delivery & SDLC Ownership Owned full BI lifecycle in Agile/Scrum environments - from requirements gathering and sprint planning to QA, deployment, and adoption.

Overview

2023

years of professional experience

Work History

Ongoing Professional Development
Currently learning Power BI Desktop, Adobe Analytics and DBT (Data Build Tool)

Senior Analytics Consultant – Services, Analytics and BI

Apps Associates (Client – Take Two Interactive)

12.2021 - 12.2022

Implemented Snowpark for Snowflake by configuring a development environment in VS Code, using DataFrames for complex transformations to support advanced data engineering workflows.
Automated dashboard and ELT workflows to improve self-service analytics and deliver strategic insights on revenue trends, campaign effectiveness and business performance to senior stakeholders.
Migrated dashboards from Oracle Analytics Cloud (OAC) to Tableau, optimizing SQL queries in Oracle ADW to enhance data load speed and visualization performance.
Served as Senior Tableau Developer & Server Administrator, managing user access, maintaining critical financial dashboards (e.g., Revenue Forecast, Project Profitability) and executing ELT pipelines for data-driven decision-making.
Trained business stakeholders on Tableau Desktop and Server usage, including report access, filter/parameter configuration and dashboard interaction, to promote self-service analytics and enhance data literacy across teams.

Data Analyst – Solutions

G2 (Bangalore, India)

06.2021 - 12.2021

Built scalable dashboards in SQL, Looker, and Tableau to monitor GTM pipeline health, buyer cohorts, and DTC campaign performance; partnered with Product and Marketing to optimize growth strategies.
Collaborated in Agile cross-functional teams, contributing to sprint planning and ensuring timely delivery of analytics solutions for Sales and Customer Success stakeholders.
Enabled stakeholder self-service and improved decision speed by reducing manual reporting and implementing AI-powered Matik templates.

Decision Science Analyst

Siri InfoSolutions Inc (Client - USAA - The United Services Automobile Association, San Antonio, TX)

08.2020 - 06.2021

Acted as a liaison between business stakeholders and IT/Data Warehouse teams to develop automated BI solutions supporting financial and operational intelligence.
Delivered actionable insights via SQL- and Tableau-based reports, dashboards and data marts, driving data-informed decisions across credit, fraud and risk domains.
Conducted detailed analysis on credit card portfolios, identifying delinquencies and policy effectiveness, informing strategy around risk mitigation and loss prevention.
Created KPIs and performance metrics for Weekly and Monthly Business Reviews (WBR/MBR), enabling targeted visualizations on delinquency trends and account behavior.
Led the migration of 30+ reports from Hadoop to Snowflake, optimizing SQL performance and ensuring seamless transition with minimal downtime.
Spearheaded SAP Business Objects to Tableau migration, translating business rules into technical specifications and reducing reporting technical debt.

Data Analyst (Reporting and Analytics Lead)

nVoq Incorporated (Boulder, CO)

06.2018 - 07.2020

Optimized support operations by clustering customer tickets and developing automated solutions using SQL and Pentaho, reducing ticket volume and response time while balancing team workload.
Conducted cohort analysis on new vs. returning users, delivering actionable insights on customer retention, usage behavior, and campaign impact to inform engagement and retention strategies.
Designed and maintained healthcare dashboards using Tableau and Amazon QuickSight (POC), offering visibility into key metrics like product usage, user logins and retention KPIs, collaborating cross-functionally with Marketing, Sales, Product and QA teams.
Engineered SQL ETL pipelines and created MySQL procedures to support data extraction, transformation and integrity in healthcare production systems.
Automated reporting workflows via Pentaho, Bash scripts and cron jobs for HIPAA-compliant scheduling and delivery of critical reports to stakeholders and partners.
Led Tableau Server deployment and Viz Alerts implementation, enabling automated PDF/CSV visual alerts and enhancing enterprise reporting infrastructure.
Led migration of legacy reporting systems to Tableau within the nVoq Administrator app and upgraded Pentaho, improving analytics accessibility and performance.

Research Data Analyst

University of Akron (Akron, OH)

09.2016 - 05.2018

Implemented the START NLP system (MIT-developed) for the FAA to transform course content and job tasks into a searchable knowledge base, enhancing training and knowledge management.
Built a KNIME text mining model to extract sentiment on risk and financial health from 10-K SEC filings and visualized insights using Tableau to support data-driven decision-making.

Database Management Intern

NYC Department of Environmental Protection (New York City, NY)

06.2017 - 08.2017

Created summarized inventory reports using Tableau, providing actionable insights for cross-functional departments and delivering critical reports to the mayor’s office.
Designed and implemented SQL backend logic to identify parent-child relationships within a Windows application, optimizing data retrieval and enhancing system performance.

Database Intern

Adequare Info Pvt Ltd (Hyderabad, India)

05.2015 - 06.2015

Developed targeted customer segments using historical data and demographics for an Online DVD Rental System, enabling successful email marketing campaigns and built a recommender system that boosted sales by 12%.
Designed dynamic Tableau dashboards by integrating data from multiple data sources, along with delivering monthly, quarterly and annual reports for tracking key metrics across branches and organization wide.
Diagnosed and optimized database performance, implementing monitoring and tuning strategies to reduce latency and ensure smooth system operation.