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 logic, data structures and reporting metrics • 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 impact from new event structures on current data ingestion logic.• 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