Personnel Work Skills

Appendix RR

Personnel Work Skills

• Monitor all staff work performance
• Develop and implement contract problem/resolution procedures in adherence to the signed agreement
• Provide status reporting on all project phases
• Provide clarification on any invoices submitted
• Ensure contract compliance, efficiency and timeliness in adherence to the signed agreement
• Produce and maintain reports and documentation as required by contract
• On-board staff as required; conduct all staff clearances, complete required access paperwork and maintain all staff documentation
• Produce Change Control Board Documentation as needed
• Calculate Earned Value Analysis for monitoring of project phases

• Comprehensive Workforce Development System (CWDS)

• Experience managing a large size custom project
• Outstanding communication and writing skills
• Strong ability to present information in client forums
• Strong meeting facilitation and interpersonal skills. Ability to engage participants in a work session and lead them to issue resolution
• Complete knowledge of the full System Development Lifecycle and other relevant technical and project management methodologies
• Analytical thinking in the review and understanding of business processes
• Event logistics planning and coordination
• Strong communication skills (both written and oral) including the ability to communicate with and understand the needs of both technical and non-technical staff
• Ability to develop and maintain effective working relationships with program area staff
• Effective time management and prioritization skills
• Flexibility, agility and change management skills
• Tolerance for ambiguity
• Ability to lead process improvement efforts

• PMP Certified
• Experience with CMMI Level 3 Processes
• ITIL Certified
• Microsoft Office Suite

• Assessment of Existing Business Processes (As-Is Assessment)
• Plan, coordinate and facilitate As-Is sessions with program staff in multiple business areas being supported
• Create process flows using Visio-like diagramming tools that enable dynamic rules management in the Rules Engine
• Create business process orchestration models with available web services using Visio-like diagramming tools
• Document business process flows and develop process diagrams. Capture process inputs, outputs, tools, roles, tasks, barriers, constraints, decisions and outcome measures
• Capture and document business area requirements across multiple business areas
• Analyze requirements of multiple business areas to determine appropriate features/logic for the application system
• Review policy and procedure documentation
• Develop BPR As-Is documentation
• Facilitate discussions to walk through processes, sub-processes and activities as documented in the BPR As-Is deliverable
• Review and validate existing business process documentation. Incorporate changes into As-Is documentation

• Determine Future State of Business Processes (To-Be Assessment and Requirements)
• Plan, coordinate and facilitate To-Be sessions with program analysts in multiple business areas being supported
• Provide recommendations on business priorities through the review of risks and costs associated with business area requests
• Identify areas for improvement in existing business processes. For multi-agency integrated systems (such as CWDS), Business Analyst will review the various business processes and engage subject matter experts to identify the most efficient integrated processes
• Play lead role in issue resolution to reach consensus on business area improvements
• Document To-Be business process established through consensus
• Plan and coordinate internal and external focus group sessions. Gather and interpret input on business processes to determine what works well and the areas for improvement.
• Develop survey tools to gather input on business processes, from internal and external customers. Analyze results and provide recommendations to Information Technology team
• Oversee the implementation of feedback from focus group sessions and survey analysis
• Develop BPR To-Be documentation. Review with program staff and incorporate feedback
• Document requirements and work with program staff to assign priorities for implementation

• Identify gaps between the As-Is Processes and To-Be states
• Develop BPR Gap Analysis documentation. Review with program staff and incorporate feedback
• Work with program staff to prioritize gaps which will determine how to proceed with improvement and changes
• Develop BPR Assessment documentation

• Translate business requirements into technical specifications for the application design and development. Document features in RequisitePro
• Write and maintain use cases in Rational RequisitePro
• Review and elaborate business and security rules in use cases
• Develop use case diagrams in Visual Studio.NET
• Create screen-mockups
• Plan and facilitate screen mock-up review sessions with program analysts and key program area staff
• Assist Application Developers in interpreting business needs and addressing the documented requirements
• Oversee compliance of system design to business needs

