Andrew Orlino Winter
andorwinter@gmail.com - github.com/andrew-winter - Los Angeles, CA 90004
SKILLS
Languages: R, SQL, Python
Tools: Excel, Tableau, SQLite, SQL Server, Access, Jira, Zendesk, Azure, HTML, CSS
Technical: data cleaning, exploratory data analysis (EDA), data validation, quality assurance (QA), visualization, database administration, text analysis, web scraping, REST APIs, statistical analysis and testing for statistical significance, linear regression, predictive modeling, hypothesis testing, A/B testing, reporting, dashboards, KPIs
Clerical: student housing administration, overnight on-call shifts, customer support (reception, phone, email), bookkeeping, community engagement, community program planning and hosting
EXPERIENCE
- Execute daily morning reporting process; work with ETL pipelines for file collection, scrubbing, and analysis
- Use appropriate tools to transform, validate, and load data; run pre-written Python and SAS code and write automation programs in R and Python
- Run and assess errors for proprietary data science models, analyzing media airings and web and phone responses
- Validate data feeds for approximately 35 clients, with weekly media budgets up to $1.5 million per week
Data Management Analyst | Icon Media Direct
04/2021 - present | Sherman Oaks, CA- Maintained health insurance product data with the applicable tools: Access databases, R scripts, SQL Server queries, Excel
- Built rates, plans, and benefits for a variety of health insurance products, including small group, individual and family, short-term health, accident, short-term health, accident, critical illness, and Medicare Supplement plans
- Reviewed team members’ builds for quality assurance (QA); research escalated customer support tickets related to data
- Communicated with internal development teams and external providers to meet business rules and development deadlines
Data Coordinator | Quotit (National General Insurance)
02/2019 - 03/2021 | Irvine, CA- Collected monthly rent payments for approximately 1,480 student residents; handled phone, in-person, email, and physical mail bookkeeping-related correspondence with recurring deadlines and on an ad hoc basis
- Researched unit condition history and processed corresponding charges, collections, and security deposit refunds
Bookkeeper | American Campus Communities (temporary, seasonal)
05/2018 - 10/2018 | Irvine, CA- Administered customer service for leasing, bookkeeping, residence life, and maintenance departments
- Planned community events independently and in small groups, typically attaining between 15 and 75 attendees
- Conducted analysis of 18 months of event trends using SPSS and presented findings to optimize events budget
Community Assistant | American Campus Communities
06/2016 - 06/2018 | Irvine, CAEDUCATION
University of California, Irvine - 06/2018
BA Economics and Political Science
Relevant coursework: econometrics, American economic history, education, experimental, health, and public economics
Dean's Honor List: Fall 2016, Spring 2017
PROJECTS
- Web scraped role descriptions from indeed.com, cleaned data, and analyzed word choice to gain insights into valued skills
- github.com/andrew-winter/job-board-descriptions
Job Board Descriptions Text Analysis | R | packages: rvest, tidytext, tidyverse
- Programmatically made HTTP requests, cleaned and combined data, and visualized pay range, benefits, and departments
- github.com/andrew-winter/LA-payroll
Exploratory Analysis of Los Angeles City Employee Payroll | R | packages: httr, tidyverse
- Made linear regression models in SPSS to identify effective, high-attendance factors of community events
- Presented findings to team, emphasizing the utility of email marketing and specific event topics, such as financial literacy
Norte by the Numbers - American Campus Communities Event Trends | SPSS
ADDITIONAL EXPERIENCE
- Coordinated with clients and lead staff to assign specialized tax returns to appropriately trained verification clerks
- Used verification software to report accurate qualitative and quantitative financial data to accounting firm clients
Data Verification Clerk | VincentBenjamin (temporary, seasonal)
01/2019 - 02/2019 | Irvine, CA- Registered eligible undergraduates to vote before the 2016 U.S. general election
Voter Registration Intern | Associated Students of UC Irvine
05/2016 - 12/2016 | Irvine, CA- Promoted campus leadership and community engagement along with the other executive board members
- Planned events and marketing in a community with approximately 1,800 first-year residents
Community Council President | Middle Earth Housing - UC Irvine Student Housing
08/2015 - 06/2016 | Irvine, CA- Mentored in large groups with a leadership program for first-year students, highlighting resources, strategies, and community engagement available at the university and beyond
Peer Mentor | Antleader Mentorship Program - Associated Students of UC Irvine
03/2015 - 03/2016 | Irvine, CA- Outlined student advocacy projects for the four on-campus undergraduate housing communities
- Composed proposal securing $2,192 grant for two sustainable bike maintenance and repair stations
Advocacy Committee Chair | Government of Undergraduate Student Housing
12/2014 - 06/2015 | Irvine, CA