Sql Server Engineer
Resume:
> TOM CHEN
MCDBA, MCSA *********@*****.*** C# EF SQL Server Developer DBA SSIS SSRS ASP.NET Business
Intelligence, Data Warehouse
Location
Greater Seattle Area
Industry
Information Technology and Services
.
TOM CHEN
Contact TOM CHEN directly
TOM CHEN's Overview
Past
Business Intelligence Architect Data Warehouse Developer SSIS ETL SSRS C# .NET SQL DBA at
HP Enterprise ServicesSr Database Developer, DBA, Sr System Engineer at United States Air Force
Sr DBA & Systems Programmer at Quantum Dynamics, Inc
.
Sr. ETL Architect, Business Intelligence Developer, Sr. Software Design Engineer at
Microsoft contractor
Sr. Enterprise Developer, System Engineer, DBA, BI, Storage Architect at IBM
Sr. Enterprise Developer, System Engineer, DBA at IT Consulting
Database Architect, BI Solutions at Ameriprise Financial Services, Inc
.
SQL Server Consultant at JPMorgan Chase
SQL Server Consultant at RMS Computer Corporation
Sr. Enterprise Developer, Administrator, DBA at State of Oregon
Sr Software Engineer at Intel
Sr Software Engineer at Saltmine LLC
Principal Web Developer at ArtsPatron.com
DBA & Web Developer at Futron
DBA & Web Developer at NASA
Adjunct Faculty - Instructor, Computer Information Systems at Lone Star College System -
Tomball N Harris College
see less
see all
Education
Certifications: MCDBA, MCSA, MCP, IBM WSAD
Beijing Normal University
Beijing Normal University
IBM Education
Microsoft
Microsoft Partner: Houston Computer Inc
Microsoft Partner: New Horizon Computer Learning Center
Oregon Axian
Portland Community College
StepTech
see less
see all
Recommendations
18 people have recommended TOM
Connections
500+ connections
Websites
Resume & Portfolio
TOM CHEN's Summary
U.S. Security Clearance: DoD Secret ( Active). Senior Developer. Business Intelligence,
SQL Server, DBA, ETL Architect, SSIS Developer, Database Engineer, Data Warehouse (DW).
SQL, SQL Server: 12+ years; SQL Server 2008 R2, 2005, 2000, 7, 6.5. Stored Procedures,
Functions, Triggers, T-SQL, Performance Tuning, OLAP, OLTP. IBM DB2 v7 & 8 ( 4+ years),
Oracle 8 / 9i for NT/2000 ( 3+ years ), MySQL (6+ years), SQL. Access, DBASE: 14+ years.
SQL Server Integration Service or SSIS ( 4+ years), DTS (6+ years), ETL design ( Extract
transform - load ) including replication, publishing, data import, export. Database
design, data schemas, OLTP normalization & denormalization for reporting databases.
SQL Server Reporting Service or SSRS (4+ years), some Analysis Service 2005 /2008. Data
warehouse / data mart ( multidimensional database design ).
KPI, Cube design (2+ years), MDX.
Visual C# (2010 / 2008 / .NET), ASP.NET, ADO.NET, Web Services: 8 years. Entity
Framework: 2 years (implemented EF and EDM for a Silverlight web portal at MSN Live Op in
2010 and, for a windows form application, a command and control system at USAF /
Washington National Guard / Quantum Dynamics Inc )
Silverlight: 2 years. MVC in J2EE: 6+ years. MVC in ASP.NET: 3+ years.
Java, JSP, Servlet, EJB, J2EE, open source, cocoon, XSP, LDAP, Tomcat, Xerces, Struts
Framework, Websphere Studio (WSAD 4 and 5.1): Apache, Eclipse, MyEclipse, Tomcat, JBoss,
SUSE, Ubuntu, Linux: 9 years
Visual Studio, Visual Basic, VB, ADO,, Classic ASP, VBA, COM, COM+, DCOM, MTS: 12 years.
All versions: Team System 2010 Ultimate / 2008 / .NET / 6.
Main developer for AMA website at Intel in 2000; Migrated CDC NBS from MSSQL to DB2 for
Oregon. Led SQL SCON design for Ameriprise; migrated the largest ad database ( Accipiter /
Atlas ) from Oracle to MSSQL.
Specialties
C#, SQL, SSIS, SSRS, Silverlight, BI. MVC. ASP.NET, Java. Enterprise Developer, System
Engineer, Database Architect, Disaster Recovery, UBDR, VMWare, Websphere, Weblogic, C#. BS
MS: nuclear chemistry, nuclear medicine, diagnostic imaging, molecular computing, gene
therapeuticsTOM CHEN's Experience
Business Intelligence Architect Data Warehouse Developer SSIS ETL SSRS C# .NET SQL DBA
HP Enterprise Services
Public Company; 10,001+ employees; Information Technology and Services industry
June 2011 June 2012 (1 year 1 month) Greater Seattle Area
Business Intelligence Reports and EDW Development Team (HP), Vale Transition and
Transformation (Windows 7).
Delivered reports to project managers of HP and Vale executives for a large scale windows
7 upgrade and migration project ( Application Remediation) . Designed enterprise data
warehouses and data marts, reporting solutions. BI, EDW, ETL, DBA, SA, SQL, C#, WPF, RIA,
ASP.NET.
Supported business executives and managers and a global team responsible for the critical
success of development, planning and executing the certification and remediation of all
applications within a customer environment in preparation for the migration to Windows 7.
Initiated system integration with multiple organizations, created reports regularly to
help managers conducting data analysis and setting priorities to ensure delivery of
Windows 7 throughout the global environment.
Supported and interacted with multiple teams within HP and Vale vendors in multiple
countries. Solved multiple technical as well as administrative problems between teams, HP
ES labs, overcame various obstacles to save money both for HP and the customer.
Sr Database Developer, DBA,
Sr System EngineerUnited States Air Force
Government Agency; 10,001+ employees; Defense & Space industry
September 2010 July 2011 (11 months)
contractor at Washington Air National Guard, 262 NWS, McChord AFB, 24th Air Force, US
Cyber Command. Industrial control systems (ICS), network vulnerabilities assessment and
security tool development. LINQ.SQL Server, database and report designs, ETL, SSIS, data
cleaning and loading, SSRS, business intelligence, Visual Studio 2010, entity data
framework (EF). VMWare, Data Collection on systems, registries, applications installed.
Sr DBA & Systems ProgrammerQuantum Dynamics, Inc.
Privately Held; 11-50 employees; Information Technology and Services industry
September 2010 July 2011 (11 months)
contractor at Washington Air National Guard, McChord AFB, United States Air Force.
Industrial control systems (ICS), network vulnerabilities assessment and security tool
development. LINQ.SQL Server, database and report designs, ETL, SSIS, data cleaning and
loading, SSRS, business intelligence, Visual Studio 2010, entity data framework (EF).
VMWare, Data Collection on systems, registries, applications installed.
Sr. ETL Architect, Business Intelligence Developer, Sr. Software Design Engineer
Microsoft contractor
Public Company; 10,001+ employees; MSFT; Computer Software industry
July 2007August 2010 (3 years 2 months)
MS ONLINE SERVICES, Sr SDE / Database Engineer. Developed and maintained SSIS packages
for data feeds, and developed FOPE subsystems for a Silverlight business intelligence
application for enterprise dashboard reporting and monitoring of server operation metrics
and performance counters. Developed database schemas and SSIS to store and display complex
hierarchy data. Also installed and maintained sharepoint servers ( sharepoint server 2010
on windows server 2008 R2 x64) in a farm engaged in a multiforest AD. Reporting Metrics,
Reporting portals, Dashboards, Scorecards, Scoreboards, Business Intelligence, Data
warehouse, Silverlight, RIA WCF. ASP.NET.Visual Studio 2010 Ultimate, MS SQL Server 2008,
SSIS, SSRS, SSAS.
Developed SSIS packages to load data from Excel to SQL 2008. Designed databases for
reporting, developed ETL processes, stored procedures and SSRS reports for MSIT. Monitored
and troubleshot Spyglass and MSSubscriptions applications and ETL processes. Developed
data models, web services and video upload applications. Created test OLAP cubes for
reporting. Extracted data from sharepoint portals. SSIS / ETL data into SQL Server and
designed the data warehouse database. Technologies: C#, Web Services, ASP.NET, LINQ to
SQL, LINQ to XML, Object Relational Designer, Microsoft Entity Framework, Microsoft
ASP.NET MVC, Dundas controls, CLR stored procedures, Silverlight, WPF, Visual Studio 2008
/ 2010, Business Intelligence Development Studio, Report Designer, Report Builder 2.0, TFS
2008.
Sr. Enterprise Developer, System Engineer, DBA, BI, Storage Architect
IBM
Public Company; 10,001+ employees; IBM; Information Technology and Services industry
February 2006February 2007 (1 year 1 month)
Clients include Ameriprise, Avaya, ICI etc. (a) Led SQL server data collection and
sizing, analysis, and consolidation design, database migrations, SQL server clustering,
SAN storage / partition design, Veritas enterprise administrator. (b) Data collection web
tool (Deuce ) development using ASP and SQL server 2005. Wrote stored procedures,
triggers, views, DTS packages to pull data from diverse data sources etc. Designed most of
the front pages in ASP and backend database in SQL server. Deuce database backup and
system maintenance, and troubleshooting application errors / debugging. Got 5 star rating
from Paul Hawbaker, PM on the Ameriprise account for IBM. Team was quite impressed by
Tom's sizing calculations on the Avaya account.
Sr. Enterprise Developer, System Engineer, DBA
IT Consulting20052007 (2 years)
THOMSON PHYSICIANS WORLD 2007. Migrating a payment system written in Access VBA with some
data on MS SQL Server 2000. Migrated / converted some Access 2000 queries to MS SQL 2000
stored procedures and views which in turn are used by Access reports / forms. Expert in
creating Access passthrough queries to use SQL server 2000 procedures / views to feed
access reports, dramatically improving performance. It worked! It impressed the client
team.
Mobile Phone App. 2007. Design, model, architect and integrate databases. Provided data
center / database architecture documentation, migrated / ported databases to MSSQL from
MySQL and Oracle, and reverse engineered all databases to produce ERD, ORM / UML data
models using DB Designer and Visual Paradigm.
Abbott project 2005-2006. Web Developer using ASP / VBScript / JavaScript / SQL. Enhanced
client s required web applications, to manage sales force / promotion points / awards.
Troubleshooting, implemented some sophisticated features. SQL Server 2000 / 2005.
Database Architect, BI Solutions
Ameriprise Financial Services, Inc.
Public Company; 5001-10,000 employees; AMP; Financial Services industry
2006 2006 (less than a year) Greater Minneapolis-St. Paul Area
SCON Lead and SQL Server architect for its BI platform, reporting servers, data
collection and sizing, analysis, and consolidation design, database migrations, SQL server
clustering, SAN storage / partition design.
SQL Server ConsultantJPMorgan Chase
Public Company; 10,001+ employees; JPM; Financial Services industry
20052005 (less than a year) New York, New York
Development DBA. Contract through RMS Computer Corporation. Work mostly on database
loading from Bank One PCS Access / Excel data to SQL server supporting developers, created
DTS packages to automate data import and mapping. Assisted with some JSP / Java bean
development, troubleshooting the application and Weblogic admin. Environment: SQL Server
2000, DB Artisan, BEA Weblogic Application Server, Java, JSP, Servlet, Windows 2000
advanced server.
SQL Server ConsultantRMS Computer Corporation
Privately Held; 51-200 employees; Information Technology and Services industry
20052005 (less than a year) New York
Development DBA. Contract through RMS Computer Corporation. Work mostly on database
loading from Bank One PCS Access / Excel data to SQL server supporting developers, created
DTS packages to automate data import and mapping. Assisted with some JSP / Java bean
development, troubleshooting the application and Weblogic admin. Environment: SQL Server
2000, DB Artisan, BEA Weblogic Application Server, Java, JSP, Servlet, Windows 2000
advanced server.
Sr. Enterprise Developer, Administrator, DBA
State of Oregon
Government Agency; 10,001+ employees; Government Administration industry
20022005 (3 years)
Designed and executed application and security architecture for NBS / NEDSS application.
Provide daily production support to NEDSS and WebLEDS applications. I configured NEDSS
servers. Installed / configured windows 2000 advanced server, SQL Server 2000, BEA
Weblogic Application Server, iPlanet LDAP Directory Server, SAS Reporting Server, NEDSS
Apps on RAID 5 volumes. I built servers, installed all applications and database,
performed daily maintenance, monitoring, backup, disaster recovery of systems and
databases. Data manipulation, generation, and cleanup. Data movement and warehousing using
SAS and DTS. Wrote batch jobs to automate file transfer through secure channels. Created
security procedures, documents for management Monitors system security. * NEDSS Java
development / porting from existing CSC -CDC application. *eSentinel: succeeded in adding
data export, secure file upload / download, and email notification features
Sr Software Engineer
Intel
Public Company; 10,001+ employees; INTC; Semiconductors industry
2000 2001 (1 year)
implemented and revisioned user interface of AMA Internet ID Application ( https://id.ama-
assn.org/) using JavaScript / VBScript / dhtml / ASP and visual Interdev, and JAVA applet
calls. Made significant contribution to Revisions 1, 2 & 3 of this application. Coded /
implemented browser detection feature which fully detects and routes users based on
browser type, platform, version, cookie, and java capabilities. * ARD auth response:
enabled real-time debugging and testing by test engineers to troubleshoot the AMA
application, its components and backends. Implementation of AMA support using asp mail
component. Setup and maintained several servers.
Sr Software EngineerSaltmine LLC
Privately Held; 51-200 employees; Marketing and Advertising industry
2000 2000 (less than a year)
ArtsPatron (Saltmine client). Chief architect for the SQL server 7 backend databases and
db diagrams, and principal author of the ASP forms related to the information collection,
profiling, updating and queries for art organization module, visitor module etc. Visual
Interdev / Studio 6, ASP, SQL server, VB & Java script, Windows 2000 server, IIS5.
Principal Web Developer
ArtsPatron.com
2000 2000 (less than a year)
ArtsPatron (Saltmine client). Chief architect for the SQL server 7 backend databases and
db diagrams, and principal author of the ASP forms related to the information collection,
profiling, updating and queries for art organization module, visitor module etc. Visual
Interdev / Studio 6, ASP, SQL server, VB & Java script, Windows 2000 server, IIS5. I met
Bill Gates Jr, father of Microsoft founder Bill Gates, who sponsored and funded
ArtsPatron. He had a business meeting with CTO David Ackerson and me at ArtsPatron. In
August 2000, Ackerson told me, "Tom, Thanks so much for your hard work on the
ArtsPatron.com database. I think the events database functions well as we envisioned at
the beginning of the project, and we've managed to meet the goals that we set. I enjoyed
working with you, and if you need a reference in the future, you can count on my
support... Thanks again for your efforts...
DBA & Web Developer
Futron
Privately Held; 51-200 employees; Aviation & Aerospace industry
19992000 (1 year)
Developed & supported several database-driven reporting & query systems for project &
program management, now widely used by NASA. Upgraded this web app from ver.1 to ver.3.5,
and developed some unique and powerful modules and components to express data and
reporting, an example being the success in creating a client function, which adds /removes
items from listboxes using HTML, ASP, VBScript, JavaScript, and most importantly, DHTML
and Visual Interdev. Developed a data source provider component DLL which builds
recordsets from SQL7 databases on the fly as called by ASP pages using COM/DCOM.
Environment: Visual Interdev / Studio 6, ASP, SQL server, VB & Java script, Windows 98 and
NT server, IIS4. Enjoyed parties and handshakes with CEO Joe Fuller, and an all hands
meeting at its headquarter office in Bethesda Maryland. Cherish an framed picture for ISS
( International Space Station ) signed and presented to me by many Futron employees in my
farewell party in March 2000. Thank you Kevin Repa for remembering me and keeping in
touch!
DBA & Web Developer
NASA
Government Agency; 10,001+ employees; Aviation & Aerospace industry
19992000 (1 year)
Contracted through Futron. Worked at Program Integration Office, Space & Life Science
Directorate under Program Manager Kevin Repa, Enterprise Architect Stacey Morrison,
Director Judy Robinson, and Lead Scientist John Charles in Building One. Developed &
supported several database-driven reporting & query systems for project & program
management, now widely used by NASA. Tom successfully upgraded this web app from ver.1 to
ver.3.5, and developed some unique and powerful modules and components to express data and
reporting, an example being the success in creating a client function, which adds /removes
items from listboxes using HTML, ASP, VBScript, JavaScript, and most importantly, DHTML
and Visual Interdev. Developed a data source provider component DLL which builds
recordsets from SQL7 databases on the fly as called by ASP pages using COM/DCOM. DBA for
SQL server. Environment: Visual Interdev / Studio 6, ASP, SQL server, VB & Java script,
Windows 98 and NT server, IIS4. Thank you Stacey Morrison for remembering me and keeping
in touch!
Adjunct Faculty - Instructor, Computer Information Systems
Lone Star College System - Tomball N Harris College
19981999 (1 year) Houston, Texas Area
Taught introductory computer science courses, computer applications, computer networks.
TOM CHEN's Certifications
Microsoft Certified Database Administrator
Microsoft
License 2333731
May 2005
Microsoft Certified System Administrator
Microsoft
License 2333731
May 2005
IBM certified associate developer
IBM
February 2004
TOM CHEN's Skills & Expertise
EDW
Business Intelligence
SQL
C#
SSIS
SSRS
SSAS
ETL
Data Cleansing
Pattern Recognition
Entity Framework
ASP.NET
MVC
Kimball Methodology
VB.NET
Java
Websphere
WSAD
J2EE
IIS
Team Foundation Server 2010 / 2008
Sharepoint Server 2010
PowerShell
BEA Weblogic
Silverlight
RIA
Virtual Server 2005
VMware Server
View All (28) Skills View Fewer Skills
TOM CHEN's Languages
English
(Native or bilingual proficiency)
Chinese
(Native or bilingual proficiency)
TOM CHEN's Education
Certifications: MCDBA, MCSA, MCP, IBM WSAD
2005
Beijing Normal University
Bachelor of Science (B.Sc.), Chemistry
Beijing Normal University
Master of Science (M.Sc.), Radiochemistry
IBM Education
Java, Websphere
Activities and Societies: IBM, 2002-. JSP & Servlet Programming in WSAD 4.0 (WF311 ),
August 2002, Greg L Scott. WF351, the J2EE WSAD class, Kameron Cole; DB2-SQL, December
2002.Sponsor: State of Oregon DHS.
Microsoft
Activities and Societies: internal proccesses / training in SCRUM, Agile SDLC. MSE
enterpise service management system. Product Studio for builds, packaging, change
management and deployment.
Microsoft Partner: Houston Computer Inc
Microsoft Training in Visual Studio
Activities and Societies: Microsoft Visual Interdev 6.0; Visual Basic 6.0, at Hilton
Computer, Houston TX, 1999-2000. Sponsor: NASA JSC.
Microsoft Partner: New Horizon Computer Learning Center
Computer Training
Oregon Axian
Java, UML
Activities and Societies: JAVA programming, also UML / Object-Orient Design, May-June
2002, Scott Davis. Sponsor: Oregon DHS.
Portland Community College
Coursework, Computer Science
JAVA Programming (CIS233J), Computer Science I (CS161, JAVA) & II (CS162, JAVA). CIS234J
(Java).
StepTech
.NET training
TOM CHEN's Additional Information
Websites:
Resume & Portfolio
Interests:
Groups and Associations:
Beijing Normal University Alumni
Codeproject
Data Warehousing Professionals Group
Federal IT Group
HP
HP Business Intelligence Solutions
HP Connections - Current Employees and Alumni of Hewlett-Packard
HP Oregon Washington Alumni
Hewlett Packard Information Management & Analytics
International Space Station
KVL - Microsoft Business Intelligence
Microsoft - Current and Former Employees
Microsoft Business Intelligence
Microsoft Developers
Microsoft Public Sector Services Careers
NASA
OSS/BSS Professionals
Putting America Back to Work 2011
SQL Server
SQL Server Administrators
SQL Server Database Administrators
SQL Server Developers
SQLDBA
SQLServerCentral
Technical Evangelists
Honors and Awards:
Microsoft Certified Database Administrator ( MCDBA ), Microsoft Certified System
Administrator ( MCSA ) 2005.5; IBM Certified Websphere Studio Application Developer (WSAD
) 2004; Microsoft Certified Professional (MCP ) 2002. Intel Award, Nov 2000, AMA Internet
ID application for American Medical Association. On May 5, 2004, DHS OIS CIO Mr Crowell
cited / honored Tom Chen and his NEDSS team for successfully developing and deploying
eSentinel application.
Contact TOM for:
Contact this candidate