Résumé

BRIAN BATTLES

38 New Britain Ave, Rocky Hill, CT 06067
860-707-7021
860-808-1285
E-mail  BrianBws1o@yahoo.com

            BrianB@BrianBattles.com

Download Brian’s resume in Microsoft Word (.DOC) format (updated Feb 18, 2010)

 

Available for permanent (preferred) or possible long-term contract/consulting positions
programming in Microsoft Access, Visual Basic, VBA, ASP.NET, VB.NET

Highly experienced Microsoft Certified Professional Microsoft Access developer and skilled Visual Basic/VBA/ASP/ASP.NET/VB.NET programmer. I have an extensive, professional hands-on background in Windows and Web-based business applications, database design and implementation. Mainly interested in contract work (W-2 or 1099) in New England (will consider permanent, full-time positions and opportunities in other areas, depending on compensation, etc).

 

Primary Skills

 

15+ years experience with Microsoft Access, Visual Basic, Active Server Pages (ASP), ASP.NET, VB.NET, ADO/DAO, SQL, HTML, Microsoft Excel, Microsoft Office, Microsoft Windows, Microsoft SQL Server, Crystal Reports, Microsoft FrontPage, Wise Installer. Webmaster for several firms, which run on Microsoft Advanced Server and use HTML, ASP, CSS and DHTML technologies. I manage a Microsoft Exchange Server e-mail system and internal LAN operations.

 

Experience Summary

 

Application Development: Microsoft Access, Visual Basic, etc (1994-2009): I am a full-time engineer/developer, writing advanced Microsoft Access applications for a large defense contractor. I previously worked for 12 years as a contractor/consultant, developing custom software applications for many businesses. The applications I have created have used such tools as Microsoft Access, Visual Basic, VBA, Microsoft Office, Crystal Reports, SQL Server, Oracle, and others. Technologies such as ActiveX Data Objects (ADO), Data Access Objects (DAO), Active Server Pages (ASP), HTML, Object Oriented Programming (OOP), etc. My clients have included:

 

 

Experience Summary      Highlights/Selected Project Details

 

1.        Analytical Engineer (Jul 2006-October 2009): Belcan Corp hired me as an MS Access programmer to improve/rewrite/optimize a large-scale existing mission-critical application used by 600+ Customer Support Engineers (CSEs) worldwide for Pratt & Whitney’s Military Programs & Customer Support (MPCS) department.  This sophisticated suite of applications is a combination of several separate Access MDE front-end programs, tied to Access, Oracle and other external sources as its back-end data. It consists of several dozen forms, reports and queries, with extensive Visual Basic for Applications (VBA) code. I also developed a robust new system for deploying and updating the application to all user’s local desktops enterprise-wide using MS Access, VBA and VBScript. I have received awards, bonuses and citations for outstanding achievements and exceptional performance in providing expert programming skills and services.

 

2.        Various MS Access Applications (Nov 2005-May 2006): Uniprise/UnitedHealth Group brought me in as a contract programming expert for its Strategic Accounts support team. We created several critical, complex applications to assist strategic account executives, underwriters, actuaries, etc, in time tracking, modeling scenarios for customer sales presentations, project management and several other projects that made use of advanced Access, SQL, VB/VBA, and reporting skills.

 

3.        Aggregated Stop Loss System (Sep-Oct 2005): CIGNA needed this Access application to view and enter data on its health care products claims to determine performance on a monthly or quarterly basis. The program connects to back-end data on a DB2 database, and uses extensive, complex VBA code to perform various calculations. The back-end Access data tables are centrally located on one server, and the front-end application (with all screens, reports, code, etc) was deployed to several field offices across the US on CIGNA’s network, so it had to be built robustly and with a simple interface for a variety of non-technical users.

 

4.        Multiple Project Tracking System (May-July 2005): Turbine Entertainment Inc of Westwood, MA, is a major developer of some of the world’s most popular computer games, and I was engaged to recreate an MS Access database application they had built in-house to serve as a task- and project-management program. The project involved taking two separate, similar, Access applications, cleaning up and merging the data into one new database, migrating it to a MySQL server back-end, then revising its Access front-end’s various forms and reports, and rewriting the VBA code, queries, etc, to upgrade the software to support added functionality, features and multiple project teams. I also took steps to ensure the application would be easily upgradeable in the future to deployment as an ASP.NET web application.

 

