Joy Qinqin Zhao Email and Phone Number

- As product owner, developed and maintained the Ohio Student Growth Report which is used for teacher evaluation for 260 accounts impacting 18,000+ teachers in Ohio * Planned timeline and drove progress of a cross-functional 6-people team and 2 stakeholders to ensure on-schedule release * Developed SQL queries to clean and report data (0.8 million records) on student, teacher, school, and district levels; led internal and external quality assurance of the code * Collaborated with data engineer to develop and test a web application for account manager self-served report generation * Presented the report and provided web app instructions to VP of account management and all Ohio account managers - Queried and prepared analytical datasets from Redshift, My SQL, and SQL Server databases with 60 million records - Developed highly customized and scalable data visualizations using SAS for student performance and growth reporting impacting all major accounts with 4 million students and 0.3 million educators; updated code documentation of 10+ programs - Responded to 40+ cases from educators about product functionality based on data analysis with 100% customer satisfaction - Streamlined custom report and case management processes, reducing operations time by 15%

- Designed multimedia online curriculum and curate a resource library in Canvas to train 130+ faculty members to build online courses that impact 900+ students each academic year- Developed 2 adaptive exercise tools for library orientation and research skills training, and cross-train 2 teams on the tools

- Devised and executed a strategy to increase 4,000+ employees’ usage of online training resources by 40% based on research findings; data-driven report and presentation were publicly commended by senior management of Engineering Practice- Conducted research including analyses of 1-year usage data of 4,000+ users and interviews with 22 global employees to understand Autodesk employees’ motivations, perceptions, behaviors, and outcomes of using online training resources- Coordinated and evaluated training programs for engineers, which 85% of participants rated as “highly recommend” - Co-developed an automated user management tool (coded in Python), saving 160+ hours of manual work for the team annually- Managed 8 team projects, planning timelines and tracking progress, of which goals were 100% achieved ahead of schedule- Co-designed an agile training program with the Agile Transformation Team

- Managed Penn’s 84 Coursera and edX courses with student enrollments totaling 4.6 million as of May 2016- Analyzed trends of enrollment, active rate, and course completion rate using 3-year course data; presented findings and recommendations to the Provost Office to increase output of student enrollment- Created the first recommendation list of 100+ educational applications for incorporation into faculty members’ course design

- Designed workshops and gallery activities, enhancing visitor engagement of guided-tours (700+ participants each month)- Designed, wrote, and recorded the first audio tour in Chinese which will attract 100% more Chinese visitors each month

- Designed and recorded 11 online courses (50-hour video lectures) independently using various interactive techniques; held live course sessions and public online talks with 20,000+ followers

- Taught vocabulary, grammar, reading and listening to 3 classes of 7th grade students; provided individualized after-class tutoring for 17 students

- Led social media marketing, website content development and digital journal editing, designed and executed online events, increasing subscriptions by 150% and pageviews by 120%- Designed posters, flyers and banners that were used in 40+ information sessions and events over one year- Assisted with media and NPO relations to fundraise RMB 2,360,000+ for an alumnus suffering from uremia- Managed and optimized workflow of corps member recruiting, saving 30% of project time- Led the intern team to create TFC's first intern handbook; assisted with new intern recruiting