|
Capabilities:
- Design and create program specifications for
in-house and contract programmers.
- Lead programming efforts and provide program
expertise to project programmers
- Extensive IBM DB2 SQL and database design
expertise.
- Conduct business systems analysis meetings to
define the scope of a project and customer requirements.
- Create and monitor project work plans.
- Document user requirements.
- Maintain and enhance AllFusion Gen based
systems.
- Conduct routine maintenance and debug
operations on application software.
Software Experience:
|
Advantage:Gen(Cool:Gen)
|
SQR
|
Eclipse
|
|
PL/SQL
|
MySQL
|
Java
|
|
Cobol II/390
|
DB2
|
VB.NET/ASP.NET
|
|
CLIST/REXX
|
QMF
|
Visual Basic
|
|
IBM Assembler
|
SQL
|
C
|
|
IBM CSP
|
DB2 Visual
Explain
|
MS Word
|
|
Easytrieve
|
MQ Series
|
Excel
|
|
TraceMaster
|
VSAM
|
ccMail
|
|
Xpediter
|
CICS
|
Telon Batch/CICS
|
|
Intertest
|
TSO
|
Millenium PDL/SDT
|
|
FileAid
|
MVS JCL
|
|
|
Librarian
|
ISPF
|
|
|
Endevor
|
Changeman
|
|
Authored Software:
DB Utility – Java application developed to
ease implementation of stored procedures and database modifications.
Posted at www.fisincorporated.com/DBUtility_page.html
Consulting Experience:
Apr 2007 – Present Senior Programmer/Analyst
Verizon, Waltham, MA
- Worked on billing system using dynamic SQL
- Performed general maintenance on stored
procedures
- Performed troubleshooting of data issues in
billing reporting system
Jan. 2006 – March 2007 Senior Programmer/Analyst
National Grid, Westborugh, MA
- Updated Advantage:Gen Time Entry System for
consolidation of purchased utility company
- Added/Modified addition Advantage:Gen programs
for continuing operations
- Updated Peoplesoft SQR programs for conversion
of Peoplesoft HR V8.0 to V8.9
- Used DB Utilities program to identify
inconsistencies in table layouts and data for both Peoplesoft upgrade
and utility company consolidaton
June 2005 -Dec 2005
CVS, Woonsocket, RI
- Developed COBOL CICS and batch programs for
inventory system
- Developed and maintained Cobol and Easytrieve
programs
- Developed new and modified VSAM files for
inventory system
Jan 2005 - Apr 2005 Senior
Programmer/Analyst
Verizon, Boston, MA
- Enhanced Java DB Utility program for full
regression testing of stored procedures, SQL comparisons of data
- Performed general maintenance on stored
procedures
- Performed troubleshooting of data issues in
billing reporting system
- Modified DB2 table/views due to table changes
- Developed DB2 UDF's to format data for
presentation
- Analyzed poor performing SQL using DB2 Explain
and modified as needed to improve performance
Nov 2005 - Jan 2005 Sabbatical
Java/VB/Continuing Education
- Created VB app for accepting XML requests and
return XML formatted stock price information
- Created Java classes to process XML stock
information and pass to Jess/JOONE
- Worked on Jess expert system software and
interfacing with Java objects for stock evaluation
- Worked on JOONE (Java Object Oriented Neural
Engine) and Java objects to extend JOONE I/O and field stock information
to neural net.
- Realized I still need a day job.
June 2003 - October 2004 Senior Programmer/Analyst
National Grid, Westborough, MA
- Made Advantage:Gen code modifications to Time
Entry System to interface with new Peoplesoft GL system.
- Developed Cobol XML generator and parser for
CICS and batch processes.
- Developed Cobol CICS transactions with MQ
Series interfaces for passing XML to and receiving reply from Peoplesoft
GL.
- Developed Advantage:Gen external action blocks
to get around CICS/Advantage:Gen limitations and to interface to XML and
MQ Series routines.
- Developed Java HTTP/Peoplesoft app due to
incompatibility between Peoplesoft GL and Peoplesoft HR.
- Made DB2 database changes to support new GL
accounting requirements.
Jan 2001 - May 2003 Senior Programmer
Analyst
Verizon, Boston, MA
- Analyzed existing batch billing reporting
system.
- Performed analysis, functional and database
design and implementation of DB2 based billing information.
- Designed and implemented Cobol stored
procedures as interface between web front end and billing information.
- Designed stored procedure reporting system for
retrieval, filtering and sorting of billing information using dynamic
SQL.
- Developed DB2 UDFs to handle specific data
reporting requirements not handled by SQL alone.
- Developed numerous DB2 views incorporating
complex SQL to support stored procedures.
- Developed program specs, monitored program
development and provided tech support to Verizon India software development group
- Used Visual Explain to check DB2 access paths
and modified SQL and indexing as needed based on explain results.
- While commuting started development of Java
DBUtility application for running and testing DB2 stored procedures.
July 1999 – December 2000 Senior Program Analyst
HRIS Incorporated, Hopkinton, MA
- Performed system analysis, functional specs,
database design and implementation of SQL Server 2000 stored procedures
for web portal testing application
- Performed analysis, design, and batch and CICS
programming to implement a web based employee benefits system
- Performed analysis, design and programming
changes to Integral HR DB2 tables and CSP code to modify the update the
system to a date effective system
- Created COBOL subroutines to interface with
Integral for implied HR changes
- Designed and coded CICS transactions to
interact with Visual Basic and SNA Transaction server middleware for web
based front end
- Performed analysis, design and CICS/DB2
programming to implement web based Time Entry System
March 2000 – May 2000, Jan 1997 – October 1999 Senior Programmer/Analyst
New England Electric (now National Grid)
- Analyzed and made code and DB2 changes to
maintain Time Entry system implemented in Cool:Gen (now Advantage:Gen).
- Handled and coordinated upgrade of IFE 5.3 to Cool:Gen 4.1.
- Performed Y2K analysis, design, coding and
system testing.
- Provided Time Entry Support during company
merger activity
April 1996 – Jan 1997 Senior
Programmer/Analyst
Putnam Mutual Funds
- Designed and implemented code to receive and
process payrolls from outside vendors for employee stock purchase
system.
- Worked with business unit and major external
customer to refine functional requirements, DB2 design, program specs,
test plans for production implementation and support.
August 1995 – March 1996 Senior
Programmer/Analyst
Dun and Bradstreet
- Maintained and debugged Assembler and Cobol
DB2 programs used in Dun and Bradstreet’s Millenium operating system
- Provided phone support and assistance to Dun
and Bradstreet customers in implementation and use of Millenium/DB2.
Documented customer DB2 problems for later analysis and debugging.
Employment
October 1976 – July 1995
Lubrizol Corporation, Wickliffe OH
- Conducted analysis and design of Marketing
division project to provide electronic routing of customer program
requests and results.
- Lead analysis, design, and implementation of
Dun and Bradsteet Capital Project Financials and Flashpoint as 3270
“screen scrapper” to provide Windows front end to system.
- Created proof of concept CICS remote procedure
calls to DB2/Sysbase code generator written in C.
- Designed and managed project for customer
profile marketing system.
- Conducted analysis and implementation of text
search retrieval system. using Thunderstone Software’s Metamorph for
competitive intelligence file system.
- Developed ISPF/Cobol front end system to
DB2/QMF for sales and profitability information for Sales and Marketing
management and field salesman
- Lived and worked at Lubrizol’s technical
center in Hazelwood, U.K. to support sales and marketing groups and
conduct user training at the center
- Developed multiple regression statistical
analysis system and procedures for analyzing and predicting engine test
results to help speed product development and reduce engine test costs.
- Prior to switch to computer oriented work
performed organic synthesis lab work for development of engine lubricant
additives.
Education
1998 Worcester PolyTechnic Institute (continuing ed)
Artificial Intelligence
1997 Brandeis University (continuing ed)
Advanced Java 1.1
1986 Cleveland State University
Masters of Computer and Information Science
1976 Pennsylvania State University
Bachelors of Science in Chemistry
Top
|
