Georgia Merit System (GMS) - Goverment Dept.

Atlanta, Georgia -------------------------------------------- (7 months) Feb. 2005 - Jun. 2006
Through: Delta
[Visual Studio .NET 2003, ASP.NET, Visual C# .NET, ADO.NET, MS SQL 2000]

Analyzed, designed, and implemented an Intranet applications for State of Georgia websites in ASP.NET, ADO.NET and C#.NET with MS SQL 2000 as Database.


Drug and Alcohol Testing Intranet Site:

• Creating SQL Server Stored Procedure for Randomly Selecting State Employee for testing.
• Creating SQL Server Jobs to run Random Stored Procedure in a monthly bases.
• Emailing All Managers By SQLMail to check and Print and email employees for Drug Testing.
• Other Supported Capabilities and Admin Maintenance features, and Archiving Data

PM Tools Log System:

• Converted a desktop application to be an Intranet Application to be used by everybody and use one database (SQL Server 2000) .
• The Application Allow user to log Support calls and emails and reply/send solutions.

MSDN Discs/DVDs inventory tacking system with Check in/out capabilities:

• Allowing the Admin to maintain and keep track of the MS Discs database.
• Employee can check out any of the required MS Disc without wasting the Admin time.
• Allowing the Admin to locate any of the Checkout Disc and send a reminder to the person who posses it.

Scanning bmp signature files into SQL Server Database:

• An Intranet Application that allows users to scan, inter, and view bmp files into the SQL 2000 Database.