|
Activity name: Microsoft Excel software programming service using Excel VBA programming language - Automate form revisions for human resources (HR) and finance templates and tools.
|
|
Service (to be performed): Microsoft Excel software programming service using Excel VBA programming language - Automate form revisions for human resources and finance templates and tools.
|
|
Location of Service provided: Online/ Offline (if needed)
|
|
Duration of Service’s performance: from date of contract signing to June 30, 2026 for main services, and to September 30, 2026 for post service maintenance.
|
|
WCS’s person in charge (PIC): Dinh Thu Trang
|
I. Background:
After several years of using automated forms and templates, WCS VN is undertaking a revision of its HR and finance automated forms to better meet the organizational needs and ensure compatibility with the Microsoft SharePoint platform.
Therefore, WCS VN are looking for a company or consultant(s) to research and implement the optimal solution to revise and update our current automated HR and finance forms.
II. Objectives:
Automate form revisions for human resources (HR) and finance templates and tools.
III. Description of work:
|
Activities
|
Outputs/ deliverables
|
Completed by
|
Allotted time (# of days)
|
|
1. Online meetings to fully understand requirements (detailed walkthrough with video recording and explainations)
|
|
May 31, 2026
|
|
|
2. HR automated forms and templates
2.1. Automated new employment agreement: English vs Vietnamese and tracking file
2.2. Automated employment agreement modification and tracking file
2.3. Personnel general information sheet – repeated, English vs Vietnamese (2 excel tabs)
2.4. Automated volunteer agreement and tracking file
|
Solutions agreed by WCS
|
June 30, 2026
|
|
|
3. Finance automated forms and templates
3.1. Revise SAP_FB allocation file to meet WCS VN booking requirements (1 day)
3.2. Revise BEAR form to: i) automate GL accounts, ii) lock columns with fixed formulas while iii) is able to insert rows (3 days)
3.3. Creat an Excel form that can link expense reports to supporting documents and automatically generate vouchers to upload to SAP (1 day)
3.4. Automate data from SAP extract to BEAR (1 day)
3.5. Automate data from Consolidate data in GIM to Program Work Plan (1 day)
3.6. Automate office costs allocation from program BEARs to Admin BEAR (1 day)
3.7. Revise Program Finance Report extract file to remain necessary formulas and format (1 day)
3.8. Update narratives in automated budget proposal template (1 day)
3.9. Upgrade GIM template to run on Microsoft SharePoint (1 day)
|
Solutions agreed by WCS
|
June 30, 2026
|
|
|
4. 3-month post service completion maintenance
|
Support provided on request
|
Sep 30, 2026
|
|
Total allotted time (total working days): Determined based on the service provider’s proposal and approved by WCS.
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 and MS Sharepoint
- At least 5-year working experience in IT. Experience in doing similar works for INGOs or companies is an advantage
- Familiar with WCS automation VBA system. Understand WCS’s system, Forms & templates
- Have strong analytics and problem solving capabilities
- Organizational and time management skills and ability to meet deadlines.
- Basic English is required.
V. Application procedure:
Interested candidate(s) are invited to send
- Technical and financial proposal;
- Company’s business licence and profile;
- CV of the lead technician(s).
to vnprocurement@wcs.org before 17:00 of 21 May 2026
Note: Only shortlisted candidate(s) will be contacted