Beau P
Founder of Ops Tech Solutions OATS
Habilidades

Conheça meus serviços

Portfólio
Experiência profissional
Data Engineer
Navita Health • Período integral
Jul 2023 - Present • 3 yrs 3 mos
Responsible for designing and operating production ETL pipelines that extract data from PostgreSQL, transform and validate it using Python/pandas and SQL, and load reporting-ready datasets into BigQuery. Built automated AWS-based infrastructure using Docker, ECS/Fargate, ECR, EventBridge, Secrets Manager, and CloudWatch to replace manual CSV and spreadsheet workflows. Developed and maintained BigQuery data models supporting Looker Studio dashboards across client, appointment, transaction, treatment, insurance, and financial reporting. Implemented automated scheduling, error handling, retries, logging, row-count validation, and email monitoring for reliable production data pipelines. Manage Git/GitHub-based development and deployment workflows and troubleshoot data quality issues across source databases, ETL processes, BigQuery, and downstream reporting.
Founder
Google • Autônomo
Oct 2022 - Present • 4 yrs
Founded and lead Ops and Tech Solutions (OATS), a data analytics and business intelligence company specializing in transforming raw data into actionable insights. I help organizations streamline reporting, automate data workflows, and improve operational visibility through custom dashboards and data solutions. My work includes building interactive dashboards in Looker Studio, developing SQL queries and data pipelines in Google BigQuery, automating data processing, and integrating data from various sources into centralized reporting systems. Key Skills & Services: - Business Intelligence & Data Visualization - Looker Studio Dashboard Development - SQL & Google BigQuery - Data Cleaning, Transformation & Modeling - Reporting Automation & ETL Workflows - KPI Tracking & Performance Analytics - Healthcare Data Analytics & EHR Reporting - Custom Reporting Solutions for Leadership and Operations
Founder
• Autônomo
Oct 2022 - Present • 4 yrs
Founded and lead Ops and Tech Solutions (OATS), a data analytics and business intelligence company specializing in transforming raw data into actionable insights. I help organizations streamline reporting, automate data workflows, and improve operational visibility through custom dashboards and data solutions. My work includes building interactive dashboards in Looker Studio, developing SQL queries and data pipelines in Google BigQuery, automating data processing, and integrating data from various sources into centralized reporting systems. Key Skills & Services: - Business Intelligence & Data Visualization - Looker Studio Dashboard Development - SQL & Google BigQuery - Data Cleaning, Transformation & Modeling - Reporting Automation & ETL Workflows - KPI Tracking & Performance Analytics - Healthcare Data Analytics & EHR Reporting - Custom Reporting Solutions for Leadership and Operations