Data Analytics Leader - 8 Years Experience - SQL/Tableau/Python Expert

Abigail Carlton

(***) *** - **** *******@***.*** linkedin.com/in/abigailcarlton/

Profile

Data enthusiast with 8 years of experience as an analyst at UIC’s Student Affairs Technology department. Began leading the data team in May 2020, as an undergraduate student. Rich technical skills like SQL, Tableau, and python and tactical skills like project management and systems planning. Committed to going the extra mile to create something amazing.

Education

University of Illinois at Chicago (UIC)

Master of Science in Management Information Systems, 2021 – 2024 Bachelor of Science in Information and Decision Sciences, 2017 – 2021 Concentrations: Business Analytics & Management Information Systems Technical Skills

• Programing Languages: T-SQL, PL/SQL, R, SAS, Java, HTML, CSS, and Python (NumPy, pandas, math, pyodbc, feedparser, argparser & configparser, requests, json, BeautifulSoup, oracledb and warnings).

• Software/Platforms: Tableau, Oracle SQL Developer, Microsoft SQL Server, Google Analytics, WIX, WordPress, GitHub, Git bash, Visual Studio Code, Power Automate, Excel, Confluence and Jira.

• Soft Skills: Project management, communication, emotional intelligence, and problem solving. Work Experience

UIC – Student Affairs Technology Department Aug 2017 – Present Jr. Data Analyst – Data Team Lead, 2023 – Present

Graduate Assistant – Data Team Lead, 2021 – 2023

Undergraduate Data Assistant, 2017 – 2021

• Onboard, teach and lead a team of 4 undergraduate & graduate students.

• Source spatial, operational, transactional, and demographic data to develop consumable reports.

• Maintain knowledge within the department of information systems, data and best practices.

• Manage and develop imports for various CRMs; build timely ad hoc reports and develop innovative dynamic Tableau reports for 10+ departments.

• Interact with APIs and create ETL pipelines using python, T-SQL, PL/SQL, and task scheduler.

• Organize projects in Confluence and Jira including our Oracle 19c and GitHub migrations.

• Mapped over 100 data attributes and constructed a query for Campus Housing’s CRM platform. Citizen’s Real Estate and Property Management May 2013 – Present Digital Consultant – 2024 – Present

Administrative Assistant – 2013 – 2021

• Migrated their CRM platform from Rent Manager to Buildium.

• Created and initiated a plan to funnel vacancies onto Zillow

• Onboarded properties and landlords into the Rent Manager system.

• Initiate projects like automating their monthly transaction processes using Buildium’s API. UIC – Information and Decision Science Department Jan 2021 – May 2021 Student & Undergraduate Research Assistant

• Researched investment prediction SAS scripts because the runtime was over 2 hours.

• Replicated the functionality in python and the program ran in under 2 minutes in.

• Worked directly with Ph.D. John Sparks and received an A in the course.

Contact this candidate