Joyce S. Email & Phone Number

Chicago, Illinois, US

• Worked with backend engineers on the architect of the data tables for the Topics service, provided data quality checks to ensure session volume and key variables match the source tables.
• Facilitated cross collaboration and understanding between data engineering, analytics, experimentation and product by shepherding conversations around table enhancements that include data pipelines, ETL ingestion.
• Drafted JIRA tickets for new data assets, clarified project scope, managed risks and identified project blockers
• Documented table definitions, key ETL joins needed for proper data ingestion and drafted technical documentation about the topics service that powers clickstream front end events

Chicago, Illinois, US

• Defined clickstream event structures in JSON and implemented analytics tracking for new features and/or enhanced existing tracking.
• Created base queries in redash to provide session funnel analysis and/or data quality checks around specific features.
• Developed Tableau data monitoring dashboards for search and menu to monitor data quality and enhance the utility of clickstream data among internal clients - product managers and the experimentation team.
• Performed data gap analysis on diner search analytics, drafted JIRA tickets for front-end engineers to implement new or enhanced tracking, QA’d engineering implementation and informed data engineering team of possible.
• Led the analytics redesign for the Topics Service (content management system) that powers various client services for discovery and search.

Chicago, IL, US

• Developed hypothesis testing scenarios to gather insights on how to effectively execute a preference center.
• Utilized R and Excel to extract, clean, and create recipient lists for regular broadcasts and reminder messages.
• Supported data warehouse migration by transferring MSSQL queries to Snowflake queries and verified the accuracy of the data stored in the new data warehouse.
• Designed new reporting templates in Micro Strategy and migrated static excel reports to dynamic, insightful dashboards

Chicago, IL, US

• Managed weekly, monthly and ad hoc report requests for over 10 clients inclusive of national and international retailers and restaurant chains.
• Developed SQL queries that aggregate data from the enterprise data warehouse to analyze campaign performances and presented findings and future strategies for testing and/or program improvement
• Supported reporting requirements for pilot programs by data pulls, custom SQL queries, and creating dashboards.
• Tagged mobile and web experiences via Google Analytics to collect customer engagement data and presented wrap reports on experience performance.

Chicago, IL, US

• Enhanced and customized reporting dashboards for over 4 clients.
• Defined mobile marketing key metrics and developed SQL queries to run benchmark analysis on.
• Developed custom SQL queries for ad hoc client requests.

Chicago, Illinois, US

• Developed and maintained weekly ad hoc reports using Vlookup and Power Pivots for senior credit risk modeling and quantification committee to monitor correct action plans (CAPs)
• Reviewed and edited PD and LGD model results documentations for inconsistencies in data analysis, findings, methodologies
• Back tested & monitored not for profit (NFP) bank model and documented SAS code logic for future reference.

Chicago, IL, US

• Created an intra-office labeling system to improve admission and document scanning process, resulting in reduced access time to folders/documents and increased productivity by 5%.
• Managed the day-to-day administrative operations at the Graduate Admissions Office.

Chicago, IL, US

• Developed excel dashboards to visually showcase improvements in branch and employee performance for the Head of Strategy and senior executive team.
• Identified performance metrics and established performance threshold(s) to manage the efficiency of regional branch functions.
• Established daily, weekly, monthly targets for individual branches to maximize the efficiency of cash operations. Acted as HR SME in human resource functions and training programs.

Terre Haute, IN, US

• Conducted professional interviews to collect data on best practices, training programs, and the establishment of new evaluation techniques.
• Presented 5 months of research findings via presentation and report form to senior leadership.

Master Of Science (M.S.), Predictive Analytics, Computational Methods

Master Of Business Administration (Mba), Finance & General Management

Bachelor Of Arts (B.A.), English Language And Literature, General