As a Manager at Merilytics, I lead a team of data analysts who provide insights and solutions to clients across Healthcare, Logistics, Professional Services and Hospitality sectors. I have successfully developed and implemented data pipelines, dashboards, and models that track key metrics, identify opportunities, and drive strategic business decisions. For example, I helped a client recover ~$3M by creating an automated model to reconcile collections data with a third-party agency. I have also earned certifications in Power BI and Scrum, demonstrating my proficiency and commitment to data analysis and project management.I graduated from IIT Delhi in 2017 with a BTech in Civil Engineering, where I developed my logical reasoning and attention to detail skills. I am passionate about solving real problems and delivering value to clients and stakeholders. I am always eager to learn new tools and techniques to enhance my data analytics skills and stay updated with the latest trends and best practices in the industry.
-
DirectorAccordion IndiaHyderabad, In -
ManagerMerilytics Oct 2021 - PresentHyderabad, 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 constructing a comprehensive catalogue of Power BI reports for a US based logistics services company, enabling them to achieve their… Show more - 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 constructing a comprehensive catalogue of Power BI reports for a US based logistics services company, enabling them to achieve their first profitable quarter (Q1 2022) in 5 years. Show less -
Senior AssociateMerilytics Apr 2021 - Sep 2021Hyderabad, Telangana, IndiaSuccessfully 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%. -
Associate Business AnalystMerilytics Inc. Oct 2019 - Mar 2021HyderabadAssociated 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 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, 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 -
Senior Business AnalystMerilytics Aug 2018 - Sep 2019Hyderabad, Telangana, IndiaAssociated 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.• 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 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 -
Associate ConsultantCapgemini Sep 2017 - Jul 2018Associated 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 emails
Vikash Agarwal Education Details
-
Civil Engineering
Frequently Asked Questions about Vikash Agarwal
What company does Vikash Agarwal work for?
Vikash Agarwal works for Accordion India
What is Vikash Agarwal's role at the current company?
Vikash Agarwal's current role is Director.
What schools did Vikash Agarwal attend?
Vikash Agarwal attended Indian Institute Of Technology, Delhi.
Who are Vikash Agarwal's colleagues?
Vikash Agarwal's colleagues are Upendra Dwivedi, Daniel J. Choi, Felix Ogutu, Juan Pablo Contreras, Anudeep Vadlakonda, Matt Tyburowski, Ridhi Sood.
Not the Vikash Agarwal you were looking for?
-
Vikash Agarwal
Bengaluru -
Vikash Agarwal
Mumbai -
-
-
Vikash Agarwal
Kolkata
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial