Two IT National Consultants to Develop an e-Learning Course on the Policy against Harassment and Sexual Harassment of the Albanian State Police

Contract

This is a Other contract. More about Other contracts.

Background

UN Women, grounded in the vision of equality enshrined in the Charter of the United Nations, works for the elimination of discrimination against women and girls; the empowerment of women; and the achievement of equality between women and men as partners and beneficiaries of development, human rights, humanitarian action and peace and security. Placing women's rights at the centre of all its efforts, UN Women leads and coordinates United Nations system efforts to ensure that commitments on gender equality and gender mainstreaming translate into action throughout the world. It provides strong and coherent leadership in support of Member States' priorities and efforts, building effective partnerships with civil society and other relevant actors.

In Albania, UN Women provides technical assistance to national partners (governmental and non-governmental institutions) on the implementation of existing international and national commitments to women's rights and gender equality. Currently, a UN Joint Programme “Ending Violence against Women” (UNJP on EVAW) funded by Government of Sweden is being implemented by UNDP, UN Women and UNFPA in partnership with Albanian Government. The Joint Programme is in line with Output 2.5 of the UN’s Programme of Cooperation for Sustainable Development (PoCSD) with the Government of Albania (GoA) and aims at: (i) strengthening the normative and accountability framework related to gender-based violence; (ii) improving institutional practices, services and coordination for survivors of violence; and (iii) challenging norms pertaining to violence against women at the state, community and individual levels. These results aim at bringing institutional and behavioral change in preventing and responding to gender-based violence, thereby contributing to freeing women and girls from all forms of violence and from the threat of such violence.

An important component of the programme is addressing various forms of violence within the public administration, including in Police forces. To this aim, UN Women supported the Albanian State Police to revise its Policy against Harassment, including Sexual Harassment (the Policy) and increase its staff capacities to identify, prevent, investigate and take disciplinary measures against harassment and sexual harassment in State Police.

Furthermore, the ASP is planning to establish an e-Learning training course on this topic, which will be mandatory for all new and existing members of the Police force.

In this context, UN Women is planning to recruit two IT National Consultants who will support the ASP to develop an e-Learning course on the prevention and elimination of harassment in the workplace among the Police forces.

Duties and Responsibilities

Under the overall supervision of the UN Women Project Manager on EVAW, and in collaboration with the ASP and the consultant who will be responsible for developing the content of the online course, the IT consultants will collaboratively work on the below processes:

1. Assessment of the current website structure and infrastructure of the Albanian State Police for enabling the online course hosting, operation and maintenance, as well as a workplan in order to track the overall ongoing development process
2. Development of the first draft proposal and structure of the online training course based on the assessment of the current infrastructure of the ASP and the content to be provided by UN Women, according to and based on the infrastructure, brand identity and visual guidelines of the ASP and UN Women. The consultants shall develop the course based on the requirements specified below.
3. Development of the full online training course for the ASP. The consultants, based on the feedback of the ASP and UN Women, will develop the final online course and proceed with the final adjustments, and deliver the final design, layout and functionalities.
4. Installation and configuration of the course on the ASP infrastructure. The E-learning course will be tested and accepted by the ASP, in compliance with their functionalities. The consultants shall deliver and install the course in the ASP system and website, together with the source code. The consultants will ensure necessary final adjustments, including to ensure that the system does not have glitches and solve any possible problems during the testing and use of the E-learning course.
5. Development of user’s manual in Albanian language and deliver training on its use to assigned ASP staff. The consultants will provide the ASP and UN Women access to the online course, who will be in charge of administering the online course and process the user data.

The consultants are expected to perform the following tasks:

Consultant 1: Developer Expert

• Write the code based on the UML (Unified Modeling Language) with the purpose of visually representing a system along with its main actors, roles, actions, artifacts or classes, in order to better understand, alter, maintain, or document information about the system. Developer should use Comments and Naming Conventions rules to make the code understandable for other developers.

• Develop User Interface using HTML, JS, CSS, and their improved versions like Angular or React. The user interface should support different browsers.

• Design queries that prevents SQL injection attack. SQL injection is one of the most commonly used hacking techniques.
• Build a Rational Database which include schemas, tables, views procedures etc., which should be configured for maximal performance and data integrity, meaning that components should have primary keys, external keys and necessary constraints
• Create search indexes that improve the speed of data retrieval operations on a database table
• Normalize the database to reduce data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies

Note: Developer should use the latest versions of any technology : He/She should separate different layers of the system in at least: Frontend and Backend. These layers should use Dependency Injection for managing resources. In addition, the developer should use Query optimization techniques as attempts to determine the most efficient way to execute a given query by considering the possible query plans*, as well as* configure the database for the most efficient use of resources to help boost the system’s efficiency and overall performance

Consultant 2: DevOps Expert

