Senior IT Professional

Location:

East Merrimack, NH, 03054

Posted:

January 11, 2025

Contact this candidate

Resume:

MICHAEL P. BOREK - CBAP

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

Webster NH 03303

Cell Phone: 603-***-****

*************@*****.***

SUMMARY: Certified Business Analyst Professional (CBAP) with over thirty years of experience in the Information Technology Industry (IT). Documented Business Requirements and received approvals from stakeholders for over 20 years. Programmed for over 20 years. Created SQL Queries, analyzed data and produced spreadsheets and reports from data warehouses for the Business. Mapped various data requirements in SQL, DB2 and Oracle databases which included TOAD and, verified the data in the data warehouses. Led testing efforts and created test plans and test cases. Analyzed and documented business workflows using Visio with swim lanes which included determining straight through processing, documenting pain points and documented As-Is and To-Be processes. Implemented the BONDirect Upgrade project (Surety) which included 40 releases and 3 years of discretionary projects. Responsibilities included the overall management of projects from requirements gathering to development, testing and implementation which included solving production issues. Conducted meetings with the business and vendors along with technical staff to develop and implement new and enhanced software. Participated in project meetings to plan the implementation schedule of projects and to resolve issues with timeframes and resources. Worked at John Hancock Manulife on the Life Admin System Consolidation (LASC) project as the Business BA Lead for Finance and Integration responsible for testing 118 touchpoints for 56 systems. Also, worked closely with the Finance team at John Hancock on testing and establishing 1400 +/- accounting items for the General Ledger and triaged defects in the HP ALM system. Subject Matter Expert (SME) for the Surety line of business for The Hanover Insurance Group and SME for Concord Group Insurance on various lines of business. Worked with many departments at BCBS of Vermont to reposition their financial billing system into a vendor system for accounts receivables which included lock box payments, bank scan lines, financial data and financial reports. Also, worked on BCBS requirements for accounts payable. My requirement documents at BCBS of Vermont is being used as a model asset.

Experiences include Lead Analyst, Senior Business Analyst, Senior System Analyst, Data Analyst, Business Development Manager, Project Manager, QA lead, Programmer/Analyst and Operations.

Past experiences include working closely with Senior Management and other company personnel; leading requirement gathering sessions; presenting requirements to large group of stakeholders; receiving approval for requirements from stakeholders; providing guidance to Technical Leads and developers; creating Change Control documents; providing estimates and; holding meetings with stakeholders to determine options and ultimately a solution.

Managed multiple projects simultaneously to meet federal and state requirements, managed new application development, evaluating vendor software packages, analyzed and documented data requirements and managed and evaluated IT staff. Over the years, was involved in multiple conversion projects with various SDLC processes.

VOLUNTEER

SUMMARY: Selectman for the Town of Webster:

Managed the affairs of the Town of Webster including the Police Department, the Fire Department, Highways and Roads and, Administration. Created the yearly annual budget and established the Annual Report. Wrote contracts for the Chief of Police and the Financial Administrator. Conducted bi-monthly meetings to handle the business and organizational structure for the Town of Webster.

Chair for the Hopkinton Webster Landfill Committee

President of the Pillsbury Lake Building Committee

Chair of the Church Council for the Webster Congregational Church

Trustee for the Webster Congregational Church

Coordinator for the Franklin Rise Again Ministries

SOFTWARE/

HARDWARE: Sharepoint, Lotus Notes, Requisite Pro, HP Quality Center/ALM, ChangeMan Version Manager, Oracle, Toad for Data Analyst, SQL, DB2, Content Manager, Service Now, Service Center, BONDirect, ACT, CAAMS, ARF, AVE, PLUS, POS, PMS, PowerMHS, Outlook, BPM, System Development Methodologies, Unified Modeling Language (UML), Use Cases, Microsoft Project, Microsoft Central, Groupwise, HEAT, Microsoft .NET, .NET Framework, Visual Studio, ADO.NET, ASP.NET, C#.NET, VB.NET, Portals, Word, Excel, Access, PowerPoint, Visio, AL3 (ACORD), HTML, XML, C++, VB, COBOL, RPG, PROGENI, MGLE, JCL, CANDE, WFL, MVS, VSAM,V4, AS400, ISeries, IBM Mainframes, Xerox Printers, Unisys Mainframes, Frame Rely, IBM Servers, Various Other Servers, PCs

