Open to opportunities

Priya Jyothi

@priyajyothi

Senior Data Business Analyst at StateFarm building Power BI dashboards and dimensional models for claims and underwriting.

United States

Message

At StateFarm, I partner with underwriting, claims, actuarial, and finance stakeholders to turn business needs into reporting and technology requirements. I develop Power BI dashboards for claims, underwriting performance, premium growth, loss ratios, and operational KPIs.

I build Star and Snowflake dimensional models for enterprise reporting and self-service business intelligence. I also profile, validate, and reconcile data to investigate reporting and data-quality issues.

Previously, at Morgan Stanley, I analyzed more than 1 million daily financial transactions using SQL and Python. I automated reporting and data-validation workflows with SQL, Python, Azure Data Factory, and Databricks, reducing manual effort by 60%; at Tata Consultancy Services, I developed SQL queries and Power BI dashboards for business and operational reporting.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Business Analyst

Current

StateFarm

Mar 2025 - Present (1 year 7 months)

Partner with underwriting, claims, actuarial, finance, and business stakeholders to gather and analyze business requirements, define KPIs, and translate business objectives into analytical, reporting, and technology solutions. Develop and maintain Power BI dashboards and reports covering claims, underwriting performance, premium growth, loss ratios, and operational KPIs.

SQL Power BI Data Analysis Requirements Gathering KPI Definition Data Modeling Star Schemas Dimensional Modeling (Star And Snowflake Schemas)Data Profiling Data Validation Root Cause Analysis Agile Scrum UAT Functional Testing

Business Analyst

Morgan Stanley

Jan 2024 - Feb 2025 (1 year 1 month)

Partnered with business stakeholders to understand business requirements, reporting needs, and operational challenges. Analyzed over 1 million daily financial transactions using SQL and Python to identify trends, anomalies, and business performance metrics, and automated reporting workflows reducing manual effort by 60%.

SQL Python Power BI Data Analysis Azure Data Factory Databricks Data Profiling Data Validation Root Cause Analysis Report Automation

Data Analyst

Tata Consultancy Services

Feb 2021 - Dec 2022 (1 year 10 months)

Gathered and documented business requirements, translating them into BRDs, FRDs, user stories, and reporting specifications. Developed SQL queries and Power BI dashboards tracking customer acquisition, churn, revenue, and operational KPIs, and built enterprise reporting solutions using Azure Databricks, AWS Redshift, and SQL Server.