Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Timeline
Generic

Nicole Schmidt, PhD

Underhill,VT

Summary

Dynamic Business Intelligence Developer with a proven track record at Systems & Software, excelling in SQL and data modeling. Adept at crafting impactful BI solutions and fostering collaboration to drive data-driven decision-making. Passionate about leveraging analytical skills to enhance reporting and deliver innovative insights that propel business success.

Overview

11
11
years of professional experience

Work History

Business Intelligence Developer

Systems & Software
Winooski, VT
06.2022 - Current
  • Engineer, improve, and debug advanced SQL statements.
  • Collaborate with customers to develop sophisticated reports tailored to their business requirements.
  • Implement BI solutions using tools such as Cognos and Microsoft Power BI.
  • Support creation of innovative data platform to enhance storage capabilities.
  • Develop and update data model/ERD.
  • Deliver tailored trainings for leveraging data-driven reporting systems.

Skills: SQL · Cognos · Oracle SQL Developer · Business Intelligence (BI) · Microsoft Power BI · Data Modeling · MySQL

Research Scientist

Minnesota Population Center
Minneapolis, MN
09.2014 - 06.2022
  • Oversaw the execution of several intricate projects, such as a $27 million national survey and biomarker data collection.
  • Managed and directed impactful large-scale NIH-supported research efforts.
  • Utilized advanced quantitative approaches, incorporating causal mediation and machine learning.
  • Gathered, integrated, and maintained extensive data sets.
  • Worked seamlessly with research groups and external partners to develop creative data strategies.
  • Supervised a group of research assistants, graduate students, and post-doctoral fellows.
  • Communicated complex research findings clearly and effectively through scholarly articles, book chapters, and professional conferences.

Skills: Academic Writing · Analytical Skills · Causal Analysis · Quantitative Research · R · Stata · Statistical Data Analysis

Data Science Consultant

Fuse Marketing
Winooski, VT
09.2017 - 12.2017
  • Assessed effectiveness of influencer marketing campaigns to boost brand recognition.
  • Determined key factors boosting business interest in Amazon's Affiliate Marketing Program.
  • Generated analytics and visual graphics to enhance presentations.

Education

Ph.D. - Criminology & Criminal Justice

University At Albany
Albany, NY
03-2011

Master of Science - Criminology & Criminal Justice

Northeastern University
Boston, MA
05-2006

Bachelor of Arts - Psychology, Minor in Statistics

University of Vermont
Burlington, VT
05-2001

Skills

  • Proficient in SQL, R, Stata; developing skills in Python
  • Data modeling
  • BI Tools: Cognos, Power BI
  • Quantitative research
  • Report generation
  • Machine learning

Affiliations

  • Snowboarding, mountain biking, hiking, adventuring in Vermont, solving puzzles

Accomplishments

  • National Institutes of Health Loan Repayment Program Award, Health Disparities Research (July 2020) | Competitive two year grant awarded to high achieving researchers doing innovative research on health disparities.
  • Institute for Social Research & Data Innovation Outstanding Service Award (December 2019) | Outstanding service award for significant contributions to the excellence of ISRDI, University of Minnesota.

Timeline

Business Intelligence Developer

Systems & Software
06.2022 - Current

Data Science Consultant

Fuse Marketing
09.2017 - 12.2017

Research Scientist

Minnesota Population Center
09.2014 - 06.2022

Ph.D. - Criminology & Criminal Justice

University At Albany

Master of Science - Criminology & Criminal Justice

Northeastern University

Bachelor of Arts - Psychology, Minor in Statistics

University of Vermont
Nicole Schmidt, PhD