Business intelligence system analyst
Kettle Foods Limited, Norwich, United Kingdom
août 2013 - aujourd'hui
Key responsibilities:
â Support the Finance and Planning team in providing concise and relevant monthly
management information to stakeholders by creating and maintaining Dashboards and KPI’s.
â Support business strategy & Identify process improvement opportunities
â Leading data migration projects during the integration process with new companies.
â Development of a wide application Using IBM Cognos Cognos TM1 to manage:
â Input sales promotions
â Manage promotion workflow with TM1 processes
â Calculate promotion data and integrate external data to generate budget and Forecast
â Train system TM1 end-users on TM1 functionality, models, and report development utilizing
best practices
â Identify the risk assessments for the new system functionalities and enhancements
â Support software upgrades, software documentation.
â Create and maintain reporting using IBM Cognos BI Reporting and Microsoft Power BI
â Maintain data transfer between IBM Cognos TM1, SQL Server and Oracle (using Microsoft SSIS
Packages and TM1 Turbo integrator)
Technical platform
â Cognos Planning Analytics (TM1) 10.2.x
o TM1 Development/ Administration (Cubes, Dimensions, Rules, Feeders, TI
processes…)
o TM1 Optimisation (Security, Feeders, Data consolidation, hierarchies, Subsets, MDX
queries...)
o Xcelerator via Excel (Active forms, Input screens, …)
â IBM Cognos Business Analytics (B)I 11.2.x
o Report Studio (Active Reports, Dashboards, …)
o Framework Manager
o Security, Jobs
â SQL Server 2012/ Oracle 10.x (Toad for Oracle)
o Microsoft SSIS Packages development / Data integration (ETL) / automated Jobs
o Database development (Transact SQL, Tables, Stored procedures, Views,...)
â Cubewise Canvas software for Cognos TM1
o Web development (HTML/CSS, Angular-Js, Bootstrap, Javascript)
3