Our Customers

Empowering teams to accomplish great things

CUSTOM SOFTWARE SOLUTIONS

“Individual commitment to a group effort–that is what makes a team work, a company work, a society work, a civilization work.”

― Vince Lombardi

New Energy Technology

Strategic Energy Management (SEM) Platform

Artesia Systems has partnered with New Energy Technology (NET) to architect the next generation of NET’s Strategic Energy Management software platform. These advanced back office tools will support their high-value SEM professional service consulting to provide strategic, actionable information to their clients.

Technologies include .NET Framework, WinForms, ClickOnce, Artesia Systems Custom Framework, SQL Server, Visual Studio, Azure hosting, DevOps, C#, T-SQL

Department of Commerce

Clean Buildings Portal

The Clean Buildings Portal is a custom web application designed to assist building owners in complying with the Clean Buildings law (HB 1357). Building owners that are required to comply with the law can use the portal to verify building information and can use a Secure Access Washington (SAW) account to view and verify parcel/building information, manage roles and authorize users to work on their profile, submit applications and compliance forms, track compliance requirements, and check on the status of applications.

The portal is also designed to assist internal Clean Buildings staff in tracking the status of applications/buildings through customized workflows. These workflows guide the users through the review of applications from building owners and help them in maintaining compliance with the Clean Buildings law.

Technologies include Angular, Bootstrap, SQL Server, T-SQL, C#, Visual Studio, Secure Access Washington (SAW)

Commerce Enterprise Data Warehouse

The vision for the data warehouse was to architect an enterprise solution for extracting, transforming, loading, and visualizing critical program data agency wide. The new architecture established a standard pattern for making disparate program data continually available to the Commerce enterprise, key stakeholders, and the Washington State public. This previously required a series of labor-intensive processes involving a wide range of differing systems and technology. Now key data, aggregated metrics and geospatial data are readily available in the central warehouse from key enterprise systems including CMS (Contract Management System), HCMS (House Contract Management System), LIHEAP (Low Income Home Energy Assistance Program). This also established an efficient pattern for onboarding new enterprise systems into the data warehouse ecosystem. Data is made available in a variety of formats including visualization/analytical tools, GIS mapping, tabular extracts, and aggregated reports.

Technologies include SQL Server, T-SQL, SSIS, SSRS, VS.NET, .Net Core 5+ Angular, ESRI, Tableau

Contract Management System (CMS)

CMS is a custom native Windows application that serves as the enterprise Grants, Contracts and Loans Management system the Department of Commerce. It supports tracking contract details and life cycles for over 100 diverse Commerce programs. The application includes a full featured Loan Tracking module that supports full customization of loans for various programs and includes simple/complex interest, annual, quarterly, monthly payment schedules and standard as well as draw-based amortization. CMS also includes an online Secure Access Washington (SAW) portal for external vendors to access to submit invoices online, review contract details and print amortization schedules.

Technologies include SQL Server, T-SQL, Visual Studio, C#, WinForms, ClickOnce, ASP.NET, AJAX, JQuery, Web Services, Secure Access Washington, SSIS, SSRS

Foreclosure Fairness Project Database (FFPD)

FFPD is a custom web application that replaced an existing application to assist homeowners and lenders explore alternative options to foreclosure through mediation. It utilizes Secure Access Washington (SAW) and role-based security to allow Referrers and Mediators to safely access information, submit the proper forms, and track the progress of applications.

Technologies include Angular, Bootstrap, SQL Server, T-SQL, C#, Visual Studio, Secure Access Washington (SAW)

Landlord Mitigation Database (LMD)

LMD is a custom web application created to track application requirements and status of applications submitted through the Landlord Damage Relief Program. It has an external facing portal where landlords needing to file a claim for financial relief or reimbursement can do so using a Secure Access Washington login and a valid Statewide Vender ID Number (SWV Number). Landlords can file claims, upload required information, track the status of their application, and check the validity of their SWV Number.

