1 / 18

Business and IT Working Together to Streamline Corporate Reporting

Business and IT Working Together to Streamline Corporate Reporting. Stephen Hord, Director of Product Development – UBmatrix. About Me - Steve. Director Of Product Development – UBMatrix 12 + years in the Technology Industry Adobe – Print Publishing and PDF teams

kirby-cotton
Download Presentation

Business and IT Working Together to Streamline Corporate Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business and IT Working Together to Streamline Corporate Reporting Stephen Hord, Director of Product Development – UBmatrix

  2. About Me - Steve • Director Of Product Development – UBMatrix • 12 + years in the Technology Industry • Adobe – Print Publishing and PDF teams • Online Travel Solutions Travelport -> Orbitz • XML and Rules Engines • 2 + years at UBmatrix • Managed UBMatrix FFIEC Solution • Oversee Development of Corporate Solutions

  3. Most Recent eBay Purchase 1967 Moto Guzzi V7

  4. Introduction The Goal of XBRL in Corporate Reporting

  5. The Goal Streamline Corporate Reporting • Meet Regulatory Requirements • SEC, SOX, Others • Provide a Single Interface to all Corporate Information Systems • Eliminate Spreadsheet Problems • Self-Service Data Access • Audit and Traceability

  6. Introduction To EII What is Enterprise Information Integration Enterprise Information Integration (EII) is the integration of data from multiple systems into a unified, consistent and accurate representation geared toward the viewing and manipulation of the data

  7. Introduction To EII EII Benefits to the end user • Reduce time finding and accessing data • Eliminate hack reporting tasks that email spreadsheets or access databases to end users • Maintain connections to source data (Traceability) • Eliminate Spreadsheet copy/paste errors and reduce regularity risk from spreadsheet macros

  8. Introduction to EII Benefits to the IT Administrator Creates a Global Map of all information including Relationships, Validation Rules, Documentation, and Source Enables simplified infrastructure management via a metadata abstraction layer over BI, CRM, DW, ETL, ERP, enterprise portals Control and report on data access patterns, Control access to data based on LDAP. Generate data usage reports

  9. Introduction to EII Benefits to the Developer • Provides a single interface and extensible metadata that can encompass all data sources, speeding the development of applications such as enterprise portals • Developers can simplify the front-end of the application by making it a Web service, and the back-end, by simplifying data access • Development is faster programmers code for access to a single virtual data source regardless of data storage

  10. How Do I Implement XBRL Enabled EII The Analyst and the Information Professional

  11. How Do I Do IT • Enterprise Wide Architecture for Publishing Data • Analyst – Builds a Corporate Wide Taxonomy • Use XBRL Layer to Normalize Data • Data Descriptions Describe where Data is Stored • Use the XBRL Extensibility Model • Remove Duplicates • Create Validation Rules

  12. Internal Reporting Corporate XBRL Taxonomy Message Queuing Accounting System SAP Inventory XML Transactions Web Services Oracle CRM Message Queuing Accounting System SAP Inventory XML Transactions Web Services Oracle CRM Application Silos XBRL Enabled Enterprise Integration External Reporting • XBRL taxonomy layer normalizes and provides easy access to fine-grain data located in disparate data-stores • Data is easily accessed and incorporated into custom business reports

  13. Introduction To EII US GAAP Taxonomy IFRS Taxonomy Corporate XBRL Taxonomy Corporate HQ Europe Division 1 USA Division 1 US Division 1 Ext. Taxonomy 3 EU Division 1 Ext. Taxonomy 1 Europe Division 2 USA Division 2 US Division 2 Ext. Taxonomy 4 EU Division 2 Ext. Taxonomy 2

  14. How Do I Do IT • Enterprise Wide Architecture for Publishing Data • IT Professional – • Corporate Information Messaging System • Metadata driven • Message across silos – XBRL-GL • Publish Taxonomy –Corporate Data Portal • Metadata driven Queries • Track All Requests from one location • Manage Access from one location • Self-Serve Dash boards

  15. Order Desk Sales HR Maximize and Enhance ExistingIT Investments Business Analytics/Reporting Presentation Layer Dashboard Enterprise Portal Universal Business Server Data Validation, Normalization, Audit control XBRL Metadata Layer Data Warehouse BPM Workflow and Processing EAI Process Integration Data Process Layer ETL Data Storage Layer Data Data Data Data Semi Structured Non Structured Batch SAP IBM SAP IBM Real-time

  16. Report Building Tools

  17. Conclusions • Focus on Data Publishing • Create a Composite View of all Data • Metadata driven Queries • Abstract storage details • Maintain Connectivity to Source Data

  18. Contact Steve Hord Director or Product Development UBmatrix steve.hord@ubmatrix.com

More Related