About José Luis
I consider myself a full-stack BI professional as I have experience and knowledge in the entire range of Business Intelligence development, from the data modeling, data warehousing, ETL, reporting and dashboards analytics.
Proven ability to quickly learn, utilize abd implement new tools and technologies in BI development as well as willing to learn new tools to enhance my skills.
Spanish
Native or bilingual
English
Conversational
Can work on-site
Alicante (up to 50km)
Experience
- KPMG - Supporting EUIPOBUSINESS INTELLIGENCE ANALYSTFebruary 2023 - Today (3 years and 5 months)Alicante, SpainMigration project from SAP Business Objects Reports to Microsoft Power BI as the primary focus of the role.Single-handedly managed all aspects of the migration process due to team downsizing (I'm the only one). I developed the EUIPO DWH from scratch, covering all stages including identifying reporting needs, database architecture design, ETL processes, monitoring, and ensuring data quality and integrity providing invaluable insights into office business processes. Excelled in unofficial duties, demonstrating adaptability and initiative in handling diverse tasks beyond the scope of the role to support team efficiency and project success.• Proficient in Microsoft Power BI (Power Query, M, DAX, Optimization of Datamart preparation, successfully achieved using SQL and OLAP functions),• SAP Business Objects Reports,• SAP Business Object Universes IDT (Information Design Tool) y UDT (Universe Design Tool).• SAP Business Objects Data Services BODS (ETL - I `m the main EUIPO's - DWH architect),• Experienced in Python and Pandas for data analysis and manipulation.• Extensive experience in data analysis, visualization, and reporting.• Strong problem-solving skills with a track record of delivering solutions to complex challenges.• Exceptional adaptability and ability to thrive in fast-paced environments.• Contributed to the design and implementation of the Balanced Scorecard (BSC) for performance management and strategic alignment (developed in Power BI). All aligned with SCRUM methodology. Responsibilities: Migration of current SAP BO reports to Microsoft Power BI. Some periodical tasks: upload files, refresh BO publications, fix bugs, and publish reports on the organization's web portal. Stack: SQL, SAP BO Data Services Designer, Microsoft Power BI, PLSQL Oracle, Oracle, Business Intelligence, Agile, Python, Scrum, SAP BO Universes Designer, SAP BO Reporting, Data Governance.
- Almaviva -Supporting EEASBUSINESS INTELLIGENCE ANALYSTJanuary 2021 - January 2023 (2 years)BelgiumIn Brussels I worked at EEAS preparing and maintaining HR reports. I was responsible for access grants and securing the reports. I fully developed a budgetary dashboard in Qlik Sense, gaining strong knowledge of ABAC (European Commission Financial System).Key tasks:Developed and maintained BI reports and dashboards (SAP BO / Qlik Sense / Excel).Designed universes in SAP BO (IDT/UDT) and administered SAP CMC.Administered Qlik Sense (QMC/HUB), managing user access and permissions.Data warehouse: architecture, schema design, performance improvements.Data and business analysis, proposing solutions for new requirements.ETL and data integration: SAP BO Data Services, PL/SQL, PowerShell scripting.Ensured data quality, integrity, monitoring, and documentation (impact assessments, migrations, validation rules, user guides).Used SAP Information Steward for lineage and impact analysis (POC at EEAS).Strong SQL (DDL/DML) and PL/SQL skills; scripting (PowerShell, DOS).Experience with Agile and Scrum.Knowledge of institutional systems: ABAC, EASREFN, SYSPER (DB level).Responsibilities:Solved incidents, documented inconsistencies, improved and developed reports and dashboards, created DataMarts to support development.Stack: SQL, SAP BO Data Services, Qlik Sense, PL/SQL Oracle, SAP BO, Qlik View, Oracle, BI, Agile, Informix, Python, Scripting, Data Governance.
- AltiaSENIOR BI ANALYST-CONSULTANTOctober 2011 - October 2020 (9 years)Alicante, SpainI started at EUIPO 15 years ago when data governance was missing. Many users requested personal SQL queries from DBAs, often with inconsistent results. My first task was to assess this issue and propose a solution. I created a VB tool where users could run SQL and export data to Excel, reducing DBA workload. However, the transactional DB was still overloaded.By analyzing frequent queries, I designed and built the official DWH from scratch. Once stable and performant, it became the main data source for the CGS department. Together, we developed a new "dashboard" DB, even more optimized, providing key data to directors. I ensured data from various systems (DBs, flat files, SAP ECC, web, logs, FTP, etc.) was integrated, harmonized, and ready for reporting, applying data governance rules. These datasets support major reports used for decision-making.Responsibilities:DWH architecture, schema design, performance improvements.ETL, data migration/integration (SAP BO Data Services, PL/SQL, PowerShell).Designed dashboards and reports (SAP BO, Power BI), business/data analysis.SAP Information Steward for lineage, governance, validation rules.Balanced Scorecards, KPIs, forecasting, statistical analysis, strategic plans.Ensured data quality, monitoring, integrity.SAP BO suite: ETL (Data Services Designer), reports (Deski/Webi), Lumira, Xcelsius, CMC admin.SQL (DDL/DML), PL/SQL, scripting (PowerShell).Front/back-end software in Visual Basic.Experience with Agile/Scrum.Stack: SQL, PL/SQL, BI Tools, SAP BO, Power BI, Qlik Sense, SAP BODS, ETL, Dashboards, Forecasting, Stats, Optimization, Shell Scripting, Agile, Data Governance.
Reviews
Recommendations
Be the first to recommend José Luis
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- TituloInstituto Tecnológico de Toluca2000Ingeniería en Sistemas Computacionales