Blog

 Position 1- Data analytics (Advanced Excel and SPSS) training for public health supply chain stakeholders in Nigeria

Position 2– Contract management training for public health supply chain stakeholders in Nigeria

Note: Firm  can bid for any of the position or as well bid for both position, However, provide separate breakdown of technical staff as well as financial proposal

1. Data analytics (Advanced Excel and SPSS) training for public health supply chain stakeholders in Nigeria

Background

Nigeria is a top-priority country within the Global Fund (TGF) portfolio. It faces an extreme disease burden across all three diseases, with trailing health outcomes. The country has the world’s greatest malaria burden and has the second largest burden of both HIV and TB in Africa. The country is classified as a high MDR-TB burden country.

The current HIV, Malaria and TB grants (2021-2023) seeks to build on the results achieved through previous grants while contributing directly to the attainment of the National HIV, TB and Malaria Strategic Plan goals and objectives by expanding access to prevention, treatment, care, and support interventions for both general and key populations. The National Supply Chain Strategy provides an overarching framework to guide investments to improve access to essential medicines and medical supplies to support the health programs.

Performance management and data analysis are key components of monitoring and evaluation and enables organizations track program implementation, routinely monitor expected changes over time and to evaluate the overall performance of the programmes.  The establishment of the National Health Logistics Management System has improved end to end visibility of the public health commodities. Additionally, data from the NHLMIS is used for planning and programming in the Supply Chain Programme. The effective management and monitoring of Key Performance Indicators in the NHLMIS database, as well as triangulation of service data from the DHIS, is a critical gap that is needed by the NPSCMP data management, IT and M&E unit to effectively manage and analyze huge volumes of data contained in these databases. In order to translate data usage to improved Supply Chain Outcomes in-country, it is necessary to improve the skills required for effective data management.

As such building skills in data analysis using statistical software like STATA and SPSS is essential to analyze data and draw inferences from the derived data. Therefore, the Global Fund is seeking to engage a service provider to design and deliver a structured and tailored Data analytics (Advance Excel and SPSS) training for selected public health supply chain personnel (NPSCMP, program and states).

1. Objectives

The service providers will work under the directives of the National Coordinator, through the relevant technical leads in NPSCMP to:

• Conduct capacity assessment to determine data analytics/Excel capacities.

• Design a tailored data analysis (Advanced Excel and SPSS) training curricular/manual for public health supply chain stakeholders

• Coordinate and deliver Data analysis (Advance Excel and SPSS) training sessions for public health supply chain stakeholders
• Coordinate a 4-week post-training support for NPSCMP and health program participants to apply concepts from the training sessions.

2. Deliverables

The expected deliverables include:

• Report on capacity assessment detailing capacity gaps and training needs
• Data analysis (Advance Excel and SPSS) training curriculum/manual
• Training report
• Participatory certificate

3. Timeline: given the urgency to rapidly implement the planned RSSH grant activities to realize benefits during the current implementation period, we expect the selected Service Provider to begin workplan implementation by May 2023 for a period of 30-40 working days. This support is deliverable-based and a contract payment plan that will be agreed with Global Fund, NACA and NPSCMP at the start of implementation. The exact start and end dates of workplan implementation may vary slightly.

4. Requirements

The selected Service Provider will be required to ensure the availability of a team of  IT specialists or an IT training firm with the following qualifications and experience:

• At least a bachelor’s degree in information management, research management, data analytics or related field from a recognized university (desirable). A relevant Masters degree together with at least 10 years’ experience in information management (alternative)
• Relevant IT certifications such as Oracle certification, Microsoft certification or similar software development certification
• At least ten (10) years’ experience conducting similar trainings in Advanced excel, SPSS and other data analytics packages.
• Experience working with the Global Fund, major donors, Principal recipients and/or other partners (USG, USAID, World Bank, BMGF etc.) of diverse backgrounds.
• Good operational experience handling data, conducting advanced analytics using diverse applications, including MS Excel.
• Ability to communicate effectively in a cross-cultural environment both oral and written in English.

The selected Service Provider will also be required to provide administrative support with the following qualification and experience:

• Bachelor’s degree in a relevant field
• Three years of post-qualification experienc

5. Technical Direction

