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.
Experience with Microsoft Office Suite.

Requirements

Qualifications

Type

Category

Qualification

Description

Competency

Required

Skills

Languages

SQL

Writing SQL scripts using SSMS

Proficient (4-6 Years)

Yes

Skills

Others

Communication skills both verbal and written

Proficient (4-6 Years)

Yes

Skills

Others

Learning ability

Proficient (4-6 Years)

Yes

Skills

Others

Software Troubleshooting

Novice (1-3 Years)

Yes

Skills

Others

Team work

Proficient (4-6 Years)

Yes

Skills

Tools

Crystal Reports

Proficient (4-6 Years)

Yes

Skills

Tools

MicrosoftOffice

Proficient (4-6 Years)

Yes

Required skills

SQL scripting (using SQL Server Management Studio)Crystal Reports report developmentCityWorks configuration and supportApplication testing (test plans, test cases, execution)Business analysis (requirements gathering and specifications)Project analysis and project tracking (work plans, deliverables, status reporting)Report and form creation/modificationData extraction and querying from SQL databasesSystems analysis and end-user support (issue resolution, enhancements, upgrades, conversion)Software troubleshootingEnd-user training and training material developmentVerbal and written communicationTeamwork and stakeholder coordination (collaborating with process owners, ITS, consultants, users)

Similar jobs