Data Analytics Analyst

Katie Hutchinson

DeSoto, MO 314-***-**** *****************@*****.*** LinkedIn Data Analytics Portfolio Experienced certified jr. Data Analyst with 10+ years in professional home and office management services. Proficient in Excel, SQL, R, data analytics, and visualizations tools like Tableau. Seeking data analytics role to leverage expertise in problem-solving and program development for impactful contributions.

EDUCATION & CERTIFICATIONS

Bachelor of Arts in Psychology Saint Louis University, St. Louis, MO Google Data Analytics Certificate Coursera, Remote Business Law Certificate Saint Louis University, St. Louis, MO Human Resource Management Certificate Saint Louis University, St. Louis, MO TECHNICAL SKILLS

Tools/Languages: Excel, SQL, (BigQuery, PostgreSQL), Tableau, R (RStudio) Data Management: Data Collection, Data Cleaning, Data Structures, Data Analysis, Data Visualization, Data Ethics Software Platforms: Microsoft 365 Suite, Google Workspace, Slack, Zoom, Kaggle, Loom PROFESSIONAL EXPERIENCE

Full Service Shopper • Instacart, St. Louis, MO 09/2021 - Present

● Orchestrated shopping and delivering services for multiple grocery stores, managing over 500 items daily

● Engaged customers through messaging apps ensuring meticulous attention to product details during shopping

● Achieved a 4.9 out of 5 rating for exceptional quality, timeliness and more attributes, earning Diamond Cart status for high-order volume and accuracy while maintaining customer satisfaction Household Services•Task Rabbit, St. Louis, MO 12/2021 - Present

● Developed comprehensive company policies and procedures, ensuring adherence to 30 criteria points for home standards.

● Efficiently managed monthly schedules coordinating times, dates, and addresses to streamline business operations

● Effectively communicated with clients to understand and meet their expectations for disinfection, organization, and overall household maintenance

● Consistently earned five-star ratings, qualifying for Elite status over the last 12 months Property Management•Santschi Trust, St. Louis, MO 12/2010 - 2018

● Collaborated with cross-functional teams including leasing agents, maintenance staff, and finance department to improve overall property management processes

● Utilized data analytics tools such as Excel to analyze property performance metrics including occupancy rates, rental income, and expenses communicated with clients to understand and meet their expectations for disinfection, organization, and overall household maintenance

Office Management•Century 21 Massa Ryan, St. Louis, MO 12/2002- 2004

● Supported the real estate team in preparing financial forecasts, budgeting, and variance analysis, contributing to informed decision-making processes

● Implemented process improvements and automation initiatives using Microsoft Office macros and scripting languages, reducing manual effort and increasing productivity

● Maintained confidentiality and integrity of sensitive property data, adhering to company policies and regulatory requirements

DATA ANALYSIS PROJECTS

Create Charts and Dashboards using Microsoft Excel Excel Dashboard Excel Demo 12/2023

● Sales to create dynamic visualizations, including monthly sales trends, salesperson performance, and sales percentages by product category

Querying databases using SQL SELECT Statement Portfolio 12/2023

● Successfully retrieved and filtered data from multiple database tables and applied various SQL operators and wildcard characters to refine data according to specific conditions, resulting in enhanced data accuracy and relevance

● Demonstrated mastery of advanced SQL operators (e.g. GROUP BY, ORDER BY) and comparison operators (e.g. BETWEEN - AND, IS NULL, IS NOT NULL), enabling precise data extraction and contributing to comprehensive insights

● Leveraged SQL knowledge to refine data presentation by retrieving distinct information, sorting data, limiting result sets, and employing SQL aliases for more effective data communication informed decision-making for cross-functional teams

● Cleaned and analyzed a dataset on food sales data over one year in Excel, creating views with data subsets to analyze, sales by month, sales by product,sales by city, and sales by person

● Created various visuals in Tableau, including bar charts, line graphs, and a map chart/other visuals, to display data conclusions, then compiled them into an interactive dashboard Data Analytics Data Camp Guided Projects • Guided Experience 01/2024

● flowers in math

● Analysis

● video games sql

Contact this candidate