Sql Server Data

OBJECTIVE: Data Analyst/ ETL/Report/BI Developer

SUMMARY

Ph D of Biotechnology with 3 years’ experience of SQL Server 2008/2012, Data Loading and Reporting tools

Proficient in data analysis

Strong data management and reporting experience

Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages

Professional experience on load variety of large volume data files into SQL server 2008/2012 database tables and generate Reports with SSRS

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.

TECHNICAL SKILLS

Database: SQL Server 2008/2012, MSBI 2008/2012

Reporting: Access 2007, Crystal Reports 2008, SSRS

Language: SQL, T-SQL

MS Office: Word, Excel, PowerPoint, Access

SELECTED ACHIEVEMENTS ON ANALYTICAL CHEMIST AND BUSINESS INTELLIGENCE

2010-Present North Carolina State University

Successfully load the data from ChIP-Seq and Microarray experiment to SQL Server; analyze and explain the results using SQL Server

Using different biological databases cross-reference other database with Primary Key, Foreign Key and linking their related knowledge together.

Retrieve and modify data using SQL Server and SQL Server Business Intelligence Development Studio (BIDS) and acquire biology information from different database.

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 BIDS

Generated variety of business reports using SSRS including parameter report, dashboard with charts and drill down function

2008-2010 Academic researcher, Kyushu University

2006-2008 Foreign researcher, Japan Society for the Promotion of Science

Successfully load the data from clinical experiment to SQL Server

Retrieve and modify data using SQL Server and BIDS and acquire disease information from different database

EDUCATION

Institution Major Degree / Year

Peking University, China Pharmaceutical Science B.S. / 1994

Yamaguchi University, Japan Chemistry M.S. / 2002

Kyushu University, Japan Biotechnology Science Ph.D / 2006

LANGUAGES: English, Japanese, Chinese

REFERENCES: Available upon request

Contact this candidate