CRM Developer

Posted: 1 month ago

THE ROLE
ITD's Database and Application Development (DAD) section is currently in the process of working with a vendor to build an enterprise system for managing the agency's land use applications. This enterprise system will consolidate three legacy applications. It will be built with a cloud-hosted instance of Microsoft Dynamics CRM and locally–hosted Microsoft SharePoint. The new application will include an Applicant Portal, Work Flow Tracking, Dashboards, Reporting and a Document Repository.
DAD is also responsible for designing, developing and maintaining the agency's major databases and application systems. The section maintains 20+ databases and applications, including ASP.NET, VB.NET, and Access/VBA applications with Microsoft SQL Server databases and a mainframe system. The section also routinely geo-processes data in bulk for various divisions at DCP and for select external agencies.
The Database and Application Development section seeks a talented and versatile CRM Developer to join its team of programmers, analysts and data specialists.
Reporting to the Director of Database and Application Development, the CRM Developer will be a key member of the team developing the critical application for managing the agency's land use and environmental review process. The CRM Developer will be responsible for all phases of the software development lifecycle (mainly in .NET, JavaScript, and in Microsoft Dynamics CRM/XRM), including planning, designing, developing and reporting, unit testing, installing, deploying, maintaining and supporting. The CRM Developer will also be responsible for understanding business requirements; translating those requirements into functional requirements and mock-ups of the application; verifying that the application is according to specifications; and ensuring that it meets the end user expectations.
The CRM Developer will also work with other programmers in the development of new applications and enhancements to several major applications including the PLUTO Database, which contains over 70 fields of land use and property-related information and is extensively used throughout city government and by community groups, educators, researchers and developers; the E Designation Database, which tracks environmental requirements and is being redesigned to contain a public facing component; and the Zoning Tax Lot Database, which is a database that contains the most up-to-date tax lot zoning designations and serves as an input to a number of other citywide applications.
Primary areas of responsibilities include, but are not limited to:
• Designing and developing database and application systems using Microsoft Technology Stack (CRM Dynamics, ASP.NET VB/C#, JavaScript and SQL Server Reporting Service)
• Supporting and enhancing the existing CRM Dynamics application as required to support business needs
• Customizing and modifying existing CRM Dynamics features and implement reports
• Developing store procedures, SSIS packages and maintaining existing data routines and products
• Supporting data migration activities in support of production cutover for new systems
• Maintaining code base in Team Foundation Server (TFS)
• Serving in multiple roles during in-house software development and release
• Routinely communicating and interfacing with agency leaders
• Collaborating with end users, technical staff and the city's oversight technology agency on requirements for enhancement initiatives
• Performing programming tasks with a high degree of quality and efficiency
• Investigating, analyzing, designing, programming and implementing effective solutions to meet business needs
• Assisting in the maintenance and updating of in-house applications
• Configuring business process flows to meet client needs and customizing where appropriate
• Building integrations with COTS and other agency systems