Liping Sun
Lead Data Analyst at Wonderful College Prep Academy- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SAS Certified Advance Programmer for SAS 9
SASOct, 2017- Oct, 2024 -
Oracle Database 11g Administrator Certified Associate
OracleFeb, 2016- Oct, 2024 -
SAS Certified Base Programmer for SAS 9
SASMar, 2015- Oct, 2024 -
C Programming Language
National Education Examinations Authority Ministry of Education(People's Republic of China)Sep, 2011- Oct, 2024
Experience
-
Wonderful College Prep Academy
-
United States
-
Primary and Secondary Education
-
100 - 200 Employee
-
Lead Data Analyst
-
Apr 2021 - Present
-Data Analysis Establish data ETL pipeline by 1)extracting and connecting complex data sets from multiple platforms using different technologies including API calls, ODBC data connection, Google Sheet connector. to gather student, staff, and operational K-12 data. 2)transform to a centralized and standardized data and analyze data using statistical methodology by using the Python and R programming languages. Produce summary report, correlation report, statistical regression reports. 3)load to Business Intelligence platforms including Tableau and PowerBI to identify, analyze and interpret trends and patterns for leadership team for decision making. -Data Management Create protocols for collecting, verifing, and managing assessment (Aeries, NWEA, Illuminate, ANET, Lexia) systems on the backend for data cleansing and reporting features. Primarily focused on SIS updates, roster verification, and standards processes for systems to produce valid and reliable results for analysis. -Data Reporting Serve as lead administrator to prepare, verify and present for school data, Authorizer reports, Federal Grants reports and compliance-related data reports to executive team and stakeholders. Provide insights that drive action and consistent growth in student achievement, organizational performance and professional practice. Show less
-
-
-
MERRICK ACADEMY QUEENS PUBLIC CHARTER SCHOOL
-
United States
-
Education Administration Programs
-
1 - 100 Employee
-
Data Specialist
-
Oct 2019 - Mar 2021
• Performed analysis on complex data sets for executive team and board members to produce insights through dashboards, visualizations and reports. • Collected and analyzed organizational data for school renewal. Successfully helped the school won a 5-year renewal. • Implemented dynamic data visualization for academic team containing advanced calculations, parameters, action filters, and table calculations in Tableau to track outcomes and impact. Facilitated multiple type of intervention programs to help close students’ achievement gaps. Show less
-
-
-
SEED Public Charter School of Washington DC
-
United States
-
Education Administration Programs
-
1 - 100 Employee
-
Data Analyst
-
Jun 2016 - Sep 2019
• Retrieved and organized the efficient metrics to measure program effectiveness for various departmental priorities including Finance Department, Intervention program, Satisfaction/Engagement Community, and Academic department by frequently using pivot table and R. • Aggregated and organized business intelligence data visualization dashboards on the platform Qlik Sense for HOS and senior leadership as per “Data System Plan”to explore data and discover insights which lives online. • Served as the POC to support and monitor the preparation of data submission, statistical reports on educational activities for government and educational agencies (OSSE & DCPCSB) through different information systems (Powerschool, Quickbase, Qlik Sense, SunGuard K-12, Socrata). Show less
-
-
-
FOCUS (Friends of Choice in Urban Schools)
-
United States
-
Civic and Social Organizations
-
1 - 100 Employee
-
Business Intelligence Analyst
-
Feb 2016 - May 2016
• Worked on standardizing historical student data to move into a data warehouse creating automatically updated data records template. • Implemented dynamic data visualization using Tableau, connected the dashboard template I created to schools data warehouse for publishing operation • Worked on standardizing historical student data to move into a data warehouse creating automatically updated data records template. • Implemented dynamic data visualization using Tableau, connected the dashboard template I created to schools data warehouse for publishing operation
-
-
-
China Southwest Securities Co., Ltd.
-
China
-
Financial Services
-
1 - 100 Employee
-
Intern as Assistant Analyst
-
Jul 2013 - Sep 2013
-Collected, disposed and analyzed industry and market information related to financial risk management; consolidated and monitored the risk situations of the company, reported risk warnings and kept track of risk events -Assisted to build the quantitative model system of risk including VaR analysis, sensitivity analysis, and pressure test -Collected, disposed and analyzed industry and market information related to financial risk management; consolidated and monitored the risk situations of the company, reported risk warnings and kept track of risk events -Assisted to build the quantitative model system of risk including VaR analysis, sensitivity analysis, and pressure test
-
-
-
-
Data Analyst Intern
-
Feb 2013 - May 2013
• Participated in a project about studying the competitiveness evaluation of regional tourism industry through stages from designing questionnaires, sample surveys, data entering and cleaning. • Conducted factor analysis, principal component analysis and variance analysis on the cross-section data of 2012 to compare the competitiveness of regional tourism industry in Hainan province with other 30 provinces. • Participated in a project about studying the competitiveness evaluation of regional tourism industry through stages from designing questionnaires, sample surveys, data entering and cleaning. • Conducted factor analysis, principal component analysis and variance analysis on the cross-section data of 2012 to compare the competitiveness of regional tourism industry in Hainan province with other 30 provinces.
-
-
Education
-
2014 - 2016
The George Washington University
Master of Arts and Science (M.A.), Statistics -
Hainan University
Bachelor of Science, Statistics
Community
