Contract Programmer in MS SQL Server, Oracle, Informix, MS Access, T-SQL, DTS, SSIS, Cognos, ASP, .NET, Visual Basic, C#, JAVA, JSP, Javascript, AJAX, HTML, DHTML, XML

EDUCATION:

MS Physics 
BS Mathematics, Physics

EXPERIENCE:

I have been an independent contractor for 20+ years, completing more than 100 projects in a wide variety of IT areas. Most projects involve the entire development life cycle from user requirements gathering through deployment and often into subsequent enhancements and versions. I understand the dynamic nature of any IT project and am extremely flexible when client requirements and/or client requests change.

Partial list of recent projects:

Confidential Pennsylvania 2008 - present

• Conversion of legacy data to new education management system, Jenzabar CX
• Creation of custom Informix database tables to support legacy data structures
• All aspects of database development - table design, index creation, triggers, stored procedures, ER designs, normalization
• Creation of data verification scripts to guarantee data integrity
• Extensive multi-query, drill through and bursting Cognos reporting for donations, alumni development and multi-million dollar phone program
• Cognos Framework Manager modeling of Informix database to support institutional advancement
• Enhanced reporting using Javascript tailored to the Cognos environment
• Creation of custom screens and software (C) to support ongoing applications
• Creation and customization of Perl scripts to insert and update database records
• Creation of Java programs to interface with XML based UI screens
• Creation of scripts to interface to OneCard student tracking/payment system and Harris data services
• User training of new Jenzabar software platform

Confidential 2007 - 2009

• Extensive data mining in VB and C#

Confidential Florida 2006

Creation of new website and database for a health care eLearning provider

• Conversion of existing database from MS SQL 2000 to MS SQL 2005 with extensive additions
• Original database had no foreign keys, no data integrity checking, no stored procedures
• Creation of new business access layer to access db through stored procedures
• Creation of complex stored procedures (100+ lines of code)
• Conversion of existing ASP Classic front-end website to ASP.NET 2.0 & AJAX
• Creation of Windows service (VB & C#) for import/export via automatic reading of attachments (via pop3) sent by clients

Confidential Iowa 2005

Conversion of MS Access Mutual Funds databases to MS SQL Server 2003

• Conversion of more than 5,000 MS Access 2003 databases (more than 50,000 tables) to SQL Server
• Conversion of all forms, reports and queries to support new SQL Server database
• Creation of DTS packages for daily database update
• Creation of new VB programs calling custom DTS packages
• Conversion of existing VBA and VB code (90K lines) to support new database
• Creation of test data and MS Access database/VBA code to verify data integrity
• Creation of MS SQL stored procedures
• Creation of complex SQL queries
• Import, export, VB creation of Excel spreadsheets
• Automation of the import and export of text files from worldwide data sources
• Documentation of all data sources and conversion specifications
• Extensive financial calculations
• Interface to flat file database on DEC Alpha Servers

Confidentialiety New York 2003 - 2004

Creation of help desk tracking system

• Responsible for entire project – database design, web interface, reporting, deployment and QA testing
• Conversion of existing MS Access database to MS SQL 2000
• Significant database changes (conversion of VB code to stored procedures, triggers, functions, views etc.) to duplicate existing functionality and support enhanced features
• Web based front end using ASP running under Microsoft IIS
• ASP web based reporting
• MS SQL Server 2000 back-end
• Web integration with MS Word and Excel
• Administrative back end to define users and user access to all program areas.

Confidential New York 2000 - 2005

MS Access (97, 2000, 2003) database designs and conversions including patient management, contact management, invoicing, regional chapter budgeting and accounting

• Database modeling, creation, normalization, replication, backup, stored procedure creation, security, user administration
• Multi-user network environment with locking
• Linked tables for improved network response
• Custom report generation
• Deployment to 50+ regional chapters

Conversion of MS Access databases to Oracle and MS SQL

• Complete project control from initial upsizing recommendations to final implementation and concurrent use testing
• Upsizing of MS Access databases to MS SQL and Oracle, including data conversion, creation of stored procedures and front end user access.
• Web based front end using AOLServer (TCL) and BEA Weblogic (JAVA)
• Web based reporting

Design/Maintenance of content management system

• Rich text editor support
• Custom form creation by staff
• Credit card processing support through VeriSign
• Full document revision and approval tracking
• Oracle back end - AOLServer front end

Design/Maintenance of existing corporate web sites.

• AOLServer (TCL)
• Oracle database back-end

Design of new websites

• All websites created in Java (Weblogic)
• Oracle database back-end
• XML based
• All programming, database design and layout (excluding graphic design)

Intranet based material ordering system

• Java based front and middle tiers interfaced to Oracle back end

Installation of chapter networks.

• Server installation and associated workstations
• Setup/configuration of MS Exchange
• DNS and TCP/IP configuration
• Staff training in network administration and client software

Confidential Pennsylvania 2004, 2009

Conversion of FoxPro database to MS Access 2003 and subsequent conversion to MS Access 2007.

• Database consists of clients, applications, contractors and associated payments.
• Extensive conversion of FoxPro code to VBA
• Approximately 50000 records, 40 screens, 25 reports

Creation of MS Access property database from Oracle mainframe database

• Downsizing of Oracle database to allow access in a non Oracle environment (not using Oracle client)
• Creation of all necessary forms, reports and VBA modules to support required functionality

SKILLS:

Internet

• .NET/ASP
• ASP Classic
• Java/JSP
• HTML/DHTML/DOM
• XML
• JavaScript/VBScript
• AOLServer
• MS IIS
• BEA Weblogic
• TCL, ADP
• CGI

Languages

• Java
• Visual Basic /VBA
• C, C+
• .NET (C#,VB)
• Intel Assembler
• Perl

E-Learning

• Authorware
• WebCT/Blackboard
• Jenzabar CX

Reporting

• Cognos
• Crystal Reports

Database

• MS Access, Excel
• MS SQL Server, DTS, SSIS
• Oracle, PL-SQL
• SQL Queries
• FoxPro, Dbase, Rbase
• ADO, DAO, ODBC
• Informix

Operating

• Windows

Systems

• Unix