Ver categorias
Explorar
Fiverr Pro
Português
$
USD
Pablo P.
@pablodpavon
Data Analyst and Business Analyst, SQL, Python, Power BI
Alemanha
Inglês, Espanhol, Alemão
Sobre mim
I'm a data and business analyst based in Berlin with 10+ years in banking, automotive e-commerce (Auto1 Group), marketing analytics and insurance. I turn messy data into clear answers: Looker Studio and Google Sheets dashboards, revenue and cash forecasts, pricing and unit economics, customer analytics (cohorts, RFM, churn) and market sizing. I work AI-assisted for speed, and every delivery is checked before it reaches you: reconciled totals, tests and a second review. Scope and deadline are agreed in writing before I start.
Habilidades
Pablo P.
offline •
Conheça meus serviços
Painéis de dados
I will build a looker studio marketing dashboard from your ads and sales data
Orçamento e Previsão
I will build a revenue and cash flow forecast model for your online store
Experiência profissional
Senior Business Analyst, IT & Processes
Confidential
Nov 2023 - Present • 2 yrs 10 mos
Insurance company in Germany. - Coordinate the business analysis workstream of a legacy mainframe decommissioning program: mapping and routing data to an archive repository (integrated with Guidewire), a modern policy management platform, and OneTrust for GDPR consent data (downstream Salesforce Marketing Cloud). - Authored functional specifications for a contract viewer: UI structure, backend-to-UI data mapping, search validation rules and role-based access. - Co-authored the company's GDPR data deletion and blocking concept (Art. 17/18, German retention periods) across data warehouse, SAP FI, document repositories and backups. - Team member on the design and delivery of the customer Self-Service Portal. - Authored a proposal for multilingual customer service combining AI translation with certified-translator validation.
Senior Strategy + Data Analyst
Foundry
Oct 2021 - Nov 2023 • 2 yrs 1 mo
- Designed and prototyped a machine-learning model for employee attrition risk scoring; the methodology was adopted as the foundation for the company's internal retention scoring system. - Built behavioral segmentation and churn analysis models in Python to inform marketing campaigns and customer lifecycle decisions. - Established automated BI reporting giving executives visibility into marketing performance and resource allocation.
Pricing Intelligence Analyst
Confidential
Oct 2020 - Nov 2021 • 1 yr 1 mo
Auto1 Group, Berlin (European used-car marketplace). - Analyzed pricing across Auto1's 9-country European used-car marketplace to inform sourcing decisions: which models to buy, in which markets, at which time of year, and where to sell them. - Built real-time pricing and inventory dashboards in Tableau for regional managers across European markets. - Standardized data pipelines and reporting templates supporting commercial operations.
