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.
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.
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.
Worked with the lead estimator of a regional fence supplier to create a simple environment to assist in the automation of bid estimation. This product was the tool that allowed the client to put out more bids in a shorter period of time to spur faster growth.