Michael Borek Email & Phone Number

Ensure AIG maintains compliance by providing data and reports to regulators like theDepartment of Insurance and Insurance Bureaus in the U.S., Canada and Puerto Ricofor assigned data calls. Also supports production systems to ensure that dataproduced is accurate.

• Business Lead for Finance and John Hancock Integration.
• Worked closely with the Finance Team to establish and test 1400 plus accounting items for the Life Finance System and the General Ledger.
• Responsible for testing 118 touchpoints for 56 systems for the Life Admin System Consolidation (LASC) project.
• Tested the Lockbox, ePay and EFT payments to integrate into the new WMA Admin system.
• Triaged defects in the HP ALM system and held meetings with the business, vendor and QA.
• Coordinated quarter end backups.

• Business Analyst working with the Finance team 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.
• Wrote requirements, reconciled Reserves, Unearned Premiums and AR Balances and, validated multiple tables and fields.
• Tested the Stage environment, the UAT environment and, ultimately verified production.
• Worked on production issues including reloading 90,000 plus transactions and millions of dollars in premium.

• Worked on multiple projects in the Specialty Lines area to enhance various systems and resolve production issues.
• Implemented the BONDirect Upgrade project which included 40 releases and 3 years of discretionary projects.
• Overall management of projects from requirements gathering to development, testing and implementation.
• Conducted meetings with the business and vendors along with technical staff to develop and implement new and enhanced software.
• Participate in project meetings to plan the implementation schedule of projects and to resolve issues with timeframes and resources.

• 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.
• 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.
• 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.
• 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.
• On loan to the Bond Department to analyze and document their workflows using Visio. The analysis included determining straight through processing and documenting pain points.
• Worked on the OneBeacon ACT (CPP) project to help convert part of the $400 million in premium from OneBeacon to The Hanover Insurance Group which included the expansion of Hanover systems to process new programs within.

Berlin, Vermont, US

• 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.
• 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.
• Analyzed data requirements and created Functional Specifications for the Correspondence system consisting of Student Certification Letters, Student Re-Certification Letters, Incapacitated Letters, Age 65 Letters.
• 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.
• Worked closely with the Finance Department to documented specifications for financial reports.

Jacksonville, FL, US

• Analyzed specialty lines including California Earthquake Authority (CEA) policies for the state of California and Assigned Risk policies for the state of New York.
• Implemented new client companies into the CEA product line, created business specifications and test plans and, performing quality control.
• Used Visio and diagramed the New York Assigned Risk process flow.

Bedford, New Hampshire, US

• Analyzed and documented the conversion process to migrate Property and Casualty policies from the mainframe to a.NET environment. Member of an evaluation team to purchase a new Policy Management system (Duck Creek was.
• Member of an evaluation team to purchase a data warehouse (Millbrook was selected). Used UML/Use Cases to define the personal automobile new business and endorsement systems.
• Managed all aspects of a project life cycle including Business Specifications, User Sign Off, Technical Specifications, Construction, Unit & System Testing, Quality Assurance, Change Control, Implementation and Post.
• Other responsibilities included the management and analysis of the Personal Automobile, Business Automobile and Business Owners lines of business to implement new company products and enhance existing systems/products.

Bedford, New Hampshire, US

• Responsible for all IT services for Underwriting, Customer Service, Marketing and, various other departments when needed. Responsibilities include: premium rate revisions for all lines of business for a $170 million.
• Projects managed included on-line and batch systems, ISO statistical reporting, accounting routines, declarations, bills, new business, endorsements, non-payments, cancellations, renewals, etc.

Bedford, New Hampshire, US

• Managed all aspects of a project for the Personal Automobile, Business Automobile and Business Owners lines of business to implement new company products and enhance existing systems/products which included on-line and.
• Created and maintained project plans, delivered IS strategies to user departments and, delivered oral presentations to Independent Insurance Agents.
• Also, managed the implementation of a lienholder database and a claims policy history database.

Bedford, New Hampshire, US

• Analyzed and evaluated Server and Mainframe software. Prepared “Statement of Work Summaries” and “Cost Analysis” reports.
• Derived alternatives and recommended solutions for many projects.
• Considered the “Auto Expert” for the 3rd largest Personal Automobile Insurer of Northern New England

Bedford, New Hampshire, US

• Automated the Business Automobile (BAP) line of business which included: analyzing and programming on-line and batch policy management systems; programming premium rates for all vehicle types, all states, all.
• Automated the Business Owners (BOP) line of business which included: analyzing and programming on-line and batch policy management systems; programming premium rates for Apartments, Offices and Mercantile locations.

Bachelor Of Science (Bs), Business Management

Associate Of Science (As), Computer Science