{"id":2351,"date":"2024-01-25T10:18:08","date_gmt":"2024-01-25T10:18:08","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?post_type=case-study&#038;p=2351"},"modified":"2024-05-13T10:18:31","modified_gmt":"2024-05-13T10:18:31","slug":"turbocharging-contractor-offboarding-achieving-60-faster-access-revocation-and-30-policy-compliance-boost-in-a-pharmaceutical-firm","status":"publish","type":"case-study","link":"https:\/\/poiseddevelopers.com\/reality-tech\/casestudies\/turbocharging-contractor-offboarding-achieving-60-faster-access-revocation-and-30-policy-compliance-boost-in-a-pharmaceutical-firm\/","title":{"rendered":"Turbocharging Contractor Offboarding: Achieving 60% Faster Access Revocation and 30% Policy Compliance Boost in a Pharmaceutical Firm"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>This case study presents the successful implementation of an automated Contractor Offboarding Application for a pharmaceutical firm, resulting in a 30% improvement in policy compliance and a 60% acceleration in access revocation.By leveraging PowerApps and Power Automate, the company streamlined its offboarding process, ensuring efficient access management and compliance.<\/p>\n<h2>Business Scenario<\/h2>\n<p>The pharmaceutical company, located in Boston, Massachusetts, grappled with challenges in contractor offboarding. Manual organization-wide emails for offboarding requests led to delays and inefficiencies, including failed device recovery, and occasionally neglecting to revoke user access rights. The need for a more streamlined and automated system was evident to initiate offboarding, revoke access, recover devices, and track request status effectively.<\/p>\n<h2>Project Details<\/h2>\n<p>&nbsp;<\/p>\n<table style=\"border-collapse: collapse; width: 707px; margin-top: 20px; height: 345px;\">\n<thead><\/thead>\n<tbody>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Customer<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Pharmaceutical with 120 staff<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Domain<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Pharmaceutical<\/td>\n<\/tr>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Division\/ Department<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">6 Departments<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Division\/ Department<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Dedicated Resources<\/td>\n<\/tr>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Tools and Technology<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">\n<ul>\n<li>SharePoint Online<\/li>\n<li>Power Automate<\/li>\n<li>Power Apps<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Browser Compatibility<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">nternet Explorer, Edge, Firefox, Chrome, Safari<\/td>\n<\/tr>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Development Mode<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Remote Work<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Our Solution<\/h2>\n<p>To address the challenges, the following strategic solutions were developed:<\/p>\n<p><strong>PowerApps Canvas App:<\/strong><\/p>\n<p>Created an intuitive platform for initiating contractor offboarding, simplifying the user experience.<\/p>\n<p><strong>Offboarding Form:<\/strong><\/p>\n<p>Designed a user-friendly form within PowerApps to capture essential information required for the offboarding process.<\/p>\n<p><strong>Power Automate (Flow) Integration:<\/strong><\/p>\n<p>Integrated Power Automate to automate email notifications, alerting relevant teams about access revocation.<\/p>\n<p><strong>Scheduled Notifications:<\/strong><\/p>\n<p>Utilized Power Automate to schedule and send timely notifications, ensuring prompt handling of offboarding requests.<\/p>\n<p><strong>SharePoint List Data Storage:<\/strong><\/p>\n<p>Employed a SharePoint List to centrally store offboarding data, providing a cohesive repository for progress tracking.<\/p>\n<h2>Benefits<\/h2>\n<p>The Contractor Offboarding Application offered a range of advantages:<\/p>\n<ol>\n<li><strong>Streamlined Process:<\/strong>Simplified offboarding initiation and data collection through an efficient<br role=\"presentation\" data-uw-rm-sr=\"\" \/>PowerApps Canvas App.<\/li>\n<li><strong>Timely Access Revocation:<\/strong>Automated email notifications ensured swift access revocation by<br role=\"presentation\" data-uw-rm-sr=\"\" \/>relevant teams.<\/li>\n<li><strong>Centralized Tracking:<\/strong>SharePoint List facilitated centralized tracking, reducing manual tracking<br role=\"presentation\" data-uw-rm-sr=\"\" \/>efforts and enhancing visibility.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2361 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02.webp\" alt=\"img\" width=\"2084\" height=\"1186\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02.webp 2084w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02-300x171.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02-1024x583.webp 1024w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02-768x437.webp 768w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02-1536x874.webp 1536w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/02-2048x1166.webp 2048w\" sizes=\"auto, (max-width: 2084px) 100vw, 2084px\" \/><\/li>\n<li><strong>Increased Efficiency:<\/strong>User-friendly interface and automation led to reduced effort, enabling HR to focus on critical tasks.<\/li>\n<li><strong>Enhanced Compliance:<\/strong>Automated offboarding maintained consistency and compliance in contractor exits.<\/li>\n<li><span id=\"elementor-toc__heading-anchor-5\" class=\"elementor-menu-anchor \"><\/span><br \/>\n<h2>Results<\/h2>\n<p>The Contractor Offboarding Application achieved an impressive 60% improvement in the offboarding process. It streamlined operations, mitigated administrative overhead, and ensured seamless access revocation and device recovery. Lastly, it enabled a comprehensive system to ensure compliance and reporting for confirmation of performance.<\/p>\n<p>&nbsp;<\/p>\n<h2>Conclusion<\/h2>\n<p>This case study highlights the transformative impact of automated solutions in enhancing compliance, access control, and operational efficiency. The pharmaceutical firm\u2019s commitment to optimizing its offboarding process showcases the potential of technology to drive significant improvements, promoting streamlined operations and compliance within the organization.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2362 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/3-1.webp\" alt=\"img\" width=\"730\" height=\"411\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/3-1.webp 730w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/3-1-300x169.webp 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/li>\n<\/ol>\n","protected":false},"featured_media":3458,"comment_status":"open","ping_status":"closed","template":"","categories":[18,19],"class_list":["post-2351","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","category-power-apps","category-power-automate"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/case-study\/2351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/case-study"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=2351"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/3458"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=2351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=2351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}