Rona Zihui Fan

**** ******* ***, ********, **, **705 310-***-**** acvvue@r.postjobfree.com

Summary

Problem solver with training in both left and right brain thinking. Skilled in analyzing internal processes, data and problems, and issues and areas for improvement by coordinating with a cross functional team to obtain solutions.

Education

University of California, Los Angeles, Los Angeles, CA BS in Psycholinguistics, B S in Statistics, March, 2016, G PA: 3.62/4.00, D ean’s Honor List Work Experience

Business Analyst, S tandard and Poor’s,

New York, NY 05/15 08/15

● Analyzed internal process, data and problems and successfully identified root causes that troubled a reverse mortgage loan portfolio.

● Ensured accurate and timely project delivery by working closely with internal stakeholders throughout the entire project life cycle, i.e. collecting, cleaning, analyzing the data and presenting the findings to the team.

● Conducted GAP analysis and identified issues that troubled the Excel model. Carried out in depth and thorough analysis of the entire portfolio and identified the root causes for the discrepancy, i.e. deferred interest not got carried through, deferred fees not reflected in the month when it should be applied, etc.

● Interviewed business users and the modeling team to ensure clarity on the underlying methodologies, formulas and data treatment methods.

● Developed an automated the reverse mortgage credit rating model using Python based on reporting guidelines and methodology to enhance accuracy and efficiency.

● Mapped internal processes to improve how people work together by creating a log report to ensure transparency and accountability throughout the project. Business Analyst, Resolution Economics LLC,

Los Angeles, CA 09/14 12/14

● Analyzed the business requirement of whether a dairy company violated labor law by asking their employees to work during lunch breaks without proper compensation.

● Using Excel, VBA and SAS, cleaned and normalized 2,000 rows of raw time log data. Visualized data using R and found outliers where work hours entered did not match these submitted on hand written forms, and singled out driver records that exhibited anomaly for further analysis.

● Wrote a SAS program based on family construct of truck drivers, using variables such as: family income, marital status, work hours, lunch hour duration, etc. Analysis indicated that drivers who are the only source of family income tended to tolerate employer’s request of working during lunch breaks without proper pay.

● Developed PowerPoint presentation and presented the findings to internal consultants. Findings were included as part of the presentation deck to external Client. Research Assistant, Staglin IMHRO Center for Cognitive Neuroscience & Semel Institute. Los Angeles, CA 09/12 09/15

● Implemented machine learning algorithm into fMRI technology to understand the functional significance of temporal lobe in controlling human attention.

● Implemented machine learning algorithm to fMRI technology to predict whether the temporal lobe have functional significance in controlling human attention.

● Communicated data analysis and findings through data visualization from initiation to delivery. Skills P ython, R, SAS, Excel, SQL, Mongodb, T ableau, SQL Server Reporting Services. Language Mandarin Chinese, Korean, Polish

Certifications Udacity Data Analyst NanoDegree

Awards Best Product Overall, SF Fashion Hacks, 2016, Best Product, Overall, LA UXPM Summit Hacks, 2015