Sign in

Data Analyst

Atlanta, Georgia, United States
November 10, 2019

Contact this candidate


Alex Basinger

Atlanta, GA 404-***-****


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

Contact this candidate