James Yu Email & Phone Number

Syracuse, Ny, Us

Collaborate with 8-person team to clean and build numerous 1,000,000+ record data files and reports for publication by the U.S. Department of Education using Excel (VBA macros, Power Query (M), PowerPivot (DAX), LOOKUPS, pivot tables) and PROC SQL (SAS). Write process documentation to train readers to read, clean, and/or build 1,000,000+ record data files and reports.

Syracuse, New York, United States

Migrated 10,000+ rows of data by (E)xtracting multiple spreadsheets via Google Drive API, (T)ransforming the data using Python (pandas, duckdb, openpyxl), SQL, and Excel, and (L)oading the data into a SQLite, star-schema database, stored on Google Drive using Google Drive's API.Programmed data collection instruments using Javascript in Google Apps Script, applying business rules that prompt data entry clerks to correct if they enter invalid data.

Syracuse, New York Area

Design data collection instruments and methodologies, prioritizing the accuracy and representativeness of the data; Survey, interview, and lead focus groups on-the-field and online with target populations in the 100’s to collect data; Recruit, train, and manage 5 data collectors to welcome respondents while ensuring data’s accuracy and cleanliness; Analyze 20,000+ rows of cleaned data visually using Excel, SQL, Python, Tableau, satisfying 100% of clients (N=4); Implement creative ideas, driven by research findings and partnering with community organizations and businesses; Mentor 12 diverse youth, teaching career exploration & development, secondary & primary research, arts, coding, etc.; Design curriculum to teach 12 SCSD high school refugee students career skills; design surveys and analyze survey data to measure if students are developing career skills to improve curriculum.

Syracuse, New York, United States

Consult Hendricks Chapel's development of Spiritual Life Council; organize events and programs to spiritually develop the Vineyard Student Group's members. Organized music for weekly church services for 50+ churchgoers; recruited, trained, and managed 14 college-aged band members, focusing on enhancing their spiritual development; organized a street performing homeless ministry to enhance the spiritual development of churchgoers involved. Shadowed religious nonprofit organization's Worship Pastor; developed a system for playing keyboard in the organization's band; taught piano to six people in a four-week class.

Syracuse, New York Area

Develop formative assessments to analyze then plan lessons that progress 80% of students’ state test scores (N=20); Consult teachers by recommending activities to include English language learners by using original literature reviews; Lead 10-person committee to strategize school-wide diversity initiatives with 2 teammates by reporting data analyses; Strategize and implement school and district-wide projects and professional development, meeting 100% of deadlines; Manage classrooms of 20+ elementary-school students, being rated an effective educator 100% of my career (N=20); Mentor 12 diverse youth, teaching career exploration & development, secondary & primary research, arts, coding, etc.

Syracuse, New York Area

Syracuse, New York, United States

Consulted clients to report requested findings from clients’ datasets, resulting in 100% client satisfaction (N=5); Cleaned, coded, and analyzed around 10,000 rows of quantitative and qualitative data by visualizing data using Excel; Collaborated with 19 teammates in 3-person groups to contribute data visuals and writing to 100+ page reports; Story-told research findings via oral presentations to clients, being 1 of 3 researchers chosen from 19 teammates; Persuaded nonprofits to launch databases and transformed paper logs into 2,000+ row Google Drive databases

New York City Metropolitan Area

Developed daily lesson plans with 3 co-teachers to teach high school seniors citizenship and introductory public policy analysis skills; Started a music club to teach high school students music performance, event-planning, and logistical problem-solving skills; Conducted research (designed surveys and interviews) with co-teachers to design consulting report proposing a leadership and public service skills development curriculum.

Syracuse, New York, United States

Build Excel database to record, analyze, and report Yeshua's data, used for team decision-making and grant-writing; design forms for updating database; construct training manuals to guide interns in updating, analyzing, and reporting data in database.

Syracuse, New York, United States

Conducted benchmarking analysis comparing SU's literacy program, Literacy Corps (LC), with 21 other college/university literacy programs; analyzed responses to evaluations to measure whether LC tutors are learning from their urban education experiences; revised evaluation tools to yield responses that more accurately reveal whether LC is achieving its goals; visualized data in multiple reports presenting benchmarking and evaluations analysis with research teams ranging from 5 to 20+ people; designed training manuals to teach future research interns how to collect and visually report LC's data.

Syracuse, New York, United States

Oversaw development of program mentoring 10 high school students through placements in part-time jobs; designed curriculum to train high school students and adult mentors.https://www.vcsyracuse.com/

Syracuse, New York, United States

Analyzed and visualized survey data from a 1,316-size sample to report to SUPA about its success in transferring credit.

Syracuse, New York Area

Partner with record label to release and promote Basket(s)' 5-song album. Hire, train, and collaborate with artist managers, consultants, art directors, financial directors, and performers to serve and develop Syracuse, NY's art culture by recording and performing original music.

Nashville, Tennessee, United States

Built and managed Excel database to monitor prints/copies made by 103 Corps Members (CMs) and 54 staff members; analyzed and reported data trends to inform team decision-making; advised CMs and staff members on solving technological issues, yielding 88% satisfaction with services; created video lessons to train next Operations Coordinator on building and managing database and analyzing data.

Dallas/Fort Worth Area

Connected virtually with 203 Uplift North Hills Preparatory alumni to peer mentor them on persisting in college; collected and communicated data from mentoring to Uplift Education administration to inform curriculum decisions.

Syracuse, New York Area

Taught study skills to college students enrolled in History of Modern Design (ART 113), History of Modern Art (ART 111), and/or Economic Ideas and Issues (ECN 203).

Syracuse, New York, United States

Facilitated group discussions and graded papers to teach public policy analysis skills to 17 SU students.

Syracuse, New York, United States

Organized events with instructor to orient 15 first-year students to Syracuse University, its Honors Program, and the city of Syracuse.

Syracuse, New York, United States

Assisted five teachers with acclimating 25-30 Dr. Weeks Elementary Pre-K students to classroom environment.

Syracuse, New York Area

Developed arts and academic-based community with $3,500 budget for 64 first-year SU students through event planning, floor policymaking, conflict resolution, and role modeling.

Syracuse, New York, United States

Assisted five teachers with math and reading instruction in a 20-student 7th grade Inclusive Education class at Lincoln Middle School; created annotated bibliography of social sciences books for the SCSD's grades 3-5 curriculum.

Nashville, Tennessee, United States

Analyzed data to report whether expenditures were within budget to Teach For America's Finance and Contracts Team.

Master Of Science (Ms), Teaching English Language Learners, 3.92 Gpa

Bachelor Of Arts (Ba), Policy Studies & Art, Minor In Entrepreneurship And Emerging Enterprises, 3.91 Gpa

Specialization in Education, Health, and Human Services Public Policy

High School Diploma