Rent Regulation System Modernization

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.

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.

 

Preferred Qualifications: 

Bachelor’s Degree in Computer Science, Information Technology or related field.

84 months experience designing and developing data migration programs.

60 months experience identifying and proposing resolution of data quality problems using tools such as Oracle Enterprise Data Quality or Experian Pandora.

84 months experience in creating logical and physical data models for OLTP systems.

84 months experience in complex SQL development.

84 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials