Yilun Sheng (Connie)
***********@*****.***
**** ****** **, *** *****, CA 94403, 319-***-****
EDUCATION
Tippie College of Business, The University of Iowa, Iowa City, IA May 2014
B.B.A. Management Information Systems
COMPUTER SKILLS
Languages: BASIC, PASCAL, PYTHON, HTML, CSS, PHP, SQL
Operating Systems: Windows, LINUX
Software: Microsoft Office, Microsoft Visual Studio, Microsoft SQL Server, Oracle SQL Developer, Adobe Dreamweaver
CERTIFICATIONS
IPv6 Certification, Certificate of Completion, Rank of Sage, Hurricane Electric May 2014
Scrum Master Certified (SMC™), SCRUMstudy, VMEdu Anticipated February 2016
WORK EXPERIENCE
Compliance Agent (Contract through Sunrise Systems Inc.) December 2015-January 2016
PayPal, San Francisco, CA
Obtained working knowledge about AML (Anti Money Laundering)
Worked under the Venmo team for the AML Compliance Project
Reviewed OFAC (Office of Foreign Assets Control) alerts received from PayPal teammates
Performed decision making on dismissing alerts as false positive or escalating to OFAC after investigating payment related users' transaction history and social media accounts
Updated compliance review log on an MS Excel spreadsheet backlog, as well as on the Venmo Underground, the Venmo website backend
Sent out emails to customers for social feed comments clarification
Student Computer Assistant March 2012-May 2014
Athletic Student Services, University of Iowa, Iowa City, IA
Organized, filed and scanned massive confidential documents into an online/physical duo database with corresponding Excel spreadsheets summaries, improving search efficiency
Accounted for data and communicated with supervisors to assure accuracy within database
Discussed with supervisors to optimize digital filing on the department’s shared drive, involving clarifying and probing questions asking
INTERNSHIP EXPERIENCE
Business Analyst Intern March 2015-December 2015
ECalix, Inc., Pleasanton, CA
Analyzed both technical and business requirement specification documents
Wrote simple and complex SQL queries to confirm data quality from back-end
Prepared test strategy, test plan documentation, test cases and test scripts
Worked closely with developers, other business analysts and data modelers to prioritize and resolve defects
Tested the process of ETL to make sure the data is populated according to the specified data transformation rules
Attained strong collaboration skill and ability to work in an onsite/offshore model
Human Resources Administrator May 2013-August 2013
Human Resources Department, Bank of East Asia (China) LTD. Nanjing Branch, Nanjing, China
Updated information in company’s browser-based databases upon supervisor and different team leaders’ requests in a timely manner
Created sign-up sheets, reserved rooms, prepared devices and software setup for training programs to ensure that programs were carried out with no delay
Checked and recorded work attendance for around 90 employees and 20 interns using Microsoft Excel every day
Provided training to successor intern students towards the end of internship
Shipping Coordinator July 2012
Document & Shipping Department, Nanjing Foreign Trade Co. Ltd., Nanjing, China
Used Trading Works, a business document database software to develop documents
Presented documents both in database and in hard copies promptly upon salespersons’ requests
Provided technical support, solving problems related to printer, scanner, software/drivers installation and updating, etc
TRAINING EXPERIENCE
Trainee/Intern Programmer Analyst June 2014-March 2015
Marlabs Inc., Piscataway, NJ
Received training on communication skills and general responsibilities of a business analyst
Attended lessons on using Guidewire, a browser-based core back-end application used by insurance companies, particularly on Policy Center
Learned general knowledge about the insurance and finance domains
CLASS PROJECT EXPERIENCE
Social Tigress Media Group Website Spring 2014
Department of Management Sciences, Tippie College of Business, The University of Iowa, Iowa City, IA
Built the website on WordPress according to the company’s requests
Customized WP plug-ins and wrote functions using PHP to meet company’s special requirements
Redesigned the SQL database to better realize particular data display functions needed
LEADERSHIP EXPERIENCE
Secretary
Greater China Business Association, Tippie College of Business February 2011-May 2013
Recorded meeting minutes and helped organize guest speaker events, doing various follow-up activities
Assisted the President and Vice-Presidents in communicating with the whole association via group emails
Represented China at the International Business Fair held by Tippie College of Business
LANGUAGE PROFICIENCIES
Fluent in Mandarin Chinese & English