JOHN P. HEGARTY

** ******* ****

Sandy Hook, CT *6482

203-***-**** Cell 203-***-****

acuws8@r.postjobfree.com

SUMMARY

IT Professional with over twenty five years of managing, analyzing, developing and supporting proprietary and COTS applications on IBM iSeries and AS400 systems within the ERP Manufacturing, EDI, Accounting and Insurance sectors. Proficient in various system development lifecycle (SDLC) methodologies and the project management phases ranging from project planning to user acceptance testing (UAT). Expertise in analyzing and developing RPG ILE, CL and SQL Programming and AS400 System Administration. Skilled in the data analysis, data warehousing, data governance and data quality assurance of DB2 files, libraries and databases. Reliable and committed in meeting with stakeholders, obtaining business requirements, managing resource teams, developing project plans, scheduling timelines and developing/testing software applications.

TECHNICAL SKILLS

SYSTEMS: IBM AS400, IBM iSeries, DB2, SQL Server, Windows 10

TECHNICAL LANGUAGES: RPG III, RPG ILE, RPG Free, CL, COBOL, SQL, XML, SFTP, PGP

COTS: Access, Aldon, AlFresco, BPCS, Business Objects Crystal Reports, Citrix, Cognos, Epic, Excel, Explorer, Genius, GoAnywhere (Linoma), Hawkeye, HPQC, ImageRight, Implementer, Kronos, Lawson, Lync, Optio, Outlook, PRMS, Project, Salesforce, SharePoint, Surveyor, Turnover, Trustedlink EDI, Visio, Word, Zendesk

EXPERIENCE

IT Consultant/ AS400 RPG Developer

ITECHS Consultants, Sandy Hook, CT 2014 – Current

Independent Consultant providing professional IT project management, analysis, software development and delivering overall quality assurance for Stirling Benefits, Phillips Van Heusen and MBI Inc..

Meets with business stakeholders to understand and define the business requirements of Lawson HRIS IT projects. Analyzes requirements and develops business requirements documents (BRDs) and functional specifications to scope the ETL enhancements of a major HRIS employee benefit and timekeeping system interface. Analyzes and develops RPG Free programs to extract, transform, convert and migrate data from a Lawson HRIS DB2 database to a new Kronos SAAS Cloud-based application. Ensures that IT projects successfully complete the SDLC and data quality assurance.

Develops, maintains and supports custom RPG Free, CL and DB2 database files within IBM iSeries/AS400 servers to establish the production of an interface that extracts incoming EDI Invoice, FedEx Small Pack and LTL Freight data from the Epic CMS database and compares the quoted and actual freight costs from transport carriers. Facilitates meetings with business stakeholders to understand and obtain IT project requirements. Analyzes project, requirements, creates project plans and requirements, plans and proposals; develops AS400 RPG and Embedded SQL code to generate EDI claim data transfers.

Accomplishes data governance and data quality assurance of ETL projects to accurately produce EDI data exchange processing of client and TPA insurance claim exports. Analyzes database project needs; performs data modeling and SQL data mining; creates AS400 EBCDIC to ASCII data conversions; SQL data mapping; SQL script to develop ETL data marts and staging files; mitigates data related issues; and performs SFTP and TrustedLink EDI import and export data feeds.

IT Project Manager/ Senior Developer

Hub International, New York, NY 2011 - 2014

Manages staff, analyzes, develops and supports Insurance and Financial IT software applications.

Responsible for the IT project management, hands-on development and support of Commercial Property and Casualty Insurance IBM AS400 RPG Free and CL applications and DB2 PF files. Met with business stakeholders to collect pro

ject requirements and conduct storyboard sessions. Created MS projects plans and functional specifications based on the business requirements. Developed Visio data flow charts and Excel data mappings to layout tables for the import/export of data files. Performed SQL data mining to accurately align and map CSC import/export data formats. Organized meetings with business managers and IT executives to communicate IT project status.

Conducted the research and analysis of claim data project requirements; performed data modeling, SQL data mining and data mapping; developed RPG program interfaces, data warehouse, data marts and staging files to store mapped data; created RPG program migrations to Linoma software; mitigated and corrected data-related issues; and performed SFTP import and export of data feeds. Developed RPG and SQL procedures to perform the automation of data import and export of ITD claims data transactions. Conducted the unit testing, regression testing, and data governance to ensure the overall data accuracy and quality assurance of data feeds.

Created project plans for P&C policy lifecycle and claim projects; developed RPG programs to develop bordereau reports to include policy, premiums, claimant, claim payments, reserves, subrogation, service fees and total incurred amounts; created procedures to produce catastrophic ISO loss reports; developed SQL programs and data warehouse files to generate ETL policy and claim data exports to partnered insurance carriers and TPAs.

IT Consultant/ Senior RPG Developer

Starpoint Solutions, New York, NY 2009 – 2011

Contracted to analyze, develop, maintain, and test Lawson Financial applications for Phillips-Van Heusen.

Developed, enhanced and tested Lawson HRIS/AS400 RPG user-exit programs, database files and Lawson display screens to be viewed with Lawson system portals. Creates file transfer solutions to export EFTs consisting of ACH file formats and develops Automated Invoice Payment systems that permit the inquiry and approval of individual invoice detail records.

Analyzes, develops and tests AS400 RPG programs to extract and transfer/FTP Lawson Employee HR/Benefit Administration DB2 files to life/health insurance carriers which include MetLife, John Hancock, Aetna, and Caremark. ETL data file formats include information related employee long term care, employee disability wages, health/dental insurance plans, Cobra benefits, flexible spending data and other payroll deduction amounts.

IT Consultant/ Senior RPG Developer

ITECHS Consultants, Sandy Hook, CT 2007 - 2008

Sole proprietor of a consulting company that provides professional IT analysis and software development for Hub International Northeast Insurance Brokerage.

Develops, maintains and supports custom RPG programs on IBM iSeries and AS400 servers to establish the production of an Automated Property and Casualty Insurance Claims Interface. Designs and develops RPG, CL, DB2 and SQL programs to extract, transform and load MGA/TPA claim data feeds. Ensures all completed IT projects meet user acceptance testing (UAT).

Administers full SDLC methodologies to deliver IT solutions and accomplish insurance claims business projects that reduced operational deployment time by 30%. Facilitates on-site meetings with IT staff, claims users and all stakeholders to collect IT project requirements. Conducts project interviews and storyboard sessions with business users to procure project solutions. Creates MS Project solutions to communicate tasks, timelines and deadlines; and obtains management approvals for the IT project specifications. Creates data flow diagrams and documentation to define the project scope and functional specifications.

Senior Analyst/ RPG Developer

Endurance Reinsurance, White Plains, NY 2003 - 2007

Responsible for the analysis, development, testing and support of Xchanging Genius Insurance and Lawson Financial systems.

Analyzed, created, maintained and tested a custom proprietary Xchanging Genius/ Lawson GL interface system. Interacted and gathered project requirements from business and IT management teams. Analyzed and created proprietary AS400 RPG and CL programs that extracted insurance DB2 data consisting of premiums, claims, reserves and cash journal

transaction data; converted, mapped and transformed all data amounts by mapping accounts and summarizing amounts; and uploaded data accordingly into the Lawson General Ledger on a SQL server.

Developed, maintained and tested SQL Server script to create/update RDBMS tables and views. Created procedures to transfer data to SQL Server and periodically update data to refresh Chart of Accounts and Financial Tables. Produced ad-hoc Business Objects Crystal Reports and MS Excel programs to reconcile original currency, base currency, foreign exchange and unrealized gain/loss Lawson Ledger account balances.

IT Director/ Senior RPG Developer

Waterbury Companies, Inc., Waterbury, CT 2000 – 2003

IT Infrastructure and Applications Supervisor responsible for the analysis, development, testing and support of a PRMS ERP system.

Interacted with all levels of users to create project plans, facilitated meetings, produced project proposals, defined resources, and developed documentation. Developed, maintained and tested PRMS ERP Manufacturing, Data Warehousing, EDI Processing and Accounting applications utilizing RPG ILE, CL and DB2 on IBM iSeries/AS400 servers. Created physical file members in a multi-plant environment to distinguish data from each manufacturing plant. Created EDI interfaces and RPG ad-hoc reports to report sales orders, purchase orders, back orders and inventory data by product and sales territories.

Developed and applied infrastructure to complete the acquisition of a Canadian manufacturing facility. Researched, planned, installed and applied IBM PTF and AS400 operating system upgrades. Procured and supported network installations of DSL, ISDN, Ethernet, Frame Relay and T1 networks. Developed and proposed plans to perform the AS400 CPU/ disk storage migrations to improve system resources, provide faster retrieval of data and increase user productivity by 25%.

EMPLOYMENT HISTORY

AS400 Project Manager Fort James Corporation/Georgia Pacific, Norwalk, CT 1998 – 1999

AS400 Programmer/ Analyst Daymon Worldwide, Old Greenwich, CT 1996 – 1998

AS400 Programmer/Analyst United Distillers/ Diageo, Stamford, CT 1995 – 1996

AS400 Programmer/ Analyst A&W Brands, Inc., White Plains, NY 1990 – 1994

EDUCATION

B.A., Computer Science, Pace University, White Plains, NY Magna cum Laude

Contact this candidate