Marcos Pérez Collado
Business Intelligence Developer
Barcelona
Summary
After completing a specialized web development course, I worked as a Full-stack developer for 3 years. I came across a Power BI project and decided to change my path and focus on Business Intelligence onwards. After 6 years of working of multiple projects across different markets and environments I'm looking for a relocation in Germany to keep growing personally and professionally
Overview
7
7
years of professional experience
5
5
years of post-secondary education
4
4
Languages
Work History
Senior BI Developer
Global Shares, A JP Morgan Company
Barcelona, Spain
12.2022 - Current
End-to-end project developments from kickoff and requirement meetings to dashboards creations, through ETL and data modeling.
Senior BI Developer
Merkal Calzados
Barcelona, Spain
04.2022 - 12.2022
- Responsible of the BI solution, analysis and development
- Development and maintenance of the ETL based on Azure and SQL Server databases
- Management of the SSAS Tabular models that are the Power BI reports data sources
- Development and maintenance of Power BI reports
- Administration of Power BI Service reports, datasets, permissions and workspaces.
BI Consultant
Necsia
08.2020 - 04.2022
- Projects responsible and development on all stages of end-to-end BI projects from different sectors
- Maintenance and development of SSIS packages and ETL on SQL Server databases
- Management of SSAS tabular and multidimensional models with DAX and MDX respectively
- Reporting with Power BI and SSRS
- Two server migrations from SQL Server 2008 to 2019 and upgrade all it's components.
BI Consultant
Bismart
01.2019 - 08.2020
- Development on all stages of end-to-end BI projects from different sectors
- Maintenance and development of SSIS packages and ETL on SQL Server databases
- Management of SSAS tabular and multidimensional models with DAX and MDX respectively
- Reporting with Power BI and SSRS.
Back-end & BI developer
Fujitsu Spain
12.2017 - 01.2019
- As a BI Developer: ETL responsible with Oracle, DB2 and MySQL data sources
- Management of SSAS tabular models with DAX
- Reporting with Power BI
- As a Back-end Developer: Internal webpage responsible programmed with Yii framework of PHP with MVC structure.
Education
Full-stack developer - undefined
Barcelona Activa
01.2015 - 04.2016
CFGS commercial management and marketing - undefined
Centre d’estudis Prat
01.2014 - 04.2015
Technological baccalaureate - undefined
IES Bernat Metge
01.2011 - 04.2013
Skills
SSMS/T-SQL
Timeline
Senior BI Developer
Global Shares, A JP Morgan Company
12.2022 - Current
Senior BI Developer
Merkal Calzados
04.2022 - 12.2022
BI Consultant
Necsia
08.2020 - 04.2022
BI Consultant
Bismart
01.2019 - 08.2020
Back-end & BI developer
Fujitsu Spain
12.2017 - 01.2019
Full-stack developer - undefined
Barcelona Activa
01.2015 - 04.2016
CFGS commercial management and marketing - undefined
Centre d’estudis Prat
01.2014 - 04.2015
Technological baccalaureate - undefined
IES Bernat Metge
01.2011 - 04.2013
Similar Profiles
Fhelrose HibayaFhelrose Hibaya
Business Banking Specialist II at JP Morgan Chase Bank, N.A. Phil. Global Service CenterBusiness Banking Specialist II at JP Morgan Chase Bank, N.A. Phil. Global Service Center
Hilal Ahmad KhanHilal Ahmad Khan
Card Fraud and Claims Analyst at Teleperformance Global Services Private Ltd, JP Morgan Chase & CoCard Fraud and Claims Analyst at Teleperformance Global Services Private Ltd, JP Morgan Chase & Co
Karanveer SinghKaranveer Singh
Product Manager - Banking at JP Morgan Chase & CompanyProduct Manager - Banking at JP Morgan Chase & Company