A Journey to the Cloud: Stored Procedures to Serverless Architecture

Thursday, December 12

12:45 pm – 1:45 pm

Future is Now

Timothy Hellman
Application Developer ITS4, MNIT at MDH

Rohit Saxena
Systems Analysis Unit Supervisor, MNIT at MDH

Over the past 15 years, the legacy reporting tool had become a patchwork of EPA mandates and code fixes. With more mandates needing to be incorporated, it was in the Minnesota Department of Health Environmental Health’s best interest to start anew using the Amazon Web Service Cloud (AWS) to innovate and modernize. In this session, you’ll hear the story of our continuing journey from on-premise monolithic legacy application to cloud-based Serverless architecture. We’ll outline the successes and pitfalls we found along the way as we replaced a legacy reporting tool with cloud-based Serverless architecture.

We will discuss the steps we took to create the new reporting process; how we used secure Restful APIs designed in swagger and implemented as AWS API Gateways; how both the UI and APIs were secured using IDAM implemented in Active Directory and Keycloak; and how data processing was handled using serverless orchestration implemented in AWS Step Functions and processed using a multitude of functions as a service (FaaS) implemented as AWS Lambda Functions.

We will discuss what we learned along the way, what worked well and what we would do differently, and how we jump started the process by working with an AWS cloud services architect. We’d also like to share how effectively our DevOps team worked together. Please follow us along on our journey!

Learning Objectives

  1. Understand the process and planning involved in moving a legacy application to the cloud.
  2. Gain awareness of some of the possible solutions and tools available when moving to cloud computing.
  3. Recognize that moving legacy applications to the cloud is possible and effective.


About GTS Educational Events

If you are a nonprofit or public sector group looking to create a conference, workshop or educational event with impact, look to GTS. We believe educational events are successful when participants learn and grow and then return to their organizations and communities to make them stronger. We look forward to continuing our work with the broad spectrum of organizations striving to make a difference for the people and communities they serve.

Steering Committee

Alex Hepp, City of Hopkins
Bill Bleckwehl, Cisco
Dave Andrews, DEED
Jay Wyant, Minnesota IT Services
Jim Hall, Ramsey County
Matt Bailey, IBM
Melissa Reeder, League of Minnesota Cities
Nathan Beran, City of New Ulm
Sue Wallace, IT Futures Foundation
Lisa Meredith, Minnesota Counties Computer Cooperative
Justin Kaufman, Minnesota IT Services
Renee Heinbuch, Washington County/MNCITLA
Jerine Rosato, Ramsey County
David Berthiaume, Minnesota IT Services
Cory Tramm, Sourcewell Tech 

Content Committee

Tomas Alvarez, Federal Reserve
Tom Ammons, MN.IT – Central
Dave Andrews, MN State Services for the Blind
Susan Bousquet, MN.IT – DOT
Robert Granvin, Metro State
Alex Hepp, City of Hopkins
Shawntan Howell, Ramsey County
Jenny Johnson, Metropolitan Council
Millicent Kasal, MN.IT – Central
Ping Li, MN.IT – MMB
Chibuzor Nnaji, MN.IT – DHS
Mehrdad Shabestari, MN.IT – Central