Emily Mathieson
Hi! My name is Emily and I am an Application/Data Engineer. Welcome to my personal portfolio site!
Emily Mathieson
APPLICATION ENGINEER / DATA ENGINEER
I am a graduate of the Biological Sciences, having focused on Ecology & Wildlife Biology. I completed an internship in 2015 with the National Park Service in Yellowstone National Park as a Native Fish Conservationist.
Although I have a passion for biology, I had decided to switch gears when it comes to my career. Being a self-starter, I started off by learning how to write & maintain code through online courses, and moved on to creating my own personal projects to solidify my skills.
I have two years of experience working at Rocket Mortgage as an Application Engineer. I started with IT account administration and support, and moved up to work with SQL and Operational Reporting work.
Skills
- SQL Server Management Studio, SSMS
- SQL Server Reporting Services, SSRS
- SQL Server Integration Studio, SSIS
- Transact SQL, T-SQL
- Team Foundation Server, TFS
- Microsoft Excel, Office, Outlook
- Black Knight Financial Services / MSP
- Unity Engine
- Blender Software
- Creative Problem Solving
- Team Building
- Detail-Oriented
- Curiosity
- Multitiered Communication
- Pattern Finding
- Reliability
- Punctuality
- Organization Skills
- SQL
- Javascript
- jQuery
- Intro C#
- HTML &CSS
- Intro GitHub
- Canva & Figma
- Intro Tableau
- Intro PowerBI
- Intro Access
Education
Web Development Path, 2017
Areas of focus include front-end web development, data management and programming. Familiarity with the concepts of HTML, CSS, Object-Oriented Programming, JavaScript, jQuery, C#, SQL.
Bachelor of Science in Biology, 2015
Native Trout Conservation Intern, Yellowstone National Park, 2015
Assisted in multiple ecological restoration & preservation projects throughout park. Data recording and management, workload, & day-to-day activities.
Work Experience
Rocket Mortgage July 2021 - August 2023
Account administration and support. Developed, maintained, and troubleshooted hundreds of stored procedures, data tables, SQL agent jobs, and SSIS packages for multiple internal RM systems, tools, and business applications. Utilized SSMS as primary tool.
Highlights:
◼ Developed, maintained, and troubleshooted unique tool created for business to
facilitate bulk processes. Team effort with one additional engineer. Processed over 2
million requests within first year. Utilized data cleansing, ETLs, JSON, Web
Services, CSV import, and API responses.
◼ Developed, maintained, and troubleshooted tool created for compliance noting for
Dialer system. First solo dev project. Utilized ETLs, JSON, Web Services, CSV
import.
◼ Developed, maintained, and troubleshooted process for paper/paperless
automation for entire RM portfolio.
◼ Winner of the “We Appreciate You 3000 Award” for Q1 2023
The Carpet Guys July 2020 - July 2021
Contract interpretation, order building in rfms software, floor plan manipulation to efficiently utilize materials, telephone communication, and general office tasks.
MATHIEKNITS 2015 - Present
Created and designed website, including photography and art direction. Manages social media and Etsy store. Creates hand-made goods out of high quality materials.
Portfolio Projects
SSMS Species
This SQL code utilizes data from a personal project I have been working on for the past few years.
The source data was collected by myself, using a combination of the NPS online database and my own personal collection of field guides.
Please be sure to view the diagram I have created, linked here.
T-SQL, SSMS