Internal staff use LMD to track the status of submitted applications using customized workflows. The workflows guide application review, approval, denial, requests for additional information, A-19 batching, payment approval, and notifications to the landlord and tenant of the status of their application.

Technologies Angular, Bootstrap, SQL Server, T-SQL, C#, Visual Studio, Secure Access Washington (SAW)

Lead Based Paint (LBP), Renovation, Repair and Painting (RRP)

LBP/RRP is a custom web application that replaced an existing internal application with an external facing self-serve portal for applicants for LBP/RRP certification as well as Training Providers seeking training accreditation. The web user experience was data driven and customized based on user roles. The new system includes a SAW enabled external web portal.

Technologies include Visual Studio, C#, ASP.NET MVC, WebAPI, AngularJS, SQL Server, WinForms, ClickOnce, SmartClient, SQL Reporting Services.

Regulatory Roadmap

The Regulatory Roadmap is a custom web application provides city and county jurisdictions a way to provide zoning and restriction information for potential manufacturing companies looking to locate facilities in the State of Washington.

Technologies include ASP.NET, Angular, BootStrap, WebAPI, Artesia Systems Custom Framework, SQL Server, Google Maps Platform, Visual Studio, DevOps, HTML, CSS, TypeScript, C#, T-SQL

Weatherization Information Data System (WIDS)

WIDS is custom native Windows application used statewide to allow local agencies to track and report weatherization projects to federal and state entities. WIDS provides critical information for full reporting and compliance with ARRA federal reporting requirements. This design was coordinated with a number of the 30+ community action council/programs that were required to report. This led to a data driven approach for capturing the key measures that must be reported. This also led to a data driven design to calculate the potential cost savings of those measures.

Technologies include Visual Studio, C#, ASP.NET, WinForms, ClickOnce, Secure Access Washington, Web Services Gateway, SQL Reporting Services.

Department of Corrections

Legal Financial Obligations (LFO)

LFO is a custom native Windows application used to import withdrawals from offenders accounts, calculate payments for legal financial obligations to counties, and export information for payments through AFRS the State of Washington accounting system.

Technologies include .NET Framework, WinForms, ClickOnce, Artesia Systems Custom Framework, SQL Server, Visual Studio, DevOps, C#, T-SQL

Contract Management System (CMS)

CMS is a custom native Windows application used to track agency wide contract requests, approval routing and contract details. CMS includes dynamically generated approval routing chains, automated reminders and workflow routing. CMS was acquired and customized through a joint inter-agency effort between Department of Corrections, Department of Commerce with professional implementation services by Artesia. This project serves as a prime example of how custom software solutions can be leveraged to save costs of development and meet the unique requirements of another customer.

Technologies include .NET Framework, WinForms, ClickOnce, Custom Framework, SQL Server, Visual Studio, DevOps, C#, T-SQL

Recreation and Conservation Office

Project Information System (PRISM)

PRISM is both a custom native Windows application and a custom web application. Internal staff uses the native Windows application to manage system data, security, project agreements and amendments. Public project sponsors use the web application to apply for state and federal grant funds for recreation or salmon recovery projects. Projects rankings are based on the scoring results of an evaluation panel of subject matter experts. Once projects are funded, project sponsors can use PRISM to submit billings online for reimbursement. Interactive maps are integrated into the web application to provide and collect geographical information relevant to the project work site and property locations.

Technologies include ASP.NET, .NET Framework, MVC, SPA, WebForms, WinForms, ClickOnce, Custom Framework, Entity Framework, SQL Server, ArcGIS, Visual Studio, DevOps, HTML, CSS, JavaScript, Knockout, C#, T-SQL, AGILE, ContractGenerator

Salmon Recovery Portal (SRP)

SRP is a custom web application used by Lead Entity staff to prioritize and manage projects that facilitate salmon recovery in the State of Washington. The application has been integrated into the PRISM database to consolidate redundant data to improve accuracy and reliability of project information. Lead Entity staff can relate projects to an “umbrella” project to view high-level progress of goals and funding and timelines. Project worksites, properties, and activity locations are visually represented and maintained using maps integrated into the application. Staff can analyze project data using customized reports and exports.

