Data Analytics & SQL-Driven Process Improvement Specialist

Robyn PROFFER

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

Professional Experience

EAB – Data Analyst, Financial Aid Optimization January 10 2022 to May 16 2025

• 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, using SSRS and SSIS.

• Full cycle support and project management of multiple simultaneous partners with large data sets

• Data evaluation and sanitation, for quality assurance purposes, to data analysis, producing a simulation of the data for the current year using SQL, Excel, and MS Access.

• Monitored weekly data loads for discrepant awarding packages using SQL and Excel

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

• Maintained and contributed to technical documentation of above processes for ease of reproduction

• Mentored inexperienced analysts and provided insightful guidance on best practices 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

• Generated technical documentation and user guide 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 ad-hoc Python scripts 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 delinquencies from API and email them to terminal using Python

• Streamlined the process of data migration and image file processing using Java to consume API and validate image files

• Built tabletools library to streamline reading and writing to Excel files using Python

• Communication and requirement gathering with non-technical stakeholders to provide technical solutions 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 (Access and Snowflake), SSRS, SSIS, CI/CD, Docker, KubernetesL Orchestration

• SQL, Python, Java, MS Office, VBA, Tableau, IBM I Series Usage, Github Dimensional Data Tables

• Pandas, PySpark, numPy, FastAPI, Excel Data Analytics tab add on WorkDay Education

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

Contact this candidate