| |
| |
 |
 |
 |
 |
| In the News |
2008/5/13
New website design is live! |
|
|
| |
| |
| |
|
|
|
| |
|
|
 |
- Developed revolutionary
Google Transit - a web based application which provides online trip planning for public transportation together with
Google project team
- Extracted data from different sources including Trapeze,
SQL Server 2000/2005, Access databases, and MapInfo
- Manipulated service data to calculate route, transit time and cost using Trapeze, ArcGIS, SQL Server, Access, and GPS data
- Tools and Environment:
VB/C# .Net 2.0, Visual Studio 2005, MS SQL Server 2005/2000, T-SQL, MS Access, ADO/ADO.Net,
ODBC, XML, VBA, MS Visio, Windows Server 2003/XP, Active Directory, Exchange Server,
Trapeze, VM Ware, Citrix
-
Developed databases for next generation online and LAN-based large scale retail
financial service application – Student Loans
for JPMC
-
Designed databases at both logical and physical level
-
Developed/optimized Stored Procedures, Views, Functions, Indexes, and Triggers in SQL Server 2000/2005.
-
Database Extract, Transform and Load (ETL) from various sources using DTS
and SSIS Packages
-
Conducted database server configuration optimization, performance monitoring and
tuning
- Tools and Environment: VB/C# .Net 2.0, Visual Studio 2005, VSS,
MS SQL Server 2005/2000, T-SQL, MS Access, ADO/ADO.Net,
ODBC, XML, VBA, N-Unit, Mercury, MS Visio, Novell Network, Windows
Server 2003/XP
- Developed Industry
Loss Experience Database, the first one in the United
States for business and home
property loss and insurance data analysis/forecasting
- Acquired and analyzed
data from large insurance companies like Nationwide and USAA
- Designed database at
both conceptual and physical level using IDEF1x model and ERD in
Visio
- Developed T-SQL
scripts, views, stored procedures, functions, and triggers in SQL
Server 2000
- Developed tables,
forms, SQL queries in MS Access frontend - SQL backend
client-server system using VBA code and ADO
- Designed and created
an end-to-end ETL process using DTS in Microsoft SQL Server
2000
- Tools
and Environment: VB, Visual Studio 2003, MS SQL Server 2000,
T-SQL, MS Access, ADO/DAO,
ODBC, XML, VBA, MS Visio, Windows Server
2000/XP,
Active Directory, Outlook
|
|
| |
|
|
