Tag Archives: SQL Server 2005

Custom Reporting Framework

Did this work during my tenure at The Elite Group.

A custom reporting framework was created for our internal users. The requirement was that they needed access to specific pieces of data on an infrequent basis. Not enough that a full (client facing) report for the front end should be developed, yet more that it couldn’t be handled as an ad-hoc data request.

The framework was written using the MVC3 framework in C#. The meta data was stored in such a way that the site didn’t need to be updated after each report was released. A T-SQL script could be used to push the report, and when the reporting framework loaded, it would detect the new report and present it as an option for the user to run.

EDI Developer

Did this work during my tenure at The Elite Group.

Developed various EDI reports as required. The initial files were generally one-time snapshots of data that would be used to transmit eligibility to various carriers. Since early 2010, most files were ongoing files, that were utilized to free up internal employees to focus on other areas of the application.


Did this work during my tenure at The Elite Group.

Coupled with the DataMart I implemented a framework that would automatically check the source data for data quality issues present. These issues were not causing errors in their respective source systems, but would cause issues on the EDI’s being developed.

The DataQualityControl database had a few initial requirements:

  • Speed – It was in the critical path for loading the DataMart, and it needed to get out of the way as quickly as possible.
  • Flexibility – Additional tests would need to be created over time, and be able to be integrated into DataMart as needed.
  • Reporting – There are two types of data recorded. First was an aggregate for historical purposes, and second was a daily log showing that days issues. Thus trends could be displayed over time to show how the errors were being addressed system wide, and the latest example of such an error could be quickly displayed.

All of these were met in the initial pass, and over time additional quality checks were added as the need arose.


Did this work during my tenure at The Elite Group.

My initial project at Elite was to build a DataMart as a central repository for future reporting needs. No singular framework existed that could meet the needs of the EDI’s that were expected to be built moving forward.

Over a period of a few weeks, the DataMart was designed and implemented along with a DataQualityControl framework.

Each day, the system loads a snapshot of key fields in the source systems. Over time, this data could be used to meet all reporting needs.

Software / Database Developer

This was the original job description provided for my position at The Elite Group.

This position is responsible for software development, database administration, and production support for a custom Human Resource and Payroll system used by Elite Group and its clients.

Essential Duties and Responsibilities:

  • Performs application troubleshooting to isolate and diagnose problems
  • Maintains and enhances proprietary software as required
  • Administer, maintain, and enhance HRIS and Payroll databases as required
  • Coordinates EDI testing and trading partner implementation initiatives
  • Provide implementation support to Benefits Administration and Payroll teams
  • Provides in-house users with portal application and technical support