DM

David Merchan

available

Last update: 06.09.2022

BI Consultant

Company: Microstrategy
Graduation: Bachelor of Science Degree in Information Technology from the UPC (Polytechnical University of Catalonia)
Hourly-/Daily rates: show
Languages: English (Full Professional) | Spanish (Native or Bilingual)

Attachments

CV David Merchan.pdf

Skills

Microstrategy, Linux, ICO, data model, analytics, DWH, BO, Actuate, COGNOS, data security, API, SAS, ORACLE, TERADATA, Microstrategy 10.3, SQLServer, Metadata, Microstrategy 9.2.1, Microstrategy 9.0.1, DB2, MicroStrategy 9.0.2, WEB, SQLServer 2008 DB, PL/SQL, Business Objects, DataStage, VB, SQL Server, DB, AS, Microstrategy 7, Oracle 8i, ODBC connections, Sybess, Sybase, VBA, ADO, DAO, ODBC, MSExcel, tecnología ZIP, Crystal Reports, Business Objects 5.0, SDK, SQL, Database, CRM, Siebel, IBM-DOS, MS-DOS, WINDOWS, UNIX, OSF/1, Programming, Basic, Pascal, Modula-2, C, Clipper, DBFast, Visual Basic, PL-SQL, REDSHIFT

Project history

06/2011 - 12/2020
Advisory technical lead BI Consultant
Microstrategy

Green Plains: Upgrade to 2020 update 1.
* Advisory technical lead BI Consultant of the upgrade from 10.4 to 2020 in Windows
environment.
TALGO: Installation of 2019
* Advisory technical lead BI Consultant of the installation of MSTR2019 in Linux environment.
TAP: SSBI and Data Discovery Advisory
* Advisory technical lead BI Consultant for TAP to succeed with MSTR environments.
Assessment Findings, Best Practices, SSBI Roadmap and Strategy Recommendations
NICE: POC SelfService & Dossiers :
* Advisory technical lead BI Consultant of the POC of self-service & Dossiers.
ICO: Data model ecvolution and TX Services implementation
* Advisory technical lead BI Consultant for the data model evolution, implementation of TX
Services technology and review of the security MSTR10.4
Loewe: Installation and Implementation of HyperIntelligence
* Advisory technical lead BI Consultant of Federated analytics, implementation and installation
of HyperIntelligence Technology MSTR2019
Melia: Corporate DWH and Dashboards
* Advisory technical lead BI Consultant of the development of the corporate dashboard for
Melia Hoteles Internacional. Design and implementation of the data model both physical
(WH) and logic (Architecture of the schema of MSTR). Analyse and design of dashboards.
Technical lead of the upgrade de MSTR 10.7 to 11.1 (2019)
Businesss & Decision - ADECCO: Corporate DWH and Dashboards
* Advisory technical lead BI Consultant of 8 people of both MSTR and Business and Decision
for the migration of reports and documents of BO, Actuate and COGNOS a MSTR.
Reviewing the data model migrated from BO, attributes, facts and metrics. Intensive and
Deep use of VLDB properties in order to improve the performance highly. Advisory for the
user's security (privileges, permissions, ACLs and data security)
ADECCO: Corporate DWH and Dashboards
* BI Consultant analysing and developing and evolutive maintenance of the corporate DWH
Data model, both physical (ORACLE) and logical (MSTR 10.4.1) and Dashboarding & URL-
API.
Gas Natural Fenosa: Corporate BI
* BI Consultant for the migration of the Microstrategy environment10.2/10.6 a 10.7 (Linux &
ORACLE)
SAS (Servicio Andaluz de la Salud): Corporate BI
* BI consultant for the migration of the Microstrategy environment 9.2.1m to 10.4. Additional
advisory for the new version (Linux & ORACLE).




