Customer Service Project

Pingting Mo

**** * ******** *****, *** *** Chicago, IL 60605 312-***-**** **********@*****.*** OBJECTIVE: To obtain an internship or entry-level position where I can contribute my IT and financial experience and education, as well as my collaboration and communication skills. EDUCATION

DePaul University, Chicago, IL Nov 2015

Master of Science in Information System

GPA:3.6/4.0

Missouri State University, Springfield, MO 2012

Bachelor of Science, Finance

GPA:3.0/4.0

TECHNICAL SUMMARY

Languages: SQL, PL/SQL, MySQL, Python, R, SAS, PHP, HTML, C# Software: SQL Developer, SqlPlus, MS Office, MS Visio, ASP.NET, Visual Studio Operating Systems: Windows XP/8, 10, Mac OS, Unix

Database: Oracle, MS Access, SQL

Certification: SAS Certified Base Programmer for SAS 9 COURSE PROJECT

PL/SQL Video Rental Store Database Application

Built PL/SQL based application to insert, update records in a video store database and generated some reports

Created customer and date tables, inserted the new customer info and updated the expiration date into the tables

Created the procedures to check different checkout and return status of customer and video then inserted and updated the new record into the database

Group all the subprograms together in a package including the package specification and package body Database Processing for Large-Scale Analytics (Movie Database)

Used Python and SQLite 3 exclusively to create 3NF database tables

Inserted the data into the tables from a CSV file and processed the data into another format

Created two queries to select, sort and filter data to analyze the data from the tables VAR Simulation Project

Applied Monte Carlo Algorithm to simulation future 7 days VAR positions of a stock portfolio at 95% with Python

Used moving average method to generate future VAR and compared the results to Monte Carlo method and analyze the data and report the result

Family Furniture Company Website

Created a business website for a fictional company called Family Furniture Company with C# and CSS

Used C# to connect database to ASP.NET and created login, register and shopping cart pages EXPERIENCE

NuZoo Media, Chicago, IL 2015

Web Development Intern

Worked in an award-winning video production, web design and graphic design company

Tested the webpage links for designers’ projects and updated new content displays on web pages

Worked collaboratively with in-house development team to build and maintain project database using MySQL and PHP

Conducted a market research by monitoring website visits, duration and bounce rate

Summarized the key findings and presented to leadership teams to improve customer satisfaction Missouri State University, Springfield, MO 2012

Project Assistant

Documented and organized project information including agendas, reports and presentations for stakeholders

Reviewed income statements and balance sheets to derive reasonable model assumptions

Performed sensitivity analysis on cash flows to validate model assumptions using Excel

Assisted to develop pro-forma financial statements and balance sheets to estimate future 10-year cash flows based on performance of previous years

Jinzhou Bank, Shenyang, China 2011

Financial Analyst Intern

Trained with highly customer service skills and provided assistance on product selection for new customers based on their credit history, risk appetite and investment need

Migrated customers account information into ERP system and performed data validation

Assisted senior marketing analysts to target potential commercial loan customers and performed credit valuation using discounted cash flow model and liquidity analysis

Contact this candidate