Résumé
BRIAN BATTLES
38 New Britain Ave, Rocky Hill, CT 06067
860-707-7021
860-808-1285
E-mail BrianBws1o@yahoo.com
Download
Brian's resume in Microsoft Word (.DOC) format
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:
|
Uniprise/UnitedHealth Group |
Vigiroda Products |
|
RLS LLC |
Turbine Entertainment Software Inc |
|
McKay Communications |
Energy East (Connecticut Natural Gas/Southern
Connecticut Gas) |
|
Fun-Time Inflatables |
Medical Laser Systems |
|
CIGNA |
C&M Telephone |
|
State of Connecticut |
The Hartford Insurance Group |
|
ConnectiCare |
Pfizer |
|
SBC/SNET |
GE |
|
Northeast Utilities |
Webster Bank |
|
Photronics |
Imaging Solutions Inc |
|
Investor’s Bank & Trust |
St Mary’s Hospital |
|
Digital Equipment Corp |
Boehringer-Mannheim Corp (BMC) |
|
Deloitte & Touche LLP |
Dictaphone Corp |
|
Rolodex Corp |
Aetna Life Insurance Company |
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 ***