Solution to interact with operational platform which reduced data load runtime by over 92%, allowing for faster completion of synchronous tasks. This effort also consolidated error handling to a single service with the capability to create support tickets on behalf of the calling process.
JobSeeker Web Application
Presented and retained information from three remote sources to provide information workers with KPIs on jobseeker statuses and program(s) eligibility.
Support Requests Database Application
Web Application used to streamline the workflow of jobseeker support requests and financial transactions as they relate to grants approvals were allocated against.
Data platform which reduced development time, established interface design pattern, and facilitated statistical analysis of enterprise objects.
Provided lecture-based and individual instruction on SQL, SSIS, SSRS, and SSAS technologies. Educated staff on industry best-practice and data-driven design patterns through lecture-based and individual instruction.
Audit Report Redesign
Addressed auditing needs of client-facing reports for an online Human Resources application utilizing SQL Change Data Capture (CDC) and table partitioning.
EDI Solution using SQL Change Data Capture (CDC) technology to notify West Coast technology partner of changes to select information on the East Coast system within 4 seconds.