OBJECTIVE/Overview Seeking a lead programmer analyst or project lead position. I have been developing industrial strength applications primarily utilizing the Microsoft suite of development tools for over 13 years. I have done some open source development using Zope, Python and MySQL. I have significant experience in the financial, heath care and insurance industries. Additionally I am an expert in MS Access, SQL Server, T-SQL , MS Access SQL and MS Office integration and automation. EXPERIENCE

• Contract Programmer remote - Confidential Responsible for enhancements and bug fixes for MS Access 2010 application for independent insurance agents. Also added QuickBooks integration module using ODBC and QODBC driver from QuickBooks.
• Contract Programmer remote - Confidential Upgraded earlier versions of MS Access databases to MS Access 2013. Added features, created and enhanced reports.
• Senior Programmer - Confidential Short term contract supporting website fixes and enhancements for various clients including JAMA and McGraw Hill. Was assigned to team to debug existing pages and to add new features. Team used Agile methodology. Work was broken into two week sprints. Performed the following tasks:
• Updated or created new web pages using HTML, CSS, XML, XLST, JavaScript through Visual Studio 2008
• Updated page logic using ASP.Net with VB.Net or C . Retrieved and manipulated data from SQL Server 2005 and 2008 databases using ADO.Net and LINQ. A majority of the sites were written in VB.Net
• Created new websites using IIS
• Created or edited stored procedures, views and triggers in SQL Server 2005 and 2008 databases. Backed up and created new databases as needed.
• Used Subversion as source control
• All websites employed n-tiered architecture and shared common controls
• Began development of new website using MVC architecture
• Designed and wrote new company's forecasting tool using MS Access 2010. Created all input screens and interface for selecting reports and using associated parameters.
• Lead Programmer - Confidential Short term contract creating an Access 2010 multi-user application that tracks cell tower locations, construction and maintenance. Application is critical to the engineering division as this region has incorporated three more states into its jurisdiction.
• The original application was written in MS Excel but had to be expanded to include numerous reports that could be viewed and manipulated by many users with varying degrees of security access to certain features. This was a highly successful and visible program in the company and future consideration is being determined to move the backend to SQL Server.

Lead Developer

Confidential

• Maintain and debug existing code and develop new code for multi-threaded, windows base, currency trading application written in C with SQL Express backend.
• Transferred new and updated executables to client machines via WS FTP
• Updated website used to collect data from the windows application to invoice customers. Website was original designed and edited with Dreamweaver but later converted to Visual Studio using Visual Studio 2008 using VB.Net as the programming language.
• All reporting was done using Crystal Reports.

Developer

Confidential

• Main responsibility was to maintain, debug and create new code commission module written in C .
• Wrote and modified numerous stored procedures, views and functions in SQL Server

Created or modified reports using Crystal Reports IX

Lead Programmer

Confidential

• Create, update, and maintain asp pages on company's health risk assessment web application using Classic Asp, HTML, CSS, SQL Server, JavaScript and assorted custom DLLs.
• Write a variety of SSIS packages to manipulate and moved data from flat files into SQL Server database.
• Create a variety of utilities using VB.Net to move files, create directories and manipulate data.
• Create numerous MS Access applications that import, manipulate and export data to SQL Server backend from flat files and other data sources to include XML.
• Create master data mapping application using MS Access with VBA
• Gather third party customer requirements, write design specs and create and/or enhance MS Access applications based on those requirements.
• Write numerous SSIS and DTS packages to move and manipulate data.
• Write stored procedures and triggers and also enhance existing SQL Server objects to include tables and views.
• Created quarterly reports for major clients such as Chevron using T-SQL and Excel

Lead Developer

Confidential

• Took over development of the company's flagship application, a mortgage generation program which is sold to banking and financial institutions. Program is written in MS Access 2000 and was simultaneously being re-written in C
• Recoded key modules consisting of well over 50,000 lines of VBA code. Coded all changes for current releases to include auxiliary program written in VB6.
• Prepared redistributable .exe file using InstallShield.
• Enhanced program to read XML data from remote site and update local tables using the web browser ocx control.
• Programmed all changes for current releases to include auxiliary program written in VB6, VB.Net and C .
• Reviewed over 50,000 lines of VBA code written over a period of 5 years by several different programmers and streamlined and enhanced structure for performance, better functionality and readability.
• Created routines to update local database from XML data residing on third party website.

Lead Developer

Confidential

• Created and enhanced Forms and Reports using MS Access for an existing revenue tracking database. Application was accessed by over 250 users in 5 states.
• Created or enhanced over 50 different reports.
• Wrote Export routines from MS Access to Excel using VBA and Excel Object Model and XML and XLST.
• Provided extensive project documentation and customer support.
• Created and enhanced existing export routines to move data into various MS Office applications for reporting and display.

Lead Developer

Confidential

• Converted VB6/MS Access application to C /SQL Server web application.
• Wrote Fault tracking web application using Zope, Python and JavaScript and MySql
• Wrote Fault tracking application using VB6 and MS Access. Faults were generated by entertainment units aboard various types of aircraft and captured by Unix box onboard the craft. Raw data was sent to me, converted, modified and prepared for reporting. Very high profile project in the company as contracts were based on the percentage of faults reporting in the units.
• Reviewed and rewrote many lines of code for continuity, performance and enhanced functionality.
• Created numerous reports using T-SQL and Excel

Programmer/Analyst

Confidential

• Help write an estimating and quotation software application for Stevens Air Transport in Torrance California using MS Access 97 with SQL Server backend. Stevens Air negotiates for shipping space on various airlines and resells it to its clients.
• Create quotation package using VB6 that the salespeople loaded onto their laptops and used as a negotiating tool when in front of a potential client.
• Skills
• MS ACCESS 97 2007
• MS Excel 1997-2007
• VBA
• Excel/Office Automation
• Visual Basic 1-6
• VB.Net
• C
• Zope
• Python
• Visual Studio/.Net
• Microsoft Visual Web Developer 2005/2008
• ASP.Net
• Classic ASP
• AJAX
• CSS
• HTML/XHTML
• Java
• JavaScript
• XML/XSL
• SQL Server
• SSIS
• DTS
• T-SQL
• MySQL
• Windows Vista/XP
• InstallShield
• Adobe Acrobat Professional
• Macromedia Fireworks
• MapPoint Integration
• Visual Source Safe
• Subversion