Client
Testimonial
"The Non-Profit Assistance Corporation (N-PAC) was granted $5
million from the US Department of Labor to implement NSP Works,
a New York City-based welfare-to-work project. The private
web-based system created enables N-PAC to receive data
from the three project sites quickly and confidentially. The
system’s reporting capabilities have been essential to
monitoring the individual progress of the 600 participants as
well as the overall success of the project."
-- Kenya F. Crumel, Senior Program Associate
 Project Summary
NSP Works is an innovative welfare-to-work program funded primarily from a US
Department of Labor competitive welfare-to-work grant award. The effort is managed by
the Non-Profit Assistance Corporation (N-PAC), a subsidiary of
Seedco.org, a national
nonprofit intermediary that revitalizes communities. Day-to-day operations of the
community-based sites are carried out by Citizens Advice Bureau in Mott Haven, the
Bronx, Northern Manhattan Improvement Corporation in Washington Heights/Inwood, and,
St. Nicholas Neighborhood Preservation Corporation in cooperation with the United
Jewish Organization in Williamsburg Brooklyn.
The objective was to provide N-PAC with a system to "connect" the three independent
community-based sites to a common, centralized data-entry, tracking and reporting system.
Such a system allows each independent site to administer, analyze and report on their
client base via secured access. In turn, N-PAC would have a "global view" of the
total client base enrolled in the program. What makes this unique is that each site has
the autonomy to develop non-system based solutions internal to their site – and the data
capture and store is comprised of all the common elements that each site tracks. The
ability to measure the performance of each site’s client base provides the mechanism to
target and share the solutions that work.
TNP was selected to develop a web-based solution to administer and distribute a
finished application from one centralized location.
After the business process analysis, development was done in multiple stages. Back-end
functionality was provided first to support the N-PAC staff in creating the
community-based sites and their respective users and to preload all support tables.
Once N-PAC set up a site with the appropriate levels of security, a Site Administrator
would take over and assign users and rights within their own site.
TNP’s development framework of balanced stages to final rollout allowed for responsive
Q&A and testing on each design. Our designers and programmers were able to quickly
respond to client acceptance testing and provide them with efficient, fast turnaround
on implementation and deployment.
TNP developed the complete web-enabled solution standardized on Internet Explorer 4.0+
browser.
- VBScript for both server-side and client-side processing and validation routines.
- Active Server Pages with VBScript and extensive SQL Server stored procedures
and triggers to handle the core back-end business processing.
- Crystal Web Reports for online reporting and analysis.
- SQL Server 6.5 upgraded to 7.0.
- Scheduled Data Transformation Service exports to MS Access for use with external analysis tools.
|
