Business Intelligence & Data Warehouse Strategy Services for UNICEF

Request for proposal for UNICEF Business Intelligence (BI) & Data Warehouse (DW) strategy Services

Background: The SAP based ERP application was first launched in 1999 for UNICEF Head Quarter(HQ) locations. It was subsequently re-engineered, expanded and then launched worldwide branded as VISION in January 2012.  VISION, an IPSAS compliant ERP system is based on SAP R/3 ECC 6.0 ERP system on HP UNIX Operating System with Oracle as underlying database.  It includes core business areas with related business processes namely planning, budgeting, grants management, finance, human resources and supply (procurement & logistics). VISION is complemented by inSight, a UNICEF corporate Business Intelligence(BI) and Performance Management System.  inSight is based on an enterprise data warehouse system henceforth called UNICEF Data Warehouse (UDW), Microsoft BI tools and SharePoint.  UDW is an in-house custom data warehouse solution on HP UNIX Operating System with Oracle as underlying database.  VISION is a critical source of information for UDW.  Data in UDW is populated via SAP Business Warehouse(BW) extracts housed in Oracle database and directly from VISION via flat files. UDW also houses non-SAP data from other applications. The inSight platform serves as a single portal for all UNICEF BI reporting, dashboards and Key Performance Indicators(KPIs). The inSight platform is a data source for enterprise web services and hosts custom bespoke applications to serve UNICEF Country Offices.  Further, the inSight platform is a critical data source for UNICEF Transparency portal which has a high visibility across the organization and to external audiences.UNICEF ERP and performance management ecosystem is managed by UNICEF and hosted in two locations. The live production systems are hosted in a commercial data center and the development & test systems in UNICEF data center.   In the event of service interruptions in the commercial data center, UNICEF data center assumes primary role to support business continuity.

Problem Statement: UNICEF has recorded a steady 40% data growth annually and an increasing demand for innovative strategic solutions since the global roll out of VISION and insight in 2012.  Despite continuous efforts to optimize extracts, data loads and queries, there is steady increase in load times, decrease in overall performance & user experience and challenges in data timeliness. The performance management reports and dashboard content served for analysis are at least a day old. This is exacerbated by aged infrastructure that was initially provisioned in 2011 which now has reached its maximum potential.  Any attempt to expand further will be expensive and unsustainable as the infrastructure and its maintenance life cycle will reach end of life 2017-2018 timeframe. There is a critical need to re-think UNICEF BI-DW strategy and to build a long term sustainable platform that can enable self-service portals, improve performance, mitigate issues of data timeliness, improve user experience and enhance the organisations ability to effectively use data to support make decisions.

Scope: Provision of a study to determine the next generation BI-DW platform (inSight-UDW) for UNICEF. The scope of the engagement includes: (i) understand and review current BI-UDW in UNICEF. (ii) gather information from stakeholders on their current and future data, reporting needs. (iii) identify options per industry best practices for a long term strategic platform that can meet stakeholder needs within various UNICEF and partner operating contexts. Among the options, the study should take into consideration current system & data architecture, UNICEF VISION platform modernization to SAP HANA, potential to use SAP HANA based data warehouse and the targeted future for UNICEF Data Centres. In addition, it is suggested that SAP future evolution, their roadmap and impact to UNICEF are also considered. (iv)         comparisons for each option along with pros and cons from various dimensions. The analysis should consider, hardware, software solution(s), data architectures & models, user experience, mobility and interfaces to internal/external data systems. (v) Feasibility and cost-benefit analysis for migrating UNICEF inSight-UDW hosted on Microsoft-Oracle to a new generation BI-DW Platform.  Note that UNICEF in short term will be moving from Oracle/HP Unix platform to Oracle/SUSE Linux platform. (vi) strategy for future BI-DW in UNICEF for an enterprise reporting and performance scorecard systems.  This should consider hardware, software solution(s), data architecture, system integration aspects and tools to enhance user experience and facilitate self-service as needed. (vii) implementation path to migrate current to the recommended future BI-DW. This should include impact analysis and how the existing extracts, reports, dashboards and queries should be adjusted/modified to be compatible with the recommended future BI-DW.

Deliverables – A comprehensive document that must detail; (i) vendor’s understanding of current BI-UDW in UNICEF (ii) information gathered directly from stakeholders on their current and future data, reporting needs (iii) platform options that were considered per industry best practices that can meet stakeholder needs within various UNICEF and partner operating contexts. (iv) comparisons of the platforms considered along with pros and cons from various dimensions. (v) Recommended platform strategy and roadmap for future BI-DW in UNICEF for an enterprise reporting and performance scorecard systems.  (vi) Approach, cost-benefit and impact analysis for migrating UNICEF inSight-UDW hosted on Microsoft-Oracle to a new generation BI-DW Platform. A business case with high-level costed plan covering results, resources & risks and dependencies for implementation of the recommended strategy & roadmap.

Proposed vendor’s team qualifications – Knowledge & Experience:

  1. Extensive knowledge and experience in Data Warehouse and Business Intelligence (BI) subject areas, products & tools is mandatory.
  2. Knowledge of use cases of various DW-BI solutions in various IT verticals and industry best practices is mandatory.
  3. Knowledge and experience with big data is desirable.
  4. Experience in developing product & solution strategy, roadmaps and professional business cases.
  5. Communication skills with ability to interact and speak with business stakeholders.
  6. Certified in project management.

Deadline 27/11

UN Office for Project Services seeks Financial Management Software provider

Call for the Provision of Financial Management Software

Contracting Authority: United Nations Office for Project Services, HQ Copenhagen
Description: FMS mainly for the Sustainable Energy for All initiative (as a global partnership platform that was to promote and support new collaborative approaches for governments, business and civil society to work together in making sustainable energy for all a reality by 2030)

Technical Specification – Financial Management Software:  Ability to open and close accounting periods and manage chart of accounts.  Must be integrated with the Austrian VAT regulatory requirements.  Ability for the chart of accounts or other functionality, to capture and report on aspects of expenses: programme, activity, intervention type, project, funding source, and ability to amend master data of these aspects.  Ability to load budget versions and report on them against expenditure.  Must be able to apply budgetary control to stop over expenditure on defined account code string.  Integration with accounts receivable (AR) and accounts payable (AP), including supplier and donor (for AR) details management.  Automation of reconciliation – for example for AR and AP and for bank accounts.  Ability to integrate with banking software. Compatibility with the Bank of Austria an advantage  Integration with a procurement module (Purchase request (PR) to payment) to include reservation of budget (funds) by purchase order or purchase request  Familiarity to Austrian auditors requirement.  Must be able to export data and integrate with other services, in particular with MS Excel and Word, across devices.  Ability to manage user access and create user groups.  Flexible reporting to allow customization of reports. Reporting to allow use of hierarchies, for the aspects of expenses listed above.  Asset management and depreciation calculation and posting automation is an advantage.  Availability to manage time based on specific projects an advantage.  Grant management module an advantage  Position management an advantage  Mobile functionality for remote use an advantage  Must reply to any requests and solicitations within 48 hours maximum.  Continued Technical Support through life product license.  Must be able to automatically upload data entries to cloud when on line.  Must provide the following modules: (Foreign Exchange Currency, Account Management, Payments Supplier, Cost Accounting, Cost Centre, Budgeting, Business Analysis, Balance Sheet, FIAC and Reporting module).

Deadline for request for quotation: 16/11

Archiving Management Solution for UNICEF

Call for: Archiving Management Solution

Contracting Authority: UNICEF

