Event List
Prev MonthPrev Month Next MonthNext Month
Data Analytics Workgroup Meeting - October 2021
Wednesday, October 20, 2021, 1:00 PM - 2:00 PM EST
Category: Albany Workgroup Meeting

Click here to register In-Person
Click here to register for Webex

Plays for Modernizing Homegrown Systems

Like most institutions public and private, the New York State Department of State (the department) has quite a few homegrown and aging data processing systems.  Many of these systems are essential supports for the department’s critical business functions.  Frequently their use extends beyond the tenure of their creators.  Documentation, if present at all, often fails to keep up with their evolution.  The resulting lack of understanding of these systems’ design and operation can impede efforts to overhaul or replace them.

In this presentation, Ari Epstein will discuss some of the challenges the department has faced attempting to modernize these tools and some of the practices it is developing and trying.  Ari will walk through a process the department developed to facilitate systems migration, using some DOS systems implemented with Microsoft Access as examples. 

The presentation will cover:

  1. approaches to documenting functionality in legacy systems,
  2. developing repeatable, automated migrations using extract-transform-load (ETL) tools,
  3. prototyping,
  4. making the switch to a new solution, and
  5. assuring ongoing maintenance and support.


Ari Epstein - Ari has 17 years’ experience managing data and technology assets in public sector and higher education contexts.  He serves as the New York State Department of State’s chief data officer.  In this capacity, he leads efforts to stand up governance, education, and tools needed to measure and improve the department’s data management practices.  Prior to his current role, Ari oversaw several strategic technology initiatives in the department’s Office of Local Government. Before he joined state service in 2014, Ari oversaw Cornell University’s shared campus governance programs, delivering online solutions to support voting, grants management, and committee operations.  Ari holds a B.S. in Biological Sciences from Cornell University and M.P.A. from Syracuse University.


Please note: Upon registering, you will receive the webex information within the confirmation email

As of June 17, 2021 The NYS Forum has lifted all restrictions related to COVID-19 screening and social distancing procedures within our offices.   We are pleased to be able to again offer full capacity, in-person attendance for all of those who prefer this method of participation.   The NYS Forum requests that any unvaccinated individuals please continue to wear a mask when inside the building.