Knowledge
Knowledge is power, and we specialize in turning data into knowledge.
Experience
Our experience with over 25 different insurance systems enable us to deliver solutions and services with exponential value.
The Company’s founder, John McConnell, has been working in the insurance industry since 1992. He is an inactive Certified Public Accountant and has held Chief Financial Officer and Controller positions with several insurance carrier groups, which is the foundation for his deep understanding of the insurance industry.
In 2001, John McConnell leveraged his formal education and passion in technology to create a consulting company with a distinct approach in serving the insurance industry. This distinct approach is adhering to a core tenet that one must understand the problem to be able to effectively solve the problem. Supporting this core tenet, his staff have formal education and experience in business and/or actuarial sciences accompanied with impressive skills in technology.
Our Company holds the belief our superior knowledge in the insurance industry delivers innovative products and solutions because we quickly comprehend the problem at hand. Our understanding of sophisticated concepts, such as loss development triangles and earned premium/exposure units, permits us to flatten the learning curve immediately. As a result of this knowledge, we deliver tremendous value since we deliver the right solution without expending time and resources in overcoming a learning curve.
Innovation is achieved through the successful fusion of experience, knowledge, and technology
Information is the foundation for knowledge, and knowledge is the foundation for sound decisions.
Ingenuity is achieved through the collaboration of people with sectionerse abilities, skills, and experience
Insight is a product of a deep and powerful understanding of the industry and business.
We deliver a thorough analysis of a company's insurance system and data architecture that will enable the company to improve the value generated from their existing system. We provide data modeling services to facilitate managing data as a resource, integrating information systems, performing system conversions and designing system databases. We create scalable and flexible data warehouses to support improved decision making.
We implement OLAP tools that best meet our client's needs and create customized analyses for individual users to facilitate business intelligence. We provide customized managed reporting solutions that automate report generation and distribution. We provide business intelligence services utilizing multiple tools and processes to improve business decision support.
With experience spanning 25 different insurance systems, we utilize our insurance knowledge and experience to bridge the gap between insurance and accounting systems and the resultant data.
First and foremost, our company specializes in the insurance industry. We pride ourselves in understanding complex insurance concepts, and our core staff has business and/or actuarial science degrees accompanied with impressive technology skills.
Our company has provided consulting services involving over 25 different policy and claims systems across the spectrum of small to multi-billion dollar insurance carriers. This convergence of skills, experience and knowledge enables us to deliver services to insurance companies with greater understanding and exponential value in delivering the right solution. The following are some of the services we provide; select a link to the left to learn more about our services.
The majority of insurance companies do not have the internal technology resources to achieve an in-depth understanding of their system data. Consequently, we are frequently engaged to reverse-engineer system databases with limited or no technical documentation or assistance. Because of our extensive system experience and industry understanding, we are able to proficiently analyze, comprehend and document the raw system data with limited guidance. Depending on the objectives of the engagement, the product of this analysis may be in the form of a data dictionary with documented data and business rules and/or a foundation for supporting a data warehouse, managed reporting or business intelligence solution.
The purpose of data modeling is to create a blueprint of data requirements necessary to support the business processes of an insurance entity. A data model is essential for effectively and efficiently managing data as a resource, integrating information systems, performing system conversions and designing system databases. More importantly, the data model must be optimally structured to fulfill its intended objectives while supporting accuracy, flexibility, granularity and performance. Because we thoroughly understand the various Perspectives affecting how information should be aggregated and presented, we can prevent common mistakes upfront and swiftly deliver an appropriate and optimal data model(s).
Data warehousing includes collecting, cleansing, organizing and storing data with a core objective of enabling better decision-making. Data warehousing helps turn raw data into useful information and is ideal for those who need to merge and integrate data across different department or system boundaries. Our combined multi-disciplinary knowledge and extensive insurance experience provide tremendous value, since we require much less time developing the business requirements and performing the data analysis & modeling. Using innovative technology, we can extract and transform our client's data and create a data warehouse environment that is scalable and can easily accommodate growth and future modifications. We address strategic and operational needs by designing and implementing a comprehensive data model which provides the flexible structure to support data mining, reporting, querying, trending, visualization and business intelligence.
Data conversion is the process of moving data from one system to another. Complications arise quickly as data cleaning, translation, transformation, normalization and referential integrity rules are applied to make the data from one system structure fit into another. We can help avoid a number of potential traps by applying our experience in planning and mapping data conversions in addition to developing efficient programming and algorithms.
Quality assurance processes should be integral to any data service. Steps must be undertaken at critical stages to ensure the data product is conforming to expected results. We can assist in developing the most efficient and pervasive testing processes. We design and implement comparison and validation scripts to automate a significant portion of recurring quality assurance that enables our clients to have continual confidence in the critical data relied upon.
Online Analytical Processing ("OLAP") provides a means for reviewing vast data sets through multidimensional aggregations and delivers answers to analytical queries. OLAP is part of the broader category of business intelligence. While conventional reports have narrow target content that often reflects detail transactions, OLAP "cubes" provide the ability to view various combinations of dimensions (e.g., product, zip code, construction, etc.) and measures (e.g., net premium earned, loss ratio, etc.) on the fly. OLAP cubes are capable of providing millions of combinations depending on the number of dimensions and measures built into the cube. Our deep industry knowledge enables us to quickly assess a company's data architecture and implement OLAP tools so that the organization can transform their information into meaningful decisions. We design your OLAP data to best meet the needs of your company and create customized analysis for the individual users of critical data, based on their need and perspective.
Managed reporting is a secure, centralized method of report creation and distribution. Our managed reporting solution automates the processes involved with generating and distributing reports to the people who need them and provides fast and easy access to customized reports. We create scheduled reporting tasks and queues that offload processing time to non-peak hours and implement report distribution plans that deliver customized reports with user-specific content. Additionally, new reporting technology pushes report creation and design functions to the business analyst and user, so technology professionals can focus on more technical matters.
Business Intelligence ("BI") refers to the technologies, applications and practices for the collection, integration, analysis, and presentation of business information in order to support better business decision making and find "intelligence" or insight into the factors driving a business. BI can also be described as a decision support system. The tools and processes utilized in BI may include any combination of Data Warehousing, Data Mining, OLAP, Reporting, Visualizations, Dashboards, Performance Metrics, etc. We offer services whereby we customize and employ any or all of these BI tools utilizing BI software best suited for your company to provide a coordinated view of your business and facilitate expert decision making. For more information regarding our customized business intelligence solution for property and casualty companies see the P&C Business Intelligence Solution section of the solutions page.
Also known as Key Performance Indicators, metrics provide dynamic actionable information to the decision-makers in your organization. Regardless of the technology and processes used to generate the measures, performance metrics have to be aligned with corporate goals, so they provide a clear indication of how the organization is performing in relation to its objectives. They must be meaningful, timely, and supported by detail so when the numbers change unexpectedly, the causes can be readily identified. We offer services whereby we work with your existing data source and set up automated processes that will generate key performance indicators in real-time as part of an overall business intelligence solution, or independently.
We frequently find insurance systems do not provide information consistent with the understanding and expectations required by the business. Whether changes in the company, industry and/or system have conspired to create this divergence, today's corporate environment demands accurate information. This reality is even more significant, considering insurance systems supply most of the financial elements for an insurance company's income statement. We offer comprehensive system audits to ensure insurance systems are processing and reporting as expected.
Our thorough understanding and practical experience in the insurance business provides opportunities where we can play multiple roles within a project, so resources are more efficiently utilized and potential miscommunication in the translation of business requirements into technical specifications can be reduced dramatically. Combined with our multi-discipline expertise, technology projects can be expedited and accuracy and end user satisfaction can be ensured while resources are more efficiently allocated.