Joseph Marchesani
Security Guard Software Engineer
Summary
Software engineering professional with proven ability to deliver MS-Access and SQL Server database products and projects. Experienced in design, debug, verification testing, and support of complex systems, including ARRIS CMTSs, DECnet, VAX and Alpha systems.
Overview
59
59
years of professional experience
Work History
MS Access Developer
Titus Consulting
Wellesley, MA
01.2012
- Developed a proposal for a marketing expense tracking system for a major financial institution.
MS Access Developer
Hanover Insurance
Worcester, MA
09.2009
- A short term project to develop an assignment and time monitoring system for Customer Service Associates.
Security Officer
Allied Universal Security Services at BAE Systems
MA and NH
04.2022 - Current
- Secret Security Clearance
MS Access and SQL Server Developer
Partners Healthcare
Somerville, MA
09.2013 - 08.2019
- Developed and supported multiple applications related to Patient Care Services, TEFRA and Redbook applications. After EPIC transition, rewrote Dialysis app in C# and SQL Server.
- Developed BI Reports for Pharmacy.
MS Access Developer
Resolute Management
Boston, MA
03.2012 - 09.2013
- Designed database for the allocation of claim liability to insurers and payments received.
MS Access Developer
Behavioral Health Network
Springfield, MA
02.2012 - 03.2012
- Created Migration databases and tools for scrubbing and transferring data to a new healthcare system.
MS Access Developer
Fidelity Investments
Boston, MA
01.2011 - 09.2011
- Returned to move SQL server version to production. Also enhanced forms and reports to take advantage of SQL Server.
MS Access Developer
Titus Consulting at Sun Life
Wellesley, MA
05.2010 - 01.2011
- Developed a database to replace an Excel spreadsheet that required a full day each month to reconcile reinsurer share payments. The database exports a spreadsheet that looks like the original output, but can run the calculations in twenty minutes. Extended the same logic to three other business lines.
MS Access Developer
Fidelity Investments
Boston, MA
10.2009 - 05.2010
- Developed additional functions for the databases at National Financial.
- A color coded, multi month, Excel calendar generator using events from the database, and a color coded, Excel Gantt Chart based on schedules of target dates. Providing resource usage and allocation tools for management.
- An email archive process to capture SME Approval emails from outlook and save them to a server archive folder, and save the link to the file(s) for each item in the database.
- Revised the WebEx capture code to import, parse and save training registration and usage data.
- Converted Data to SQL Server test system; including development of Views and Stored Procedures. Improving response time and performance at least ten fold.
MS Access Developer
Fidelity Investments
Boston, MA
04.2008 - 04.2009
- Developed two new databases and modified two existing databases that manage the implementation, training and documentation for National Financial.
- Training Database
- Restructured database to streamline data relationships, making reporting more accurate and efficient
- Redesigned forms to make data entry more efficient
- Designed reports to address new requirements
- Enhanced data entry for web-based classes to address performance issues and increase accuracy
- Redesigned existing reports to ensure accuracy with new structure
- Developed ad-hoc reporting mechanism to be able to handle changing reporting requests
- Documentation Database
- Full build of project functionality to allow management of a large number of projects (typically up to 140 active projects covering a span of 6 months)
- Development of reports to allow summary and detail reporting on items and projects
- Development of an issue tracking database to facilitate the management of project issues.
- Implementation Database
- Incorporated the common login and version replacement mechanism to ensure that all users are using the most current version of the database
- Developed excel output to assist with ad-hoc reporting
- Developed the “Conversion Plan and Calendar” output to Excel, to match an existing Excel workbook; this streamlined maintenance of a key management and reporting tool
MS Access Developer
Fidelity Investments
Merrimack NH and Boston, MA
09.2007 - 02.2008
- Developed an Access database to manage the relocations of personnel in the Technology Group.
- Consolidate several Excel spreadsheets and provide connections to corporate databases.
- Two Small 1 week projects in Boston.
MS Access Developer
Sepracor Inc
Marlborough, MA
03.2007 - 08.2007
- Developed a SQL Server backend with an Access front end for a Quality Assurance Adverse Event and Product Complaint tracking database.
- Consolidated several production tracking databases into one.
- Enhanced a non-clinical purchasing database.
MS Access Developer
Public Sector Partners
Worcester, MA
03.2006 - 02.2007
- Technical lead for database system supporting payments from the Massachusetts state pharmacy assistance program (SPAP) under Medicare Part D to 20 insurers. Database also records member enrollments, providing reporting by member by plan by month.
- Developed forms and queries to support automated: payment of remittances; processing of data feeds from the Center for Medicare and Medicaid Systems; and Coordination of Benefits reports for insurers.
- Planned and executed migration of back end to Oracle
- Extensive interaction at high levels with insurers, the state agency, and Public Sector Partners.
MS Access Developer
WellPoint/UniCare
Andover, MA
08.2005 - 02.2006
- Ford Disability Management, to develop a new transfer program and modify the Disability Case Management System to match MDA V4.3 on a SQL Server database. Developed new triggers to match new schema.
MS Access Developer
Citizens Bank, Corporate Security
Medford, MA
08.2004 - 07.2005
- Developed custom reports using Access from Investigations Case Management System on a SQL Server database. Developed Forms and wrote VBA code to generate complex SQL Pass thru queries and formatted Excel spreadsheets and charts.
MS Access Developer
KSB Data Access
Arlington, MA
03.2004 - 08.2004
- Developed applications for medical research data analysis, Material Management at a Major Hospital, Meeting Management for a large Medical Partnership, and a database for the Arlington Chamber of Commerce.
Application Developer
Unicom
Woonsocket, RI
10.2002 - 10.2003
- Consultant and developer on a conversion from Access97 to Access2000 with SQL Server 2000 for the Public Defenders Office of Rhode Island
- Implemented customizations to Astea Alliance Enterprise V6.1 CRM for Field Service using iStudio, VB, and MS SQL tools.
Senior Software Engineer
Nortel Networks-ARRIS
Andover, MA
02.1999 - 07.2002
- Developed automated test scripts using Tcl/Tk, Scotty, Expect, SmartBits, SimpleTester, and Net-SNMP on Linux and Windows 2000 systems, for testing of CMTS.
- Developed the second and third versions of the DOCSIS Cable Modem Provisioning System in MS-Access/VBA. Added Forms and functions to provision: Ingress Avoidance, Account Management, and EuroDOCSIS.
- Enhanced Reporting and Import functions. Modified, ported and created several C utility programs required for LCn.
Fidelity Investments
Marlboro, Merrimack, Boston
10.1996 - 02.1999
- Developed an online Access application to provide reports and charts on all aspects of compensation packages for analysis of results during the 1998 Bonus and Share Cycle.
- Developed an Access reporting and analysis for senior employee compensation planning for corporate HR. Developed a system that used a few basic templates to provide reports and charts from a wide variety of criteria for grouping, sorting and comparison of EEO data.
- Enhanced and maintained a data scrubber for Health and Welfare client data feed.
- Developed and provided support for an MS Access, Accounts Payable systems using data from Sybase servers.
3Com ISD (Chipcom Corporation)
Southboro, MA
04.1993 - 10.1996
- Consultant to the Finance Group - Developed and provided support for MS Access reports using data from a large production management system. Provided timely reports on Backlog, Bookings and Shipments, enabling management to exceed year end revenue goals.
- Developed Saber Menus and Reflection scripts for automated dial-in connections to GrowthPower through NetWare: PC/OnLAN, Access Server, and NACS.
Principal Software Engineer
Digital Equipment Corporation
10.1974 - 02.1993
- Alpha and VAX Systems 1987-1993
- Responsible for hardware and software for all VAX-Alpha announcements, photo shoots, and shows worldwide.
- Collaborated with outside engineers to install and run their software on Alpha systems at DECworld. Demonstrating the ease of porting applications to Alpha AXP OpenVMS.
- Modified the VAX architecture exerciser, Virtual Terminal Program to run on the 7000 series console, allowing existing test procedures to run on a radically new console.
- Network Software Engineering 1983-1987
- Implemented a Data Link and port driver for MS-DOS DECnet for the asynchronous ports on the Rainbow and IBM PC, and Ethernet controllers for IBM PCs and compatibles. Coded in C and optimized in assembler.
- Responsible for the implementation of a VMS terminal port driver, serving terminal concentrators in a local area network. (LAT)
- MultivVAX Systems Engineering 1981-1983
- Managed a buy-out of a hi-availability, digital data switch for VAX/VMS Cluster terminals, and the design and development of software to control connections and fault isolation of the switch.
- MDC Software Development 1979-1981
- Developed a terminal ACP providing a T1 like software interface for DECdataway concentrator terminals.
- Senior Software Engineer-Supervisor 1978-1979
- Responsible for supervising two system managers and a telecommunications supervisor
- Designed and developed an electronic terminal switching system, including vendor evaluation and developing proposals and presentations relating to terminal switching networks.
- Field Service Software Specialist 1974-1978
- Trouble shooting customer hardware/software problems using the RSTS/E operating system. Resolving customer telecommunications problems.
Application Engineer/Programmer
All Systems
Moorestown, NJ
01.1972 - 01.1974
- Developed device driver code for Data modulators/demodulators and status display panels, which were part of a maritime satellite communication and navigation system.
Business Machines Group
Burroughs Corporation
Downingtown, PA
01.1969 - 01.1972
- Designed logic for boot loader and paper tape reader/punch on B700.
- Defense Space and Special Systems Group
- Final test technician CENPAC, Pershing and ILLIAC IV Processing Element.
Customer Engineering
Optical Scanning Corporation
Newtown, PA
01.1967 - 01.1969
- Federal Systems Manager, Midwestern Regional Manager, Customer Engineer
Education
No Degree - Computer Applications Development
05.2001 -
Skills
Application programming
Analytical problem-solving
Team collaboration
Application development
Experience with source code
Performance optimization
Code validation
Hardware development
Technical writing
Technical support
Unit testing
Source control management
Education and Training
- Digital Equipment Corporation - Alpha Porting Seminar, Software Quality Workshops, Ultrix System Management, Time Management, Finance for the Non-Financial Manager, RSX-11M/S User and Support, Data Communications Devices;
- Burroughs Corporation - MS7000, Pershing Systems;
- Optical Scanning Corporation - Dale Carnegie Course, Customer Engineering;
- U.S. Air Force - MA-1 Weapons Control, Electronics
Timeline
Security Officer - Allied Universal Security Services at BAE Systems
04.2022 - Current
MS Access and SQL Server Developer - Partners Healthcare
09.2013 - 08.2019
MS Access Developer - Resolute Management
03.2012 - 09.2013
MS Access Developer - Behavioral Health Network
02.2012 - 03.2012
MS Access Developer - Titus Consulting
01.2012
MS Access Developer - Fidelity Investments
01.2011 - 09.2011
MS Access Developer - Titus Consulting at Sun Life
05.2010 - 01.2011
MS Access Developer - Fidelity Investments
10.2009 - 05.2010
MS Access Developer - Hanover Insurance
09.2009
MS Access Developer - Fidelity Investments
04.2008 - 04.2009
MS Access Developer - Fidelity Investments
09.2007 - 02.2008
MS Access Developer - Sepracor Inc
03.2007 - 08.2007
MS Access Developer - Public Sector Partners
03.2006 - 02.2007
MS Access Developer - WellPoint/UniCare
08.2005 - 02.2006
MS Access Developer - Citizens Bank, Corporate Security
08.2004 - 07.2005
MS Access Developer - KSB Data Access
03.2004 - 08.2004
Application Developer - Unicom
10.2002 - 10.2003
Franklin Pierce University - No Degree, Computer Applications Development
05.2001 -
Senior Software Engineer - Nortel Networks-ARRIS
02.1999 - 07.2002
- Fidelity Investments
10.1996 - 02.1999
- 3Com ISD (Chipcom Corporation)
04.1993 - 10.1996
Principal Software Engineer - Digital Equipment Corporation
10.1974 - 02.1993
Application Engineer/Programmer - All Systems
01.1972 - 01.1974
Business Machines Group - Burroughs Corporation
01.1969 - 01.1972
Customer Engineering - Optical Scanning Corporation
01.1967 - 01.1969