5.        Retirement Housing Selection Program (Mar-June 2005): RLS LLC of Hartford, CT, sells retirement/senior housing, and I created a web-based application for their sales representatives to use in various remote sales offices to allow residents to select a housing unit and its associated options/upgrades (ie, floor plan, furnishings, etc).  This was built as an ASP.NET application using an MS Access database as a back-end.

 

6.        Order Entry/Invoicing and Inter Office Action Request Tracking System (Jun 2004-Present): McKay Communications of Sydney, Australia, a manufacturer of two-way radio accessories (headsets, earphone, microphones, etc) opened its new North American headquarters in Connecticut, and needed custom software for creating and printing invoices, tracking inventory, sales contacts and requests for products and engineering/design changes through its main office in Sydney.

 

7.        Database Migration Project (May 2003-Mar 2004): Energy East needed to migrate data from many separate businesses to its new SAP CRM software system. This mission-critical project was under a tight deadline, and also entailed complex processes to work around and prepare legacy data and database designs. The data had to be located and converted from a wide variety of external data sources including Access, Oracle, PeopleSoft, SQL Server, Sybase, DB2, MySQL, FoxPro, Excel, text files, Unix systems and more, and contained a varied mixture of formats and datatypes that all had to be aggregated, converted and formatted to properly fit the SAP specifications.

 

8.        Sales Accounting System (Feb-Mar 2003): A complete sales and accounting application for order entry, customer and inventory maintenance, with invoicing, statements and summary reports, for Medical Laser Systems, built entirely with MS Access. This program includes amortization to allow users to enter rental transactions, specifying APR, a monthly payment schedule, monthly payment amounts, rental period and an end-of-rental buyout.

 

9.        Claims Inventory Processing (Apr-Jul 2002): An application to provide analysis of insurance claims, written for CIGNA in MS Access/VBA/Excel, that imports figures from daily Excel worksheets to use as data files in an Access database.

 

10.     Foodborne Illness Complaint System (FICS) & Right From The Start (RFTS) (Sep 2001-Apr 2002): These are MS Access applications for the State of Connecticut Dept of Public Health. One allows them to gather immediate data on potential foodborne illness outbreaks and quickly identify trends and possibly issue health warnings or deploy inspectors to investigate sources of health risks; the other is used in district office sites statewide to gather data and statistics from clients enrolled in a program for pregnant teens

 

11.     Quote Tracking (Feb-Aug 2001): I was hired to add complex, advanced ad hoc reporting capabilities to an Access application at The Hartford Insurance Group (Hartford Life Group Reinsurance) in Windsor, CT.

 

12.     Self Funded Finance (SFF) (Sep 2000-Feb 2001): The Finance department at ConnectiCare replaced an existing ad hoc Access database with this application using a Visual Basic front end with a SQL Server database, to organize and track claims and payments transactions, provide extensive custom reports, generate bills and consolidate data for export to a PeopleSoft general ledger.

 

13.     Dynamic Resource Planning and Tracking (Jul–Sep 2000): Object-oriented application that uses reusable components and ActiveX Database Objects (ADO) technology as front end to an Oracle database. It allows system administrators to plan and track full-time and outsourced personnel for Pfizer’s Pre-Clinical Research Division.

 

14.     Sales/Marketing Program Planner (1999-2000): I built this application in MS Access, with utilities in Visual Basic, to simplify creation and tracking of various product offering packages by the Vice President of Marketing and Sales and Marketing Directors at Southern New England Telecommunications (SNET)/SBC.

 

15.     Y2K Global Tracking Database (1999): This application was written in Microsoft Access and deployed across General Electric’s corporate domestic and overseas LANs, to gather, update and report information on more than 5000 of GE’s suppliers’ compliance with Year 2000 requirements.

 

16.     Total Billing and Revenue System (TBRS) (1998-1999): This Access application is used by SNET/SBC to compare sales representatives’ actual revenue attainment to annual projected objectives, and calculates their monthly payout amounts based on these comparisons and specified target amounts. The unique part of this program is that it incorporates a “rolling true-up” routine that reevaluates each payout based on all previous months’ payouts and revenues.

 

17.     Project Tracking System (1998-1999): (SNET/SBC) uses this Microsoft Access application to enter and track engineers and contractors, and to produce invoices and reports, for installation and maintenance work done by its Custom Business Group (CBG).

 

