Crystal Report Developer

Prospect Infosystem Inc.; Nashville (TN); On-site; USD 70,000 - 90,000; Full time

Job summary

Prospect Infosystem Inc. in Nashville is seeking an experienced application support analyst to provide primary CityWorks support for select government departments. The role includes testing, troubleshooting, business analysis, and coordination with ITS and stakeholders.

You will create reports in Crystal Reports, run SQL queries, and perform data extracts from SQL data warehouses. Experience with CityWorks configuration and user training is required for successful delivery.

Qualifications

• Experience with CityWorks configuration and support.
• Crystal Reports experience for reporting requirements.
• SQL queries for extraction/updating of data.
• Coordinate end-user meetings and deliver training materials.

Responsibilities

• Providing primary application support for CityWorks for government departments.
• Performing application testing (test plans/cases and execution) and troubleshooting.
• Performing business analysis activities and delivering status reports.
• Data extracts from SQL based on user requests and public requests.
• Coordinating with process owners, users, ITS, and consultants.
• Preparing and updating training materials for end-user training.

Skills

Business analysis

Stakeholder coordination

User level meetings

Training coordination

Tools

CityWorks

Crystal Reports

SQL

SSMS

Job description

• Providing primary application support for CityWorks which is being used by a select group of general government departments.
• Performing application testing (test plans/cases and execution) and troubleshooting for all CityWorks and related systems and applications.
• Performing business analysis activities for enterprise-wide application such as: work plan input, deliverable definition and tracking, status reporting, conducting user level meetings.
• Report or form creation/modification in Crystal Reports and SQL queries using Cityworks and Land Management data.
• Performing project analysis activities for enterprise-wide application projects such as: work plan input, deliverable definition and tracking, status reporting, conducting user level meetings, and preparing application requirements/specifications.
• Coordinating and communicating with other team members including process owners, users, departments, ITS technical team, and consultants.
• Data extracts from SQL based on user request and/or public request
• Experience with CityWorks configuration and support, Crystal reporting, and SQL queries
• Experience with SQL Server Management Studio (SSMS)
• Experience writing SQL queries to update or extract data from a SQL database
• Experience as systems analyst, supporting users with issues resolution, system enhancement, upgrades and conversion.
• Experience coordinating and conducting end-user training including preparing and updating training materials. As part of an implementation training rollout a plus.