Dan Hofer, a Principal Business Intelligence Consultant at Abellatech, has been chosen by a Midwestern Manufacturer and Distributor in Toledo, OH for ETL, data warehouse, AND Cognos development. Additionally, Dan will install and configure Cognos 10.1. Dan will provide the following: develop a star schema data model based on Kimall methods. use Microsoft SQL Server Integration Services to write the ETL to populate the data warehouse. use Cognos Framework Manager to model the metadata for the data warehouse. use Cognos tools to develop information delivery for the data warehouse. use Cognos administration tools to properly deploy and secure the environment.  

Dan Hofer, a Principal Business Intelligence Consultant at Abellatech, has been chosen by Sloan-Kettering Cancer Center in New York City for a variety of Cognos platform enhancements. The engagement is composed of migrating their current Cognos environments from version 8.4 to 10. This effort includes the design, installation and configuration of all the server based Cognos infrastructure. Cognos Life Cycle Manager will be utilized to validate the approximately 2,500 reports that will be upgraded. Dan will also repair any anomolies that may present themselves in the metadata models as well as reports. In addition to the upgrade, Dan will further consult on the implementation of row level security mechanism linked to the authenticated user.    

AbellaTech's client, a large telecommunications company, engaged us to provide a strategic role in a key project. Our client is leveraging our strength in Microsoft SQL Server database development and .Net development technologies. Our client has their choice of a multitude of local and national firms to work with. That being said, they chose AbellaTech.

AbellaTech 's client is implementing Business Objects Data Integrator as their tool of choice for ETL purposes. With our client being new to data warehousing, AbellaTech was brought in to review their approach to the use of the tool and data warehousing in general

A long time client of AbellaTech leveraged our ability to source and provide augmented IT staff for a JAVA based development effort. This is the 3rd time in recent years AbellaTech has been called upon in this role by our client. We provided a skilled JAVA resource for a short engagement.

Dan Hofer, a Principal Business Intelligence Consultant with AbellaTech, was chosen to provide a complete life cycle data warehouse and information delivery development effort. Our client has been growing through acquisition and needed to consolidate sales data across a variety of ERP systems that had been implemented over the years (4 total). Dan designed and executed the project from end to end. Oracle, SQL Server, Access, and flat file data sources were transformed through Informatica and populated an Oracle based data warehouse. The data warehouse was designed using Kimball methods and modeled in Microsoft Visio. The data warehouse was modeled with Cognos Framework Manager and reports were created using Cognos 8.4. This project was completed on time and on budget. We love successful projects - it's what keeps our customers coming back!

AbellaTech's client, a major insurance company, turned to us when additional capacity was needed on their data warehousing team. This client has been with Abellatech since 2006. We've done numerous projects related to the data warehousing and business intelligence areas since that time. Currently, we have 2 full time resources on their site providing ETL and data warehousing development services.

AbellaTech's client,  a large restaraunt chain, engaged us to upgrade their Microsoft SQL Server database and reporting environments. We completed the upgrade as required and made enhancements that significantly improved the throughput of critical reporting components. Another successful project.

Our client, a leader in the delivery of patient accounting systems for nursing homes, turned to AbellaTech for assistance with their needs for information delivery. AbellaTech consulted on best practices and approaches to the strategic use of Microsoft SQL Server database development and Microsoft Sharepoint development. Given our client's close proximity to Columbus, OH, AbellaTech is pleased to have been chosen over all the options available.

AbellaTech's client, a Bermuda based insurance company servicing the oil production industry, engaged us to develop claim loss prediction programs. Working with the company's chief actuary, AbellaTech developed a model to run millions of simulations of events based on the North Atlantic Named Weather System to predict claim losses. This is the second engagement with this client in 12 months. The project completed smoothly - we look forward to future projects (who wouldn't when the client is located in Bermuda!).