About 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.
English
Native or bilingual
Spanish
Fluent
French
Fluent
Portuguese
Native or bilingual
Catalan
Conversational
Can work on-site
Barcelona (up to 50km)
Experience
- RevolutData AnalystBANKING AND INSURANCEMarch 2022 - Today (4 years and 3 months)• * 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 AnalystTRAVEL AND TOURISMNovember 2018 - February 2022 (3 years and 3 months)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 AnalystBANKING AND INSURANCEOctober 2015 - June 2018 (2 years and 8 months)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
Recommendations
Be the first to recommend Alan
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
- 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