Data Engineer and Analyst
New York
anthonygraff24@gmail.com
Languages/Platforms
Python - SQL (Postgres, MySQL, DB2)
HTML+CSS - JavaScript (React, Node)
Java - Rust - Docker - Ansible - C/C++
Software/Tooling/Libraries
Git(Hub) - Jenkins - Jira - Excel
Tableau - PowerBI - Trello
Visual Studio - Eclipse - Vim - JUCE
Selenium - Cypress - GIMP - Lightworks
Photoshop - Subversion
Music Software
Reaper - Logic - Audacity
ProTools - Finale - Musescore - Famitracker
About Me
My name is Anthony Graffigna. I'm a Data Engineer and Analyst with a background in Software Engineering and DevOps roles. I'm also a Musician, Audio Engineer, Graphic Designer, and all-around Creative, and have done freelance work in these areas. I enjoy the process of finding, cleaning, organizing, and analyzing complex datasets in order to extract and communicate concise and actionable conclusions. I have a wide variety of experience including backend development, automation pipeline administration, web development, system administration, and database administration, and I draw upon all of these experiences to guide my process when working with data. I prefer working with Python and JavaScript for the majority of my work, as it allows me to take advantage of their large and vibrant open source communities.
Projects
Click on a title to check out the GitHub page or presentation!
Washington State Lobbying Spending 
Every year, over 3 billion dollars are spent in the United States to lobby the government in an effort to influence legislation. This project utilized publicly available datasets from the Washington State Public Disclosures Commission and LegiScan to analyze trends in this spending over the past 10 years in Washington State.
United States Wind Power Market 
Over the course of one week, I served as the scrum master for a mock sprint in which my teammates and I conducted analysis on the wind power market in the United States, utilizing the U.S. Wind Turbine Database published by the United States Geological Survey.
CitiBike COVID-19 Impact Study 
Utilizing data published by CitiBike, I constructed a PostgreSQL database containing records from over 200 million CitiBike rides taken since 2013 and used it to analyze the impact of the COVID-19 pandemic on their service.
AirBnb Analysis - Bozeman Montana 
As a part of a team, I utilized datasets published by AirBnb to analyze the market for rental properties with easy access to ski resorts in Bozeman, Montana, and presented several candidate properties that met client stipulations.
Peach Turnip Data - Super Smash Bros. Melee 
I created scripts that analyze Slippi replay files for the game Super Smash Bros. Melee and calculates various statistics involving the type and number of Turnips pulled by the character Peach, an RNG dependant move with results that can significantly impact gameplay.
Work Experience
Audio Engineer / Freelance
Dec 2020 - Present
- Wrote, produced, and mixed Radio Production Beds for Premiere Networks’ Alpha Libraries for Radio service, delivering tracks according to both stylistic and technical specifications, utilizing Reaper
- Edited and Produced Podcasts, cutting raw audio down to episode length, removing extraneous noise, adding music and sound effects, adjusting volume and loudness, and publishing, utilizing Reaper and Audacity
- Recorded, produced, and mixed, and mastered songs and albums for several independent artists, incorporating artist feedback and adhering to technical specifications required by streaming platforms, primarily utilizing Reaper
DevOps Engineer - IBM OpenPages
Jan 2020 - July 2021
- Managed and maintained nightly development builds of OpenPages software, utilizing Jenkins and Github to identify bugs and notify relevant parties
- Created Ansible workflows to enable deployment of OpenPages software on end-user Windows systems
- Maintained Docker build files to upgrade bundled software to meet conformance standards on nightly build images
- Maintained a suite of Virtual Machines and associated CI/CD Jenkins jobs used by various team members to both manually test the OpenPages software suite and demonstrate it to customers
Software Engineering Co-op / HubSpot
Jan 2018 - Aug 2018
- Worked on a backend engineering team responsible for creating and maintaining various messaging pipelines for HubSpot services
- Designed and implemented a system to detect and notify end-users whose linked email inboxes become disconnected from HubSpot software
- Added standardized metrics and logging to existing code to improve the team’s ability to monitor deployed services