Jyothi Priya Murari
Data Engineer @State Farm
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @State Farm
TX, US
Optimized T-SQL queries (CTEs, window functions, stored procs, indexing, partitioning) on multi-million-record datasets, cutting execution time 45% and boosting reporting performance. • Designed scalable Enterprise Data Warehouse with Star/Snowflake schemas, fact/dimension tables, surrogate keys, and SCD Type 1/2. Standardized insurance KPIs (claim/loss ratios, premium growth, underwriting, lapse rates, reserves), boosting data consistency 30% and cutting reporting discrepancies. • Built ETL/ELT pipelines with Azure Data Factory, SSIS, and Python to ingest/transform/validate insurance data from policy/claims systems, CSV/JSON/APIs; cut manual reporting by 20% and boosted accuracy via automation. • Engineered scalable PySpark workflows on Azure Databricks to process high-volume claims, risk profiles, and telematics data—cutting batch processing time by 40% and enabling 3x faster risk aggregation. • Developed Azure Data Lake (ADLS Gen2) with Medallion Architecture (Bronze/Silver/Gold), boosting data reliability 30% and cutting reprocessing 25% for underwriting, compliance, and fraud analytics. • Implemented incremental loading strategies (CDC, watermarking), partitioning, and performance tuning to support near real-time insurance analytics, reducing data latency by 50% and improving pipeline efficiency by 35%. • Built Power BI semantic models and executive dashboards using optimized DAX, RLS, and performance tuning—cut load times 40%, boosted adoption 30% across underwriting, claims, actuarial, and finance. • Applied Python/PySpark for statistical analysis and anomaly detection to identify fraudulent claims, underwriting risk outliers, and abnormal loss patterns—improved fraud detection accuracy by 22% and reduced claims leakage.
EDUCATION
University of North Texas
Master's degree, Information systems and technology
G. Pullla Reddy Engineering College, (Autonomous), Kurnool
Bachelor of Technology, Civil Engineering
ABOUT JYOTHI PRIYA MURARI
Data Engineer with 5+ years of experience designing, developing, and optimizing scalable data pipelines, ETL/ELT workflows, and data warehouse solutions to support analytics and business intelligence. Proficient in Python and SQL with hands-on expertise in Apache Spark, Hadoop, Kafka, and distributed data processing frameworks. Experienced in building batch and real-time data pipelines using Airflow and implementing data modeling techniques including dimensional modeling and data warehousing concepts. Strong knowledge of cloud platforms such as AWS, Azure, and GCP, along with databases including MySQL, PostgreSQL, MongoDB, and Snowflake. Skilled in CI/CD, Git, performance tuning, data quality, and data governance, with a proven ability to deliver reliable, scalable, and high-performance data solutions in agile environments.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.