| Project: LiveSmart BC Rebate Processing System
Client: British Columbia Ministry of Energy, Mines, and Petroleum Resources
Role: Lead Developer
Product Type: ASP .NET Web Application
Framework: .NET Framework 3.0
IDE: Visual Studio 2008
Programming Languages: C#, JavaScript
Database Backend: MS SQL Server 2005
Other Technologies: NHibernate (Object Relational Mapping tool); NUnit (Unit Testing Framework); Magic AJAX (Asynchronous loading of page components for enhanced performance and better user experience)
Description: Web-based application responsible for entire workflow associated with the calculation and disbursement of rebate checks due to home owners for making their homes more energy efficient as per LiveSmart program requirements.
Key Features Implemented:
- Ability to import raw transactions from XML files containing before and after inspection data needed to calculate rebate totals on a manual (i.e. single file) or automated/scheduled (i.e. multi-file, batch) basis; Import routine supported comprehensive error logging and transactions containing rebates with invalid data could still import rebates with correct data while flagging ones with invalid/corrupt data specifying the reasons for the failures (i.e. an entire transaction would not fail to import if only some rebates contained invalid data or prevent other transactions in a file from being imported).
- Routines needed to compute all supported program rebates for each transaction based on a home's physical location, achieved improvement levels, and other complex and changing LiveSmart program requirements; Included the ability to pro-rate rebates where appropriate.
- Ability for authorized users to manually adjust/reduce rebates; System audited such adjustments and required users to specify the reason(s) behind why these adjustments were made.
- Workflow process responsible for progression of transactions from inception to conclusion; Included ability to audit transactions manually or automatically audit transactions when certain conditions were met as well as demote transactions to an earlier stage in life cycle; Comprehensive lifecycle auditing included for each transaction.
- Ability to reconcile rebate totals for each transaction with Ministry CAS (Corporate Accounting System) before checks were disbursed to home owners on an an automated/scheduled basis to identify and resolve discrepancies.
- Ability to automatically generate customized letters to be sent to home owners that would accompany disbursed rebate checks; Letters would show the itemized rebate totals a home owner was eligible for, list contributions made by partners like Terasen and BC Hydro towards a home owner's total rebate (if applicable), and conditionally show/hide text based on whether certain business rules were satisfied.
- User security and role management system governing which users could access the system and what activities they were able to perform based on Ministry requirements; Included roles governing who could import transactions, promote/demote transactions from one state to another, select transactions for auditing, mark transactions as complete once they've were reconciled with CAS warehouse or manually reconcile them when discrepancies arose, etc.
- Performance enhanced searching/filtering and on-demand reporting as required by LiveSmart program.
|
|
