RQ08784 - Solutions Designer - CRM - Senior

Project Background Information

Ontario is driving a stronger economy through its recent investments into skilled trades and apprenticeship programs to support job seekers and attract students to lucrative careers in trades. Along with Ontarios investments into healthcare manufacturing and construction sectors this will result in a stronger demand for labour relations services. Many of these new careers are represented by unions and employers involved in collective bargaining.

The Labour Relations Solution Division (LRSD) in MLITSD plays a critical role in fostering supporting and maintaining a harmonious constructive and productive labour relations climate in Ontario by providing neutral thirdparty assistance (i.e. conciliation mediation and appointment of arbitrators) to employers and unions throughout all public and private sectors in Ontario. It also provides the infrastructure to support the legal processes and administration of collective bargaining for public and private businesses in addition to providing neutral data analytics and evidence to support businesses in estimating their collective bargaining costing. Its key services offer pathways (and in some cases the only one) for businesses to legally seek Dispute Resolution Services (DRS) e.g. the resolution of grievances when there are perceived contraventions of collective agreements; and legislatively proceed with work disruptions (i.e. strikes lockouts) via noboard reports.

Under section 122.1 4 of the Labour Relations Act (LRA) the Minister has delegated authority to the Director of DRS in LRSD corresponding to the request application notification report or filing of service requests. To support LRSD in facilitating and processing collective bargaining services LRSD uses an existing existing legacy labour relations case management system. However this system is over a decade old and no longer sustainable. Its unable to keep up with client expectations and there is a high probability that its functionality will cause longterm and permanent damage to service delivery. This would result in potential impacts to LRSDs ability to facilitate collective bargaining deals due to an inability to process requests quickly or keep up with increased demand harm MLITSDs credibility and mandate to settle workplace disputes and meet objectives under the LRA and impact workers collectively bargained working conditions. These impacts echo into public and private sector impacts that have significant repercussions e.g. work disruptions in the education and municipal sectors in addition to key ministries such as TBS who rely almost entirely on MLITSD for its collective bargaining and arbitration datasets to conduct their analysis costing and collective bargaining on behalf of the Ontario Public Sector. Increased strikes or lockouts can also affect employers through loss of production and customers; employees families and workers through reduced or loss of income and students through decreased accessed to learning tools.

Responsibilities/Assignment Deliverables:

The Consultant is required to work with clients and various stakeholders to address the ongoing M&S tasks considering business implications and requirements for enhancing the functionality of LR Gateway (LRG) application. The consultant will be responsible for providing daytoday guidance to other team members handson support services related to the development management of projectrelated documentation and plans as well as facilitation of project tasks. Other responsibilities will include undertaking detailed analyses to identify key business issues as well as coordinating and executing the delivery of specific project activities.

Perform day to day development activities on the Salesforce platform.

Support the creation of customizations and integrations required to the LRG application in production.

Configure the Salesforce application based on the business requirements.

Apply best practices and experience to build Salesforce applications.

Perform Root Cause Analysis (RCA) and provide resolution to production issues and incidents; debug issues identified during phase 2.

Work closely with other developers in the vendor team business analyst QA analyst and project managers.

Research Salesforce capabilities as needed to suit business requirements and provide gap analysis.

Contribute to the preparation of business cases initiating and recommending next generation Salesforce solutions based on technology service gap analyses risk and business value to OMSB and customer base. Identify consult with and advise OMSB on solution technologies to facilitate business practices and promote the costeffective application of solutions that satisfy client requirements.

Create actionable technical documentation based on gathered business requirements.

Assist with scoping and planning of various CRM related projects and initiatives.

Perform routine administration functions for Salesforce.

Create documentation including training documentation and release notes.

Participate in crossfunctional teams that address strategic business issues.

Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that any technical glitch can be quickly addressed.

Support Quality Assurance (QA) and User Acceptance testing teams to code test and debug extensions/tools integration services

Participate in code reviews sessions (scheduled and unplanned releases)

Work with the testing teams to aid in preparation of the Test Plan for Unit and Integration testing.

Prepare fully documented operational procedures for system and production system support staff as required.

Provide problem resolution support to database staff system and user acceptance test teams and other staff members.

Coordinate system development production support activities and technical consultative support to other staff members.

Provide knowledge transfer to ministry staff at all stages of this assignment.

Resolve defects as required and help prepare implementation plan.

Skill Set:

Salesforce Delivery Lead and Implementation experience

Agile experience leading and coordinating a development team as a technical expert.

Development experience on the Salesforce platform; specifically with Public Sector Foundation Experience

Certified Salesforce Developer

Experience integrating Salesforce with other applications.

Strong communication skills

Excellent interpersonal skills including:

o Group facilitation/team management

