Haiyan Pei

Ann Arbor, MI ***** ● acemu1@r.postjobfree.com ● 217-***-****

OBJECTIVE

Database Analyst/Business Analyst/Reporting Engineer

SUMMARY OF QUALIFICATION

Master of Library and Information Science with 6 years experience of most

advanced Oracle, Microsoft SQL Server, Access database.

Professional experience of most advanced SQL Server 2005/2008 and

Oracle10g/11g Database Server installation, User account setup, Schema

logical design, load variety of data into Oracle/SQL Server database tables.

Generated reports with SQL queries, Excel 2010 Pivot Table, Crystal Reports

2008 and SSRS from different Databases.

Experience on high performance data integration solutions MS SQL Server

Integration Service (SSIS), including extraction, transformation and load (ETL)

packages for data warehousing.

Excellent team work spirit and communication skills, ability to prioritize and

complete multiple tasks and detail oriented.

Proven capability to approach problems effectively, prioritize and complete

multiple tasks.

Fast learner, take initiator and hard worker.

TECHNICAL SKILLS

Database: Oracle 10g, 11g, MS SQL Server 2005/2008/2012, MySQL, MS Access.

Reporting: Crystal Report 2008, Access 2007, SSRS.

Languages: VB Script, SQL, PL/SQL, T-SQL.

Operating Systems: Windows 2008/2012, MS DOS, UNIX.

Internet: HTML, Apache Web Server, CSS, MS Share Point.

Information System Formats: Voyager, Metadata, AACR2, OCLC Connexion.

EDUCATION

Master of Library and Information Science, 2007

Univ. of Illinois at Urbana-Champaign, IL

Programming- Database Management CS&IT, 2010

Parkland College, Champaign, IL

Certificate in Business Administration 2011

Univ. of Illinois College of Business

Oracle Database 10g Administrator Certified Associate (OCA) 2010

Bachelor of Education 2001

Jiangxi Normal Univ., Nanchang, China,

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

Created ETL packages using SQL Server 2008 SSIS to extract data from flat file,

Haiyan Pei Page 1

reformat the data, and insert the reformatted data into SQL Server Database, loaded

different types of dimension and fact tables into data warehouse, and deployed SSIS

packages and solutions into test and production system by using SQL Server Business

Intelligence Development Studio (BIDS).

Developed projects by using SQL Server 2008 SSAS, created data source/data

source view/cube with measures and dimensions, configured attributes of

dimension table with hierarchy relationships, modified cube and dimensions,

deployed KPIs on SSRS and Excel and created different metrics, and added new

measure groups and dimensions.

Generated variety of business reports by using SQL Server 2008/2012 SSRS

(including matrix report, parameter report, dashboard with charts and drill down

function), built reports from Analysis Services cube by using MDX query

designer, configured report server and deployed reports on web server and

SharePoint, and built Performance Points Dashboards in SharePoint 2010.

SELECTED ACHIEVEMENTS ON DATABASE

Configured Oracle and SQL Server parameter files to adjust the memory usage

Created database tables with various constraints including primary key, etc.

Loaded data from flat data files into SQL server database tables using bcp, bulk

insert, and table import/export, loaded data from flat data files and excel sheet

into Oracle database using SQL*Loader and SQL Developer and into SQL Server

database using Sql Server Management Studio(SSMS).

Extracted data from SQL Server 2008 database and Oracle database tables into

flat data files and Excel sheet.

Proficient at advanced SQL queries with multi-table joins, group functions,

subqueries, T-SQL and PL/SQL.

Generated variety of business reports using SQL queries, sqlplus, Excel, SSRS,

Crystal Report 2008 and Excel 2007 Pivot table.

Successfully download and install SQL Server, Oracle and Linux on Virtual

Machine.

EXPERIENCE

Illinois Business Consulting (Business Analyst) 2010-- 2011

University of Illinois at Urbana-Champaign Champaign, IL

2007 2009

Digital/Metadata (Research Assistant)

Illinois State Library, Springfield, IL

Reference/Catalogue/Technical Service (Research Assistant) 2006 -- 2008

Libraries, Univ. of Illinois at Urbana-Champaign (UIUC)

Haiyan Pei Page 2

Contact this candidate