• A large non-profit healthcare, housing and employment agency

    A large non-profit healthcare, housing and employment agency


    Our client provides life-sustaining services to a large population of high-needs individuals and families. Their organization delivers diverse services requiring a cadre of operational systems. For healthcare services there was an urgent need to improve analytics in order to positively affect patient treatment outcomes. A data warehouse was a core component of the solution.

    CSG Pro partnered with the client internal staff to design and build out the data warehouse. Using Microsoft SQL Server, SSAS and Power BI, the first stage of the data warehouse development is well underway.

    Our client is now able to perform analysis of patient risk factors, targeting treatment plans to individuals based on risk profile. This improves the quality of care provided. The result is healthier patients and more efficient use of healthcare resources.

  • Updating & Enhancing: SchnitzerSteel.com Redesign

    Updating & Enhancing: SchnitzerSteel.com Redesign


    Schnitzer Steel is a global leader in the metals recycling industry that has grown from a single person operation in 1906 to a Fortune 1000 company today.

    Schnitzer tapped CSG to architect and develop their four public websites back in 2007. When it came time to freshen up Schnitzer's main website, Schnitzer asked CSG to implement their new designs. CSG took things a step further by using a "responsive design" approach that ensures the site works well on desktops, laptops, tablets and smartphones.

    Read Full Case Study

  • Custom Application Development and Support for Agriculture Management

    Custom Application Development and Support for Agriculture Management


    A major agriculture company based in the northwest was in need of an application to track their products through the growth and shipping lifecycle.

    The application created by CSG Pro provided a means for users with appropriate security privileges to generate records of planting, harvesting, storing, shipping, receiving and inventory across the suite of the client’s products. The application was developed with Microsoft Visual Studio using WebAPI, Typescript, Angular, Entity Framework and ADFS security in Azure.

    CSG Pro provided requirements analysis, development, quality assurance and ultimately deployment and ongoing support. The result is a secure, web-based, user-friendly application built on Microsoft Azure Web and SQL platforms. The application provides a variety of user privileges and access, as well as audit trails and archiving of records; maintaining referential integrity between records throughout the lifecycle. The application is currently used in a production capacity across North America.



A global manufacturer and distributor of sportswear

Our client had invested millions in best of breed, enterprise software platforms but their data...


Our client had invested millions in best of breed, enterprise software platforms but their data warehouse was not fulfilling all necessary requirements. CSG Pro was hired to implement an alternative data warehouse implementation using Microsoft’s BI stack (SQL Server and Power BI). This proof-of-concept was to demonstrate how the Microsoft approach could provide a better solution with dramatically lower costs.

CSG Pro delivered a fully functional version of the data warehouse for a fraction of the cost spent on the production system. As a result, our client has confidence should they chose to migrate the DW to the MS platform, saving hundreds of thousands of dollars.



Improving Processes through Custom Application Development

A state department needed an older application updated to be more responsive and reduce maintenance...


A state department needed an older application updated to be more responsive and reduce maintenance times for application updates. Current processes can take weeks or even months for simple changes and administrative updates to the application.

CSG is in the process of updating the application so that application updates are instantaneous and do not require deployment of code using an internal review process. The new process allows them to continue consolidating data from various database sources and Microsoft Excel spreadsheets and upload them to the new system.

The reduction in data load times from weeks to seconds will greatly improve the system usability. Further enhancements that automate changes currently requiring maintenance of application code will further improve system quality while reducing the number of deployments. The end result will improve the usability and reduce the total cost of ownership for the application.



A national media and publishing company

Our client publishes monthly magazines for major cities across the US. However, the operational...


Our client publishes monthly magazines for major cities across the US. However, the operational data for each of these publications resides in separate silos. With this isolated data, getting a consolidated view of the business was extremely cumbersome and unreliable. CSG built an integrated database which is populated on a nightly basis with data from all operational systems. We created interactive reports and dashboards using Microsoft Power BI.

