Participating in Cohort 6 of the Climatebase Fellowship, the climate career accelerator.

Responsible for full data pipeline builds (DBT/Redshift) from Business requirements/planning, design, data structure organization, accuracy, QA, ETL/ELT, and Tableau reports build out.

BIE supporting Amazon Music Finance reporting and Cost Savings projects. Utilizing AWS: Redshift, S3, and Athena. Visual automated reports using Amazon Datanet ETL and Tableau.

BIE supporting transportation initiatives around capacity planning and forecasting. Utilizing Redshift, S3, Quicksight, and Datanet ETL Scheduling.

BIE with Alexa Smarthome BI supporting weekly/monthly/quarterly reporting, on-call end user support, research/development, adhoc requests, and analytics/insights. Developed and put into production new model to predict customers engagement classification using R (Logistic Regression Model). Redshift, ETLM Datanet, Tableau, R, Python.

Support for company wide analytics function assisting multiple teams with analytical needs. Customer Segmentation, Claims Litigation support, Pricing Multivariate Data support, and Claims Reserving reporting. Microsoft SQL Server, Tableau, SAS.

Supporting The Everett Clinic EBI function. Microsoft SQL Server, R.

ETL support for data analytics projects for the Claims and Customer Service Departments. Analysis and modeling using SAS, Statistica, and R statistics applications.

Supervised and worked in conjunction with the BI Research team on complex projects. Examples include Ratestudy support for P&C lines. Multivariate data was prepared through high level programmatic verification. Premium at Current Rate Level was developed and maintained. Data analytics projects on claim activity and claims handling. Data support for Claims litigation.

Supported the BI group and the company business information requests. Part of BI team that developed the EDW and data marts as part of new system integration. Developed new reports as part of new system integration. Supported complex projects for ratestudies, litigation, compliance, and competitve analysis.

Supported the Actuarial function with data preparation for Loss Reserving, Ratestudies, and adhoc studies. Improved efficiencies and automation of Auto line of business indications. Helped prepare filings for the OIC.