Business Intelligence Office Assistant

zMI*NSFP************

Peilin Gong

***** **** ****, ********, ** 11355 646-***-**** ad5yf9@r.postjobfree.com

SUMMARY

Strong analytical ability/skills utilizing large dataset for data analysis and business intelligence

Proficiency in computer programming such as Python and SQL as well as in Microsoft Office applications

Efficiency in Statistical software package R & Tableau

Strong team players & quick learner

EDUCATION

Zicklin School of Business, The City University of New York, NY

Master of Science in Quantitative Methods and Modeling – Expected May 2025

Baruch College, The City University of New York, NY

Bachelor of Arts in Actuarial Science, minor in Psychology and Business Law, GPA 3.3, Jan 2022

PROFESSIONAL EXPERIENCE

Office Assistant - Zhao Gastroenterologist, Flushing, NY 07/2021 - Current

Manage front office functions such as patient check-in/check-out; Handle scheduling patients, answer patient questions, and track & respond to ongoing prospective patient inquiries

Check patient's eligibility & update insurance coverage status with insurance companies

Update patient charts with latest information on testing results & latest diagnosis

Perform other projects as requested

Customer Service Representative - CoCo Fresh Tea and Juice, Sam's Club, Flushing, NY 07/2017 - 07/2019

Created/updated daily sales reconciliation sheets/charts

Performed transaction audits; Maintained appropriate inventory levels; Conducted and followed month-end inventory procedures

Provided customers satisfaction and addressed any complaints with sincere attention

PROJECT EXPERIENCE

Movie Popularity and Profitability Study, Zicklin School of Business, The City University of New York, NY

Worked together with a team to study movies’ popularity and profitability by analyzing ten years of data on movie ticket sales, timing of movie release, movie type, audience composition, etc.

Utilized Python and R for conducting trend analysis. Utilized Tableau and Excel for data visualization and analysis

Database Normalization Project - BAR App Development, Zicklin School of Business, The City University of New York, NY

Developed an easy-to-use app for validating nightlife goers age for entertainment venues

Designed the efficient relational database using BCNF (Boyce-Codd Normal Form) technique

References Available Upon Request

Contact this candidate