Activity name: Upgrade financial and logistics tools
|
Service (to be performed): Management System upgradation and automation
|
Location of Service provided: Hanoi
|
Duration of Service’s performance: 4 months
|
WCS’s person in charge (PIC): Hong Anh
|
I. Background:
In 2020, WCS has automated some of its forms and templates relating to finance, procurement and human resources using VbA in order to reducing errors, increase accuracy and productivity in its transaction processing.
After almost two years of implementation, realizing that those tools can be further improved by continuing the automation, using a more advanced programming language and/or integrating difference works in different stages, WCS is now in need of a consultant to provide solutions and advices and implementation of integration and advance automation.
II. Objectives:
- 1. Review current WCS VbA forms and templates, discuss and propose on possible improvement to minimize errors causing by new user. In co-operation with finance team, discuss and find solutions and propose improvement and further automation/integration for current forms and new forms.
- 2. Using C# programming language or equivalent for piloting PAR and propose a plan for moving from VbA to the new programming language.
- 3. Automating logistics tools for training/workshop.
III. Description of work:
Activities
|
Outputs/ deliverables
|
Completed by
|
- Discuss with Finance Team, understand the expectation and review forms/templates/reports
|
Submission of ideas and solutions
|
15/4/22
|
- Work on improvement of current VbA forms and templates of WCS: Bank transfer, Salary allocation, core-cost allocation, PAR
- Create VbA for Cash request form, Budget narrative and PIT reconciliation form.
- Using C# programming language or equivalent for piloting PAR and propose a plan for moving from VbA to the new programming language.
- Automating logistics tools for training/workshop: Check-in/Check –out, calculation of allowance for participants, participant list, number of rooms used, Payment solutions or non-cash payment…
|
- Bank transfer, Salary allocation, core-cost allocation, PAR forms are improved with errors minimized
- VbA form of Cash Request Form, Budget Narrative and PIT reconciliation are completed
- C# (or equivalent language) applied to PAR
- Automated logistics tools
|
15/5/22
|
- Maintenance and training
|
Promptly fix errors when it occur and train the Finance team on basic principles to fix errors |
15/8/22
|
|
IV. Requirements (selection criteria):
- University degree in Information and Technology or related fields.
- Certification in VBA excel or equivalent.
- Solid and practical knowledge and experience in VBA/Excel macro/Excel
- At least 5-year working experience in IT. Experience in doing similar works for INGOs or companies is an advantage.
- Have strong analytics and problem solving capabilities
- Organizational and time management skills and ability to meet deadlines.
- Understand WCS’s system, Forms & templates
- Basic English is required.
V. Application procedure:
Interested candidate(s) are invited to send
- Email of interest
- Updated CV with relevant working experience and products
- Financial proposal (total of working days and daily rate/person including Personal Income tax) to vietnamconsulting@wcs.org before 17:00 of 17/04/22
Note: Only shortlisted candidate(s) will be contacted