Activity name: Collect data and develop analysis report of wildlife crime situation, period 2022-2023.
|
Service (to be performed): Software development on Microsoft Excel using the VBA programming language to develop an analysis tool that includes standardized and automated forms and templates for collecting wildlife crime cases to develop an analysis report.
|
Location of Service provided (tentatively): Ha Noi, Ho Chi Minh City and remotely
|
Duration of Service’s performance: Oct 2023 – March 2024
|
I. Background:
Since 2016, WCS started working with the Criminal Statistics Bureau (CSB or Department 2) of Supreme People’s Procuracy (SPP) on collecting data and developing reports on wildlife violations, crimes and law enforcement.
However, the data collection and statistical analysis processes have been manual, resulting in significant time and effort requirements. In order to address these challenges and streamline the workflow, we aim to develop an analysis tool that incorporates standardized and automated Microsoft Excel forms and templates. This tool will enable efficient data collection on wildlife crime cases nationwide and facilitate the generation of analysis reports in subsequent periods.
Therefore, we are seeking a consultant who can conduct research and propose the optimal solution for developing this tool.
II. Objectives:
The consultant will cooperate with WCS and its partner to carry out activities to achieve the following objectives:
- Survey the current status, collect requirements and propose software solution
- Software development on Microsoft Excel to develop, finalize and maintain a standardized and automated analysis tool, including Microsoft Excel forms and templates for data collection and statistics of criminal wildlife cases.
- To provide training sessions of the developed tool to the users from WCS and relevant partner agency
III. Description of work:
Activities
|
Outputs/ deliverables
|
Tentative timeline
|
Allotted time (# of days)
|
- Survey the current status, collect requirements and and propose software solutions to ensure the feasible structure of Microsoft Excel forms and templates, including attending meetings with the WCS focal person
|
Solutions agreed by WCS
|
Oct 20, 2023
|
Based on an agreement between the consultant and WCS.
|
- Software development on Microsoft Excel using VBA programming language to build Excel forms and templates (about 100 data fields) to automatically collect and synthesize information of wildlife cases such as incident date and location, involved people, evidence, etc.
Details of data fields and extract request will be discussed and agreed later with WCS.
|
Microsoft Excel forms and templates for data collection and statistics will be fully drafted and revised based on comments from WCS.
|
Oct 27, 2023
|
- Deliver two in-person training sessions and collect comments to improve forms and templates in training courses for users as tentative plan, including:
- Training course 1 in November 2-3, 2023, in Ha Noi (1 day, 50 pax)
- Training course 2 in November 16-17, 2023, in Ho Chi Minh City (1 day, 40 pax)
|
- Presentation and on-site training sessions in two courses are delivered to participants.
- Participants understand and use properly the provided tools.
- Microsoft Excel forms and templates for data collection and statistics will be improved after comments from training courses.
|
Nov 30, 2023
|
- Finalize forms and templates and 3-month maintenance service
|
- Support provided on request during the time forms and templates being in use, including fix issues (if any).
- Microsoft Excel forms and templates for data collection and statistics will be completed.
|
Mar 31, 2024
|
Total allotted time (total working days): Following agreement between the consultant and WCS. Consultant(s) is encouraged to discuss the TOR in details with WCS before submitting the financial proposal
IV. Requirements (selection criteria):
- Certification in Microsoft software development
- Minimum of 15 years of experience working in Information Technology, including system automation and software development on Microsoft Excel using the VBA programming language for both companies and NGOs.
- Experience in working with WCS on system automation and a demonstrated ability in analytics and problem-solving is an advantage.
V. Application procedure:
Interested candidates are invited to send
- Email of interest
- Updated CV with relevant working experience and products
- Financial proposal (total of working days and daily rate in VND including Personal Income tax)
to vietnamconsulting@wcs.org before 17:00 of 15/10/2023
Note: Only shortlisted candidate(s) will be contacted