| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateWillie (Wei) Li
Street Address Beninford
Westmont, IL Street Address
Phone: PHONE NUMBER AVAILABLE
E-mail: EMAIL AVAILABLE
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. |
