Programmer AnalystTSF, SQL Server

Job Description:
 

Responsibilities:

• Analyze business programs and application procedures. Assist users with developing business requirements for computer systems. Coordinate with IT Management to make system modifications and to implement system upgrades.
• Perform systems analysis and develop and document system requirements and technical specifications.
• Develop computer code and configure application systems; prepare test plans and scripts and perform system testing: prepare related system documentation.
• Perform as technical expert to HMFA staff and other parties to provide daily and ongoing support to system users as required. Respond to Divisional requests for assistance or program analysis.
• Prepare user guides and manuals, and provide user training. Recommend appropriate actions in the case of procedural problems.
• Preserve data integrity by conducting thorough testing of system changes, upgrades to software, and data conversions.
• Coordinate the prioritization and scheduling of activity with other IT staff such as database and network personnel, business users, and vendors on an ongoing basis.
• Working with users, prepare report specifications and develop reports on an as needed basis.
• Automate various processes and data within Divisions as assigned, incorporating information security and audit trails as well as business functionality.
• Provide input to the evaluation of software purchases. Coordinate, test, and install software upgrades as needed.
• Establish and maintain lines of communication with proprietary software houses and consultants; make recommendations where appropriate.
• Document, report and track software discrepancies to vendors.
• Recommend policies and procedures to improve systems, IT processes, and related business processes.

Requirements:

• Knowledge of methods and procedures used in conducting systems analyses.
• Programming skills, including Visual Studio including TSF, SQL Server, and web-based languages including Strong JavaScript skills Angular JS.
• Knowledge of and experience in designing relational databases and optimizing database structures for performance and/or maintainability.
• Knowledge of and experience in Web application development including ASP.NET and C#, MVC.
• Skills in producing reports using Microsoft reporting including SSRS, SSIS, SSAS and Power BI tools.
• Skills in developing and documenting functional specifications, system design, and technical specifications.
• Skills in creating web user interfaces with JQuery (HTML, XML, CSS and Java Script, JSON).
• Knowledge of and experience in implementing the full system development and maintenance life cycle. - Ability to implement systems using industry proven best practices, such as project methodologies and including information security and privacy.
• Ability to act as a technical advisor to HMFA staff and other parties on questions or problems relating to Agency business applications.
• Ability to devise solutions and make recommendations based on analyses.
• Ability to establish and maintain effective working relationships and to train system users.
• Ability to communicate effectively orally and in writing and to listen actively.
• Ability to analyze, document, and escalate software problems.
• Ability to maintain a positive work atmosphere in an appropriate manner that ensures cooperation and effective communication with customers, clients, peers and management.