Business Alignment

228 Pages·2016·3.7 MB·English

by  Naas, John

Position Catalogue

SaskPower IT&S – Position Catalogue

Version 1.0 1 of 228
9 March 2016
Position Catalogue
Document review and approval
Revision history
Version Author Date Revision
0.1 Andrew Chad, Manager IT Vendor 2014/01/16 Initial Draft
Management
0.2 Andrew Chad, Manager IT Vendor 2014/01/27 Updated based on feedback from IT&S Managers
Management
0.3 Andrew Chad, Manager IT Vendor 2014/02/21 Updated based on feedback from IT&S Managers
Management
0.4 Andrew Chad, Manager IT Vendor 2014/03/04 Updated based on feedback from IT&S Managers
Management
1.0 Andrew Chad, Manager IT Vendor 2014/03/10 1st official release as part of VoR – Staff Augmentation RFP March 2014
Management
1.1 Andrew Chad, Manager IT Vendor 2015/04/14 Addition of Training Consultant to Project Delivery Position Category
Mgmt & Resource Planning
1.2 Ryan Normand, Admin Coordinator 2016/03/04 Addition of Account Manager to Business Support Services Category
BP&P
This document has been reviewed by
Reviewer Date reviewed
• VoR Manager Working Group 2014/01/22
• VoR Manager Working Group 2014/02/25
• SaskPower Legal Department 2014/03/07
•
This document has been approved by

Name Title Date approved
1 Andrew Chad Manager, IT Vendor Management March 4, 2014
2 Derek Cherneski Manager, Cyber Security February 25, 2014
3 Donnaleen Bowns Manager, Solution Architects March 3, 2014
4 Ian Cameron Manager, Project Delivery February 28, 2014
5 Shawn Dawson Manager, Project Delivery March 11, 2014
6 Randy Munholland Manager, Network Services February 25, 2014
Version 1.0 2 of 228
9 March 2016
Position Catalogue
7 Robert Schultz Manager, Business Analytics February 28, 2014
8 Scott Rider Manager, Deskside Support February 6, 2014
9 Terry Mack Manager, Application Support February 26, 2014

