Louis lu

Arcadia, CA ***** acslib@r.postjobfree.com

OBJECTIVE: ETL Developer / Database Analyst / Reporting Engineer

SUMMARY

* ***** ********** ** *** server 2008/2012, Oracle 10g/11g, Access 2007/2010 database

and data Loading and Reporting tool such as: SSIS, SSRS and Crystal Repotrs 2008/2011.

Strong data manage and reporting experience on quantitative analysis.

Professional experience of most advanced SQL server 2008/2012 database server

installation, login and user creation, role and permission configuration.

Professional experience on load variety of large volume data files into SQL server 2008/2012

database tables, migrate Oracle tables into SQL server 2008/2012 database tables and

generate Report with SSRS.

Experience on high performance data intergration solutions-Microsoft SQL server

Intergration Service(SSIS), including extraction, transformation, and load (ETL) packages

For data warehousing.

Robust MS Access and Excel skills with pivot tables.

Strong team player with great verbal, written communication and interpersonal skills.

Proven ability to approach problems effectively, prioritize and complete multiple tasks.

Quick learner,take initiator, and hard worker. willing to take responsibilities.

COMPUTER SKILLS

Database: SQL server 2008/2012, Oracle 10g/11g,MSBI 2008/2012, SSIS, Access 2007/2010

Reporting: Access2007/2010, SSRS, Crystal Reports 2008/2011

Language: SQL, T-SQL, VB, Excel Visual Basic

Intennet: HTML, Apache Web Server Log, MS Sharepoint

Ms office: Word, Excel, PowerPoint, Access

Education

B.S computer science, southwestern university 2004-2007

international trade, nankai university . china 1996-1999

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

• Created ETL packages using SQL Server 2008 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio(BIDS).

• Developed projects using SQL Server 2008 SSAS, created data source/data source view/cube with

measure and dimensions, configured attributes of dimension table with hierarchy relationships

modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new

measure groups and dimensions created data-mining solutions in BIDS, deployed them to SSAS

instance, trained the model and queried the model using DMX.

• Generated variety of business reports using SQL Server 2008 SSRS incluing matrix report,

parameter peport, dashboard with charts and drill down function; built reports from Analysis

Services cube using MDX query designer; configured report server and deploy reports on web

server and SharePoint, built Performance Point Dashboard in SharePoint 2010.

SELECTED ACHIEVEMENTS ON SQL SERVER 2008 DATABASE AND ORACLE DATABASE

• Configured SQL Server 2008 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust

the memory usage and file size.

• Create database tables with various constraints including primary key, foreign, etc.

• Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, and

table export/import; loaded data from flat data files and excel sheet into Oracle database using

SQL Loader and SQL Developer.

• Extracted data from SQL Server 2008 database tables and Oracle database tables into flat files

and Excel sheet.

• Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set

operations and T-SQL or PL-SQL functions.

• Generated variety of business reports using SQL queries, sqlplusSSRS and Excel.

• Generated variety of businedd reports using SQL Server 2008 sql query, SSRS,Crystal Report

2008 and Excel 2007 Pivot table.

EXPERIENCE

• ETL developer Data analyst

China Eastern Airline Corp, NY, ShangHai, ShanXi 2009-2015

• Successfully load the data to SQL Server 2008 and analyze and explain the result using SQL Server

2008 and Access as an important tool.

• Using different airline databases cross-reference other database with Primary key, Foreign key

And linking their related knowledge together.

• Retrieve and modify data using SQL Server 2008 and BIDS and acquire disease information from

different database.

• (CEAC as one of the three major airlines in mainland China, it flies a fleet of more than 430 long-

haul and short-haul aircraft, China Eastern serves nearly 80 million travelers annually and ranks among the world's top 5 airlines in terms of passenger transportation volume. As an official

member of SkyTeam.)

LANGUAGE English, chinese

REFERENCES Available upon request

Contact this candidate