Sql Server Engineer

Location:

Seattle, WA

Posted:

October 16, 2012

Contact this candidate

Resume:

Jieyang Hu

/ Dev

* + * = **

RSS Twitter

Jieyang (Jay) Hu

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

Summary

I am currently a senior software development engineer with over seven years of

professional development experience creating web services and web applications using the

Microsoft technology stack (C#, IIS, .NET Framework, ASP.NET, and SQL Server). I have

gained a wide breadth of knowledge over the years by working on all aspects of web

development, from the front end, database backend, mid-tier, data access layer, to the

business logic layer. I started off my full time career as the second developer hired at

Seattle based startup company Twango (now Share on Ovi), a media sharing web application

that was later acquired by Nokia and currently has over six million members. Despite

having worked mostly with Microsoft technology, I am a quick learner and am frequently

called upon to rapidly prototype new functionality while utilizing various proprietary and

open source technologies.

Skills

Languages: C#, T-SQL, Java, C, C++, Python, Ruby, Perl, PHP

Scripting: Javascript, VB Script, Bash, Awk, Sed, Powershell

Frameworks: NET Framework 2.0/3.5, Windows Identity Foundation, WCF, LINQ, ASP.NET,

Cherry-PY, Classic ASP, Ext-JS, Prototype-JS

Operating Systems: Windows Server 2000/2003/2008, Linux (Fedora Core, Ubuntu, Cent OS)

Databases: SQL Server 2005/2008, MYSQL

Web Servers: IIS, Apache, Glass-fish

Other: Regular expressions, XPath, Active Directory Federation Server 2.0 (Security Token

Service) server, CSS, HTML, XSL, MsBuild, OAUTH, SAML, WebSSO, Microsoft CRM

Education

University of Washington, Seattle Washington (20012005)

Bachelor of Science in computer science with a minor in mathematics.

3.55 Cumulative GPA

Certifications

University of Washington Professional and Continuing Education C++ Certification

Microsoft SQL Serverr 2008, Database Developer Certification

HSK Chinese Proficiency Test Level 3 Certification

Work Experience

Concur TechnologiesSenior Software Development EngineerSeptember 2011present

Worked on a team of two developers to design and develop Concur Standard Travel, a

simplified version of Concur Premiere Travel. Despite pressure to use the legacy ASP code

in order to ship on time, I successfully argued for the use of ASP.NET by architecting a

flexible design. The end result was a hybrid approach that used AJAX calls to generate

HTML from ASP.NET and ASP endpoints, allowing us to port over as much of the code base as

possible to C#, while still being able to reuse old legacy code when necessary in order to

meet deadlines. In addition, I was responsible for writing the CSS and coming up with

screen mockups during the early design process. Prototype-JS and Ext-JS were the main

Javascript frameworks used. C# and VBS was used for the mid tier and AJAX endpoints, and

SQL Server 2008 for the backend. This project is expected to generate millions in revenues

and expand Concur s market share in the corporate travel booking space for mid-sized

corporations.

Designed and developed a user survey to collect customer feedback and created reports on

the data. Architected a flexible backend and midtier design that would facilitate easily

adding/removing questions using C# and TSQL. Created the front end using a combination of

ASP, ASP.NET, CSS, Javascript, and Prototype-JS.

Wrote an HTML cleanup application in C# and TSQL that fixed malformed customer generated

HTML stored in the database. This application balanced tags using a stack based algorithm.

Proactively looked for, found, and fixed security vulnerabilities in my free time,

resulting in being assigned many PCI Security compliance bugs found by third party

vulnerability scanners. These vulnerability fixes included cross site script injection,

SQL injection, and ASP injection.

Helped to develop and maintain the SQL Server 2008 backend of Concur, including database

schema design, stored procedures, and performance tuning.

Helped make the website section 508 compliant, allowing it to be more accessible to

customers with disabilities.

Helped maintain the legacy Concur Travel code base, fixing/improving functionality

ranging from seatmaps, air/hotel/car booking and reservation, corporate rules enforcement,

and advertising. Technologies used include XSL, XPATH, C#, Javascript, VB Script, and

TSQL.

(Avanade Consulting) Microsoft Software development engineer

November 2009August 2010

Worked on a team of two developers to design, develop and unit test a REST webservice

used internally by the Xbox Live team. This web service served two main purposes:

Providing a security framework to manage roles and permissions, and providing account

management capability that supplemented Microsoft CRM functionality. Technologies utilized

by this web service include WCF, C#, .NET Framework 3.5, Windows Identity Foundation,

LINQ, Active Directory Federation Services 2.0 (ADFS 2.0) and T-SQL.

Implemented a claims based authorization and authentication model for the REST webservice

by using the Windows Identity Foundation to integrate it with ADFS 2.0, a single sign on

technology from Microsoft. This involved coding an ADFS custom claims adapter that mapped

users authenticated via Windows Live and Active Directory with a claims set corresponding

to their permissions. Another key component of ADFS integration was developing custom WCF

behaviors that retrieved and verified tokens from ADFS 2.0.

Responsible for setting up, configuring and maintaining the Active Directory Federation

Services 2.0 (AD FS 2.0) server farms on the development and QA environments, including

setting up relying parties, federating with Live and Active Directory, and configuring the

claims rules. Also helped Operations set up the ADFS 2.0 servers in the production

environment.

Responsible for the SQL Server 2008 backend of the REST web service, including database

schema design, stored procedures, and replication. Worked closely with QA team during

stress testing to do performance tuning.

Responsible for build automation, deployment, and release notes.

Nokia Software development engineer

20072009

Helped design, develop, and maintain the C# midtier and data access layer of Nokia Ovi

Share, an online media sharing and content management web application that currently has

millions of users.

Designed, developed, and maintained an ATOM and a REST based web service using C#, TSQL,

and .NET that enabled applications to upload, geocode, edit, comment and share photos and

videos on Ovi Share. These APIs were mainly used by Nokia phones, allowing Nokia to

tightly integrate its web services with its mobile devices, generating tens of thousands

of daily new members on Ovi Share.

Responsible for creating and maintaining the regular expressions used by the URL

rewriting engine of Ovi Share that enabled RESTful URLs for the website and its web

services.

Using a third party SMS provider, developed the Ovi Share SMS functionality that enabled

Ovi Share users to send and receive social media notifications on their phones.

Developed and maintained the geocoding functionality of Share on Ovi, allowing automatic

location tagging of photos and videos uploaded via Nokia mobile devices. This included the

parsing and preservation of the EXIF metadata that contained the location information.

Developed and maintained RSS and ATOM syndication feeds that exposed recent, popular,

featured, and other interesting views on Ovi Share that helped to create viral social

media.

Helped design, develop and maintain the Ovi Share SQL Server 2008 backend, including

database schema design, stored procedures, and performance tuning.

Helped convert and replace the legacy authentication and authorization code of Ovi Share

with a federated single sign on solution, NCIM, provided by Nokia and based on OAUTH,

WebSSO, and SAML.

Helped develop a syndication API that allowed Nokia S40 and S60 phones to publish social

media to Facebook and Youtube. Main areas of responsibility included creating the MySQL

database schema, the Python data access layer, and the implementation of the ATOM and REST

API endpoints using Python. These APIs were hosted on Linux (Cent-OS) servers running

Apache and written in Python and the Cherry-Py web service framework.

Designed and developed a REST API for determining mobile phone number international

country codes based on mobile country code, using Java and the Glass Fish web service

framework.

Twango Software development engineer

20052007

Worked in a small team of four developers to create a media sharing/content management

website that was later acquired by Nokia. This web application was written in C#, hosted

in IIS 6.0, and used SQL Server 2005 for the backend.

Responsible for designing, developing, and writing the automated test cases for the SOAP,

ATOM and Megaweblog web services that enabled applications to upload, share, and edit

media on Twango.

Worked on the Twango SQL Server 2005 back end, including database schema design, stored

procedures, and performance tuning.

Designed, developed and wrote the automated test cases for a multithreaded windows

service that sent out email or SMS notifications regarding new user activity on social

media. Also implemented the SQL Server backend and C# business logic layer functionality

that kept track of user subscriptions and notification preferences.

Designed, developed and wrote the automated test cases for private messaging

functionality on Twango.

Virtual DSP Firmware development intern

2004

Wrote firmware code in C for the Net Muffin, a network enabled embedded software device

that remotely controls lighting appliances via the X10 protocol.

Wrote a web based UI in PERL that allowed users to monitor and issue commands to Net

Muffins plugged into their local area network.

Comments are closed.

Return top

RECENT ENTRY

Javascript === operator

Solving problems with two dimensional indexes

Finding crap in the SQL Server database

Why every developer should work for a startup at least once in their lives

Can t we all just get along?