David Hill
Senior Consultant at Versatil- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
French Limited working proficiency
-
English Native or bilingual proficiency
Topline Score
Bio
Credentials
-
IBM Certified Administrator - IBM Cognos Analytics Administrator V11
IBM Professional CertificationSep, 2019- Oct, 2024 -
IBM Cognos Analytics Modeling Essentials - 2017
IBMMar, 2019- Oct, 2024 -
IBM Cognos Analytics Reporting Essentials - 2017
IBMMar, 2019- Oct, 2024 -
Knowledge Centered Service (KCS)
IBMMar, 2019- Oct, 2024 -
Enterprise Design Thinking
IBMFeb, 2019- Oct, 2024 -
Kubernetes and IBM Cloud Container Service
IBMJun, 2018- Oct, 2024 -
Earning Advocacy Practitioner
IBMFeb, 2018- Oct, 2024 -
Cloud Essentials I
IBMAug, 2017- Oct, 2024 -
Client Success and Support: Professional
IBM -
Client Success and Support: Professional
IBM -
Cloud Essentials I
- -
IBM Cognos Analytics Administration Essentials
IBM
Experience
-
Versatil
-
Spain
-
Retail
-
1 - 100 Employee
-
Senior Consultant
-
May 2019 - Present
-
-
-
Self-Employed
-
Real Estate
-
1 - 100 Employee
-
President
-
Apr 2019 - Present
-
-
-
Élections Canada | Elections Canada
-
Canada
-
Government Administration
-
700 & Above Employee
-
Senior Cognos Consultant
-
Apr 2019 - May 2019
PROJECT/ROLE DESCRIPTION Elections Canada was looking for a senior Cognos consultant to help transform their organization to self-service reporting using IBM Cognos Analytics version 11. The main activities performed included: - Performing administrative tasks around the Cognos environment, including: o Troubleshooting server and performance issues using logging, reviewing logs, fixing issues or creating workarounds, working with IBM support when required. o Implementing security model and process based on the Elections Canada licenses & reporting requirements. o Creating reporting/dashboard templates. o Using MetaManager to perform content deployment, backups and bulk changes. - Leading all development activities for CEO dashboards for the general election. This includes: o Performing requirement analysis and ensuring requirements are clearly defined. o Designing, developing IBM Cognos 11 Framework Manager model for a new data warehouse and ODS, as well as report templates and mock-ups for different user groups. o Working with BA's, data warehouse, ETL and Test teams to ensure all requirements were met. o Generating test data in the data warehouse using Redgate. o Designing, developing highly visual dashboards in the IBM Cognos Analytics to showcase new Cognos 11 capabilities. o Providing status updates. o Making recommendations. o Implementing custom controls for advanced prompting. o Migrating content to UAT and Prod environments. o Providing support and expert advice on everything related to Cognos products. o Providing fixes and solutions to open tickets for complex Cognos dashboards and reports that included Esri Map integration using Integeo software. Some issues involved working directly with Integeo to troubleshoot, collect logs and fix issues. Technologies: IBM Cognos Analytics 11, SQL Server, BSP MetaManager, Integeo
-
-
-
IBM
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Seniour Technical Analyst - Cognos Analytics on Cloud
-
May 2017 - Mar 2019
Employed as part of the IBM Business Analytics Cloud Hybrid team, with main responsibility of providing software support and resolving customer issues as well as providing technical expertise for design and development for all IBM Cognos products. Maintained one of the lowest backlogs, highest throughput, fastest resolution rates in the Cognos Analytics Support organization. Provided deep-dive analysis of root causes for aging backlog. Maintained extremely high customer satisfaction rates. Main Activitieso Providing expert IBM Cognos Business Analytics product support through different industries and verticals.o Working with all Cognos Business Analytics products (on premise & in the cloud) including Series 7, Business Intelligence versions 8 and 10, Cognos Analytics 11 and 11.1, and Watson Analytics. o Client account managemento Top tier technical support for strategic enterprise accounts through roles with Advantage Support, Accelerated Value, Escalations and Global Solutions Consulting teams.Some tasks:o Installing and configuring Cognos products on various platforms.o Replicating customers’ environments and problems.o Analyzing user requirements.o Applying updates to Cognos and third-party products.o Upgrading Cognos Analytics environments.o Designing & implementing solutions/workarounds.o Designing & developing reports & dashboards.o Designing & developing Framework Manager models & Data Modules.o Designing & developing cubes (Dynamic Cubes & Transformer).o Scheduling reports & jobs to deliver email or to a file location.o Examining SQL to resolve performance issues.o Coordinating resources for timely completion of projects.o Reviewing and analyzing active and historical support case inventory.o Documenting and presenting results to senior management and other stakeholders.o Creating Knowledge Base Articles (Technotes).o Coaching/mentoring team members & customers on the use of IBM Cognos Analytics solution.
-
-
Global Solutions Consultant
-
Apr 2015 - Mar 2019
Employed as part of the IBM Business Analytics Global Solutions team, with main responsibility of providing second level software support and resolving customer issues as well as providing technical expertise for design and development for all IBM Cognos products. Maintained one of the lowest backlogs, highest throughput, fastest resolution rates in the Cognos Analytics Support organization. Provided deep-dive analysis of root causes for aging backlog. Maintained extremely high customer satisfaction rates. Main Activitieso Providing expert IBM Cognos Business Analytics product support through different industries and verticals.o Working with all Cognos Business Analytics products (on premise & in the cloud) including Series 7, Business Intelligence versions 8 and 10, Cognos Analytics 11 and 11.1, and Watson Analytics. o Client account managemento Top tier technical support for strategic enterprise accounts through roles with Advantage Support, Accelerated Value, Escalations and Global Solutions Consulting teams.Some tasks:o Coaching/mentoring team members & customers on the use of IBM Cognos Analytics solution.o Creating Knowledge Base Articles (Technotes).o Installing and configuring Cognos products on various platforms.o Replicating customers’ environments and problems.o Analyzing user requirements.o Defining troubleshooting methodologies.o Designing & implementing solutions/workarounds.o Examining SQL to resolve performance issues.o Coordinating resources for timely completion of projects and to provide timely customer solutions.o Reviewing and analyzing active and historical support case inventory.o Documenting and presenting results to senior management and other stakeholders.
-
-
Technical Analyst - Accelerated Value Program
-
Mar 2006 - Apr 2015
Providing top tier support for IBM Business Analytics - Cognos BI and TM1 products.Level III KCS Coach (Knowledge Centered Support)
-
-
-
-
Professional Artist
-
1989 - Mar 2006
Managed a successful career in one of the most exciting and challenging fields with a national exhibition history. Conception, planning, development, production, marketing. Proposal & Grant appilciation writing. Canada Council for the Arts Grant (1998) Managed a successful career in one of the most exciting and challenging fields with a national exhibition history. Conception, planning, development, production, marketing. Proposal & Grant appilciation writing. Canada Council for the Arts Grant (1998)
-
-
-
-
General Manager
-
May 1998 - Nov 2005
Designed & Implemented cost saving mechanisms including IT solutions. Responsibilities included Finance, Businesss Development & Stragegy, IT, Supply Chain. Designed & Implemented cost saving mechanisms including IT solutions. Responsibilities included Finance, Businesss Development & Stragegy, IT, Supply Chain.
-
-
-
-
Chair
-
Jan 1997 - Jan 1999
Oversaw and guided the smooth operations of a highly active cultural production and dissemination centre through a stressful period in the organization's long history. Oversaw and guided the smooth operations of a highly active cultural production and dissemination centre through a stressful period in the organization's long history.
-
-
-
-
Production Manager
-
Jan 1996 - Jan 1998
Responsibilities: Production Management. Accomplisthments: Developed several cost saving processes and expanded business operations through the development of new revenue streams. Responsibilities: Production Management. Accomplisthments: Developed several cost saving processes and expanded business operations through the development of new revenue streams.
-
-
-
Heritage Canada
-
Canada
-
1 - 100 Employee
-
Photographer / Inventory Clerk
-
1995 - 1995
Designed and implemented an inventory methodology and image database to document and track department owned assets. Designed and implemented an inventory methodology and image database to document and track department owned assets.
-
-
-
University of Ottawa
-
Civil Engineering
-
1 - 100 Employee
-
A/V Technician
-
Jan 1992 - Jan 1994
Responsibilities included the care and maintenance of camera, darkroom, audio/visual and computer equipment. Responsibilities included the care and maintenance of camera, darkroom, audio/visual and computer equipment.
-
-
-
Compucentre
-
Brazil
-
IT Services and IT Consulting
-
Sales Manager
-
Jan 1985 - Jan 1990
Staff training, deposits, established sales targets, inventory control, payroll, tax remittance. Staff training, deposits, established sales targets, inventory control, payroll, tax remittance.
-
-
-
-
Assistant Manager / Inventory-Control Clerk
-
Jan 1985 - Jan 1987
Tracking and maintaining inventory, quality control, designed and implemented Inventory and Shipping/Receiving Methodologies. Tracking and maintaining inventory, quality control, designed and implemented Inventory and Shipping/Receiving Methodologies.
-
-
Education
-
ITI
Information Technology -
University of Ottawa
BA, Theory & History of Art -
University of Ottawa
BFA, Visual Arts -
University of Ottawa
B.F.A, Visual Art - Sculpture & Photography -
York University
BA, Economics/East Asia Studies -
York University
B.A, Economics & East Asian Studies