Solution Buildout / Platform Consolidation

Job ID: 33782822

Budget: $3,000 – $5,000 USD

BACKGROUND
Veterans2Work is a 503(c) nonprofit with the mission of helping less advantaged veterans launch careers in the growth economy, without the need for a four-year college degree, through fast-track training-to-jobs programs and aptitude based job matching.

Our VetMatch™ aptitude-based job matching tool combines personality assessment with
predictive analytics to 1) help returning veterans identify best fit careers and qualify for jobs that match their interests and personalities; and 2) help employers identify and hire veterans most likely to succeed in a particular job based on aptitude. The VetMatch tool is expected to transform veteran hiring, dramatically expanding both job opportunities for veterans and the pool of qualified talent for employers.

Our prototype has been successfully tested in limited user and market environments. The goal of this project is to prepare the product / platform for full market rollout in three thrusts:
1) completing minimally viable product with features to support full scale distribution;
2) consolidating data and functionality on a common, streamlined platform; and
3) connecting to two third party applications via existing APIs.

Salesforce has been our primary CRM platform since 2009. Our proprietary VetMatch product runs on a separate (node.js) platform. To consolidate, we plan to house needed CRM functionality from Salesforce to the node.js environment

PROJECT OBJECTIVE
Enable creation of 100,000 VetMatch Success Profiles by EOY 2024.

PROJECT DELIVERABLES include:
● Updated data model (view current model)
● +- 30 new data fields to current [node.js] application
● Single user site for creating, updating account information, accessing ONET functionality, adding ONET output (7 numerical values) to account record (through their REST APIs) and activating Coursera account / viewing course progress (via Coursera APIs)
● Administration portal / dashboard to include 5-6 reports, lookups, filters and email
communications to individuals and groups.
● ONET and Coursera connectivity (via APIs) to enable above functionality

CURRENT ENVIRONMENT
● Salesforce is the current CRM platform (to be phased out)
● VetMatch application runs on node.js using Postgres on Heroku. Current technologies:
HTML, javascript, CSS, EJS, PLpgSQL
● Google Forms captures new users, from which a Salesforce record is created. This will be phased out.
● There are two data sources for a “Success Profile.” 1) VetMatch, our native
personality assessment, and Interest Profiler, a U.S. Dep’t. of Labor (ONET) application
that assesses personal interests and maps them to best-fit careers. Interest Profiler
output is to be combined with VetMatch results to create a comprehensive “Success
Profile.” Currently, there is no connection between the user account / Vetmatch data and
O*NET results.
● Coursera is our learning platform. Course enrollments and progress are associated
manually to user records.

→ Schematic view of current environment: https://docs.google.com/drawings/d/1LAdv7q4HOAs40OH6-hXL6nlEQMb_xXQaJpu-MOyPufg/view

FUTURE ENVIRONMENT
● Salesforce and Google Sheets will be phased out; all data and functionality will reside on a single platform.
● Basic CRM functionality will be built into the new [node.js] platform; data will be migrated from Salesforce.
● ONET application will be seamlessly accessible from user account (via ONET REST APIs); with ONET data to be imported into user record (6 values).
● User friendly access to account information, including ONET functionality,
● Administration data access.
● Coursera account activation and progress update using Coursera APIs, with UID as link to node.js
account record