San Francisco, CA *****

(***) *** – **** aceddc@r.postjobfree.com

Zan Guang Ni www.linkedin.com/in/zanguangni

www.zanguangni.com

EDUCATION Institution: San Francisco State University (SFSU)

Degree: Bachelor of Science

Major: Information Systems

Overall GPA: 3.65; graduating Cum Laude

Honors & Activities:

• CIO Scholarship Award, Spring 2013

• SAP Student Award Certificate, Spring 2014

• Member of BETA GAMMA SIGMA (BGS) International Business Honor Society

• Dean’s List: Fall 2010, Spring 2011, Spring/ Fall 2012, Spring/ Fall 2013

• Director of PD of Information Management Systems Association (iMSA) at SFSU

SKILLS & EXPERTIES Software: SAP Solution Crystal Dashboard Crystal Report

MS SQL Server MS Excel MS Power Point

MS Access MS Project MS Word

Programming: SQL Statement JavaScript HTML

CSS

Other Skills: Joomla Prestashop MySQL

Languages: English Chinese Mandarin

WORK EXPERIENCE Feb. 14 – Apr. 14 Database Management Intern WealthVest Marking

IT Department San Francisco, CA Reference: Dan Goldman (415) 505 - 1919

• Created the Product Master tables in the database.

• Analyzed the existing product data from the carriers and iPipeline and in complete detail

determine where those data are mismatched.

• Analyzed ongoing data to determine where it is incomplete.

• Troubleshooting data errors where they are found.

• Obtained and populated missing carrier product data.

• Analyzed existing reports and ongoing user requirements that pertain to Product Master

tables and modified them to use the new product data structure.

• Created SQL scripts to support ongoing processing of product data.

• Created documentation to enable ongoing operational support of all delivered projects.

PROJECT May. 14 Personal Portfolio Website Design and Development

San Francisco State University San Francisco, CA

Designed and developed the site from the scratch using HTML and CSS.

•

Make the website front end more responsive and interactive with use of JavaScript.

•

Connecting site to MySQL database on the back end.

•

www.zanguangni.com

•

Nov. 13 Database Development and Support via Oracle DBMS

ISYS 464 San Francisco State University San Francisco, CA

Built a database from the scratch for an imaginary online game shop.

•

Layout relationships between multiple entities in an E-R diagram.

•

Defined primary and foreign keys of each entity in relational tables.

•

Developed relational database by creating table, and retrieving data using Oracle DBMS.

•

Got an A on this project.

•

Contact this candidate