The New York State Education Department is one of the largest state agencies and conducts business with each of the 705 NYS school districts and 33 Boards of Cooperative Educational Services (BOCES).

The Challenge:

NYSED, like most state agencies, is working toward conducting more business via the web. The NYPRO project will provide them with a web-based Professional Licensing and Discipline system.  As part of the development and implementation effort, data from multiple disparate sources will need to be converted into the new application.  This conversion effort will be based on the new target structures that are created for the NYPRO application.

The Solution:

IS Consilium, Inc was contracted by New York State Education Department (NYSED) to provide data analysis, data mapping and data conversion services for the NYPRO application.  The key to any successful project is the skillful combination of tools, methodologies and an experienced team.  Consilium staff will be utilizing their knowledge of the Oracle toolset and specifically, Oracle Warehouse Builder (OWB), to map, transform and convert data from varied sources such as MS Access and Excel files, HTML pages and Mainframe flat files.