Strengthening Integrity and accountability program 1 (SIAP 1)
Terms of Reference
Position : Web Database Developer
Starting Date : July 2013
Duration of Contract : 22 working days
Background and Objectives
Our beneficiary has An Reporting Information System to process and analyze reports once it is submitted by mail and manually entered to the system by staffs. SIAP 1 will assist one of Indonesia government institution in increasing the compliance. To do this effectively, there is a need to improve procedures for monitoring submitted reports and also developing infrastructures. SIAP 1 will also assist in developing an online interface for public servants to submit their report. This online interface could be accessed through browsers and/or Android/iOS devices.
Activities
A. Database Analysis
1. Gather and analyze current database design and structures. (3 days)
Web developer will analyze the database design document and structure of Sistem Informasi Gratifikasi.
B. Database modification 1. Modification of current database diagram and structures. (5 days)
Web developer will modify the database according to needs based on the existing regulation
2. Develop a simple Decision Support System on the report. (7 days)
Web developer will create a simple DSS on the report based on some raw data.
3. Participates in the testing process; through test, review and analysis of application. (2 days)
Conduct User Acceptance Test (UAT) based on the new business process.
4. Revise the web database application based on test, review and analysis. (5 days)
Revise and finalize the database based on UAT.
Requirements
Terms of Reference
Position : Web Database Developer
Starting Date : July 2013
Duration of Contract : 22 working days
Background and Objectives
Our beneficiary has An Reporting Information System to process and analyze reports once it is submitted by mail and manually entered to the system by staffs. SIAP 1 will assist one of Indonesia government institution in increasing the compliance. To do this effectively, there is a need to improve procedures for monitoring submitted reports and also developing infrastructures. SIAP 1 will also assist in developing an online interface for public servants to submit their report. This online interface could be accessed through browsers and/or Android/iOS devices.
Activities
A. Database Analysis
1. Gather and analyze current database design and structures. (3 days)
Web developer will analyze the database design document and structure of Sistem Informasi Gratifikasi.
B. Database modification 1. Modification of current database diagram and structures. (5 days)
Web developer will modify the database according to needs based on the existing regulation
2. Develop a simple Decision Support System on the report. (7 days)
Web developer will create a simple DSS on the report based on some raw data.
3. Participates in the testing process; through test, review and analysis of application. (2 days)
Conduct User Acceptance Test (UAT) based on the new business process.
4. Revise the web database application based on test, review and analysis. (5 days)
Revise and finalize the database based on UAT.
Requirements
- Have a minimum of 2 (two) years experience in designing database and application process, preferably for a government agency;
- Have a minimum of 2 (two) years past experience in developing a web database application, preferably for a government agency;
- Have past experience and knowledge regarding:
- Database and application design process
- Web programming especially PHP, JAVASCRIPT / AJAX and HTML
- RDBMS especially PostgreSQL
- Have an experience in testing the software.
- Have an experience in writing user manual and system documentation. This user manual will be accessible in the system where users can access them easily.
- Have an experience in user training.
- Have a satisfactory record of Past Performance; and
- Be able to provide the Services within the time period.
Deliverables
- Report/Documentation on modification of database and system design process,
- Web database application on the reporting,
- A simple Decision Support System.
Application should include a cover letter, CV (including three references) and contact number by July 1, 2013, at the latest. Please put the position you apply for as the subject of your email. This is a local position; only Indonesian nationals will be considered.
Please send applications to zkrishnamoorthy@msi-inc.com.
Please send applications to zkrishnamoorthy@msi-inc.com.
Only shortlisted candidates will be contacted.
