David Grimm
Saint Joseph,MO
Summary
Results-oriented professional with over 16 years of experience in analysis, database tools creation, report and dashboard development, and report automation. Highly skilled in effectively communicating technical information to diverse audiences. Exceptional presentation and interpersonal abilities. Proficient in presenting to management, peers, and internal and external departments.
Overview
27
27
years of professional experience
1
1
Certification
Work History
HRIS Analyst
Triumph Foods
St. Joseph, USA
10.2016 - Current
- Compensation – File Creation, Implementing, Updating
- Lead for data ETL for switch from SF to ADP HR systems
- Working knowledge of HR, Recruiting, Benefits, Health Services and OSHA recordables analytics
- Consolidate data between app producer and company
- Directed the LMS development of the maintenance department
- Overhauled the audit reports for the maintenance department
- Accelerated and advanced the production of several daily, weekly, monthly, and quarterly reports for management, upper management, and executive teams
- Reconcile data for quarterly and yearly bonus structure
- Reconcile data for annual merit program
- Configuration of compensation module
- Configuration of performance management module
- Importing large updates for the HCM system
- Creation of Benchmarking tool for management to use
- Created tools for quarterly/annual merit and bonus programs
- Assist with benefits for management/management support and production employees
- Experience with ADP HR, payroll, time, LMS, compensation, performance, recruiting management, and reporting
- Experience with Success Factors in the following modules: Compensation, SAP Jam, Learning, Recruiting, Time and Attendance (KRONOS), Onboarding, Reporting, and Admin Center
- Designed and developed courses on Microsoft Excel
Associate Actuarial Analyst - Pricing P&C, A&H
Swiss Re
Overland Park, USA
02.2007 - 07.2016
- Delivered Rate Reviews for Worker’s Compensation line of business
- Performed Business Analyst duties for Worker’s Compensation and Medical Expense group updating and testing software and investigating and fixing issues with software that was communicated by the Underwriters
- Streamlined and updated reserve analysis for the Worker’s Compensation line of business
- Extensive experience with database creation and maintenance
- Called upon from numerous areas to advise and/or in the creation of reports to be presented on the corporate level
- Evaluated numerous reports that are presented at the Actuarial Workshop on a yearly basis
- Aligned and directed co-workers located in India
- Quantified and interpreted data in the sale of the Worker’s Compensation line of business
- Investigated and Recreated a TPA’s 'black box' pricing tool that was being used by the Worker’s Compensation line of business so that the pricing would be better understood and programming errors could be found
- Creation of push button type reports using excel VBA to see data in several different manners
- Automate reports, so that when data was updated the reports would be updated
- Creation of dashboards for the use of the A&H team members and management
- Provide data and reports to upper management and executive management of Swiss Re
- Experience with Business Objects and programing in R
- Analysis of reports and made suggestions to management
Actuarial Technician
Cameron Mutual Insurance Company
Cameron, USA
06.2000 - 02.2007
- Produced and developed rate reviews and competitor’s comparisons for twenty-two lines of personal and commercial lines of business for two states
- Performed Business Analyst duties of updating and testing updates and investigating and fixing issues that the Underwriters communicated
- Presented rate reviews to be discussed by the rate review committee
- Implemented rate changes on the company network
- Drafted correspondence to the state insurance departments concerning rule and rate revisions and serve as the liaison for inquiries pertaining to such changes
- Responsible for the quarterly calculation of the company’s loss reserving data
- Developed numerous product quality reports used by internally and externally
- Developed the rate level tiering for the personal auto conversion to Attract with Claims
- Collaborated on the development of four lines of business for entry into a new state
- Developed new territories for the Earthquake Program
- Coordinated the consolidation of 48 territories into 15 territories and calculated the appropriate rates for the new territories
High School Teacher
08.1997 - 05.2000
- Instructor of four levels of mathematics
- Responsible for maintaining an accurate and current record of students’ grades and attendance
- Assisted in coaching Freshman Football, Varsity Football, and Varsity Track
- Collaborated on the development of student's individual education programs
- Developed lesson plans, worksheets and tests
Education
B.S. - Mathematics
Missouri Western State College
St. Joseph, MO05.1997
Skills
- Dashboards/Reporting
- Problem-Solving
- Adaptability
- Analytical Skills
- SQL and Databases
- MS Excel
- Salary analysis
- Verbal and written communication
- Reliability
- Data Analysis
Certification
Excel/VBA for Creative Problem Solving Part 1; University of Colorado Boulder
Excel/VBA for Creative Problem Solving, Part 2; University of Colorado Boulder
Excel/VBA for Creative Problem Solving, Part 3 (Projects); University of Colorado Boulder
R Programming; JOHN HOPKINS UNIVERSITY
Data Vizualization with Tableau Project; University of California, Davis
Data Wrangling, Analysis and AB Testing with SQL; University of California, Davis
Creating Dashboards and Storytelling with Tableau; University of California, Davis
Essential Design Principles for Tableau; University of California, Davis
Fundamentals of Visualization with Tableau; University of California, Davis
SQL for Data Science; University of California, Davis
Visual Analytics with Tableau; University of California, Davis
R Data Pre-Processing & Data Management - Shape your Data!; Udemy
R Level 1 - Data Analytics; Udemy
R Basics - R Programming Language Introduction; Udemy
Introduction to Python for Data Science Course; DataCamp
Introduction to R Course; DataCamp
Introduction to SQL for Data Science Course; DataCamp
Timeline
HRIS Analyst
Triumph Foods
10.2016 - Current
Associate Actuarial Analyst - Pricing P&C, A&H
Swiss Re
02.2007 - 07.2016
Actuarial Technician
Cameron Mutual Insurance Company
06.2000 - 02.2007
High School Teacher
08.1997 - 05.2000
B.S. - Mathematics
Missouri Western State College
Similar Profiles
Naniolyn DeLeeNaniolyn DeLee
Internal Communications Analyst at Triumph FoodsInternal Communications Analyst at Triumph Foods
Jina ChanvongJina Chanvong
Quality Assurance Food Safety Technician at Triumph FoodsQuality Assurance Food Safety Technician at Triumph Foods
Francisco Carrera GarciaFrancisco Carrera Garcia
Automation Mechanic at Triumph FoodsAutomation Mechanic at Triumph Foods
Gary SteebyGary Steeby
Maintenance Supervisor at Triumph FoodsMaintenance Supervisor at Triumph Foods
Gary McGaughyGary McGaughy
Machine Operator at International PaperMachine Operator at International Paper