SUMMARY

• Talented and accomplished Programmer/Developer specializing in creating database applications in Microsoft Access, VB.net, and VB6 against
• SQL Server and other databases, and also creating software tools for Microsoft Office suite and other Visual Basic related technologies
• Technical proficiency in technologies described herein for Rapid Application Development.
• Proficient in the creation and maintenance of relational databases, and front - end applications.
• Strong communication skills leading to productive interaction with co-workers and customers.
• Demonstrated willingness to work beyond expectations in meeting corporate objectives.
• Superb supplier evaluation/validation, purchasing, and vendor relations/negotiation skills.
• Military experience, providing exceptional leadership, team building, and managerial skills.

TECHNICAL SKILLS

• Salesforce
• ASP.NET
• Excel VBA
• Outlook VBA
• T-SQL / Access SQL
• Visual Basic 6.0
• VB.NET
• Javascript
• SQL Server 2005/2008
• Word VBA ASP
• Access VBA

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

Salesforce / SQL Server / SSIS / MS Access / MS Excel

Responsibilities:

• Provide programming support for Confidential in the areas of Salesforce / SQL Server 2008 / MS Access / MS Excel with particular focus on the integration of SQL Server and Salesforce.
• Administration of Salesforce instance for Confidential with particular focus on the integration of Salesforce with SQL Server 2008 using DBAmp connector (and associated stored procedures).Certified Salesforce Administrator.
• Maintenance of SQL Server 2008 instance to include the creation of stored procedures, views, backups and database restorations.
• Desktop development of applications in both MS Access and MS Excel -- generally manipulating and passing data to and from SQL Server and Salesforce.
• Creation/maintenance of SSIS (SQL Server Integration Services) Jobs in support of data sent to and received from various external organizations and trading partners.
• During this time, developed the first version of the ASP.NET website that is currently Confidential . Created numerous desktop apps for the integration of data with Salesforce and many other projects.

Confidential, Baltimore, MD

Contractor / MS Word 2007 / MS Access 2007

Responsibilities:

• Provide development and maintenance for the Microsoft Word template and autotext document system used by the Office of Disability Adjudication and Review (ODAR) in support of SSA Hearing Offices around the U.S. Source code for this project is managed by MKS Integrity and the job requires a Public Trust security clearance.

Confidential, New York

Database Programmer III and SQL Server 2005 / MS Access 2007 / VB.NET / VB6 / ASP.NET

Responsibilities:

• Sole developer for the WVT (Water Vapor Transfer) Database (Access to SQL Server backend) involving numerous data input forms, queries and reports.
• Sole Programmer and SQL Server DBA for the Battery Build Database (Access front end/SQL Server 2005 backend) consisting of more than 71 tables and over 50 forms, reports and modules, for tracking the build and repair of battery stacks for General Motors prototype electric vehicles.
• Rewrote the Material Requirements Planning (MRP) database with an Access 2007 front-end and an Access 2007/SQL Server 2005 backend for the acquisition of fuel cell materials (including purchase orders, receipt, distribution within the facility, and reusability of parts).
• Wrote a system in VB.NET for tracking process and inventory for iMEA group managing information in SQL Server 2005 backend tables.
• Created and modified tables, views, stored procedures, functions, triggers and indexes in the SQL Server 2005 databases used by the Programming Development team. Our team works directly with the SQL Server 2005 server (serving as both DBA and Developer).
• Migrated numerous back-end databases from Access to SQL Server 2005, as well as creating a synchronization technique to ensure that Users who continued to use the Access front-end always had their own copy (eliminating the problem of multi-user database corruption in Access).
• Revised and maintained the database used in the Test and Development of Fuel Cell stacks -- containing over 40 forms and several hundred queries. Migrated this database from an Access 2003 backend to a SQL Server 2005 backend. Proficient in the use and deployment of SQL Server 2005. Also rewrote major portions of the system to achieve performance gains and was very successful in reducing the response times of many forms.
• Utilize SQL, Access forms (VBA), and Visual Basic to tie front end systems (both desktop and online via ASP.NET) to Access 2003 and SQL Server 2005 backend databases.
• Utilized GSNet graphic design package (together with Visual Studio 2005 program development platform) for the creation of online charts to display database information within ASP.NET applications.
• Also proficient with Microsoft Office 2007 -- specifically the creation and modification of ribbons within the XML control files (replacing the former toolbars).

Confidential, Rochester, New York

Developer / Programmer - VB.NET / VB6 / VBA / Microsoft Office

Responsibilities:

• Create online database systems utilizing ASP (against Access databases) and ASP.NET (against SQL Server databases) employed within Thomson Corporation.
• Create Word & Excel macros and templates, as well as, Access and online databases. Many applications involving automation across programs, and widely disseminated across the organization.
• Utilize FileMaker Pro, PERL, FSR, SQL, and SQL Server to create a variety of online databases.
• Design document tag systems for labeling and tracking documents imported from external sources.
• Develop databases to manage and retrieve information related to legal research and publications.

Confidential, Rochester, New York

Legal Research Specialist / Word Basic Programmer

Responsibilities:

• Created many Microsoft Word macros and templates, which would later be converted into Word Basic (with the advent of Word 97); and from there transitioned into VB6 (very similar to VBA).
• Completed numerous projects to create templates, databases, and tools that have led to substantial savings in man-hours necessary to complete routine tasks. These have included:
• Created and released "Phoenix Toolkit," an MS Word template for editorial team use in working with the different document coding structures. This toolkit selected for demonstration at 2004 Tech Summit, held at corporate headquarters in Eagan, MN. It continues to be the primary non-XML editor tool used for Analytical products in the organization with multiple releases each year.
• Collaborated with Senior Database Engineer to convert PAX Conversion database from Access 2000 to Access Project with SQL Server 2000 back-end. This conversion resulted in improved stability in a multi-user environment. Continues to serve several hundred customers and provides a key resource in tracking changes for the conversion of publications between technologies.
• Developed process for reading and transferring tag-based information from multiple Word documents into an Excel spreadsheet.
• Created and rolled out VB file-splitting program for dividing large files, based on tags. Also created VB program to extract key numbers from large file sent from corporate headquarters, which allowed rebuilding of infobase with current changes.
• Rewrote multi-step processes involving combination of PERL scripts and Word macros into a single VB program that performs the functions in a single step.
• Long-time PC hobbyist and technician from early 1980’s with a wide-ranging experience encompassing DOS and older mainframe technologies (JCL / JES2 / CICS / ADABAS-Natural).