Project Mising Purchase Order and Invoice # Application
Organization Total Call International , W. Los Angeles, California
Project Type Off-site Consultant and project development
Duration July 2000 ? Sept 2001
Platform/OS Windows NT 4.0, Windows 2000
Position SQL Server Database Architect, Developer and Web Developer
Software SQL Server 7.0/2000, Access 97/2000, ASP.NET, VB.NET, IIS 4.0/5.0
Description The application finds missing Purchase orders and Invoice numbers for misuse.
Key Features
  • Confidential
My Tasks 
  • Control and update all database schemas with versioning and publish database schema diagrams.
  • Write SQL Scripts to find out missing PO and Invoice numbers from payment syste.
  • Write daily tasks scripts; Create insert script from existing data.
  • Optimize and rewrite existing stored procedures, views, and triggers for better database performance.
  • Denormalized highly normalized database for performance and optimization.
  • Help and train programmers and DBAs to write efficient stored procedures, to prevent deadlocks, to optimize indexes and queries, to convert MS-Access pass through queries into Stored procedures and change VBA codes.
  • Use SQL Server Profiler for timing and finding long running stored procedures and queries.  Use query show plan for analyzing and optimizing stored procedures. Use performance monitor and network monitor tools to measure network traffic and the performance of SQL Server machines.
  • Give advices for new SQL server hardware platform. Advise production DBAs for maintenance plans, set ups, configuration changes, applying hot fixes, checking performance monitor items and elaborating the results, finding long running queries, fixing tempdb growth, and setting up security.
  • Help Project Managers for defining each database application tasks and estimating time and resource requirements and writing project plans.
  • Create a ASP.NET Intranet Reporting application to interface and distribute reports inside Company network.