• Develop and document procedures for handling helpdesk requests. Identify categories to classify request complexity. Develop process flows for request escalation and resolution. Identify resolution roles and responsibilities
• Work with Helpdesk team to gather helpdesk requests from the business areas, for the support of CWDS and other LI-OIT-BBAD-WDD systems
• Document and categorize helpdesk requests. Determine complexity and level of effort needed to resolve request
• Categorize, document, assess and prioritize helpdesk requests
• Implement corrective temporary solutions to address basic requests
• Escalate requests to appropriate roles including the Application Developers
• Work with Application Developers to address helpdesk requests. Interpret business needs into actionable corrective actions for the Application Developers to complete
• Work with Application System Admin to define and document change control procedures/roles as well as oversee change control for change requests and enhancements
• Work with Application System Admin to plan, direct and coordinate with agencies in the integration of external applications

• Plan, organize, perform and coordinate aspects of system and user testing. Testing may include user acceptance testing, unit testing and component integration testing
• Develop test scripts for testing activities such as integration testing and user acceptance testing
• Participate in user acceptance testing. Execute test scripts
• Track testing results and document test findings
• Work with Application System Administrator to develop application builds and oversee migration to testing and production environments
• Perform regression testing and document findings
• Create the necessary system documentation needed for production migrations

• Assist in the development of Request for Proposals, Request for Quotes and other applicable procurement strategies
• Participate in fact-finding studies related to systems assessment and design modifications
• Participate in systems review sessions

• Work with clients to obtain feedback on system efficiency and usage as well as user needs and issues. Document findings and provide recommendations

• Design training curriculum for application systems
• Develop training materials using an authoring tool
• Capture the development and maintenance of online help
• Identify and assess training delivery methods. Identify appropriate delivery method for system training. Training may include formal and informal instructor-led classroom training, Web-based training, distance learning, webinar sessions and job aids
• Work with program area training coordinators to plan and manage training logistics including reservation of training venues, facilities management, development of training calendars/timelines
• Manage information relating to training sessions and participants in the Learning Management System (LMS)
• Coordinate training program delivery in the business areas. Provide consultative support to the business areas in training program delivery. This may include serving as a consultant to approved trainers
• Develop, deliver and interpret training evaluations
• Develop, review and update system documentation relating to system operations and maintenance

• Develop communication plan to address user information needs
• Identify appropriate communication channels
• Work with business areas to implement the communication plan across the identified communication channels
• Develop and implement outreach plans to increase awareness/ education of system roll-out and enhancements
• Assess effectiveness of outreach programs. Document findings and provide recommendations for increasing outreach effectiveness

• Develop project implementation plans and work plans. Oversee work plans and identify critical risks/issues
• Track action items, issues and risks in Rational ClearQuest

• Comprehensive Workforce Development System (CWDS)
• Other LI-OIT-BBAD-WDD systems

• Ability to create process flows using Visio-like diagramming tools that will enable dynamic rules management in the Rules Engine
• Ability to create business process orchestration models with available web services using Visio-like diagramming tools
• Technical Writing knowledge
• Strong meeting facilitation and interpersonal skills. Ability to engage participants in a work session and lead them to issue resolution
• Knowledge of the full System Development Lifecycle and other relevant technical and project management methodologies
• Knowledge of the functions and capabilities of a variety of industry standard application software including spreadsheets, databases, word processing, etc
• Analytical thinking in the review and understanding of business processes
• Event logistics planning and coordination
• Strong communication skills (both written and oral) including the ability to communicate with and understand the needs of both technical and non-technical staff
• Ability to develop and maintain effective working relationships with program area staff
• Effective time management and prioritization skills
• Flexibility, agility and change management skills
• Tolerance for ambiguity
• Ability to lead process improvement efforts

• Rational ClearQuest and RequisitePro
• UPK (User Productivity Kit) for web-based training material development
• IBM Learning Management System
• FileNet Content Management Tools
• Accessibility Testing tools (AccVerify, JAWS, Zoomtext and Dragon Naturally Speaking)
• Eligibility Rules in Rules Authoring tools
• ITIL Certified

