Sql Server Developer

TOM CHEN, MCDBA, MCSA, MSc. US Citizen, Clearance: SECRET.

Senior Developer, Database Engineer

Phone: 425-***-**** Email: *********@*****.*** Skype: data800800

Linkedin: www.linkedin.com/in/tomchen22

Seattle, Washington

Summary of Qualifications

Senior Developer, Database Engineer in Microsoft Business Intelligence, Data Warehouses, SSIS ETL, Enterprise Databases, Systems, Applications & Security, SQL Server DBA, C#, ASP, ASP.NET, Java. Process automations, data cleansing, data extraction, data movement & data quality. 12+ years cross platform developer mainly on Microsoft platform but also on Open source / Sun Java / IBM Websphere / BEA Weblogic platforms.

Also a seasoned qualified Windows System Engineer, Security Administrator, Architect, Storage / SAN Architect, System & Application Management, Operations & Production Support, Migrations and Consolidations of Databases, Servers and Applications. Disaster Recovery Architect, Solution Architect.

Positive verifiable work history in US federal and military agencies (NASA, WASHINGTON AIR NATIONAL GUARD - United States Air Force, State of Oregon ), and in private consulting (HP Enterprise Services, Microsoft Corp, Intel Corp, IBM Global Services etc.

Certifications

• Microsoft Certified Database Administrator (MCDBA), May 2005.

• Microsoft Certified System Administrator (MCSA), May 2005.

• IBM certified associate developer in Websphere studio application developer, February 2004.

• IBM certified solution developer tests passed 285 and 286.

• Brainbench certified in Web Server Administration, E-Commerce Concepts, Windows 2000 Fundamentals, HTML 3.2, HTML 4.0, Dynamic HTML, JavaScript, VBScript 5.5, Active Server Pages (ASP), Visual Interdev 6. http://www.brainbench.com/transcript.jsp?pid=3076392

Education

• MS & BS, Chemistry, Beijing Normal University, CHINA, 1986. PhD student, UC San Diego, CA, USA, 1990-1991.

• New Horizon Computer Learning Center Bellevue WA, Jan.2008. Windows Server 2008 (Longhorn ), SQL Server 2008 (Katmai ), Visual Studio 2008 seminars

• Attended Computer Science ( Associate level ) at Portland Community College, 2001-2005. JAVA Programming (CIS233J), Computer Science I (CS161, JAVA) & II (CS162, JAVA). CIS234J (Java),

• Axian ( Beaverton, Oregon ): JAVA programming, also UML / Object-Orient Design, May-June 2002, Scott Davis.

• Asentus Microsoft security guidance training II #2802B, Salem, OR. Oct.19 & 20, 2004

• IBM Education, 2002-2005. JSP & Servlet Programming in WSAD 4.0 (WF311 ), August 2002, Greg L Scott. WF351, the J2EE –WSAD class, Kameron Cole; DB2-SQL, December 2002. WSAD is Websphere Studio Application Developer.

• StepTech, April 2002. Microsoft .NET

• Desktop Publishing Specialist & Adobe Photoshop Specialist, at Cuyamaca College, San Diego CA, 1996.

• Hilton Computer ( Microsoft Authorized Training Center ), Houston TX, 1999-2000. Microsoft Mastering Web Application Development Using Visual Interdev 6.0; Mastering Visual Basic 6.0 Fundamentals & Development

• Johnson Space Center NASA, Houston TX, 5 days, 1999: Work Breakdown Structures (WBS) and project management training

Technical Skills

SQL, SQL Server: 12+ years; all versions from 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 ( 1 years).

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.

Perl, C++, J++, FORTRAN: 3+ years ( took in college).

Scripting Languages:

PowerShell: 2 years JavaScript, Jscript, VBScript,, DHTML, XML, XSL, XLST, XHTML / HTML, CSS: 12+ years

Virtualization: 5 years including VMWare,Vcenter, VSphere, Virtual PC, MS Virtual Server 2005, Hyper V. Install, Configurations. Virtual Box.

Change Management and Source Control: 10+ years. Experience level in descending order: VSTS, SVN, Visual Source Safe, Team Foundation Server, TFS, PVCS, CVS, ClearCase

Builds: Wix, MSI, source depot. Ant. 5+ years.

Firewalls, SSL, SSH, Routing, DNS: configuration, setup: 10 years.

Work History

HP Enterprise Services LLC, June 2011 – present. Designed enterprise data warehouses and data marts, reporting solutions. BI, EDW, SSIS ETL, DBA, SA, SQL, C#, ASP.NET.

Quantum Dynamics Inc. / WASHINGTON AIR NATIONAL GUARD / USAF, September 2010 – July 2011, McChord AFB, WA. Sr Developer, Sr Database Engineer, Sr System Engineer. Developed security tools to scan hosts and devices on the network, developed reports with a goal to discover host or network vulnerabilities, and any fingerprints and signatures specific to certain ICS control systems of interest. Developed SSIS / ETL packages to cleanse, extract and load data into custom databases for analysis and reporting. C#, Visual Studio 2010 Ultimate, entity data framework (EF), LINQ, ICS ( industrial control systems ), network and security tool development. Hands on experiences in Virtualizations with VMware Server 2.0.X, VMware workstation, VSphere, VCenter management and Microsoft Virtual Server.

MICROSOFT July 2007 – August 2010, REDMOND WA.

• MS ONLINE SERVICES (Security & identity - MSN GFS LIVE Ops), Lead SDE / Lead 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. Reporting Metrics, Reporting portals, Dashboards, Scorecards, Scoreboards, Business Intelligence, Data warehouse, RIA WCF RIA Services. C#, Visual Studio 2010 Ultimate, MS SQL Server 2008, SSIS, SSRS, SSAS. Also installed and maintained sharepoint servers ( sharepoint server 2010 on windows server 2008 R2 x64) in a farm engaged in a multiforest AD.

• MSIT Windows Services Security Group. Sr Developer. Developed reporting and auditing systems using SSRS, SSAS, SSIS. Set up dev infrastructure on x64 windows server 2008, x64 SQL Server 2005 / 2008 and visual studio 2005 / 2008. Designed database for reporting, developed ETL processes, stored procedures and SSRS reports. ASP.NET.

• CSAT, Commerce Business Operations Group. Sr Developer, System Administrator. Successfully built / migrated BI application Spyglass from windows Server 2003 / SQL Server 2005 to Windows Server 2008 / SQL server 2008. Monitored and troubleshot BI application servers and ETL processes for Spyglass and MSSubscriptions. Silverlight.

• Specialized Devices & Applications Group / SDA, Sr Developer. Developed databases and Web services in C# and ASP.NET, Visual Studio 2008. ASP.NET 3.5.

• Developer and Platform Evangelism team / DPE: Sr Developer. System Administrator DBA. Developed SSIS packages to extract and load data from sharepoint portals into SQL Server, developed the data warehouse database. Created test OLAP cubes for reporting.

• MS Sales Reporting team / BICOE: System Administrator DBA. Implemented daily and repetitive tasks using Command Line / Windows batches / VBScript. Daily administration and production support of MS Sales reporting servers, analyzed and documented data warehouse workflow, factory job / OLAP cube details, processes and execution topology.

CLEAR CHANNEL November – December 2009. Sr Report Developer. Developed reports using MS BI toolset, SSRS & SQL.

INTEL July 2007. SQL Server developer. Developed scripts for SQL Server migrations.

THOMSON PHYSICIANS WORLD ( May – June 2007, Secaucus NJ ). Sr. Developer. Migrating a payment system written in Access Reports / Forms 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.

MOBILE PHONE APPLICATIONS (The Ringleader ) March – May 2007, New York NY. Database Architect. Design, model, architect and integrate database for mobile phone ad campaigns. Provided design spec for data center documentation, migrated / ported Atlas / Accipiter databases ( major #1 ad serving database used by USA media and ad agencies ) to MSSQL from MySQL and Oracle using SQL Server DTS / SSIS, and reverse engineered all relevant databases to produce ERD, ORM / UML diagrams and data models using tools like ER Studio, DB Designer and Visual Paradigm, to assist developers utilize these databases and understand data structure. Provided database architecture document.

IBM Global Services February 2006 – February 2007. Sr Developer, System Engineer. Lead web developer for Project Deuce, a data collection tool 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. Recognized system administrator and database storage architect, and windows systems architect / SME for SCON. Designed SAN / storage, recommended Infrastructure /Architecture. Configured HA (High Availability) clustering, load balancing for MS SQL, IIS, SQL server and windows server data collection and sizing of databases / partitions / SAN volumes; For example design and migration of Onyx databases on SQL Server clusters for Ameriprise.

ABBOTT VIA MADISON PERFORMANCE INC November 2005- January 2006. Report 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.

JP MORGAN CHASE, August - November 2005. SQL Server developer DBA. Created DTS packages to load data from Bank One PCS Access / Excel data source to SQL server. JSP / Java bean development. Environment: SQL Server 2000, DB Artisan, BEA Weblogic Application Server, Java, JSP, Servlet, Windows 2000 advanced server.

STATE OF OREGON DHS, Oregon Health Services March 2002 – May 2005. Web Developer, System Administrator

• As NEDSS ( National Electronic Disease Surveillance System ) – NBS ( NEDSS Base System ) developer I ported a large JAVA /J2EE health application from Oracle – Silverstream environment to DB2 – Websphere environment. I ported over 200 java objects to work / comply with IBM DB2 SQL syntax requirement. Learned iPlanet LDAP programming in Java., Heavy debugging in Websphere studio for struts and cocoon libraries to resolve certain critical errors. Configured IBM Websphere SSL and administered Websphere application server. eSentinel is a custom disease monitoring application I participated. I succeeded in adding data export, secure file upload / download, and email notification features. UML / use case modeling using Visio. Contributed to and wrote several components to the DHS-wide initiative for Websphere environment / server testing / certification using Java and servlets etc. Environment: Websphere Studio Application Developer 4 and 5, Websphere Application Server 4 and 5, Java, JSP, Servlet and Struts, UML / Visio, DBArtisan, ERWIN, DB2 and SQL server, JavaScript, XML, PVCS, Windows 2000 advanced server, IIS5, Weblogic and iPlanet / Sun One LDAP server.

• Provide daily production support to NEDSS applications. I configured NEDSS servers customized for Oregon. Installed / configured Windows 2000 Advanced Servers and Windows Server 2003, SQL Server 2000, BEA Weblogic Application Server, iPlanet LDAP Directory Server, SAS Reporting Server, NEDSS Apps on RAID 5 volumes on HP Proliant DL360 and DL380 servers.

INTEL CORP, Intel Health Group, Hillsboro, Oregon. September 2000 to March 2001. Sr Web Developer

I implemented and revised user interface of American Medical Association (AMA) Internet ID Application 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. Assisted in configuring & troubleshooting ClearCase, Tracker server applications. Environment: Visual Interdev / Studio 6, ASP, Oracle, SQL server, VB & Java script, XML, Perl, ClearCase, Windows 98 and 2000 advanced server, IIS5.

SALTMINE, Seattle, Washington. April - August 2000. Sr. Web Developer.

Client 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.

NASA JOHNSON SPACE CENTER, FUTRON, Houston, Texas. January 1999 to March 2000. Report Developer. 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 using Crystal reports, HTML, ASP, VBScript, JavaScript, DHTML and Visual Interdev.

N Harris & Tomball College, Houston, TX. May – December 1998. Instructor, computer information systems. Taught Intro Computers, Windows 98, Databases and Office 97, Windows NT Workstation, NT Server to two-year degree students and extended study students.

Awards, Honors, Publications and Early Demonstration of Skills in Computing Intel award, November 2000, for promptly delivering the AMA Internet ID application to American Medical Association. State of Oregon Appreciation ( Ladd-Wilson to Tom Chen For DHS Health Services), 2005. Futron / NASA presented a gift to Tom Chen in March 2000 during his farewell event appreciating his efforts at NASA JSC. First Prize in English, Second Prize in Mathematics, Anhui Provincial Contests For High Schools, 1979. "Selective Column Concentration of Alkali-Metal Cations with a Crown Ether Carboxylic Acid Resin," T. Hayashita, J. H. Lee, S. Chen and R. A. Bartsch, Anal. Chem ., 1991, 63,1844-1847. "Solvent effect in radiobromination via bromine-for-bromine nucleophilic substitution reactions," S. Chen and B. Liu, J. Radioanal. Nucl. Chem. Lett., (Budapest), 1988, 126(4), 279-286. "The calculation of cavity radii of crown compounds by means of the 2 pi method," S. Chen and B. Liu, J. Beijing Normal Univ., 1986, 3, 54-60. Early chemistry career dealt with physical chemistry, pharmaceutical and organic chemistry, medicine, spectroscopy.

Miscellaneous Skills and Experiences:

Teamwork and Communication: Excellent teamwork attitude, interpersonal rapport and communication, proactive and take initiatives. Possess highly effective leadership and interpersonal skills, and able to contribute as a team player. Excellent analytical and troubleshooting skills and ability to quickly get up to speed on new technologies. A self-motivated and enthusiastic team player, I consistently manage and implement multiple projects, meet project requirements, and ensure project deliverables are completed on time and on budget.

Software Expertise (Hands-on Experience and Expert Level Usage):

Office (97, 2000, 2003, 2007, XP) including Word, Excel, Access, Visio, PowerPoint, Project, Publisher, FrontPage Desktop publishing, PageMaker, QuarkXpress, multimedia presentation

Graphics: Adobe Photoshop, Premier, CorelDraw, Illustrator, Flash, Freehand. File conversions / compression / optimization. PDF Writing. Video capturing, editing. DVD authoring.

Document Management, Imaging, Acrobat, Pagekeeper, Omnipage, Paperport. Form Management (Scan & OCR, Omniform, Roboform, and Xerox Omnipage), Data, image & document conversions, archiving. Xerox Scanworks.

Chemistry: Extensive experience using LC/MS, GC/MS, HPLC, FPLC, All major spectroscopy and chemistry / biochemistry lab equipment and instruments. Inorganic, organic, medicinal, bioorganic, molecular, pharmaceutical chemistries, radiochemistry, nuclear chemistry / medicine, CT tomography.

List of websites I developed:

NEDSS: https://apps.dhs.state.or.us/eNBSAuth/logon Java developer, principal database administrator and state production support since March 2002. ESentinel: https://apps.dhs.state.or.us/eSentinel/logon Java developer. AMA Website: https://membership.ama-assn.org/JoinRenew/search.jsp?checkXwho=done . (Site originated from my ASP site.)

References: Available upon email request.

Contact this candidate