A dental practice management firm needed to identify ways to improve performance and to increase the scalability of its existing systems. Recommendations for database object and system architecture changes were made after a review of the company’s OLTP system.

Tools & Technologies: Microsoft SQL Server 2005

An energy efficiency and management firm needed data extracted from text files, transformed, and loaded into an OLTP database. Data exports to text files were needed as well. SSIS packages were created to perform the ETL processes. BIT also conducted a workshop to define the requirements and scope of a new business process and system being considered as part of business strategy.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Integration Services

A manufacturer of corrugated high density polyethylene pipe needed an SQL Server 2005 data mart and cube to replace an existing SQL Server 2000 solution. SSIS packages were created to automate testing by comparing data from the old cube, the new data mart, and the new cube. MDX statements were generated for use by reports. Assistance was provided in designing the new cube.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Integration Services, SQL Server 2005 Analysis Services, Microsoft SQL Server 2000 Analysis Services

A pharmaceutical company needed data from a JD Edwards ERP system loaded into a new data warehouse. SSIS was used to extract, transform, and to load the data as part of an automated ETL process. The tables loaded were partitioned. Automated cube partitioning was added.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Integration Services, SQL Server 2005 Analysis Services

A provider of investment solutions and services needed to extract, transform, and load data from heterogeneous financial systems into a data warehouse. A Sarbanes-Oxley-compliant ETL framework for administering, logging, and auditing ETL processes was created. SSIS ETL packages and processes were used to populate an Eagle Investment Systems PACE data warehouse with securities, holdings, and transactions data from SS&C CAMRA, SS&C Debt & Derivatives, and McCracken Financial Systems Strategy CS systems.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Integration Services, SQL Server 2005 Reporting Services

A marketer and distributor of commercial printing and business imaging papers, packaging systems, facility supplies, and equipment needed a design for an enterprise reporting architecture that provided highly granular data access authorization control to heterogeneous data sources while minimizing the touch-points and complexity of authorization management.  An enterprise reporting architecture was designed and documented. A proof-of-concept prototype was developed.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services, Microsoft Office SharePoint Services 2007, Active Directory, Kerberos authentication

A firm that manages assets and provides administrative services for qualified and non-qualified retirement plans needed a data warehouse to support historical balance and transaction reporting for plan members. An ETL process to populate the data warehouse was developed. The data warehouse tables were partitioned and an automated data purging process was created.

Tools & Technologies: Microsoft SQL Server 2005, SQL Server 2005 Integration Services