Jasper (Cheng Chuan) Mao Email & Phone Number

Bentonville, Ar, Us

Bentonville, Arkansas, Us

Bentonville, Arkansas, Us

New York, New York, Us

• Guided the manual flow of client-directed asset transfers, executed daily reconciliations• Generated accounting/financial reports with precision and accuracy under high-stress and high-volume environments.• Created and automated reports in spreadsheets that provide the clear and most current update of the information

Salt Lake City, Ut, Us

• Lead in performance analytics projects for the university’s IT department• Created and automated reports in spreadsheets that provide clear and the most current update of the information

New York, New York, Us

•Managed financial credit information updates on a timely manner for 3000+ hedge funds•Revised and automated NAV and performance reporting process through Excel •Wrote SQL script to increase proficiency in data analytics

West Valley City, Utah, Us

• Automated compliance reports using Excel VBA that reduce labor hours by 99.2%• Utilized Google online apps including, but not limited to, Google forms, Google sheets to improve communication among compliance teams within the school district• Ensured data quality and accuracy by monitoring and developing multiple Excel tools (Pivot Tables, slicers)

Rexburg, Idaho, Us

• Promoted to the leadership position as a senior data analyst• Managed a team of 5 data analysts in completing 100+ number of data analytics projects, employee training, and project coordination• Created forecasting model for the enrollment services with 0.2% of forecasting error• Modified and tracked forecasting accuracy

Rexburg, Idaho, Us

• Performed project base analysis for the institutional and research department at BYU-I• Built predictive analysis and Qualtric survey for the different departments on campus• Implemented student data and information to create forecasting and trend in academy, enrollment, and student housing using R, SPSS, and MySQL • Identified areas for improvement and built Excel applications using VBA to gather and analyze data used in daily and weekly decision making. Created Excel dash board for complex data to be user-friendly

• Networked with more than 10 companies in the supply chain/logistics industry • Managed a team of 5 to fill in speaker for the society's meeting schedule for the Spring 2017 semester

As part of the BYU-Idaho Integrated Business Core program, I worked for and managed projects in finance, marketing, and logistic departments for Panini Plus, a startup company.• Accounted accurately for all the financial transactions.• Established financial pro-forma and budgeting for each department.• Designed and executed 5 marketing promotions and increased sales by 20%• Delegated 4 business projects effectively and improved operating efficiency by 18%

Rexburg, Idaho, Us

• Conducted business analysis with a team of 3 in over 300 hours of in-depth research that led clients to make smart business decisions and resulted in future projects.• Worked with a virtual team of 8 research associates to exceed expectations by producing detailed leads for possible investors into a developing venture capital fund.

Salt Lake City, Ut, Us

• Raised over 23,000 dollars for BYU-Idaho through phone and email contacting and strong salesmanship skills• Increased revenue raised for scholarships and Pathway program by 17% • Updated the alumni of the school the latest news of BYU-Idaho

Central, Hong Kong, Cn

• Associated with more than 20 pilots from various countries and helped them solve any issues that came up with their documents and/or applications• Translated required documents for the Chinese airline pilots, including medical examinations, training certificates, and letter of consents from English to Mandarin Chinese• Compiled multiple commercial and advertisement pamphlets, marketing presentations, and ATPL test for customers

• Organized and cooperated with a troop of 100 men in effort to complete assigned missions• Responded promptly to commands and finished successfully 5 major combat simulations• Participated in trainings of critical thinking and tasks priority management

Master Of Science - Ms, Business Analytics

Bachelor’S Degree, Business Management