ZHANGWEI MA

**** ****** ****, ********, ** ***** 917-***-**** ac7ot7@r.postjobfree.com

EDUCATION Baruch College New York, NY May 2017

Major: B.A.A in Computer Information Systems

Minor: Mathematics Major GPA:3.86/4.0

RELEVANT Object-Oriented Program II (C++ & Java) Database Management System I Principle of Web Design COURSEWORK Object-Oriented Program II with Java Data Warehousing for Analytics System Analysis and Design Information Technology Project and Management

TECHNICAL Languages English, Chinese (Mandarin), Wenzhounese SKILLS Computer Languages Java, C++, SQL, HTML, CSS, UML Database Software Oracle 12c, Pentaho DI and BA, Hadoop, MS Access, Lucid chart, FileMaker Design & IDE Software Eclipse, MS Visual Studio, Adobe Dreamweaver, Adobe Photoshop, Google Service Other Software DocWare, QuickBooks, eClinicalWorks System PROJECT Database Management System I Course project, Baruch College Tasked to develop a database application to improve a fictional company internal and external accessibility

• Proposed a fictional company, Anthem of the Sea (AoS), and its internal and external database entity relationship with issue based on a cruise company

• Developed an Entity Relationship Diagram (ERD) for the company that showed all elements of entities, attributes and possible identifiers and relationships with labels using Microsoft Access

• Organized and created tables, including constraints, based on the normalized relations

• Designed 5 useful queries and 6 useful reports

Principle of Web Design project, Baruch College

Using Adobe Dreamweaver/ Photoshop to plan, design and build a professional website with HTML and CSS, working with images and hyperlinks, and creating interactivity.

• Developed a professional website for an imaginary coffee shop to raise its guest site visit with Adobe Dreamweaver

• Designed the coffee shop logo and favicon, graphics orientation and coloration with Adobe Photoshop

• Further developed a mobile version that is compatible with Google Chrome and Firefox browsers WORK

EXPERIENCE Quality Color Design, New York, NY

Full-Time Bookkeeper July 2017 – present

• Categorize and maintain accounting records with QuickBooks

• Verify bank statement and credit card statement

• Perform account analysis and reconcile memo reports to protect company’s assets

• Organize company’s jewelry in an exhibition event

• Update item database with Photoshop and FileMaker

• Analyze FileMaker user interface as a tester and make suggestions for ERD improvement TruSmile Dental Office, New York, NY

Part-Time Billing Data Entry Clerk June 2016 – Jul 2017

• Organized patients’ information and patients’ billing database with Microsoft Excel

• Communicated with insurance company regarding patients’ medical treatment with clear request

• Assigned as Patient Services Representative to translate for dentists and patients if need Pediatrics Office, New York, NY

• Part-Time Patient Services Representative Jan 2016 – Dec 2016

• Verified patient’s insurance information and financial eligibility

• Organized and reserved patient’s future appointments in eClinicalWorks System

• Communicated clearly with patients prior to their appointments, about medical records, insurance updates, etc. LEADERSHIP

• Group Director, Chinese Christian Fellowship, Baruch College Jan 2015- June 2016

• Treasurer, Chinese Christian Fellowship, Queensborough Community College June 2013- June 2013

Contact this candidate