Ongoing rapid regulatory change and a complex market dynamic present significant challenges for financial institutions’ operating models, analytics and reporting capabilities. As regulators begin to export compliance regulatory requirements downstream to smaller banks as well as buy side firms, these entities will be keenly scrutinizing the pioneering risk data aggregation and integration processes as potential best-practices that can be scaled to their sizes and adapted to specific jurisdictions’ regulatory requirements.
ControllerView (CV) delivers data lineage, risk aggregation, workflow automation, validation and audit functionality and supports disclosures in multiple formats, including XBRL. These features support data and process governance and seamlessly integrate clients’ source data from disparate systems and geographical locations without forcing data conversion. The high-performance platform transparently aggregates clients’ data from multiple siloed systems, enriches and validates it to any level of granularity, and then runs the data through relevant calculations and populates the reports.
Controllerview® Data Flow Diagram
Automation – The increased volume and granularity of data needed to support risk aggregation as well as greater frequency of reporting means that workflow automation is a necessity. ControllerView automates analytics and reporting workflow end-to-end, including all data collection, enrichment, and management, as well as all calculations, processes to final report submission.
Change Management – Visual Business Rules – Tool for handling ongoing change in regulation or business requirements without the need for programming expertise. AxiomSL’s, pioneering visual data modelling and business rules tool, enables users to make even the most complex adjustments to processes in response to changes.
Dashboards – Web browser dashboards can be used to present information and manage processes, such as analysis, drill down and sign-off.
Data Lineage and Transparency – AxiomSL’s agnostic data-driven platform retraces the journey of the source data through every single workflow processes or calculations across siloes systems all the way to disclosures.
Drill Down and 100% Auditability – Every step in the data collection, enrichment and consolidation is tracked and recorded, including all comments. This enables FIs to drill down from any output to the underlying data and processes involved in creating this output. This entire process can be viewed by regulators and internal and external auditors.
Electronic Submission – Supported for all regulators globally in all required formats, including XBRL, XML or other file-based electronic submission. Will also connect directly to regulators’ web services where available for submissions.
Flexibility to deal with any Level of Complexity – ControllerView can handle the flow of information particular to a client’s organization, such as specific Key Risk Indicators (KRIs), syntaxes, data taxonomies and process operating models. Further, as demands like BCBS 239 require near-constant fine-tuning to address data governance, Controller View’s Visual Business Rules enable adjustments to regulatory and management changes with its out-of-the-box configurability and slice-and dice of data.
Global Coverage for all Current Regulations – Basel III, Liquidity, BCBS239, Dodd Frank, FATCA/CRS, EMIR, MiFID, MAS, etc.
High Volume, High Performance and Reliability – Scalable and resilient architecture can handle all volume and performance demands. Reports can be produced at any time interval to meet internal and external requirements.
Leveraging Data and Processes – All data, calculations and other processes defined for one purpose are stored and can be reused wherever required to address new regulations and internal management reporting. It ensures consistency, reduces total cost of ownership (TCO) and accelerates responsiveness.
Pre-submission Review – Multiple report writers allow users to review reports in various formats before submission, with the ability to drill down and make manual adjustments where necessary.
Security and Control – The ability to define granular data and process permissions for hundreds of users provide a completely controlled and secure environment.
Automates complex workflow process enabling users to review results and ensure accuracy
Delivers global coverage of reporting templates with timely update services
Provides comprehensive views of financial information on entity and consolidated levels
Enables business users to analyze each report on-screen line by line, providing comprehensive transparency
Aggregates data to view detail by any grouping criteria, such as Branch, GL accounts, etc. Allowing to view data on transactional trade or positional level at any point of the analysis
Delivers transactional level disaggregation, allowing users to drill-down into the data at any level of granularity
Multi-level sign off – hierarchies can be defined with automated alerts to the next level after signing off
Customizable Data Storage
Allows data to be maintained internally or loaded from an external source
Adapts to changes across institutions, geographies and jurisdictions without systems re-engineering, reducing implementation times
Through drill-down capabilities supports instant verification of aggregate numbers down to individual accounts
Preview of Results
Enables to analyze and adjust reported facts to ensure accuracy prior to submission
AxiomSL’s platform consolidates data from modern and legacy systems by enriching data taxonomies and metadata across the organization. As data is integrated, traceability of the enriched data and workflows is transparent since AxiomSL retains the identity of each source, thus allowing full visibility on ongoing changes and their impacts.
Data lineage is quickly becoming a topline concern and challenge for data managers in financial services. In the past, data lineage—generation of a trail of information that tracks the use and custody of data as it travels throughout the enterprise—was primarily a concern for niche internal projects, usually run by reporting teams. A combination of closer oversight by prudential regulators and rising global standards around data governance, itself, has rapidly led many financial institutions to become more interested in how to do this on a broader level.
AxiomSL’s solution is designed to meet key requirements at once: technical flexibility combined with tailored outputs and visualization. In fact, AxiomSL’s lineage tool brings business and technology users together and provides the answers to the following questions:
Which data sources are used in the generation of a report or reporting line?
What data transformations and business logic is applied to populate a reporting line/cell?
Can I export data lineage information in a readable and printable format to share with team members, keep track of business logic updates between different reporting cycles and for audit?
Can I perform search to see where in the code a data attribute is used example a general ledger account?
Can I get the list of all different reports that utilize a data source?
What will be the impact of updating or decommissioning a data attribute?
What makes AxiomSL’s solution unique is the understanding that data lineage metadata must be available, portable, and presented in user-specific ways. Part of the strength in this area is that, unlike many alternative choices that are just beginning to ramp up data lineage now, AxiomSL has emphasized this area for a long time. As a result, the solution is the most flexible and configurable available with numerous benefits.
Data-lineage tool captures and documents data flows and business logic from the point of data entry to the final report
Empowers the “business user” to make critical decisions with trust and confidence in information
Enhances collaboration across all business functions and IT
Understand quickly where information originates and Improve data governance
Become BCBS 239 compliant quickly and cost effectively without disrupting firms’ existing infrastructure
Reduces cycles spent across teams validating data accuracy
Advantages of AxiomSL’s Platform:
Validation and Exceptions: Firms partnering with AxiomSL can build business-level and validation rules using the platform to enable drill-down and traceability into risk data subsets and associated metadata, while also flagging and documenting potential exceptions for review.
Workflow Automation: Leveraging AxiomSL’s data governance platform allows banks to build the level of sophistication for today’s requirements and future needs.
Change Management Tracking: BCBS 239 is very strong on documenting change, from cell-level adjustments to SQL edits. AxiomSL’s platform automatically populates and archives these respective changes as they happen.
Data Integration: AxiomSL’s platform allows firms to achieve data integration without that risk of disruption or sunken cost.
Dashboards – Customizable user interface (UI) has grown in importance as data management and governance have become less a province of technology and compliance units over time, and are now exposed to a wider array of enterprise-wide personnel. AxiomSL’s new UI dashboard toolkit provides users tools with this sophistication in mind, allowing users greater flexibility to tailor their presentation layer and scheme to business logic in a way that cookie-cutter libraries cannot.
Besides being more role-specific and also more secure, AxiomSL’s new user dashboards provide a higher level of interaction. Designed to be bidirectional, they offer new elements that can “listen” to system events as subscribed to directly by the user, as well as present more static objects and information. These upgrades are in keeping with AxiomSL’s core proposition: providing greater flexibility.
Data Lineage – Industry initiatives such as BCBS 239 have pushed data lineage to the fore. Whereas this area was concerned primarily with the back office and auditing, data lineage has now moved forward to front-office end-users, who require access to granular details about data flow and governance rules without being overwhelmed. Meanwhile, regulatory bodies have begun more closely examining metadata as well.
Very few data governance tools have historically achieved such a balance of drill-down capability, documentation and filtering, and AxiomSL has taken a leadership role in defining and building the necessary components—from enterprise-level frameworks and solutions down to a number of data adapters including one developed in partnership with IBM’s IGC—to solve this puzzle as expectations continue to evolve over time.
R-Script Support – AxiomSL aims to for script-level compatibility wherever possible, and while the use of R isn’t new, its prevalence continues to increase for complex statistical compilations, building time series, and other quantitative analysis activities at major banks and financial institutions. As a result, the AxiomSL platform provides full support for lifting data from our platform into R, directly and without any need for translation.
Clusters – AxiomSL’s Clustering option, like in-memory execution, recognizes financial institutions’ need for stronger, targeted compute power and by deploying nodal clusters, this is achieved with horizontal scalability. Today’s regulatory environment requires firms to regularly run multiple reports simultaneously. This is not only a challenge of execution complexity but also of managing load, and performance will lapse without a strategy to distribute these larger tasks.
Clustering allows systems to offload in-memory executable tasks to auxiliary nodes, relieving this pressure by distributing them horizontally. While this may seem straightforward, the subtlety lies in deciding system dynamics. Partnering with AxiomSL, firms can gather the necessary statistics to parameterize when and how task offloading should take place, and the relationship between the master node and the clusters that best maximizes system efficiency.
In Memory Execution – New reporting requirements imposed upon financial institutions in recent years mean heavier performance needs for certain workflows. Though simple business rules can still be executed efficiently using traditional database engines, in-memory execution is better suited to the complex logic and larger reports produced by running databases queries—sometimes hundreds or even thousands of them—in parallel. Therefore, AxiomSL can now bake this logic in directly on the application server-side.
With task manipulation, enrichment and annotation all occurring in-memory, banks benefit from significant performance gains. Additionally, AxiomSL’s adjustable workflow parameters mean in-memory execution can be utilized as needed, essentially switched on or off when tasks with simpler logic are reverted back to completion via conventional database. The result is an intelligent approach to task execution that meets the complexity of today’s reporting requirements, applying higher-performance technology where it is needed most.
AxiomSL’s comprehensive reporting solution can be quickly deployed to meet new taxonomy requirements around the world.
AxiomSL has extended its fully integrated data management and regulatory reporting platform to support XBRL taxonomy management and submission, and it easily adapts to XBRL taxonomy requirements across multiple countries.
AxiomSL’s out-of-the-box XBRL reporting solution enables financial institutions to leverage their existing infrastructures to quickly become compliant with the new capital (COREP), financial (FINREP) and liquidity (LCR and NSFR) disclosure requirements, by embedding all of the XBRL ‘behind the scenes’. As a result, users focus in on results rather than having to understand XBRL itself. This investment moves AxiomSL from a first-generation report and tagging solution to a second-generation taxonomy management and submission platform.
AxiomSL’s sophisticated XBRL functionality also gives users the ability to access multiple iterations of the same taxonomy. This is particularly important as reporting requirements evolve and market participants are obliged to resubmit reports using earlier XBRL taxonomy versions.
AxiomSL leads in providing the 2nd generation taxonomy submission platform
AxiomSL’s cutting-edge XBRL tagging approach is a powerful solution, as it accelerates regulatory submission processes and increases data integrity while delivering transparency, audit and validation of the results. This seamless XBRL integration provides significant cost savings stemming from greater process efficiencies and automation of manual reporting processes – allowing organizations to access a multitude of business information data from a full range of disparate applications and systems across the supply chain.
AxiomSL’s comprehensive XBRL solution is built on our proven data-management and regulatory reporting platform and includes all the critical features required for controlled reporting:
Submission management and business sign-off;
Seamless XBRL taxonomy importing and versioning;
Data integrity verification and drill down capabilities;
Multi-dimensional visualization of the XBRL submission instance for internal reporting;
Flexible data sourcing strategy included with new XBRL functionality.
AxiomSL’s single platform for XBRL reporting enables firms to seamlessly meet regional and national reporting mandates across multiple jurisdictions
Financial institutions across the world are seeking a single platform for XBRL reporting needs as opposed to disparate systems across each region. The move to common reporting in Europe presents firms with an opportunity to reduce compliance costs by moving to a single platform for all of their reporting and calculation needs.
Firms can now benefit from AxiomSL’s strategic vision, by providing one platform that covers any regional or national disclosures, both XBRL and non-XBRL. Institutions in EMEA and APAC are initially utilizing AxiomSL to meet their COREP, FINREP, LCR and NSFR reporting obligations as part of the Capital Requirements Directive (CRD) IV, but they are also looking to leverage the platform for IFRS, Solvency II or any other XBRL reporting need.
AxiomSL’s XBRL submission modules have been tested by the Financial Conduct Authority (FCA) as part of early submission testing
As the regulatory landscape in the financial sector continues to evolve, momentum has been building towards a single electronic financial reporting standard which would allow for more efficient retrieval and processing of financial information. XBRL, an open and global technology standard used for the electronic communication of financial data, is revolutionizing business reporting. The impact of XBRL on global financial reporting and data exchange has been compared to the impact of bar-coding on merchandising.
Regulators will have far more power and control over data in the coming years as XBRL enhances dramatically the capabilities of regulators to analyse, compare and validate financial data. AxiomSL’s robust and flexible platform supports customisation, extension and the ability to tag at the data source and reuse the validated financial results for other reports.
IntegrationCenter ™ and Dynamic Data Warehouse™
Tactical and Strategic Response to Regulatory and Business Change
ControllerView/Dynamic Data Warehouse combined with client’s existing data management tools enables financial institutions to develop tactical responses to immediate regulatory and business demands, while building a strategic infrastructure that can adapt as the operational environment evolves over the long term.
DDW and IntegrationCenter in conjunction with ControllerView deliver the foundation to ensure data accuracy, data completeness, data lineage and adaptability that enable banks to meet stringent requirements on risk data aggregation and reporting. AxiomSL’s data governance functionality provides the necessary data granularity across multiple business functions.
AxiomSL’s platform creates a collaborative environment among risk, finance, operations and compliance entities to manage the granularity attributes and deliver high standard of data quality.
Preserve your Existing Infrastructure
Interface with all Source Systems
DDW/IC will interface with any internal repository or external service to access transactional, position, cash flow, market, reference or analytical data.
No Data Transformation Required
Front, middle or back office data is accepted in the native format of the source systems, including Excel, text, XML, XBRL or other file types. Data does not have to be transformed before input to DDW/IC.
Preserves IT Investment
Clients can continue to use established data warehouses and extract, load and transform (ETL) tools for collecting and managing source data, thus preserving the value of existing data management assets.
Full ETL Capabilities
DDW/IC is able to provide a full range of ETL, data warehousing and data management capabilities to meet new regulatory or business requirements.
Meet all Regulatory Specifications
Today’s regulatory regimes frequently demand specific data formats, historical and audit information. Where the client’s systems do not already comply, DDW/IC can clean, enrich, extend and model data to conform to regulatory specifications.
Support for Full Data History
Regulation such as the US Sarbanes-Oxley Act demands the retention of certain data for much longer than was traditionally required. DDW/IC can store and manage whatever history of data is required for compliance.
Robust & Comprehensive Features
Flexible and Extendable Data Model to accommodate enterprise and external data sources
High volume, High performance, reliability of information access and storage
Control over Data accumulation methods for transactional, market, reference and analytical data
Support dynamic creation and storage of multiple data marts from aggregation and analytical process
Full enterprise data dictionary by source and data model accessible to applications via API
Large library of data templates for third party front, middle and back office and market data systems
Comprehensive data model for all market data, statistical matrices and financial curves, historical and current
Complete data warehouse API for in-house application and WEB services development
Complete repository for Meta Data and Visual Business Rules
Seamless Integration through Flexible Data Management
Seamless integration in client’s architecture cuts implementation time and project costs
Effective maintenance facilitated by metadata used to describe physical framework of the client’s application instance
Automation of client’s business processes with built-in tools and facilities
Simple data management through grouping internal and external transactional and reference data sources into manageable entities in Data Modeling functionality
Easy process management with scheduled or ad-hoc execution of pre-set data generating sequences via the Work-Flow facility
Flexible & Easy to Use
Visual Data Modelling and Business Rules
AxiomSL’s pioneering Visual Business Rules tool enables users to easily define data hierarchies and workflow processes without the need for programming skills.
Adaptability to New Rules
New functionality can be added to Dynamic Data Warehouse & IntegrationCenter to meet regulatory or business changes without the need for a new software release or full regression testing, saving time and cost.
Preservation of Report Data and Logic
Completion of a multi-level sign-off triggers freezing of reports, preserving not only submitted results, but all data, business rules, formulas and calculations used to produce the final submission. Past reports going back to any point in time can be reconstructed instantly in full detail on demand for regulators or internal audit.
Handles the flow of information specific to the client’s organization.
Scalable, High Performance, Automated Platform
Workflow processes defined with Visual Business Rules or other tools can be executed automatically by a system scheduler.
Reliability, High Volume & Performance
Scalable and resilient architecture can handle all volume and performance demands in a robust environment.
Covers Regulations Globally
Financial firms can meet their local and global requirements on one strategic platform.
Fifth Third Bank Chooses AxiomSL for its Strategic Regulatory Reporting
Empowering Bank Holding Companies to comply with ever-changing regulations while ensuring full transparency, scalability, and reducing cost
Tackling stress testing with AxiomSL’s enterprise-wide integrated platform
AxiomSL has confirmed its platform is capable of handling multiple versions of the European Banking Authority’s (EBA) XBRL taxonomy for…
AxiomSL XBRL Solution White Paper
AxiomSL’s out-of-the-box XBRL reporting solution enables firms to quickly meet any taxonomy requirements worldwide, such as Intl. Financial Reporting Standards (IFRS)…
Waters Rankings 2015: Best Reporting System Provider AxiomSL
Since the collapse of Lehman Brothers back in September 2008, an event that sparked a domino effect of financial crisis, the capital markets…
Data lineage an important issue in 2018
In an ever-changing global regulatory environment, one certainty as we head into 2018 is the growing importance of establishing and maintaining data lineage, AxiomSL founder…