Global Health Services Company Modernises Data and Applications with Microsoft A global health services company needed to execute on its corporate promise to deliver affordability and convenience to its patients. However, the company discovered that there was a disconnect between that promise and intended delivery. Further investigating that disconnect revealed that the organisation's procedures for tracking and delivering rebate payments were hampered by complex, time-consuming processes, and inconsistent data. Seeking to modernise their processes, institute governance and improve efficiency, the company sought to leverage Microsoft technologies to transform how the company handled rebates. Topics Data, Analytics and Business Intelligence Digital Transformation Industries Healthcare Client Snapshot Profile Global Health Services Company Client Situation Payment processes were complex, time-consuming with inconsistent data Work Performed Modernised the data and applications with Microsoft Azure and Power Platform Outcome/Benefits Modernised Microsoft solution achieves operational efficiency and improves data quality Manual processes and lack of integration were causing operational inefficiencies Looking closely at their processes, the company identified inefficiencies in its two-part process for managing rebates. The first part of the process consisted of the accruals team capturing and tracking the precise dollar amounts involved. The second part of the process involved the disbursement team approving and sending out the correct payments to the right recipients. In the two-part process for managing rebates, there were several challenges uncovered, which included Manual and disjointed processes that required a significant time investment from human resources on both the accrual and disbursement teams to get each rebate payment processed. Lack of integration forced team members to spend a lot of time manually pulling data from various disparate systems. These disparate tools such as Excel, Access and Netezza were used to manipulate the data, which required numerous manual steps and lacked integration and potentially created holes in the flow of information. Delayed approval processes with reports being circulated via email threads to get needed approvals. A process which introduced back-and-forth email communication, often causing delays and making it easy for conversations, feedback or file attachments to get lost in inboxes. Operational inefficiencies were causing employees to be bogged down with manual processes, email chains and manually manipulating Excel spreadsheets and relying complex formulas. Organisational shift toward the cloud As the company looked to modernise their operations, it became clear that a company-wide transformation effort was needed. Ultimately, the goal was to move its data into the cloud and transition to centralised processes. During the planning and discovery process, it was evident that some of the data the accrual and disbursement teams used would need to be migrated to Azure-based sources, spurring the need for changes in their process. That observation manifested into an opportunity to modernise the highly manual rebate process as part of the organisational shift toward the cloud. The company expected that moving to the cloud would give them more processing speed and reliability than they could achieve on-premises. The company opted to partner with Protiviti to implement Microsoft solutions to modernise their end-to-end rebate process to make it more efficient, streamlined, and timely for both their employees, prescription drug manufacturers and insurance plan clients. Modernising the data and environment with Azure Synapse, Azure, Power Apps: The accrual and disbursement teams met with Protiviti to document the current processes in use. Defining those processes relied on querying individual employees gathering information that became the foundation to design a solution to remove the bulk of the manual work from both teams. Working closely with the client, Protiviti was able to build a custom Microsoft solution that would meet the needs of both the accrual and disbursement teams. Leveraging Microsoft Power BI, Azure Synapse, Azure Data Lake, Azure Data Factory and the Power Platform, this solution automated and modernised their data and reporting processes while also allowing teams to provide comments and feedback on their reports as a part of the newly automated approval process. Now, this global health services organisation has a modernised, end-to-end process, from accrual to disbursement, streamlined into a singular cloud solution. This reduces the human hours required for data gathering, manipulating, and reporting. It also automates the workflow, reducing the risk of files being lost, delays in the timeline and communication breakdowns. Modernisation leads to processing patient rebates smoothly and efficiently The organisation has achieved operational efficiency on both sides of the rebate equation using the modernised applications built on Microsoft Azure. The benefits include: Improved the reliability and consistency of data used for accruals and tracking finances Automated the workflow for accruals and disbursement, freeing up the time of roughly 50 team members to spend on more impactful aspects of their roles Decreased the processing time for disbursing payments Elevated the internal employee user experience Better data governance processes as data does not need to leave the systems and be scattered on manual email threaded processes The global health services organisation knows that to act as a reliable source of guidance for their patients and foster a seamless experience, they must continue to hold their internal processes to the same standard of convenience, efficiency, and reliability. Thanks to the power of these modernised Microsoft applications, the company’s patients can depend on this business adhering to their promise to help them get the services they need when they need it. A modernised, end-to-end process, from accrual to disbursement, streamlined into a singular cloud solution reduces the human hours required for data gathering, manipulating, and reporting. Find out more about our solutions: Microsoft Consulting Solutions Protiviti is a Managed, Microsoft Cloud Solutions Partner with proficiency in all 6 designations: Modern Work, Security, Data and AI, Infrastructure, Digital and Application Innovation and Business Applications. Featured insights BLOGS Building a Business Case for Copilot for Microsoft 365 – A Game-Changer for Business Efficiency With the rapid rise in artificial intelligence (AI) tools, companies are updating technologies and processes as quickly as budgets allow. Industries are transforming rapidly as the drivers for economic growth are evolving. BLOGS Improving Financial Services’ Efficiency with Copilot for Microsoft 365 In an era of rapid technological advancement, businesses are increasingly turning to artificial intelligence (AI) to enhance productivity, streamline processes and improve decision-making. One such tool making waves in the financial services sector... BLOGS Unlocking Agile Insights: Building Automated Burndown Charts with Microsoft DevOps Analytics View and Power BI In the fast-paced world of software development, staying ahead of the curve requires more than just coding prowess. Agile methodologies have emerged to provide a structured framework for teams to navigate the ever-changing landscape. BLOGS Building an Accessibility Culture with Copilot for Microsoft 365 Organisations across the U.S. recognise the criticality of accessibility for both consumers and employees. This concern dates to the early 2000s, when several well-known brands were targeted by lawsuits that ultimately changed how e-commerce works.... BLOGS Cloud synergy: Microsoft Azure and its relationship to Microsoft 365 As organisations increasingly embrace cloud-based technologies to enhance productivity and efficiency, understanding the dynamic relationship between Microsoft Azure and Microsoft 365 becomes crucial for maximising their potential. With the power of... BLOGS Microsoft SharePoint Premium simplifies content management and governance Content management involves the creation, organisation, storage and distribution of digital content within an organisation, ranging from documents and images to videos and web pages. One of the biggest problems businesses face with content management... BLOGS 9 common errors to avoid while implementing security in Microsoft Dynamics 365 Finance and Operations Microsoft Dynamics 365 Finance and Operations (D365FO) is a comprehensive ERP solution that empowers businesses to optimise financial management and operational efficiency. With its integrated approach, powerful analytics, scalability and continuous... BLOGS Navigating the GenAI course with Microsoft Copilot Generative artificial intelligence (GenAI) is a hot topic these days, and not just in the IT world. The statistics indicate off-the-charts interest in GenAI’s capabilities, with AI spending predicted to more than double to $300 billion by 2026.... BLOGS Azure DevOps: 3 tips to organise work items using standard functionality To effectively manage software development projects, it’s crucial to organise work items efficiently. Proper organisation not only boosts productivity but also enhances collaboration among team members. Microsoft Azure DevOps (ADO) is a powerful... BLOGS Capabilities, limitations of Microsoft’s native SoD tool Segregation of duties (SoD) is a well-known term among auditors and anyone who has ever been audited. SoD is the understanding that no user should have access to two conflicting business functions that would allow a user to commit fraud or error (e.g... BLOGS Creating Read-Only Roles for Microsoft Dynamics 365 Finance and Supply Chain Management This blog post was authored by Sarah Guthrie - Senior Consultant, Enterprise Application Solutions on Protiviti's technology insights blog. In today’s fast-paced business landscape, organisations rely heavily on robust enterprise resource planning... BLOGS Migrating Security from Microsoft Dynamics 365 Finance and Supply Chain Management Microsoft Dynamics 365 Finance and Supply Chain Management (D365 F&SCM) publishes security changes with new code releases. These changes are automatically applied to out-of-the-box security roles, duties and privileges when the code is upgraded... Button Button Featured client stories Global Hospitality Company Achieves Efficiencies with Microsoft and Nintex A global hospitality company needed to transition their highly manual process for RFPs to one that was more automated. The need to update their processes was driven by the changes required to address the Covid-19 pandemic, which created a dynamic... Global Retailer Goes Digital: Revitalising Store Operations and Enhancing Community Commitment Protiviti leveraged Microsoft Power BI to help this client transform its operational analytics. We built a user interface that generates analytics every 15 minutes and is easy to use with little training required. From staffing and sales targets to... Intelligent Document Retrieval System, Powered by Responsible AI, Helps Reduce Air Pollution This company is a leader in the supply of after-sale services to the world’s engine and compressor markets and is trusted by nuclear power plants, the U.S. military and both public and private electricity generators around the globe. With the EPA’s... Manufacturer Optimises Supply Chain Analytics With Azure Machine Learning Global Manufacturer optimises supply chain analytics with Microsoft Azure Machine Learning significantly improving its ability to adapt to rapid changes in both processes and cost analyses. Button Button