Pavuluri Niharika

Data Analyst with hands-on experience across retail, financial, and enterprise environments, specializing in reporting, trend analysis, data quality, and business intelligence. Proficient in SQL, Python, Excel, VBA, Bash, Power BI, Tableau, ETL, data modeling, SQL Server, and Oracle. Experienced in building dashboards, preparing reliable datasets, automating recurring analysis, and collaborating with business and technical teams throughout requirements gathering, testing, and deployment.

Known for a practical, detail-oriented approach and the ability to turn complex data into clear, actionable insights

Data Analyst at Walmart (2025-05 – Present)

• Analyzed sales, pricing, inventory, and supply-chain data using SQL, Python, Excel, Power BI, and Tableau to support business and operational decisions.
• Built and maintained dashboards that track sales trends, margin performance, inventory movement, forecast variance, and operational exceptions.
• Extracted data from SQL Server, Oracle, ERP systems, and Excel files and prepare it for recurring reports and ad hoc analysis.
• Wrote SQL queries using joins, CTEs, aggregations, CASE statements, and window functions to combine and summarize data from multiple sources.
• Worked with finance, merchandising, supply-chain, and operations teams to understand reporting needs and define KPI calculations.
• Automated recurring reporting and data-preparation tasks using Python, Power Query, VBA, and scheduled SQL workflows.
• Performed data-quality checks for missing records, duplicate transactions, incorrect mappings, and unexpected changes before reports are shared.
• Investigated differences between source-system data and dashboard results and coordinate corrections with technical teams.
• Supported dashboard and reporting changes through testing, UAT, deployment validation, and post-release review.
• Documented KPI definitions, report logic, validation steps, and user instructions for ongoing support.

Graduate Research Analyst at University of Houston - Clear Lake (2023-08 – 2025-05)

• Supported 60+ graduate students across 4 semesters with coursework and project questions in data mining, statistics, SQL, machine learning, and business intelligence.
• Co-authored research on adversarial machine learning for medical image classification and presented it at ACM ICICT 2026, with experimental results reaching 94%+ model accuracy.
• Maintained rubrics, feedback notes, lab documentation, and reusable examples so evaluation logic, data definitions, and project expectations stayed consistent and easy to explain.

Business Data Analyst at JP Morgan Chase (2022-07 – 2023-07)

• Analyzed financial, transaction, risk, and operational data using SQL, Excel, Python, Power BI, and Tableau.
• Developed reports and dashboards for transaction volumes, processing exceptions, financial variance, operational controls, and risk indicators.
• Met with finance, risk, operations, compliance, and technology teams to gather requirements and clarify business rules.
• Translated stakeholder needs into business requirements, process flows, data definitions, report specifications, and acceptance criteria.
• Used SQL to identify duplicate transactions, missing records, reconciliation differences, and unusual activity across multiple systems.
• Built Excel-based analysis files using pivot tables, Power Query, lookup functions, conditional formulas, and basic VBA automation.
• Supported ETL validation by comparing source data, transformed records, and final reporting outputs.
• Prepared source-to-target mappings, test scenarios, data definitions, and supporting documentation for reporting changes.
• Coordinated UAT activities, tracked defects, validated fixes, and confirmed results with business users.
• Worked with developers and QA teams throughout the SDLC to test, deploy, and validate analytics solutions.
• Presented findings and data issues to business stakeholders in a clear and practical way.

Junior Data Analyst at Capgemini (2020-05 – 2022-07)

• Supported finance, procurement, inventory, and operations reporting by preparing data from Oracle, SQL Server, ERP systems, and flat files.
• Used Talend, SQL, and basic Bash scripting to support ETL workflows, scheduled jobs, file handling, and data validation.
• Built Power BI and Tableau dashboards for operational metrics, process volumes, exceptions, and service-level reporting.
• Wrote SQL queries, views, and stored procedures and performed checks for nulls, duplicates, record-count differences, and referential-integrity issues.
• Worked with business users, developers, and testers across requirements, UAT, deployment, issue resolution, and Agile delivery.

Master of Science in Data Science – University of Houston – Clear Lake

Bachelor of Technology in Computer Science – Institute of Aeronautical Engineering