Jan - Business Analyst COGNOS

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
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 ---