Acerca de Alan
I help organizations deliver big from complex data, even when resources are limited.
I’ve worked extensively with large volumes of data, structured or not. I've gone from exploratory analysis to the pipeline-building work that supports it, investigating anomalies and delivering clear dashboards and reports, often under tight deadlines.
I’m currently on a long-term leave from my company and eager to help teams navigate challenging data.
Inglés
Bilingüe o nativo
Español
Competencia profesional completa
Francés
Competencia profesional completa
Portugués
Bilingüe o nativo
Catalán
Competencia profesional básica
Acepta trabajo presencial
Barcelona (hasta 50 km)
Experiencia
- RevolutData AnalystBANCA & SEGUROSmarzo de 2022 - Hoy (4 años y 5 meses)• * Automated different reconciliation processes in the finance department and provided accounting reconciliation queries for audit compliance• * Helped implement and maintain the company's accounting subledger with volume > 500 billion rows• * Led one large accounting reconciliation project with > 5M GBP financial impact• * Created multiple dashboards in Looker + source queries for production stability monitoring• * Implemented 2 ETLs end to end (from SQL query to python processing and airflow integration)• * Led data analysis and helped define finance data flow for multiple product onboardings• * Managed two direct reports (junior/mid analysts) on onboarding and reconciliation projects• * Created a series of training materials as support for Data Analysts/Financial Controllers in the finance department
- CaraveloInsights AnalystVIAJES & TURISMOnoviembre de 2018 - febrero de 2022 (3 años y 3 meses)Barcelona, Spain• * Leading role in implementing the company's new data stack (AWS, Postgres)• * Implementation and maintenance of client-facing dashboards and automated reports• * Over 50% reduction in reporting + analytics response time with automated processes and streamlined analytics• * QA + product debugging based on product data analysis• * Training and support work to colleagues and clients, helping them self-serve
- AgeRio - Agência Estadual de FomentoCredit Risk AnalystBANCA & SEGUROSoctubre de 2015 - junio de 2018 (2 años y 8 meses)Rio de Janeiro, State of Rio de Janeiro, Brazil• * Financial analysis of firms and projects, from small (Sales < 1 M BRL) to large (Sales > 500M BRL). Over 70 Credit Risk Rating and Market Analysis reports made, for over 20 mi BRL in loans• * Data analysis and financial modeling in Excel, including scenario based studies, stress tests and DCF analysis• * Receivable analysis and analysis of innovation projects
Recomendaciones
Sé el primero en recomendar a Alan
Ayuda a este freelance a destacar compartiendo tu experiencia.
Estos perfiles de freelance también coinciden con tus criterios
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
Formación
- Scouting and Game Analysis Specialist Introduction to Talent Identification in FootballScouting and Game Analysis Specialist Introduction to Talent Identification in Football
- Full Time MBACoppead UFRJ2017Full Time MBA