The Problem​

A client's extensive customer base exposed them to potential fines from the FCC for non-compliance with Customer PII (Personally Identifiable Information) and CPNI (Consumer Proprietary Network Information) regulations. Non-compliance can result in hefty fines reaching upwards of $80 million, jeopardizing the bottom line. The client lacked sufficient visibility into their data storage systems, making it difficult to access and ensure timely compliance. Gaining clear visibility into the client’s data storage systems was a challenge. Without this enhanced observability, assessing and ensuring compliance was a guessing game or sheer luck.   ​

Determined to proactively safeguard sensitive customer information and uphold regulatory commitments, the client knew they needed real-time, trustworthy insights into their data landscape. They set out to strengthen their compliance posture and empower their teams to act quickly and confidently when issues arose.

How Kenway Helped

Kenway’s expertise in Data Management, Data Integration, Business Intelligence, and Business Process Assessment allowed us to uniquely met the needs of this organization. Kenway identified the appropriate backend source systems and engaged the database administrators to ingest data into Power BI. Kenway wrote custom scripts to parse through a system fallout mailbox to load that data into the BI tool to reconcile against the backend data sources. The team delivered reliable, real-time reporting to the client team with a dashboard to address their gaps, enabling leadership to promptly identify finable offenses and correct within the mandated timeframes. The team built current and future state system mappings which supported the client’s approach to proactively reduce defects before they occur. The deliverables provided were:

• Reliable, Real-time, Interactive Reporting Package​
  • Embedded logic to identify which records required immediate attention from the Compliance Team​
  • Deployed a product-centric approach to easily expand scope and scale at ease​
• Comprehensive Data Flow Diagrams​
  • Provided root cause visibility by creating detailed current and desired state system and data flow maps which facilitated efficient investigations and prevented potential fallouts before they occurred​
• Secure Environments​
  • Leveraging Cloud Gateways and ODBC drivers for security connectivity​
  • Secure daily data refreshes to reflect records that were rectified the day prior

​Results​

Users now have over 10 up-to-date, well-designed, exportable reports at their fingertips. This enabled the Compliance Team to streamline troubleshooting by tracing system fallouts to their root cause for swift investigations and rectifications within the time span defined by the FCC. Users are equipped with an understanding of upstream systems allowing them to streamline their work by proactively addressing potential recurring fallouts and work to limit their occurrence.​