Beau P
Founder of Ops Tech Solutions OATS
Competenze

Consulta i miei servizi

Portfolio
Esperienza lavorativa
Data Engineer
Navita Health • Full time
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 • Lavoratore autonomo
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
• Lavoratore autonomo
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