Skip to content
Hays - Recruiting experts worldwide
  1. I am
    I am

Talk to a consultant

Consultant

Talk to Carly Clark, the specialist consultant managing this candidate, located in Edinburgh

Contact consultant
ttelephone:0131 603 8372
24 Charlotte Square,, Edinburgh, Lothian, United Kingdom, EH2 4ET

Cognos 10 and SQL Consultant

Glasgow & Strathclyde

Job Type
Contract / interim
Pay
Daily Rate
Reference
8161736
  • Request information for Cognos 10 and SQL Consultant

I am currently working with a highly experienced Cognos 10 consultant with over 22 years experience who has just finished a contract through myself at Dundee University on a 22 month contract.

Summary

• Has worked in IT Industry for 22 years
• Specialist in Cognos 10 and SQL
• Able to work both individually and as part of a team
• Good communicator to both technical and non-technical staff
• Able to interact with people at varying levels of any organisation
• Good understanding of project lifecycles

Development tools

Cognos 10 (5 Years experience)
Microsoft SSIS (1 Year experience)
Cognos 8 (Report, Query and Analysis Studios, Framework Manager, Transformer) (6 Years experience)
Cognos Impromptu including Impromptu Web (6 years experience)
PeopleSoft (2 years experience)
Visual Basic 6 (5 years experience)
Oracle Reports (6 years experience)
Cognos Powerhouse (Quiz,Quick,QTP) (10 years experience)

Database Systems

Microsoft SQL Server
Oracle

Training

SQL Server Integration Services for BI (Learning Tree 2014)
SQL Server Analysis Services for BI (Learning Tree 2014)
Cognos Impromptu Administration
Cognos Impromptu Web
Oracle PL/SQL
Oracle Forms & Reports
Oracle Application Server
Oracle/Peoplesoft PeopleTools

In his most recent contract at Dundee University he was employed as Cognos 10 & SSIS Consultant

He was initially brought in to develop Cognos 10 frameworks and reports to replace Impromptu. The University had already created some frameworks and reports in Cognos 10 but these did not cover all the requirements.

Once Impromptu had been decommissioned work then moved onto improving the Cognos 10 environment.

There was no data warehouse in place and reporting was done pulling data directly from the source systems. He used Microsoft tools (SSIS and SQL Server) to create a data warehouse taking data from multiple systems. These included Human Resources (Oracle HRMS), Finance (CODA Financials), Purchasing and Invoicing (Pecos) and a small amount of data from SITS (Student Records). All source systems were running on Oracle. This data was modelled into dimensional star schemas and he developed Cognos frameworks. This improved performance, accuracy and usability while enabling non technical staff at the University to easily create their own reports in Cognos. He developed reports and dashboards using the new frameworks.

He is immediately available and is ready to start his new contract. He is also very flexable with location.

  • Request information for Cognos 10 and SQL Consultant
|