The selected Service Provider will work under the overall guidance of the NACA and NPSCMP, with remote support from The Global Fund Supply Chain Team and the Nigeria Country Team.

6. Scope of training

Services to be provided

1. Draft a work plan for the above training engagement for approval by management of NPSCMP
2. Support the development of a training curricular/manual on contract management, financial management and accountability, supply chain transport & network design, data analytics.
3. Share the training curricular/manual with NPSCMP and harness their input
4. Support the conduct of 5-day national level training on contract management, supply chain transport & network design, data analytics Submit technical report of the exercise to NPSCMP
5. Submit the training curricular/manual to NPSCMP

1. Contract management training for public health supply chain stakeholders in Nigeria

TERMS OF REFERENCE

1. Summary

Nigeria is a top-priority country within the Global Fund (TGF) portfolio. It faces an extreme disease burden across all three diseases, with trailing health outcomes. The country has the world’s greatest malaria burden and the second-largest burden of HIV and TB in Africa. The country is classified as a high MDR-TB burden country.

The current HIV, Malaria, and TB grants (2021-2023) seek to build on the results achieved through previous grants while contributing directly to the attainment of the National HIV, TB, and Malaria Strategic Plan goals and objectives by expanding access to prevention, treatment, care, and support interventions for both general and key populations. The National Supply Chain Strategy provides an overarching framework to guide investments to improve access to essential medicines and medical supplies to support health programs.

NPSCMP is currently building up her technical capabilities for new roles as the change driver for the strategic plan and the integrated management of public health products and essential medicines. In a bid to increase government ownership and performance management of all supply chain functions, there is a need for NPSCMP to empower the states to engage Third-Party logistics providers for supply chain functions, particularly the last mile distribution. The country is strengthening state infrastructure and systems to take an active and sustainable model for the supply chain management. Therefore, the Global Fund is seeking to engage a service provider to design and deliver structured and tailored contract management training for selected public health supply chain personnel (NPSCMP, program, and states).

7. Objectives

The service providers will work under the directives of the National Coordinator, through the relevant technical leads in NPSCMP to:

• Conduct a needs assessment to identify knowledge gaps in contract management.

• Design a tailored contract management training curricular/manual addressing identified gaps for public health supply chain stakeholders

• Coordinate and deliver training sessions for public health supply chain stakeholders for 5 days
• Coordinate a 4-weeks post-training support for NPSCMP participants to apply concepts from the training session.

8. Deliverables

The expected deliverables include:

• A capacity assessment report detailing gaps and training needs on capacity assessment
• Contract management training curriculum/manual
• Training report
• Participatory certificate

9. Timeline: Given the urgency to rapidly implement the planned RSSH grant activities to realize benefits during the current implementation period, we expect the selected Service Provider to begin workplan implementation by June 2023 for a period of 30-40 working days. This support is deliverable-based and a contract payment plan that will be agreed upon with the Global Fund, NACA, and NPSCMP at the start of implementation. The exact start and end dates of work plan implementation may vary slightly.

10. Requirements

The selected Service Provider will be required to ensure the availability of a team of supply chain specialists with the following qualifications and experience:

• At least a bachelor’s degree in supply chain management, public health, or a related field from a recognized university (desirable).
• Supply chain certifications (CIPS, APICS, CSCP, or similar) are desirable.
• At least ten (10) years post-qualification experience working in a supply chain of which five (5) years must have been in a senior management position with thorough understanding of health systems and public health issues in the Nigerian context. Legal background or experience will be a bonus.
• Experience working with the Global Fund, major donors, Principal recipients and/or other partners (USG, USAID, World Bank, BMGF, etc.) of diverse backgrounds.
• Experience designing and implementing health products supply chain interventions
• Good operational experience handling end-to-end supply chain processes for health commodities (from customs clearing procedures to use at service delivery points).
• Strong understanding of health supply chain systems and key health supply chain stakeholders in Nigeria.
• At least 5 years of experience working on nationwide health supply chain strengthening efforts, including projects supported by development partners is essential.
• The prospective service provider must, in addition, be very conversant with the National Supply Chain Strategy and Implementation plan 2021 – 2025
• Ability to communicate effectively in a cross-cultural environment both orally and written in English.

The selected Service Provider will also be required to provide administrative support with the following qualification and experience:

• Bachelor’s degree in a relevant field

