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.