EDUCATION: Franklin Pierce College – Rindge, NH

BS – Business Management

Valedictorian, Summa Cum Laude

Franklin Pierce College – Rindge, NH

AS – Computer Science

GPA 4.0

George Washington University – Washington, DC

Professional Certificate in Business Analysis (CBA)

New Hampshire Technical College – Concord, NH

Microsoft .NET Technology Certification

Keane, Inc.

Project Estimating and Risk Management Certification

Insurance Institute of America

Certificate in General Insurance

Northeastern University – Boston, MA

Artificial Intelligence Certification

PROFESSIONAL

EXPERIENCES: Senior Business Analyst – AIG Insurance – 1/2017 through 8/2024

Responsibilities included ISO and Regulatory filings for various states throughout the United States and Canada using various tools including Word, Excel spreadsheets, Pivot Tables, Portals, COBOL programs, etc. Filings were due throughout the year and my filings were always on time. Met with various state auditors on requirements and to answer any questions and to review large amounts of premiums and losses from AIG which was not the norm for insurance carriers.

Was the point person for all COBOL processes for the department. Developed and upgraded COBOL programs as needed for the various filings for all states. Also, was the go-to person for anyone who needed assistance with any COBOL process.

Eliassen Group – Senior Business Analyst - Contractor working at John Hancock

Business BA Lead for Finance and JH Integration – 12/2015 through 10/2016

Responsible for 118 touchpoints for 56 systems for the Life Admin System Consolidated (LASC) project. Worked closely with the Finance team at John Hancock to test and establish 1400 +/- Accounting items for the Life Financial System (LFS) for the General Ledger. Worked closely to test ePay, Lockbox and EFT payments to integrate into the new WMA Admin system and verifying (testing) downstream systems continue to process correctly including LFS, Lawson, Corp. Treasury, ServiceNet and, SalesNet. Worked on correspondence for premium bills, annual statements, cancellations, etc. Also, worked closely with the Valuation, Inforce Illustration and Privacy teams.

Triaged defects in the HP ALM system and held meetings with the vendor, business, QA to resolve defects. Provided an integration testing spreadsheet for all downstream areas from the new Admin system which includes dates, application managers and sign-off managers. And, coordinated the backups of quarter-end files to establish criteria for downstream system testing.

KForce – Senior Business Analyst Contractor working at Swiss Reinsurance

Business Analyst – 4/2015 through 10/2015

Worked with the Finance team at Swiss Reinsurance. Main Business Analyst on the conversion to the Ceded Reinsurance Accounting System (CRAS). Used SQL queries and TOAD for BA to analyze, report on, download to Excel and ultimately transform data. As a contractor, responsible for writing requirements, reconciling Reserves, Unearned Premiums and AR balances and, validating multiple tables and fields. This position focused on testing the Stage environment, the UAT environment and, ultimately verifying production. Responsibilities include verifying the conversion, technical changes, reconciliation and overseeing specifications. Worked on production issues including reloading 90,000+ transactions and millions of dollars in premium.

The Hanover Insurance Group – Worcester, MA

Business Analyst/Project Manager, 10/2012 to 11/2014

This position included the overall management of projects from requirements gathering to development, testing and implementation. Subject Matter Expert (SME) for the Surety line of business for The Hanover Insurance Group. Handle all Baseline projects and production issues for the Hanover Insurance Group for the Surety line of business. Gathered and documented all requirements for projects in Sharepoint. Also, documented procedures in Sharepoint for the business and for the technical staff. Analyzed data from a vendor’s system and from the company’s data warehouse. Used TOAD to produce SQL queries. Acted as a Business Intelligent BA to analyze data for the business. Downloaded data into Excel spreadsheet for further analysis and produced reports for the business. Also, mapped various data requirements for projects. Created test plans and test cases, worked with QA on test plans and test cases and resolved defects with the business and vendors. Conducted meetings with the business and vendors along with technical staff to develop and implement new and enhanced software. Participated in project meetings to plan the implementation schedule of projects and to resolve issues with timeframes and resources. Worked closely with the vendor and was their main contact for various projects. Recently, implemented the BONDirect Upgrade project which included 40 releases and 3 years of discretionary projects. Managed all testing for this upgrade which involved daily meetings with the business, vendor, developers and testers to determine the status of the project and the necessary steps, including fixes, to keep the project on time.

