Previous Job
Programmer Senior High
Ref No.: 18-00696
Location: Albany, New York
Start Date: 06/26/2018

Is this a Project or Program specific request (e.g., Connections, SFS)?
If yes, please list the Project or Program Name:
New York Incident Management Reporting System (NIMRS) and various Health Cluster projects as necessary
Please provide a short description of the project:
With Oracle database as the data store, enhance the NIMRS web application and integrate application data with other OMH and Justice Center systems.
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
Daily Tasks will include but not limited to the following:
1. Working with project stakeholders and ITS manager and technical team to design business rules for developing/modifying modules to integrate with existing internal and external modules.
2. Use TOAD for Oracle to create Oracle PL/SQL stored procedures and packages in Oracle database.
3. Use Microsoft Visual Studio 2010/2012 to implement new business rules as well as maintain application code using VB.Net, C#.Net, JavaScript, AJAX, XML and HTML using Oracle database.
4. Use TFS as a repository for the source code, for checking code in and out and for tracking project work items.
5. Use Crystal Reports/.Net/TOAD for Oracle to create new/enhance existing reports.
6. Perform unit testing on all code changes.
Which Service Group is required?
What is the number of staff being requested?
(maximum of 5)
Which Job Title Category is required?
Which Skill Level is required?
Which Skill Demand is required?
How many Candidate Response Forms are being requested per Contractor per position?     (1 or 2)
When is the Target Start Date?
(30 Business Days minimum from date of request)
How long is the engagement? (in months)
When is the estimated completion date?
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)?
If  Part-Time, enter approximate number of hours per week:
What are the daily work hours? (note if negotiable or list preferred start and end time):
8 hour days with start time at or after 7:30
Where is the Home Base Region?
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP
Office of Mental Health/ITS
44 Holland Avenue
Albany, NY 12229
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)
Microsoft, Oracle 11g, .NET, Tools for Oracle Application Development (TOAD), Client Quality Center, Subversion, Fortify
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)
Client / Dell
Position Mandatory Qualifications
-Analysis, design, coding, component and assembly testing of all application code owned by the Application Team.
-Maintenance (including production support), enhancement and development work.
-Write application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions.
Senior 60-84 Months
Candidate is able to work without assistance and can provide leadership for others; may have advanced education.
Requested Qualifications
72 Months       Demonstrated experience programming web based applications in C#.Net, VB.Net in a Multi-Tier environment with focus on using an Oracle database.
72 Months        Demonstrated experience with Oracle 9i or higher in ORACLE PL/SQL coding utilizing stored procedures, packages, indexes, triggers, creating tables, etc. using an ORACLE 9i or higher database. (NOTE: Microsoft SQL Server or MS Access will NOT be considered as valid database experience)
72 Months        Demonstrated experience with Ajax, XML, JavaScript, Cascading Style Sheets, and HTML.
48 Months        Demonstrated experience designing and invoking Crystal Reports (NOT SSRS) from web based applications using an Oracle database.
36 Months        Demonstrated work experience developing applications with MVC.
20 Months        Demonstrated experience developing clinical applications for a complex health related agency, including experience with HIPAA protected data.
Additional Information Requests:
Are there additional security requirements for the Authorized User?
HIPAA and OMH Confidentiality and Non-Disclosure Agreement (CNDA)
Will additional training possibly be required during the Engagement?
If Yes, provide description of anticipated training.
Candidate will attend all New York State/GOER and Agency mandated training programs, including Internal Controls, Prevention of Workplace Violence, Sexual Harassment Prevention, Information Security
What type, or manner, of Knowledge Transfer is requested during the engagement?
During the term of this assignment, knowledge transfer from the consultant/project team to State employees will be mandated. The knowledge transfer plan will be a written plan with details determined by the State Project Manager in collaboration with the selected contractor according to the specific program needs.
Is travel anticipated during the Engagement?
Yes, please list anticipated frequency and locations for travel: