Kolin Schuerman
Data Scientist at FirstParty- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Algorithmic Trading and Stocks Essential Training
LinkedInJul, 2020- Oct, 2024 -
Economic Indicators
LinkedInJul, 2020- Oct, 2024 -
Microsoft Excel - Basic & Advanced
MicrosoftNov, 2018- Oct, 2024 -
Financial Modeling Basics
Microsoft
Experience
-
FirstParty
-
Computer Software
-
Data Scientist
-
Oct 2022 - Present
-
-
Data Analyst
-
Jan 2022 - Oct 2022
-
-
-
Public Service Commission of Wisconsin
-
United States
-
Government Administration
-
1 - 100 Employee
-
Water Data Scientist
-
Jun 2021 - Jan 2022
- Implemented sets of SQL queries connected to Excel Power Query to be ran annually for flagging utilities with erroneous data on their Annual Report which increases efficiency of Utility rate cases- Gathered data from Department of Workforce Development on workforce demographics to analyze against utility diversity data in Tableau to present during a commission briefing- Crafted an excel dashboard to automatically track progress of active rate cases- Updated Excel VBA code for Utility rate case application tool to implement application changes/fixes
-
-
-
UW Carbone Cancer Center
-
United States
-
Research Services
-
100 - 200 Employee
-
Finance Intern
-
Jan 2019 - Apr 2020
Honored to have been a part of the University of Wisconsin Carbone Cancer Center team which is distinguished by the National Cancer Institute for being the only comprehensive cancer research center in Wisconsin. I worked internally to help the post-award accounting team analyze and optimize the way they conducted clinical trials from a business perspective. I ensured the efficiency of payment procedures and contract adherence with major pharmaceutical companies. Honored to have been a part of the University of Wisconsin Carbone Cancer Center team which is distinguished by the National Cancer Institute for being the only comprehensive cancer research center in Wisconsin. I worked internally to help the post-award accounting team analyze and optimize the way they conducted clinical trials from a business perspective. I ensured the efficiency of payment procedures and contract adherence with major pharmaceutical companies.
-
-
-
The Campus Agency
-
United States
-
Advertising Services
-
1 - 100 Employee
-
Brand Ambassador for Google Allo
-
Sep 2017 - Nov 2017
I was delegated as a Restaurant Lead Ambassador where I was POC for team members and in charge of voucher distribution and reconciliation at the end of restaurant takeover shifts. As a brand ambassador, I used my creative mindset to drive downloads and market Google Allo weekly. I also had the opportunity to coordinate an individual ambassador run event on campus. I was delegated as a Restaurant Lead Ambassador where I was POC for team members and in charge of voucher distribution and reconciliation at the end of restaurant takeover shifts. As a brand ambassador, I used my creative mindset to drive downloads and market Google Allo weekly. I also had the opportunity to coordinate an individual ambassador run event on campus.
-
-
-
Kevin P Schuerman Cpa
-
United States
-
Accounting
-
1 - 100 Employee
-
Accounting Assistant
-
Aug 2013 - Aug 2016
-Gathered data from client books and prepared spreadsheets for assembly of sales tax reports and tax returns-Assisted with general filing, photocopying, and basic customer service -Gathered data from client books and prepared spreadsheets for assembly of sales tax reports and tax returns-Assisted with general filing, photocopying, and basic customer service
-
-
Education
-
University of Wisconsin-Madison
Bachelors of Science, Economics with Mathematical Emphasis