Description: UNICEF is seeking to procure an ISAD (G) complaint Archives Management Systems (the “AMS Solution”) deployed in an ISO 27001 certified managed cloud solution that is regularly audited delivering a compliant and cost effective storage. We wish to procure the implementation, post implementation maintenance and support services for this system. UNICEF requires, as a turn-key solution a single, integrated and secure off-the shelf AMS solution to be delivered, fully designed, configured/customized (where necessary), installed and tested and fulfilling all the requirements defined in this document. Thus, the proposed AMS solution shall in one contract include the software tool/solution [(either following a traditional software on premise approach or in its Software as a service (saas version)] and the implementation services, including post implementation support and maintenance for the envisioned duration of the resulting contract/agreement.

Deadline for expression of interests: 23/11

O zakázku na europarlamentní systém správy elektronických záznamů soutěží jen 3 zájemci

Nabídku do tendru na “pořízení a implementaci systému správy elektronických záznamů” pro Evropský parlament podaly jen tři firmy. To znamená, že můj klient má 33-ti procentní šanci ho vyhrát:) A není jediný důvod, proč by neměl:) V budgetu je slušná sumička, 10 milionů euro.

Sekretariát Rady EU potřebuje pomoc se svým Finančním IS na bázi SAP

Zakázka: Poskytnutí služeb souvisejících se systémem SAP
Zadavatel: Rada EU – Generální sekretariát

Popis: Údržba, podpora, školení a poradenské služby související s integrovaným finančním informačním systémem na bázi systému SAP ERP Central Component 6.0 (s názvem SOS II) a souvisejícími produkty (SAP BI, SAP PI, Solution Manager apod.) používanými generálním sekretariátem Rady Evropské unie, Soudním dvorem Evropské unie, Evropským účetním dvorem a Evropským univerzitním institutem.

NATO hledá poradce pro přechod z ASP na .NET

Tender: NATO Standardization Office Consultancy Support

Zadavatel: NATO Standardization Office, Brussels

The call aims to obtain tenders for CIS contractors support to identify and implement migration of the existing „Classic ASP“ sites to .NET environment. The entire project may split in subprojects and may also entail maintenance of NSO Business Applications (current NSO environment – Classic ASP – is present in MS Windows 2008R2 with target to be upgraded to 2012R2. NSO´s Business apps also use the latest SQL server version).

Kontrakt na rok 2018 s možností prodloužení na rok 2019 a 2020.

Deadline pro odevzdání nabídky: 20/12 – 12:00

Case Management System pro OBSE

OSCE (Organizace pro bezpečnost a spolupráci v Evropě) hledá dodavatele pilotní verze Case Management Systemu pro Inspectorate of Albanian High Council of Justice. Půjde o celkovou dodávku (“design, develop, test, install and configure”).  Deadline 20/11 – 12:00.

Síťová infrastruktura a bezpečnostní síťové vybavení pro Radu EU. Kontrakt na 9 let

Pořízení vybavení síťové infrastruktury (položka 1) a bezpečnostní síťová zařízení (položka č. 2) a související služby

Rada Evropské unie, General Secretariat, Brusel, Belgie

Budget nespecifikován

Doba trvání: smlouva na 24 měsíců + možnost prodloužení o 7×12 měsíců, tj. celkem 9 let

Stručný popis: Cílem je uzavřít 2 rámcové smlouvy (1 pro každou položku) na pořízení vybavení síťové infrastruktury (položka 1) a bezpečnostního síťového vybavení (položka č. 2) a poskytnutí souvisejících služeb s cílem nahradit stávající rámcové smlouvy.

Oddělení infrastruktury a operací ředitelství pro komunikaci a informace (DGA CIS) – poskytuje soubor síťových služeb pro:

— IT služby poskytované ze strany DGA CIS,

— služby týkající se bezpečnosti, tisku, budov a konferencí generálního sekretariátu Rady (GSC),

— všechny koncové uživatele v prostorách Rady, kterými mohou být: • zaměstnanci GSC, • členové delegací, • pracovníci tisku nebo návštěvníci.

Síťové služby poskytují základ pro další infrastrukturní služby DGA CIS, které zase podporují služby DGA CIS poskytované klientům.

