Skip to content
View KyleKohlmeyer's full-sized avatar

Block or report KyleKohlmeyer

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
KyleKohlmeyer/README.md

Hi there 👋

The work currently on this GitHub is from my time as a student in the Northwestern Data Science and Visualization Certificate program. Please check out my repositories to see some of the cool assignments and projects I have worked on!

About me

I graduated with a biochemistry degree from Valparaiso University in 2022. After attending a year of chemistry graduate school at Indiana University, I realized that I enjoyed working with data more than running experiments in the lab. Thus, I left graduate school and enrolled in the Northwestern Data Science bootcamp. It has been the best decision of my life! I enjoy coding and working with data, and there is nothing more satifying than when the code finally works and outputs what you want. I started working as a Business Intelligence Analyst at Gaylor Electric in May 2024, where I used my data skills to track construction and manufacturing process, and to implement ETL processes and integrations. Currently, I am a Technology Analyst at Ascension, where I am in charge of managing the Trimble e-Builder application. I gather business and technical requirements from stakeholders, implement new customizations and features, manage application data, and work to uphold good IT and security practices.

Bootcamp summary

In the Northwestern Data Science bootcamp, I have:

-Created a VBA script to analyze stock data in Excel and apply formatting, saving time on the data analysis for large Excel datasets with multiple sheets.

-Used Python and the Open Weather API to compile and graph weather data from 1,000 randomly selected cities, and performed linear regression analysis to determine which weather conditions are correlated with latitude

-Employed the Pandas, Matplotlib, and NumPy Python libraries to efficiently clean and analyze responses to an Amazon consumer behavior survey, allowing for purchasing trends to be discovered and visualized.

-Written SQL queries to retrieve information from a database and join necessary tables, allowing for database data to be easily analyzed without altering the stored data itself

-Utilized the Flask and SQLAlchemy Python libraries to create an application to retrieve temperature and precipitation data from an SQLite database, making accessing the data less time consuming and more efficient

-Designed random forest and logistic regression machine learning models to predict housing prices in Chicago based off data from the Cook County Assessors office

This is not an all-inclusive list, please check out my repositories for more information and details

Skills

My Skills

Work Experience

Technology Analyst at Ascension (2025 - Current)

I use my technical and programming skills to manage the Trimble e-Builder application, allowing the Planning, Design, and Construction team to efficiently manage their projects. This work includes working with business stakeholders to develop new processes, making updates to existing functionality, and ensuring that organizational security standards are met. Additionally, I coordinate with the software vendor, Trimble Inc., to implement new customizations and resolve software outages.

Business Intelligence Analyst at Gaylor Electric (2024 - 2025)

I built and deployed a Power BI dashboard for construction asset data, allowing manufacturing and operations to improve scheduling and progress tracking. As part of the dashboarding process, I met with several stakeholders to gather business requirements and to ensure that the way the data was being presented was effective for them and their teams. In addition to my dashboarding, I helped the company roll out a new HCM software, Ceridian Dayforce, by loading existing data into Dayforce and creating long term integrations to create and transfer data. As part of this process, I created Python scripts that converted tabular records to nested XML format using the Python ETree library so that existing employees could be transferred to the new system before it went live. Additionally, I created ETL processes using Python Azure Runbooks and SQLAlchemy to maintain data consistancy between the HCM software and the data warehouse.

Associate Instructor at Indiana University (2022 - 2023)

I led an undergraduate organic chemistry laboratory section of 16 students, providing them with hands-on laboratory experience and ensuring that all EH&S waste disposal guidelines and safety protocols were followed in the teaching lab. I also held office hours, assisted with the lecture, and graded for organic chemistry I.

Undergraduate Researcher at Valparaiso University (2021)

I designed procedures for steps in the synthesis of potential pterin antifungal compounds to make developing and testing derivatives more efficient. One of my favorite parts of my research was analyzing nuclear magnetic resonance (NMR) spectroscopy data to optimize experimental conditions such as temperature and solvent, which led to higher yield and quicker reaction times.

Education

Chemistry Graduate Program, Indiana University | Bloomington, IN (August 2022 - May 2023)

-Took graduate courses and conducted research in the field of organic chemistry (3.43 GPA)

-Utilized the Reaxys database and conducted experiments to develop procedures to make an intermediate compound for the synthesis of natural product Cyathin D.

B.S Biochemistry (American Chemical Society certified), Valparaiso University | Valparaiso, IN (August 2018 - May 2022)

-Graduated Summa Cum Laude (3.88 GPA).

-Member of the chemistry honors society, Phi Lambda Upsilon (2022 – Current).

Hobbies

Founder of DarkfireBricks (2020 - Current)

I enjoy collecting, building, and displaying Lego sets. However, as my collection has expanded, I have gotton a lot of Lego sets that I did not want as part of large package deals for obtaining items that I wanted. I decided that I wanted to get rid of these sets, and have more money to expand my collection. Thus, I founded an online store selling used Lego that has grossed $10,000 in revenue. After starting out on Ebay, I decided to shift to Mercari in 2021 due to its ease of listing items and decreased competition. I have completed 110+ orders on Mercari with an average order value (AOV) of $67.04. The store receives an average of 144 item views per day.

Pinned Loading

  1. project1-analysis-amazon-survey project1-analysis-amazon-survey Public

    Jupyter Notebook 1