Jonathan David Helm
2 Sorel Avenue, North Smithfield, RI 02896
[Send email to request phone number] 65-6254 [Send email using form at bottom]
Summary: Experienced programmer/analyst on a variety of platforms including
multi-tiered Client/Server, SQL Server in a Data Warehouse environment, AS/400,
and OS/MVS.
Operating Systems: Windows 2000/NT/95/98/XP, AS/400 RISC, OS/MVS
Languages: Visual Interdev 6.0, ASP, HTML 4.0,
VBScript, Visual Basic 6.0, Transact-SQL,
COBOL, CICS, OS/MVS JCL, VSAM, AS/400 CL
Database: SQL Server 7.0/2000/2005/2007, Access97,
DB2/SQL, Sapiens/DB2
Software: Cognos BI Impromptu and PowerPlay tools
Crystal Reports 8.5
Policy Management System insurance system
TIDAL Enterprise Scheduler, CICS
Strategic Data Systems (SDS) insurance system
Experience directly related to this Professional Opportunity
(independent consultant working with Reliance Systems) 6
months of 2001
o Contracted to provide an ASP / VB Script / SQL SERVER 2000 solution for a
company that hired mystery shoppers, and wanted to quantify all of the results of
the shopping trips, to grade the shoppers and the stores.
o Although this was almost 8 years ago, I currently work with VB6 and SQL Server
now.
Full-time Professional Experience
AIPSO Johnston, RI
Senior Programmer Analyst 2005-2009
o Supported the Alaska and SouthEast Service Center System, including
interactive and batch functionality for Underwriting, Billing, and Agency Support
processing.
o Modified, tested and deployed the integration of the Application Processing
System rewrite project within Alaska Service Center system, using the Producer
WebService.
o Developed and deployed enhancements for numerous scripts for error fixing
within the AK/SESC to comply with production server lockdown requirements,
including monthly and daily batch errors, check register issues, company and
producer data issues, and printing errors.
o Developed and deployed Quota Inquiry processing for Annual Updates, and
converted Quota Inquiry Annual and Quarterly data-loading to Tidal processing.
o Supported the Rhode Island Service Center System, including CICS and Batch
functionality for Underwriting, Billing, and Agency Support processing.
Jonathan Helm page 2
OneBeacon Insurance Company Foxboro, MA
Snior Programmer 2004-2005
o Designed, developed and implemented the EARS personal automobile driver
incident reporting interface. Extracted data using COBOL with DB2/SQL from the
mainframe, to create external reporting tape to request driver incidents on a
monthly basis. This project yielded time savings by allowing for elimination of
some manual reporting by field office personal.
Providence Washington Insurance Company Providence, RI
Applications Programmer Specialist 2000-2004
Lead Developer for the Data Warehouse project.
o Supervised other employees using AS/400 COBOL extracts, and SQL Server
7.0/2000 database design and stored procedures, to populate the Actuarial policy
and claims data warehouse. Performed data modeling and database performance
management duties in a team environment.
o Developed and implemented SQL stored procedures loading the data warehouse
star schema design, and summarizing the data for use with COGNOS BI tools.
o Used COGNOS Impromptu, PowerPlay, and ReportNet for ad-hoc querying, and to
create reports and data cubes. These new interfaces yielded 2-3 per month of
time savings for the Actuarial department.
Senior Applications Programmer Analyst 1997-2000
o Designed, developed, and implemented an Agency Experience Intranet-based
application. Used Microsoft Visual Interdev, ASP, VBScript, and HTML 4.0.
Learned new technologies from an external consultant, and delivered the project
within 3 months. Designed and developed the back-end database using SQL Server
7.0, including the web security portion. Built SQL stored procedures and
accessed them with ASP and VBScript.
o Developed a SQL Server 6.5 database for an Interactive Voice Recognition
application. Maintained applications’ front-end “call handler” routines using
Enterprise Interaction Center from Interactive Intelligence, Inc. Provided time
and cost savings by reducing by 50% the number of routine calls that employees in
the Billing and Underwriting units needed to handle.
o Responsible for the maintenance of the Executive Information System database,
using SQL Server 6.5.
Jonathan Helm page 3
Providence Washington Insurance Company (continued)
Applications Programmer Analyst 1989-1997
o Designed, developed and implemented an Access97 database application for
claims checks from the AS/400. The project became key to Financial and Claims
Department identification and reconciliation of internal accounting
discrepancies, eliminating approximately 1 day of manual work per month.
o Developed the data conversion from an IBM mainframe to an AS/400 platform in a
team environment, for both online and batch statistical applications and data.
o Designed and developed the Casualty Limits Profile reinsurance system,
resulting in a significant upgrade in processing and reliability for reinsurance
treaty negotiations.
Hanover Insurance Company Worcester, Ma
Senior Systems Analyst 1986-1989
o Implemented Claims Foreign File charge-back system, increasing the accuracy of
intra-company budgeting. Developed the interface to an external general ledger
package.
o Project Leader in the development and installation of a Casualty Reinsurance
system.
o Designed and developed applications for Commercial Automobile Analysis,
Policy/Claims Summary, and Internal Company Statistics.
Education
Bachelor of Science in Computer Information Systems
Bentley College, Waltham, MA
June,1986
|
