Alex Basinger
Atlanta, GA 404-***-****
adas3a@r.postjobfree.com linkedin.com/in/alex-basinger
EDUCATION
Georgia State University – Andrew Young School of Policy Studies Atlanta, GA Master of Arts in Economics August 2015 – May 2017 Bachelor of Science in Economics August 2012 – July 2015
• Presented published research to over 100 audience members in TEDx
• Published “Recidivism and the Convict Labor Market” in Discovery Magazine
• Aggregated and modeled recidivism data from 18 countries with OLS regression to argue for-profit prisons increase the incarceration rate of released prisoners and presented in the Georgia State Research Conference EXPERIENCE
Aderant Holdings Atlanta, GA
Conversion Programmer April 2019 – October 2019
• Developed custom SQL code to correct data in staging tables
• Converted and loaded client data into Aderant's Expert software
• Extracted data from clients' source tables using stored procedures
• Communicated progress on multiple collaborative projects to client representatives
• Validated data returned in results scripts according to legal and banking best practices Namely HRIS New York, NY
Technical Analyst April 2018 – September 2018
• Resolved data discrepancies between client and carrier databases
• Mentored clients in updating employee data using Namely products
• Created a customized dashboard to visualize assigned carrier data feeds in JIRA
• Constructed data feeds using clients’ benefits and payroll data using proprietary tool
• Leveraged ad hoc SQL queries and Excel parsers to review carrier feeds for compliance
• Configured and tested EDI connections to securely transmit clients' sensitive information
• Created dummy client data in order to test carriers' APIs for file transmission and interpretation Argus Information & Advisory Services White Plains, NY Data Analyst October 2017 – April 2018
• Queried SQL servers for KPIs requested by clients at 32 national and regional banks
• Created tables comparing banks’ relative performance for monthly client presentations
• Executed searches for files pertaining to client requests with a command line interpreter
• Compressed databases and checked disk space utilization to improve server performance
• Participated in monthly client phone meetings to better understand their needs and deliver solutions
• Debugged queries and Excel functions for client requests and validated outputs with time series analysis TECHNICAL SKILLS
• Microsoft Office Suite – Outlook, Word, Excel, Access, PowerPoint
• Excel – Pivot Tables, Pivot Charts, vLookup, Filters, Macros
• ArcGIS, ArcMap, Google Earth, Google Fusion Tables – Data Visualization
• SQL – Temporary Tables, Nested Subqueries, Stored Procedures, Indexing, Joins
• R & RStudio – Smoothing, Moments, Copula, Probit, Logit, ARIMA, ANOVA, MANOVA
• STATA – Regression Discontinuity, Difference-in-Differences, Fixed Effects, Instrumental Variables