Data lineage

Client Needs & Objectives

Our client’s objective was to determine the correct data lineage from the accounting platform to reporting for the FRY-9c and 002 Regulatory Reports
Key Reporting Elements (KRE) were identified and our client wanted to be able to trace the KREs back to the accounting system to better understand the flow of data and any potential transformations

Identify the KREs in scope
Identify the changes that have occurred using newly updated reporting schedules (Gap Analysis)
Using the Master Data Dictionary (MDD), IT lineage software (Informatica) and workshops with internal IT experts we:
- Documented the technical lineage for each KRE (Table and Column at the Landing, Staging and Result stage using the technical lineage in Informatica
- Proposed updates to the MDD and ran workshops to demystify lineages that were unclear / non-existant
Documented next steps for remediation efforts

Clear understanding of the data journey between the accounting system and the reporting system
Identification of gaps and list of remediation items to be addressed by each group
Functional understanding of reporting data flow that can be easily communicated both internally and externally

Cookie	Duration	Description
_ga	2 years	The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.
_gat_gtag_UA_136803493_1	1 minute	Google uses this cookie to distinguish users.
_gid	1 day	Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.