The information is now available in the cloud to all of the people in the company who need to work with the data. The client now has a 360 degree view of the business and can monitor and manage operations much more effectively. As a result, the organization is able to optimize the bottom line results.



A worker’s compensation insurance provider

Our client has a mature and capable data warehouse. However, the primary user tool for consuming...


Our client has a mature and capable data warehouse. However, the primary user tool for consuming data and this best of breed BI tool was no longer supported. An upgrade would be costly and there would not be any significant new functionality as a result.

CSG Pro was hired to assess the feasibility of implementing Microsoft’s Power BI Platform. The need was to demonstrate how Power BI could not only replace the tool, but also prove how the solution could better empower users through self-service BI.

The results of the engagement included specific Power BI solution components and a detailed roadmap for full adoption of Power BI. With CSG’s assistance the client is no longer dependent on Cognos. They are getting more value from their data through Power BI while also significantly reducing costs.



An iconic regional company known for great food and hand-crafted beverages

Our client owns numerous thriving locations, each running stand-alone point of sale systems. Our...


Our client owns numerous thriving locations, each running stand-alone point of sale systems. Our client needed to integrate data from all locations in a centralized data warehouse. CSG Pro designed and built the data warehouse and the ETL framework required to integrate data from all locations on a nightly basis.

The solution supports business critical financial reporting and forecasting and payroll operations. Our client's business is thriving and growing at an impressive rate. The solution design makes it easy to add new locations as new properties come on line.



Custom Application Development for Healthcare

A large, healthcare provider, based in the northwest, wanted to centralize the management and...


A large, healthcare provider, based in the northwest, wanted to centralize the management and distribution of its internal reporting capabilities and catalog. The goal was to create a central dashboard of all defined reports found across the spectrum of their internal applications and databases.

The application created by CSG Pro provided a means for users with appropriate security privileges to review, create, edit reports across the organization’s environments. The application was developed with Microsoft Visual Studio using MVC, Typescript, Knockout, Entity Framework and Windows authentication security on IIS.

CSG Pro provided requirements analysis, development, quality assurance and deployment. The result is a secure, web-based, user-friendly application built on IIS and SQL platforms. The application provides multiple query mechanisms with robust search and filter capabilities, as well as list favorites, templates and sort options; all controlled through a variety of user privileges and access.



OIA Packaging Financial Dashboard

Oregon International Air Freight (OIA) is a leading third-party logistics provider that offers...


Oregon International Air Freight (OIA) is a leading third-party logistics provider that offers freight forwarding, warehousing, distribution, customs brokering, global sourcing, and creative packaging solutions.

As a leader in logistics, OIA sought creative ways to efficiently utilize all software and database systems that were helping them lead the industry yet required considerable amounts of manual effort to maintain. CSG tasks included: requirements analysis, backend data modeling, new SharePoint lists, and new ETL processes.

CSG built a highly functional, time-saving, and user-friendly dashboard that leveraged Microsoft SQL Server, Excel, PowerPivot, SQL Server Integration Services (SSIS), and SharePoint. It delivered essential information required for managing the logistics and packaging divisions.



Custom Application Development for the Insurance Industry

A large insurance company requested an update to an existing web forms application to improve...


A large insurance company requested an update to an existing web forms application to improve adoption and increase features using the latest web technologies.

The application created by CSG Pro used MVC, Typescript and Entity Framework and was deployed to an on premise IIS instance that was exposed to the public via the internet. The application requires access to internal nonpublic databases and sits in the company DMZ zone.



Automotive Industry Custom Application Development

An industry leader in the used auto parts industry requested an update to their website. They had...


An industry leader in the used auto parts industry requested an update to their website. They had a need to use current technologies to create a responsive designed that allowed mobile to desktop access. This company used shared libraries with a parent site, a custom search engine and required a site upgrade to support multiple languages.

