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