Sql Server Web Developer

Willie (Wei) Li

*** *********

Westmont, IL *****

Phone: 630-***-****

E-mail: ********@*******.***

SUMMARY OF QUALIFICATIONS

Strong business analytical skills. Understanding Prepayment modeling, fix income and its related topic.

Full life cycle business application development experience

Excellent Web/E-Commerce and Client/Server Programming

Strong database design and database administration skills

Solid object-oriented programming and problem solving skills

Great background in Computer Science, Mathematics and Statistics

COMPUTER SKILLS

Languages: Visual Basic/Visual Basic .NET, ASP, ASP.NET, C#, C/C++/Visual C++, MS Visual J++, Java,

VBScript /JavaScript, HTML/DHTML, XML, XSL, UML, CSS, SQL, PL/SQL, ADO/ADO.NET, JSP, FoxPro

Database: MS SQL Server (6.5,7.0,2000,2012,2014), Oracle, MS Access, Ingres, Informix, FoxPro, DB2

Software: MS SQL SSIS/SSRS, IIS/MTS, Data Architect, Microsoft .Net, Visual InterDev, Crystal Reports, PowerPoint,

MSMQ, SOAP, Visual Source Safe, FrontPage, Visio 2000, SAP, TOAD, Adobe Photoshop, Flash

EXPERIENCE

Li & Association (Westmont, IL) Consultant 09/04 – Present

Design, create and maintain a window stock application. The application is integrated with Fidelity Trade Pro

to retrieve real time quote. It uses SQL server to store market data, generate different trend reports.

Design, create and enhance business reports for different clients.

Bank One (Chicago, IL) Senior DBA/Developer 08/02 – 08/04

Designed, created, maintained and fine-turning SQL Server database and managed the database security.

There are more than 100 GB data in 11 databases, more than 300 stored procedures to implement the business rules

when we process the data, more than 50 DTS and Jobs to automatically process data.

Built and continue enhanced SuperBase application. This is an analysis tool used to analyze loan level (current and

future) and pool level (current) data.

Built SuperBase client software. Client uses our software to analysis their loan information and generate

forecast data based on the marketing information. We process each client’s data and generate the processed data for

their analysis using this application monthly/quarterly.

Processed the loan level data received from six different issuers, pool level data from Intex to produce the data for

SuperBase application. It also generated monthly residential ABS reports, loan forecast data (ARM and Fixed),

on-demanding reports/data required by business users and clients.

Built a data warehouse. The monthly report’s results are stored in our system. These data will be used for long-

term analysis later.

Created Microsoft Word templates used for monthly reports.

Enhanced the Prepayment Analysis application.

Tellabs (Lisle, IL) Contract (Web Developer) 10/01 – 5/2002

Enhanced and supported Detailed Specification System. The DSS software is intranet application designed to

increase the productivity of the deployment engineering group by producing detail specifications.

Technium (Chicago, IL) Consultant 9/00 – 8/2001

Designed and built several applications for different client.

eSkye Solutions, Inc: a service network and technology solutions provider for the global beverage industry.

Web Developer: built a web application allow eSkye customer service to set up and maintain user’s profile and

their priority.

SQL Server Developer: data mapping between the existing data structure and the newly implement data structure.

Converted all data from the existing database and other resources to the new database. Created and modified stored

procedures, triggers, user defined functions and built DTS packages and jobs.

VB Developer: part of the team in building an application that is used to maintain the corporate information

(exclude user information).

RollingStone.com: an internet music distribution.

Web Developer: involved in the full life cycle development of client’s system. Built a web based administrator tool

to allow the user change their data on-line. Created and modified COM components to add new functionalities.

SQL Server Developer: Created COM components to be used in jobs. Created and modified stored procedures,

triggers, user defined functions and built DTS packages and jobs.

Stargate Communications Inc. (Oak Brook, IL) Web Developer 3/00 – 9/00

Designed and built several applications for different client.

www.comm-2000.com: an information /document marketing & distribution company. It has the contract to sell

UL(Underwriters Laboratories Inc.) documents on-line. Designed and created this B2B site. Designed and set up

the application’s database. Designed and coded “Document Search”, ordering and shopping cart. Designed and

Coded the batch process to translate the product and client information between UL and www.comm-2000.com.

www.mba2mba.com: a community web site geared toward the MBA. Responsible for the web site design and

database design. Coded most of the site functionality including member sign on/registration, colleague search

and site administration functionality (maintaining member information on-line).

www.OurHouse.com: an on-line hardware store. Used SQL Server, Crystal Report as the tool to sort and group

the raw data from www.OurHouse.com and produced meaning report for the client.

Newspaper Services of American (Naperville, IL) Senior Developer 7/98 – 3/00

Designed and built a client-server application to maintain the company’s vendor information.

Designed and built an interface application for converting clients’ data into existing system.

Installed a new MS SQL Server. Designed and set up a new MS SQL Server database, converting the existing data

into the newly created database.

Designed and coded company’s intranet application

NCH Promotional Service (Lincolnshire, IL) Developer 1/97 – 7/98

Designed and modified current system (Batch and Front-end) to accomplish business changes.

Directly contacted manufacturers, obtained requests and completed tasks.

Supported current retailer system.

Metamor Technologies (Chicago, IL) Consultant 6/96 – 1/97

Designed and built several applications for client UHCI.

United HealthCare of Illinois: A healthcare insurance company.

Created, reformed current system (batch process) to achieve client’s request

Communicated directly with clients finished their requests.

On call support.

EDUCATION AND CERTIFICATE

Master of Science Degree (Computer Science, Loyola University of Chicago, January, 1994 - May, 1996)

Microsoft Technology Associate (MTA) in (70-461)Querying Microsoft SQL Server 2012/2014

Microsoft Certified Professional in Designing and Implementing Desktop Applications With Microsoft Visual Basic 6.0

Microsoft Certified Professional in Designing and Implementing Distributed Applications With Microsoft Visual Basic 6.0

System Administration for Microsoft SQL Server 7.0 (Certificate)

Crystal Report 7.0 (Certificate)

Microsoft Windows NT 4.0 Core Technologies (Certificate)

Microsoft Networking Essentials (Certificate)

References: Available upon request.

Contact this candidate