Sql Server Data

Joy Qiu CV

Joy Qiu

Rockville, MD *****

**********@*****.***

SUMMARY of QUALIFICATIONS

Over five years’ experience of relational database management using SQL Server 2008, 2012,

Access 2007.

Proficient in data management, business intelligence and reporting tool using SQL Server

Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Crystal Report,

Excel Pivot Table and Formulas.

Experience in implementing analytical solutions for multiple fields including: insurance business,

medical and healthcare database, government data management.

Experience in reading and understanding execution plan and fixing query to execute with low

cost using various operators depending on the scenario.

Experience in performing administrative tasks, Database files management, Backup/Restore,

Security management, and Data integration.

Experience in ETL Processes. Worked extensively on data extraction, cleansing, integration, and

loading from multiple data sources.

Experience in data modeling and creating Star and Snow-Flake schemas, fact and dimensions

tables, physical and logical data modeling.

Experience in most advanced SQL Server installation, role and permission configuration and

management.

Advanced skills on MS Access and Excel with Pivot tables.

Demonstrated problem solving and multitasking skills.

COMPUTER SKILLS

Database: SQL Server 2008, 2012, PostgreSQL, Oracle, Access 2007.

Reporting: SSRS, Crystal Report 2008, Access 2007.

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

Operation systems: Windows, Unix, Linux, MS-DOS.

EDUCATION

Master Degree of Computer Science, Kochi University, Kochi, Japan

Bachelor Degree of Computer Science, Tianjin University, Tianjin, China

EXPERIENCE

Database Analyst Arkansas Department of Workforce Services 06/2010-05/2014

Made significant contributions to various projects related to data modeling, data mart design

and development.

1

Joy Qiu CV

Built a cube for investment project. Investigated state-wide labor market and unemployment

statistical information. Provided predict reports using SQL Server Analysis Services data mining

tools and algorithms.

Extracted, transformed and loaded data from a variety of data sources into data warehouse and

financial data mart using SQL scripts, stored procedures, T-SQL and Microsoft SSIS ETL packages.

Improved reporting system performance by creating cube and multi-dimensions using SSAS.

Designed, Developed, Configured and Deployed custom build business reports using MS

Reporting Services including dashboard, cascading, matrix reports with graphic, drill down and

drill through function.

Planned, scheduled, controlled and maintained SSIS packages including SSAS Cube process

package and SSRS reports base on plans and requirements outlined by the business.

Installed, Configured and Maintained SQLServer 2012/2008R2, Implemented SQL Logins, Roles

and Authentication Modes as a part of Security Policies for various categories of users.

DBA and Reporting Engineer Crossroads Dental Group, Seattle WA 11/2006- 03/2010

Reviewed and cleansed clinical data, loaded financial information into reporting system.

Generated a variety of business reports using Excel Pivot table, Access reporting tool, and

Crystal Reports.

Performed data analysis upon specific business requirement.

Installed, configured and maintained database system and dental application software.

Lab Data Analyst University of Washington, Seattle WA 4/2003 -10/2006

Queried research data from a drug-drug interaction database. Managed research lab

information using Access database.

Research Scholar Medical Information Center of Kochi University, Kochi, Japan 3/1999 -3/2003

Queried medical information from Oracle database in Medical school and multiple clinical

databases for research projects.

Transformed data from different data source include PostgreSQL database, flat file into Oracle

databases.

Participated in developing reports using Java script, PL/pgSQL on PostgreSQL database for

medical research.

Software developer/DBA Property Insurance Company of China, Qingdao, China 8/1984-3/1999

Participated in data warehouse designing, data modeling, schema and table creating. Installed

and configured database software for Oracle Application development environment.

Responsible for the Installation, Daily monitoring, Maintenance of database.

Developed and maintained financial application programs using C, PL/SQL and UNIX Shell Scripts.

2

Joy Qiu CV

3

Contact this candidate