Karpman Consulting 41C New London Turnpike
Glastonbury, CT 06033
New Jersey Clean Energy Program Database
Karpman Consulting designed, implemented, maintains, and administers the database for New Jersey Clean Energy Commercial and Industrial incentive programs (NJCEP). Upwards of 25 case managers from across the country utilize the database each day, adding to the over 12,000 projects and $50 million paid incentives currently catalogued.
From the receipt of a project application to the reporting of results to New Jersey Board of Public Utilities, the database plays an integral part in the administration of the program. Primary features include:
- Simple interface to track fundamental project
information, such as the involved companies, utility accounts,
building location, and comprehensive details of the funded measures.
- Important milestones for each project,
starting from the receipt of application to the post-construction
inspections and incentive payment.
- Import incentives and energy savings for
individual projects into the database from Excel worksheet to
eliminate redundant data entry.
- Quality control is automated through use of a
Project Inspector tool, which insures that all required data is
entered and valid before a project or incentive can be approved.
- Letters to customers for common events, such
as project approval or scheduling an inspection, are generated with
one click from Microsoft Word templates and are pre-populated with
the project information merged from the database.
- Invoices for the program implementation
services are generated through administrative interface, which also
allows users with administrative access privileges to authorize
incentives for individual projects.
data exchange is utilized to interface with an external database
managed by the program coordinator.
- Extensive reporting capability, in both
stylized pdf and CSV format.
As NJCEP has added programs, the database has evolved to meet its requirements. Users can now track and invoice for 12 distinct program types, each with different incentive structures and program requirements. As aid from the American Reinvestment and Recovery Act starts to flow into the energy efficiency sector, new database features allow NJCEP to meet the strict reporting requirements imposed by the federal government. It now has the capability to track the funding source of each incentive and estimate the number of jobs created by stimulus funds. As the NJ Clean Energy program continues to grow, Karpman Consulting expands and customizes the database to adapt to its ever-changing needs.