Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

Qing Ren

Greenbelt,MD

Summary

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
02.2018 - 07.2021

Accountant Assistant

Barry Zhang CPA
01.2017 - 05.2017

Data Analyst Intern

Global Energy Network Institute
09.2014 - 08.2015

Master of Science - Biostatistics

San Diego State University

Computer Technology / ITI

Montgomery College