Ayushi Pandey

About Ayushi Pandey

With a Master\'s degree in Business Analytics from The University of Texas at Dallas, my journey at Conifer Health Solutions is marked by crafting data narratives through sophisticated visual dashboards. Advanced analytics and data visualization are the cornerstones of my role, where I employ Python and SQL to extract and interpret complex hospital data.My competencies extend to market intelligence, demonstrated during my tenure at WebstaurantStore, where Python-driven analyses catalyzed a 10% sales boost. These experiences, paired with certifications in Excel for Business Analysts, Social Media Marketing, and Google Ads, underscore my commitment to data-driven decision-making and continuous learning.

Experience

1. Business Insight Analyst Iv

   Conifer Health Solutions

   Dec 2023 — Present · San Francisco, CA, US

   Designed, developed, and maintained automated, stable, and scalable BI and analytics solutions using SQL-driven data models to support clinical and operational priorities related to quality, safety, and performance.• Wrote and optimized complex SQL queries, stored procedures, and functions to extract, transform, and analyze data from enterprise data warehouses and source systems.• Developed and maintained SQL scripts and automated jobs (e.g, scheduled processes, refresh routines, and data pipelines) to support recurring reporting and analytics needs.• Performed data cleansing, validation, and transformation to ensure accuracy, consistency, and reliability of analytical datasets.• Identified efficient data sources and developed standardized analytical datasets, metrics, and statistical algorithms for quality, patient experience, volume, and financial measures.• Ensured data integrity by collaborating closely with the Tenet EDW/BI team on database structures, data definitions, interfaces, and data quality standards.• Built and enhanced dashboards, reports, and user interfaces using tools such as Business Objects and Power BI, supported by a strong SQL foundation across all reporting layers.• Defined problem statements, analytical scope, development timelines, and strategic prioritization in partnership with senior leaders and key stakeholders.• Translated complex SQL-based analyses into clear, actionable insights for hospital and ambulatory operators.• Trained and educated end users on effective interpretation and utilization of reports, dashboards, and underlying metrics.• Participated in team initiatives and supported additional analytics deliverables as needed.

Education

• MODY university of science and technology

  Bachelor of Technology - BTech, Computer Science

  2014 — 2018

• The University of Texas at Dallas

  Master of Science - MS, Business Analytics