Paul Rankin

Data Strategy Consultant

About

I am a Senior Data Architect, BI and Analytics Solutions Specialist with a focus on Cloud architecture and the Data Management echo system. I have fifteen years experience in designing and delivering data Integration and BI solutions for a large number of national and International organisations. I am currently living and working in Switzerland where my latest challenge has led me to an exciting role and fantastic opportunity as Head of Data Management Platforms with Roche Diagnostics.

Country

Switzerland

City

Zurich

Industry

Information Technology & Services

Skill

Business Intelligence, ETL, Data Warehousing, Oracle, Requirements Analysis, Databases, OLAP, SSIS, Microsoft SQL Server, Requirements Gathering, Software Development, Cognos, Maximo, SQL, JD Edwards, CODA, SITS, Student Management Reporting, Dashboard Reporting, Masterpiece

Experience

Data Strategy Consultant

2024-1 - Present · 2 yrs 9 mos

Switzerland

Head of Data Management Platforms at Roche Diagnostics

Roche

2021-9 - 2024-4 · 2 yrs 8 mos

Switzerland

Senior Manager Applied Intelligence

Accenture

2020-11 - 2021-9 · 11 mos

Zurich, Switzerland

Digital Delivery Principal

Accenture

2018-1 - 2020-11 · 2 yrs 11 mos

Zürich Area, Switzerland

Working with Accenture's Digital Delivery team as Principal for the ASG region. Specialising in delivering technical solutions for data integration, data warehouse, business intelligence, analytics and visualization projects. As a key member of the data management sub-chapter I lead the data warehouse methodology chapter advising on Kimball and Data Vault methodoligies.

Data Integration and BI Solutions Specialist

Zurich Insurance

2015-5 - 2020-11 · 5 yrs 7 mos

Zürich Area, Switzerland

Risk IT platforms data integration, data warehouse and BI project. In Paul’s role as technical lead he was responsible for the design and development of an integrated Risk data warehouse, visual analytics and regulatory reporting solutions. Tools used included Oracle 10g, SSIS, IBM Cognos Analytics, SQL Developer, RAVE visualization.

Senior Cognos BI Consultant & Pre Sales Specialist

Barrachd

2009-9 - 2015-4 · 5 yrs 8 mos

United Kingdom

As a Senior Business Intelligence Consultant, I am responsible for the design, development, and implementation of customer BI solutions utilizing the Cognos suite of BI tools and 3rd party ETL tools. I work with clients to understand, analyse, and refine the application requirements and, where needed, provide guidance on selection of suitable Cognos BI tools and methodologies. Once the design has been validated and endorsed by the customer, my job is to source and model the data before developing and deploying reporting and analytics applications to the end users.