Sql Server Project

Wei Gong 518-***-**** (Cell)

**** ***** **., ***********, ******* ***********@*****.***

OBJECTIVE: Data Analyst/Business Analyst

SUMMARY

PhD of Climatological Statistics and Master Degree of Numerical Modeling with Excellent knowledge of applied statistical methods to identify key performance indicators for support of decision making recommendations.

Severn years of professional experience on data extract, transform and load (ETL) on both external and in-house data into SQL Server 2008.

Experience in developing automation systems for data mapping, extracting, loading and querying over huge amount of data.

Knowledge of Microsoft Business Intelligence package including SSIS and SSAS for data analysis and reporting.

Strong programming and debugging skills on large and complicated codes.

Knowledge of SQL Server 2008 instance/database installation, memory usage configuration, and database backup.

Experience of project proposal and progress report to project managers of federal agencies and academic collaborators, with detailed project plans, project status and future goals in a thorough professional development measure.

Proficient in SAP Crystal Report, Microsoft SSRS, Excel and Powerpoint and graphical tools in creating reports with parameters and drill down layout, pivot tables, and various forms of charts for visualization in seminar and workshop and for publication in peer-reviewed scientific journals.

Strong team player, quick learner and hard worker.

COMPUTER SKILLS

MS Office: Excel, Word and PowerPoint

Database: SQL Server 2005/2008, Access 2007 and Oracle 11g

Database Software: Business Intelligence SSIS/SSAS/SSRS, SAP Crystal Report 2011

Language: SQL, Perl, C Shell script, C and FORTRAN, Visual Basic .Net

Operating System: Windows, UNIX, and Linux

Platform: Visual Studio 2010, SUN Workstation, CRAY, and Linux PC cluster

EDUCATION

PhD Climatological Statistics, Beijing University

M.S. Numerical Simulation, Chinese Academy of Meteorological Science

B.S. Atmospheric Physics, Beijing University

PROFESSIONAL EXPERIENCE

Research Scientist April 1997- Present

Atmospheric Sciences Research Center, State University of New York at Albany

Visiting Scientis

Associate Professor February 1992 - March 1997

Chinese Academy of Meteorological Sciences

SELECTED ACHIEVEMENTS on Data Collection and Analysis (2005-2011)

Analyzed huge dataset of observational and modeling data by various statistical methods, such as correlation, standard deviation and regressions for in-depth understanding dominant factors in the microphysical processes of aerosol-cloud interactions and the data assimilation in the hurricane track simulation for the projects funded by various government Agencies, such as Department of Energy (DOE) and National Oceanic and Atmospheric Administration (NOAA).

Generated all sorts of report, with parameters and drill through layout using Microsoft SSRS and SAP Crystal Reports with multi-table joins, group functions, subqueries and set operations.

Created various graphics for presentation in seminar and international meetings using Excel, Powerpoint and other graphical software.

Performed Extract and transform various forms of data from data files (text, spreadsheet, Binary, NetCDF format) into temporary files that will be loaded into database.

Developed Intelligence packages for mapping and loading data from CSV/XLS files into database in project of Department of Energy (DOE) Atmospheric Radiation Measurement.

Created automation tools using T-SQL scripts, including variables, store procedures, dynamical SQL, cursors and Common Table Expression (CTE) for complex data querying with multi-table joins from database.

Installed instances and databases of Microsoft SQL Server 2008 R2.

Configured SQL Server 2008 R2 parameter files to adjust the memory usage and file size for the increasing volumes for aerosol-cloud interaction numerical experiments.

Perform routine tasks of database backup and restore.

SELECTED ACHIEVEMENTS on C/FORTRAN Programming and Reports (1992-2011)

Designed, programmed, debugged, tested, and analyzed modern weather numerical models with progressively programming experiences. These models comprise of hundreds of thousand lines of source code and complicated structure, in both module units and interfaces. Codes are performed on UNIX/LINUX systems, manipulated by Make/GNUMake, and C Shell and Perl scripts.

Prepared and presented progress report, including details of present status and future goals with thorough professional development measures, to project managers and collaborators in federal agencies.

Published over twenty papers in peer-reviewed scientific journals.

LANGUAGES English, Chinese

REFERENCES Available upon request

Contact this candidate