Entreprises, SSII, DSI
Trouvez rapidement les meilleurs intervenants pour tous vos projets informatiques
Photo de Jan, Développeur COGNOS

Jan Développeur COGNOS

CV n°130220V001
Études et formations

Education and training
Microsoft SQL Server BI: Integration, Analysis en Reporting Vijfhart 2013

(Social) Communication Skills Training PinkRoccade Healthcare 2011

Presentation Skills Training Atos Origin 2010

Train de Trainer Est'09 2010

Dimensional Modelling Harm van de Lek 2008

IBM C8 Multidimensional Report Authoring Cognos, an IBM Company 2008

Introduction to Enterprise Business Intelligence MicroStrategy 2008

Qlikview Enterprise Qliktech 2007

Qlikview Professional Qliktech 2007

Database 10g; SQL fundamenten deel I Vijfhart 2007

Cognos8 Scorecard Application Development Cognos 2007

Cognos8 Report Authoring Part 2 Cognos 2007

Cognos8 Meta Modeling Part 2 Cognos 2007

Cognos8 Fast-track Cognos 2006

ReportNet Fast-track Cognos 2005

Injury prevention NGS 2003

Impromptu Web Reports for Administrators Cognos 2001

Supporting BI Impromptu Cognos UK 2001

Supporting BI Powerplay Cognos UK 2001

Access Manager Cognos 2001

Impromptu Administration Cognos 2001

Report Building with Impromptu Cognos 2001

Advanced Impromptu Reporting Cognos 2001

PowerPlay OLAP Modeling Cognos 2001

PowerPlay Report Building Cognos 2001

PowerPlay Data Exploration Cognos 2001

AMBI MG-1W Exin 2001

Sports massage NGS 1999

Practice Diploma Payroll St. Ned. Ass. Praktijkexamens 1992

Cardiac Resuscitation Nederlandse Hart Stichting 1992

Computer Accounting Thorbecke College Almelo 1992

MEAO (BA, BE) Thorbecke College Almelo 1992

AMBI, module 1 Exin 1989

MEAO (Ne, En, CE; In; DV; St) Van Rijnschool Almelo 1985

MAVO MAVO "Don Bosco" Rijssen 1980

Task Areas Business Intelligence / Data warehousing 12 2013
Balanced ScoreCarding 1 2008
Helpdesk Financial Software 8 2001

Functions Cognos Consultant, - Developer, - Trainer, - Beheerder, - Migrater, Metadata Specialist, Informatie Analyst 12 2013
Helpdesk Financial Software 8 2001

Branches Computers (Hardware, software) 25 2013
Insurance & Pensions 1 2010
Transportation and logistics (goods) 3 2009
Local Government 6 2008
Oil & Gas Production 1 2008
Automotive 1 2008
Health Care 3 2011

Methods Kimball, Inman, Lindstedt 12 2013
Agile, Scrum 5 2013
Coda, Decade, Beaufort, Centric applications, Docu-Informatie applications 6 2008
Balanced Scorecarding 1 2008

Tools and Utilities VNWare 8 2013
Virtula PC 7 2013
Virtual Box 4 2013
TOAD 7 2012

Applications Microsoft SQL Server BI: Integration, Analysis en Reporting 1 2013
IBM Cognos 10 (Report-, Query-, Analysis-, Metric Studio, Business Insight) 3 2013
Cognos 8 (Report-, Query-, Analysis-, Metric Studio) 6 2013
Cognos ReportNet (Report-, Query Studio) 8 2013
Cognos Series 5, 6, 7 (Impromptu, PowerPlay, IWR, PowerPlay Web, Acces Manager) 12 2013
Qlikview 2 2008
MicroStrategy 8 1 2007

Programming SQL 12 2013
MDX 6 2013

DBMS MS SQL Server (SQL 2000, 2005, 2008) 12 2013
Oracle 8 2013
DB2 4 2006
MS Acces 15 2013

Operating Systems Windows 2008 Server, Windows 2003 Server, Windows 2000 Server, Windows NT Server, Windows 3.11 for Workgroups 26 2013

Expériences professionnelles

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
Branche Software, Computers (Hardware, software)
Function Cognos Developer
Task • Responsible for creating a demo and a presentation of Cognos and Qlikview for a potential sponsor.
Applications MS SQL, IBM Cognos 8.2, Qlikview
Operating System Windows 2003 Server
DBMS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare

Assignment Pilot DBC (Diagnosis Treatment Combination)
Period November 2006 – September 2007
Sponsor St. Maartenskliniek
Branche Health Care
Function Cognos Developer
Task • Responsible for reporting in Cognos8, for the establishment of the development, Test, acceptance and production environment.
• Responsible for reporting in Cognos8, for the establishment of the development, Test, acceptance and production environment.
• Responsible for the migration of Cognos Series 7 to Cognos8. Responsible for the upgrade from Windows 2000 Server/Windows 2003 Server/Cognos Cognos 7.3 to 7.4
• Responsible for installing Cognos Series 7 and Cognos8 on first and the same server.
Applications MS SQL, IBM Cognos 8.2
Operating System Windows 2003 Server
DBMS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare

Opdracht Consultancy
Period June 2006 – September 2007
Sponsor Ciber
Branche Software, Computers (Hardware, software)
Function Cognos Consultant
Task • Responsible for performing (Cognos) Consultancy
Applications MS SQL, IBM Cognos 8.2
Operating System Windows 2003 Server
DBMS SQL Server 2005
Programming SQL, MDX
Tools & Utilities VMWare

Assignment Consultancy In Local Government
Period March 2002 – May 2006
Sponsor Impact Information Management BV
Branche Software, Computers (Hardware, software), Local Government
Function Cognos Consultant
Task • Responsible for Implementations PowerPlay; PowerPlay Web; Impromptu and IWR on financial-, HRM/salary and Docu-information packages, such as Coda, Decade, Beaufort, Centric Applications, Docu-Information Applications, etc.
• Trainer of PowerPlay, PowerPlay Web, Impromptu, IWR for users and administrators.
• Consultant for ICT and BI architecture in the field of BI-environments for customers.
Applications MS SQL, Oracle, IBM Cognos 5, 6, 7
Operating System Windows NT, -2000 Server
DBMS Oracle
Programming SQL
Tools & Utilities ---

Assignment Helpdesk (Cognos)
Period March 2001 – February 2002
Sponsor Cognos
Branche Software, Computers (Hardware, software)
Function Technical Analyst
Task • Support on functional and technical BI questions.
Applications IBM Cognos 5, 6, 7
Operating System Windows NT, -2000 Server
DBMS All
Programming SQL
Tools & Utilities ---

Assignment Helpdesk (Financial Software)
Period September 1993 – January 2001
Sponsor Quadrant Software BV; Innolan BV; Van der Moere BV
Branche Software, Computers (Hardware, software)
Function Helpdesk Operator
Task • Support on functional and technical questions.
Applications Financiële pakketten
Operating System MS-DOS, Windows NT, -2000
DBMS ---
Programming ---
Tools & Utilities ---