Post Job Free

Resume

Sign in

Sql Server Data

Location:
Pittsburgh, PA
Salary:
40000/annual
Posted:
September 08, 2015

Contact this candidate

Resume:

Meng Hu

*** **** **, **********, ** *****

acrlli@r.postjobfree.com

acrlli@r.postjobfree.com

205-***-****

QUALIFICATIONS:

Able to change priorities as needed, excellent organizational skills, time management skills; and the ability to identify and implement process improvements

Interested in obtaining a position will allow me to enhance the knowledge I have acquired from my previous work experience. I also seek to continue to develop skills that contribute to the growth and the success of Company.

EDUCATION:

University of Alabama at Birmingham - Masters of Computer Science GPA: 3.00 Sep 2012 -Apr. 2014

Shandong University - Bachelors of Science in Electrical Engineering Aug.2005-June 2009

EXPERIENCE:

UPMC - Pittsburgh, PA 15219 Mar 2015- Present

BI developer

Create databases and schema objects including tables, indexes, applied constraints and connected various applications to the database. Written functions, stored procedures and triggers.

Using CTE, table type to refactor the stored procedure to improve the execution time.

Used SSIS to create ETL package to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Extensively used SSIS transformations to transfer the data from the source file to the database. Such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Create SQL Server Agent jobs to handle the database backup and restore.

Create Database user and assign the authorization to the database user.

Create stored procedure to get the xml data from xml file.

Upgrade SQL Server 2008R2 to SQL Server 2012.

Cloudeeva - East Windsor, NJ 08520 October 2014- Feb 2015

BI developer

Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Used SSIS to create ETL package to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Used ETL tools to implement the Slowly Changing Dimensional maintain Historical Data in Data warehouse.

Designed Cubes with Star/Snowflake Schema using SQL Server Analysis Services 2012 (SSAS).

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, char and matrix report).

Histogenetics – Ossining, NY 10562 August 2014-October 2014

IT in the IT section of Histogentics

Creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation.

Used 5-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.

Using Perl language to write the file in xml format.

University of Alabama at Birmingham – Birmingham, AL Sept 2010- August 2014

Technician in the lab of Department of Medicine

Ordered the supplies and reagents necessary in order to be ready for the experiment

Performed project evaluation in order to make recommendations for corrective action if required

Communication between PI and technician to ensure projects are complete on time and all experiments needs are meet and everyone is informed of any change that may occur

University of Alabama at Birmingham CSSA Sept 2012 – August 2013 Website Developer

Developing UAB CSSA website, build the flea market in order to student can publish some news on it.

University of Alabama at Birmingham August 2012 - April 2014

Computer Science Student

Prevention of cloud computing attacks

Reversi game project (Java).

Detecting A “new spam campaign” (Java)

Analogy page fault in the operating system (java)

Search maze (java)

Operator arrangement (Ruby)

Aisino Company – Beijing, China June 2009 - August 2010

QA

Encrypted Mobile USB Flash Disk

Tax Declaration Software

General Invoice Control and Management System

ShanDong University– WeiHai, ShanDong Sept 2005 – June 2009

Student

Students’ Grade Management System

NS-2 Mobile Communication

Radio Assembly

Auto-Test System & Interface Technique

SKILLS:

Excellent human relation skills with high teamwork and leadership capacity

Professional Programs (Java, SQL Database, C#, Ruby, Matlab, Dreamweaver, PHP, C, C++, NS2, Loadrunner, HE stain, Westernblot, Microsoft Office Word, Excel, PowerPoint).

Course Related:

Basis of Analogue Electronic Technique, Advanced Mathematics, MATLAB Language, C++ Language, Computer Interface technology, Electronic Circuits of Communication, Distribute computing, Bioinformatic, Algorithm(JAVA), Security & Privacy Cloud Computing, Mobile malware, Database Management System Curriculum Design, Signals & Systems, Basis of Analogue Electronic Technique, Electronic Circuits of Communication, Discrete Structures, Fundamentals of Mono-Chip Computers & Applications, Database management, Programming language,Parallel computing,Software Engineerin, Database Systems I

Published and Award:

A Comparative Study on I/O Performance between Compute and Storage Optimized Instances of Amazon EC2. Abu Awal Md Shoeb, Ragib Hasan, and Meng Hu SECRETLab, Department of Computer and Information Sciences UAB



Contact this candidate