Deva Vipul

About Deva Vipul

Results-driven Senior Business Analyst with 4+ years of experience supporting enterprise…

Experience

1. Business Data Analyst

   PNC

   Apr 2024 — Present · TX, US

   Designed QuickBase dashboards and Pipelines for compliance and provider roster management, cutting manual workflows by 45% and improving provider data accuracy. • Built Excel reconciliation dashboards (Power Query, PivotTables, VLOOKUP) for AR disputes, reducing resolution time by 30% and improving forecasting accuracy by 35%. • Conducted Medicaid and regulatory reporting analysis, ensuring 100% compliance with state requirements and improving audit readiness by 25%. • Partnered with FP & A and Legal to reconcile rebate disputes and validate contract compliance, reducing aging disputes by 40% and accelerating resolution timelines. • Delivered executive PowerPoint decks summarizing dispute trends, reconciliation KPIs, provider data quality, and late fee invoice status for senior leadership. • Developed SQL-based anomaly detection models for payment transactions, reducing fraud detection time by 40% and improving exception handling by 90%. • Collaborated with data governance teams to enforce compliance, provider roster integrity, and data quality standards across Snowflake and Teradata systems, boosting reliability by 50%. • Facilitated cross-functional workshops with business, technology, and compliance teams to gather requirements for Medicaid and PBM reporting workflows. • Automated late fee invoice tracking and reconciliation using QuickBase and Excel Power Query, reducing processing errors by 60%. Acted as liaison between business stakeholders, FP & A, Trade Relations, and Legal to ensure financial dispute escalations were properly documented, tagged, and resolved

Education

• SR Engineering College

  Bachelor's degree

• University of Houston-Clear Lake

  Master's degree