Our Work: SQL Server

Energy Efficient Database

Through its energy-related programs, the Alaska Housing Finance Corporation (AHFC) was collecting detailed energy usage data. With a $300 million grant for a rebate program that gathered detailed energy usage before and after efficiency improvements, AHFC’s data was going to increase exponentially.

Industries:
Oil, Gas, Energy
State Government
Technologies:
ASP.NET
C#
JavaScript
SQL Server
SQL Server Analysis Services (SSAS)
SQL Server Integration Services (SSIS)
T-SQL
VB.NET
XML

Burn Permit Site

For 6 months each year, Idaho requires a fire safety burn permit for any burn outside city limits. But getting a permit required going to a permit issuing center. The Idaho Department of Lands (IDL) wanted to make getting a permit easier. They asked us to create an online, self-service permitting application that also supported their traditional agency-issued permit workflows.

Industries:
State Government
Technologies:
ArcGIS APIs
ArcGIS Server
ASP.NET
C#
HTML5
JavaScript
SQL Server
WCF Services

Food Brokerage Accounting System

As a broker between food suppliers and distributors, our client’s processes and requirements had evolved over time, but their accounting application wasn’t designed to accommodate these changes. For example, the existing system only tracked transactions at the invoice level. However, each invoice could include multiple products, each of which is subject to different contract rules.

Industries:
Other
Technologies:
C#
Silverlight
SQL Server
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
T-SQL
WCF Services

SharePoint Document Management System

Containing 400,000 project documents from the past 10 years, the Hummingbird document management system was considered mission critical by ANTHC’s Division of Environmental Health and Engineering (DEHE).

However, the system required constant support; corrupted documents randomly; and couldn’t meet DEHE’s needs in key areas like searching, automated workflows, and security. DEHE asked us to replace the system with SharePoint.

Industries:
Engineering
Environmental
Health and Social Services
Technologies:
C#
JavaScript
SharePoint
SQL Server

SharePoint Migration

The Oregon Food Bank (OFB) uses SharePoint extensively—from automating business processes, to managing documents and intranet content, to sharing information with partners.

To take advantage of new features and improvements, OFB keeps their SharePoint infrastructure updated. However, because OFB uses SharePoint so heavily, upgrading can be a significant task.

Industries:
Nonprofit
Technologies:
SharePoint
SQL Server
SQL Server Reporting Services (SSRS)