18.     Customer Request System (1997-1998): This object-oriented program is a high-visibility, mission-critical program created for Northeast Utilities to allow Clearing Desk personnel to enter, review and edit orders for new electrical service and service changes. It uses stored procedures to read and write data on multiple Sybase database servers.

 

19.     Investment Account Reporting System (1998): I was brought in to Webster Bank to create a program to automate month-end processing of an existing Access database application that merges new account information and provides a set of predefined reports.

 

20.     Loss Analysis System for Enhanced Reporting (LASER Lyte) (1998): Written in MS Access, this high-visibility, mission-critical database program was created for The Hartford Insurance Group to distribute to field representatives, brokers and major corporate policyholders to allow claims personnel to download data from the home office Oracle database and view/print reports at the user's site.

 

21.     ISO Training Analysis (1997): This application was created for the quality assurance (QA) department of Photronics, a large international ISO-certified manufacturing company, to maintain records and provide various reports, tracking employees and various specialized QA certification training courses they have completed, with frequent updates due to specification revisions, changes in terminology, etc.

 

22.     Investment Banking Reporting System (1997): I created this application in MS Access to provide a variety of reports on clients’ investment and trust fund account status at Investor’s Bank and Trust in downtown Boston. Reports included a variety of tables, charts and graphs.

PREVIOUS EXPERIENCE

 

1989-1995: Features Editor, QST Magazine, ARRL National Headquarters, Newington, CT

Wrote, edited and researched technical and feature articles, columns, book reviews and new product reviews.

 

1986-1989: Audio Production Manager, CareerTrack, Boulder, CO

Handled production planning and design, scheduling, writing, recording, editing, mixing, voice-overs and preparing direct-mail advertising copy for business training and personal improvement audiocassette programs. I was also author/presenter/producer of How to Listen Powerfully, which has sold more than 36,000 copies worldwide.

 

1985-1986: Technology and Marketing Manager, Sun Hill Corp, Manchester, CT

Handled the acquisition, installation and training for the company's office computer automation system to handle its accounting, inventory and customer maintenance operation. I helped organize this start-up business (manufacturing a portable liquid-nitrogen flash-freezing system used in food services, industry, scientific and academic applications), drafted and presented a successful business plan, wrote and designed trade magazine advertisements, brochures and marketing materials, and attended trade shows and industry meetings as a product technical specialist and market researcher.

 

1979-1983: Production Director, Announcer, WCCC, WBAB, WAQY, WXLS, WINY, WHUS

Hosted on-air radio programs and made many public appearances on behalf of stations and sponsors, and participated in recreational and charitable events. I wrote advertising copy, produced commercials and performed radio and TV voice-overs for stations and outside agencies and advertising. My commercials won numerous awards and honors, including a Clio Award Finalist, Big Apple Award, BOLI (Best On Long Island) Award, New York Radio Festival Award.

 

1983 to Present: Writer/Columnist

For more than 15 years I’ve written regular columns and articles on marketing, advertising design, copy writing, technical production, and other topics in television and radio broadcasting.

 

COMMUNITY AND SERVICE ORGANIZATIONS

 

1994-1995: Deputy Commissioner, Special Olympics World Games

Served as Deputy Commissioner of Amateur Radio Operations for the 1995 Special Olympics World Summer Games in New Haven, Connecticut.

 

1991-Present: Communication Manager, Epilepsy Foundation of Connecticut

Serve as a volunteer with the Foundation's Board of Directors and with local Amateur Radio clubs and individuals to arrange amateur and commercial radio communication coverage for annual Mud Volleyball Tournament event officials, game operations staff, volunteers, public safety, parking and crowd management.

 

1990 to Present: Middlesex Amateur Radio Society/Connecticut Amateur Radio Emergency Service

As an active member of MARS/CARES, a volunteer service organization, I served as President for two years, and help organize public service communication support for community events, emergencies, disaster drills, fundraising projects, media publicity, public demonstrations and FCC license training classes. I coordinate volunteer communication support for annual March of Dimes WalkAmerica and other events.

 

1976 to Present:

Member of the American Radio Relay League (ARRL), Connecticut Digital Radio Association (CDRA), Tucson Amateur Packet Radio Corp (TAPR), North East Digital Association (NEDA), the New England TCP/IP Association (NETCPA), the Audio Engineering Society (AES), the Society of Broadcast Engineers (SBE), the International Television Association (ITVA), and the Masons (AF&AM) Warren Lodge #51.

 

 

*** END ***