Connel Wilson

Database Management & Data Analysis

Let me bring meaning to your data so you can focus on what to do about it.
image2
About me

I am an enthusiastic newcomer to Data Analytics.

From Physics Degree to Data Analyst

In early 2021 I was approaching my graduation from CU Boulder; set for May 6th. I had nearly graduated the semester before but being just three upper level physics credits short I was stuck staying through the Spring semester.

I elected to take Plasma Physics to finish out my requirements and added several non-degree courses that sounded interesting to round out my schedule. This meant my final semester would be relatively light, with really only the Plasma Physics final to worry about. I was working part time for the college IT department but this would end with graduation so I put the free time from my minimal course load towards finding my next job.

Here's what I'm working on now:

From data migration, cleaning and analysis to database design and management, I’m becoming an expert in all things data to better serve you. 

Alexander Freberg's Data Analytics Bootcamp - In Progress

Video Data Analyst Bootcamp course covering: SQL, Excel for Data Analytics, Tableau and Power BI. Course subdivided into five sections, each including practical examples & problems.

Google Data Analytics Certificate - In Progress

Video Data Analyst certificate program course going over SQL, Business Communication, Spreadsheet Software, Business Analysis, Data Visualization, and Data Management. Course is subdivided into eight sections each ranging from 9-3 hrs, and totaling 186 hrs.

Power BI Analyst Associate - In Progress

Certification designed to confirm candidates can: Provide meaningful business value through easy-to-comprehend data visualizations. Enable others to perform self-service analytics. Deploy and configure solutions for consumption.

Here's what I'd like to do for you:

Really anything if it’s with your data… 

Data Analytics

Data cleaning, analysis & visualization using SQL, Python, R, Tableau, Power BI and Excel. Report, query and dashboard creation.

Database Design

Database Design with architecture consideration for databases using Microsoft Access, SQL Server or MySQL DBMSs.

Database Management

Data migration, validation and upkeep. SQL Database create, read, update and delete (C.R.U.D) function proficiency.

Here's what I've done so far:

Skills

Microsoft SQL Server
Proficient
MySQL
Beginner
Power BI
Moderate
Tableau
Moderate
Python
Proficient
R
Beginner
Microsoft Excel
Expert

Portfolio

Previous Work Experience

June 2021-Oct 202

Boyer Sales & Service

Project MaNager

Rose from a Sales Application Engineer to the Inside Sales Manager before transitioning to a Project Management role. Developed internal tools in PowerApps, Excel and Sharepoint. Wrote new processes and formalized existing practices to help streamline team work flows. Performed engineering selections and generated quotations for custom-engineered commercial pump systems with values from $500 to >$100,000. Followed same systems through production and delivery with a focus on matching final costs to initial estimates for comparison. Performed trouble shooting and start ups on PLC and HMI control systems including uploading of custom logic and settings.

Sept 2020-May 2021

CU Boulder

OIT Tech Copilot

Troubleshot technical issues with audio/visual equipment and campus communications softwares for professors and students. Leveraged existing documentation and resources while contributing to a solutions database with detailed analysis of, and solutions for novel issues encountered. Partnered with other campus IT departments to find solutions for students and professors as needed.

May 2016-Aug 2016

Deluxe Foods

Deli Employee

Deli Employee. Took orders from customers, made sandwiches, opened and closed the store including cleaning and preparation as needed.

May 2015-Aug 2015

SMWB Law Firm

Summer InTern - Law Firm

Researched and drafted material for articles published on the firm's website. Conducted legal research for firm cases and performed courthouse deliveries. Fulfilled mailing, filing and general support staff functions.

May 2012-Aug 2012

Young Engineering Services

Summer Intern - Engineering Firm

Completed Autocad file editing and Heating/ Energy & Efficiency calculations for HVAC projects. Accompanied on-site inspections and familiarized myself with the relevant hardware, systems, and principles involved in active projects.

2011-2014

Vargas Gymnastics Academy

Assistant Coach

Taught tumbling and trampoline to ages 5-15. Assistant coached the gym’s competitive gymnastics team which would compete in the National Junior Olympics. Co-managed parties for up to 40 guests and summer camps.