Department of Children, Youth, and Families

Federal Reporting and Tracking System (FRATS)

FRATS is a custom native Windows ClickOnce application used to track Federal Grants balances, Quarterly Grant Withdrawals, Cost Allocation, and Annual and Quarterly Federal Reporting.

Technologies include .NET Framework, WinForms, ClickOnce, Custom Framework, SQL Server, Visual Studio, DevOps, C#, T-SQL

Contract and Procurement System (CAPS)

CAPS is a custom web application used to create and track contract agreement and amendment details, approval routing history, detailed contractor and contact information, invoice history, payment history, current contract balance, deliverable tracking, and organization audit information. CAPS exports invoice payment data that is imported into AFRS, the Washington State accounting system where it is processed for payment.

Technologies include ASP.NET, WebForms, SQL Server, Visual Studio, DevOps, Octopus Deploy, HTML, CSS, JavaScript, C#, T-SQL, Aspose.Words, Aspose.PDF, ContractGenerator

Financial Management Reporting (FMR)

FMR is a custom web application used to import agency allotments, expenditures, contract balances, and adjustments from multiple sources and combine this information to calculate a more accurate balance and projection for programs by fiscal year and biennium for management.

Technologies include ASP.NET, WebForms, SQL Server, Visual Studio, DevOps, Octopus Deploy, HTML, CSS, JavaScript, C#, T-SQL

Department of Natural Resources

Reforestation Information Management System (RIMS)

RIMS is a custom native Windows application used by the Webster Forest Nursery to track seed inventory, calculate seed withdrawals needed to grow trees requested by DNR Regions and contractors as well as trees grown for public sale. Trees are inventoried throughout the 1 to 3 year growth cycle to prepare for any request surplus or shortage. DNR Region, contract, and public orders, invoices, and payments and progress payments, and shipments are also managed by RIMS using a variety of customized reports.

Technologies include ASP.NET, .NET Framework, WebForms, WinForms, ClickOnce, Custom Framework, Oracle, Visual Studio, SVN, HTML, CSS, JavaScript, C#, PSQL

Forest Fire Protection Assessment (FFPA)

FFPA is a custom web application used to manage fees to be paid by private forest landowners and exempt entities (counties, cities, non-profits, and state landowners) to help pay for the cost of preparing to fight wildfires as opposed to actually fighting the fire (the costs that are referred to as “suppression costs”). Learn more…

Technologies include Angular, Angular Material UI, Rest Web API, Entity Framework, Oracle, ArcGIS, Visual Studio Code, SVN, HTML, CSS, JavaScript, C#, PSQL, Secure Access Washington (SAW) or Windows authentication

Employment Security Department

Next Generation Tax System (NGTS)

NGTS is an ASP.NET web application serving the Washington State employers to track unemployment insurance data and the associated billings for taxes due. Artesia was retained for the subsequent stabilization and re-architecture phases of the project. Areas of focus include the Tax Accounting, Tax and Wage Reporting and Billing business domain areas. Primary roles include Tax Accounting and Billing Team Lead. Major successes include data quality improvement goals, performance tuning and data quality diagnostic collector process implementation. Other roles were SQL Server Database architecture, implementation and tuning consulting.

Technologies include Visual Studio 2017, C#, ASP.NET, Windows Services, TFS, Git, SSIS, SSRS, MSMQ, BizTalk, RedGate SQL Toolbelt, Ecrion.

Workforce Training Board

Student Data Portal

The Student Data Portal is a custom web application used to collect statistical and confidential information about students and programs provided by selected education providers. The information collected us used to determine trends in education in relation to skills needed by the State of Washington workforce.

Technologies include ASP.NET, WebForms, Custom Framework, SQL Server, Visual Studio, DevOps, HTML, CSS, JavaScript, C#, T-SQL

Our Services

Custom Software Solutions

How can we help?