Professional with strong background in managing and organizing student records. Skilled in data management, compliance with institutional policies, and maintaining accurate records. Known for fostering collaborative team environments and adapting to evolving needs. Reliable with proven ability to deliver results efficiently and effectively.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Student Record Coordinator
Carlos Rosario International Public Charter School
11.2022 - Current
Access multiple external databases to verify and upload data through SEDS, OSSE SLED, Quick Base, PCSB and attend monthly relevant webinars training
Create and consolidates student electronic and manual files and ensure that all prospective students' residency documents are appropriately validated to legal compliance with the Charter Authority and the school's admission requirements
Assist in identifying errors made during registration sessions and follows up on them
Support the planning and reporting of reports and verification of students data pertaining to the annual enrollment audit
Process students' admissions applications and tracking forms by reviewing data for deficiencies; resolving discrepancies and returning incomplete documents to the Registrar for resolution
Perform daily database updates efficiently and accurately.
Data Support Specialist
Montgomery County Public Schools• DCCAPS Dept
07.2021 - 11.2022
Design and maintain databases for the collection of records needed by the school consortia office
Import the database weekly in FileMaker and analyze the summary table
Prepare and print Choice/Assignment letters for DCC, NEC and MSMC area, and other target letters
Run the lottery of upper-grade part-time programs and follow up with the invitation letter based on their capacity
Respond to data requests from school coordinators and update the view of their FileMaker
Troubleshoot data-related problems and coordinate maintenance or modifications to correct defects
Support registration team for online enrollment and submit appeal letters for student transfer.
Data Entry Specialist
Carlos Rosario International Public Charter School
02.2018 - 07.2021
Manage data entry stations and enter student data into the system
Create and consolidate 2000+ student electronic files to ensure accurate completion, while also providing feedback on data collection processes
Utilize multiple external databases with efficiency to verify and upload data through SEDS, SLED, Quick Base, PCSB, and OSSE
Develop and prepare reports and verification of student's data pertaining to the annual enrollment audit
Execute data validation and conditional formatting to manage data for 2100+ students, while also using mail merge tools to prepare notification letters for individual students each semester
Demonstrate a mastery of Macros, Project Explorer, PivotTables, graphs, and dashboard creations to prepare reports on a consistent basis
Track necessary student immunization records provided to the Department of Health.
Accountant Assistant
Barry Zhang CPA
01.2017 - 05.2017
Interview clients to get a thorough picture of the financial situation
Prepare simple and complex tax returns for individuals or small businesses
Identify potential tax credits and liabilities and ensure accurate and complete returns in a timely manner
Help taxpayers by using their federal, state and local codes and make sure that clients receive the maximum benefit permitted under the law of government.
Coordinated timely payments from vendors, clients and account holders.
Data Analyst Intern
Global Energy Network Institute
09.2014 - 08.2015
Lead the Air Pollution and Energy Development Project to compare relevant data between China and the United States, using international databases from official organizations
Sort data using conditional formatting and create PivotTables based on given data
Analyze data in SPSS and Excel to look at air pollution levels, possible key factors, and energy structures between both countries.
Use statistical analyses to find patterns from data and identify improvement opportunities.
Assist with development of dashboards and reports using spreadsheet and visualization software.
Analyze and tracked data to prepare forecasts and identify trends.
Education
Master of Science - Biostatistics
San Diego State University
05.2016
Computer Technology / ITI
Montgomery College
Rockville, MD
Skills
Proficient in Microsoft Excel, SAS, JMP, R, SPSS
Familiar with Student Information System such as FileMaker, Maestro, Proactive
MS Office such as Advanced Excel
Comfortable working with diverse populations
Detail-oriented
Organization and Time Management
Information Analysis
Attention to detail
Time management
Data cleaning
Languages
Chinese (Mandarin)
Certification
SAS Certified Base Programmer for SAS 9
Querying Data with Transact - SQL
Timeline
Student Record Coordinator
Carlos Rosario International Public Charter School
11.2022 - Current
Data Support Specialist
Montgomery County Public Schools• DCCAPS Dept
07.2021 - 11.2022
Data Entry Specialist
Carlos Rosario International Public Charter School
Lead Preschool Teacher at Creative Minds International Public Charter SchoolLead Preschool Teacher at Creative Minds International Public Charter School