CONTACT DATA

Name: Emilio Abella Birth date: ** November 1968

Address: Concordia 43 Birth place: Barcelona (Spain) City: 08004 Barcelona – Spain Driving license: A-2, B-1 Mobile: +34-637-**-**-** Own vehicle: Yes

Mail: adf1fp@r.postjobfree.com Mobility: Yes

EDUCATION

• 1993: Graduated in Economics and Business Administration, at the Universitat Autònoma de Barcelona.

• Year 1990-91 studied at the University of Limerick (IRELAND). IBM COGNOS BI EDUCATION

Oficial training

• IBM Cognos Series 8, Cognos 10

• IBM Cognos Planning

• Microsoft SQL server administrator

• HRMS. PeopleSoft.

Certifications

• Cognos BI Administrator

• Cognos BI Author

• Cognos 8 OLAP Developer

• Cognos 10 OLAP Developer

• Cognos training certification program

WORK EXPERIENCE

Working several software companies since 1997 as ERP and BI consultant:

• From 2010 to 2019 Cognos Senior Consultant as freelance.

• Actually working as Senior Cognos Consultant at Mercedes Benz CAC Maastricht (freelance).

• Employed between 2005 and 2009 in ITEVA solutions (co-owned company) official IBM Cognos Partner, working in BI consultancy, presales, training, administration, operations and post sales. This company was based in Barcelona.

• Employed between 1999 and 2005 in Moebius Consulting (later sold to Dominion TI) as BI consultant, BI Project Manager and Manager of BI Business Unit (2004-2005). Curriculum Vitae - Emilio Abella

Page 2

• Employed between 1997 and 1999 as HR and ERP consultant in SERESCO. I have worked in many of the projects this company had in Barcelona and Madrid.

• Employed at Université de Liège (Belgium) between December 95 and August 96. Sèrvice de Pedagogie Experimental, giving IT support to the department and making electronic version of educational courses. Several jobs earlier no IT related.

LANGUAGES

• ENGLISH : High knowledge in expression as well as understanding, oral and writing. Stay in Ireland from September 90 to June 91. TOEFL Test : 590.

• FRENCH : High knowledge in expression as well as understanding, oral and writing. Stay in Belgium from January to August 1996. Fourth level at the Escola Oficial d'Idiomes of Barcelona.

• SPANISH & CATALAN: native speaker.

LEGAL

Registered as self-employed in the Spanish Tax Office since 2005. Servicing through an owned limited company founded on 2005 (when required). LEISURE

Cycling

Music listening

Travelling

Reading

Computers and technology

…

Curriculum Vitae - Emilio Abella

Page 3

IBM COGNOS BI PRODUCTS KNOWLEDGE

Since 1999 in this BI (Business Intelligence) environment involved in the development of BI projects using different versions, deep knowledge of series 7, Cognos 8, 10 and Analytics 11. PRODUCTS

These are the products in which I have most experience: Cognos Analytics 11

Cognos Report Studio, Query Studio, Analysis Studio Cognos Framework Manager (DQM included), Dynamic Cube Designer Event Studio, Dashboards, Data Module

Cognos 10

Cognos Report Studio, Query Studio, Analysis Studio Cognos Framework Manager (DQM included), Dynamic Cube Designer Cognos Transformer

Cognos Workspace and Workspace Advanced (a.k.a. Business Insight and BI Advanced) Cognos Mobile

Cognos Connection

Cognos Data Manager

Cognos Metrics manager and Cognos Metrics Modelling Cognos 8

Cognos Framework Manager and Cognos Map Manager

Cognos Connection

Cognos Report Studio, Query Studio, Analysis Studio Cognos Dashboards, Cognos Metrics manager and Cognos Metrics Modelling Cognos Transformer, Cognos Powerplay

Cognos Office connection and Cognos Analysis for Excel (C.A.F.E.) Cognos Mobile

Cognos Data Manager

Series 7 and earlier

Cognos Impromptu 4, 5 and 7, Cognos Impromptu web reports, Cognos Query Cognos Architect

Cognos Powerplay 6, 7, Powerplay web

Cognos Powerplay for Excel, Powerplay Connect

Cognos PowerPlay Enterprise server and Upfront (6, 7) Cognos Transformer 6, 7, 8 and 10

Curriculum Vitae - Emilio Abella

Page 4

Cognos KPI manager

Cognos Visualizer

Cognos 4 thought, Cognos Scenario

Cognos Reportnet

ENVIROMENTS

OS: Windows, Sun Solaris, HP-UX, Linux

DB: Oracle, MS SQL Server, Ibm DB2, AS400, Informix Security: Active Directory, LDAP, Access Manager, NTLM, Third Party Authentication Third party OLAP connections: Microsoft Analysis Services, Essbase, SAP BW IBM COGNOS TRAINING EXPERIENCE

