RATN Database Development TOR

Regional Aids Training Network: Database Development

Introduction

The Regional AIDS Training Network (RATN) is an international non-profit organization with operations in Eastern & Southern Africa (ESA) region.

RATN is a consortium of training and capacity building institutions collaborating on a mission to strengthen the capacity of relevant individuals, organizations and other stakeholders to effectively respond to STIs/HIV/AIDS. Currently RATN has 30 institutions that are full members spread across 11 countries in ESA region.

The initiative for strengthening HIV and AIDS Training and Networking (INSTANT) programme is a new RATN initiative involving MIs submitting proposals on small innovative projects related to HIV training and capacity building as part on implementation of the RATN Strategic Plan (2009-2014).

The projects are aligned to the four RATN Strategic Plan programme areas namely: Training & Capacity Building, Knowledge & Information Management, Advocacy, Partnerships & networking and Research and Monitoring & Evaluation.

Since inception in September 2009, three rounds of application have been received.

RATN is now seeking a company/consultant to develop a web-based database system that will help manage these projects efficiently and effectively whilst at the same time act as a monitoring and evaluation system.

Terms of Reference for Development of Web-based Database Application for INSTANT Projects

Objectives

Design, develop, adequately test and ultimately actualize a web-based database application that will assist its users (RATN and MIs) to access, analyze, process, and convert data into useful information using various search, sort, filter, and rank queries.
Since it will have different users of the system with different privileges, this database is required to have multiple views depending upon the needs of users.
It should serve the basic needs such as data entry and report generation for all users at all levels
The database should have an installable off-line version that can be updated/ synchronized with the online version.
The database will also serve as a planning, monitoring, and evaluation system other than just being an information source
The database will have various views: Some information on the database will be displayed for public viewing on the website. This link gives an idea of what is expected.
The database should provide administrative logs tracking the various activities done from specific accounts. The public profile/display should also provide adequate statistics on views and hits.
User involvement throughout the project to ensure that it meets the needs of the users.

Key data elements (INSTANT Database)

RFP profile:

Name of MI, location, and contact information
Project name
Strategic objective (s) RFP is responding to (e.g. Kim, RM&E, training, etc)
RFP contact at MI
RFP contact at RATN

Project dates

Award date
Award amount
RFP start & end dates
Contract modification (s)

Deliverables

Expected deliverables
Actual deliverables

Reporting

Reports by months
Expected reporting date-programmatic
Actual reporting dates-programmatic
Expected report date-financial
Actual report date-Financial

Other

Support supervision: date, key issues raised
Documents generated by project: research, baseline reports, media articles etc
Stories of Change/best practice reports
Challenges

Qualitative data

Create fields for uploads of financial and programmatic reports narratives

Deliverables:

Deliverables for this project include:

Functional Specification Document
Technical specification document: (Preferred database software is Mysql as this should easily integrate with existing joomla website).
Work break down structure with deliverables details
Initial working prototype with complete features demo
A complete and successfully running web-based database application, free of any hick-ups and bugs
All data and reports generated during software development
User and administrative manuals
A report detailing all data and procedures described in this document and performed in each phase of application development.
Support for 6 months after completion and successful commissioning of the database.

Experience: The consultant/company will be expected to undertake a comprehensive user requirements analysis in order to ensure the system is responsive to user’s needs.

The consultant must also demonstrate proven past work experience of a similar nature.

How to Apply:

Eligible and interested consultants should send their applications including references on related previous work by email to vacancies@ratn.org.

The application should also be accompanied with a quotation for the work including expected costs and duration for the project.

Deadlines:

The closing date for receipt of applications is Monday 3rd October 2011 at noon.

Only successful applicants will be contacted and will then be expected to make presentations on how they would undertake the project.

These presentations must be made by 5th October 2011.

The selected company/consultant will be expected to embark on the project immediately

Arid Lands Information Network (ALIN) Computer Trainers Jobs

Arid Lands Information Network (ALIN), an International NGO facilitating information and knowledge exchange between /informediaries/ in the arid lands of Kenya, Uganda and Tanzania wishes to recruit a to recruit a dynamic, energetic and committed individuals ICT trainers.

The trainings will be conducted through ALIN's Maarifa (Knowledge) centres spread in the Kenya, Uganda and Tanzania. The trainers will undergo an initial induction and will be conduct free computers and Internet training to members of the public at Maarifa centres are located in the following areas

Kenya: Isinya in Kajiado, Nguruman in Magadi, Ng'arua in Nyahururu, Marigat in Baringo, Kyuso in Mwingi, Mutomo in Kitui, Ndhiwa in Homa Bay

