Alexander Ruhe

Alexander Ruhe Email and Phone Number

Lead Data Engineer @ State Farm
Normal, IL, US
Alexander Ruhe's Location
Normal, Illinois, United States, United States
Alexander Ruhe's Contact Details

Alexander Ruhe work email

Alexander Ruhe personal email

n/a
About Alexander Ruhe

Alexander Ruhe is a Lead Data Engineer at State Farm. He is proficient in Japanese.

Alexander Ruhe's Current Company Details
State Farm

State Farm

View
Lead Data Engineer
Normal, IL, US
Website:
statefarm.com
Employees:
107175
Company email:
info@jhannahco.com
Alexander Ruhe Work Experience Details
  • State Farm
    Lead Data Engineer
    State Farm
    Normal, Il, Us
  • State Farm
    State Farm
    Normal, Il, Us
  • State Farm
    Lead Software Engineer
    State Farm Aug 2024 - Present
    Bloomington, Illinois, Us
  • State Farm
    Data Analytics Engineer
    State Farm Aug 2022 - Aug 2024
    Bloomington, Illinois, Us
    • Developed and maintained a solution to mock production formatted simulation data for rating and underwriting impact analysis to convert ensure accuracy during legacy conversion. ◦ Used a Jupyter-Notebook configured to run a Pyspark instance to take multi-dimensional SAS and SQL sourced dataframes and join them together via a custom defined python UDF, which repackages and formats a proprietary json / edn payload, mocking the format needed by the models. ◦ Debugged and wrote tooling to identify causes of simulation errors, using regex, Pyspark, and Python. • Rewrote simulation preparation for operational glue job to new core format and simultaneously increased performance by 35% by using spark functions conjoined with Python list comprehension.• Wrote custom flattening AWS glue job that takes a proprietary hierarchical json simulation response format and flattens it to a singular data frame for analytic consumption by actuaries. ◦ Generalized the script to be capable of flattening to any target dimension, including risk, policy, driver, etc. ◦ Optimized performance to cost less than $5 per 1.8 million record execution ◦ Documented using Google’s Python style guide.• Maintained simulation-data-pipeline, a Terraform managed GitLab repository containing information on our established model monitoring systems, including step functions which operate on specially queried Redshift jobs which are fed into a step function containing a simulation on EMR and several subsequent glue jobs.• Trained formally in Data Scientist lead course on GLM development, using scikit-learn for modeling and seaborn for visualization techniques.• Worked with legacy DB2 based databases to extract data using SQL for use in impact analysis.• Enforced higher documentation standard by assisting in identifying needed retro topics for team self reflection as part of the agile life cycle.
  • State Farm
    Software Engineer
    State Farm Dec 2021 - Aug 2022
    Bloomington, Illinois, Us
    • Worked with Spark to run simulations on AWS EMR cluster to validate accuracy of thousands of attributes• Developed python based Jupyter notebook to reverse engineer flattened data into hierarchical .json files for testing data flattening process.• Updated and operated with PySpark notebook to convert flattened .csv-like data into .edn compliant hierarchical schema defined data using Pandas for the purposes of running model validation through a simulation pipeline.
  • State Farm
    Software Developer
    State Farm Oct 2019 - Nov 2021
    Bloomington, Illinois, Us
    • Developed tools and improved existing infrastructure used by GLMs for both underwriting and actuarial consumption.• Wrote sweet recursive functions in Clojure to optimize work flow, improve performance, or to just do something cool.• Acquired insurance business acumen needed to understand the process flow for customers.• Utilized bash scripts to optimize workflow and improve effeciency. • Familiarized myself with data sources available to actuarial modeling and pricing.• Practiced best developer techniques including version management using git, gitlab, github and AWS CodeCommit.• Endured agile methodology for the purpose of ensuring transparency, organization and best developer practice.
  • Illinois State University
    Senior Sales Associate - Techzone
    Illinois State University Jun 2016 - Aug 2019
    Normal, Il, Us
    Handled receiving packages, asset management, and filing paperwork for the universityFacilitated transactions totaling over $200,000 worth of technology productsEducated 500+ students regarding campus technology during scheduled presentationsAssisted in training new employees and developing training documentsSolved customer service issues
  • Illinois State University
    Graduate Assistant
    Illinois State University Aug 2018 - May 2019
    Normal, Il, Us
    Assisted faculty with day-to-day classroom operations including proctoring examinationsAllocated time outside of scheduled work periods for grading and other department workTutored students during both office hours and scheduled tutoring hoursConducted classroom lab sessions alone weeklyAccurately maintained student grades

Alexander Ruhe Education Details

  • Illinois State University
    Illinois State University
    Applied Statistics (Not Complete)
  • Illinois State University
    Illinois State University
    General Mathematics

Frequently Asked Questions about Alexander Ruhe

What company does Alexander Ruhe work for?

Alexander Ruhe works for State Farm

What is Alexander Ruhe's role at the current company?

Alexander Ruhe's current role is Lead Data Engineer.

What is Alexander Ruhe's email address?

Alexander Ruhe's email address is al****@****arm.com

What schools did Alexander Ruhe attend?

Alexander Ruhe attended Illinois State University, Illinois State University.

Who are Alexander Ruhe's colleagues?

Alexander Ruhe's colleagues are Clarice Cook, Tina Barnard, Ryan Boling, Lena Kirk, Paula Gill, Gabriela Muro, Monette Trice.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.