Sql Server Management

Xiaotian Chen

Mobile: 917-***-**** Email: ********@*****.*** Address: 3920 Club Drive Apt 1010 Duluth GA 30096

Goal: Looking for a permanent position in SQL Server database administration and development, SQL Server

Business Intelligence Development

Skills: 3 years of SQL Server database administration and development, 8 years proficiency and demonstrate

expertise in data-driven web application technologies, including:

Database Management: SQL Server 2005/2008, T-SQL, Stored procedure, View, Trigger, SSIS, SSRS

Web Development: NET Framework 2.0, ASP.NET 2.0, C#, VB.NET, Active Server Pages 3.0, HTML, DHTML,

XML, VB Script, JavaScript

Software Development, Tools & Applications: Microsoft Visual Studio 2008, SQL Server Business Intelligence

Development Studio 2008

Server: Microsoft Windows Server 2003, Internet Information Services 6.0/7.0

Employment:

MadisonGrey, LLC, Atlanta, GA 12/09 – 10/10

Database Administrator/Developer - Permanent Position

-Created, designed, and monitored SQL Server 2005/2008 database

- Responsible for SQL Server database performance and tuning analysis

- Designed and executed SSIS packages to facilitate data extraction, transformation, and loading (ETL),

implemented data integration and data transaction between different formats to create data warehouse

- Created, managed, and delivered reports using SQL Server Reporting Services (SSRS)

- Maintained optimal performance levels, identified and resolved bottlenecks, resolved problems relating to

database aspects of end user experience

- Reviewed overall physical database structures for data integrity, performance tuning, recoverability, and

maintenance

- Managed backup and disaster recovery procedures, archived database and migrated SQL Server database to

target physical and logical locations

- Analyzed, designed, and implemented solutions to meet organizational needs; Performed ad-hoc technically

oriented duties as assigned

Titan Management Group, LLC., Atlanta, GA 11/02 – 09/09

Programmer/Database Developer - Permanent Position

- Designed, developed, and maintained SQL server 2000/2005/2008 relational databases. Created, maintained,

analyzed, optimized tables, views, queries, stored procedures, indexes, and triggers

- Analyzed database and design modules for data transaction using Transact-SQL statements, DTS packages,

and SQL Server Integration Services (SSIS)

- Created, managed, and delivered reports using SQL Server Reporting Services (SSRS)

- Created OLAP cubes and built MDX queries to optimize analytical solutions using SQL Server Analysis

Services (SSAS)

- Designed and implemented the database logical models, schemas, and physical structures based on the

development objectives

- Provided performance tuning to ensure integrity, reliability, and maintainability for the production database

- Performed SQL server installation and created scripts for database installation

- Performed production database backups, recovery, and security

- Created SSIS packages and implemented data integration and data transaction between different formats,

such as XML-based files and internet-based sources, to create data warehouse

- Troubleshot production database issues and solved problems in real-time. Applied the best technical solution

to meet the business needs

- Built and maintained Web-Based UST (underground storage tank) Operational Compliance management

programs, which is the best-in-class UST Internet Management Information Systems

- Updated the design and functionality to provide the users a comprehensive management tool and a central

database access. Maintained and troubleshot EDGE internal/external issues

- Designed, developed, configured, coded, tested, and implemented Web applications: EDGE (The Electronic

Data Gathering Exchange), which is the #1 Online UST (Fuel) Management Information Systems and the most

effective way to manage and access UST (Fuel) System, using SQL Server 2000/2005/2008, and ASP.NET

- Managed the development team to integrate the .NET project of teamwork into the existing Web application.

Designed, Developed, and maintained customized data-driven web applications for existing and new clients

using object-oriented platform.

Vatav Inc., Dallas, TX 09/00-01/01

Web developer/Designer – Contract Position

- The project was designed to be a B2B E-commerce web application for the client company: Vatav, Inc. The

B2B platform marketed and processed the transaction the products for the construction industry, such as

construction material, aircraft parts, automobile parts, etc.

- Created the introductory page using Macromedia Flash, designed the Graphical User Interface using

Macromedia Flash and Adobe Photoshop, developed homepage using HTML and FrontPage

- Deployed, tested, and published the pages and the web application. Implemented and deployed Java Sever

Pages to display information on Web pages

Innerlink Strategic Solutions, Inc., Pittsburgh, PA 05/99-01/00

Web Developer/Application Designer – Internship

- The website was designed to give the company, a consulting firm in communication, a virtual presence. It is

involved with a typical set of tasks to achieve dynamic functionality. Designed several parts of the application

from scratch based on the general application design rules.

- Designed and developed web pages using HTML, JavaScript, and Java Applets. Designed the site

architecture and Graphical User Interfaces

Education:

Saint Peter’s College, Jersey City, NJ 09/01-11/02

Master of Business Administration

Duquesne University, Pittsburgh, PA 09/98-08/00

Master of Science in Information Systems Management

Duquesne University, Pittsburgh, PA 09/94-05/98

Bachelor of Science in Business Administration Major in Finance

Honors: Honor graduate student: Cum Laude, May 1998

National Dean’s List, 1996-1998

Other: U.S. Permanent Resident

Contact this candidate