SUMMARY

• PhD of Biology wif 6 years experience of SQL Server 2008/2012, Access database/Excel interactive and Data Loading and Reporting tools such as: SSMS, SSIS, SSAS, SSRS, Crystal Reports 2008/2013 and Tableau 8.1/8.3.
• Professional DBA and Production experiences: Install, Data Security, Backup & Recovery, Performing Tuning and SQL Tuning, mirror server and Always on, migration and update.
• Professional SQL/T - SQL skills including but not limited to multitable joins, group functions, dynamic SQL, Store procesure and function, nested sub-queries, cursors, triggers, error handling, pivot and user defined functions.
• 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 wif SSRS.
• Intensive experience of generating variety of business reports using SQL Sever 2008/2012 SSRS, Tableau and Crystal Reports: such as tabular, matrix, parameterized, cascading parameterized, sub report, chart, graph, dashboard, drill-down, drill-through, map report and generating reports from cube using MDX query designer.
• Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Hands-on experience wif SSAS including but not limited to data warehouse designation, cube/mart construction and hierarchy configuration, data query wif MDX, data modeling and DMX query.
• Advanced knowledge and experience wif conceptual, logical and physical data model, professional experience on primary key, foreign key and schema, table design.
• Robust MS Access and Excel skills: macro,VBA, Powerpivot, Powerview, Data Connection.
• Basic statistical knowledge and experience wif SAS programing.
• Strong team player wif 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, Oracle 10g/11g, MSBI 2008/2012, SSIS, Access 2007/2010Reporting: Access 2007/2010, SSRS, Tableau 8.1/8.3 and Crystal Reports 2008/2013Statistics: SAS programming, Graphpad prism 5, IBM SPSS 20Language: SQL, T-SQL, PL-SQL, basic #CVB, .Net, Excel Visual BasicMS Office: Word, Excel, PowerPoint, AccessPROFESSIONAL EXPERIENCE

SELECTED S ON BUSINESS INTELLIGENCE,

Confidential,

Responsibilities:

• Database migration, backup/restore, replication, linked server and performing tune,
• Always on and mirror and transancation backup,
• Created database tables wif various constraints including primary key, foreign key, 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 data files and Excel sheet.
• Power user of advanced SQL queries wif multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
• Configured SQL Server 2008 and Oracle 12c on Linux system and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.
• Generated variety of business reports using SQL queries, sqlplus, SSRS and Excel.
• Access Database management and development using designer and generate report and create form wif Access2013.
• Created ETL packages using SQL Server 2008/2012 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/SSDT).
• Developed projects using SQL Server 2008/2012 SSAS, created data source/data source view/cube wif measure and dimensions, configured attributes of dimension table wif 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/SSDT, deployed them to SSAS instance, trained the model and queried the model using DMX.
• Generated variety of business reports using SQL Server SSRS including matrix report, parameter report, dashboard wif charts and drill down function; built reports from Analysis
• Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010.
• Generated many professional dashboard reports, skilled in connecting to Excel, CSV, flat files and visualization data in minutes using Tableau Desktop 8.1/8.3. Familiar wif reshaping data in Excel, swap, Sorting, Grouping, Hierarches and Trend lines analysis.
• Generated variety of business reports using SQL Server 2008 sql query, SSRS, Crystal Report 2013, Tableau 8.2/8.3 and Excel 2007 Pivot table.
• Excel Function, macro,VBA, Powerpivot, Powerview, Data Connection

Confidential, Cedar Fall, IA,

• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• SQL Tuning in an Sql Server Environment
• Replicaction and linked server
• Migration from legcy system.
• High availability plan (log shipping, mirroring, replication,FCI and Always On)
• ON Call Support.

Confidential, Omaha, NE,

• Heavily used T-SQL: store procedure, function, view, trigger, cursor, DDL, DML
• Generate SSRS reports, Crystal reports and Tableau visualization reports
• OLTP data mining, cleansing, extraction, transformation and load (ETL)
• Data ware house design, cube and data mart construction and maintain
• Access, Excel interaction, macro,VBA, Powerpivot, Powerview, Data Connection.
• SSIS, SSAS and SSRS experience and highlighted as above.

Confidential, Omaha, NE,

Responsibilities:

• Successfully load the data from ChIP-Seq and Microarray experiment to SQL Server2008/2012 and analyze and explain the result using SQL Server 2008\2012 and Access as an important tool.
• Generate reports wif SSRS, Crystal Report or T-SQL
• Write store procedure, function, create view and DML, DDL.
• Using different biological databases cross- other database wif Primary Key, Foreign Key and linking their related knowledge together.
• Query data from data warehouse, data mining and prediction analysis.
• Retrieve and modify data using SQL Server2008 and BIDS and acquire disease information from different database.
• Bioinformatics works: Genechip data and UCSC, IMGT, cDNA library and other databases analysis to select target gene and predict new lincRNA.
• Studied the roles of IRF4 and IFR8 in pathogenesis of Chronic Lymphocytic Leukemia (CLL).
• Collect clinical CLL data library, data mining, cleansing and deploy to SQL Server
• Laboratory management and new method development.