Ayushi Agrawal
Data-Driven Business Intelligence Graduate | Turning Data into Strategic Insights
- Role
- Data Analyst at Anthem, Inc
- Location
- New York, NY, US
- LinkedIn followers
- 500 followers
About Ayushi Agrawal
AI Product Analyst with 3+ years of experience in product analytics, machine learning…
Experience
Data Analyst
May 2024 — Present · Hoboken, NJ, US
Collaborated with Fraud Investigation, Data Engineering, and Compliance teams in Agile sprints, using JIRA for task management and Confluence for documentation to define project scope and requirements for healthcare claims fraud analysis. • Wrote complex SQL queries involving subqueries, INNER, LEFT, and FULL JOINs, window functions, and CTEs to extract, aggregate, and analyze claims data from large-scale relational databases, supporting fraud pattern detection. • Processed multi-format data from hospitals, pharmacies, and providers using AWS Athena, Glue, and Power Query to create scalable ETL pipelines, enabling efficient data transformation and cleansing workflows. • Conducted exploratory data analysis with hypothesis testing, correlation, and visualization on millions of claims records, identifying patterns that contributed to a 12% decrease in suspicious claims and improved fraud detection. • Used Python (pandas, NumPy, SciPy, Matplotlib) for time-series and cohort analysis, using outlier detection techniques to find anomalies in claims data, significantly boosting the accuracy and effectiveness of fraud detection models. • Developed interactive Power BI dashboards featuring slicers, drill-through reports, and real-time KPI alerts, leveraging advanced DAX measures to calculate fraud risk scores, increasing fraud detection efficiency by 15%.
Education
University Institute of Technology, RGPV
Bachelor of Technology - BTech
2019 — 2023
Stevens Institute of Technology
Master of Science - MS
2023 — 2025
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.