Prashant Shetty
Las Vegas,NV
Summary
Senior Data Analyst specializing in healthcare with over 8 years of experience in developing KPI frameworks and conducting data quality audits. Proficient in SQL and Power BI for executive reporting and analysis of complex datasets. Skilled in translating data insights into actionable recommendations for non-technical stakeholders. Strong focus on security and compliance in regulated environments, providing support to end users and external clients.
Overview
14
14
years of professional experience
Work History
Sr. Data Lead /SQL BI Developer
Aveanna Healthcare
Las Vegas, Nevada
06.2023 - Current
- Drove end-to-end analytics delivery by translating leadership goals and business requirements into KPI frameworks, complex SQL data models, and intuitive Power BI experiences for non-technical users.
- Built and owned 15–20 Power BI dashboards/reports (hourly, daily, weekly, monthly cadence) with automated refresh and email distribution, enabling organization-wide visibility.
- Delivered key operational reporting, including Patient Reports, SOC/Pending SOC dashboards, Patient Access scorecards, backlog/aging, and throughput metrics used in leadership reviews.
- Automated recurring reporting using Power Automate flows and advanced VBA, saving approximately 20 to 30 hours per week while improving consistency and auditability.
- Designed SQL-based ETL and reusable data marts/pipelines, improving BI reporting efficiency by approximately 30% through standardized datasets and streamlined refresh processes.
- Optimized critical stored procedures/views via indexing and query refactors, improving performance by approximately 60% to 90% and stabilizing reporting SLAs.
- Audited complex healthcare datasets for completeness, validity, and performed EDA, basic statistical checks to identify trends, outliers, and data pitfalls before publishing KPI scorecards.
Sr. Data & Reporting Analyst
Sands Corp
Las Vegas, Nevada
03.2023 - 06.2023
- Built four Power BI dashboards, moving from Excel-only reporting to scalable, self-serve FinOps/IT cost analytics for approximately 30,000 users, partnering with APAC and EMEA IT/integration teams to deliver near real-time (30-minute refresh) cloud/virtualization reporting.
- Standardized cloud cost/usage reporting across Azure, AWS, and VMware by defining a consistent KPI layer and dimensional model (cost center, app, subscription/account, region), enabling cross-region comparability.
- Developed leadership KPI views including Spend by Cost Center/App/Subscription/Account, Actual vs Budget (Variance %), Month-End Run-Rate Forecast, Unit Cost (Cost/VM, vCPU-hour, GB stored), Unallocated/Untagged Spend, and Top Cost Driver decomposition (compute vs storage vs network vs licensing).
- Built VMware KPI reporting (VM density, vCPU/memory utilization, license compliance and license utilization) and implemented quality controls (freshness lag, completeness %, duplicate rate, billing reconciliation) to improve trust and reduce rework/escalations.
Business Intelligence Engineer
Amazon
Las Vegas, Nevada
02.2021 - 03.2023
- Supported two organizations (Ring and Last Mile), delivering QuickSight and Excel analytics for international rollout including. EMEA and operational performance, partnering with stakeholders to define KPI frameworks and scorecards.
- Developed complex Redshift SQL data models and queries, powering self-serve reporting and deep dives, translating business requirements into clear, user-friendly dashboards, and decision-ready insights.
- Built KPI reporting across regions/countries including Dealer Performance Rate (dealer rate) trends, On-time Delivery / SLA adherence, Volume & Backlog trends, and finance metrics such as Chargebacks and Variance to Plan (%).
- Engineered Datanet ETL pipelines reduce manual data handling by approximately 730 hours per year and automate recurring leadership reporting, saving over 500 hours per year; delivered major automation wins, including $2.5 million in savings in 5 months (chargeback/variance system), and approximately 90% efficiency improvement, plus 1,300 to 1,500 hours per year saved via Python (Selenium) automation in Excel.
Sr. Data Analyst
PepsiCo
High Point, North Carolina
01.2020 - 02.2021
- Streamlined A/R and credit operations through an Excel VBA automation model, improving efficiency by approximately 20% and generating approximately $4 million in savings while strengthening process adherence and escalation management.
- Built and maintained performance reporting using Excel, Power BI, and SQL, tracking credit/collections KPIs, including Past Due %, to support cost reduction and operational decision-making.
- Improved data integrity through data quality assurance and cleansing (Excel + SQL), ensuring reliable KPI reporting, and stakeholder confidence.
- Managed large datasets across Azure and MySQL, executing ETL into SQL packages, and partnering with Finance and Operations to translate business needs into actionable insights and KPI improvements.
Lead Data & Analytics Consultant
TJ Maxx
Boston, Massachusetts
12.2019 - 01.2020
- Short-term contract to deliver board-ready month-end visibility: built spend dashboards by consolidating finance datasets in SQL, and standardizing reporting metrics.
Sr. Financial Data Analyst
Lead Design
High Point, North Carolina
06.2019 - 12.2019
- Built and refined forecasting and portfolio models (Excel VBA and Power BI) to guide F&E procurement decisions for more than 10 hospitality clients per month, improving planning accuracy and decision speed.
- Led market research and performance analysis that drove approximately 30% customer base growth and approximately 9% ROI uplift, translating findings into actionable strategy recommendations.
- Used SQL to manipulate and analyze large datasets, supporting marketing and customer analytics (e.g., performance trends and customer lifetime value drivers).
- Partnered with Sales and Purchasing teams to define KPIs, re-evaluate performance metrics, and deliver insight-driven recommendations supporting business objectives.
Sr. Financial Data Analyst
Royal Caribbean
Miami, Florida
01.2012 - 06.2019
- Owned financial reporting and account reconciliations across 11 luxury cruise vessels, improving accuracy, closing workflows, and operational visibility.
- Managed and audited casino cash operations and transaction reconciliations, ensuring controls, compliance, and audit readiness for high-volume revenue streams.
- Built and automated recurring financial and operational KPI reporting using advanced Excel and VBA (cash, expense, sales, and inventory), reducing manual effort and improving consistency.
- Produced budgets, forecasts, and leadership-ready performance packs; translated trends and variances into actionable recommendations for ship leadership and operations teams.
- Served as an officer-level business partner, interfacing with Customer Service, auditors, and cross-functional department heads, aligning reporting and controls with business priorities.
Education
Bachelor of Science - Business Management
University of Mumbai
Mumbai, India05-2011
Skills
- Advanced SQL (data modeling, performance tuning, Redshift)
- Power BI (DAX, dashboards, subscriptions/scheduled refresh)
- KPI design and standardization (scorecards, metric definitions)
- ETL/ELT pipelines (AWS SQL; orchestration, monitoring)
- Automation (Power Automate, VBA, Python)
- AWS Analytics Stack (S3, Redshift, Athena, Glue, Lambda automation, CloudWatch monitoring)
- Other BI tools include Tableau and QuickSight
- Python programming
- Data quality (freshness, completeness, duplicates, reconciliation)
- Exploratory data analysis (basic statistical testing, trend/correlation, significance checks)
- Stakeholder management (cross-functional, exec reporting)
Timeline
Sr. Data Lead /SQL BI Developer
Aveanna Healthcare
06.2023 - Current
Sr. Data & Reporting Analyst
Sands Corp
03.2023 - 06.2023
Business Intelligence Engineer
Amazon
02.2021 - 03.2023
Sr. Data Analyst
PepsiCo
01.2020 - 02.2021
Lead Data & Analytics Consultant
TJ Maxx
12.2019 - 01.2020
Sr. Financial Data Analyst
Lead Design
06.2019 - 12.2019
Sr. Financial Data Analyst
Royal Caribbean
01.2012 - 06.2019
Bachelor of Science - Business Management
University of Mumbai