Professional Bio
WORK HISTORY
Data Analyst (Volunteer)
July 2020 - Present
The Bakken Museum
Minneapolis, MN
Initiated data analyst volunteer role to help non-profit museum that doesn’t
have a designated data team or even person. Responsible for learning the internal
CRM software and then determining how best to wrangle the data within the platform.
Working toward setting the Bakken up for data success through uniform file management
and creating streamlined data pipelines. Manage limited time in office between
ongoing projects, ad-hoc queries, and building my own technical knowledgebase.
Key Accomplishments
- Helping museum to maximize rental profits thru ETL; performed using jupyter notebook, pandas, and python scripts
- Starting more thorough profit analysis of museum members by aggregating correctly-validated data; accomplished with PostgreSQL for data exploration, python scripts for mathematical analysis, and Microsoft Excel to deliver results
- Creating profit strategy for the museum store (newly taken over by my supervisor), which includes analyzing profit margins, determining ordering schedule, and exploring for insights within the data
TOOLS & TECHNOLOGIES
DATA ANALYTICS:
- Programming Languages - Python, SQL, VBA, JavaScript, R
- Data Visualization - Tableau, D3.js, Plot.ly, Leaflet.js, Matplotlib, Seaborn
- SQL - PostgreSQL, MongoDB
- Python - Pandas, NumPy, SciPy, SQLAlchemy, VisualCode, Jupyter Notebook, Sci-kit Learn
- Amazon Web Services (AWS) - Hadoop, PySpark, ZEPL, S3, Sagemaker
- Excel - VBA, Macros, Pivot Tables/Charts, Index/Match, VLOOKUP, IFS
- Statistics - Descriptive & Inferential, AB Testing, Confidence Intervals, Hypothesis Testing, ANOVA, T-Test
WEB DEVELOPMENT:
- CSS
- HTML
- JavaScript - D3.js, Plot.ly, Leaflet.js, Amcharts
GENERAL COMPETENCIES:
- Microsoft Office - Excel, PowerPoint, Access, Sharepoint, Word, Outlook
VOLUNTEERING
Business Mentor
Jan 2020 - Present
Technovation[MN]
Wayzata, MN
Mentor middle and high school girls in coding, entrepreneurship, problem solving, and social responsibility.
Treasurer
Feb 2020 - Present
Homeowners Association
Loring Park
Prepare bi-monthly financial reports and analyze budget discrepencies.
Give talks to building-wide community about status of association finances.
Prepare annual budget.
Secretary
June 2018 - Feb 2020
Homeowners Association
Loring Park
Prepare written reports of all board meetings. Act as communication liaison between
community residents and the board. Familiarize myself with all matters to be discussed
at bi-monthly meetings in order to lend a well thought-out opinion. Commit to two-year
term, voted in by a majority of homeowners.
Meal Server
Feb 2014 - Present
Plymouth Congregational Church
Minneapolis, MN
Work as a team to feed 150-200 patrons-in-need from the surrounding community.
Responsibilities include guiding and serving guests, working as a team, cleaning,
maintaining a positive energy, and connecting with guests through conversation.
EDUCATION
Data Analysis & Visualization Certificate
May 2020
University of Minnesota, Twin Cities
A 24-week intensive program focused on building my technical programming skills in Excel,
VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, and Machine Learning
Bachelor of Arts, Mathematics
May 2010
University of Minnesota, Twin Cities
Minors in Architecture and Design