SUMMARY:

• A technologist with 10 years of professional experience and continuous progression due to exceptional performance. Commended for his business savvy and ability to effectively leverage technology to meet and exceed business objectives. Excels in a small to mid - sized work environment where the opportunity to make a positive, measureable impact is present.
• Over 7 years experience setting up, administering, troubleshooting, and developing Microsoft SQL Server 2000 and 2005
• More than 10 years experience setting up, administering, troubleshooting Windows Servers (NT, 2000, 2003)
• Programming experience: TSQL: 7 years, VB: 8 years, ASP: 8 years, ASP.NET: 1.5 years, MS Access: 5 years
• Exceptionally strong written and verbal communication skills. Highly personable and capable of working with all levels in an organization Proficient in solving problems and implementing solutions under tight deadlines.

PROFESSIONAL EXPERIENCE:

Confidential - Southfield, MI

SQL Server DBA/Developer

• Setup, administered, and developed company's mission critical 1 TB SQL Server database
• Designed Stored Procedures, SSIS and DTS packages to automate monthly importing of customer data (consisting of health insurance claims (ICD9 and CPT codes) for over 100 different data sets in all kinds of formats - pipe delimited, XML, Excel, etc
• Automated monthly data exports using SSIS and DTS packages for client usage
• Developed TSQL queries and Stored Procedures to report on and manage the company’s data
• Redesigned and programmed company’s MS Access front end application, including reports, forms, queries, linked-tables, and security
• Designed and developed company’s customer relationship management tool in ASP.NET with tight integration to company’s ASP based Intranet
• Programmed custom VB6 applications to monitor equipment and log data
• Performed ongoing database tuning: Designed and implemented table Indexes to greatly improve performance of front-end application and reports
• Using data analysis, designed several company critical reports allowing management to monitor revenue and productivity real-time
• Designed, developed, and implemented real-time web-based portal (Intranet) to monitor and manage business at all levels including:
• Productivity (hours worked, time spent on phone, faxes sent, files worked)
• Call center metrics (abandon rate, time to answer, calls taken, time on phone)
• Revenue, broken down by day, month, year, all time, FTE
• Designed automated outbound faxing system, eliminating 98% faxes sent through manual paper fax
• Migrated company from POP3 Mail Service to in-house MS Exchange 2003 with Outlook Web Access and Full-text Indexing
• Identified a need and spearheaded development of a secure customer Extranet web site allowing clients real time access to their case data

Confidential - Taylor, MI

Systems Administrator

• Successfully managed a $250,000 project to upgrade Atlas Oil's entire computing infrastructure
• Upgraded a Windows NT 4-based network to Windows 2000 Advanced Server
• Setup and configured Active Directory including related DNS, DHCP and WINS services
• Successfully migrated an Exchange 5.5 server to a faster, more robust server utilizing Exchange 2000
• Converted a mixture of Windows 95 and 98 clients to Windows 2000 terminal server
• Upgraded and secured Atlas's Firewall and Virtual Private Network (VPN) with a Cisco PIX firewall enabling users to work efficiently in remote branch offices or at home
• Installed and configured Rightfax (electronic faxing service) to meet the company's high volume faxing needs
• Assisted in upgrading Atlas's IBM AIX UNIX server running Informix and Factor (industry specific ERP). This upgrade included both new hardware and a version upgrade of AIX and Informix.
• Performed database optimization to further increase performance. Provided maintenance and troubleshooting of related services including VSI-Fax (Unix-based faxing service)
• Developed Visual Basic (VB6) applications to collect and manage company information
• Developed reports utilizing Excel, Active Server Pages (ASP), and Crystal Reports.

Confidential - Troy, MI

Systems Administrator

• Built the network from the ground up utilizing: four NT servers; two T1 Internet connections; Microsoft Exchange 5.5; and Microsoft Internet Security and Acceleration Server (ISA). This network grew to include an Oracle database application that managed the company's most critical information
• Setup and administered Microsoft SQL Server 2000 for real-time reporting and fast searching of resumes
• Developed several applications using Active Server Pages (ASP) and Visual Basic (VB) to manage the company's human resource information and other systems as needed
• Connected to a remote office utilizing a high-speed WAN connection and Terminal Services
• Provided proactive solutions for business activities and computing utilizing web based reports and applications in ASP and VB, including a timesheet application and an employee information management system

Confidential

Interim Computer Facilities Administrator

• Administered a 100-user Windows NT domain including primary and backup domain controllers; file, print and web servers
• Managed daily operations of 3 computer labs, including supervision of 10 staff and support for 100 PCs
• Network administration of a TCP/IP - 10/100baseT and 10base2 network
• Developed several web-database applications in Cold Fusion
• Supported the computing needs of the School of Business Administration's faculty and staff
• Troubleshot and upgraded the network and desktop PCs
• Assisted the School of Business Administration in their computing needs
• Installed and maintained hardware and software on all of the school's computers