Jonathan E. Russ
Deland,FL
Summary
Data Analytics Consultant specializing in statistical analysis, data visualization, and data mining. Proficient in big data skills. Demonstrated excellence in critical thinking, problem-solving, and communication.
Overview
16
16
years of professional experience
Work History
Data Analytics Consultant
Allstate Insurance National Catastrophe Team
12.2015 - Current
- Developed reports and applications to aid the Allstate National Catastrophe Team's management and support staff, as well as regular business partners
- Utilized Microsoft Visual Studio to create web-based reporting solutions
- Created dashboards, reports, and visualizations to present findings to stakeholders using Tableau.
- Designed and developed queries for data mining activities with SQL Server Management Studio.
- Developed and constructed data mining queries using Oracle SQL Developer
- Developed Dremio queries for effective data mining
- Created dynamic and automated reports using Excel
- Constructed Business Objects queries to facilitate efficient data mining
- Created queries and generated reports using Microsoft Access
- Hosted conference calls and/or in-person meetings to assess the scope of data requests and projects
- Assisted team members with their projects and reports
- Ran Hurricane Projections for senior management.
Reporting Analyst
Pilot Catastrophe Services in association with Allstate Insurance
09.2008 - 12.2015
- Managed daily reporting responsibilities for management team and support staff, encompassing claim counts, location details, and staffing requirements for auto and property catastrophes
- Effectively maintained and utilized a storm tracking program for Field Managers, ensuring access to key information about storm history, claim counts, and potential catastrophe locations
- Designed and implemented Tableau reporting
- Utilized Business Objects to construct queries for data mining purposes
- Created customized queries and reports in Microsoft Access to enhance data analysis
- Conducting conference calls and in-person meetings to define the scope of data requests and projects
- Constructed database search queries through SQL Server Management Studio for data extraction
Education
Associates Degree - General Studies (emphasis on business)
Northern Virginia Community College
Woodbridge, Virginia05.2001
Advanced Studies High School Diploma -
Brooke Point High School
Stafford, Virginia06.1998
Skills
- SQL Server Management Developer
- Oracle SQL Developer
- Tableau Dashboard Developer
- Dremio Data Lake Developer
- Microsoft Visual Studio Developer
- Business Objects Developer
- Data Extraction
- Data Mining
- Data Validation
- Data Analysis
- Report Preparation
- Microsoft Access
- Big data technologies
- Mapping techniques
Recognition
2020, Allstate Golden Compass Award
Timeline
Data Analytics Consultant
Allstate Insurance National Catastrophe Team
12.2015 - Current
Reporting Analyst
Pilot Catastrophe Services in association with Allstate Insurance
09.2008 - 12.2015
Associates Degree - General Studies (emphasis on business)
Northern Virginia Community College
Advanced Studies High School Diploma -
Brooke Point High School
Similar Profiles
Ryan ScheetsRyan Scheets
Claims Service Leader at Allstate Insurance, National Catrashophe TeamClaims Service Leader at Allstate Insurance, National Catrashophe Team
Sharlene FallsSharlene Falls
Property Adjuster at Allstate Insurance Company / Pilot Catastrophe SvcProperty Adjuster at Allstate Insurance Company / Pilot Catastrophe Svc
Paul GaylesPaul Gayles
Senior Insurance Team Lead at National General Insurance An Allstate CompanySenior Insurance Team Lead at National General Insurance An Allstate Company