• Maintain application design models in Unified Modeling Language (UML)
• Design, develop and maintain application software on multiple technical platforms using approved languages and tools
• Develop simple-to-complex application code for new or existing applications based on various architectures. Ensure conformity to Commonwealth’s coding standards, procedures and techniques. Coding activities include data modeling/analysis, schema design, etc
• Participate in requirements gathering sessions and work with Business Analysts and Database Staff to prepare accurate technical specifications and documentation for application design and development
• Develop code to integrate / interface existing systems with new systems. Code systems to facilitate data transfers between interfacing systems
• Develop class designs and participate in business component and user interface development
• Develop data access library
• Facilitate code review sessions
• Work with Application System Administrator in the analysis, design, development and implementation of application security requirements
• Participate in all phases of application development projects

• Develop code to resolve application performance issues highlighted from system test results

• Resolve data fixes and debugging requests from business areas
• Provide advisory support and guidance to the business areas on issues regarding system design, functionality and overall application use
• Identify and implement best practices in designing scalable web based solutions for applications with multiple online and interface transactions
• Work with the Business Analysts in the creation and revision of use case specifications, technical documentation and other descriptive documentation that may support software applications
• Work with Application System Administrators in managing batch operations

• Comprehensive Workforce Development System (CWDS)
• Other LI-OIT-BBAD-WDD systems

• Object Oriented Design principles, practices and Unified Modeling Language (UML)
• Knowledge of Commonwealth IT standards, policies and methodologies for application development
• Understand best practices of application development in line with Commonwealth development standards

• Experience in developing multi-tier web-based applications
• Ability to apply development tools/techniques to formulate end-user technology solutions

• Ability to translate technical language into terms easily understood by non-technical staff

• Ability to work well with others and complete tasks with minimal supervision
• Ability to work in a high-pressure environment
• Strong team player and interpersonal skills
• Excellent problem solving and structured thinking skills
• Experience using latest development methodologies, coding standards and design patterns
• Experience in working with cross-functional teams and mentoring skills
• Excellent analytical skills. Good communication skills

• Rational ClearQuest
• Rational Requisite Pro
• SQL Server 2008
• Crystal Enterprise application including Crystal Reports Developer
• Visual Studio.NET 2008
• Team Foundation Server

• RapidSpell.NET
• webMethods
• Offline Access Toolset
• Rules Engine Toolset
• Mercury LoadRunner
• Mercury QuickTestPro
• Business Objects

• ITIL Certified

• Participate in Business Process Review sessions to understand business processes, procedures and needs. Develop database solution that addresses business needs
• Establish data administration standards and procedures that pertain to data elements, data dictionary, data sharing, entity relationship diagram and quality assurance
• Develop and document procedures for defining, creating, revising and controlling Commonwealth databases
• Participate in intra/inter agency data exchange initiatives

• Perform custom database upgrades or generic installations. This includes configuring clustering, default collation, file locations, number of instances, and service accounts
• Create linked server
• Configure network libraries
• Troubleshoot failed installations

• Design centralized and distributed database structures consistent with Commonwealth applications and operations
• Develop reporting and data analysis architecture
• Develop and maintain logical & physical data models

• Develop database coding guidelines and templates, and implement database development best practices.
• Develop and ensure compliance with database development standards (naming standards, process standards etc.) during database development activities.
• Assist and guide development team with complex database procedures and functions.
• Develop automation processes to create routine non-logic database procedures such as database triggers and delete procedures.
• Provide efficient and effective database solutions to support batch and interface processing.
• Create and maintain the ErWin data model. Ensure the integrity of the data model with respect to changes deployed to the databases.
• Create and alter simple-to-complex databases. This includes adding filegroups, configuring filegroup usage, expanding and shrinking databases, setting database options and sizing/placing the transaction log

• Configure database options for performance. Configurations include includes capacity, network connectivity, physical drive configurations, and storage locations
• Attach and detach databases
• Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views
• Manage database objects in the development, test, and production environments
• Install and support database servers
• Develop and maintain data dictionary