Three years of post-qualification experience

1. General Eligibility Criteria for Both Position
2. Evidence of company registration (certificate of incorporation of the company) including Forms CAC2 and CAC7;
3. Evidence of Company’s Income Tax Clearance Certificate for the last three (3) years (2019, 2020 & 2021) valid till 31^st December 2022;

• Copy of Company Audited Accounts for the last 3 years (2019, 2020 & 2021);

1. Evidence of PENCOM Compliance Certificate expiring by December 2022;
2. Evidence of ITF Compliance Certificate expiring by December 2022;
3. Evidence of NSITF Compliance certificate expiring by December 2022;

• Sworn Affidavit disclosing whether or not any officer of the relevant committees of the National Agency for the Control of Aids or the Bureau of Public Procurement is a former or present Director, shareholder or has any pecuniary interest in the bidder and to confirm that all information presented in its bid are true and correct in all particulars;
• The minimum validity period of the Tender should be One Hundred and Twenty (120) Days;

1. Evidence of financial capability to execute the contract by submission of Reference Letter from a reputable commercial bank in Nigeria, indicating willingness to provide credit facility for the execution of the project when needed;
2. Company’s Profile;
3. At least 10 years’ experience ‘supporting public health programs in the area of procurement and supply chain system

• evidence of at least three (3) similar jobs executed in the last five (5) years by showing copy of either Letters of Awards, or Job Completion Certificates or Contract Agreement.
• All documents for submission must be transmitted with a Covering/Forwarding letter under the Company Letter Head Paper using the Tender Submission Sheet template in Form G-1 and bearing amongst others, the Registration Number (CAC), Contact Address, Telephone Number (Preferable GSM No.), and e-mail address, duly signed by the authorized officer of the firm. An unsigned bid will be disqualified.

2. COLLECTION OF TENDER DOCUMENTS

The Standard Bidding Document (SBD) can be downloaded from this link;

https://naca.gov.ng/wp-content/uploads/2023/05/RFP-NPSCM-TRAINING-cONSULTANT-FIRM-Clean-copy.pdf

3. DEADLINE FOR SUBMISSION

The deadline for the submission of Tender should not be later than 12 noon of  19^th  June, 2023. Clarification can be obtained at the Office of the Head of Procurement, Ground Floor, NACA main building, 3 Ziguinchor Street. Wuse Zone 4. Abuja

4. GENERAL INFORMATION

1. Bids must be in English Language and signed by an official authorized by the bidder;
2. Bids submitted after the deadline for submission would be rejected;
3. NACA reserves the right to evaluate and award per line item and in the event of exigency, NACA may vary the quantities/quality of the items during the time of evaluation, award and execution of contract with respect to this invitation to tender;

1. NACA is not bound to shortlist any Consultant, and reserves the right to annul the bidding process at any time without incurring any liabilities or providing reason.

12.0   ADDRESS FOR INFORMATION AND SUBMISSION OF PROPOSALS

Attention:

Head Procurement

National Agency for the Control of AIDS (NACA) 

Ground Floor Room 1.08

No. 3 Zinguinchor Street, Beside AEDC Office, Wuse zone 4, Abuja

Email: [email protected]

Tel: +234-9-4613726-9 Fax: +234 94613700

13.0  GLOBAL FUND CODE OF CONDUCT

You shall get acquainted with the global fund code of conduct for suppliers using this link below: https://www.theglobalfund.org/media/3275/corporate_codeofconductforsuppliers_policy_en.pdf

Accepting this invitation shall serve as an acknowledgement and agreement to abide by the Global Fund Code of Conduct for Suppliers.

14. Notes/Disclaimer
15. Late submissions will not be accepted.
16. NACA shall verify any or all documents and claims made by applicants and will disqualify consultants with falsified documents and claims.

iii. If it is determined that submitted documents and claims have been falsified, the consultant may face prosecution in a court of Law.

1. NACA shall not be held responsible for any disqualified proposal as a result of any omission or deletion relating to the submission guidelines.

iii.  This advertisement shall not be construe a contract to any Consultant, nor shall it entitle any Consultant submitting documents to claim any indemnity from NACA.

1. NACA is not bound to shortlist any Consultant, and reserves the right to annul the bidding process at any time without incurring any liabilities or providing reason.

Signed

Management.