Version 1.0 3 of 228
9 March 2016
Position Catalogue
TABLE OF CONTENTS
PURPOSE ...................................................................................................................................................................................................................... 6
EXECUTIVE SUMMARY ............................................................................................................................................................................................... 6
POSITION-TO-POSITION CATEGORY MAP ............................................................................................................................................................... 7
POSITIONS .................................................................................................................................................................................................................. 10
.NET DEVELOPER AND SUPPORT ANALYST .................................................................................................................................................................. 10
3RD PARTY APPLICATION SUPPORT ANALYST & DEVELOPER ......................................................................................................................................... 14
3RD PARTY DATABASE ADMINISTRATOR ........................................................................................................................................................................ 19
ACCOUNT MANAGER ................................................................................................................................................................................................... 24
AUTOMATED TEST SPECIALIST .................................................................................................................................................................................... 29
BUSINESS ANALYST .................................................................................................................................................................................................... 32
BUSINESS INTELLIGENCE ANALYST .............................................................................................................................................................................. 35
BUSINESS INTELLIGENCE (BI) SPECIALIST .................................................................................................................................................................... 38
BUSINESS WAREHOUSE (BW) SPECIALIST ................................................................................................................................................................... 42
USABILITY / USER EXPERIENCE SPECIALIST ................................................................................................................................................................. 46
DESIGN ENGINEER ..................................................................................................................................................................................................... 49
DESKSIDE TECHNICIAN ............................................................................................................................................................................................... 52
DISASTER RECOVERY CONSULTANT ............................................................................................................................................................................ 55
ENTERPRISE ARCHITECT ............................................................................................................................................................................................. 58
ENTERPRISE SECURITY ARCHITECT ............................................................................................................................................................................. 61
ENTERPRISE SECURITY CONSULTANT ......................................................................................................................................................................... 65
ENTERPRISE SECURITY SPECIALIST ............................................................................................................................................................................ 68
GIS DATABASE ADMINISTRATOR ................................................................................................................................................................................. 71
IMAC INSTALL TECHNICIAN ......................................................................................................................................................................................... 76
INTEL SERVER SUPPORT............................................................................................................................................................................................. 80
IT PLANNER/SCHEDULER ............................................................................................................................................................................................ 86
MESSAGING SUPPORT ................................................................................................................................................................................................ 89
MOBILE APPLICATION DEVELOPER AND SUPPORT ANALYST .......................................................................................................................................... 93
NETWORK SUPPORT ANALYST .................................................................................................................................................................................... 96
OPENTEXT DEVELOPER AND SUPPORT ANALYST ....................................................................................................................................................... 101
ORACLE DATABASE ADMINISTRATOR ......................................................................................................................................................................... 107
ORGANIZATIONAL CHANGE CONSULTANT ................................................................................................................................................................... 112
PORTFOLIO MANAGER .............................................................................................................................................................................................. 116
PROGRAM MANAGER ................................................................................................................................................................................................ 122
Version 1.0 4 of 228
9 March 2016
Position Catalogue
PROJECT ADMINISTRATOR ........................................................................................................................................................................................ 126
PROJECT MANAGER ................................................................................................................................................................................................. 130
PROJECT QUALITY ASSURANCE ................................................................................................................................................................................ 134
SAP DEVELOPER ..................................................................................................................................................................................................... 137
SAP FUNCTIONAL CONSULTANT ............................................................................................................................................................................... 140
SAP NETWEAVER ADMINISTRATOR........................................................................................................................................................................... 144
SAP SECURITY CONSULTANT ................................................................................................................................................................................... 148
SAP SOFTWARE QUALITY ANALYST .......................................................................................................................................................................... 152
SECURITY ADMINISTRATOR ....................................................................................................................................................................................... 156
SERVICE DESK SUPPORT .......................................................................................................................................................................................... 159
SHAREPOINT DEVELOPER AND SUPPORT ANALYST .................................................................................................................................................... 163
SOFTWARE QUALITY ANALYST .................................................................................................................................................................................. 168
SOLUTION ARCHITECT - APPLICATION ........................................................................................................................................................................ 172
SOLUTION ARCHITECT - BUSINESS ............................................................................................................................................................................ 174
SOLUTION ARCHITECT - INFORMATION ....................................................................................................................................................................... 176
SOLUTION ARCHITECT - INFRASTRUCTURE ................................................................................................................................................................. 178
SOLUTION ARCHITECT - INTEGRATION ....................................................................................................................................................................... 181
SOLUTION ARCHITECT - SAP .................................................................................................................................................................................... 183
SOLUTION ARCHITECT - SECURITY ............................................................................................................................................................................ 186
SQL DATABASE ADMINISTRATOR .............................................................................................................................................................................. 188
SYSTEMS MANAGEMENT SPECIALIST ......................................................................................................................................................................... 193
TRAINING CONSULTANT ............................................................................................................................................................................................ 196
UNIX MIDRANGE SUPPORT ...................................................................................................................................................................................... 200
USABILITY / USER EXPERIENCE SPECIALIST ............................................................................................................................................................... 207
WEB APPLICATION DEVELOPMENT AND SUPPORT ANALYST ........................................................................................................................................ 210

Version 1.0 5 of 228
9 March 2016
Position Catalogue
Purpose
The purpose of this document is to define the Positions required by SaskPower IT&S to support their IT infrastructure and service requirements.
Executive Summary
The SaskPower IT&S Position Catalogue identifies and describes in one cohesive document the potential contractor Positions that SaskPower IT&S may require
to deliver services to its customers. It is a living document that provides stakeholders with detailed information on each position. It includes:
• A common catalogue of position descriptions,
• Major Responsibilities,
• Activities,
• Qualifications, and
• Seniority definitions.
The Position Catalogue also contains a Position Category to Position map for quick reference. Through the competitive procurement process Vendors become
eligible to bid on resources by Position Category. For example, Vendors who are qualified under the Infrastructure Services Position Category will be invited to
bid on any new opportunity that arises under the Infrastructure Services Position Category (including any current positions or positions added over the term of
the vendor agreement). Note that the Position descriptions are alphabetized by Position Name.
Note the following:
• All Positions must adhere to the General Requirements and Practices outlined in Appendix A;
• Seniority is determined by a combination of relevant years of service (i.e. years utilizing the specific technology(s) or performing the role) and Seniority
Level Descriptions found in Appendix B;
• Appendix C provides SaskPower’s Approved Application List which pertain to some of the positions; and
• Appendix D contains a list of GIS Specific Applications which pertain to GIS related positions.

