Vikash Agarwal Email & Phone Number

Hyderabad, IN

Hyderabad, Telangana, India

- Led the creation of a reporting suite in Tableau for a US based professional services company, optimizing labor procurement planning and achieving a 10% reduction in labor costs within a year.- Conducted fraud detection analysis for a US based restaurant chain, leading to termination of employees engaged in fraudulent activities.- Led analytics team in.

Hyderabad, Telangana, India

Successfully ideated & built a time-series model to forecast the minimumbaseline demand of transportation resources needed for a logistics company enabling the client to reduce their shipping costs by 8%.

Hyderabad

• Associated with a Healthcare Service provider client that operates long- term-acute-care hospitals across the U.S generating yearly revenue to the tune of $7 billion
• Developed reporting suite to track top Denial reasons, Denied amount, Collection Rate and other key denial metrics by various cuts of Insurers, facilities etc.
• Created automated reports to reconcile collections claimed by the 3rd party collection agency with the client’s collection data to identify over-claimed bills… Show more Associated with a Healthcare Service provider.
• Created automated reports to reconcile collections claimed by the 3rd party collection agency with the client’s collection data to identify over-claimed bills, enabling the client to recover ~$3M over the last 6 months
• Created dashboards to track key Revenue Cycle Management metrics like Referrals, Admissions, Denial Rate, Collection rate on SAP Design Studio
• Analyzed billing data to develop insights into AR that is not released to Insurers enabling the client to optimize AR Days Show less

Hyderabad, Telangana, India

• Associated with an elevator parts manufacturer client based out of U.S generating yearly revenue to the tune of $250 million.
• Synthesized Business Intelligence data using SQL and created dashboards using Tableau to enable the client monitor key business performance indicators across different business verticals (sales, finance, operations etc.)
• Built a Revenue forecasting model using Excel enabling the client to conduct Budget vs. Actual comparison
• Spearheaded an in-depth… Show more Associated with an elevator parts manufacturer client based out of U.S generating yearly revenue to the tune of $250 million.
• Spearheaded an in-depth analysis of customer behavior, their purchase patterns and generated insights which helped the client to make a data-driven business decision of cross-selling the products Show less

• Associated with a large BFSI client based out of U.K.
• Developed and tested new product change requests prior to release to assist development team in identifying and fixing bugs for a portal to process Insurance claims.
• Processed over 500 support requests received over 6 months from end users for technical assistance on wide range of issues related to Guidewire and patiently walked individuals through basic troubleshooting tasks via.