Jared White

Led end-to-end data pipeline builds using DBT/Redshift, ensuring accuracy and efficiency.

* Developed Tableau reports for data visualization, aiding in decision-making processes.

* Collaborated with cross-functional teams to meet business requirements and improve data structure organization.

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.

Central Washington University

Bachelor of Science - BS, Mathematics - Actuarial Science * (1998 - 2001)