Dextrys/Veritude – Worcester, MA

The Hanover Insurance Group

Consultant working as a Business Analyst, 6/2009 to 10/2012

Was a major participant in the creation of the Bonds Underwriting System (BUS) to capture all account business for the Bonds Department. The BUS was considered the number 2 best projects of 2012. Rewarded with a large bonus for this project. The new system streamlined the Underwriting process to analyze account business to make informed decisions. Responsibilities involved meeting with the business (Contract and Commercial) to gather requirements, meeting with the vendor to determine the integration, designing UI screens, analyzing current functionalities, providing guidance on new capabilities, creating workflows diagrams, presenting ideas to the business and to the Technical staff, mentoring other BAs, reviewing requirements and specifications with the business and Technical Staff, working with the Technical Lead on developing the system, working with QA to test and resolve defects, creating Change Control documents, working with the Technical Team to implement the system and servicing any problems in the warranty period. Presented the new system to upper management and received approval for the system. Part of this project was setting up new DB2 tables for the BUS.

Worked with the business to analyze and document their workflows using Visio with swim lanes. The analysis included determining straight through processing, documented pain points and documented AS-IS and TO-BE processes. Acted as an ETL (Extract, Translate and Load) Analyst on multiple conversion projects for Hanover Insurance.

Worked on the Professional Lines systems to streamline the process for agents. Condensed the number of screen needed and eliminated the Account View system to improve workflow and time it takes for agents to write Professional Liability.

Worked on the “OGC120 Compliance Assessment for MA PII” project to discover, monitor and prevent Personal Identifiable Information (PII) from being misused at the Hanover Insurance Companies. And, worked on the “OGC140 Advanced eDiscovery Assessment and Vendor Eval” project to create an RFP to select a vendor to discover and protect Electronically Stored Information (ESI) for the Office of the General Council.

Another responsibility included, analyzing various systems at The Hanover Insurance Group to expand the available time for the Point of Sale (POS) system to nearly 24 hours a day. Worked very closely with the Project Manager, SMEs, Solution Architect, Technical Lead, QA lead and others.

KEANE, INC. - Boston, MA

Blue Cross Blue Shield of Vermont

Principal Consultant acting as a Business Analyst, 5/2006 – 1/2009

Lead Business Analyst in converting the legacy billing system to the PowerMHS billing system. The conversion incorporated the Account Receivable system for invoicing Direct Pay, Safety-Net and Groups accounts and receiving lockbox payments. Also included were cancellations and reinstatements, data warehouse loads, broker commissions, financial data and building historical data for the new system. Facilitated sessions to determine options for converting the Account Receivable system and recommended a solution which was used. Created Functional Specification Documents (FSD) from Business Requirements and proposed various solutions to accommodate the use of the new system. My FSD was used as the model asset for Keane Inc. Part of this project involved running various billing jobs to test the billing functions and working on Group, Account and Subscriber/Membership screens.

Performed the analysis and documented data requirements to be extracted and stored on a secured internal network to be retrieved by the “My Accounts” application, developed by SMC Partners LLC, on a native DotNetNuke (DNN) framework for an Employer Web Portal.

Created an FSD for Account Payables, Finance Reporting, GL, Capitation, and Refunds & Adjustments for the Upgrade project. The Upgrade FSD included the introduction of EFTs to BCBSVT, interest payments and the automation of Vision Service capitation. Also, worked closely with the Finance Department to documented specifications for financial reports.

NATIONAL GRANGE MUTUAL INSURANCE COMPANY – Keene, NH

Senior Business System Analyst, 2/2005 – 12/2005

Analyzed specialty lines including California Earthquake Authority (CEA) policies for the state of California and Assigned Risk policies for the state of New York. Responsibilities include: implementing new client companies into the CEA product line; creating business specifications and test plans; and performing quality control. Used Visio and diagramed the New York Assigned Risk process flow.