Rachel Zhou
Research and Policy Intern at Commonwealth Corporation- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Commonwealth Corporation
-
United States
-
Government Administration
-
1 - 100 Employee
-
Research and Policy Intern
-
Jan 2023 - Dec 2023
33 Harrison Ave, Boston, MA 02111 • Develop and design an interactive program KPI performance Tableau Dashboard, containing 11 tabs with more than 60 graphic sheets, delivering comprehensive information over the past three years to targeted stakeholders (state government and external users) • Present the Tableau Dashboard to managers, directors, and vice presidents for content validation and consistency, ensuring readiness for publication on the company’s webpage • Retrieve data through SQL and HTML, generate reports on… Show more • Develop and design an interactive program KPI performance Tableau Dashboard, containing 11 tabs with more than 60 graphic sheets, delivering comprehensive information over the past three years to targeted stakeholders (state government and external users) • Present the Tableau Dashboard to managers, directors, and vice presidents for content validation and consistency, ensuring readiness for publication on the company’s webpage • Retrieve data through SQL and HTML, generate reports on Excel pivot table to analyze the grant program participant (21k+ participants) demographic information, facilitate improvements in the application process, and increasing general participant satisfaction rating by 9% • Host a cohort meeting, confirm discussion content with invited guest speakers and organize interactive panel discussions involving nine participants, addressing the topic ‘Gen-Z in the workplace’, fostering meaningful dialogue between speakers and interns. • Conduct Excel and Tableau workshop sessions, focusing on data manipulation, visualizations, and dashboard layout. Show less
-
-
-
Suffolk University
-
United States
-
Higher Education
-
700 & Above Employee
-
Geno A. Ballotti Scholar: Marketing Art & Design Scholar
-
Jan 2021 - May 2021
73 Tremont St, Boston, MA 02108 • Managed and designed the daily post for CLAS Instagram • Worked coordinate with clubs’ social media directors to help promote school events • Tracked the visit numbers and likes for each post and analyzed the shared characteristics for the popular posts
-
-
Peer Tutor
-
Feb 2020 - May 2021
8 Ashburton Pl, Boston, MA 02108 • Offered 21 different courses tutoring service • Guided students by offering strategies to strengthen the learning experience and build up long-term learning skills • Helped to clarify difficult concepts and theories in academic subjects • Gathered the experience of addressing the academic struggles with different students
-
-
Education
-
Boston College
Master of Science - MS, Applied Economics & Applied Analytics Dual Degree -
Suffolk University
BSBA in Accounting and Big Data, GPA: 3.9/4.0, Department GPA:4.0/4.0 (both majors) -
Bethlehem Catholic High School
High School Diploma