Finance Data Quality Assessment & Recommendations.
Benefits & Results
Background
Sky UK Limited is a British broadcaster and telecommunications company providing television, broadband internet, and fixed-line and mobile telephone services. Part of Comcast since 2018, Sky is committed to delivering innovative services and maintaining high standards in financial operations. The company's finance team faced significant challenges in data quality, impacting their reporting, operational efficiency, and readiness for future technology upgrades.
Challenges
Issue Identification: Sky Finance dealt with critical data quality issues within their finance data model, particularly in the Chart of Accounts and Enterprise Structures in the SAP ECC on HANA system. Key pain points included data misalignment, duplication, and high cycle times for month-end closing, compounded by extensive manual data manipulation.
Issue Impact: These challenges led to inefficiencies in the month-end closing process, increased operational costs, and hindered employee engagement due to repetitive data-related tasks. The inability to meet Comcast's reporting requirements without extensive manual intervention posed a risk to compliance and strategic business goals.
Solution
NowVertical's Role: NowVertical conducted a detailed assessment of existing audit processes and anomaly patterns in patient transactions. They integrated patients information along with providers and affiliates in GCP, creating a foundation for developing data science models to detect anomaly patterns and raised a warning to the audit team to investigate and prevent questionable medical procedures on patients
Implementation
- Conducted workshops and interviews with key stakeholders to identify pain points and gather insights.
- Analyzed data extracts using Power BI and Excel tools based on 35 pre-defined criteria.
- Evaluated General Ledger Accounts (Chart of Accounts), Profit Centres, Cost Centres, Trading Partners, and WBS Elements.
- Provided short-term fixes for issues like duplicates and misalignment; Developed a long-term roadmap for data quality improvement, aligning the finance data model with future technology upgrades, particularly the migration to SAP S/4HANA; Utilized Power BI for showcasing data quality assessment findings.