Sql Server Data

DONG XIAO

PITTSBURGH, PA ***** 412-***-**** ******@*****.***

OBJECTIVE

To obtain a job as Database Analyst.

SUMMARY OF QUALIFICATION

Ph.D. of Biomedicine with 4 years’ experience of SQL Server, Oracle, Access database

and data Loading and Reporting tools such as SSIS, SSRS and SAP Crystal Reports.

Strong data managing and reporting experience on quantitative analysis.

Professional experience of advanced SQL Server 2008/2012 Database Server installation,

login and user creation, role and permission configuration.

Professional experience on loading variety of large volume data files into SQL Server

2008/2012 database tables, migrating Oracle tables into SQL Server 2008/2012 database

tables and generating report with SAP CR or SSRS.

Experience on high performance data integration solutions: Microsoft SQL Server

Integration 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.

AREAS OF TECHNICAL EXPERTISE

Database: SQL Server 2008/2012, MSBI 2008/2012, SSIS, Access 2010/2013 and Oracle

10g/11g.

Reporting: Access, SAP Crystal Reports and SSRS.

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

MS Office: Word, Excel, PowerPoint and Access.

EDUCATION

Soochow University June 1997

Ph.D., of Radiology

SELECTED ACHIEVEMENTS ON SQL SERVER AND ORACLE DATABASE

Configured SQL Server 2008/2012 and Oracle 10g/11g database parameter files to

adjust the memory usage and file size.

Created database tables with various constraints including primary key, foreign key,

etc.

Loaded data from flat data files into SQL Server 2008/2012 database tables using

bcp, bulp insert, and table export/import.

Extracted data from SQL Server 2008/2012 database tables and Oracle database

tables into flat data files ad Excel sheet.

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

subqueries, set operations and T-SQL functions.

Generated variety of business reports using SQL Server 2008/2012 sql query, SAP

Crystal Reports, SSRS and Excel pivot table.

SELECTED ACHIEVEMENTS ON BUSINESS INTELLIGENCE

Created ETL packages using SSIS to extract data from flat files, 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 or SSDT. Generated variety of business reports using

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

function.

EXPERIENCE

2009 – Present

Research Assistant Professor (Data Analyst)

Department of Pharmacology & Chemical Biology and Urology, University of Pittsburgh

Successfully loaded the data from ChiP-Seq, microarray experiment and Clinical

trials into SQL Server 2008/2012; analyzed the data using SQL Server and Access;

and generated the reports using SSRS and SAP Crystal Reports.

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 2008/2012, BIDS and SSDT; acquire the

information on the effect of dietary natural products on cancers from different

databases.

Provided guidance related to laboratory work and offered counseling to several

postdoctoral fellows.

Awarded “RO1 and R21 Project Funding by NIH/NCI”

2006 – 2008

Research Instructor

2001 – 2005

Research Associate

Department of Pharmacology & Chemical Biology, University of Pittsburgh

Awarded “CEO Pilot project Funding by University of Pittsburgh Cancer Institute”

Study on chemoprevention and the inhibition of cancer cell growth through the

modulation of genes.

Analyzed and presented research data using MS Excel, PowerPoint and Word.

Mentored research fellows, research specialists, students of College and graduate

students.

Associate Professor 1998-2000

Antitumor Lab of Pharmacology, Shanghai Institute of Materia Medica,

Chinese Academy of Sciences, China

Investment of the relationship between the angiogenesis and tumor growth

Used MS Excel, PowerPoint and Word to record, analyses and report the research

results.

Supervised the students and research stuffs in the research group.

LANGUAGES: English, Chinese

REFERENCES Available upon request

Contact this candidate