I have an excellent background in data warehousing and business intelligence. I am attracted by data-related job profiles such as data manager or data analyst.
The Global Fund
to july 2012
- Designed OBIEE architecture and datamarts for multiple projects hosting
- Setup automated tests server
- Aligned with temporary Oracle BI Applications hosted on same server
- Managed deployment process
- The overall BI project was started in May 2010 with the objective of meeting the rapidly increasing needs of the business for accurate, consistent and timely information to help make informed decisions. The mandate for BI stream is to build an Enterprise Data Warehouse and to provide pre-defined and self-service reporting capabilities. This project is being implemented in phased approach. The ultimate goal being that all the 600 employees eventually gain access to data through consolidated reports.
The first business team who could benefit from the BI initiative works on Price Quality Reporting. The integration of the data reported by the countries on their spending (medicine, bed nets, etc.) allows identifying inappropriate prices and helping countries to improve their money management.
- Country Programs project:
This phase is targeting the Country Programs area, delivering the core modules of the global BI project as well as a first set of pre-defined reports and the self-service reporting environment in different areas (Finance, Grant management, Procurement…).
- Strategic Information project:
The Global Fund applies the principles of performance-based funding. In order to promote accountability and transparency, and to provide incentives for recipients to use funds efficiently and effectively, the Global Fund links continued funding to the achievement of clear and measurable results. Performance-based funding provides a framework for grants to demonstrate that they can convert financing into results, enabling further funds to be committed to those programs which achieve results. The Performance Framework integration into the BI platform enables analysts to cross key programmatic indicators (number of bednets distributed, number of lives saved...) with other important data areas like expenditures and budget data.
- Periodic review:
Periodic reviews are an in-depth evaluation of programmatic performance, of the impact achieved and of efficient and correct use of funds, which will determine funding levels for the subsequent commitment period of Grants. Therefore, Reviews uses numerous reports in different areas (Financial, Epidemiological statistics...) in order to take subsequents decisions.
- Round 11:
The Global Fund needed to extend its existing BI platform in order to support the Round 11 call for proposals for new grants. Transactional and analytical reports lie at the heart of the system and support the submission, screening and processing of each proposal. Applicants must demonstrate their eligibility for new grants by using historical data based on their previous and current grants as well as other key information such as epidemiological and country statistics. 23 reports and a self-service environment will be delivered as part of the project.
The Global Fund To Fight AIDS, Tuberculosis and Malaria is an international financing institution that invests the world’s money to save lives. Until the beginning of 2011, it has committed US$ 21.7 billion in 150 countries to support large-scale prevention, treatment and care programs against the three diseases..