SUMMARY:

I have worked primarily as a database developer utilizing Microsoft SQL Server products for over 20 years. I consider myself an expert at programming with MS T - SQL. I have utilized SSRS and SSIS, as well as most MS Office products.

SKILLS:

Languages and Software: MS Transact-SQL, Visual Studio, TFS, MS SSRS, MS SSIS, C#, MS Office Suite, DOS BATCH. Previously used MS QBASIC, PICK BASIC, C++, Crystal Reports, Cognos Impromptu and PowerPlay, Fortran, RPG, COBOL, COBOL CICS, Pascal.

Operating Systems: Windows (3.1, 95/98, NT, XP, 2000, Vista, 7, 10), PICK, Novell, UNIX.

EXPERIENCE:

Confidential, Elk Grove Village, IL

Database Administrator

Responsibilities:

• I worked on two netFORUM software upgrades, which were very complex due to the massive volume of customizations of the baseline product.
• As part of one of the upgrades, I rewrote our membership dues billing programming with all its intricacies, saving the company well over $200,000.
• Using SSIS and SSRS, I automated many manual processes.
• I wrote and implemented a process that updates all US and Canadian addresses to get certification for having clean data, which reduces the postal costs for bulk mailings.
• Beginning in early 2018 we switched to an Agile Scrum methodology for our software development.
• Having worked with most of the departments within the organization, and learning their processes, I have been able to anticipate their needs, and have on many occasions delivered solutions that exceeded their expectations, saving the organization hundreds of staff hours of work.
• I have written hundreds of stored procedures and scripts and modified hundreds more for performance improvements; for reports, data extractions, ensuring data integrity, archiving, and to simplify staff day-to-day tasks.

Assistant Database Administrator

Confidential

Responsibilities:

• I collaborated with the DBA to perform system maintenance tasks and some database development work.
• I was assigned an increasing amount of development work, and ultimately no longer had the time to perform any DBA duties.
• I was part of a team that migrated our main database, an association management system, from ABLAZE to netFORUM.
• I wrote most of the data conversion scripts for this migration.
• I designed and constructed several databases for web-based applications.
• I implemented multiple netFORUM software customizations based on user requirements.
• I continued to improve my MS T-SQL, Reporting Services, and Integration Services skills.

Senior Programmer/Analyst

Confidential

Responsibilities:

• I worked closely with the Database Administrator with system level issues that arose.
• I informed our DBA of any data integrity issues that I discovered and write routines to repair the bad data.
• When writing or modifying SQL Stored Procedures, I tuned them for performance and efficiency.
• I improved our main dues billing program, bringing its run time down from 30 hours, to 20 minutes.
• I developed and tested new and modified reports for our ABLAZE system, utilizing SQL Stored Procedures and Crystal Reports.
• I was ultimately responsible for guaranteeing that the SQL Stored Procedures written by any of our developers were returning data accurately, and that the Crystal Reports were displaying the data to the users' specifications.
• I was also the system administrator for the HP-9000-K210 computer system, running HP-UX UNIX 11.0 and Ultimate PICK operating systems.
• I wrote and ran routines on the PICK system that extracted all the data, about 7 Gigabytes, for conversion into our ABLAZE system.

Information Analyst/Programmer

Confidential

Responsibilities:

• I was the system administrator for the HP-9000-H40 computer system, running HP-UX UNIX 9.0 and Ultimate PICK operating systems.
• I was responsible for monitoring and controlling system resources and processes and adjusting programs and procedures as necessary.
• I assisted the users in determining their programming requirements and trained them to do many tasks themselves.
• I wrote programs for new applications in PICK BASIC, FoxPro 2.5, and QBASIC, as well as modifying and maintaining existing programs.

Education Computer Data Base Administrator

Confidential

Responsibilities:

• I was responsible for training the fifty staff members within the Department of Education in computer usage.
• I generated programs to produce reports as necessary, utilizing the Honeywell 7000 computer with an Ultimate PICK operating system, and IBM compatible personal computers.
• Due to my advanced skills, I became a valuable resource to the Computer Services department. I developed a database and spreadsheet system used for the departments' budgeting process. I was also responsible for creating slides, on an IBM compatible computer, used in presentations by many doctors affiliated with the Academy.
• I had designed and implemented a data base entry and retrieval system consisting of over 1,200 slides that I created.

Confidential, Bethesda, MD

Teaching/Research Associate

Responsibilities:

• I collected, coded and entered data for research projects using the National Institute of Health IBM 370 WYLBUR system, the University’s VAX/VMS, and IBM-AT compatibles.
• I have written programs in SAS and BASIC, to analyze the findings and prepare the results for presentation.
• I have also co-authored several papers describing our outcomes of the research.