Vinay Mamillapalli

Project Maverick: Healthcare Providers Data for Anomaly Detection

• Developed Tableau dashboards for calculating comprehensive Length of stay for a each individual facility.
• Creating weekly, monthly, quarterly growth analysis reports and dashboards for patient wait time, claims denial rate, average treatment charge
• Performed Exploratory data analysis and reduced the data from 55k records to 5K unique records which increased the expired providers giving services by 12% .

CMS: Deep Healthcare Analytics:

• Developed Tableau dashboards for the distribution of private and public insurance by Region, Top 5 states in coverage of less insurance, Overall un insured in all the regions.
• Performed Time series forecasting for the out patient with with prediction intervals
• Owned end-to-end clients' deliveries of different reports and ad-hoc analysis for Elevance health by working with multiple stakeholders achieving target revenues ( $10M ) and increasing new insurance holders by 1.75x.

AA Optimization project:

• Deals with Edits that comes while logging commercial claims manually.
• Leading role of project is to increase auto adjudication rate for claims by 72.5% and thereby decrease manual intervention with 40% during claim processing using in house Automation tool SimplifyQA which reduces defect count to 25% in each sprint

WGS Pricing LIGHTSON:

• Project deals with testing of severe production defects in stipulated time in release cycle and ensuring those defects and checking those after implementing in production
• Reported 12 defects in single sprint release and got IMPACT award for highest number of defects in single sprint.