p
pablodpavon

Pablo P.

@pablodpavon

Data Analyst and Business Analyst, SQL, Python, Power BI

Alemania
Inglés, Español, Alemán
Parte de la información aparece en idioma inglés.
Sobre mí
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.... Lee más

Habilidades

p
pablodpavon
Pablo P.
desconectado • 

Revisa mis servicios

Panel de datos
I will build a looker studio marketing dashboard from your ads and sales data
Presupuesto y previsiones
I will build a revenue and cash flow forecast model for your online store

Experiencia laboral

Confidential

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.

Foundry

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.

Confidential

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.