KEVIN M. COCCARI
PROFILE Lead staff person in regards to Database
Administration, providing technical support and system administration services
for various applications and database development.
WORK EXPERIENCE
Southwestern Pennsylvania Human Services
Eastgate
8,
Network/Database Administrator (2000-Present)
ESSENTIAL FUNCTIONS:
·
Responsible for a wide range
of computer-related duties associated with system administration, database
development/maintenance, workstations, network printer setup, network security
and configuration.
·
Develops, maintains and enhances corporate and
program-specific databases using Microsoft Access 2000/XP/2003, SQL Server
2000, Crystal Reports, and Office Developer for various corporations.
·
Database Administration for Human Resources, Fund Accounting,
and payroll applications.
·
Migrated SQL databases from Windows 2000 to Windows 2003
server.
·
Established remote access using the Internet, Virtual
Private Network, and Citrix connectivity for users.
·
Developed a Help Desk application in Microsoft Access
for IT staff.
·
Implemented an application for importing monthly bulk
services from a Microsoft Access database to a SQL 2000 database utilizing Data
Transformation Services (DTS).
·
Lead Technical Writer for end-users and computer staff.
·
Serves as Corporate Webmaster that included migration to
Microsoft FrontPage 2000, multi-user access, and staff training.
·
Serves as lead staff person in regards to corporate
Internet access that included Intranet development, software installation,
Anti-virus, Web Hosting setup, and related standard operating procedures. Also
developed a Corporate Bulletin board for Southwestern Pa Human Services and
affiliates.
Southwestern Pennsylvania Area Agency on Aging, Inc.
Eastgate
8,
Supervisor, Management Information
Systems (1996-2000)
Programmer/Analyst (1993-1996)
Data Coordination Specialist (1990-1993)
Data Technician (1988-1990)
ESSENTIAL FUNCTIONS
·
Analyzed, designed, developed,
tested, and implemented the Aging Information System. Also developed a service
entry program for 14 subcontractor sites and provided verbal and written
training.
·
Supervised and instructed IT
staff as the Management Information Systems Supervisor including the agency
representative with assignment in the evaluation and acquisition of all
computer technology and key technical advisor.
·
Served as the primary liaison
with Southwestern Pennsylvania Human Services, Inc. computer staff, appropriate
subcontractor staff, and the Pennsylvania Department of Aging’s
Chief of the Division of Management Information Systems.
·
Designed, developed, implemented, and maintained The Southwestern Pennsylvania Area Agency
on Aging, Inc. (www.swpa-aaa.org) Internet Web site.
President
- Professional web design, site hosting and
promotion for small business.
- Home and business computer sales, training,
consultation, setup, and repair.
·
Designed, developed, implemented, and maintained the Pennsylvania Association of Area Agencies
on Aging Directors Internet Web site. Also developed an online computer
system for ordering agency training materials.
·
Provided
consultation to the Douglas School of
Business personnel in regards to computer systems acquisitions, hardware
issues, and Internet technology recommendations.
·
Developed and maintained the Albert Lexie
Web site for the Shoe-shine man turned philanthropist.
EDUCATION
·
Westmoreland County
Community College,
Major:
Database Management
·
Major:
Business Management - Associate Degree
·
Major:
Applied Computer Programming – Diploma
·
Major:
Communications
AWARDS AND CERTIFICATIONS
Microsoft Office User
Specialist - Microsoft Office 2000 Access certified.
Cathedral Award – 2003 and 2005
Employee Excellence
Award - 1996
HARDWARE
Windows NT/2000/2003 Server,
Citrix Server, SQL Server, Personal Computers and Laptops, DEC PDP 11/84, DEC
VAX 3100.
OPERATING
SYSTEMS
Windows
NT/2000/XP/2003, DOS (all versions), Windows 3.11/Workgroups, Windows 9X,
Windows NT 4.0, Open VMS VAX V6.1, RSTS/E V9.3.
PROGRAMMING
LANGUAGES
Access VBA, SQL,
Visual Basic 6, Magic, Dbase III+, IV, Clipper, FoxPro, Magic VMS V5.56V,
DATATRIEVE
APPLICATIONS
AND UTILITIES
Microsoft Access
97/2000/XP/2003, Office Developer, Crystal Reports, Sage Abra
Human Resources and Payroll, MIP Fund Accounting, FAS Non-Profit Asset
Accounting, Microsoft Office Access Developer Extensions, Microsoft Exchange,
Norton Corporate, Excel, Lotus 1-2-3, WordPerfect, Word, dBase, Outlook,
Microsoft FrontPage 2000, HTML, JavaScript, Eudora, Corel Xara,
Adobe PhotoShop.
RELATED COLLEGE COURSES
Advanced Microsoft
Access 2000, Visual Basic 6, Internet Programming, Multi-media Design.
SPECIALIZED TRAINING
SQL Administration,
Microsoft Access 2000/VBA, Crystal Reports, Windows NT 4.0 Administration,
Advanced Microsoft Access 97, Word 97, Magic University, Advanced dBase IV
Programming.
References furnished upon request