AddThis Social Bookmark Button
Kathy Schmid
SW 27th St . , Topeka, KS - 66614 USA
Expertise :SQL Server, Visual Basic, ASP
Status :Citizen
Job Type :
Permanent
Position :

Resume
 

Summary

Career Objective
Position in Application Development or Database Administration


Employment

2007 -  Present
SQL Database Administrator

SQL Database Administrator Mental Health Consortium , Inc
Administer SQL Server 2000, SQL Jobs, Set up Mail Service with Outlook using Exchange server. Extract data for conversion, create queries, stored procedures, views, create and set up jobs and maintenance plans. Add Users and grant permissions. Design database structure, manage indexes and DTS packages. Load SQL Server software, hot fixes and patches.


2001 -  2007
Applications Development Supervisor

Applications Development Supervisor Juvenile Justice Authority
Develop, Design, Code, Test, Maintain Web applications In ASP, Vbscript, JavaScript, HTML, CSS, SQL, VBA, XML, Visual Basic 6.0, Stored Procedures using SQL 2000 and Access 2000 Databases. Consult and Train users on applications. Deploy Applications On Web Server and SQL Server. Provide Database Administration backup. Manage User Logins and Permissions. Design and Develop Database Applications in SQL 2000 and Access 2000. Database Architecture and structure design for applications. Design Models for users, Gather design documentation. Project Management for applications. Supervise 5 Application Developers.


2000 -  2001
Analyst

Programmer Analyst II Kansas Department of Health and Environment

Design, Develop, Code, Maintain Database in Visual Basic 6.0, Access, SQL 7.0 Server, Create Reports in Access, Visual Basic. Work with users in development of database and reports. Create queries using SQL.


1999 -  2000
Research Analyst

Research Analyst II Kansas Department of Transportation

Create new project schedules and modify existing project schedules. Monitor and track schedules, conduct statistical analysis. Prepare reports to support KDOT tracking of project schedules. Maintain templates and adding of activities to schedules. Ad hoc reports for Data Analysis and research. Write database in Access, Excel.


1994 -  1999
Accounting Manager

Accounting Manager Topeka Association For Retarded Citizens , Inc




Education

Allen County Community College GPA 3.91
Associates Degree in General Studies

Friends University
Organizational Management and Leadership Bachelor of Science
Cumulative GPA 3.90



Miscellaneous

Order of the High Tower Highest Honor

Professional and Custom Computer Training

Dynamic Computer Customer Training in GroupWise
Kaw Area Technical Custom Computer Training in Microsoft Office
Washburn University Custom Training in Visual Basic 6.0
New Horizons Dreamweaver, Flash, UltraDev
New Horizons XML, XSL, DTD, Schemas
ExecuTrain SQL Server 2000 Administration
ExecuTrain Querying SQL Server 2000 with Transact-SQL
Foss Training Programming SQL Server 2000
Foss Training Advanced Crystal Reports 9.0
ExecuTrain Programming Microsoft Access 2002
Project Management Training St of KS Session 1

Manage and supervise Accounts Payable, Inventory, Maintain and process Accounts Receivable, Maintain and perform reconciliation of General and Payroll Checking Accounts, Maintain ledger on investments, Maintain and reconcile Family grants and Family Subsidy, Monitor receipt and Payment of County Mill and State funds for affiliates, Monitor, Audit and maintain allocations for specific budget accounts, Prepare and encode journal entries, Prepare Investment page for Treasurers Report, Prepare 1099, Monthly KDOT report, Process Intangible Personal Property, Process Exemption Applications, Process Unclaimed Property to St of KS, Process KS Excise report, Maintain and process Food Program monthly reports and annual budget, Process credit applications. Load software and perform software support. Coded and designed Database in Access 97 for Grant tracking.

Equipment and Software Used : SQL 2000, Windows 2000, Windows Server 2003 Office 2000, Terminal Server, Access 2000, Front Page, IIS 5, IIS 6, NT 4, Internet Explorer, Visual Studio, Visual InterDev, Visual Basic 6.0, FrontPage, GroupWise, Dreamweaver, Lotus Notes, Internet Explorer, Netscape, Excel, Access, Visual Basic 6.0, SQL, HTML, CSS, Magic Help Desk, Exchange Server, Outlook, Track It.

Todd Reinert Work Reference
1713 SW Village Dr
Topeka, KS 66604
Home Number

Jim Davis Work Reference
KDHE

Christine Reece Work Reference
7230 Wattling Court
Topeka, KS 66614
Home Number -

Work Number -

David Harder Work Reference
15025 Topeka Ave
Carbondale, KS 66414
Home Number -

Work Number -

Gerri Rathke Work Reference
5100 SW 32nd Terrace
Topeka, KS 66614
Home Number -

Connie Wahweotten Personal Reference
DISC
Personnel Department

Work Number -

Dr.L .D. Holmes Personal Reference
Wanamaker Woods Nazarene Church
Topeka, KS 66614


3