o Relationship management and effective collaboration

o Stakeholder partnership

o Knowledge transfer to the Client

Experience with business methodologies and tools including:

o Business analysis

o Performance measurement

o Logic models

Experience working in programs consisting of multiple highly interdependent projects.

Experience in the development of feasibility studies; business case development and cost benefit analysis.

Excellent analytical problemsolving and decisionmaking skills; verbal and written communication skills; interpersonal and negotiation skills.

Knowledge of and experienced with the following computing environments:

o Database: Oracle

o CRM: Salesforce Public Sector

o Business Intelligence: MSPower BI ETL

o Operating Platforms: Unix (Solaris AIX Azure Cloud)

o Web/Application Servers: WebLogic Microsoft IIS

o Configuration/Builds: DevOps Ant. Etc.

o Other technologies such as UML Modeling tools Eclipse Junit and Log4J

Proven Experience with all stages of automated system implementation in large complex highvolume systems in Cloud environments with online Mainframe Transactions

Demonstrable knowledge and experience in working in accordance with policies and procedures of Ontario Public Service.

A team player with the ability to work with competing priorities and strict deadlines.

Proven ability to perform to successful completion assignments of high magnitude and complexity.

Knowledge of the bargaining process in the Labour Relations Act (e.g conciliation interest arbitration and grievance arbitration)

Experience in developing Salesforce LWCs following ODS (Ontario Design System)

Experience in developing Salesforce LWCs following accessibility standards (AODA)

Experience in building bilingual apps

Experience in integrating Salesforce with SharePoint Security APIs and SendGrid.

Salesforce Application Architect certification

Salesforce System Architect certification

Expert knowledge and building with Apex code custom Lightning Web Components (LWCs) Flows system configurations

Expert knowledge of Salesforce Object Query Language (SOQL)

Troubleshooting advising leading and debugging to support business team with bug resolution

Knowledgeable of source code control

Expert with DevOPS GIT Visual Studio

SkillsExperience and Skill Set Requirements

Evaluation:

Technical Skills

• 10 years of full cycle software development including requirements design development optimization testing implementation and support.
• 10 years of development configuration and testing experience on the Salesforce platform; Salesforce Development with Salesforce Public Sector foundation Service Cloud /Sales/ Azure Cloud knowledge.
• Heavy understanding of Object Model features and functionality of Salesforce configurations.
• Knowledge on Process Builder Workflow rules Approval process Assignment rules and Profiles and Roles in Salesforce.
• Certified Salesforce Developer.
• Maintaining Salesforce deployment and best practices.
• Experience in Agile Methodology DevOPS/Confluence).
• Experience integrating Salesforce with other largescale applications.
• Participation in each phase of Ull Salesforce Lifecycle implementations and creating web interfaces for largescale websites.
• Experienced in defining systems strategy and requirements designing and prototyping planning testing and supporting training efforts.
• Experience with Responsive frameworks.
• Experience defining product strategy and roadmap and translating into actionable delivery team activities using Salesforce.

45

Analytical & Problem Solving Skills

• Conduct research and assessment of options for technical design issues
• Contributing to design/development project plans including work breakdown
• Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs.
• Working with technical systems specifications and translating them into working tested applications for large complex mission critical applications
• Work with Quality Assurance (QA) to code test and debug extensions/tools integration services
• Analysis design and development work on complex multitier webbased applications microservices architecture mobile and offtheshelf solutions
• Proven technical leadership skills with ability to identify areas for improvement and recommend solutions.
• Designing developing and implementing applications that work across modern browsers and various platforms and mobile devices.
• Conducting technical analysis program code detailed programming reports and specifications program design writing and/or generating code and conducting tests
• Conducting technical evaluation and assessment of options for technical design issues application figuration aspects and integration capabilities related tools and utilities gap analysis of integration components to technical requirements/specifications/documentation
• Experience with Software Development Lifecycle (SDLC)

30

Business Analysis Skills

• Experience with gathering business requirements
• Experience translating business requirements into project delivery timelines and estimates.
• Experience in programming and analysis at the specified experience level
• Experience in structured methodologies for the development design implementation and maintenance of applications

15

Communication Consultation & Negotiation Skills

• Ability to build good working relationships.
• A team player with a proven track record for meeting strict deadlines
• Good verbal and written communication skills.
• Good analytical and problemsolving skills.

Excellent ability to present to a technical and nontechnical audience.

• Experience with effective stakeholder management through facilitation of workshops communication negotiation & consensus building
• Experience with demonstrating developed features and gaining user acceptance.
• Experience with advising on business analysis policies processes best practices and standards.

Excellent communication skills

10

Must haves:

• 10 years of full cycle software development including requirements design development optimization testing implementation and support.