Semi professional Basketball player
José Coelho
Business Intelligence Analyst
Lisbon
Summary
Business Intelligence Analyst with 3 years providing employers with valuable and actionable data to drive profit growth and enhancing departments efficiency. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Eager to learn and positively impact others
Overview
6
6
years of professional experience
3
3
Languages
Work History
Business Intelligence Analyst
Banco Atlântico Europa
09.2021 - Current
- Increased understanding of customer behavior patterns by analyzing big volumes of data
- Migration and implementation of regulatory reports ( Excel to BI framework )
- Data mart construction from scratch
- Data warehouse optimization - correcting metrics, creating new metrics in factual tables,adding new descriptive data to dimension tables
- Work with audit teams to close recommendations from regulators (internal and external)
- Participated actively in stakeholder and interdepartmental meetings during the development of various projects
- Enhanced data quality by conducting thorough analyses, identifying discrepancies, and providing recommendations for improvement - Finding duplicates, columns not being properly loaded, wrong logics
- Optimized database performance through regular maintenance, query optimization, and index tuning - using the "Orchestrator" ETL framework
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Supported strategic decision-making processes by delivering timely and accurate insights from complex datasets
- Tickets resolution via JIRA platform
Commercial Credit Card Analyst
Banco Atlântico Europa
08.2020 - 08.2021
- Managed cards (debit & credit) operational flow
- Minimize error by designing task automation with developers
- Provide support to commercial areas
Trade Finance Analyst
Banco Atlântico Europa
02.2018 - 07.2020
- Enhanced trade finance processes by streamlining workflow and implementing automated solutions.
- Assisted in the implementation of a new trade finance platform, enhancing operational efficiency and reducing transaction timeframes.
- Managed critical documentation related to import/export activities, safeguarding against potential legal issues or delays.
- Managed the whole lifecycle inherent to letters of credit
Education
Master of Science - Information Management With Specialization in BI
NOVA IMS - Information Management School
Lisbon, Portugal 04.2001 -
Bachelor of Science - Management
ISCTE Business School
Lisbon,Portugal 04.2001 -
Bachelor of Science - European Business Studies
RISEBA University
Riga,Latvia 04.2001 -
Skills
- Data Visualization
- SQL Programming
- ETL development
- Data Quality Management
- Data Modeling
- KPI Monitoring
- Data dashboard & reports design
- Data Warehousing
- Business Intelligence Analysis
- Database Management
- Python Programming
Interests
Music
Reading
Dogs & Cats
Software
Power BI
SSMS
SSIS
SSRS
Timeline
Business Intelligence Analyst
Banco Atlântico Europa
09.2021 - Current
Commercial Credit Card Analyst
Banco Atlântico Europa
08.2020 - 08.2021
Trade Finance Analyst
Banco Atlântico Europa
02.2018 - 07.2020
Master of Science - Information Management With Specialization in BI
NOVA IMS - Information Management School
04.2001 -
Bachelor of Science - Management
ISCTE Business School
04.2001 -
Bachelor of Science - European Business Studies
RISEBA University
04.2001 -
Similar Profiles
Cláudio De Sonda DiogoCláudio De Sonda Diogo
Assessor Na Direcção De Meios De Pagamentos at Banco Millennium AtlânticoAssessor Na Direcção De Meios De Pagamentos at Banco Millennium Atlântico
Yuri ContreirasYuri Contreiras
Intern at Bank Millenium AtlânticoIntern at Bank Millenium Atlântico
DILO DE SÁDILO DE SÁ
MANAGING DIRECTOR at Striped-Horse Atlântico LdaMANAGING DIRECTOR at Striped-Horse Atlântico Lda