Paul D.

Engaged in R&D to extend my capabilities in:

𝗚𝗖𝗣 𝗗𝗼𝗰𝘂𝗺𝗲𝗻𝘁 𝗔𝗜 - parsing PDF content (semi-structured) and extracting relevant data into structured BigQuery schemas with 100% accuracy

𝗚𝗖𝗣 𝗗𝗮𝘁𝗮𝗳𝗹𝗼𝘄 (𝗔𝗽𝗮𝗰𝗵𝗲 𝗕𝗲𝗮𝗺) - Streaming data pipelines with automated end-to-end integration testing with pytest

𝗚𝗖𝗣 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗛𝘂𝗯

- writing a BigQuery Cost Optimizer App for release on GCP Analytics Hub

- exploring Data Clean Rooms techniques for safe collaborations between Enterprises

𝗦𝗻𝗼𝘄𝗳𝗹𝗮𝗸𝗲 𝗗𝗖𝗠 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 - Snowflake Declarative CI/CD using Snowflake DCM Projects + Flyway + dbt Fusion

I built the Google Cloud Data Architecture for this global software brand:

𝗘𝗻𝘁𝗲𝗿𝗽𝗿𝗶𝘀𝗲 𝗗𝗮𝘁𝗮 𝗟𝗮𝗸𝗲 𝗔𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁𝘂𝗿𝗲: Designed and implemented a centralized Data Lake in Google BigQuery to support business operations across Finance, Product, and Web Traffic domains

𝗗𝗮𝘁𝗮 𝗜𝗻𝗴𝗲𝘀𝘁𝗶𝗼𝗻 & 𝗘𝗟𝗧: Configured Stitch to ingest external source data from Salesforce, HubSpot, and Zuora into BigQuery datasets

𝗗𝗮𝘁𝗮𝗳𝗼𝗿𝗺 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲𝘀: Developed scalable data pipelines using Google Cloud Dataform to build out the core architecture of a custom Customer Data Platform (CDP)

𝗥𝗲𝘃𝗲𝗿𝘀𝗲 𝗘𝗧𝗟 & 𝗗𝗼𝘄𝗻𝘀𝘁𝗿𝗲𝗮𝗺 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻𝘀: Developed Authorized Views in BigQuery to securely surface data for Reverse ETL tools and enterprise integration buses

𝗖𝗹𝗼𝘂𝗱 𝗥𝘂𝗻 𝗠𝗶𝗰𝗿𝗼𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀: Developed and deployed containerized Python microservices on Google Cloud Run to handle backend automation, including cross-platform blob synchronization

𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲𝗱 𝗗𝗮𝘁𝗮 𝗤𝘂𝗮𝗹𝗶𝘁𝘆: Built a standalone Data Quality Checks engine deployed as a Dockerized Cloud Run service to proactively monitor dataset integrity

𝗜𝗱𝗲𝗻𝘁𝗶𝘁𝘆 & 𝗔𝗰𝗰𝗲𝘀𝘀 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 (𝗜𝗔𝗠): Configured and secured GCP environments via IAM, managing Service Accounts, implementing conditional role bindings, and establishing granular BigQuery object-level privileges

𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗥𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴 𝗠𝗼𝗱𝗲𝗹𝘀: Created distinct data mart structures and standardized views to support PowerBI financial reporting

WESTFIELD SPECIALTY INTERNATIONAL is a Lloyds of London Insurance Syndicate. I designed and implemented the Snowflake Data Architecture:

𝗥𝗕𝗔𝗖 𝗔𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁𝘂𝗿𝗲: Designed and implemented RBAC frameworks, using a hierarchy of Functional and Access roles for service accounts, Azure integrations, and business function teams

𝗜𝗔𝗠: Integrated SSO using SAML and automated user and role provisioning through SCIM

𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 𝗣𝗼𝗹𝗶𝗰𝗶𝗲𝘀: Developed Network and Authentication Policies to secure access for interactive users, third-party applications, and service accounts

𝗦𝗲𝗿𝘃𝗶𝗰𝗲 𝗔𝗰𝗰𝗼𝘂𝗻𝘁 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻𝘀: Configured secure integrations for external platforms, implementing OAuth for Oracle (OIC) and Key-Pair authentication

𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗖𝗜/𝗖𝗗 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: Managed schema evolutions, security administration, and account parameters using structured database migration tool Flyway

𝗗𝗮𝘁𝗮 𝗤𝘂𝗮𝗹𝗶𝘁𝘆 & 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻: Developed Data Quality checks with automated alerts for DQ failures

𝗦𝘆𝘀𝘁𝗲𝗺 𝗢𝗯𝘀𝗲𝗿𝘃𝗮𝗯𝗶𝗹𝗶𝘁𝘆 & 𝗔𝗹𝗲𝗿𝘁𝗶𝗻𝗴: Created monitoring tasks to generate email alerts for task metrics, CI/CD application changes (Flyway), and security events like expiring passwords

𝗔𝘂𝗱𝗶𝘁 & 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝗦𝗻𝗮𝗽𝘀𝗵𝗼𝘁𝘀: Established automated security auditing mechanisms to take routine snapshots of active configurations, users, roles, and privilege grants

𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀 𝗘𝗻𝗮𝗯𝗹𝗲𝗺𝗲𝗻𝘁: Built componentized, DRY Snowpark function libraries and Jinja scripts, on internal stages, to automate zero copy cloning isolated env setup for each jira ticket

𝗗𝗮𝘁𝗮 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲𝘀: Used Dynamic Tables to model and transform data into Star Schemas for use by Power BI

𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲𝗱 𝗧𝗲𝘀𝘁 𝗦𝘂𝗶𝘁𝗲: Provided pytest modules to validate and audit configuration and pipelines matches expectations

Snowflake, Data Warehousing and +9 skills