Microsoft Office Data

Jiang Bian

**** ******** ***, *** **, Philadelphia, PA 19104

Phone: 215-***-**** Email: *********@*****.***

Education

Drexel University, Philadelphia, PA

Master of Science in Information System Graduated in June 2015

Cumulative GPA: 3.77

Drexel University Philadelphia, PA Bachelor of Science in Business Administration (Magna Cum Laude) Graduated in September 2013

Concentration in Accounting Cumulative GPA 3.86

Tianjin University of Finance and Economics Tianjin, China

Completed coursework in Finance September 2008 to December 2010

Cumulative GPA: 3.05

Honors and Awards

Dean's List, Drexel University, Fall 2011-September 2013

Dean's Scholarship, Drexel University, Fall 2011- Present

Work Experience

RIM, DBHIDS, City of Philadelphia Philadelphia, U.S

Programmer Analyst Intern September 2014-March 2015

Conducted source-target mapping of RIM’s SQL and WebFOCUS databases and DSS CARES' database; drafted related data dictionary.

Designed and built ETL process for XeoHealth source data by using SSIS package which includes unzipping and file tasks, data validation and linkage (using cursors). It has made the consolidation between XeoHealth’s claim data and the department’s clinical data possible.

Wrote proposal for the redesign of SummerCamp application and suggested on new system specifications and improved workflow based on existing functions and issues identified.

Designed and implemented the automation of HCSIS data extract using SSIS, which saves the department about 20 man-hours per week.

Pennrose Management Company Philadelphia, U.S

Staff Accountant Intern September 2012-March 2013

Booked journal entries in Yardi, reconciled bank accounts and cash balances

Prepared monthly, quarterly and year-end workpapers for assigned properties

Finished year-end audit workpapers for assigned properties

Project Experience

INFO 605 Database Design And Implementation for ERetail.com January-March 2014

Designed the ERD, relation schema and data dictionary for a virtual e-commerce website

Built and ran the database on Oracle Database Server using DDL and DML

Created and executed basic SQLs to obtain valuable insights to the business

INFO 620 Analysis and Design of DBay, An Online Book Exchange System January-March 2014

Collected system requirements and defined project scope with the team

Developed the Use Case Diagram, Class Diagram and Design Class Diagram in Rational Rose

Designed Sequence Diagram for the “buy items” use case in Visio

Skills

Programing Languages- VB (VBA); C++ (basic); Java (Intermediate); SQL

Computer Skills- Microsoft Office (Word, Excel, PPT, Access, Visio, Project); R; Yardi; SAP (basic); SPSS

Language Skills- Native in Chinese (Mandarin)

Contact this candidate