Siyu (Seraphina) Lu
*** ******** **, ******** ****, NJ, 08904
Mobile Phone 304-***-**** Email: ac8kin@r.postjobfree.com Education
University of Maryland, College Park, Robert H. Smith School of Business College Park, MD Master of Science in Information Systems August 2017 – December 2018 West Virginia University Morgantown, WV
Bachelor of Science in Business Administration August 2014 - December 2016 Major in Management Information System GPA 3.42/4.00 Technical Skills
Programming Language: Visual Basic, Visual Studio 2015, C# (MVC, ASP.NET) Data Science and Data Management: R, PYTHON, SQL Server, Hadoop, Sqoop, Hive, Pig, Spark, AWS Application Software: Windows Office (Word, Excel, PowerPoint, Access), Flash, Tableau Professional Experience
PricewaterhouseCoopers Management Consulting (Shanghai) Limited Shanghai, China Intern in Consulting Function, Big Data and AI Data Technology Group June 2018 – August 2018
• Participated in well-known insurance company intelligent underwriting project. Established and improved PwC external database with 50 fields of enterprise data and 26 fields of customer data to summarized over 20 underwriting rules and increase accuracy of predictive analytics based on machine learning and deep learning.
• Build a real-time supervised risk underwriting model by Random Forest and KNN to identify customers’ characteristics and summary underwriting rules; Conduct clustering analysis by K-means for customers’ segmentation.
• Managed client relationship by communicating front-end and back-end development of intelligence underwriting system, and data analysis method in establishment of underwriting rules. Deloitte Touche Tohmatsu CPA Ltd. Shanghai, China
Intern in Audit Function, GFSI Group July 2016 – August 2016
• Reviewed quarterly financial information and analyzed financial statements of 100 companies.
• Designed and sent approximately 200 standard audit confirmation requests to target clients and collected response.
• Sampled cut-off test in 6 months and designed tests of internal controls; Cooperated with project manager to edit non-operating income and expense working papers for semi-annual report. Bank of China Limited Shanghai, China
Intern in Assistant of Personal Financial Manager May 2013 – September 2013
• Verified potential Point of Sale system application while recorded statements and feedback from 500 current customers. Supervised approximately two thousand credit card applications to determine credit and eligibility.
• Facilitated currency exchange for company tour guides. Expanded customer base by 500 people through phone call and customer face-to-face marketing.
• Directed customers to sign loan contract and reviewed almost 50 loan documents in compliance with company regulations.
Academic Projects
Airbnb High Booking Rate Predictive Analytics Model (R, Python, Excel, Tableau) Feb 2018 - May 2018
• Collaborated with team of five to predict high booking rate on Airbnb.com – achieved model accuracy of 84.17%.
• Participated in data cleansing and preprocessing of 1GB dataset; applied Tableau and Python for iterative feature selection and engineering; built Tree model, KNN, and Logistics Model in Python.
• Utilized tree based gradient boosting classifier as parameter tuning model, winning first prize with the highest accuracy in twelve teams.
College Ranking Information System Development Sep 2017 - Dec 2017
• Led user story and ER diagram development, developed SQL query structure and table structure for 500 record Microsoft SQL Server database of college ranking data.
• Conducted marketing research via the Internet and literature materials, cooperated to complete functional features and technical feasibility comparison, identified benchmarking products and development technical framework.
• Participated in the design of ERD, DFD and the finalization of data dictionary; used SQL Server to complete partial database construction and SQL Query code writing tests. Awards & Honors
CUM LAUDE West Virginia University December 2016