|
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.
|