• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Blog
  • News & Events
  • Videos
  • Resources
main-logo-small

Compliance Architects

Consulting Technology Outsourcing

  • About Us
    • Senior Staff
    • Why Us
    • Mission And Vision
    • Clients
    • Partners
    • Career Opportunities
  • Services
    • Inspection Readiness & Enforcement
      • FDA Inspection Readiness
      • Audits & Assessments
      • FDA Enforcement Response/Remediation
    • FDA Quality Consulting
      • Quality System & Compliance Turnarounds / Restructuring
      • Training / Coaching
      • Quality & Compliance Computer-Based Systems
      • External Supply Chain Compliance
      • Part 11 & Computer Systems Validation
      • Turnkey Quality Systems
    • Quality Assurance and Engineering
      • CRPN Quality Roadmap®
      • Quality Culture Assessment
      • Product Quality Consulting
      • Operational Efficiency/Compliance Effectiveness
      • Project/Program Management
    • Corporate Compliance and Litigation
      • Corporate Compliance Programs
      • Interactions With Department Of Justice And The Courts
    • FDA Regulatory Consultants
      • Product Development / Submissions / Commercialization
      • REMS (Risk Evaluation And Mitigation Strategies)
      • Mergers / Acquisitions / Licensing
    • Quality, Compliance, Regulatory & Operations’ Staffing
      • Staffing
      • Talent Management
      • Rapid Turnaround
  • Innovative Solutions
    • Writing for Compliance®
    • CRPN Quality Roadmap®
    • Quality Pulse®
    • IEEP
    • REMS
  • Success Stories
  • Industries
    • Biopharmaceuticals
    • Cannabis/CBD
    • Cell & Gene Therapies
    • Combination Products
    • Cosmetics
    • Dietary Supplements
    • Medical Devices and Diagnostics
    • Pharmaceuticals
  • Contact Us

SharePoint® Quality & Compliance Metrics Reporting

Download a .PDF of this Case Study here:
SharePoint® Quality & Compliance Metrics Reporting

Client Business Situation

Pharmaceutical Quality MetricsClient was trying to manage a complex enterprise enforcement remediation activity without the benefit of useable information on quality systems’ metrics or quality system effectiveness. Most site quality information was being collected on Microsoft Excel spreadsheets, with much difficulty, and being emailed to a central location for consolidation and subsequent publishing. The information was often weeks or up to a month old, and had little accuracy or consistency, since data standards had not been applied nor data aggregation rules defined.  Further, little meaningful analysis of the data aggregated was being performed, since all efforts were focused on the highly-inefficient data collection and aggregation process.

Client Business Pain

Substantial personnel resource time was being devoted to sending around massive spreadsheets, and trying to format and create derivative reports from the data.  Collected data was also being used for Management Review purposes, and Management Review preparation time averaged two months to gather and prepare information for the Management Review meeting.   Client Quality Management was having a difficult time determining what activities should be escalated for executive management focus, given the poor quality of the data and information and the dated and inconsistent nature. Without adequate information and real-time metrics for analysis and follow-up, remediation activities were proving difficult to complete, and executive focus was not resulting in sufficiently rapid change.

Solutions Provided/Services Delivered

Pharmaceutical Quality MetricsAs part of a larger, enterprise compliance remediation effort, Compliance Architects® conceptualized, developed and implemented an innovative, Microsoft SharePoint®-based quality and compliance metrics reporting model, to provide enterprise visibility across multiple sites, regulated product classes and quality subsystems.

Initial project activities focused on alignment of data definitions and sources across multiple regions, divisions and sites.   Significant work on alignment of definitions was necessary since many critical quality measures were not consistent from site to site, nor region to region.   Significant organizational resistance was experienced when changes to definitions were mandated to ensure cross-enterprise alignment.

