WORK EXPERIENCE:

Confidential
Hodgkins, IL January 2001 to July 2009 Sr. Development Analyst / DBA
I am a Sr. Programmer / Analyst, and the SQL Database Administrator for this company. 
As Sr. Development Analyst, I have done complete life-cycle development for several important financial systems and significant modifications to others The Customer A/R Statements system which downloads the A/R data from the IDS System and creates the weekly A/R Statements. This A/R data is then used to update the Net Sales Reporting System. The Net Sales Reporting system is the main sales reporting system which is used for period sales reports. The Net Sales Reporting data is used for the Rebate System. The Rebate System is used to process the yearly member stores rebates. The Miscellaneous Billing Data Entry System which is used for entering any credits or purchases that can not be handled by the IDS System. A retail support tracking system called Store Visits. The Store History Reporting System which is used for historical invoice reporting. The Loan Accounting System which is used track and bill the company loans to the member stores. The Accounts Payable Reporting System which is used for quick indexed lookups of A/P information. I also developed a general reporting program and some stand alone Crystal Reports for specific user requests.
As the SQL Database Administrator, I created and maintained production SQL Databases, SQL Scheduled Jobs and DTS packages. I also did some of the initial testing for the SQL 2005 Server conversion project. And did some testing of different versions of Linux as a possible database server platform.

Confidential.
Chicago, IL March 1998 to January 2001 Sr. Systems Analyst
I acted as the MIS Manager, Network Administrator, Programmer / Analyst, and PC Specialist for this company. I made most of the decisions regarding the company network, servers, PC’s and software.
As the Network Administrator, I designed and setup the entire company network. Our main server is a Dell PE 4300 using a RAID 50 configuration running NT Server 4.0. There was also a Firewall Server running Checkpoint Firewall-1 and an Internet Mail Server running Sendmail. All the PC’s were Dell Intel-based systems running MS Windows 95, 98, 2000 or NT Workstation. The entire network, including the printers, was Fast Ethernet (100Base-T) using the TCP/IP network protocol.
As the Programmer / Analyst, I was responsible for developing and maintaining the main Risk Systems and the five other systems that either feed data into Risk or did other reporting from Risk. All these systems were developed in MS FoxPro 2.6 for Windows. I developed other internal systems written in MS Visual Basic and SQL Server. The first system was the SGAI Control System. This system will give the users one entry point to access the rest of the SGAI systems. It will also provide tracking and reminders for anything that had to done on a regular schedule. The main system for SGAI was the AMS System (Analytical Management System) for analyzing CTA (Certified Trade Advisor) performance. Another system was the Subscription & Redemption System. This was a database system for tracking the subscriptions and redemptions entered for a given fund.
As the PC Specialist, I setup and maintain the servers, PC’s and printers. This included installing the operating systems, standard desktop software, all utility software (backup, anti-virus, communications, etc.) and any user specific software.

Chicago, IL August 1995 to March 1998 Sr. Systems Analyst
My main job function was to work as the Lead Programmer / Analyst with an outside consulting firm in developing the company’s Material Purchase and Scale Systems that were integrated into the SBT Accounting System. This included a C++ program used to read the scale and automatically enter data into the MP Scale program. I also converted all the internally developed FoxBASE systems to FoxPro for integration into SBT.
I also worked as the Network Administrator and Hardware Technician. The main systems were an ALR SMP running SCO UNIX, a Windows NT 3.51 custom server running the Payroll and HR systems, and the MIS Development Server running NT 4.0 and MS Visual Source Safe for program version control and development. I provided Technical Support which included building and maintaining Intel-based PC systems for various applications, answering most of the hardware problems, software problems, and most computer related questions in general.

Chicago, IL September 1993 to August 1995 PC Specialist
Developed parts of the Point-Of-Sale System used by over 200 individual stores nation wide. Worked on the roll-out team for the new POS system. Lead Analyst for the Corporate Controller System which handled all the daily POS data downloaded for the individual stores through a UNIX server to an IBM 3090 mainframe. Wrote data entry programs, report programs, and other programs for various departments using C/C++, MS Access, or Progress RDMS. I worked as the UNIX Administrator, setting up users, printers, etc. and monitoring the daily POS data transfers. I also did the initial development for the EDI program using EDI Edge to transfer data between Florsheim and Sears.