Version 1.0 6 of 228
9 March 2016
Position Catalogue
Position-to-Position Category Map
Position Category Position Name
.Net Development & Support .Net Developer and Support Analyst
Application Development & Support 3rd Party Application Support Analyst & Developer
Architectural Services Enterprise Architect
Architectural Services Solution Architect – Application
Architectural Services Solution Architect – Business
Architectural Services Solution Architect – Information
Architectural Services Solution Architect – Infrastructure
Architectural Services Solution Architect - Integration
Architectural Services Solution Architect - SAP
Architectural Services Solution Architect – Security
Business Support Services Business Intelligence Analyst
Business Support Services Project Administrator
Business Support Services Account Manager
Database Development & Support 3rd Party Database Administrator
Database Development & Support Oracle Database Administrator
Database Development & Support SQL Database Administrator
Engineering Services Design Engineer
Enterprise Content Management (ECM) Development & Support OpenText Developer and Support Analyst
GIS Development & Support GIS Database Administrator
Infrastructure Services Deskside Technician
Infrastructure Services Disaster Recovery Consultant
Infrastructure Services IMAC - Install Technician
Infrastructure Services Intel Server Support
Infrastructure Services IT Planner/Scheduler
Infrastructure Services Messaging Support
Infrastructure Services Network Support Analyst
Version 1.0 7 of 228
9 March 2016
Position Catalogue
Position Category Position Name
Infrastructure Services Security Administrator
Infrastructure Services Service Desk Support
Infrastructure Services Systems Management Specialist
Infrastructure Services UNIX Midrange Support
Mobile Development & Support Mobile Application Developer and Support Analyst
Project Delivery Business Analyst
Project Delivery Organizational Change Consultant
Project Delivery Portfolio Manager
Project Delivery Program Manager
Project Delivery Project Manager
Project Delivery Project Quality Assurance
Project Delivery Training Consultant
SAP Services Business Intelligence (BI) Specialist
SAP Services Business Warehouse (BW) Specialist
SAP Services SAP Developer
SAP Services SAP Functional Consultant
SAP Services SAP NetWeaver Administrator
SAP Services SAP Security Consultant
SAP Services SAP Software Quality Analyst
Security Enterprise Security Architect
Security Enterprise Security Consultant
Security Enterprise Security Specialist
SharePoint Development & Support SharePoint Developer and Support Analyst
Software Quality Services Software Quality Analyst
Software Testing Specialist Automated Test Specialist
User Experience Development & Support Usability/User Experience Specialist
Web Development & Support Web Application Development and Support Analyst
Version 1.0 8 of 228
9 March 2016
Position Catalogue

Version 1.0 9 of 228
9 March 2016
Position Catalogue
Positions
Position Name Position Category Last Revised
.Net Developer and Support Analyst .Net Development & Support February 21st, 2014

Major Responsibilities: Elements:
• Analyze and design of .net oriented software solutions
• Requirement analysis
• Identify the scope of work required to complete software development
• Design
activities
• Development
• Perform application testing and lead design and code walk-through sessions
• Integration and test
to ensure adherence to development standards
• Implementation
• Identify common SOA implementation scenarios
• Operations & maintenance
• Identify the products and technologies used to build connected systems
solutions

• Create distributed applications using the Team Foundation Server
• Streamline application development using leading practices and standards
• Manage identities and authorizations using leading practices
• Participates in code review
• Leverage SaskPower standards for user interface
• Work with Controls – build sites using ASP.NET controls including basic web
controls, validation controls, list controls, rich user controls, and custom
controls
• Build and use task-specific controls and how to convert web forms into user
controls
• Use validation controls to perform client-side and server-side validation
depending on browser capabilities
• Create applications that query, filter, order, and group data from external
data sources
• Bind data to an ASP page using data-bound controls.
Version 1.0 10 of 228
9 March 2016