Data Analyst

Ryn Proffer

Richmond Virginia, *****

************@*****.***

To Whom It May Concern:

My name is Ryn Proffer. I have 7 years of experience in information technology, data engineering, and data analysis. I enjoy finding the meaning in large data sets and getting data where it needs to go. I have used SQL queries, Python scripts, and software such as Access, Excel, and Pandas in my pursuit of this.

My coworkers have often described me as resourceful, dedicated, and a passionate problem solver. I bring these qualities with me, as well as my experience in other professional capacities, which provide a well-rounded background. One of the best parts of my job has always been picking apart a problem, tracing it back to its origin, and building a solution; troubleshooting is a great source of joy for me. An example is the discrepancy checks in my time as a data analyst at EAB. These consisted of checking to see if the award package they intended to provide students matched what they had previously outlined. The solution built for this could be as simple as ensuring the cut points used to determine academic rank matched what they used, or it could be as complicated as building a newly created award into the simulation.

Attached you will find a copy of my resume that details my projects and experience. I look forward to hearing from you at 804-***-**** or by email at ************@*****.*** Thank you for your time and consideration. I am excited to speak with you about this opportunity.

Respectfully,

Ryn Proffer

Ryn PROFFER

************@*****.*** • 804-***-**** • linked-in

Professional Experience

EAB – Data Analyst January 10 2022 to Present

• Data communication and cleaning with internal and external stakeholders, such as partner schools and principal analysts

• Utilized SQL to purge data erroneously pushed to the warehouse and perform data crosswalks to correct errant key fields, matching truncated Student IDs with their intended IDs as a data warehouse SME.

• Full cycle support of multiple simultaneous partners from data evaluation and sanitation to data analysis, producing a simulation of the data for the current year using SQL, Excel, and MS Access.

• Monitored weekly data loads for discrepancies using SQL and Excel

• Visual representation of data using Tableau, Excel, Powerpoint, and FAA Dashboard

• Checked for errors in representation using SSRS

Morton – Consultant, PFG November 2021 to February 2022

• Scripted payroll delivery using Python and Pandas to pull data from an Excel document, sort the data into lists of depot employees, insert it into depot-focused Excel spreadsheets, and email the new spreadsheets to the depot manager

Estes Express – Information Specialist I, Billing Services January 2018 to 8/20/2020

• Created and maintained library of SQL queries and SQL report generating scripts for data analytics and reporting

• Developed Python script to locate probable errors in data entry forms for bills of lading

• Monitored job execution logs to locate and solve errors

• Developed script to pull notifications of severe delinquency from API and email them to terminal using Python

• Built Java program, consuming an API, to streamline the process of pulling W&R documents, allowing for faster processing

• Built tabletools library to simplify reading and writing to Excel files using Python Volunteer Experience

Community Outreach Initiative

• Organized and facilitated housing and transportation for clients during episodes of increased risk

• Engaged in fact finding and leadership meetings to ensure adherence to current community needs

• Supervised and participated in acquisition, storage, and distribution of resources

• Guided development of policies and practices with focus on high-risk populations Skills

• Relational databases

• SQL, Python, Java, MS Office, Tableau, IBM I Series Usage

• Pandas, PySpark

Education

Bachelor of Science in Computer Science Randolph-Macon College-2018

Contact this candidate