Senior Programmer Analyst – Report Writer

Department of National Defence (DND) has a requirement for the continued provision of
maintenance and support services for the ULTools application. The maintenance and support services
include maintenance releases, software error correction, software documentation, the software and
support services (e.g., help desk support) for the duration of the contracted support period.

Mandatory requirements

• Undergraduate degree from a recognized university in Engineering or Computer Science and a minimum of 60 months of demonstrated Report Writer experience
  OR
  Three-year college level certificate in computer science combined with a minimum of 84 months of demonstrated quality assurance experience
  OR
  Secondary school diploma combined with a minimum of 120 months of demonstrated quality assurance experience
• 48 months’ experience with SQL 2012 (or later version) developing stored procedures, views, and functions to manipulate data
• 48 months of relevant work experience developing reports using a business intelligence software package that generates a wide variety of reports from computer data such as but not limited to SQL SSRS, Crystal Reports or equivalent software package
• Minimum of two (2) projects in the last sixty (60) months, at the time of bid closing, where the Resource developed applications using SSRS, Crystal Report or equivalent software package. *For the project to qualify, the Resource must have worked on the project for a minimum of twelve (12) months
• Minimum of 36 months in software development using Visual Studio, C#, .NET Framework 3.5 (or later version) or equivalent software package

Optional requirements

• College diploma or undergraduate degree in engineering or computer science or other related field from a recognized post-secondary institution
• More than 48 months of demonstrated combined experience with Microsoft SQL Technology and understanding of the 4 following relational database systems:
  SQL Server 2012 (or later version)
  SQL Database Management
  SQL Server Reporting Services (SSRS)
  Various versions of the Microsoft Windows Operating System
• 48 months of demonstrated experience with SQL Server 2012 (or later version); developing, maintain and optimizing SQL Server stored procedure, views and functions
• Minimum of twenty-four (24) months of experience in the last sixty (60) months, at the time of bid closing, in the following technologies:
  SQL Server
  Visual Studio
  .NET Framework 3.5 and later version
  .NET Core 2.0 and later version
  XML, JSON, HTML
  AJAX
  C# .net, VB.net
  TFS, Git, SVN
• More than 48 months of demonstrated experience developing reports using a business intelligence software package that generates a wide variety of reports from computer data such as but not limited to SQL SSRS, Crystal Reports and other software packages
• More than 48 months of work experience gathering requirements from stakeholders and advising units/end users on effective use of the new reporting functions
• Worked as a software developer on at least three (3) projects in the last sixty (60) months, at the time of bid closing, where the resource performed all of the following on each project:
  Developed software systems
  Prepared functional and technical design documents
  Participated in the implementation phase
• More than 36 months of hands-on experience in providing customer service and technical support via phone or email to more than 100 users
• Minimum of 36 months of demonstrated experience writing application software using Microsoft APIs (Word, Excel, and Access API)

General tasks

• With direction and guidance from the Senior Business Analyst (BA3) and in conjunction
  with other ULTool team personnel, the PA/RW3 will be involved in many phases of the
  system and report development life cycle and problem solving activities;
• Analyze reporting requirements of multiple stakeholders and interpret the analysis into
  generic products requirements for standard generic or customized reports that can be used
  across the entire user base;
• Create standard generic or customized reports using the MS SQL SSRS platform from
  generic product requirements created by the PA/RW3 or other members of the ULTool
  team;
• Create report and dashboard specifications according to an established standard, and to
  evolve the standard as needed;
• Prepare and maintain system and product technical documentation on the recommendation
  made and on the modification to existing reports due to new user requirements and support
  the delivery of report changes and testing and deployment with adequate documentation in
  relation with the request for changes or additional requirement;
• Assist with analysis of data and troubleshooting of possible data issues or discrepancies,
  document problems and resolution for future reference;
• Provide timely and professional support via telephone, email, remote control and
  sometimes in-person;
• Develop new reports and dashboards as well as optimize existing reports;
• Working as team member on other duties as assigned, which may include occasional travel
  to customer sites;
• Review and verify data integrity within the databases and data contained in them by
  running diagnostic reviews of data to verify the data is homogeneous and will report and
  review all suspected outliers;
• Develop software tools, including the research, design, programming and testing of the tool
  software, as well as support existing software tools such as ULTools;
• Communicate with people at all levels of the business, including gathering requirements
  from stakeholders and advising operational units/end users on effective use of the new
  reporting functions;
• Accepting, analyzing and troubleshooting of trouble tickets reported through the Air Force National Service Desk (AF NSD);
• Documenting actions taken to resolve reported problems through the RCAF’s Trouble Ticket Reporting System (Assyst), including actions requiring escalation to higher levels of support such as Ocean;
• Performance of routine “housekeeping” tasks required to maintain the integrity of the ULTools data;
• Submitting recommendations and/or observations on matters that affect ULTools sustainability to AFCCIS LCMM/1 CAD/A6C2IS;
• Maintaining, revising, identifying ULTools Reporting requirements;
• Assisting the site implementation teams, on an “as requested basis”
• Assist the AFCCIS LCMM in testing, installing, configuring, and updating new ULTools software releases and updates. Including testing the baseline configuration against new interfaces (ex: Monitor Mass) or changes to the network operating environment (ex.: upgrade from Window 7 to Windows 10).   Testing occurs virtually or on-site at an Ottawa test facility developed or selected by the AF CCIS LCMM.  Support includes but is not limited to:
  Provide technical advice
  Installation and configuration activities
  Troubleshooting
• Provide advanced technical and functional training to:
  1 CAD/A6C2IS staff, including the AF NSD
  AFCCIS LCMM staff
  DND/CF Subject Matter Experts and key unit personnel
• Provide on-going training to existing users of ULTools and provide training to new users of ULTools at new RCAF sites
  Collection, analysis, and resolution of ULTools configuration issues that cannot be resolved remotely;
  Maintenance, revision, identification of ULTools Reporting requirements
  Reinforcement of training to unit personnel
  Participation in workshops or OWG
• Participate in site surveys;
• Update and identify ULTools data elements and related business processes;
• Help users to integrate the ULTools capabilities/features into the daily operations/activities by replacing existing tools (i.e., graphics, spreadsheets, etc.);
• Provide on-going guidance and training in the use for ULTools;
• Review data collected during both site surveys and at the beginning of the installation phase;
• Make recommendations to the Technical Authority or delegated representative on how to apply collected data to further configure the Software to meet the users’ needs;
• Participate in post installation / upgrade lessons-learned meetings.