Gregg J. Hamel
10 Oakledge Road •
Swampscott, MA 01907-2916
Phone (home)
781-592-1707 • (cell) 617-549-3819
Hardware:
IBM Z series, S390, Apple
Macintosh, Windows PC
Software:
Mainframe: Z/OS, OS/390, MVS, IMS/DL1, DB2/SQL, Oracle,
CICS/VS, TSO, VSAM, COBOL, SAS, Eztrieve, Fileaid, Panvalet Librarian, Abendaid, Xpediter, Intertest, SmartTest, Spufi, IBM Utilities, Platinum, JCL, TCP/IP, FTP,
Control-M, Endevor.
Windows PC: Microsoft Word, Microsoft Access, Microsoft
Excel, Microsoft Visio, TCP/IP, FTP, Control-M, JavaScript, HTML, Brio, Mercury
Quality Center, ClearQuest, VisualStudio,
Notepad++, Toad.
Project Management: Agile,
Scrum.
Work Experience:
October 2008 – December 2008 Ciber Inc. Boston, MA
Lead Systems/Business Analyst at Fidelity Investments for Ciber Inc.
· Lead analyst on a VB6 to .Net conversion project for an internally facing intranet website related to Fidelity employee brokerage licensing and registration. Project utilized Agile project management methodologies with Scrum techniques. Tasked with producing project technical documentation, setting up test scripts in Mercury Quality Center and performing unit and regression test plans on test servers prior to releasing builds on QA servers. Created detailed sitemap for the large, 300 page intranet website. Primary responsibilities included meeting with the Fidelity employee subject matter experts to document and convey requirements and deliverables to the onsite Ciber development team, coordination with the project delivery manager on general project related issues and planning, coordination of testing with the developers and detailed technical specification documents and testing results.
November 2000 – July 2008 Fidelity Investments Boston, MA
Consultant/Senior Software Engineer Developer
· Hired for a multiyear project to implement a large, complex vendor package that is used to calculate state tax withholdings for retirement distributions. Gathered requirements for, designed, coded and implemented the applications programming interface modules for the vendor software in COBOL/DB2, in both batch and online versions. Designed DB2 tables to be used as state tax rules reference repositories in conjunction with business analysts and the user community. Utilized Endevor as the sole software control and migration control for all production installs; software retrieval, locking, compiles and migration were all done through Endevor. Post implementation support involved coordination and implementation of vendor software changes with coordination of user acceptance testing of said changes. Since then have participated in numerous long-term and short-term projects involved in many phases of the SDLC including project sizing, requirements gathering, JAR/JAD sessions, findings presentations, gathering signoffs, test plans creation, writing SDLC documentation, creating detailed technical specifications for junior members of the IT team, software coding, unit testing, systems integrated testing, user acceptance testing, all utilizing Fidelity Investments’ SDLC standards. Last responsibilities were to support an asset allocation system that created mutual fund orders for incoming retirement contributions. Components of the allocation system supported included a web based front end, CICS backend, homegrown middleware utilizing XML, CICS support screens and a large multi-threaded batch processing component. All mainframe components coded in COBOL and DB2. These were constantly in flux due to frequent regulatory and business changes, which I coordinated. Projects include enhancing and maintaining the complex middleware and backend processing modules for the web based contribution system, adding new threads to the batch processing, deciphering unique holiday processing issues, modifying the CICS screens to meet business objectives and coordination of unit testing with users, developers and business analysts. Subject matter expert on several in house systems; contribution processing, mutual fund order creation, contribution and fees processing for SIMPLE plans and state tax withholding. Main responsibility was to interface and support the user community in order to provide direct support of their business; coordinating system enhancements, problem resolution, management reporting and requirements gathering. Coded modifications to screens in an intranet application for state tax regulatory requirements utilizing JavaScript, VB and HTML. Provide continuous off hours on-call production support for mission critical systems. Provided countless ad-hoc management reports using DB2 data mining tools, SAS and Eztrieve for the management and the user communities. These required extensive DB2 and VSAM data mining and knowledge of the data. Received two “On-the-spot” recognition awards for 1) excellent customer service and 2) detecting and averting potential holiday and production processing issues.
April 1999 – November 2000 IBM - NSTAR Boston, MA
Consultant/Programmer Analyst
· Working as a sub-contractor through IBM. Supporting CIS (Customer Information System) which provides customer information, payments and billing services to NSTAR. Processed via a large IMS batch and online system. Used structured methodology to implement sweeping Gas Deregulation changes to the system. Working from detailed specifications, I modified numerous modules, unit tested, system tested and then implemented the changes. Also provided analysis for large migration project. Allowing two disparate companies to merge into one processing entity. Creating detailed specifications for junior members for software changes including test and implementation plans.
April 1994 – March 2000 Harvard Pilgrim Health Care Wellesley, MA
Consultant/Programmer Analyst
· Implemented a large Capitation subsystem from vendor (EDS) to be integrated within the current claims payment system. Provided analysis for business, technical and processing requirements. Wrote detailed system design documents and functional specifications encompassing all facets of a multidimensional project. Worked with the database administrators on design of new IMS/DL1 databases. Developed complex processes utilizing Cobol II, SAS, VSAM, IMS/DL1. Wrote complete detailed system documentation. Handled post-implementation install issues as they arose. Implemented a large, new DB2 data-warehouse system. Worked with DBA’s on design of new data warehouse tables. Wrote SAS/DB2 extracts for the new system. Utilized DB2 utilities for load and unload of new data warehouse tables. Also employed TCP/IP and FTP for data transfer between disparate platforms and systems within an eclectic environment. Provided 24/7 support of production systems.
Feb 1992 – April 1994 Electronic Data Systems Boston, MA
Systems Engineer
· Handled all facets of systems migration to a new claims payment system. Wrote systems conversion software for required data format changes in Cobol II, set up new procedures with JCL, developed interfaces between old and new systems, created conversion modules. Developed new online data entry system utilizing CICS, later adding major modifications to a complex IMS/DBDC multi-screen system. Interacted extensively with user community to analyze requirements for addendum’s and future modifications to existing systems. Handled production support, modifications and enhancements of front-end traffic cop system utilizing Cobol II, VSAM, IMS/DL1. Provided management analysis reporting for the user groups using SAS.
April 1989 – Jan 1992 Blue Cross/Blue Shield Boston, MA
Lead Programmer
· Interfaced with vendor (PMSC Inc.) to discuss and specify customized changes for a large claims payments software system on the IBM mainframe. Provided analysis to the vendor with input from user area on mandated and requested changes to software. Provided support for database recovery and 24/7 systems support. Ran systems unit testing and systems user acceptance testing procedures. Provided production rescue and ad hoc management reporting utilizing Cobol II, VSAM, SAS, and IMS/DL1.
Sept. 1987 – April 1989 The Boston Company Boston, MA
Programmer Analyst
· Installed and maintained vendor software for banking area utilizing COBOL, VSAM. Developed CICS online security system. Supported a check reconcilement vendor package. Provided 24/7 on-call support, development of interface programming and production rescue. Interfaced with user area for problem resolution and enhancements to production system. Created and maintained reporting subsystem.
July 1985 – Sept. 1987 State Mutual Insurance Company Worcester, MA
Programmer Analyst
Developed, implemented and maintained in-house
software for Group Insurance system using COBOL, IMS and VSAM. Worked in batch and online
environments. Provided
in on-call support for production systems. Involved in unit and user
acceptance testing phases of development cycle.
Education:
·
Computer Processing Institute, Woburn, MA 1984
Diploma in Business Computer Programming
·
Northeastern University, Boston, MA 1980 – 1983
Completed studies towards
master’s degree in Biology.
·
Indiana University, Bloomington, IN 1978
Received Bachelor of Science Degree in Biology, Honors Program