Chicago, IL August 1989 to September 1993 Sr. Programmer / Analyst
Developed new pen-based Car Inspector System for Grid System computers to replace the older NDC based used at the major service centers. This systems handled inbound inspections of railroad cars, builds repair estimates, and transferred it’s data directly to an AS/400.
Developed two pen-based applications for Grid Systems computers used for collecting labor reporting data from remote repair facilities and car condition data from remote storage sites. These systems communicated with a UNIX PC and in turn to an AS/400.
Supported all PC systems used in the major service centers, mini / mobile service centers, car storage sites, and the NDC based Car Inspector System. Provided technical and general support for all the PC based hardware and software related questions.

Oak Brook, IL May 1988 to August 1989 Contract Programmer / Consultant
Contract programming using a variety of development tools and languages on various platforms. Worked on A/P, A/R, and Inventory Systems on an MAI Basic IV. Converted Pascal programs to C for PC-based system. Tested custom software packages for other software developers.

Confidential.
Lisle, IL August 1985 to May 1988 Programmer / Analyst
Developed and maintained parts of a PC-based, commercial lines insurance rating system. Developed and maintained internal tracking systems. Provided general PC and network technical support.

Oak Lawn, IL June 1984 to June 1985 Software Engineer
Developed user interface for the PC-based, real-time data collection system in Turbo Pascal and Micro Assembler (MASM) for the corrugated container industry. System could monitor up to 24 different machines at one time from a single PC.

Computer Systems:

• Dell PowerEdge Servers
• ALR Revolution SMP
• AST Manhattan SMP
• MAI Basic IV
• IBM AS/400
• IBM 3090
• Dell Intel-based PC’s
• IBM PS/2 PC
• Compaq Intel-based PC
• Custom Intel-based Servers & PC’s
• PictureTel TeamStation
• Wyse 50, 60 Terminals

Operating Systems & Network Software:

• Windows 2.x, 3.x, 95, 98, 2000
• Windows Server 2000, 2003
• Windows NT 3.51, 4.0
• Windows NT Server 3.51, 4.0
• SCO UNIX 3.2.4.2, 3.4.5.0
• Novell NetWare 2.x, 3.x, 4.x
• MS Exchange Server
• MS-DOS 2.x, 3.x, 5.x, 6.x
• ArcServe & NovaStor Backup
• Checkpoint Firewall-1
• Sendmail NT 8.x

Network Hardware:

• 3Com Hubs, Switches
• Cisco 3600 Router
• ADC Kentrox Router
• Allied-Telesyn Hub
• 3Com & Intel 10/100 NIC
• Addtran Modems

Peripherals:

• HP LaserJet Printers
• HP DeskJet Printers
• HP Scanjet Scanners
• Various Modems
• Various Dot Printers
• Iomega Zip Drives
• Pinnacle CDR Drive
• Various Backup Drives

Development Software:

• Visual Studio 5.x, 6.x, 2002.Net
• Visual Basic 6.x, 2003.Net
• SQL Server 7, 2000, 2005
• SQL ActiveX VB Script
• MS FoxPro for DOS 2.x
• MS FoxPro 2.6 UNIX
• MS FoxPro for Windows 2.x
• MS FoxBASE 1.x UNIX
• MS Access 2.x, 7.x
• Turbo C/C++ 2.x, 3.x, 4.x
• Turbo Pascal 2.x, 3.x, 4.x
• MS C/C++ 7.0
• SCO UNIX C
• Progress 6.x, 7.x RDMS
• MS Quick BASIC 4.x
• MS Business BASIC 1.0
• MAI Basic IV BASIC
• MS Macro Assembler

Desktop Software:

• MS Office 4.x, 95, 97, 2000, 2003
• Lotus SmartSuite 96, 97
• McAfee Anti-Virus 3.x, 4.x
• Norton Utilities & Anti-Virus
• Adobe Acrobat 3.x, 4.x
• Visio 5.x

EDUCATION:

• MS-803 Windows NT Server Network Administration
• MS-922 Windows NT Server Core Technologies
• MS-1013 Visual Basic 6 Development w/ SQL Server