BBVA: Data maintenance with TXS
* BI Consultant for the applications development of data maintenance with TX Services
(Microstrategy 9.4.1, TERADATA)
Gas Natural Fenosa: Prosafety
* BI Consultant for the data model evolution logical and physical to self-service DWH
(Microstrategy 10.3, SQLServer)
Gas Natural Fenosa: Optima
* BI Consultant for Dashboarding. Analysing and developing focus on ESRIMaps. Visual
Insight & reporting Services.
PromoCaixa: Botiga BI
* BI Consultant for Suite installation. Analysing and developing the DWH Data model, both
physical (ORACLE) and logical (MSTR) for some Dashboards. Visual Insight.
VHIR (Vall d'Hebron Investigacio I Recerca): Web and mobile Corporate DWH and Dashboards
* BI Consultant Maintenance of the Dashboards.
* BI Consultant for the upgrade from version 9.4.1 a 10.3 (WHH and Metadata in SQLServer)
URL (Universitat Ramon Llull): Corporate DWH and Dashboards
* BI Consultant for Suite installation. And analysing and developing the DWH Data model,
both physical (SQLServer 2012) and logical (MSTR) for some Dashboards. Visual Insight.
Planeta dE Agostini: Upgrade/Migration from 9.2.1 to 10. 0
* BI Consultant Migrating from verions 0.2.1 to 10.0 (Warehouse were GeenPlum and
Metadata SQLServer 2012)
ADECCO: Corporate DWH and Dashboards
* BI Consultant analyzing and developing the DWH Data model, both physical (ORACLE) and
logical (MSTR) for some Dashboards
BBVA: HIGECO
* BI Consultant analysing and developing several iCubes in order to improve the performance
of the reporting environment (Microstrategy 9.2.1, TERADATA)
INDITEX: BI system for de sales area
* BI Consultant analysing and developing several reports for the sales area (Microstrategy
9.0.1, DB2, SQLServer)

02/2009 - 05/2011
BI Consultant
Tecnocom

BI Consultant analyzing and developing several BI solutions for several customers
BBVA : BI Systems with new technologies: iPad
* BI Consultant analysing, designing and developing new Solutions for iPad Technology
Metro Madrid : BI system for the facilities maintenance area
* BI Consultant for developing the solution for the financial control and budget, economic
maintenance of the facilities of the Metro de Madrid (MicroStrategy 9.0.2., Oracle).
Media Brands: Reporting system for the the financial department
* BI Consultant analysing, designing and developing the reporting system of the orders and
invoices via WEB (SQLServer 2008 DB, Integration Services, Reporting Services)
INDITEX: BI system for the sales area
* BI Consultant analysing, designing and developing of several reports and documents for the
sales area (Microstrategy 9.0.1, DB2)

01/2008 - 01/2009
BI Consultant
Arpil; SOGETI

BI Consultant analyzing and developing several BI solutions for several customers




Generalitat de Catalunya-Mossos d'Esquadra: Several Data Marts Maintenance
* BI Consultant for the maintenance of several DMs for the Cos Mossos d'Esquadra de la
Generalitat de Catalunya.(Microstrategy 8.0, PL/SQL, ORACLE)
Aguas de Barcelona : Corporate BI of Aguas de Barcelona
* BI Consultant for the maintenance of the global BI of Aguas de Barcelona (Business Objects
XI, DataStage, Oracle).

01/2001 - 03/2008
BI Consultant
ATOS ORIGIN (Before SEMA GROUP)

BI Consultant analyzing and developing several BI solutions for several customers. Analyzing and
developing several Client/Server applications with VB
Internal education: Microstrategy 8.
* Teacher for internal education of Microstrategy 8.
EXPOFINQUES: Corporate BI
* BI Consultant analysing, designing and developing of the DWH corporate of Expofinques
(SQLServer 2005 con los modules: Motor de BD, IS, AS y RS). Maintenance of DataCycle's
environment.
Generalitat de Catalunya: Departament d'Interior DWH
* BI Consultant developing of several Data Mart (SQL Server as DB, AS and MIS OnVision).
Círculo de lectores: Contingency plan
* Design of the Contingey plan of the DWH environment (ORACLE, Microstrategy 7).
Generalitat de Catalunya: DWH Departament d'Interior
* BI Consultant analysing, designing and developing of overseeing of the recruiting process
for Mossos d'Esquadre (Oracle y Microstrategy).

Gas Natural: DWH corporativo
* BI Consultant for the maintenance of several DM of the corporate DWH of Gas Natural
(Oracle 8i y Microstrategy 5.6/7).

Local Availability

Only available in these countries: Spain
Profileimage by David Merchan BI Consultant from Barcelona BI Consultant
Register