Leon P.

If your reporting depends on manually exporting CSV files, maintaining complex spreadsheets, or pulling data from several different systems, I can help automate it. I build reliable reporting and data automation systems that connect APIs, business platforms and databases to tools such as BigQuery, Google Sheets and Looker Studio. A typical solution might look like: API / Business System → Automated Data Pipeline → BigQuery → Looker Studio / Sheets I have more than 15 years of experience building data, reporting and automation systems, with over $200K earned on Upwork and a 100% Job Success score. I’ve built reporting solutions for major media agencies and brands including Europcar, Samsung and Intel, as well as ecommerce businesses, healthcare companies, agencies and other organisations that need reliable reporting across multiple data sources. I also built a reporting platform used by media agencies to consolidate large volumes of marketing and analytics data into unified dashboards. What I can help with • Connecting APIs and third-party platforms • Automating manual reporting and spreadsheet processes • Building API → BigQuery data pipelines • Designing and modelling BigQuery reporting datasets • Writing SQL queries and reporting views • Building Looker Studio dashboards • Replacing unreliable third-party data connectors with controlled pipelines • Troubleshooting existing reporting systems and broken integrations • Automating scheduled imports using Google Cloud Functions and other serverless tools • Adding AI to reporting and automation workflows where it provides a genuine business benefit Platforms and data sources I regularly work with data from platforms including: Google Ads, Meta/Facebook Ads, Amazon Seller & Advertising, Shopify, Google Analytics, CRMs, marketing platforms and custom APIs. I also work extensively with BigQuery, SQL, Google Cloud, Cloud Functions, PHP, webhooks, Google Sheets and Looker Studio. Examples of recent work • Built automated marketing reporting pipelines that collect data from multiple APIs into BigQuery and power Looker Studio dashboards used by agency teams. • Created serverless Google Cloud pipelines that retrieve ecommerce data automatically each day and transform it into clean reporting datasets. • Built Amazon Seller API reporting systems covering sales, inventory, advertising and operational performance. • Created reporting systems that combine CRM, marketing and operational data so management can see performance in one place. • Built automation tools that use internal business data to make changes to Google Ads campaigns automatically. I’m equally happy taking over an existing reporting setup that has become unreliable or difficult to maintain, or designing a new solution from scratch. Many of my clients work with me long term to maintain their pipelines, add new data sources and continue developing their reporting as their business changes. If you have data spread across APIs, spreadsheets or different business systems and want to turn it into reliable automated reporting, I’d be happy to discuss the best way to approach it.