Uganda: Koro and Awach in Gulu

Tanzania: Shinyanga and Kayanga in Karagwe

Desired Qualification, skills and experience

A Degree or Diploma in related field.
Relevant Computer training from a recognised institution (ICDL desirable).
Excellent knowledge of MS Office, Explorer
Demonstrated skills and experience in delivering a training package.
Mature, responsible and a person of high integrity
Prepared to travel stay in at the Maarifa centre for a period of not less than 3 months
Knowledge of a local languages where Maarifa is located
Able to work under minimal supervision

Closing date: 28 th September 2011

Interested candidates should forward their applications including a motivation letter stating their expected remuneration, curriculum vitae and telephone contacts or email and addresses of 3 referees by 28th September 2011:

E-mail your applications to:

The Selection Panel,
ALIN,
E-mail: trainers@alin.net

Bank of Kigali Head of Retail Product Development and Head of Retail Credit Risk Management Jobs in Rwanda

Bank of Kigali is the leading bank in Rwanda with a market share of 31% of total banking assets The Bank also account for over 50% of the banking sector profit performance.

It is the only credit rated company in Rwanda and has been awarded the Bank of the Year award by the Financial Times two years running in 2009 and 2010.

“Bank of Kigali aspires to be the best and most innovative provider of financial solutions in the region.”

‘We endeavour to provide the best financial services and solutions to our business and retail customers in order to create value for our stakeholders.

We invest in our employees and provide them with meaningful rewards that encourage them to make significant contributions to the company and the community’

The Bank aims to be the leader position in human capital and skills development in the financial services and employer of choice in Rwanda.

To this end the Bank is seeking self motivated persons to further these objectives.

Head of Retail Product Development

Job Description

Reporting to Deputy CEO/COO, develop and design new retail banking lending and deposit products and re‐design and re‐launch the current retail product lineup

The Bank is investing in the expansion of branch network and electronic channels, and plans to establish an agent network to be capable of serving 500,000 retail clients in 2‐3 years; the generic, payroll‐specific, prepaid card, and other current accounts and bundles should meet the expectations of the market/relevant segments and scale easily; payroll debit card overdrafts, utility bill pay and remittances are to be made easily accessible for activation and use through ATMs & online, as well as branches;
Specific Responsibilities

Update regularly the term deposit product lineup and launch a savings account as part of the current account bundles;
Payment, e‐wallet and/or m‐wallet solutions to be launched in accordance with the evolving requirements of the market;
The Bank’s current lending lineup of payroll, general‐purpose cash consumer loans, mortgage loans etc is to be augmented by launching revolving credit cards, instant/POS consumer loans and other scorecard‐based lending products;
Responsible for establishing product sales targets and business objectives for each product and channel and for the development of the text‐based and video product guides and training manuals for the front‐office staff and video tutorials for clients and call centre sales scripts;
Conduct monthly channel visits and monitoring to ensure “best practice” is consistently delivered network‐wide;
Work closely with the channel management to develop challenging but realistic sales targets across all products and channels;
Responsible for the competitive benchmarking of each core product from a market‐share, pricing and feature/usability standpoint;
Build and manage a team of professional product development managers to develop products and services to increase bank's retail market share/profitability in each identified product group, in close co‐operation with IT, retail credit risk and channel management;
Assist the front office sales/channel management in designing cross‐selling campaigns for specific client segments and monitor and drive the penetration rate of key products.

Desired Profile

5‐10 years relevant experience acquired in a dynamic retail banking environment
IT literacy and ability to liaise effectively with the developers
Good communication and leadership skills
Integrity, open minded and goal focus

Head of Retail Credit Risk Management

Job Description

Build and manage a team of retail credit risk analysts
Design, modify, communicate and explain lending credit policies which would anticipate/reflect market conditions (thus ensuring improvement in the portfolio quality and maximising profitability)
Develop a generic scorecard and other required decision‐making tools to scale mass‐market retail lending
Continually develop management information and portfolio segmentation MIS to clearly identify the risk drivers so that these are controlled and aligned to forecasted portfolio performance. Work closely with Product Managers to provide value added risk feedback to assist the business in achieving sustainable & profitable growth for all products
Provide feedback on risk matters concerning new products, changes to existing products (through the CAD process) and participate in the key business management/strategic decisions
Where required make appropriate and timely corrective actions on lending policies and provide active suggestions on soft and hard collection strategies

Desired Profile

