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.
• 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
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)
Microsoft SQL Server
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 Forms & Reports
Oracle Application Server
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.