|
Project |
Centerlinq Kiosk Application |
| Organization |
GENESIS Intermedia Inc.,
Van Nuys-LA, California |
|
Project Type |
On-site Consultant and project development |
|
Duration |
Mar 2000 – July 2000 |
|
Platform/OS |
Windows NT 4.0, Windows 2000 |
|
Position |
SQL Server Database Modeler//Developer/Project Leader |
|
Software |
SQL Server 7.0/2000, ASP, VB,
IIS 4.0/5.0 |
|
Description |
The application manages CenterLinq kiosk machine transactions
in 200 US malls. |
|
|
|
Key Features |
- Keep track of
each user login
- Reporting
- Create coupons for users
- Provide mall specific info for mall managers and let
them update, enter or delete data.
- User profiling based on user transactions
|
|
My Tasks |
- Remodeled database structure and created the
relationships and published the new database diagram.
- Designed, altered and wrote tables, indexes, triggers, views, stored procedures,
constraints, defaults, rules, and user data types with T-SQL.
- Optimized and rewrote existing stored procedures, views, and triggers for better
database performance.
- Normalized the new central databases and denormalized them for performance and optimization.
- Helped and trained programmers to write efficient stored procedures and optimized
indexes and queries.
- Used SQL Server Profiler for timing stored procedures.
- Used query show plan for analyzing
and optimizing stored procedures.
- Transformed data from 86 databases
into 2 new centralized databases by creating
DTS packages and update queries.
-
Installed SQL Server 2000 and upgraded some of the existing databases
for test purposes.
- Setup target and master servers for clustering. Gave advices for new SQL server hardware platform.
- Setup OLAP Server for Datawarehousing and reporting projects.
- Trained junior SQL Server DBAs.
- Reengineered existing ASP codes for better performance. Tested XML queries and pages
for new development.
|