Ayushi Jar

Supply Chain Data Analyst @Cigna Healthcare

CT, US

Gathered and documented supply chain business requirements, data dictionaries and workflows to ensure alignmentwith SDLC best practices and seamless integration with procurement, logistics and clinical operations.• Designed and maintained end-to-end ETL pipelines integrating supplier, procurement and EHR/EDI feeds intoSnowflake, ensuring high-quality, unified datasets for demand planning and inventory optimization.• Developed advanced forecasting models using time-series and machine learning techniques (Prophet, scikit-learn,stats models) to predict demand for critical drugs and surgical kits, improving forecast accuracy by 18%.• Optimized inventory strategies through linear and integer programming in Gurobi, enabling scenario modeling forSales & Operations Planning (S & OP) and reducing excess inventory costs by millions annually.• Conducted supplier performance analytics (fill-rate variance, lead-time distribution, cost-variance trends) to evaluatevendor reliability and strengthen supplier relationship management.• Worked on root cause analyses of backorders and supply disruptions using SQL and Python diagnostics, identifyingsystemic drivers of delays and reducing stockouts by 23% while maintaining a 95% SLA for critical supplies.• Developed interactive executive dashboards in Tableau and ThoughtSpot with KPIs such as OTIF (On-Time In-Full),days-on-hand and lead-time variance, accelerating procurement and finance decision-making cycles by 30%.• Implemented automated data quality checks and anomaly detection frameworks to monitor stockout and overstockevents, enhancing data observability and preventing costly disruptions.• Ensured HIPAA compliance and PHI/PII security by implementing data masking, encryption and role-based accesscontrols across cloud-based storage and reporting environments.• Collaborated with cross-functional teams including procurement, finance, logistics and IT in Agile

University of New Haven

Masters, Data Science

Jabalpur Engineering College

Bachelor of Technology - BTech, electronics and communication engineering