By integrating information previously contained within the massive Microsoft Excel spreadsheets, and integrating real-time information from a specialized computer-based NC/CAPA system, the Quality Operations Portal has evolved to contain real-time data on NC, CAPA, recall, holds, supplier quality, external manufacturing, change control, training and other quality system reporting datasets.   The solution delivery introduced the concept of “real-time” or “pushbutton” reporting where all data sets are updated, and customized, up-to-date reports are created, at the literal push of a button.

Benefits Realized

The Quality Operations Portal has become the “go-to” executive quality management destination for real-time quality and compliance metrics.  Regularly enhanced, the site permits quality metrics information to be immediately available to executive management, resulting in improved focus, reduced compliance risk and reduced business risk.  By leveraging the company’s enterprise installation of Microsoft SharePoint®, Compliance Architects® was able to save the company substantial amounts of money on IT infrastructure and license costs while ensuring consistency with internal IT/IS standards and establishing the long-term viability of the solution.

In addition, the critical Management Review process was greatly enhanced.   Preparation time for Management Review was reduced from over two months to less than one day due to the “pushbutton reporting” capability of the solution.   Although this resource reduction was welcomed, the biggest impact was the company’s ability to spend more time on analysis and assessment of acquired data — something that couldn’t be done with the previous activities.

Primary Sidebar

Case Study

  • Client References
    CA-JCP-012
  • Product Classes Manufactured
    Cosmetic, Medical Device, OTC Pharmaceutical
  • Number of Employees
    15,000 +
  • Number of Client Sites
    Five (5) plus dozens of external manufacturers
  • Operating Scope
    Global
  • Annual Revenue
    $8 billion +

Footer

Compliance Architects®

  • Contact Us
  • (888) 734-9778
  • info@compliancearchitects.com

Quick Links

  • About Us
    • Senior Staff
    • Why Us
    • Mission And Vision
    • Clients
    • Partners
    • Career Opportunities
  • Services
    • Inspection Readiness & Enforcement
      • FDA Inspection Readiness
      • Audits & Assessments
      • FDA Enforcement Response/Remediation
    • FDA Quality Consulting
      • Quality System & Compliance Turnarounds / Restructuring
      • Training / Coaching
      • Quality & Compliance Computer-Based Systems
      • External Supply Chain Compliance
      • Part 11 & Computer Systems Validation
      • Turnkey Quality Systems
    • Quality Assurance and Engineering
      • CRPN Quality Roadmap®
      • Quality Culture Assessment
      • Product Quality Consulting
      • Operational Efficiency/Compliance Effectiveness
      • Project/Program Management
    • Corporate Compliance and Litigation
      • Corporate Compliance Programs
      • Interactions With Department Of Justice And The Courts
    • FDA Regulatory Consultants
      • Product Development / Submissions / Commercialization
      • REMS (Risk Evaluation And Mitigation Strategies)
      • Mergers / Acquisitions / Licensing
    • Quality, Compliance, Regulatory & Operations’ Staffing
      • Staffing
      • Talent Management
      • Rapid Turnaround
  • Innovative Solutions
    • Writing for Compliance®
    • CRPN Quality Roadmap®
    • Quality Pulse®
    • IEEP
    • REMS
  • Success Stories
  • Industries
    • Biopharmaceuticals
    • Cannabis/CBD
    • Cell & Gene Therapies
    • Combination Products
    • Cosmetics
    • Dietary Supplements
    • Medical Devices and Diagnostics
    • Pharmaceuticals
  • Contact Us

Our Services

  • Inspection Readiness & Enforcement
  • FDA Quality Consulting – Systems and Training
  • Quality Assurance and Engineering
  • Corporate Compliance and Litigation Services
  • FDA Regulatory Consultants – Due Diligence
  • Quality, Compliance, Regulatory & Operations’ Staffing Services

Proprietary Solutions

  • Writing for Compliance®
  • Quality Pulse®
  • CRPN Quality Roadmap®

© 2009-2023 Compliance Architects Holdings LLC – used by permission. All copyrights, trademarks and other intellectual property are the property of Compliance Architects Holdings LLC and are used by permission.

  • Debarment Certification Statement
  • Privacy Policy
  • Terms of Use

Contact Us Today

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT