Expérience professionnelle
Overview of assignments
The assignments which Jan has done, are described below. Besides the performances and also attention to contribution of the employee and, if relevant, the background against which it was delivered.
Assignment Training New Features IBM Cognos 10.2
Period January 2013 – January 2013
Opdrachtgever Janssen, Pharmaceutical of Johnson and Johnson
Branche Pharmaceutical products
Functie Cognos 10 Trainer
Taak • Responsible for training new features IBM Cognos BI 10.2
Applicaties MS SQL, IBM Cognos 10.1.1
Operating System Windows 2008 Server
DBMS MS SQL Server 2008
Programmeertalen SQL, MDX
Tools & Utilities VMWare
Assignment Developing reports and dashboards in Cognos 10
Period November 2012 – December 2012
Opdrachtgever Janssen, Pharmaceutical of Johnson and Johnson
Branche Pharmaceutical products
Functie Cognos 10 Developer
Taak • Responsible for making packages in Framework Manager.
• Responsible for making cubes in Transformer.
• Responsible for creating reports on cubes and packages.
Applicaties MS SQL, IBM Cognos 10.1.1
Operating System Windows 2008 Server
DBMS MS SQL Server 2008
Programmeertalen SQL, MDX
Tools & Utilities VMWare
Assignment Maintenance IBM Cognos BI environment
Period April 2012 – November 2012
Sponsor KPN Datacenter
Branche Software, Computers (Hardware, software)
Function IBM Cognos Consultant
Task • Responsible for the provisioning of a Cloud on Cognos 10.1.1 BI for KPN customers.
• Responsible for setting up a process for promotion of packages, cubes and reports in an OTAP.
• Responsible for training Administration IBM Cognos 10.1.1 of the promotion of packages in OTAP.
• Sparring partner in the field of Cognos and BI issues.
Applications MS SQL, IBM Cognos 10.1.1
Operating System Windows 2008 Server
DBMS MS SQL Server 2008
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Training IBM Cognos BI
Period April 2012 – April 2012
Sponsor Municipality Of Waterland
Branche Local Government
Function IBM Cognos Trainer
Task • Trainer for Cognos 8 & 10 on Centric applications, such as Key2Onderwijs, Key2Financiën, GWS4All, Pims4All.
• Sparring partner in the field of Cognos and BI issues.
Applications Centric Applicatiions, IBM Cognos 8.4 & 10.1.1
Operating System Windows 2003 & 2008 Server
DBMS Oracle
Programming SQL
Tools & Utilities VMWare
Assignment Maintenance IBM Cognos BI environment
Period October 2011 – March 2012
Sponsor ASR Verzekeringen
Branche Insurance & Pensions
Function IBM Cognos Developer
Task • Responsible for the maintenance of the IBM Cognos BI environment.
• Responsible for promoting of Cognos Packages by OTA.
• Responsible for developing and customizing frameworks, cubes and reports for the various departments.
• Sparring partner in the field of Cognos and BI issues.
Applications MS SQL, IBM Cognos 8.4
Operating System Windows 2003 Server
DBMS MS SQL Server 2005, Oracle
Programming SQL, MDX
Tools & Utilities VMWare, TOAD
Assignment Consultancy
Period October 2011 – present
Sponsor The Future Group
Branche Software, Computers (Hardware, software)
Function IBM Cognos BI Professional
Task • Responsible for performing (Cognos) Consultancy.
Applications MS SQL, IBM Cognos 7, 8 & 10
Operating System Windows 2003/2008 Server
DBMS SQL Server 2005 / 2008, Oracle
Programming SQL, MDX
Tools & Utilities VMWare, Sun Virtual Box, Virtual PC
Assignment Start of freelance
Period April 2011 – September 2011
Sponsor n.v.t.
Branche Software, Computers (Hardware, software)
Function IBM Cognos BI Professional
Task • Research to start as a freelancer.
Applications n.v.t.
Operating System n.v.t.
DBMS n.v.t.
Programming n.v.t.
Tools & Utilities n.v.t.
Assignment Consultancy Care instellingen
Period April 2011 – May 2011
Sponsor Pink Roccade Healthcare
Branche Software and Health Care
Function Consultant
Task • Responsible for creating (tailor-made) reports on Caress.
• Sparring partner in the area of SQL, Cognos and BI issues for both internally and at the customer.
Applications IBM Cognos 8.2 & 8.4
Operating System Windows 2005 Server
DBMS MS SQL Server 2005
Programming SQL
Tools & Utilities VMWare
Assignment Training Jumpstarters
Period November 2010 – March 2011
Sponsor Atos (vh Atos Origin)
Branche Software, Computers (Hardware, software)
Function Trainer
Task • Responsible for the training of Jumpstarters.
• The responsible guidance for SQL and Cognos questions during this BI Game.
Applications MS SQL, IBM Cognos 8.4.1 & – 10.1
Operating System Windows 2008 Server
DBMS MS SQL Server 2008
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Report optimization and new requirements.
Period August 2010 – October 2010
Sponsor Achmea
Branche Insurance & Pensions
Function Cognos Developer
Task • Contribution in the performance improvement of the reports, for using techniques, such as (x) HTML in the reports.
• Sparring partner in the field of Cognos and BI issues.
Applications MS SQL, IBM Cognos 8.3
Operating System Windows 2003 Server
DBMS MS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Knowledge Communication IBM Cognos
Period April 2010 – present
Sponsor Cognos Users Group Netherlands
Branche Software, Computers (Hardware, software)
Function President
Task • Responsible for organizing the annual meeting (ALV).
• Responsible for organizing the “networkborrels”.
• Responsible for maintaining messages in the Social Media.
Applications n.v.t.
Operating System n.v.t.
DBMS n.v.t.
Programming n.v.t.
Tools & Utilities n.v.t.
Assignment Reafinance for Reaforce
Period June 2009 – July 2010
Sponsor Reasult BV
Branche Software, Computers (Hardware, software)
Function Business Consultant Reafinance
Task • Responsible for processing the information analysis, for developing data marts.
• Responsible for the financial reports and management presentations of real estate information.
• Optimizing performance management by offering reports in Cognos8.
Applications MS SQL, IBM Cognos 7.4, 8.1, 8.2, 8.3 en 8.4.1
Operating System Windows 2003, 2008 Server
DBMS MS SQL Server 2000, -2005
Programming SQL, MDX
Tools & Utilities VMWare
Assignment
Developing BI Transport models
Period December 2008 – April 2009
Sponsor Fourpoints Intelligence
Branche Software, Computers (Hardware, software)
Function Cognos Developer
Task • Responsible for the factory in Cognos8 conceptrapporten based on different data marts from a factory concept DWH.
Applications MS SQL, Oracle, IBM Cognos 8.4.1
Operating System Windows 2003 Server
DBMS MS SQL Server 2000, -2005, Oracle 10g
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Training PowerPlay Web & ReportNet
Period November 2008 – November 2008
Sponsor Carglass
Branche Automotive
Function Cognos Trainer
Task • Responsible for knowledge transfer for users of their Cognos environment by an interactive seminar.
• Through these training wanted they know or information in the reports could be adjusted or in the metadatalaag.
Applications PowerPlay Web, ReportNet
Operating System Windows 2003 Server
DBMS -
Programming -
Tools & Utilities PowerPoint
Opdracht Zero Point Measurement (FourScan)
Period September 2008 – November 2008
Sponsor TNT Innight
Branche Transport en Logistiek (goederen)
Function Informatie Analyst
Task • Responsible for mapping the current Cognos environment for a zero measurement.
Applications MS SQL, Oracle, Cognos 8.2 en 8.4
Operating System Windows 2003 Server
DBMS MS SQL Server 2000, -2005
Programming SQL, MDX
Tools & Utilities VMWare, Demo Metamanager
Assignment Demo Transport (Cognos)
Period december 2008 – april 2009
Sponsor Fourpoints Intelligence
Branche Software, Computers (Hardware, software)
Function Cognos Developer
Task • Responsible for creating a demo and a presentation for the ICT & Logistics fair.
Applications MS SQL, Oracle, IBM Cognos 8.4
Operating System Windows 2003 Server
DBMS Oracle 10g
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Knowledge Transfer Cognos
Period May 2008 – June 2008
Sponsor Amstelring
Branche Health Care
Function Cognos Consultant
Task • Responsible for the complete training for Administrators, Authors in Cognos8 BI BI Report.
Applications MS SQL, IBM Cognos 8.2
Operating System Windows 2003 Server
DBMS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare
Opdracht Building dashboards
Period May 2008 – June 2008
Sponsor Municipality Of Barneveld
Branche Local Government
Function Cognos Consultant
Task • Responsible for creating dashboards for the daily strategic reports for the Finance Department for their budget monitoring.
Applications MS SQL, IBM Cognos 8.2
Operating System Windows 2003 Server
DBMS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare
Assignment Demo Transport (Qlikview)
Period maart 2008 – mei 2008
Sponsor Fourpoints Intelligence
Branche Software, Computers (Hardware, software)
Function Qlikview Developer
Task • Responsible for creating a demo and a presentation for the ICT & Logistics fair.
Applications MS Excel, Qlikview
Operating System -
DBMS -
Programming SQL
Tools & Utilities -
Assignment Migration Cognos Global Internal Learning
Period January 2008 – May 2008
Sponsor Shell
Branche Oil & Gas Production
Function Cognos Developer
Task • Responsible for the migration of Cognos Series 7 to on the Development, testing and Cognos8 Acceptance environment.
Applications MS SQL, IBM Cognos 7.4 & 8.1
Operating System Windows 2003 Server
DBMS SQL Server 2000
Programming SQL
Tools & Utilities VMWare
Assignment BI Transport POC
Period October 2007 – December 2007
Sponsor Fourpoints Intelligence
Branch...