• Apply the rules in the system architecture of The Albanian State Police Datacenter which is configured to use replication for each database
• Configure automatic backups of the database to prevent data lost or to check the information in a specific time, as well as disaster recovery to restore the database in the event of a fire, earthquake, vandalism, or other catastrophic events
• Install Linux based Operating systems in the host machines
• Install the application server and configure it for production Environment, create and configure as many virtual hosts as needed for the system
• Install the SSL certificate, which will be provided by ASP IT Team, in the application server
• Create a Docker Hub in which the application docker images will be pushed and install Kubernetes to manage Docker Containers
• Configure at least One Master Node and Two Working nodes of the Kubernetes Cluster in order to offer zero downtime of the system
• Install a GIT repository for managing and storing source code branches and versions
• Install Jenkins in developer computer and the system hosts to ensure data communication, delivery and deployments, and configure Jenkins CI/CD Pipeline for automatization of the processes like Git Commit, Push Image, Testing Unit, deployments etc.

Online course properties

• The E-learning course will be developed in the Albanian language primarily with some references in online or hardcopy resource materials available in the English language.
• The online course must be created in the Content and Learning Management System (LMS & CMS). The course must be compatible with the existing infrastructure of the ASP institution, meet all modern technology standards and be easy to administer.
• The course can but does not have to be an exclusively open source solution. The requirement is that the system does not require any additional or subsequent maintenance or purchase fees.
• The complete course shall be installed and integrated into the institution’s server space and integrated into the institution’s web page.
• Configuration of all components of the platform (user types, UI, database, content, etc.).
• The consultants must set-up the system with three initial user profiles (i. administrator - who can modify the content of the whole system, manage users and eLearning content; ii. managers - who manage eLearning content and user accounts, iii. Users -who register on the platform to undergo the training programme).
• All courseware packages developed shall be uploaded into the infrastructure of the ASP and ready for launch and use. The consultants shall provide detailed documented instructions of the course in the area of the administration, utilisation and management of the online courses in the form of a manual for using the system.
• The consultants shall hand over to the ASP and UN Women all content created about the course and materials created, including all media files (video, audio, pictures and text) as well as the source code(s) used for developing the online course.

• During the installation of the course in the hosting servers of the ASP, the consultants will support the respective IT staff in installing, adjusting and connecting the course with the institution existing platform and web site.

  When designing the course, special attention should be paid to meeting the following features and requirements:

• Have high performance, high availability, flexibility, and scalability.

• The course must be based (but not limited) to HTML/ CSS/ JavaScript/ Java programming architectures and must be compatible with the existing infrastructure of the beneficiary institutions.
• Provide multiple levels of access to content and administration, time content definition, central media content (audio, video, photos, documents).
• Be based on the most recent release of open source existing platforms.
• Role-wise credential system incorporation for user management. System should support user sign up and sign in.
• The platforms will be accessed by at least 1,000 users.
• Include info security plan for the courses.
• Ability to encrypt user IDs and passwords and impose minimum password lengths along with ability to reset passwords following a standard password strategy.
• Robust multimedia content management system with support of video, audio, pdf, word, ppt etc.
• Dynamic content management system with support of contents upload, searching features. The course shall not allow the users to download or copy the content.
• Cross browser compatible, responsive, graphically attractive and full responsive to mobile devices, tablets, and different size screens.
• Tested at module integration and load level.
• Need to use Open Source Development Platform. Technology and all related design/data will be open to the institutions.
• Include videos for some of the content to illustrate situation as part of the lecture and single, multiple-choice quizzes also text submission answer choices.
• Include report section in each user to show progress calculation, having in account the answered questions and seen lectures.
• The systems should include search or filtering option.
• Leverages cloud computing and service-oriented architecture
• Explanation material in Word and PDF format about “eLearning course Quick Start Guide” will explain the structure, description manuals of the course workflow.
• The platform should enable track users’ progress with the course reading and include features for the administrator and managers to generate reports on the number of users who took the course, disaggregated by sex and rank and those who successfully passed it.

• Upon successfully completion of the course the system should issue a certificate of completion of the course

  Site Design and Graphic Preparation

• The electronic structure of the course must be avant-garde and resist changes. Its internal structure shall not need to be updated or modified with changing technology.

• The design of the course should be in line with the institution guidelines and identity. Multimedia must consider the topic and end users.

  System security and performance

• Database Normalization

• Query Optimization

• Encryption of sensitive data in Database

• Database/Application Log Management

• Database Replication and Disaster Recovery configuration

• Use of SSL certificate

• Load Balancer configuration

• Application Server clusterization

• IP restrictions to access the system

Duration of the Work

The consultants will be contracted for a maximum of 30 days each, over a period of December 2020 through 31 January 2021

Deliverables

• Report on the assessment of the current website structure and infrastructure of the Albanian State Police and the workplan. – to be completed within 14th December 2020
• First draft proposal and structure of the online training course- to be completed within 23rd December 2020
• Development of the full online training course for the ASP- to be completed within 15th January 2021
• Installation and configuration of the course on the ASP infrastructure, followed by the testing and accepted by the ASP, in compliance with their functionalities – to be completed within 29th January 2021

Competencies

Core Values:

• Respect for Diversity