CSG Pro provided an application which transitioned seamlessly from English to Spanish and from desktop to mobile across multiple browsers with the appropriate look and feel for each. Based on the results the client is requested additional work to bring in additional features to the site to make it more useful to its users.



Short Term Web Development Staffing and Mentoring

Multiple companies have requested CSG developers for short term replacements in both a mentoring...


Multiple companies have requested CSG developers for short term replacements in both a mentoring capacity and a fill in for missing staff developers. CSG Pro developers have a wide skill set and can quickly step in to ensure projects continue uninterrupted.



Moving applications to Azure

CSG has assisted local companies with moving their existing applications from on premise or virtual...


CSG has assisted local companies with moving their existing applications from on premise or virtual cloud machines to Azure using Azure Web Services and Azure SQL Databases. This process eliminates the need for maintaining physical or virtual servers on premise or in the cloud by selecting just the services needed in Azure. This reduces costs and maintenance time. You pay for only what you need. Since patches and backups are part of the service elements of system maintenance are eliminated which reduces time and cost for support.



Increase Awareness: OBRC - Know Your Nickel

Oregon Beverage Recycling Cooperative (OBRC) processes virtually 100% of recyclable containers...


Oregon Beverage Recycling Cooperative (OBRC) processes virtually 100% of recyclable containers redeemed throughout Oregon. Know Your Nickel, a campaign by OBRC and their branding agency, was created to educate the public on the impact of recycling.

CSG expanded the campaign message through web and mobile by creating a development strategy that included: cloud hosting, mobile design, responsive development, and localization. CSG used HTML5, CSS3 and Windows Azure was selected as the hosting platform.

The flexibility of Azure’s cloud hosting ensured website availability regardless of high usage spikes. Featured on NPR, Oregon Live and billboards across the Portland Metro area, the web campaign launched successfully and continues to deliver this important message.



A large non-profit healthcare, housing and employment agency

Our client provides life-sustaining services to a large population of high-needs individuals and...


Our client provides life-sustaining services to a large population of high-needs individuals and families. Their organization delivers diverse services requiring a cadre of operational systems. For healthcare services there was an urgent need to improve analytics in order to positively affect patient treatment outcomes. A data warehouse was a core component of the solution.

CSG Pro partnered with the client internal staff to design and build out the data warehouse. Using Microsoft SQL Server, SSAS and Power BI, the first stage of the data warehouse development is well underway.

Our client is now able to perform analysis of patient risk factors, targeting treatment plans to individuals based on risk profile. This improves the quality of care provided. The result is healthier patients and more efficient use of healthcare resources.



Updating & Enhancing: SchnitzerSteel.com Redesign

Schnitzer Steel is a global leader in the metals recycling industry that has grown from a single...


Schnitzer Steel is a global leader in the metals recycling industry that has grown from a single person operation in 1906 to a Fortune 1000 company today.

Schnitzer tapped CSG to architect and develop their four public websites back in 2007. When it came time to freshen up Schnitzer's main website, Schnitzer asked CSG to implement their new designs. CSG took things a step further by using a "responsive design" approach that ensures the site works well on desktops, laptops, tablets and smartphones.

Read Full Case Study



Custom Application Development and Support for Agriculture Management

A major agriculture company based in the northwest was in need of an application to track their...


A major agriculture company based in the northwest was in need of an application to track their products through the growth and shipping lifecycle.

The application created by CSG Pro provided a means for users with appropriate security privileges to generate records of planting, harvesting, storing, shipping, receiving and inventory across the suite of the client’s products. The application was developed with Microsoft Visual Studio using WebAPI, Typescript, Angular, Entity Framework and ADFS security in Azure.

CSG Pro provided requirements analysis, development, quality assurance and ultimately deployment and ongoing support. The result is a secure, web-based, user-friendly application built on Microsoft Azure Web and SQL platforms. The application provides a variety of user privileges and access, as well as audit trails and archiving of records; maintaining referential integrity between records throughout the lifecycle. The application is currently used in a production capacity across North America.