Project	Envision Application for Wireless Communication Companies
Organization	ARIS Inc., Upland-LA, California
Project Type	Onsite Consultant and project development
Duration	Dec 1999 – Mar 2000
Platform/OS	Windows NT 4.0, Windows 95/98
Position	SQL Server Developer and DBA
Software	SQL Server 7.0, Fox Pro
Description	This is an information system application for managing all aspects (from accounting to sales) of wireless communication companies.
Key Features	Billing Purchasing Technical Support Customer Care Payment, Fulfillment AR and AP Trouble Ticketing Credit card processing Quote Management POS Sales, Telemarketing, Scheduling, and Sales Analysis
My Tasks	Administered development SQL Servers machines in Windows NT environment. Wrote T-SQL script for creating new tables, indexes, triggers, views, stored procedures, constraints, defaults, rules, and user data types. Kept and updated all script in Visual Source Safe. Created installation script for Envision database application that is and Operation Support Software. Optimized and rewrote existing stored procedures, views, and triggers for better database performance. 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.