{
    "id": 73113,
    "procurementProjectId": 28885,
    "parentId": 35967,
    "noticeNumber": "2021-073113",
    "reducedTimeLimitsForReceiptOfTenders": false,
    "corrigendumAdditionalInformation": [],
    "creatorSystem": "Cloudia Kilpailutus",
    "type": 300,
    "legalBasis": "32014L0024",
    "project": {
        "id": 28885,
        "title": "Valtioneuvoston kanslian omistajaohjausosaston analyysipalveluiden yll\u00e4pito ja kehitt\u00e4minen",
        "contractType": 2,
        "procurementCategory": 1,
        "referenceNumber": "VN\/21690\/2020",
        "jointProcurement": false,
        "procurementLaw": [],
        "centralPurchasing": true,
        "coPurchasers": [],
        "validationState": 0,
        "organisation": {
            "id": "036a256e-c938-4157-2d35-08d78deb351a",
            "information": {
                "officialName": "Valtioneuvoston kanslia",
                "nationalRegistrationNumber": "0202132-3",
                "nutsCodes": [
                    "FI1B1"
                ],
                "postalAddress": {
                    "streetAddress": "Snellmaninkatu 1",
                    "postalCode": "00230",
                    "town": "Valtioneuvosto",
                    "country": "FI"
                },
                "email": "[email protected]",
                "contactPerson": "Jukka Ohtola",
                "mainUrl": "http:\/\/www.vnk.fi",
                "validationState": 0
            },
            "contractingAuthorityType": 1,
            "contractingType": 0,
            "mainActivity": 1,
            "mainActivityUtilities": 0,
            "validationState": 0,
            "dataSource": 0,
            "identifierMissing": false
        },
        "state": 1,
        "defenceWorks": 0,
        "defenceSupplies": 0,
        "publish": 1,
        "agricultureWorks": 0,
        "isPrivate": false,
        "isConcluded": false,
        "tendering": 0
    },
    "lotsInfo": {
        "divisionLots": false,
        "lotsSubmittedFor": 0,
        "lotsSubmittedForQuantity": 0,
        "lotsMaxAwarded": false,
        "lotsMaxAwardedQuantity": 0,
        "lotCombinationPossible": false,
        "validationState": 0
    },
    "objectDescriptions": [
        {
            "mainCpvCode": {},
            "additionalCpvCodes": [
                {
                    "code": "48000000",
                    "name": "Ohjelmatuotteet ja tietoj\u00e4rjestelm\u00e4t",
                    "vocCodes": []
                }
            ],
            "nutsCodes": [
                "FI1B"
            ],
            "descrProcurement": [
                "Valtioneuvoston kanslia -  IT-konsultointi 2018-2022 (DPS) \u2013 Yll\u00e4pito, sovellus- ja ohjelmistokehityspalvelut \u2013 Valtioneuvoston kanslian omistajaohjausosaston analyysipalveluiden yll\u00e4pito ja kehitt\u00e4minen",
                "",
                "Hankintayksikk\u00f6 pyyt\u00e4\u00e4 tarjoustanne omistajaohjausosaston analyysij\u00e4rjestelm\u00e4n yll\u00e4pito-ja kehitt\u00e4miskonsultoinnin teht\u00e4vist\u00e4 t\u00e4m\u00e4n tarjouspyynn\u00f6n ja sen liitteiden mukaisesti. ",
                "",
                "Teht\u00e4v\u00e4t sis\u00e4lt\u00e4v\u00e4t tietovaraston yll\u00e4pito- ja kehitt\u00e4misteht\u00e4vi\u00e4 Microsoft SQL Server \u2013ymp\u00e4rist\u00f6ss\u00e4, miss\u00e4 toiminnallisia ominaisuuksia ovat:",
                "",
                "- ELT -latausprosessi avainlukuaineistojen lataamiseen tietovarastoon.",
                "",
                "- SQL-tietovarastotietokanta tietojen ensisijaisena tallennuspaikkana",
                "",
                "- Tietovarasto sijaitsee VN konesalissa. Sen j\u00e4lkeisess\u00e4 ETL-prosessissa KPI-tiedostot latautuvat automaattisesti SQL-tietokantaan.",
                "",
                "- KPI-raportointi \/ analytiikka tapahtuu tietovaraston OLAP-kuutiosta Excelill\u00e4 toteutettavilla interaktiivisilla raporteilla.  ",
                "",
                "- OLAP -kuutio Excelill\u00e4 tapahtuvaa ad-hoc raportointia varten sis\u00e4lt\u00e4en writeback -ominaisuuden tarvittaville mittareille",
                "",
                "- OLAP-analyysikuutiosta virkamies voi tarvittaessa hakea ad-hoc pivot raportteja jotka on integroitu exceliin. Analyysikuutio sijaitsee samalla tietovarastopalvelimella.",
                "",
                "- J\u00e4rjestelm\u00e4 pit\u00e4\u00e4 muokata mahdollisimman nopeasti yll\u00e4pit\u00e4m\u00e4\u00e4n k\u00e4ytt\u00f6lokia: on selvitett\u00e4viss\u00e4, kuka k\u00e4ytt\u00e4j\u00e4 on k\u00e4sitellyt mit\u00e4kin tietoja \/ mit\u00e4 toimintoja k\u00e4ytt\u00e4nyt ja koska. My\u00f6s mahdollisessa jatkokehitt\u00e4misess\u00e4 tulee varmistaa k\u00e4ytt\u00f6lokitietojen saatavuus.",
                "",
                "-  Palvelun sis\u00e4lt\u00f6 (sis\u00e4lt\u00e4en ainakin k\u00e4ytt\u00f6liittym\u00e4t ja tuotetut dokumentit) on tarkoitus laatia saavutettavaksi EU-direktiivin \"Directive on Web Accessibility\" ja sit\u00e4 tarkentavan kansallisen lains\u00e4\u00e4d\u00e4nn\u00f6n mukaisesti sopimuskauden aikana",
                "",
                "- PowerBI -palvelun mahdollisen k\u00e4ytt\u00f6\u00f6noton sis\u00e4lt\u00e4en opastuksen raporttien omatoimiseeen toteuttamiseen",
                "",
                "- Reporting services \u2013raportit",
                "",
                "- Tarjouspyynt\u00f6 ei sis\u00e4ll\u00e4 mit\u00e4\u00e4n lisenssej\u00e4 eik\u00e4 palvelinta",
                "",
                "Lis\u00e4ksi asiantuntijapalvelut sis\u00e4lt\u00e4v\u00e4t k\u00e4ytt\u00e4j\u00e4tuen sek\u00e4 raportointimallien kehitys- ja yll\u00e4pitoteht\u00e4vi\u00e4. ",
                "",
                "K\u00e4ytt\u00f6- ja yll\u00e4pitotuen tulee olla tavoitettavissa arkisin (maanantai-perjantai klo 8.15-17.00).  Tarkemmat SLA-vaatimukset on kuvattu liitteen\u00e4 olevassa hankinnan kohteessa.",
                "",
                "Hankinta k\u00e4sitt\u00e4\u00e4 keskim\u00e4\u00e4rin noin 5-15 tunnin ty\u00f6panoksen kuukaudessa (kaikki tilattavat palvelut yhteenlaskettuina). Hankintayksikk\u00f6 edellytt\u00e4\u00e4, ett\u00e4 tarjoaja nime\u00e4\u00e4 teht\u00e4v\u00e4\u00e4n v\u00e4hint\u00e4\u00e4n yhden asiantuntijan ja yhden nimetyn varahenkil\u00f6n.",
                "",
                "Laiteymp\u00e4rist\u00f6n\u00e4 on yksi palvelin. Toimittaja yll\u00e4pit\u00e4\u00e4 ja kehitt\u00e4\u00e4 j\u00e4rjestelm\u00e4\u00e4n et\u00e4yhteyden kautta. Palvelin sijaitsee Valtorin konesalissa.",
                "",
                "Palvelun tulee t\u00e4ytt\u00e4\u00e4 ICT-varautumisen ja tietoturvan osalta TLIV - tason vaatimukset.",
                "",
                "Yleisarkkitehtuurikuvaus on tarjouspyynn\u00f6n liitteen\u00e4.",
                "",
                "Tarjojan kanssa tehd\u00e4\u00e4n liitteen\u00e4 olevan luonnoksen mukainen hankintasopimus, sopimus henkil\u00f6tietojen k\u00e4sittelyn ehdoista, tietoturvallisuus- ja turvallisuussopimus.",
                "",
                "Valittu asiantuntija ja varahenkil\u00f6 antavat suostumuksensa siihen, ett\u00e4 heist\u00e4 tehd\u00e4\u00e4n turvallisuusselvityslain (726\/2014) mukainen turvallisuusselvitys.",
                "",
                "Teht\u00e4viin sis\u00e4ltyvist\u00e4 yksitt\u00e4isist\u00e4 kehitt\u00e4mistoimeksiannoista sovitaan sopimuskauden aikana erikseen. ",
                "",
                ""
            ],
            "disagreeAwardCriteriaToBePublished": false,
            "awardCriteria": {
                "criterionTypes": 5,
                "qualityCriteria": [
                    {
                        "criterion": "Laadun maksimipisteet",
                        "weighting": "60"
                    }
                ],
                "costCriteria": [],
                "priceCriterion": {
                    "weighting": "40"
                },
                "criterion": [],
                "criteriaStatedInProcurementDocuments": false
            },
            "estimatedValue": {
                "type": 0
            },
            "timeFrame": {
                "type": 3,
                "beginDate": "2021-01-21T00:00:00",
                "canBeRenewed": false
            },
            "candidateNumberRestrictions": {
                "envisagedNumber": 0,
                "envisagedMinimumNumber": 0,
                "envisagedMaximumNumber": 0,
                "selected": 0
            },
            "optionsAndVariants": {
                "variantsWillBeAccepted": false,
                "partialOffersWillBeAccepted": false,
                "options": false,
                "optionType": 0
            },
            "tendersMustBePresentedAsElectronicCatalogs": false,
            "euFunds": {
                "procurementRelatedToEuProgram": false
            },
            "additionalInformation": [
                "Hankinnan ennakoiduksi arvoksi on merkitty maksimiarvo. Sopimuksen arvo voi olla my\u00f6s merkitt\u00e4v\u00e4sti pienempi, mik\u00e4li yll\u00e4pitoteht\u00e4vi\u00e4 on v\u00e4hemm\u00e4n."
            ],
            "awardContract": {
                "contractAwarded": 1,
                "noAwardedContract": {
                    "failureReason": 0,
                    "originalNoticeSentVia": 0
                },
                "awardedContracts": [
                    {
                        "conclusionDate": "2021-01-21T00:00:00",
                        "contractNumber": "VN\/21690\/2020 ",
                        "contractTitle": "Valtioneuvoston kanslian omistajaohjausosaston analyysipalveluiden yll\u00e4pito ja kehitt\u00e4minen",
                        "numberOfTenders": {
                            "disagreeTenderInformationToBePublished": false,
                            "total": 4,
                            "electronic": 4
                        },
                        "disagreeContractorInformationToBePublished": false,
                        "contractors": [
                            {
                                "officialName": "Fujitsu Finland Oy",
                                "nationalRegistrationNumber": "0815044-1",
                                "nutsCodes": [
                                    "FI1B"
                                ],
                                "postalAddress": {
                                    "streetAddress": "Valimotie 16",
                                    "postalCode": "00380",
                                    "town": "Helsinki",
                                    "country": "FI"
                                },
                                "isSmallMediumEnterprise": false,
                                "validationState": 0
                            }
                        ],
                        "initialEstimatedValueOfContract": {},
                        "finalTotalValue": {
                            "type": 1,
                            "value": 135000,
                            "currency": "EUR"
                        },
                        "likelyToBeSubcontracted": false,
                        "valueOfSubcontract": {},
                        "notPublicFields": {
                            "communityOrigin": false,
                            "nonCommunityOrigin": true,
                            "countries": [],
                            "awardedToTendererWithVariant": false,
                            "abnormallyLowTendersExcluded": false
                        }
                    }
                ]
            },
            "validationState": 0
        }
    ],
    "communicationInformation": {
        "procurementDocumentsAvailable": 0,
        "additionalInformation": 1,
        "additionalInformationAddress": {
            "officialName": "Valtioneuvoston kanslia",
            "nationalRegistrationNumber": "0202132-3",
            "nutsCodes": [
                "FI1B1"
            ],
            "postalAddress": {
                "streetAddress": "Snellmaninkatu 1",
                "postalCode": "00230",
                "town": "Valtioneuvosto",
                "country": "FI"
            },
            "email": "[email protected]",
            "contactPerson": "Jukka Ohtola",
            "mainUrl": "http:\/\/www.vnk.fi",
            "validationState": 0
        },
        "otherAddressForProcurementDocuments": {
            "nutsCodes": [],
            "validationState": 0
        },
        "sendTendersOption": 0,
        "addressToSendTenders": {
            "nutsCodes": [],
            "validationState": 0
        },
        "electronicCommunicationRequiresSpecialTools": false,
        "documentsEntirelyInHilma": false,
        "specsAndAdditionalDocuments": 0,
        "validationState": 0
    },
    "contactPerson": {
        "name": "Jukka Ohtola",
        "email": "[email protected]"
    },
    "procurementObject": {
        "shortDescription": [
            "Hankintayksikk\u00f6n\u00e4 toiminut valtioneuvoston kanslia pyysi tarjouksia omistajaohjausosaston analyysij\u00e4rjestelm\u00e4n",
            "yll\u00e4pito-ja kehitt\u00e4miskonsultoinnin teht\u00e4vist\u00e4 tarjouspyynn\u00f6n ja sen liitteiden mukaisesti. Kilpailutus tehtiin Hansel Oy:n dynaamisen hankintaj\u00e4rjestelm\u00e4n pohjalta: IT-konsultointi 2018-2022 (DPS) \u2013 Yll\u00e4pito, sovellus- ja ohjelmistokehityspalvelut. Hankinnan nimen\u00e4 oli Valtioneuvoston kanslian omistajaohjausosaston analyysipalveluiden yll\u00e4pito ja kehitt\u00e4minen.",
            ""
        ],
        "estimatedValue": {
            "type": 0
        },
        "estimatedValueCalculationMethod": [],
        "mainCpvCode": {
            "code": "72000000",
            "name": "Tietotekniset palvelut: neuvonta, ohjelmistojen kehitt\u00e4minen, Internet ja tuki",
            "vocCodes": []
        },
        "totalValue": {
            "type": 1,
            "value": 135000,
            "currency": "EUR"
        },
        "defence": {
            "nutsCodes": [],
            "frameworkAgreement": {
                "includesFrameworkAgreement": false,
                "includesConclusionOfFrameworkAgreement": false,
                "frameworkAgreementType": 0,
                "frameworkEnvisagedType": 0,
                "includesDynamicPurchasingSystem": false,
                "dynamicPurchasingSystemInvolvesAdditionalPurchasers": false,
                "dynamicPurchasingSystemWasTerminated": false,
                "estimatedTotalValue": {
                    "type": 0
                },
                "duration": {
                    "type": 0,
                    "canBeRenewed": false
                }
            },
            "subcontract": {
                "tendererHasToIndicateShare": false,
                "tendererHasToIndicateChange": false,
                "caMayOblige": false,
                "successfulTenderer": false,
                "successfulTendererToSpecify": false
            },
            "optionsAndVariants": {
                "variantsWillBeAccepted": false,
                "partialOffersWillBeAccepted": false,
                "options": false,
                "optionType": 0
            },
            "totalQuantityOrScope": {
                "type": 0
            },
            "renewals": {
                "canBeRenewed": false
            },
            "timeFrame": {
                "type": 0,
                "canBeRenewed": false
            }
        },
        "validationState": 0
    },
    "conditionsInformation": {
        "economicCriteriaToParticipate": false,
        "technicalCriteriaToParticipate": false,
        "restrictedToShelteredWorkshop": false,
        "restrictedToShelteredProgram": false,
        "reservedOrganisationServiceMission": false,
        "executionOfServiceIsReservedForProfession": false,
        "participationIsReservedForProfession": false,
        "obligationToIndicateNamesAndProfessionalQualifications": false,
        "validationState": 0
    },
    "conditionsInformationDefence": {
        "restrictedToShelteredWorkshops": false,
        "restrictedToShelteredProgrammes": false,
        "restrictedToParticularProfession": false,
        "staffResponsibleForExecution": false,
        "validationState": 0
    },
    "conditionsInformationNational": {
        "validationState": 0,
        "reservedForShelteredWorkshopOrProgram": false
    },
    "complementaryInformation": {
        "isRecurringProcurement": false,
        "estimatedTimingForFurtherNoticePublish": [],
        "electronicOrderingUsed": false,
        "electronicInvoicingUsed": false,
        "electronicPaymentUsed": false,
        "additionalInformation": [],
        "validationState": 0
    },
    "datePublished": "2021-05-12T07:45:06.6020595",
    "state": 2,
    "tedPublishState": 4,
    "tedSubmissionId": "20210510-005352",
    "tedPublishRequestSentDate": "2021-05-10T07:42:30",
    "tedPublicationInfo": {
        "ojs_number": "093",
        "no_doc_ojs": "2021\/S 093-243817",
        "publication_date": "2021-05-14T07:00:00",
        "ted_links": {
            "fi": "http:\/\/ted.europa.eu\/udl?uri=TED:NOTICE:243817-2021:TEXT:FI:HTML"
        }
    },
    "tedValidationErrors": [
        {
            "type": "TECH",
            "items": [
                {
                    "name": "T001",
                    "valid": true,
                    "message": "XML file is valid against XSD."
                },
                {
                    "name": "T002",
                    "valid": true,
                    "message": "Metadata could be retrieved from the XML file."
                },
                {
                    "name": "T003",
                    "valid": true,
                    "message": "Unique key is active."
                }
            ]
        },
        {
            "type": "VALIDATION_RULES",
            "items": []
        }
    ],
    "noticeOjsNumber": "2021\/S 093-243817",
    "previousNoticeOjsNumber": "2018\/S 165-377025",
    "procedureInformation": {
        "procedureType": 2,
        "acceleratedProcedure": false,
        "contestType": 0,
        "frameworkAgreement": {
            "includesFrameworkAgreement": false,
            "includesConclusionOfFrameworkAgreement": false,
            "frameworkAgreementType": 0,
            "frameworkEnvisagedType": 0,
            "includesDynamicPurchasingSystem": false,
            "dynamicPurchasingSystemInvolvesAdditionalPurchasers": false,
            "dynamicPurchasingSystemWasTerminated": false,
            "estimatedTotalValue": {
                "type": 0
            },
            "duration": {
                "type": 0,
                "canBeRenewed": false
            }
        },
        "reductionRecourseToReduceNumberOfSolutions": false,
        "reserveRightToAwardWithoutNegotiations": false,
        "electronicAuctionWillBeUsed": false,
        "procurementGovernedByGPA": true,
        "disagreeCriteriaForEvaluationOfProjectsPublish": false,
        "validationState": 0
    },
    "tenderingInformation": {
        "languages": [],
        "tendersMustBeValidOption": 0,
        "tenderOpeningConditions": {},
        "defence": {
            "previousPublicationExists": false,
            "hasPreviousContractNoticeOjsNumber": false,
            "hasPreviousExAnteOjsNumber": false,
            "payableDocuments": false,
            "languageType": 0,
            "languages": [],
            "otherLanguage": false
        },
        "estimatedExecutionTimeFrame": {
            "type": 3,
            "canBeRenewed": false
        },
        "validationState": 0
    },
    "rewardsAndJury": {
        "prizeAwarded": false,
        "serviceContractAwardedToWinner": false,
        "decisionOfTheJuryIsBinding": false,
        "validationState": 0
    },
    "resultsOfContest": {
        "contestWasTerminated": false,
        "noPrizeType": 0,
        "originalNoticeSentVia": 0,
        "participantsContemplated": 0,
        "participantsSme": 0,
        "participantsForeign": 0,
        "disagreeParticipantCountPublish": false,
        "disagreeWinnersPublish": false,
        "disagreeValuePublish": false,
        "validationState": 0
    },
    "tedNoDocExt": "2021-073113",
    "attachments": [],
    "hasAttachments": false,
    "changes": [],
    "isCorrigendum": false,
    "isMigrated": false,
    "isCancelled": false,
    "cancelledReason": [],
    "isLatest": true,
    "language": "FI",
    "proceduresForReview": {
        "reviewBody": {
            "officialName": "Markkinaoikeus",
            "nutsCodes": [],
            "postalAddress": {
                "streetAddress": "Radanrakentajantie 5",
                "postalCode": "00520",
                "town": "Helsinki",
                "country": "FI"
            },
            "telephoneNumber": "+358 295643300",
            "email": "[email protected]",
            "mainUrl": "http:\/\/www.oikeus.fi\/markkinaoikeus",
            "validationState": 0
        },
        "validationState": 0
    },
    "attachmentInformation": {
        "description": [],
        "links": [],
        "validationState": 0
    },
    "modifications": {
        "additionalCpvCodes": [],
        "nutsCodes": [],
        "timeFrame": {
            "type": 0,
            "canBeRenewed": false
        },
        "totalValue": {},
        "awardedToGroupOfEconomicOperators": false,
        "contractors": [],
        "reason": 0,
        "increaseBeforeModifications": {},
        "increaseAfterModifications": {},
        "validationState": 0
    },
    "contractAwardsDefence": [
        {
            "numberOfTenders": {
                "disagreeTenderInformationToBePublished": false,
                "total": 0
            },
            "contractor": {
                "nutsCodes": [],
                "postalAddress": {},
                "isSmallMediumEnterprise": false,
                "validationState": 0
            },
            "estimatedValue": {},
            "contractValueType": 0,
            "finalTotalValue": {},
            "lowestOffer": {},
            "highestOffer": {},
            "annualOrMonthlyValue": {
                "type": 0,
                "canBeRenewed": false
            },
            "likelyToBeSubcontracted": false,
            "valueOfSubcontract": {},
            "valueOfSubcontractNotKnown": false,
            "allOrCertainSubcontractsWillBeAwarded": false,
            "shareOfContractWillBeSubcontracted": false,
            "validationState": 0
        }
    ],
    "hilmaStatistics": {
        "energyEfficiencyConsidered": false,
        "innovationConsidered": false,
        "smeParticipationConsidered": false,
        "validationState": 0
    },
    "isPrivateSmallValueProcurement": false,
    "espdRequestReferences": [],
    "dateCreated": "2021-05-10T07:41:59.8601892",
    "dateModified": "2021-05-14T07:00:07.5955871"
}