Clarice S. Email & Phone Number

New York, NY, US

New York, NY, US

• Created annual transportation network mapping and conducted transportation route analysis using Tableau
• Conducted analysis of freight cost by type, vendor and region to help the team understand cost
• Built dashboard using Smartsheet to improve project timeline management efficiency. Designed automatic workflow and reminder trigger
• Conducted supply and demand analytics using SQL, R, and Power BI (products shipped vs. bought, sales trend reports)

New York, NY, US

• Initiated career outcomes analytics project in the School of Professional Studies
• Analyzed and visualized employment status of over 1,000 graduates using Excel and Tableau. Composed a comprehensive report in the form of text, heat map, bar chart, table and radar chart.
• Helped with event organization, post job blast and provided career development suggestions for students

• Developed a new credit score model from multiple data sources for evaluating loan applicants’ creditworthiness to repay debt in full
• Conducted exploration data analysis, feature engineering, value distribution analysis and dimension reduction
• Applied advanced machine learning models such as Random Forest, GBM and XGBoost to predict the probability of default

New York City, New York, US

• Helped to build a framework for a WEF white paper on blockchain application and collect data for further analysis
• Conducted market landscape research and presented research results to founding partners at Prysm Group

Hong Kong, HK

• Assisted clients with due diligence, market landscape research, simplifying business processes, and building auditing program guidesPerformed in-depth data analysis for projects across various industries and prepared.
• Guangzhou China Mobile Internet Special Auditing Project on the Network Management Outsourcing− Analyzed COGS and operating expenses to identify 68K+ units of missing materials to save client 4MM RMB in costs savings−.
• Financial Robotic Process Automation Project in Hengda Property Developer Company− Utilized Uipath to program 2 financial frameworks to automate the data entry process and synchronize information in the financial.
• Guizhou China Mobile Auditing Project on Marketing Operation KPI− Built a marketing plan evaluation model to identify 6 low-yield marketing plans by analyzing budget, customers acquired, ROI
• China Telecom Auditing Project on Marketing Supporting System− Led team of 3 in auditing IT system, including assessment of data access, program development, operations, and system security

Guangzhou, Guangdong, CN

• Served as the teaching assistant for two courses: Financial Management and Managerial Accounting
• Organized review session and helped students with the use of Excel functions
• Assisted with course administration：prepared teaching materials, managed student attendancesheet, collected teaching feedback, organized examinations and score registration

Master Of Science - Ms, Applied Analytics

Bachelor'S Degree, Finance, General

Exchange/Non Degree Seeking Program, Finance, General