I have been teaching courses to end users, developers, system administrators. Official training and ad-hoc courses. IBM Cognos 10 BI Training

IBM Cognos 10 BI Administration

IBM Cognos 10 BI Framework Manager: Design metadata models IBM Cognos 10 BI Query Studio: Build Adhoc reports IBM Cognos 10 BI Report Studio: Author Professional Reports Fundamentals IBM Cognos 10 BI Report Studio: Author Professional Reports Advanced IBM Cognos 10 BI OLAP Modelling

IBM Cognos 8 BI Training

IBM Cognos 8 BI Administration

IBM Cognos 8 BI Framework Manager: Design metadata models IBM Cognos 8 BI Query Studio: Build Adhoc reports

IBM Cognos 8 BI Report Studio: Author Professional Reports Fundamentals IBM Cognos 8 BI Report Studio: Author Professional Reports Advanced IBM Cognos 8 BI Metrics Manager, Modelling

IBM Cognos 8 BI Fast Track

Series 7 training

Report building with Impromptu

Impromptu advanced report building

Impromptu administration

Powerplay analysis and report building

Powerplay web analysis

Powerplay administration and Upfront

Impromptu web reports

Curriculum Vitae - Emilio Abella

Page 5

Cognos Query

Visualizer,4 thought

Curriculum Vitae - Emilio Abella

Page 6

IBM COGNOS PROJECTS

This is a chronological list of projects (short).

CUSTOMER. Activity Sector

Project description, Role,tasks,tools, Project/job description and others (in case it’s relevant) MERCEDES BENZ CAC. AUTOMOTIVE. NETHERLANDS

July 2019 – Actual

Role: Requirements Engineer. Cognos Developer. Cognos Analytics 11 Tools : Cognos Report Studio. Cognos Query Studio. Cognos Framework Manager. Cognos Connection. Tasks: Reporting Requirements gathering. Functional and technical documentation creation. Testing and QA. Project Description: Creation of a set of reports for the Customer Service. AHOLD DELHAIZE. RETAIL. BELGIUM

Jan 2019 – May 2019

Role: Cognos Developer. Cognos Analytics 11

Tools : Cognos Report Studio. Cognos Framework Manager. Cognos Event Studio. Tasks: Reporting Requirements gathering. Functional and technical documentation creation. Modelling and Reporting. System engineer. Security.

Project Description: Creation of a set of reports/dashboard to analyze the supply Chain operations. Reporting on WMS Manhattan oSCI. ODS

MERCEDES BENZ CAC. AUTOMOTIVE. NETHERLANDS

March 2018 – Dec 2018

Role: Requirements Engineer. Cognos Developer. Cognos Analytics 11 Tools : Cognos Report Studio. Cognos Query Studio. Cognos Framework Manager. Cognos Connection. Tasks: Reporting Requirements gathering. Functional and technical documentation creation. Standardization of reporting design. Coordination of reporting tasks with the development team, also as member the development for some of the key reports. Testing and QA.

Project Description: Creation of a set of reports/dashboard to analyze the corporate metrics and KPIs. COGNIZANT. IT SERVICES. SPAIN

December 2017 – March 2018

Role: Application support analyst

Curriculum Vitae - Emilio Abella

Page 7

Tools: Remedy

Tasks: Application support of existing applications. Incident management. Service request handling. Migration support. User access management, …

PAGE GROUP. RECRUITING SERVICES. SPAIN

April 2017 – May 2017l. Consultant Cognos 10.2.2

Role: Cognos Developer.

Tools :. Cognos Connection. Cognos Framework Manager. Cognos Report Studio. Tasks: Key Report Development, Data Modelling (relational, multidimensional), Report standarisation, Bug fixing, New solutions analysis and Prototyping. Performance Tunning. Cognos BI best practices advisor. Frontend Testing

Project Description: Creation of a set of reports/dashboard to analyse the corporate KPIs UBS AG. BANKING. SWITZERLAND

August 2016 – March 2017. Consultant Cognos 10.2.2 Role: Cognos Developer. Frontend tester.

Tools :. Cognos Connection. Cognos Framework Manager. Cognos Cube Designer. Cognos Report Studio. Tasks: Key Report Development, Data Modelling (relational, multidimensional, dynamic cubes), Report standarisation, New solutions analysis and Prototyping. Performance Tunning. External data management. Cognos BI best practices advisor. Frontend Testing (Test case development, sample data creation, test execution). Project Description: ---

Others: Scrumm Methodology. Jira, Confluence, HP Quality Center. Oracle. Linux. FIATC. INSURANCE. SPAIN

January 2016 – April 2016. Consultant Cognos 10.2.1 Role: Consultant and Administrator

