Developer Software

John P. McAnespie

** ******* ******, ******, ** *1850 ? 978-***-**** ?

****.*********@*******.***

SKILLS

Programming Languages: VBA, VB6, Transact-SQL

Web Technologies: HTML, Joomla, Lua Scripting, FactSet

Reporting Technologies: Corvu, MS Access, Crystal Reports 7-XI, Lotus Notes

Development Tools and Technologies: MS Access, Visual Basic, PowerBuilder,

Lotus Notes

Databases: MS Access, SQL Server

User Support Technologies: Webex, Salesforce, CrossLoop

EXPERIENCE

Software Consultant, April 2010 - Present

BJ's Wholesale - Software Design and Development

Technologies Used: MS Access, Excel

. Converted Excel based applications to an MS Access applications

. Enhanced existing MS Access applications.

GL&V - Software Design and Development

Technologies Used: MS Access, Excel

. Converted numerous Excel based applications to MS Access

. Trained internal users to use new system.

. Created a User Guide and Technical Guide

The Legacy Companies - Software Support

Technologies Used: MS Access, Webex, Setup Factory

. Enhanced existing MS Access application

. Support of end users in the setup and use of existing MS Access

application

The Legacy Companies, March 1999 - April 2010

Senior Software Developer

Technologies Used: MS Access, MS Word, MS Excel, Setup Factory

with Lua Scripting, Salesforce CRM, Joomla, PDF-XChange

. Designed, developed, tested, debugged and implemented the

proprietary software used to automate the values-based planning

methodology written in MS Access and VBA

. Administered the company website using Joomla and HTML.

. Created all setup executables using Setup Factory and Lua

scripting language to customize software installations for all

types of users.

. Designed and developed a security system to unlock the

proprietary software.

. Created and updated end-user guides and instructions as needed.

. Provided support for 500+ end users with all aspects of the

proprietary software.

. Administrator of company Salesforce CRM.

. Administrator of company email accounts and resource centers.

State Street Research and Management Co., April 1996 - March 1999

Senior Developer

Technologies Used: Visual Basic, Transact-SQL, Crystal Reports,

MS Access, Eagle PACE Data Warehouse, FactSet

. Designed, developed, tested and debugged a Global Portfolio

System reporting application

. Converted an existing Symphony Spreadsheet to a Visual Basic/SQL

Server/Crystal Reports application

. Data Warehouse Lead Developer converting mainframe reports to

use data warehouse data

. Created automated data feeds to numerous banking institutions

using MS Access and API calls for FTP processing

. Produced numerous Fixed Income/Equity/Bond ad-hoc reports using

MS Access and SQL Server

. Year 2000 Lead Developer

. Mentor to two junior developers

John P. McAnespie Page 2

41 Burnaby Street, Lowell, MA 01850 ? 978-***-**** ?

****.*********@*******.***

C.W. Costello and Associates, June 1994 - April 1996

Software Consultant/Developer

Long Term Assignments Included:

Colonial Management Inc. - Software Design and Development

Technologies Used: PowerBuilder

. Created a Marketing Budgeting System

. Trained internal users to use new system.

. Created a User Guide and Technical Guide

State Street Research and Management Co.- Software Design and

Development

Technologies Used: MS Access, SQL Server

. Code of Ethics application

. Investment Clearance application

. Portfolio Reporting System

Wang Laboratories, August 1987 - August 1993

Data Center Programmer/Data Center Operator

Technologies Used: COBOL, Wang Procedure Language

. Created a COBOL based scheduling system for the Revenue

Management Organization, automating the process of running

revenue batch jobs and reporting the progress to all

operators

. Processed production batch jobs and created system backups

for 100+ systems

COMPUTER EDUCATION / CERTIFICATIONS

Hands On Technology Transfer - 2010

. VB.Net and ASP.Net Training, October 2010

. Business Intelligence Training (SSRS, SSIS, SSAS), November

2010

Boston University - 1994

Software Application Developer Certificate Program, April

1994

Client/Server Application Development Certificate Program,

June 1994

Salem State College - 1984 -1987

. Computer Science Major/Mathematics Minor

Contact this candidate