Question 1

Alliance Enterprises

Accepted Answer

• Provided architectural and implementation support for Alliance’s efforts to migrate numerous stand-alone virtual machines across multiple subscriptions, resources groups and virtual networks into a centrally managed Active Directory integrated solution within the Azure Government platform.
 • Assisted in the development of both the disaster recovery plan and related procedures for the Alliance Azure Cloud Services Hosting solution.

Question 2

BAER Solutions

Accepted Answer

Developed a mobile application for IOS and Android that tracks gun safety training.

Question 3

Board of Accountancy

Accepted Answer

At Board of Accountancy, our team provided support in migrating their legacy licensing system for certified public accountants into a new Salesforce based solution and provided development support for integrating the Salesforce solution with agency partner systems.

Provided environment and application updates services to a technologically outdated system for CPAOnline, which tracks over 20,000 accounting licensees and accounting firms.

Question 4

Bradken

Accepted Answer

Developed the Tacoma Laboratory Information Management System (Tacoma LIMS) on the programming and equipment software integration project to allow for better quality control and tracking of materials.

Question 5

Department of Children, Youth, and Families (DCYF)

Accepted Answer

We specialize in modernizing and maintaining business-critical systems through streamlined CI/CD pipelines, robust database development, and custom software solutions. Our expertise includes application upgrades, reporting and integration services, and ongoing maintenance to ensure reliable performance. We also provide thorough documentation and knowledge transfer to support collaboration, scalability, and long-term success.

Question 6

Department of Commerce

Accepted Answer

Provided development, training, and technical support on the Individual Trust Account Reporting System (ITARS).

Question 7

Department of Early Learning (DEL)

Accepted Answer

• Developed an authorization interface (AI) component to track time, attendance, and billing system (TABS).
 • Developed an upgrade to the Early Learning Management System (ELMS) to provide an AI component for subsidized Child Care eligibility allowing parents to be aware of services available and find qualified childcare businesses near them.

Question 8

Department of Services for the Blind (DSB)

Accepted Answer

Provided a technical resource to troubleshoot Internet Information Server configuration files to allow the web server to connect to the database.

Question 9

Department of Social and Health Services (DSHS)

Accepted Answer

• Developed the Electronic Jobs Automated System (eJas). eJas is an integrated case management system that supports the Dept of Social and Health Services staff, partner state agencies and contracted service providers in Support Service payments, gas cards, and documenting, monitoring, tracking and reporting the activities of WorkFirst and Basic Food Employment and Training participants.
 • Provided architectural, development, testing and ongoing support on various DSHS enterprise applications, including the Learning Management System (LMS), Agency Records Request Tracking System (ARRTS), WAC Tracking System (WACTrack), Criminal History System (CHS) and Online Background Check System (OBCS) currently.
 • Providing architectural, development, testing and ongoing support for development of data repository (DSHSLMS) used to merge Human Resource Management System (HRMS) data along with Active Directory (AD) data to support various enterprise applications including: Incident Monitor, LMS, Telecom Billing, Leave Tracker and AD compliance reporting.
 • Designed, developed, and implemented the Background Check System (BCS). BCS is a web-based replacement system for the existing Criminal History System which processes over 320,000 background checks for over 80 business areas within DSHS and DEL annually.

Question 10

Department of Transportation (DOT)

Accepted Answer

• Developed Cascades Rail Project Performance Database that tracks delay performance data for railroads in Washington State. The system is used to create reports and an index to gauge the railroads on-time performance.
 • Data and Term Search System – Developed an application used for viewing and managing a library of over 3.5 million business terms, applications, and physical data objects. This system provides search and management capabilities for all Washington State Dept. of Transportation Employees.
 • Materials Lab Data Mart - Led development and technical tasks required implement, maintain, enhance performance, and troubleshoot extract, transform and load (ETL) processes that move data from the Materials Lab transactional databases and flat files to the Data Warehouse.

Question 11

Edge R&D

Accepted Answer

Provided Project Management to facilitate execution of deliverables on the Westfield Live Receipts project to be used by individuals at airports to find services available to them within the timeframe of their flight.

Question 12

Employment Security Department (ESD)

Accepted Answer

• Provided development assistance with the annual process and procedures in the Jobs Financial System (JFS), which is the payment system used for the WorkFirst Program. These processes and procedures are required yearly to close out the prior program year’s finances and opens the ledgers for the next program year.
 • Worked on the Employer Account Management System (EAMS) to develop a secure, webpage-based portal (with an API option) used by employers and their tax preparers for filing, viewing, and amending quarterly hour and wage reports for each employee, and paying unemployment insurance fees and taxes.

Question 13

Health Care Authority (HCA)

Accepted Answer

• Provided development, business analysis, testing and coordination on the Public Employees Benefit Board (PEBB) application.
 • Provided development, business analysis, testing and coordination on the School Employees Benefit Board (SEBB) application.

Question 14

Office of the Secretary of State (OSOS)

Accepted Answer

At OSOS, our team supports the IT Enterprise Team by designing and implementing solutions that meet business needs, documenting and standardizing system architectures, and guiding the development of Azure and on-premise platforms. We also mentor IT staff, establish and maintain secure and efficient Azure DevOps processes, and provide ongoing support to ensure systems and integrations run effectively.

Question 15

Office of Superintendent of Public Instruction (OSPI)

Accepted Answer

• Provided technical project management on the Student Growth Percentile (SPG) system to develop a web-based solution for producing reports that illustrated student growth using data visualization techniques.
 • Developed the School Apportionment Financial Systems (SAFS). SAFS calculates monthly payments of state and federal dollars to each of Washington State’s 295 School Districts, 9 Educational Service Districts (ESDs) and other institutions that provide public education to Washington State’s K-12 student population.
 • Developed the Comprehensive Education Data and Research System (CEDARS). CEDARS collects information on Washington State public school courses, students, and teachers. This data-rich system involves several user interfaces screens, import/export functionality, and a vast set of complex reports.
 • Provided data verification and testing services of the Statewide Longitudinal Data Systems (SLDS).

Question 16

Port of Shelton

Accepted Answer

Created a web-based inventory, staff, tenant and other resource management system to allow the Port of Shelton to run their operations more efficiently.

Question 17

Washington Pilots Association (WPA)

Accepted Answer

Provided an online registration and tracking tool to help support the distribution of a regular pilot newsletter and distribute grants/scholarships to young aspiring pilots.

Question 18

Washington School Information Processing Cooperative (WSIPC)

Accepted Answer

• Collected requirements, designed, and developed a dropout prevention system, integrating with existing WSIPC data systems to provide a predictive model to provide timely interventions to potential high school dropouts.
 • Provided technical assistance and project guidance for the WSIPC data warehouse system.  Assisted in data model design, developed ETL processes, created reporting solutions and custom SharePoint code as needed.  Participated in regular meetings with the company director to report progress and prioritize future needs.

Question 19

Washington State Patrol (WSP)

Accepted Answer

At Washington State Patrol, our team collaborates directly with the IT Department and various Business Units. Our team's mission is to standardize, streamline, enhance, and simplify technology solutions in order to reduce maintenance complexity and increase system agility. Through the adoption of various DevOps Methodology principles, our team has automated the testing, integration, and delivery of small-to-large on-premise and hybrid solutions.

Question 20

Washington State Transit Insurance Pool (WSTIP)

Accepted Answer

Provided the technical implementation of the Driver Record Verification System (ADR) which involves the retrieval of driving records from the Department of Licensing in an automated system to monitor drivers flagged with new infractions to maintain the quality of drivers insured by WSTIP.

Projects

Kiehl Northwest Project Summaries