Previous Job
Specialist Expert High
Ref No.: 18-01219
Location: Albany, New York
Start Date: 10/18/2018
Agency: Information Technology Services (ITS)

Is this a Project or Program specific request (e.g., Connections, SFS)? Yes
If yes, please list the Project or Program Name: OFT000000000047 - HUTS Replacement 

Please provide a short description of the project: The RRSM project will result in a solution that will address the business transformation of three core business functions and the development of a modern, web-based application and reporting system for Homes and Community Renewal's Office of Rent Administration (ORA), the Tenant Protection Unit (TPU, and the General Counsel's office.

Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
Perform all stages of data migration from data analysis to pre go-live validations, user acceptance testing, user sign-off, cut-over planning and post go-live validations. 
Interact with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
Develop logical and physical data model for OLTP system.
Design, develop and maintain data migration programs and manage migration tools using SQL Server Integration Services (SSIS) and T-SQL.
Develop data quality reports for the business to identify and drive data cleansing and remediation efforts.
Writing T-SQL for data validation and post conversion reports.
Develop complex queries using T-SQL.
Document data extraction, mapping, cleansing and migration processes.

Which Service Group is required?
Service Group 1. STANDARD TITLES
What is the number of staff being requested? 
(maximum of 5) 1
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) 1
When is the Target Start Date?
(30 Business Days minimum from date of request) 12/11/2018
How long is the engagement? (in months) 24
When is the estimated completion date? 12/10/2020
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)? Full Time
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): 8A.M.-5P.M.
Where is the Home Base Region? 
Region 1 - Capital Area
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP 1220 Washington Ave. B5 and Hampton Plaza 38-40 State St. , Albany,  NY , 12226
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”) Microsoft and Oracle
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”) Microsoft Windows server and client platforms

Position Mandatory Qualifications
- Experience in the usage and support of a collection of development platforms, technical architectures, or business applications and products that run on those platforms, beyond that of a Programmer- The Authorized User may seek Specialists in the following areas (list is not exhaustive):• Backup and Recovery• Security
84+ Months: Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field

Requested Qualifications 
Bachelor's Degree in Computer Science, Information Technology or related field.
At least 84 months experience developing complex end-to-end data migration programs
At least 60 months experience identifying and proposing resolution of data quality problems using tools such as Oracle Enterprise Data Quality or Experian Pandora. 
At least 84 months experience in creating logical and physical data models for OLTP systems
At least 84 months experience in complex SQL development.
At least 84 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials

Additional Information Requests:
Are there additional security requirements for the Authorized User? Mandatory ITS Security Agreements and Fingerprint-based Background Check.
Will additional training possibly be required during the Engagement? Yes  
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? Build Docs and configuration Changes must be documented.  Knowledge Transfer will be required utilizing presentations and mentoring of State Staff. Candidate must be able to communicate clearly and precisely to an
team of subject matter experts who must benefit from extensive knowledge transfer during this engagement. Agency staff will become largely independent and self-sufficient during this engagement through weekly meetings during the project.
At the end of the engagement, a transition meeting will be required to review any open items for the project. A list of open tasks must be
submitted and reviewed during the final transition meeting
Is travel anticipated during the Engagement? No