Ref No.: 18-04731
Location: NYC, New York

Someone who can assess legacy systems (mainframe, asp/, access) and help work on new cloud-based systems (Microsoft). This is HEAVY on the data side – so that's what we'd need 1st and foremost. They should have the .Net framework experience as well but primary skills are database-related.

The Consultant will assist with the implementation of a Citywide Procurement System that will be used by DCAS OCP along with their constituents to manage OCPs internal and citywide goods and services contracts portfolio. The system will serve as the central repository for all procurement information and will allow for more transparency, faster cycle times, and an information clearinghouse that can be leveraged to lower contract prices for internal City consumption.
The consultant is responsible for analyzing existing ASP/ SQL based application, MS Access databases, and the Mainframe system data along with planning and taking part in decommissioning these systems as dictated by the Mayors Office of Contract Services project timeline and planning. Additionally, consultant will be expected to develop a unified approach for extracting and utilizing internal data residing in our existing in-house systems, along with collecting additional data not currently housed in systems. Consultant will also be responsible for helping to troubleshoot system /data issues as part of testing and implementation and ensuring that city staff is equipped to maintain the new application, along with data that may be moved to internal storage systems. The consultant will be expected to document and write necessary interfaces.
The consultant is expected to travel between DCAS and MOCS and work out of two office locations

NYC is implementing a cloud based procurement system PASSPort lead by Mayors office of Contracts (MOCS). DCAS is a key implantation partner. The consultant will
1. Study and document existing DCAS mainframe, SQL and access data base systems
2. Code data extraction procedures to supply data to new PASSPort System
3. Create CRM and .Net based systems to develop and create functions not supported by cloud based PASSPort system based on DCAS needs in a separate system.
Consultant will be responsible to move current data from Mainframe, SQL and access data bases, create interfaces and help decommission existing DCAS procurement systems.

5 + years of MVSP/CICS 6.5.0, ADABAS(ADAMPM5)/ NATURAL 4.72, JCL, TSO, CISC VM. Solid experience with mainframe systems data extraction.
Minimum of 7 years experience providing specialized knowledge of systems Data analysis. Excellent understanding the system from SQL database, and
Creating system analysis document.
5+ years of experience with SQL Server 2008/2012/2014/2016 in creating data models, writing stored procedures, functions, triggers and SQL scripting
5 + years of hands on experience using ASP3.0, HTML, XML / SQLXML, VB.Net, MS Visual Studio, Adobe Acrobat, Dynamic CRM, C#.Net, ASP.Net, MVC, ADO.Net, Entity Framework and LINQ, MS Windows 2008-2016,
5 + years of solid experience in data migration of SQL Server, Dynamic CRM and vice versa.

Serve as a Subject Matter Expert (SME) and provide technical leadership for all data initiatives (i.e. design principles, ETL and BI architectures, business rules/logic, Operational Data Stores, enterprise data warehouse, source-to-target mappings, data lineage and meta data requirements).
Create/deploy SQL server reports using SQL Server Reporting Services (SSRS).
Create required custom .Net or CRM based application.
Demonstrate analytical and problem-solving skills; Excellent organizational and time management skills required
Apply industrys best practices in software development
Coordinate with business analysts to develop application tailoring to business needs and meet deliverable timelines
Candidate must have strong interpersonal skills, team player and dynamic thinker
Strong knowledge of design patterns, software design and application of best practices
Experienced in Agile/Scrum development methodology

Familiarity with COBOL, decommissioning mainframe systems. Preferred knowledge of procurement systems.
7+years experience in .NET, Angular Client and C Sharp
Expert level knowledge and experience with SQL server TSQL in SQL Server 2008 and above; writing stored procedures, views, and user defined functions.
Experience with SQL Server services like SSIS, SSRS and SSAS is a must.
Multiple full lifecycle implementation experience.
Skills in ascertaining requirements for automated processes and translating them into efficient database objects.
Ability to plan all phases of projects starting with source, transformation and target.
Experience in Performance Tuning and Query Optimization.
MS certified preferred MCST or MCP SQL Server.