Tools : Cognos Report Studio, Framework Manager, Cognos Administration. Project Description: Development of a Cognos Series 7 migration to Cognos 10. Design and implementation of a new Dashboard Architecture.

UCB. PHARMA. BELGIUM

May. 2015 – September 2015. Functional Analysis. Cognos Modeller and Report developer. Cognos 10.2.1 Tools: Framework manager(DQM), Report Studio, Workspace Advanced. Project description: Creation of a dashboard solutionto analyse marketing impact on HCP through a group of electronic channels: website, email, webinar, apps, ...

Remarks: Integration of heterogeneous data: google analytics, external provider files, TIBCO, Veeva, ... Dynamic Query Modelling. Agile Methodology SCRUM.

ARROW ECS. IBM OFFICIAL TRAINING. SPAIN

Curriculum Vitae - Emilio Abella

Page 8

November. 2014 – May 2015. Training Adhoc et consultant Cognos 10.2.1 FP1 Role: Trainer

Tools : Cognos Report Studio, Framework Manager

Project Description: Training to the several companies. Official IBM training. B5259 Cognos 10 Report Studio Advanced, B5261 Cognos 10 Multidimensional Authoring, B5258 Cognos 10 Report Studio, B5252 Cognos 10 Modelling

VF INTERNATIONAL. APPAREL AND CLOTHING. SWITZERLAND April. 2014 – September 2014. Consultancy and Adhoc Training to Key Users. Cognos 10.2.1 FP1 Role: BI trainer and Consultant - Developer.

Tools: Cognos Workspace Advanced and Report Studio (these are the main ones). Project Description: Training to the company Key users to enable them to be the Cognos referent in their respective departments and to enable them to train their respective end users. All done through a series of guided training and supported workshops.

Tasks: Cognos tools training, training methodology implementation. Support to the BI team for other projects, mainly in development advise and improvement to existing projects. BAXTER. PHARMA. BELGIUM

Feb. 2014 – Mar. 2014. Development of a Dashboarding solution for commercial based in Cognos 10.2.1 FP2 Role: BI Consultant and Cognos Senior Developer.

Tools: Data Manager, Framework manager, transformer, Report Studio(online and Active reports). Project Description: Creation of some Dashboards (Report Studio based) with operational information from different systems

(JDE, CRM, and Supply chain). Proof of concept for management approval. Tasks; Analysis, ETL, Metadata modeling (FM and transformer), Dashboards and Report developer (Active Reports included). Remarks: Data Manager. Latest Cognos version 10.2.1 FP 2. SOLVAY (ACTUALLY RENOLIT). CHEMICAL

Oct 2013 – Dec 2013. Collaboration in different project commercial reporting, stock management. Role : Consultant, developer and project manager. Cognos Administration. Tools : Cognos Impromptu, transformer, Powerplay windows and web, Upfront, DataManager. CRH PLC. IRELAND

2013 Jul – Oct 2013 Several Cognos roles due to handover leaving Cognos administrator Role: Cognos Administrator

Tools: Cognos Administration, Framework manager, Report Studio, Transformer. Cognos 8 and Series 7. Project Description: Creation of new reports, modifications to existing ones, admin, helpdesk, training to end users Remarks: Upfront and IWR.

ISS FACILITIES SERVICES. BUSINESS TO BUSINESS. SPAIN 2013 Jan – 2013 Jun. Development of a Dashboarding solution based in Cognos 10.2. Curriculum Vitae - Emilio Abella

Page 9

Role: Dashboards, Report and Metadata developer.

Tools: Framework manager, Report Studio. Cognos 10.2 Project Description: Creation of some Dashboards (Report Studio based) with operational and financial information, detail reports also included. Conditional (dynamic) rendering of the Dashboards depending on the Company level of responsibility.. Adaptation to mobility devices. HR Dashboard

Remarks: Implementation on user security by report. JOHNSON & JOHNSON. PHARMA. FRANCE

2012 Jun – 2012 Dec. Development of a Dashboarding solution based in Cognos 10.1. France Role: Solution Architect, Consultant, analyst and developer. Tools: Framework manager, Transformer, Report Studio, Analysis Studio. Cognos 10.1 Anaylisis and development of a Dashboarding solution for different levels of users. Adhoc Security. Professional Support for other projects/teams.

Remarks: Development of and on the fly security system mixing relational administration of security with no cube refresh needed.

BANCO PASTOR. BANKING. SPAIN

2010 Dec - Apr 2012. Development of an Integrated management solution based in Cognos 8.4.1. Several Microstrategy projects migration to Cognos 8.

Role: Solution Architect, Consultant, developer and project manager. Tools: Framework manager, Transformer, Report Studio, Analysis Studio. Chief of the Cognos Best Practices Office in the Bank (Business Intelligence Competency Center), the main objective was to control all projects developed in Cognos 8 in the Company, advise to other teams of consultancy. IBM SOFTWARE SERVICES. IT

