Case Studies: SQL Server

Telemedicine, using technology to bring doctors and patients together efficiently over distance, is a rapidly growing field. Since 2008, Saturn Systems has provided core software development and quality assurance services to industry leaders. Our projects range from medical device communications and integration, to online calendar management. Saturn Systems’ unique skills mix of device control and enterprise application development are the perfect fit for the industry.

The Minnesota Department of Employment and Economic Development (DEED) contracted Saturn Systems to design and develop an enterprise suite of applications to track attendance and service usage at 49 Workforce Centers across the state. Saturn Systems worked closely with DEED stakeholders, carefully designing the Customer Registration System (CRS) to meet the needs of a diverse clientele - Workforce Center operators, DEED management, and agency sponsors. The resulting solution required a variety of technologies, including: desktop applications, web services, online administration, ID card printing, bar code scanning and complex reporting. The application is used on a daily basis on more than 500 workstations in WorkForce Centers around Minnesota.

Saturn Systems was contracted to design and develop a web solution to provide fundraising services to non-profit organizations and their event participants. The purpose of the system was to allow online registration for charitable events, and offer a user-friendly, yet versatile means for fundraisers to create a personalized web site for collecting and reporting ongoing donations. To do this effectively, the system had to allow for quick and easy fundraiser registration and dynamic personalized web site, while preserving consistent organization branding. Integration with existing payment transaction software and an online and desktop fundraising tracking application were also key requirements. The resulting system was built and deployed successfully and has been instrumental in raising tens of millions of dollars for charity purposes.

A nationwide printer of newspapers, inserts and catalogs contacted Saturn Systems to replace an online portal used by chain retail advertising customers to design and customize weekly inserts. The system to be replaced was a heavyweight Java application with client PC and bandwidth requirements that frequently exceeded those of their customer base. Saturn Systems designed a new lightweight, purely web-based solution that supported online markup and annotation, page additions using approved templates and prototype generation. Significant back-end enhancements were made, adding workflow to ensure advertiser edits were routed, approved and processed. The resulting system has significantly simplified the weekly process of design, approval and publishing advertising circulars for Saturn’s customer and their advertising customers.

Saturn Systems took over support and enhancement of a complex system of web services and batch processes used by a non-profit that works with troubled mortgage owners to stay in their home. The system is continually being enhanced to add services, address new regulations and integrate with agencies and providers. The systems were developed by the previous vendor which used a hybrid onshore/offshore model. Saturn Systems was able to step in and deliver the necessary technical expertise and staffing at a lower cost than the previous vendor.

A regional provider of chemical dependency services contracted with Saturn Systems to provide support and enhancement of an existing web based secure forms solution used for tracking of all patient information and case activity. The site uses IBM Forms technology, formerly PureEdge, to accept information and integrate with attached smartcard readers to verify electronic signatures of staff and patients. The original system was developed using Microsoft Classic ASP which had become difficult to support. Saturn Systems redesigned the system to use ASP.NET and improved the usability of the interface. The resulting system has greatly simplified maintenance and reduced development costs.

A national chain of clothing stores with more than 700 outlets contracted Saturn Systems to create a web-based Customer Relationship Management (CRM) application for use by all of their stores. The resulting application integrated with the point of sales (POS) system and allowed store staff to survey customers at the time of purchase. The design required support for multiple store brands, and each retail chain required its own unique survey form containing questions designed by the chain’s marketing staff. The application is widely used to collect tens of thousands of names, addresses, birthdays and personalized notes on customers, which are used to mail promotional materials and by store managers to contact individual customers regarding special sales and new merchandise.

The Electronic Security Systems Integrated Management System (ESSIMS) application is a large scale enterprise web development initiative sponsored by SPAWAR code 743, responsible for providing physical security for Marine Corp bases throughout the world. ESSIMS is a powerful and intuitive web based project management tool that allows project engineers, program managers and USMC sponsors and site managers to manage USMC Physical Security projects. Users are able to track and manage project finances, milestones, documentation, tasking and problem reports. Saturn Systems leads a group of software engineers for this project and is responsible for project management, requirements gathering, software design and quality assurance.