Pam Hamrick.
Always learning.
I am a senior IT professional seeking a new position in data analytics that will utilize my depth of experience and ability to apply new skills.
SQL, SQR, PeopleSoft Query, Object Security, Query Security, PeopleCode, Oracle database, BI Publisher, Crystal Reports, Application Engine, Upgrades, PUM lifecycle management process
SQL coding, ETL, Data analysis, Business analysis, Requirements gathering/analysis, Software Development Lifecycle, Project Implementation, Test Planning
SSRS, SSMS, Python, SQL Server, Oracle, Excel, VBA, VS Code, Visual Studio
Python (with SQLAlchemy, Pandas, Matplotlib), API, PostgreSQL, MongoDB, Flask, Splinter, SQLite, BeautifulSoup(web scraping), JavaScript, Plotly, JSON, Leaflet, GeoJSON, HTML, CSS, Tableau
This project builds a website with Bootstrap and JavaScript to display data on UFO sightings. The data is displayed in a table with the option of filtering the sighting on these elements:
Technology Used:
There is a scientific investigation into plausibility of finding the right bacteria to synthesize proteins that taste like beef. The right bacteria may exist in someone's belly button. This study collected belly button bacteria and other data from participants including:
When the participant's id is selected from the drop-down menu, three charts are displayed that demonstrate the quantity of bacteria in each OTU sample, the top ten bacteria for each participant, and the number of times per week the participant washes their navel.
Technology used:
This project visually explains the relationship between average fares and city types over a period of 4 months for a ride share company. Additionally, a summary is provided to show by City type:
The data was analyzed by utilizing functions like count(), index(), unique(), .dtypes, and describe(). Various plots were made with the merged data to develop an understanding of the data metrics.
Technology used:
This analysis is for potential investors in a bike-sharing program in the city of Des Moines, Iowa. Using data from August 2019 of New York City bike-sharing data, a Tableau story with many types of charts is presented. Is Des Moines a good place for a bike share program?
Technology used:
This project provides for management the total number of employees eligible for retirement, the same information broken down by retirement-eligible employees per title, a list of the retirement-eligible employees and a list of employees eligible to participate in a mentorship program.
The company expects a large portion of employees will be retiring soon. Management has requested information to determine who is eligible for retirement, how many are eligible, and how many are eligible by their title. Also needed is a list of current employees who would be eligible to participate in a mentorship program. This information will help management plan for the large number of expected retirements. Using six csv files, relational database was created that contains employee and departmental information from which reports can be provided for management.
Technology used: