** **** ******

PO Box *** Arthur Evans

413-***-**** Cell

Montague, MA 01351

413-***-**** Home

____________________________________________________________________________

________________________________

OBJECTIVE

. Continue to utilize and leverage skills from over twenty

years experience as a computer software developer,

specializing in business analysis, software design and

development of custom database systems and reports in

all phases of the software development lifecycle.

SKILLS

Database / Programming Summary

. Access 2.0 to 2007, VBA

. Crystal Reports 6.0 thru X, XI and 2008; SSRS - SQL

Reporting

. Microsoft SQL Server 7.0, 2000 and 2005, SSIS

. Other Databases used include Clarion, Clipper, Dbase,

Filemaker, FoxPro 2.5-6.0, Q&A, MySQL, Oracle, and

others

. Visual Basic 3.0 to 6.0

. Visual Studio 2003 and 2005 - VB.Net and ASP.Net

EXPERIENCE

March 2010 to Present The Mentor Network, Boston, MA.

Programmer/Analyst

. Develop new reports and maintain existing reports (Aging

by Guarantor, Background Check Expiration, Client

Ledger, Delaware Invoice, Discharge Outcomes, Employee

Productivity, Employment Documentation Expiration,

Follow up Notes, Leave Report Billing Detail, Payment

Register, Registry Setting Exceptions, TBI Fund Invoice,

etc.) in Crystal Reports XI accessing data in a Cache

database for an Avatar Practitioner Maintenance program.

. Support Biscom application and develop reports in SSRS

(Number of Transactions Received, Invoice Statistics,

New Hires etc.). Also develop SSIS application to port

data from Oracle export files to SQL Server.

. Develop Avatar screen interface options,.

November 2009 to Dave's Soda and Pet Food City, Agawam, MA.

Marchy 2010 Consultant

. Develop new reports (Sales History, Drop Order, Customer

Retention, etc.) in

Crystal Reports 10 accessing data in a Counterpoint 7

Point of Sale system.

July to United Technology Research Center, East Hartford,

CT.

October 2009 Consultant

. Develop new reports in Crystal Reports 2008 for

Maintenance and Repair of Commercial and Military jet

engines at Cheshire Connecticut and Singapore plants

based on legacy VBA.

. Reports utilize an Oracle datasource.

March 2009 to Pratt & Whitney, East Hartford, CT

July 2009 Consultant

. Provide analysis, upgrade and enhancements to CASPR

(Contract Accounting Support Program), a database system

which tracks forecasts and actual FIA (Fleet

Introductory Alliance) and commission payments on Pratt

& Whitney's engines and aircrafts, developed in Access

2003.

. Modified to calculate extended sales and perform monthly

Sales and FIA Cap escalations and generate new reports.

. Provided full documentation to comply with Sarbanes-

Oxley requirements.

June 2008 to Blackstone Medical, Inc, Springfield, MA

February 2009 Senior Systems Analyst/ Consultant

. As a Senior Systems Analyst in a contract-to-hire

position, serve as Project Lead for all Business Systems

for two business/programmer analysts, a Cognos Reports

developer, and a Crystal Reports/Help Desk person,

interfacing regularly with external consultants and all

levels of users and management in the organization.

. Support and development of a Vantage ERP system using

VB.net customizations.

. Produce new and modified reports in Crystal Reports XI.

. Blackstone Medical is a publicly held corporation with

$120 million+ year in revenue.

. This position ended because the entire facility at

Springfield was closed.

April 2007 to United Technology Corporation, IT Security, East

Hartford, CT

To March 2008 Consultant

. Design and develop a Risk Assessment System in ASP.net

(VS 2005) and MS SQL 2005, which integrates several

areas of IT Security including Applications, Exceptions,

Patching, and Vulnerabilities.

. Maintain and enhance two Visual Studio 2005 ASP.Net

applications, one which retrieves data from all UTC

Vulnerability databases (MySQL) at all UTC companies and

moves that data to MS SQL Server 2005 databases located

at UTC Headquarters IT Security department; the other, a

Vulnerability Reporting Application, produces graphical

reports using ChartFX from the SQL Server 2005 data.

. Develop reports using ChartFX.

. Develop reports using SSRS.

. Develop several SQL Server Integration Services (SSIS)

packages to move Vulnerability data from MySQL to SQL,

load the Risk Assessment System data, and report new

PointSec files. Develop many reports using SQL Server

2005 Reporting for the various systems.

. Modify Windows Server Update Services (WSUS) programs

developed in ASP.net (VS 2005).

. Develop and maintain Workflow programs for IT Security

Investigations, ID Requests, Policy Exceptions, Active

Directory Requests, Forensic Imaging and others in a

proprietary Workflow application developed by Hamilton

Sundstrand.

. Complete several ACE (Achieving Competitive Excellence)

courses.

September 2006 to Mass Mutual Life Investor Services Inc, Springfield,

MA

March 2007 Consultant

. Design and develop a reporting application, MM

Reporting, in VB.Net Visual Studio 2003 and upgrade to

Visual Studio 2005 to print reports developed in Crystal

Reports XI.

. Application allows selection and storage of Print

preferences, report criteria, and scheduling information

and sends reports to file/screen/printer with auto

generated emails.

. MM Reporting also provides for pre-processing of data

retrieved from AS400/DB2 and Access 2003 databases and

creation of data extracts for reports.

. Develop approximately 150 reports in Crystal Reports and

integrate with MM Reporting and BI.

. Attend training in AWD/BI (Automated Workflow

Distributor / Business Intelligence) by DST.

May 2006 to United Technology Corporation - UTC Power - Fuel Cell

Division, South Windsor, CT

March 2007 Consultant

. Design and develop an Intranet application using

ASP.net/Visual Studio 2005 and SQL Server 2000 to allow

Legal Staff and company engineers to enter, retrieve,

and report on UTC Invention Disclosures, Patent

Applications, and Patent information, as well as

Competitor Patents. Program provided for the linking and

maintenance of related documents, images, charts, etc.,

and the relationships between various Invention

Disclosure, Application and Patent records.

. Migrate data from legacy Lotus Notes program and legacy

Access 2003 tables to SQL Server.

. Develop downloads from Micro Patent Office to SQL Server

and export routines from SQL Server to CSV and other

file formats. Update functionality in Access 2003

program.

April to Mass Mutual Life Investor Services Inc, Springfield,

MA

May 2006 Consultant

. Develop programs and databases in Access 2003 for

auditing and quality control of Trading, Brokerage,

Cashiering, New Accounts, and Account Maintenance

departmental functions.

March to F.L. Roberts, Springfield, MA

August 2006 Consultant

. Develop programs in VB.Net and Access 2003 to perform

file input/output operations and various file

conversions for integration with an AS400 environment.

. This included a Survey program and Time-punch program.

Also support legacy Clarion databases and reports.

December 2005 to Software Concepts, Inc., North Billerica, MA

April 2006 Consultant

. Provide new development and enhancements in VB6/Access

2003 on a remote/laptop based Order Entry module of an

AS400 based accounting system.

. Spearhead development of software tools and develop

several modules deployed in DLLs in addition to feature

enrichments.

. Act as guru to other development staff and provide

design recommendations and consultation to management

regarding development on the Microsoft Windows platform

(versus the character based AS400).

May 2005 to Mitchell Machine, Springfield, MA

December 2005 Consultant

. Enhance existing reports and develop new reports using

Crystal Reports 8.5.

. Convert Access 97 VB application to Access 2003 and

develop a conversion program to export data.

2005 Twisted Balloon Company, New York City, NY

Consultant

. Develop a Customer, Event and Task database Contact

Management System in Visual Basic 6.0, Access and

Crystal Reports to produce invoices, "gig" sheets, thank

you letters, and other reports, and import and export

Customer, Event, and Task information to MS Outlook.

. It will be marketed to a variety of

Entertainers/Entertainment companies, including Balloon

Artists, Caricature Artists, Clowns, Face Painters,

Jugglers, Musicians and DJs, etc. in the Fall/Winter

2005.

. Upgrade portions of program to VB.net (VS 2003).

June 2001 to Academy at Swift River, Cummington, MA

2003 Consultant

. Develop database system in Access 97/VB 6 to store

Student information and therapy results.

. Assist with off-the-shelf software search for web based

student information system and provide analysis on

integration of corporate DBMS, off the shelf systems,

and custom program requirements.

2001 to Northeast Foundation for Children, Greenfield, MA

2006 Consultant

. Develop a comprehensive database system in Visual Basic

6.0 integrated with Access 97/2002/2003 to perform all

operations for Workshops, Consulting, and Publishing

branches of this non-profit business.

. Application ties in a legacy database system and SBT

Accounting program.

. Also made modifications to SBT (FoxPro 6.0). Work on

Upgrade to VB.net in 2003

2000 to Holyoke Public Schools, Holyoke, MA

2007 Consultant

. Provide development and support on a variety of database

systems in Access 97 - 2003 including Inventory,

Medicaid, Personnel, Sped, Transportation and others.

Medicaid System interface with web-based program and

school management system (Rediker).

February 2000 to Fidelity Investments, Boston, MA

June 2000 Consultant

. Enhancements and maintenance on a system developed in

Visual Basic 6 that is used by Investment Analysts to

create business models based on a broad range of

portfolio criteria.

. The system stores sixteen screens of financial

information in Access 97, and passes that information to

a series of spreadsheets in Excel which produces

analytical results.

. Efforts involved adding fields, screens, combining

models, new reports, upgrading components, etc. Work

done in collaboration with Berkshire Technologies.

July 1998 to EMC Corporation, Milford, MA

June 1999 Consultant

. Independently develop a Visual Basic 5.0/6.0 application

to perform inventory auditing and generate a variety of

inventory reports. The Inventory Audit Program (IAP)

will be used at approximately 300 EMC locations

worldwide.

. Users can enter inventory data on custom entry screens

or via upload of bar code files.

. Administrative oversight with additional features and

reports is provided for administrative staff for

Domestic operations in Milford, Massachusetts and for

International operations in Cork, Ireland.

. IAP shares Sybase data files with Clarify, an enterprise

level customer tracking system.

. Also develop a VB 5.0 application using SQL Server to

store and report on millions of dollars of Return

Merchandise Authorizations (RMA) for sales on EMC

products.

. Modify existing SQL scripts and develop new SQL routines

on the server, and integrate these into a new front end

VB application that also accepts daily data feeds from

an AS400.

. Additional ad hoc reporting and querying provided

through Access 97.

. Software used for the above projects includes ADO 2.0,

RDO 2.0, Farpoint Spreadsheet Control, Sheridan Calendar

and Data Widgets, and VS View.

September 1996 to Tracknology, Inc., Montague, MA

Present President

. Microcomputer consulting, specializing in the design and

development of database applications.

. Market a proprietary software program nationally (1996

to 1998) to Racing Commissions and RaceTracks, called

TrackExpress.

1994 to Commonwealth of Massachusetts, Massachusetts State

Racing Commission, Boston, MA

Present Consultant

Support systems below on six consecutive three year

contracts.

. Develop a Financial Reporting System (FRS) in Visual

Basic 6.0 / Access 2003 previously developed by me in

Foxpro 2.6 (in 1994). FRS tracks all revenue received

for betting at the four Massachusetts race tracks and

State Fairs for live and simulcast performances, and all

revenue received off-track from simulcast of

Massachusetts' Thoroughbred, Harness, and Greyhound

races. One system is installed at each of the four

racetracks with a master system at the main office in

Boston that receives data via modem from the tracks and

allows for deposit reconciliation and additional

comparative/statistical reporting. The system provides

for easy modification of percentage, track, and contract

information, and was modified for centralization of data

in Boston with tracks on-line. Upgrade to Access 2007

(2008). Modify (2009-2010) to support new financial

requirements.

. Develop a Racetrack Licensing System (RLS) in VB 6 /

Access 2003 to store and track all persons licensed to

operate at Massachusetts' racetracks, including Jockeys,

Owners, Racing Officials, Trainers, Kennels, Stables,

etc. RLS tracks a complete history of licenses for each

licensee, allows maintenance of status records, and

streamlines the Receipt process allowing the Commission

to maintain tighter controls over revenue. RLS produces

several Revenue, Deposit, Receipt, and Transaction

History reportsand is installed at all four of the

state's racetracks and at the main office in Boston.

Turnkey efforts include design, coding, testing,

implementation, training, documentation, and on-going

support. Enhance RLS (2004-2005) to include photo

imaging. New system integrates a video camera and allows

user to snap images of licensees on-line, print badges

using NISCA printers, store/retrieve history of photos,

generate Licensee dossiers, etc. Also add and upgrade

reports and other functionality. Modify (2005-2006) to

extract data and send to Boston. Upgrade (2008-2009) to

new cameras and integrate webcam software at all

tracks..

September 1991 to Commonwealth of Massachusetts, Registry of Motor

Vehicles, Boston, MA

July 1998 Consultant

. Responsible for custom database software development on

the Local Area Network (Novell 4.1).

. Supervise five full time contract programmers and

develop more than thirty separate networked applications

using FoxPro, Clipper, and Visual Basic versions 3, 4,

and 5, Access 2.0, Crystal Reports 6.0, Sheridan

controls, Videosoft, and other VB third-party add-on

products.

. Serve as LAN Administrator for 250 workstations/350

users (1991-1993)

. Work with all levels of users and management to pursue

the goals of the agency.

. FoxPro applications independently developed and upgraded

to Visual Basic include:

Blue Light/Red Light Tracking Dealer Repair

Payroll & Personnel Tracking

Confidential Plates Excise

Security Tracking

Confidential Licenses Fatal Accidents

Training Department System

Correspondence Tracking Medical Affairs

Vehicle Inspection

TRAINING

. Apple - iPhone Development Self Study, 2009;

. Unix Scripting - Self Study, July 2009.

. Hidden Tech .Net Users Group;

. AppDev VB.Net and ASP.Net Training, 2002-2006;

EDUCATION

Sonoma State University, Rohnert Park, California.

. Bachelor of Science, Computer Science; Minors in

Management and Psychology.

CLIENT LIST

A & W Machine Instruments Matrix Computer Systems

Academy at Swift River MicroTest Laboratories, Inc.

Bay State Cruise & Steamship Company Mishawum Park Associates

Beacon Company Mitchell Machine

Beacon Health Strategies, LLC Multibank Service Center

Better Lifestyles, Inc. Northeast Foundation for Children

Blackstone Medical, Inc. O & W Heat Treatment, Inc.

Boston Central Realty PC Magazine

Boston Harbor Hotel PC Week Newspaper

Boston Redevelopment Authority Peabody District Court

Boston Roommate Center Pioneer Training

C C & F Asset Mgt Co Pratt & Whitney

Community Boating Rainbow Lobby

Computer Land Rice Oil

Coolidge Bank and Trust Roommate Connections

Davenport & Co Real Estate Sage Corporation

Dave's Soda and Pet Food City Scandinavian Seminar

Discovery Charter School Shawmut Bank

EMC Corporation Shuffain & Zophin

Fazzi Associates Silverscreen Design

Fidelity Investments Software Concepts, Inc.

F L Roberts Sportscape, Inc.

Friends of Children Staples / Market Max

Gekay Team Air Express

General Electric Textron, Inc.

G J Lucheti Construction The Balloon Guy & Company

Genetics Institute The Boston Company

Hingham District Court The Forum Company

Holyoke Public Schools The March Company

Keller Services The Mentor Network

Library of Transportation Thrifty Financial Services, Inc.

Ludlow Public Schools Town of East Longmeadow

Massachusetts Business Development Twisted Balloon Company

Corporation Unique Homes

Massachusetts Society for the Prevention of United Technology Corporation IT Securty

Cruelty to Children (Corporate HQ)

Massachusetts State Police United Technology Corporation UTC Power

Mass Registry of Motor Vehicles United Technology Research Center

Massachusetts State Racing Commission Uplinc, Inc.

Mass Mutual Life Investor Services Upward Bound

Contact this candidate