We perform systems analysis for every project. Using MS Visio, the project is documented at various levels appropriate for the scope of the project. Our high-level diagrams and written documentation tend to be non-technical and user-friendly. We believe that without proper analysis it is not possible to create an accurate design.

Regardless of the scope of the project, we create a logical and physical data model. The logical model thoroughly documents the business definitions. The physical data model encapsulates 100% of the physical database specifications.

We specialize in the MS SQL Server database platform. We have experience in delivering both transactional and dimensional (data mart) architectures. We employ advanced TSQL programming to create robust, flexible, reusable data processing resources. The master data model is synchronized with the physical database; changes in the data model are reflected in the database; changes in the database are reflected in the data model.

Using MS SQL Server Integration Services (SSIS), we are able to fully automate very complex data processing tasks. Disparate data sources can be harnessed into a master database. We are experienced in data migrations, integrations, traditional ETL (data mart), and exports. The SSIS systems we create are flexible, extensible and meticulously documented.

We have a long history of successful MS Access databases spanning a wide range of business applications and scope. This includes MS Access Data Project development where Access provides a native connection to a MS SQL Server database. This approach leverages the RAD, user-friendly features of MS Access and the power of MS SQL Server.