Skip to content

Pavani Lakamsani

Data & Reporting Analyst • Business Requirements • Dashboards & Insights

I’m Pavani Lakamsani, a Data & Reporting Analyst with 4 years of professional experience, including about 2.5 years as a data analyst. I work with business teams to understand what they need, then translate those requirements into accurate reports, Power BI dashboards, and insights people can act on.

View My Work Email me

01 / About

About me

I have 4 years of professional experience, including about 2.5 years as a data analyst, supporting business and technical teams with the reports they rely on. My work starts with people: I gather business requirements, ask the questions that clarify what a team really needs, and turn those needs into clear report and dashboard specifications.

Then I make sure the numbers are right. I prepare and validate data with SQL, reconcile across sources, and build reports and Power BI dashboards that are accurate, documented, and easy to turn into useful insights.

02 / Skills

Skills

Data and Querying

  • SQL
  • SQL Server
  • Joins
  • Aggregations
  • Data transformation

BI and Reporting

  • Power BI
  • DAX (basic formulas)
  • Power Query
  • Tableau
  • KPI reporting
  • Ad hoc reporting

Programming and Automation

  • Python
  • Data preparation
  • Reporting automation

Data Quality and Modeling

  • Validation
  • Reconciliation
  • Data cleaning
  • ETL
  • Star schemas
  • Data models

Business Requirements and Delivery

  • Requirements gathering
  • Translating needs into report specs
  • KPI definitions
  • Root-cause investigation
  • Documentation
  • Stakeholder communication

03 / Projects

Projects

Projects and dashboards I have built — from business requirements through to accurate reports, KPIs, and useful insights.

Work Project

Customer Support & Operations Reporting

Key skills

  • SQL
  • SSRS
  • Power BI
  • DAX
  • Python
  • ETL

Goal

At Ranco Labs, translate customer-support, operations, and management reporting needs into accurate reports and dashboards for operational decision-making.

My contribution

  • Gathered reporting requirements from stakeholders and documented KPIs, report detail, and business rules; prepared CMS, SQL, and ETL data for reporting.
  • Built parameter-driven SSRS reports and Power BI dashboards for support volume, case status, resolution trends, and operational KPIs.
  • Maintained data models and calculations built with basic DAX formulas, tuned SQL queries, and reconciled reports against source data to investigate discrepancies.
  • Automated recurring preparation and validation with Python, reducing manual reporting effort by 15%; documented report logic and delivered approved enhancements.

Work Project

Student Enrollment & Financial Reporting

Key skills

  • Excel
  • SQL Server
  • PivotTables
  • XLOOKUP
  • Workday Student

Goal

At the University of Arkansas at Little Rock, prepare reliable recurring reports on student registration, enrollment, payments, scholarships, and renewals.

My contribution

  • Prepared weekly and monthly Excel reports, using PivotTables, XLOOKUP, formulas, and conditional formatting to organize and review student data.
  • Queried SQL Server to filter records, verify totals, identify duplicates, and investigate reporting questions.
  • Validated record counts, filters, dates, and totals against source data before sharing report results.
  • Supported Workday Student reporting questions and maintained support and reporting notes in line with university confidentiality and access procedures.

Work Project

Retail Sales, Inventory & Store Performance

Key skills

  • SQL Server
  • Excel
  • Power Query
  • Power BI
  • DAX
  • Power BI Service

Goal

At TCS, support an end-to-end sales and inventory analytics project for Coinstar, providing reporting and performance insights to U.S. business stakeholders.

My contribution

  • Worked with sales, inventory, and operations teams to gather requirements and document KPI calculations and reporting granularity, then combined SQL Server and Excel/CSV data.
  • Cleaned and transformed data with Excel and Power Query; designed a star-schema model and built calculations with basic DAX formulas for sales, growth, running totals, average basket size, and store performance.
  • Built and maintained 6–7 interactive Power BI dashboards covering product, customer, inventory, store, trend, variance, segmentation, and cohort analysis.
  • Reconciled KPIs with SQL source data, published reports with row-level security and scheduled refreshes, and shared findings and approved enhancements through Agile delivery cycles.

Master's Project

Retail Sales Analytics

Key skills

  • Excel
  • Power Query
  • SQL Server
  • Power BI
  • DAX

Goal

Organize retail sales data and report on sales, profit, customers, products, and regions.

My contribution

  • Cleaned and standardized data using Excel and Power Query, then staged and cleaned it in SQL Server.
  • Modeled date, customer, product, geography, and sales fact tables.
  • Built a three-page Power BI dashboard: Executive Overview, Product Performance, and Customer & Region.
  • Created basic DAX formulas for total sales, profit, profit margin, orders, units sold, average order value, return rate, YTD and YoY sales.

