Alice Tan Email & Phone Number

Chicago, Illinois, US

Waukesha, WI, US

• Created the 1st dashboard for the team to visualize user activities and system integration progress in PowerBI. Enabled the team to have an overview of the progress and target users who are behind. Improved business.
• Wrote a python script automate a previously manual and time-consuming data collecting progress. Improved team efficiency by 20% and saved 3 hours on average.
• Redesigned a data table connecting with multiple databases to improve PowerBI calculation efficiency by 60% through SQL.
• Collaborated with various project manager and development team members to maximize the benefits of the applications.

Houston, Texas, US

• Identifies specific business requirements as communicated by a sponsoring business area, including cross-referencing requirements articulated by multiple business areas
• Applies knowledge of supported business areas in evaluating opportunities for process integration and refinement
• Identifies gaps and analyzes downstream impacts of business requirements makes recommendations for improvements and/or additional requirements within assigned business areas
• Performs data analysis related to business requirements and may perform data analysis related to production issues

• Worked cross-functionally to assist with reporting and Salesforce.com needs at all levels of business
• Created custom ongoing and ad hoc reporting to provide management with oversight of team performance.
• Coordinated with IT to generate Business Requirements Documentation, logic creation, and process mapping.
• Developed and maintained current solar pricing system with Microsoft Access & VBA.
• Rewrote VBA Modules in Python to increase data processing efficiency when necessary.
• Automated report generation with SQL queries in Microsoft Access.

Irvine, CA, US

• Communicated with research group about project requirement and potential outcome during JRD meeting.
• Examined Atmospheric Model Intercomparison Projection precipitation models using MATLAB
• Performed data profiling task with Macros in Excel to filtering out data with excessive deviation.
• Processed 4-Dimensional models in NetCDF files and extract data for post processing.
• Assisted lab supervisor with creating new feature class and digitalizing points on ArcGIS.
• Analyzed the mechanisms that cause prediction differences between different models

Irvine, CA, US

• Directed and supervised overall operations and student staff activities of the club.
• Planned and organized bi-weekly club social activities with board members.
• Communicated with UCI Earth System Science Department to calculate and finalize annual budget cap.
• Initiated club mentorship program in 2017, resulting in the matching of 22 mentor-mentee pairs.
• Improved membership registration process by creating an online system.
• Prepared spreadsheet and presentation slides in Word and PowerPoint document for meetings and workshops.

Oakland, California, US

• Design and manage field sampling research program. Thesis: Coastal dune invasion and restoration at Point Reyes: the ecology of European sea rocket, ​Cakile.
• Wrote and proofread final research paper with team members (Names ranked by last name initials).
• Individually designed and presented research proposal during research thesis conference.
• Analyzed statistical data with JMP Statistical Software by implementing ANOVA and Tukey tests.
• Worked collaboratively with team members and faculties who came across different UC campuses

Irvine, CA, US

• Developed extensive understanding of chemistry concepts and strong ability to communicate information
• Developed public speaking skill by holding review sessions before exams for a lecture session consisted of 300-400 students.
• Facilitated a learning environment for one-on-one tutoring during weekly office hours.
• Initiated contact with professors to discuss and obtain relevant course materials.
• Participated in three continuously quarters to increase skills relating to teamwork, communication, and leadership.

Master Of Science - Ms, Business Analytics

Bachelor’S Degree, Geology/Earth Science, General