Sql Server Developer

MARK LIU

**** ***** ***** *****, ******, TX ***59 512-***-**** (Cell) ( E-mail:

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

OBJECTIVE

Report Developer, Data & Database Analyst

PROFILE SUMMARY

Report developer, Data and Database analyst with full life-cycle

development and deployment experiences. Different industry work experiences

including Finance, Telecommunications, Petroleum, Software, hardware, Law

firm, and Government agencies. Special expertise includes:

Reporting: Crystal Reports 7 to 11, Business Object XI Suite, SQL

Server Reporting Services

Languages: SQL, PL/SQL, T-SQL, Perl, C, HTML, Visual Basic

Database: MS SQL Server, Oracle, DB2, Sybase, PeopleSoft, My SQL,

MS Access, Informix

Network: TCP/IP suite, Client/Server programming

OS Systems: Windows, UNIX, LINUX, Sun Solaris

Other Tools: Universe Designer, Dashboard Manager, Crystal Enterprise,

Crystal Clear, ePortfolio, SQL*Plus, SQL Loader, Toad, SQL Server

Management Studio 2005, SQL Query Analyzer, Enterprise Manager, Command

Editor, DBArtisan, Rapid SQL, MS Office suite, MS Visio, Embarcadero ER

Studio, MS Visual Source Safe, Dynabase, Erwin, Informatica, Microsoft

SharePoint, Rational ClearQuest

PROFESSIONAL EXPERINCE

BJ SERVICES, Tomball, Texas 03/09 - 02/10

Consultant (contract)

SQL Server Report development, database, data analysis for Call Center and

Change Management by using SQL Server Management Studio, SQL Server

Reporting Services. The reports include matrix, tables, lists, and graphs

with dynamic narrow down parameters driven. Only person worked for the full

life cycle report development and deployment.

P.G.H. L.L.C., Austin, Texas 06/08 - 08/09

Consultant (part time)

SQL Server Report development, database analysis using SQL Server

Management Studio, SQL Server Reporting Services, and Access. Get

requirements from the clients, created specifications and reports.

DELL INC. Round Rock, Texas 05/08 - 02/09

Database and Data Analyst (contract)

SQL Server, Access database and data analysis using SQL Server Management

Studio and Access. Daily trouble shooting for clients using DTS packages,

stored procedures, Report generating using SQL Server Reporting Services,

QUEST, and Excel. Extensive query writing on both SQL Server and Access.

TEXAS DEPARTMENT OF PUBLIC SAFTY, Austin, Texas 01/07 - 05/08

Report Developer and Database Analyst (contract)

Crystal Report development, database analysis using Crystal 11, Business

Object XI suite, IBM DB2, and SQL Server. Communicated with clients to get

requirements, created specifications, stored procedures, functions, wrote

extensive SQL codes for data and database analysis. Also worked as Business

Objects administrator (10%). Only person worked for the full life cycle

report development and deployment.

AIM FIANACIAL INVESTMENTS, Houston, Texas 08/03 - 12/06

Report Developer & Data Analyst

Major developer responsible for report development, database and data

analysis using Crystal, Crystal Enterprise, Crystal Clear, Business Object

XI, SQL Server Reporting Services, Oracle SQL *Plus, Toad, SQL Query

Analyzer, SQL Server Enterprise Manager. The databases include Oracle

(Remedy), SQL Server (Remedy), PeopleSoft, Access, Informix (Avaya) and

Sybase. As a major developer, created more than 300 reports and report

specifications for clients. Wrote extensive SQL codes, created views,

functions. Created data warehouse using ETL tool (Informatica).Create

Universes using Universe designer. Worked with different departments

including Help Desk, Data Center, Finance and HR.

Texas Commission on Environment Quality, Austin, Texas

06/03 - 08/03

Crystal Report Developer

Crystal Report development using Seagate Info, Oracle, Cool Gen and MS

Access. Created 60 reports including lists, labels and mail merges.

ENCORE TELECOMMUNICATIONS INC. Austin, Texas 02/02 - 05/03

Data Analyst & Report Developer

Data analysis for marketing, sales, and billing dispute using Oracle, Sun

Solaris, Crystal Report. Created scripts, triggers, functions, views and

tables. Performed extensive SQL query for the analysis.

@OUTCOME INC. Austin, Texas 01/00 - 01/02

Database Engineer & Report Developer

Database development, data analysis and reporting using My SQL, Sybase,

Crystal Reports. Created the databases, ER diagrams and stored procedures.

Performed data modeling and analysis. Perl/CGI programming. Designed and

developed an inventory database and administration system for Texas

Computer including database design, data modeling, interface creation and

testing.

EDUCATION

( M.S. in Computer Science - The University of Texas at Arlington,

Arlington, Texas

( B.S. in Chemistry - Jilin Normal University, Jilin, China

Contact this candidate