Master's Project

Pharmacy Inventory and Sales Analysis

Key skills

  • SQL Server
  • Power BI
  • Power Query
  • DAX

Goal

Explore pharmacy sales and inventory data through KPIs and interactive reporting.

My contribution

  • Reviewed and cleaned a dataset of about 60,000 records.
  • Built Power BI queries and measures.
  • Prepared views for sales, profit, transactions, and quantity.

Master's Project

CO₂ Emissions Analytics

Key skills

  • Python
  • K-Means
  • DBSCAN
  • Random Forest
  • Topological Data Analysis
  • PCA

Goal

Analyze global CO₂ emission patterns across countries with Topological Data Analysis and clustering, and measure how much data cleaning improves the results.

My contribution

  • Selected the top 50 emitters over the most recent 20 years, handled missing values, and standardized the emission series in Python.
  • Grouped countries with K-Means (6 clusters by the elbow method) and DBSCAN; cleaning raised the silhouette score from 0.42 to 0.58 and cut noise points from 12% to 5%.
  • Used Persistent Homology and the Mapper algorithm to reveal stable emission patterns and transitions between country groups.
  • Built a Random Forest model (80/20 split, R² ≈ 0.91) showing oil and coal as the strongest drivers.

Dashboards

Reports and dashboards I have built, turning business questions into KPIs people can act on.

Executive & Sales Overview

A three-page retail analytics dashboard with measures for sales, profit, margin, orders, units sold, average order value, return rate, and YTD/YoY sales.

  • Executive Overview
  • Product Performance
  • Customer & Region

University Student, Faculty & Staff

Department and people-type pie charts alongside IT support, daily and monthly reports, enrollment, payments and scholarship renewals.

  • Students / Faculty / Staff
  • Department
  • IT support
  • Daily / Monthly reports
Open full dashboard →

Customer Support & Operations Dashboard

Support reporting I work on: case volume and backlog, resolution time, and SLA performance by team.

Cases opened
5,630
Cases closed
5,542
Avg resolution
21.8 hrs
SLA breach rate
5.9%

Cases opened vs closed

Monthly volume — backlog grows when opened stays above closed.

Case status by priority

Open and in-progress work, the kind of matrix an SSRS report shows.

Average resolution time by team

Hours from case opened to case closed.

SLA breach rate by team

Share of cases closed after their SLA target.

04 / Experience

Experience

4 years of professional experience, including about 2.5 years in data analysis and reporting, working with business teams on requirements, data validation, and dashboards.

  1. October 2025 – Present

    Reporting Analyst · Ranco Labs

    • Gathering reporting requirements from stakeholders and translating them into accurate reports and dashboards.
    • SQL and ETL data-quality testing and reconciliation.
    • Recurring, ad hoc, KPI, and executive reporting.
    • Python automation and Power BI dashboards.
    • Investigating reporting discrepancies.

  2. April 2024 – May 2025

    Graduate Teaching Assistant · University of Arkansas at Little Rock

    • Instructed undergraduates in Linux, database systems, data mining, and Shell programming.
    • Guided students on schema design and database management.
    • Worked with professors on lectures, assignments, and course assessment.

  3. August 2023 – March 2024

    Support Specialist · University of Arkansas at Little Rock

    • Handled ServiceNow tickets for students, faculty, and staff — new account setup, access requests, login issues, and basic application questions.
    • Supported Workday Student users on registration, enrollment, payments, and scholarships; documented complex issues, escalated them to the Systems team, and followed up until resolved.
    • Helped users with Azure MFA setup and login-related questions.
    • Weekly and monthly Excel reports on registrations, enrollment, payments, scholarships, and renewals.
    • SQL Server checks for totals, duplicates, and reporting questions; validated results against source data.

  4. March 2021 – May 2023

    Inventory and Store Performance Analyst · TCS

    • Retail sales and inventory analytics for Coinstar, reporting to U.S. business stakeholders.
    • Gathered requirements and defined KPI calculations and reporting granularity.
    • Built and maintained 6–7 interactive Power BI dashboards; tested results against SQL source data.
    • Published reports through Power BI Service with row-level security and scheduled refreshes.

05 / Process

How I work

  1. 01

    Gather business requirements

  2. 02

    Prepare and validate the data

  3. 03

    Model and analyze

  4. 04

    Build the report or dashboard

  5. 05

    Validate and share insights

06 / Q&A

Ask my portfolio assistant

Have a question about my experience, skills, or projects? Ask below — answers are generated from the content on this page.

Answers come from this portfolio.

07 / Contact

Have a data or reporting opportunity? I’d be happy to hear from you.

Email me

lakamsani1604@gmail.com