Application Analyst

Title: Application Analyst

Location: Sunnyvale ,CA

Duration: 6 months

Required Skills:

• Essential job functions may include, but not limited to:
• Plans, designs, recommends, installs, upgrades, and supports application systems, interfaces, queries, database, scripting activities, and business intelligence/reporting solutions to achieve optimum performance in accordance with the IT Service Level Agreement (SLA).
• Completes service requests in a timely manner and provides support to end users; guides and assists others in completing service requests. Troubleshoots, upgrades, or configures application, database or reporting systems to determine cause(s) or failure and resolves problems, to include cybersecurity issues.
• Designs, documents, develops, codes, tests, and debugs applications and interfaces.
• Analyzes, validates, and documents business processes and system requirements using standard Business Analysis tools and methodologies for the development or procurement of software systems.
• Designs, documents and develops extract, transform, load (ETL) processes to ensure accessibility of data from business systems for reports or use by other systems.
• Ensures systems and applications, including the City's Internet and Intranet, are patched and kept current on all security patches and upgrades.
• Conducts design sessions and develops design documents.
• Evaluates and monitors cost acquisition of applications, scripting, and reporting tools related items to obtain the best results, meet budget guidelines, and ensure system compatibility.
• Assists in the development and execution of preventive maintenance programs identifying weaknesses of current systems to determine critical application, reporting or system issues, including cybersecurity. Develops technical system documentation, training materials, and provides training to users and support staff.
• Prepares presentation materials for meetings; documents and follows up on actions and decisions from meetings.
• Assists in the development and operations of the IT Strategic Plan (ITSP).
• Provides input and recommendations on new technology and solicits technical specifications.
• Communicates clearly and concisely, both verbally and in writing.
• Assists in the creation of operational procedure manuals.
• Provides guidance to team members.
• Acts as a liaison between the various divisions within the department along with the client departments.
• Provides subject-matter expertise on complex technical issues.

Knowledge Skills & Abilities:

• Principles and practices of excellent customer service.
• Extensive knowledge and experience of Report writing with Crystal Report and Microsoft SQL Server Reporting Services
• Principles and practices of ITSM (IT Service Management) systems to include Incident; Request Fulfilment; Knowledgebase; Asset Management and IT Service Catalogs.
• Developments and trends of application and reporting solutions.
• Fundamentals of Business Analysis Core Concept Model (BACCM) framework defined in Business Analysis Body of Knowledge (BABOK).
• Database design and basic administration of database platforms like Microsoft SQL Server and Oracle.
• RDBMS programming including stored procedures and user functions Basic knowledge of Local Area Network (LAN), wireless, and Wide Area Network (WAN) technology.
• Microsoft Office, Microsoft Project and Microsoft Visio.
• Team formation and execution; how to motivate teams.
• Cost-benefit analyses to recommend the most effective solution.
• Provide excellent customer service. Communicate effectively, orally and in writing. Gather and document requirements for function changes and new requirements, translating user
• defined requirements into technical specifications. Plan, design, document, install and support application systems, scripting, business intelligence reports for both enterprise and departmental needs.
• Effectively organize, prioritize, and follow-up on work assignments to meet established deadlines.
• Prepare clear and concise written reports and technical documentation.
• Respond promptly and effectively to requests for service, including cybersecurity incidents.
• Develop complex reports using business intelligence tools; convert data into information.
• Learn new business systems, programming languages, reporting tools, databases, and other technology tools as required to support the City's operations.
• Perform cost/benefit analysis for applications, reports, systems enhancement or replacement. Establish and maintain and promote positive and effective working relationships with employees, other agencies, public officials, and the public.
• Demonstrate initiative and exercise good judgment in the performance of duties. Work independently and as a team member; recognize and set priorities and meet deadlines.
• Work with vendors, ensuring the priorities of the City are met. Serve as a client liaison to identify and define project requirements, scope and objectives.
• Provide guidance and direction to team members.
• Provide emergency response to reduce downtime, correct errors or monitor vendor activity surrounding critical system failures, off-hours scheduled maintenance downtime or work on call on a scheduled and as needed basis.
• Provide services in different geographical locations throughout the City as requested by users or needed.

Desired Skills:
Previous experience working in a public agency.
Certifications in current programming or scripting languages.

Required:
Possession and continued maintenance of a valid class C California driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.