Ohio Department of Youth Services
DSI re-engineered the existing educational program curriculum and staffing of the Student education program. DSI evaluated practical alternatives to revise educational staffing requirements, salaries and annual teaching calendars. DSI served as project lead to compare existing statutes relevant to youth services educational programs in light of program deficiencies experienced as compared to State schools for Blind and Deaf programs. Also made recommendations for a practical solution approach with estimated costs and expected benefits
DSI provided modifications, enhancements, web enablement, administration and support for the Grants Management Information System. DYS conducts various rehabilitation programs for child felons. DYS allocates the grants received from the federal government across various Programs. Grants Management Information System provides details of these Programs, funds granted by the federal govt. and budget allocations.
- Meeting end users, requirements collection
- Review and Evaluate requirements
- Creating business flow diagrams like ERD, Data Flow diagrams
- Developing User Interface screens using Developer 6i (Forms 6i)
- Web enabling the forms
- Creating stored procedures, functions, database triggers for data validation purposes
- Developing Reports using Crystal Reports 8.5
- Daily Database Administration
- Creating Test systems and environment
- Creating back-ups of the database
- Executing changes in Database, Oracle forms and Reports for maintenance purpose.
