Yating (Margaret) Lan

***A Tehama Street, San Francisco CA 94103

acv2g4@r.postjobfree.com 812-***-****

SUMMARY

Motivated team player, passionate about data analyst and business operation, with proven leaning agility, attention to details, strong business acumen and technical understanding, is seeking an entry level opportunity in business technology analytics.

EDUCATION

Stevens Institute of Technology, Howe School of Technology Management Hoboken, NJ

Master of Science in Business Intelligence and Analytics (GPA: 3.69/4.00) May 2016

Core Courses: Optimization and Process Analytics, Strategic Data Management, Social Network Analytics, Web Analytics, Marketing Analytics, Supply Chain Analytics, Knowledge Discovery in Databases

Indiana University Bloomington, Kelley School of Business Bloomington, IN

Bachelor of Science in Accounting, Finance and Technology Management December 2013

Core Courses: Accounting Information Systems, Communication for Accountants, Working Capital Management

SKILLS

Advanced in MS Office, SAS, PowerPivot, and Financial Modeling

Experience in Oracle SQL, MS Visio, MS Access and Tableau

Knowledge of SDLC, Data Modeling, ETL, Use Case and Workday

SAS Certified Base Programmer Certified

Fluent in Chinese and English

ACADEMIC PROJECTS

User Response Analysis Fall 2014

• Designed survey for past participants and analyzed users valuation decision factors for online courses system by implementing ANOVA F-test, multiple comparison and different randomized design and tests in SAS

Financial Performance Insights from Tweets Spring 2015

• Analyzed 3 month tweets to predict company financial performance with the assistance of SAS Enterprise Miner text mining analysis and social neural network analysis in R, compared with company 10K fillings and Q1 earnings report

DW and BI Design for Nielson Television Market Fall 2015

• Developed relational database for Nielson local digital media sector including entity-relationship and schema design, implementation and analysis, to help with company marketing strategy planning

Text Analysis – Track of Disease From Medical Documents Fall 2015

• Analyzed and classified text in 247 SDB related articles to identify potential pattern of symptom and treatment, figured out main researcher, topics, location and their future research trends; generated a social networks graph using NodeXL

What Make a Popular News Fall 2015

• Compared and implemented best machine learning method and model in SAS Enterprise Miner to find popularity decisive factors to online news, studied and analyzed most influential news contributor

Hidden Meaning in Titanic Disaster Spring 2016

• Cleansed and processed titanic data set for predictive analysis, studied and analyzed most recognize pattern, classify decisive factors, and visualized prediction for future events

EXPERIENCE

Stevens Institute of Technology, International Student and Scholar Services Hoboken NJ

Graduate Assistant September 2014 – June 2015

Assisted international students and scholars on preparation and completion of non-immigrant work authorization, travel applications and other immigration documents

Processed initial hard copy and electronic files for designated school officials and immigration advisors

Maintained and updated student data into university based student information system

Interpreted during meetings and for documentations when necessary

Indiana University Bloomington, Volunteer Income Tax Assistance (VITA) Bloomington IN

Tax Consultant Tax Season 2011 – 2012

Provided personal tax advisory and assistance to people with low-to-moderate income, senior citizens, persons with disability and others who need assistance in preparing their own tax returns

Completed over $2000 total tax return for people who need assistance in preparing their own tax returns

Conducted pre-screenings interviews focusing on various tax credits that low income taxpayers may receive

Provided language interpreter services to customers who are not fluent in English

Beijing Xing Hua Certified Public Accountants Beijing China

Audit Intern July 2011 - August 2011

Participated in fiscal year auditing for 8 international schools and consulting firms with an aggregated value of $ 200,000

Performed account reconciliation for accounts receivable, accounts payable and payroll, translated English written financial documents and supported the development of the ending certification reports

Generated reconciliation reports for fixed and capital assets based on historical invoices and balance sheets

Collected, organized and copied client working papers for audit consolidation and archives

Contact this candidate