WORKFLOW USE CASE
Data Reconciliation
Everysk can automate reconciliations of day-over-day changes in datasets and produce smart reports that alert users of any differences that require attention. Save hours of manual checks and instantly surface potential issues by building custom thresholds and checks into your data processing. Utilizes: Seven digital robots.
Eliminate Errors
Fund managers and capital markets professionals deal with large datasets that are updated daily. Whether it’s a time series, risk analytics, or alpha signals, critical decisions depend on the accuracy and integrity of these datasets. Detecting errors and large changes as they arise is essential to ensuring the integrity of these datasets. Often data errors are found by manual checks, eyeballing reports, or it is not performed at all.
Everysk is capable of performing automated reconciliations on datasets so users are alerted when significant changes occur. Custom thresholds are applied to individual metrics, summary reports are distributed, and alerts are sent in real-time to users’ messaging apps – dramatically speeding up the reconciliation process.
Manual burdens and guesswork are removed as users receive powerful, reliable data quality assurance, tailored to their specific needs.
Explore the different possibilities of these robots below.
Comprehensive Review
Data Reconciliation
Everysk’s Data Reconciliation Workflows utilize seven pre-built no-code, low-code robots. Users string these robots together via our drag and drop interface. Keep reading to see the role each plays in providing users with automated, quality assured data checks.
Data Integration Robot
The workflow pulls in data sets from D and D-1 for comparison. Data can be pulled from any SFTP or API integration. Data arrives in a raw format and is normalized into a standard format through the process.
Limits Retriever Robot
A metadata table that stores tolerances per data type is retrieved from the system. Each analytic has a customizable threshold of what day-over-day percent difference triggers a warning. The values can be easily edited by users in the platform or fed in dynamically.
Reconciliation Engine Robot
A reconciliation robot checks the percent differences of each analytic per position over the previous business dates. Clients can specify these checks within the Everysk platform or import their own code to the engine.
Datastore Editor Robot
The percent differences and pass/fail results of the checks are added to the latest datastores to enhance the original dataset.
Limit Checks Robot
A compliance robot is used to create a compliance table that summarizes the checks for each data type and creates an object that can be used in a report. Each compliance check can be itemized and specified by clicking into the configurable menu.
Report Generator Robot
Datastores with the data checks and compliance results are passed to a customizable report template to generate a daily reconciliation report. The report summarizes any analytic that had large day-over-day changes and the details of which securities breached the limits.
Email Distribution Robot
Reports are sent out to a distribution list via email. Further alerts can be configured if there are high impact errors that require urgent attention.
Key Workflow Benefits
Add peace of mind to your data operation, and put the controls in place to be alerted to data quality issues when they arise.
Relieve your people of tedious data check work. Utilize the machine precision of scheduled automated checks.
Customized thresholds, user friendly no-code interface and the flexibility to control the code for power users gives clients the freedom to design their own data checks.