• Integrity

• Professionalism

Core Competencies:

• Creative Problem Solving

• Effective Communication

• Inclusive Collaboration

• Stakeholder Engagement

• Leading by Example

Please visit this link for more information on UN Women’s Core Values and Competencies: https://www.unwomen.org/-/media/headquarters/attachments/sections/about%20us/employment/un-women-values-and-competencies-framework-en.pdf?la=en&vs=637

Functional Competencies

• Excellent knowledge of PC/LAN operating systems, Microsoft Windows, corporate ICT security and virus protection systems;
• Excellent PC hardware troubleshooting skills;
• Excellent knowledge of Enterprise Resource Planning Software, SharePoint services and MOSS;
• Excellent knowledge of database packages;
• Excellent knowledge of video conferencing and telecommunication;
• Ability to review a variety of data, identify and adjust discrepancies;
• Ability to provide input to business processes re-engineering, elaboration and implementation of new systems;
• Ability to provide advice and guidance

Required Skills and Experience

Qualifications/Education

• University degree in Information Technology, Computer Sciences or related fields; Master’s degree in the above fields would be preferred

Work Experience

• Minimum 5 (five) years of experience in developing web-based applications and software;

• Experience with HTML, JavaScript and CSS technology;

• Records of mainstream programming technology stacks (JAVA, Angular, C#, ASP, NET.).

• Experience with Docker, Kubernetes and CI/CD technology;

Schedule of Payments:

Payment will be made as per the payment schedule in the contract upon (i) satisfactory completion of tasks; (ii) provision of deliverables specified in the ToRs; (iii) certification of payment.

Recommended Presentation of Offer:

Qualified and interested candidates are asked to submit their application no later than 7th December 2020.

The application should contain:

• Cover letter explaining the applicant’s interest in applying for the position.

• Filled Personal History Form (P11 form) including past experience in similar assignments and contact details of referees (blank form can be downloaded from: http://www.unwomen.org/about-us/employment/) ; please upload the P11 instead of your CV

• Financial Proposal - Financial proposal specifying the total lumpsum with breakdown of daily fee and other expenses in Albanian Lek. Please note that the financial proposal is all-inclusive and shall consider various expenses incurred by the consultant/contractor during the contract period (e.g. fee and any other relevant expenses related to the performance of services

Evaluation of applicants:

Candidates will be evaluated using a cumulative analysis method taking into consideration the combination of the applicants’ qualifications and financial proposal. Contract will be awarded to the individual consultant whose offer has been evaluated and determined as:

Responsive/compliant/acceptable; and

Having received the highest score out of below defined technical and financial criteria.

Applications will be assessed according to the following Technical Criteria:

• University degree in Information Technology, Computer Sciences or related fields; Master’s degree in the above fields would be preferred

(10 points)

• Minimum 5 (five) years of experience in developing web-based applications and software; (20 points)

Professional knowledge of HTML, JavaScript and CSS technology; (15 points)

• Excellent knowledge of mainstream programming technology stacks (JAVA, Angular, C#,

ASP,NET.). (15 points)

• Professional knowledge of Docker, Kubernetes and CI/CD technology; (10 points)

Only candidates obtaining a minimum of 70% (49 points) in the technical evaluation would be considered for financial evaluation.

The maximum number of points assigned to the financial proposal is allocated to the lowest price proposal. All other price proposals receive points in inverse proportion. The calculation formula applied is as follow:

p = 30 (µ/z); where: p = points for the financial proposal being evaluated; µ = price of the lowest priced proposal; z = price of the proposal being evaluated.

How to Submit the Application: To submit your application online, please follow the steps below:

• Download and complete the UN Women Personal History Form (P11)- http://www.unwomen.org/en/about-us/employment
• Merge your UN Women Personal History Form (P11), the Financial Proposal, and Cover Letter into a single file. The system does not allow for more than one attachment to be uploaded;
• Click on the Job Title (job vacancy announcement);
• Click 'Apply Now' button, fill in necessary information on the first page, and then click 'Submit Application;'
• Upload your application/single file as indicated above with the merged documents (underlined above);
• You will receive an automatic response to your email confirming receipt of your application by the system.

Notes:

• UN Women retains the right to contact references directly. Due to the large numbers of applications we receive, we are able to inform only the successful candidates about the outcome or status of the selection process.

• The consultancy post is open to local (Albanian) individuals or foreign individuals with valid temporary or permanent residence in Albania.

• Applications without the financial offer will be treated as incomplete and will not be considered for further assessment.

• The individual consultants should take the mandatory learning security course prior to commencement of assignment– details will follow before the issuance of contract.

**UN Women is committed to achieving workforce diversity in terms of gender, nationality and culture. Individuals from minority groups, indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the strictest confidence.

UN Women does not tolerate sexual exploitation and abuse, any kind of harassment, including sexual harassment, and discrimination. All selected candidates will, therefore, undergo rigorous reference and background checks.**

Apply now

Added 3 years ago - Updated 3 years ago - Source: jobs.undp.org