Key Technologies: SQL · Python · Django · Dagster · BigQuery

- Ongoing...
- Current work is centered around building automated data pipelines, cloud-based analytics solutions, and scalable workflow orchestration.

Key Technologies: SQL · VBA · Excel · BigQuery · Google Cloud · SAS

- Spearheaded the transformation of our legacy SAS projections process, aiming for automation. This involved rewriting the entire process using SQL and creating a user friendly front-end interface in Microsoft Excel and Django.
- Performed statistical analyses on book-of-business-level data to validate and inform the use of critical underwriting factors during the request-for-proposal (RFP) process.
- Developed a stand-alone claims intake model that standardized external claims files, reducing processing times from days to minutes within 3 months through automated mapping and Google Cloud integration.
- Provided comprehensive financial and data modeling support to the Pricing and Analytics team, as well as various functional areas across the organization.
- Facilitated ongoing model enhancements through detailed QA testing via SQL and edge case reporting, significantly optimizing the analytics workflow and reducing processing time.

Key Technologies: SQL · IMDM · VBA · Excel · Tableau

- Executed high-quality data analysis using SQL and Python, with a focus on normalizing operations, enhancing performance, and maintaining data integrity.
- Conducted extensive quality assurance audits to verify accurate file processing by both peers and company algorithms, including machine learning models.
- Proposed strategic adjustments to enhance a company-defined algorithm, streamlining record remediation operations.
- Monitored and administered team SharePoint sites, optimizing workflow efficiency and fostering employee engagement.