Sql Server Engineer

Judi (Xingzhu) Hua

C: 214-***-****

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

Summary

Solid Professional IT experience:

. 5+ years experience in Software Configuration Management (SCM) and

build/deployment with deep knowledge in Microsoft Team Foundation

Server (TFS), SQL Server, MSBuild, CruiseControl CI Build, Visual

Source Safe, Source Control, Team Explore, Team System Web Access

(TSWA), Power Toy, and Mercury Test Director.

. Experience in administration of TFS, Visual Source Safe, Internet

Information Server (IIS), Active Directory (AD), SQL Server Reporting

Services, and Sharepoint.

. Strong experience in TFS system improvement and development.

. Full-life cycle software development experience in OOD/OOP, C#,

ASP.NET, Visual Studio .NET, Winforms, VBScript, JavaScript, HTML,

XML, Visual Basic, ASP, COM+. Knowledge of Powershell.

. Database and data warehouse experience in SQL Server 2000/2005/2008

and MS Access, including Entity-Relationship (ER) and multi-

dimensional modeling, database development in T-SQL, stored

procedures, triggers, SQL Server Analysis Services, DTS/Integration

Services and Reporting Services.

. Operating system experience: Windows NT, 2000/2003/2008 Server.

. Software testing and QA experience in both web based and Windows based

applications.

Work Experience

03/1999 - 01/2010. Configuration Engineer / Application Engineer.

Match.com Inc.

Worked as multiple roles in this largest online dating e-business company

in the US:

Software Configuration Management and System Administration:

. Managed and performed multiple scheduled builds for both web and

database objects using MSBuild and CruiseControl continue integration,

including daily routine builds (three times per day), bi-weekly

release builds, and hot bug fix builds. Managed configuration files

for different build release requests.

. Managed software deployment across development, QA and production

systems. Maintained deployment scripts and files using VBScript and

TFS utility programs.

. Managed Team Foundation Server and TSWA for the entire company in a

distributed environment with multiple locations in US, Europe,

Australia, Asia, and other regions. Administered and maintained Team

Projects, work item types, global list settings, UI layout designs,

customized rules for normal or special requests, new field settings,

customized work flow designs and implementations, and alert settings.

Created and utilized various approaches to manage these jobs, such as

self-developed C# programs, TFS command line utilities, scripts, and

Power Toy.

. Managed security for Team Foundation Server, Visual Source Safe, SQL

Server Reporting Service, IIS, and Sharepoint, include user accounts,

user groups at different scopes and levels, and access rights to TFS.

. Designed and developed Mercury Test Director work flows for software

development life cycle management.

. Performed unit tests, created test plans and test cases, coordinated

with dev, QA and users for UAT, bug fixing, and SIT, created bug logs,

utilized Sharepoint plug-in Webparts to track software release

schedules and manpower workloads. Managed QA and bug tracking systems

using TFS and Mercury Test Director.

TFS System Improvement and Development:

. Designed and developed a time and cost tracking, analyzing, and

reporting system with MS Team Foundation Server (TFS) and Active

Directory integration using SQL Server 2005 Analysis Services,

Reporting Services, TFS data warehouse, C#, and ASP.NET. Enhanced

and customized TFS multi-dimensional models, extracted data from the

system into TFS data warehouse, generated labor cost reports,

developed diagnostic and cost cutting tools at company, region, and

department levels. The system is used by the entire company on daily,

weekly, and monthly basis.

. Designed and developed an alert and email notification system which

enables managers, team leaders, and end users to easily handle work

item status changes, immediate information updates for special or

critical fields using TFS API and SDK, C#, ASP.NET, and SQL Server

2005.

Software Development:

. Created and managed QA and bug tracking reports for multiple Match.com

applications and features, such as Market Emails, Profile Approvals,

Time Tracking and Time Entry using SQL Server 2005/2008 Reporting

Services, TFS queries, TFS data warehouse, MS Excel, MS Project, and

Mercury Test Director.

. Designed and developed multiple email system tools such as Agent e-mails,

Mass e-mails and Marketing e-mails for promotions, discounts, and events

in different geographic regions, ages, genders, sign-up groups using MS

Outlook, CDO, SMTP, SQL Server 2005.

. Designed and developed a profile based auto-approval system. The system

automatically processes member profiles, scans and filters bad words,

blocks or approves member profiles and publishes in Match.com's web site

using C#, ASP .NET, SQL Server 2000.

. Developed an application for managing SQL Servers in a distributed

environment using SQL-DMO and Visual Basic. The application manages

multi-server remote access, user/user group logins, user rights, and

database security.

04/1996-02/1998. Engineer. Siemens Energy & Automation Inc.

. Mechanical design of the electrical switchboards using AutoCAD R12/14.

03/1992-04/1996. Inventory Manager / Engineer. Mactronix Inc.

. Managed material planning and inventory control systems for this mid-

sized semi-conductor manufacturer. Responsible for daily inventory

maintenance, update, backup and reporting, stockroom transaction and

recycling management, weekly MRP running, planning and forecasting,

periodical inventory counting and valuation.

Education

1982 BSME Southwestern Petroleum University, Sichaun, China.

1985 MSME Southwestern Petroleum University, Sichaun, China.

Contact this candidate