SQL [SEQUEL]

I have utilized SQL extensively in my professional roles to analyze data, optimize workflows, and deliver actionable insights. These projects showcase my ability to turn raw data into meaningful insights and practical solutions through SQL. Highlights include:

  • Developing SQL scripts at DaVita Kidney Care to analyze customer and insurance data, supporting cost-effective care decisions and stakeholder reporting.

  • Creating a hardware tracking database and generating leadership reports using SQL and Tableau for RSU03 School District.

  • Streamlining data retrieval and reporting processes with SQL-based repositories at Cobscook Community Learning Center.

Building Blocks: PostgreSQL Templates for Seamless Onboarding

This project showcases a PostgreSQL script designed as a reusable template for onboarding new team members in a data analytics or ETL-focused department. The script, written for PostgreSQL and deployed on the Coginiti platform, demonstrates foundational ETL processes such as creating temporary tables, using conditional logic with CASE statements, and efficiently transferring data into a main table. It also includes cleanup operations to ensure a streamlined workflow.

The code is both practical and instructional, serving as a clear guide for new hires to understand key concepts in ETL workflows. By implementing this script, the team gains a reliable resource for standardizing table updates and ensuring data consistency while promoting best practices in SQL development and platform utilization.