data warehouse

Jiaqi (Jack) Zhang, SAP/Oracle Certified Associate

**** ******* **, *****, ***** 484-***-**** **************@*****.***

Education

Master of Science in Information Technology and Management

The University of Texas at Dallas, TX Expected 05/15

Bachelor of Science in Engineering Management

Northeast University of Finance & Economics, Dalian, China 07/07

Professional Experience

System Analyst

Intelligent Parking Management System (UTD Project), Richardson, TX

01/15-04/15

. Designed a parking management system that can help people in campus find

empty park space quickly and help service office record improper parking

behavior automatically.

. Collaborated with team members to translate user requirements to

functional and design specifications.

. Created the interface, use case diagram, class diagram, sequence diagram

to present our analysis and design.

. Learned from this project about all phases of SDLC, planning, analysis,

design and implementation

. Environment: Visual Paradigm for UML (VP-UML)

Data Analyst

The University of Texas at Dallas (JSOM Advising Office), Richardson, TX

01/14-07/14

. Designed and developed applicant review report for student advisor by

applying MS access query, forms

. Pulled reports from the systems to identify discrepancies in

information, and compared data in various database systems

. Created object oriented design patterns, emphasized data structures

using MS Access to generate various reports

. Analyzed large data by applying Excel Pareto charts, pivot tables, V-

lookup and what-if analysis

Environment: MS Access, MS Excel 2007

Database Architect

Online IT Retail database System Design (UTD Project), Richardson, TX

01/14-05/14

. Documented business requirement, detailed desired business process and

developed ERD for database system functionality

. Prepared design documents detailing the desired implementation of

database systems and processes

. Presented new designs to IT staff to ensure the designs are implemented

properly

. Assisted effectively in the preparation of test plans for database

systems

Environment: MS SQL Server2008, MS Visio

Academic Experience

. Extensively worked with SAP BW Basic Infocubes, Real time Infocubes,

DSOs, ETL

. Experience with SAP Business Objects, Xcelsius, Crystal reports, and SAP

BEx Analyzer, BEx Query Designer, Web Application Designer and other

reporting tools

. Strong and hands on SAP functional knowledge in several SAP R/3 areas

such as HCM, Materials Management, Sales & Distribution,

Certification

SAP Certified -Associate Business Foundation & Integration with SAP ERP 6.0

EHP5

Oracle Certified- Oracle Database 11g Administrator Certified Associate

Contact this candidate