5‐10 years relevant experience acquired in a dynamic retail banking environment
Excellent numerical and analytical skills are required to understand the underlying credit risks at both customer and product portfolio level
Familiarity with consumer banking credit management, credit tools and best‐practice policies / procedures is essential
Knowledge of all key functions of retail credit operations with in‐depth knowledge on general‐purpose consumer loans, instant/POS consumer loans, credit cards and payroll‐backed products
A working knowledge of credit scoring and management of scorecards to ensure continued validity and acceptable performance is essential
Solution oriented and able to persuade and influence colleagues and superiors of the validity of solutions proposed based on rational argument, supporting data and appropriate previous experience
Rational, pragmatic, disciplined and methodical
IT literacy and ability to liaise effectively with the developers
Good analytical and interpersonal communication skills
Focus and attention to detail

How to apply If you fit the above job specification, please submit your application letter, current CV together with a filled Personal Record Form (PRF Form) which can be downloaded from BK website using the link (http://www.bk.rw/index.php?option=com_content&view=article&id=80&Itemid=79) not later than 26th September 2011 to: Head of Human Resources & Administration, Bank of Kigali, P.O.Box 175 Kigali, Rwanda E-mail: fnsinga@bk.rw; phabyarimana@bk.rw

Oxfam Information Technology Officer and Plant Electrician Jobs in Dadaab Kenya

Oxfam’s Kenya Programme is a complex programme that incorporates both rapid and slow onset emergencies as well as longer term development and policy work.

Oxfam Kenya applies a one programme approach which means it has multiple activities that support a holistic approach to humanitarian, development and advocacy for long lasting change in poverty reduction.

Oxfam in Kenya works in the north, principally in Turkana, Dadaab and Wajir, the Nairobi informal settlements and on national level advocacy and coordination issues in multi stakeholder fora.

Oxfam has launched its largest ever appeal in Africa in response to the massive food crisis facing more than 12 million people across Ethiopia, Somalia and Kenya.

In Kenya, Oxfam aims to help 1.3 million people with clean water, cash initiatives and veterinary support people’s livestock.

To this end, we are seeking to fill the following positions:

Information Technology Officer

Location: Dadaab

Contract: Fixed Term contract upto March 2012

The IT Officer will be required to support the email system and ensure its reliability in the Dadaab office, ensure effective data management in the server including disaster recovery that ensures data is backed up and restoration tested regularly to ensure business continuity as well as provide support to programmes in implementing and maintaining applications that assist them in their day to day work.

The post-holder will manage the deployment of crucial systems upgrade, configure hardware and setup according to the set global standards, organise and conduct formal Induction to all new staff, as well as ensure user compliance to internal policies and procedures and report to Regional Information & Systems Manager in case of violations.

The incumbent of this position will contribute to budgeting and forecasting in relation to IT equipment, provide first level support to hardware/software maintenance & upgrades in the Dadaab office as well as act as the support person during system upgrades or rollouts by independently carrying out IS systems upgrades in the Dadaab offices.

To be successful in this role you will have a graduate in Computer Science or Information systems and professional training on computers, with knowledge on Local Area Networks, servers (basic hardware and software), possess high level of competence in development and implementation of computerised systems and be technically competent in area of specialisation and/or experience in IT workflows.

You will be required to have good written and verbal communication skills in English, possess the ability to take initiative in problem solving and learn/follow Oxfam policies and (technical) procedures to do the job.

In-depth experience in similar role is mandatory.

Plant Electrician

Location: Dadaab

Contract: Fixed Term contract upto March 2012

The Plant electrician will be expected to service and maintain gensets and pumps by monitoring all the electrical installations in the generator rooms and making recommendations of their replacements or repairs.

S/he will be expected to retrieve, repair and install boreholes submersible pumps, monitoring yield trends and behaviour of boreholes and suggest relevant remedial measures where necessary as well as repair and maintain standby control panels, change over switches and other
electrical equipments in the workshop.

The postholder will be expected to prepare weekly and monthly unit reports on jobs and conditions of all the relevant systems, do technical designs of the power grid for the Oxfam compounds in Dadaab and also assist in supervision of the contractors doing upgrade or installations of the power grids in Oxfam compounds.

To be successful in this role you will have a suitable qualification (Plant electrician grade one/diploma plant option) coupled with in-depth experience in plant workshop and in relevant field work.

You will be expected to be proficient in MS Office software and in possession of excellent communication skills in English and Swahili languages (both written and spoken).

You should be willing and ready to work for long and odd hours and have the ability to work with minimal supervision.

To apply

If you believe you fit the profile, please submit your application and CV detailing your experience for the post and including daytime telephone contact and two referees, preferably your current line managers to kenyajobs@oxfam.org.uk 0R drop your application at Oxfam Dadaab main office not later than 3rd October 2011.

We are committed to ensuring diversity and gender equality within our organization

Oxfam Business Support Manager Job in Nairobi Kenya

Business Support Manager

Location: Nairobi, Kenya

Level: Global C1

Contract: Open ended

Salary: £23,090 - £29,954 net per annum plus other benefits

The Kenya Programme, with an annual turnover of around £25 million is a complex programme that incorporates both rapid and slow onset emergencies as well as longer term development and policy work.

Oxfam Kenya applies a one programme approach which means it works on a multitude of activities that support a holistic approach to humanitarian, development and advocacy such that long lasting change happens whilst fulfilling Oxfam’s humanitarian mandate.

Oxfam in Kenya works in the north, principally in Turkana, Dadaab and Wajir, the Nairobi informal settlements and on national level advocacy and coordination issues in multi stakeholder fora.

Oxfam has launched its largest ever appeal in Africa in response to the massive food crisis facing more than 12 million people across Ethiopia, Somalia and Kenya. In Kenya, Oxfam aims to help 1.3 million people with clean water, cash initiatives and veterinary support people’s livestock.

To this end, we are seeking to fill the following positions:

To strengthen and lead the support function in the programme work Oxfam GB is looking for a highly innovative and motivated individual to work as a Business Support Manager based in Nairobi.

You will provide overall management advisory role on all aspects of programme support, including managing and contributing to the work of HR, Finance, Logistics & Administration and Fundraising teams.

You will be responsible for overseeing the functioning of the Kenya programme office to ensure that office systems run in an efficient and co-ordinated manner.

Working with the Regional Centre IT team you will maintain an overview of information technology and communications requirements and manage their implementation accordingly.

In close collaboration with the finance team you will be expected to ensure accurate and timely input into the production of financial reports to donors as well as effective tracking and reporting on multiple donor funded programmes, ensuring that the programme is cost effective, efficient and complies with all organisational standards of management and accountability.

You will identify and design appropriate training for staff and partners in the areas of logistics & administration, finances, human resources and fundraising. You will be part of the senior management team.

Previous work experience of programme service management (human resources, finance, capital assets, information management and logistics) in emergency and/or development context in an international setting is essential.

You will be required to be an assertive communicator, proven decision- maker and be in possession of excellent people management skills as well as the ability to work innovatively with minimal supervision.

You’ll have well-developed interpersonal and cross-cultural skills and demonstrable ability to be flexible in demanding situations. An excellent oral and written communications skill in English is essential.

If you believe that you fit the job and the person profile please send your application to kenyajobs@oxfam.org.uk or apply online at www.oxfam.org.uk/jobs using REF INT4886.

The closing date for applications is 7th October 2011

Futures Group Data Warehouse Senior Technical Manager Job in Kenya

Position: Data Warehouse Senior Technical Manager

Reports To: Chief of Party

Project Description:

Established in 1971, Futures Group develops and delivers innovative, locally relevant, evidence - based solutions to improve the health and well- being of people around the world.

We have assisted governmental and non-governmental agencies, foundations, and the private sector by designing, implementing and evaluating programs in HIV, sexual and reproductive health, population and family planning, maternal and child health, infectious diseases, and gender.

Futures Group has deep expertise in policy and advocacy, research and strategic information, health markets and private sector engagement, modeling and economic analysis, patient monitoring and management/HMIS, strategic consulting, and program management.

Futures Group provides HMIS support to the Government of Kenya (GoK) and the Centers for Disease Control and Prevention (CDC).

Under a new contract, the Futures team provides a range of technical assistance including: support for the continued development and implementation of the national HMIS strategy; improving information flow to guide policy and program decisions; facilitating interoperability between disparate HMIS including specific efforts to harmonize and integrate laboratory, pharmacy, and electronic medical records (EMR) sub-systems; and developing a data warehouse.

Position Summary:

The Data Warehouse Senior Technical Manager will advise and provide technical expertise to the Chief of Party, and the broader project team.

This individual will lead the project’s strategy for and implementation of the data warehouse, define the business and information requirements, resolve high-level business and information issues, coach both the HMIS/NASCOP and Futures Group team in the development of the data warehousing solution, provide continuity in all major data warehousing solution decisions, and determine how technology can be applied to meet the client’s needs.

The work requires innovation, often with very little guidance. There is an organizational reliance on the knowledge, initiative and experience of the Data Warehouse Senior Technical Manager. Work is very technical in nature and knowledge is specialized.

Minimum Qualifications, Skills and Knowledge:

Demonstrated technical expertise in design, development, deployment and maintaining large data warehouse (DW) or very large databases
Deep technical understanding of data warehouse model and design methodologies, ETL, Data Marts, OLAP, OLTP,Metadata, normalization, 3NF, Dimensions, SCD Slowly Changing Dimensions,
Experience in requirements gathering for DW, creating Use Cases, UML , Enterprise Architect, ER Diagrams, Data Dictionary, Test Cases,
Demonstrated technical experience integrating different data sources (e.g health, finances, vital statistics, education, planning) from different databases (MySQL, SQL Server, Oracle) while addressing issue of data quality;
Strong operational experience in improving in database performance, optimization, data aggregation, SQL queries for coding for interactive dashboards, charts and reports
A minimum of 5 - 7 years’ proven technical experience is required
Desired Datawarehouse business intelligence (BI) experience, software tools (Business Objects, Cognos, Microstrategy) or any open source BI software tools (Pentaho, JasperSoft, SpagoBI, icCube)
Strong understanding of public health information systems in Kenya, including EMRs.
Oral and written communication skills, Good writing skills are required to develop and articulate data warehouse strategy and implementation plan and present ideas to various audiences
A university degree in computer science or information technology or any related discipline is required as a minimum, post graduate qualification and /or relevant certification courses will be an added advantage

Essential Functions:

Design , develop, test, deploy, maintain, large, robust data warehouse at MOH
Lead technical responsibility for development of national health data warehouse and identified data sources
Lead in design, modeling, architecture of robust data warehouse platform;
Lead technical responsibility to integrate data from different data sources (health, finances, vital statistics, education) into data warehouse solution
Lead the information gathering and documentation process in consultation with the Ministries of Health
Lead in development of data warehousing standards and SOPs , and test cases
Resolve performance, database issues associated with maintaining and enhancing large data warehouse

Additional Information

Equipment to be used: General office equipment; Computers

Physical demands: N/A

Must be available for domestic and international travel for up to 30% of the time.

All applications for this position should be submitted online at www.futuresgroup.com via the Careers page before September 27, 2011.

Futures Group provides equal employment to all participants and employees without regard to race, color, religion, gender, age, disability, sexual orientation, veteran or marital status.

KCB Head, I.T. Projects & Quality Assurance Job Vacancy

Head, I.T. Projects & Quality Assurance

Job Ref I.T. 09/2011

The Position

Reporting to Director IT, the position is responsible for Project Management, Applications Development and Quality Assurance in the service delivery within I.T. in order to meet the business objectives.

Key Responsibilities

* Set and enforce adherence to Project Management standards in all I.T. implementation activities.
* Set and enforce adherence to Application development standards in all I.T. system development initiatives.
* Set and enforce change and quality assurance standards in IT systems
* Accountable for development of the core banking system and all the interfaces to the system
* Identifying and coordinating core banking system upgrades
* Ensure all projects are properly scoped, documented and implemented within scope
* Coordinating with internal and external stakeholders to ensure projects are delivered on schedule
* Establish and maintain procedures for project management, applications development and quality assurance in line with industry best practice
* Assessment of risks within the areas of responsibility and ensuring that risks are mitigated and that applications are developed and deployed in line with risk management policies of the bank
* Monitor and ensure that applications development and system changes are properly tested in line with best practice before changes are made to the T24 operating environment.
* Planning and prioritizing IT projects and application development activities for the bank
* Managing both internal and external application developers to ensure timely delivery of solutions
* Carry out resource planning and mapping for all implementation activities to be carried out.
* Reporting and communicating on all project related issues to key stakeholders

The Person

* A Bachelor’s degree in ICT or related field from a recognized university is required. An MBA will be an added advantage
* Must possess at least one of IT certifications. Possession of T24 certification will be an added advantage
* Project management training and skills is a mandatory requirement.t.
* A minimum of 5 years’ experience in 3 of which must be in IT Senior Management with hands on experience in:

1. Managing enterprise wide large IT core banking project implementations
2. Designing system architectures
3. Leading application development teams
4. Change management and quality assurance

* Working experience with Oracle, Unix and Microsoft systems
* Leadership experience with large cross functional project teams
* Knowledge of and experience with programming languages and platforms – visual basic, .NET, Java etc
* Should have excellent understanding of processes particularly the Systems Development Life Cycle
* Knowledge and application of the bank products, services and policies
* Thorough understanding of other essential supporting banking systems such as clearing, various channels and interfaces etc.

The above position is a demanding role which the bank will provide a competitive package for the successful candidate.

If you believe you can clearly demonstrate your abilities to meet the criteria given above, please submit your application with a detailed CV, stating your current position, remuneration level, e-mail address and telephone contacts quoting the job title/reference in the subject field to recruitment@kcb.co.ke.

To be considered your application must be received by 20th September 2011.

Only short listed candidates will be contacted.