LOT1: Vybavení síťové infrastruktury a souvisejících služeb. Položka zahrnuje veškeré vybavení poskytující služby „Media Layers“ (OSI – propojení otevřených systémů – 1 až 3), ať už poskytují také služby vyšších vrstev, či nikoliv, a poskytování služeb týkajících se dodávání vybavení, např. systémovou integraci, profesionální služby, údržbu a školení.

LOT2: Vybavení bezpečnostní infrastruktury a souvisejících služeb. Položka zahrnuje veškeré vybavení poskytující služby „Host Layers“ (OSI – propojení otevřených systémů – 4 až 7), ať už poskytují také služby nižších vrstev, či nikoliv, a poskytování služeb týkajících se dodávání vybavení, např. systémovou integraci, profesionální služby, údržbu a školení.

Deadline: 13/12

IT služby pro evropský Open Data Portal

Tendr: Provision of IT services related to Open Data Portal (ODP)

Zadavatel: Publication Office of the EU

Rámcový kontrakt na 4 roky /budget €3.000.000

Scope of the call for tenders: the provision of software evolution, maintenance and consultancy services for the ODP. During the implementation of the FWC, the migration of the application to a cloud environment is foreseen.

Background: The European Union Open Data Portal is the single point of access to a growing range of data from the institutions and other bodies of the European Union. Data are free to use and reuse for commercial or non-commercial purposes. By providing easy and free access to data, the portal aims to promote their innovative use and unleash their economic potential. It also aims to help foster the transparency and the accountability of the institutions and other bodies of the EU.

Services to be provided:

S1                             Evolution

S2                             Maintenance

S3                             Consultancy

Other related services that may be requested:

S4                             Takeover

S5                             Handover

Deadline k podání nabídek 15/12

Evropský patentový úřad hledá partnera pro “externalizaci” datových středisek

Tendr: Zajištění řízení projektu a technické odbornosti pro externalizaci datových středisek

Zadavatel: Evropský patentový úřad

Kontrakt na 2 roky

Místo „doručení“: sídlo EPO v The Hague/Rijswijku

Kritéria pro hodnocení: technická část/kvalita 60% : cena 40%

Tendr má 2 fáze:

1) do 17/11 12:00 je třeba vyplnit a odeslat Pre-Selection Questions a Confidentiality Agreement (viz dále)

2) Zhruba na konci listopadu dostanou vybraní zájemci zadávací dokumentaci. Deadline pro odevzdání nabídky je plánovaná na polovinu/konec prosince.

NDA ke stažení.

Pre-Selection Questions:

I. Economic and Financial Capacity of the bidder

  1. Please confirm that the statutory seat of your company (legal entity) is in a Contracting State to the European Patent Convention, as specified in Point 1 of this Published Notice. Please provide evidence.
  2. Please confirm that your company is not bankrupt or being wound up, has ceased or suspended business activities, is being administered by courts or has entered into arrangements with creditors or analogous situations.
  3. Please confirm that the EPO may run a solvency check on your company via an external source (i.e. Dun & Bradstreet).
  4. Please supply details and the name(s) of the representative(s) authorised to sign a Non-Disclosure Agreement on behalf of your company, together with a recent excerpt from the commercial or similar register for your company (where so needed supplemented by additional information). In case the register does not specify this concretely, please arrange for a power of attorney.

II. Technical and Professional Capacity of the bidder:

  1. Please confirm and provide evidence that your company has at least 5 years’ experience in providing Project Management Support for Data Centre Migration project to organisations in Europe of a similar size as the EPO
  2. Please provide a minimum of 3 references/ written customer testimonials from previous customers to whom the bidder has provided the above services across multiple locations within at least Europe. The following Structure should be used:
  • General info: Organisation name/ Country locations/ Business sector/ Agreement to a reference visit (for at least 1 reference);
  • Details: Service descriptions and main technical details of the service solution/ Scale of implementation (number of users & locations, complexity of migrated services & applications)/ Service period