2012 – 2010. Collaboration in many customers as presales, architecture definitions and technical consultancy. Training to customers.

Role: IT Specialist. Cognos services advisor. Support and Training Services. Tools: Series 7, Cognos 8, Cognos 10.

MAPFRE. INSURANCE.

2010 and 2008. Development of several projects during a few months each, especially in risk management and health management.

Role: Consultant, developer and project manager.

Tools: Mainly in Cognos 8 with reporting and analysis, Metrics manager. UNIX/Oracle CAIXA ANDORRANA DE SEGURETAT SOCIAL. PUBLIC ADMINISTRATION. 2008. Social security system. Develomento of a population monitoring system and dashboarding fot the government leaders. Role: Project management and development.

Tools: Scorecarding, analysis and reporting in Cognos 8. Metrics manager. Curriculum Vitae - Emilio Abella

Page 10

BONDUELLE. FOOD

2006. Project development of commercial reporting and stocks management. Role: Project development.

Tools: Cognos Series 7 Impromptu and Powerplay.

SOLVAY (NOW RENOLIT). CHEMICAL.

2003 – 2012. Collaboration in many projects such as Comercial reporting, stock management. Several months of work during many years.

Role: Consultant, developer and project manager.

Tools: Cognos Impromptu, transformer, powerplay windows and web, upfront. ESADE BUSINESS SCHOOL. EDUCATION

2008. Scorecarding and reporting of education services, Tools: Cognos 8 report studio, transformer, FM and Metrics manager. Role: Consultant, developer and project manager.

SANITAS (BUPA GROUP). HEALTH CARE

2003. Analysis, reporting and dashboard of the company operations and providers. Role: Developer.

Tools: Series 7 and Cognos 8. Enviroment: HP-UX, Solaris. CEPSA. ENERGY

2007.Opetations control based in C8. ntegration with to SAP BW and MSAS. Role: Project management and development.

Tools: Analysis and reporting in Cognos 8.

NOVARTIS. PHARMA

2002 – 2005. Project development of several solutions for Financial reporting, stock management, human resources. Integration with Esbasse. Series 7

Role: Consultant, developer and project manager.

Tools: Cognos Series 7 Impromptu and Powerplay (windows and web). HOSPITAL SAN JOAN DE DEU. HEALTCARE.

2007. Project development, training. The main project was a Scorecarding solution. Migration from series 7 to Cognos 8. Tools: Cognos 8. Custom LDAP

Role: Consultant, developer and training services. BASE DETALL SPORT. RETAIL.

2008. dashboard solution for management.

Curriculum Vitae - Emilio Abella

Page 11

Role: Consultant, developer and project manager.

Tools: Cognos 8, FM., Metrics modeling, Metrics manager, report studio. LIST OF OTHER PROJECTS/CUSTOMERS (ASK FOR INFORMATION) Mutua de Terrassa (heatlh care), Cerámicas Saloni (Real State), Laboratorios Labiana (Pharma), NIFCO (Automotive), Cadena Idea Electrodomésticos (Retail), Consorcio Zona Franca (Real State), Caja Burgos (Banking), Mutua General de Seguros (Insurance), Accor Services (Financial), Nostrum (Food), Jack & Jones (Texrtil), Ajuntament de Barcelona (Public Sector), Ecotecnia (Energy), Domecq (Food), Michelin (Automotive), Mobles 114 (Furniture), Santa & Cole (Furniture), Clariana (Chemical), FLUIDRA (water), Beam Global (Food), Casa Tarradellas (Food), Colomer (Beaty), Comercial Martí

(Automotive), Egarsat (Insurance), Frudesa (Food), Gea Penedés (Food), MC Mutual (Insurance), Transportes Pujol (Travel), REGISA (Retail), Laboratios SALVAT (Pharma), SANDO (Real State), VEMSA (Manufacturing), AGFA (Chemical), Conservas Albó (Food), Autoliv (Automotive), Benteler (Automotive), Comunidad Foral de Navarra (Public Administration), Ecolab

(Chemical), FCC (Real State), Peroxidos Farmacéuticos (Pharma), Laboratorios ABBOTT (Pharma), Applus (Automotive), BOMAR (Distribution), CEPEX (water), GlaxoSmithKline (chemical), BBVA (Banking), INCOVAL (Professional services), Instituto Canario de Hemodonación (health care), MAXXIUM ESPAÑA (Distribution), Óptica del Penedés (Health care), Palladium Spain (consulting), Pasaiko Portua (travel), PLASTIVIT (manufacturing), PRONOVIAS (textile), RICOH (Chemical), Damm (Food), VITRI (Manufacturing) …

Contact this candidate