Robert G. Deckman
- Business Analyst
- Boston, MA
- Member Since Jun 15, 2023
Robert G. Deckman
PROFILE
A Business Analyst and Computer Programmer professional with many years of experience in testing, creating and maintaining computer software. Experienced in Property and Casualty Insurance software, manual and automated testing across Client Server, Web and Mainframe. Have experience with E-Commerce, Data Mapping, Data Analysis, Creating Reports, Business and Requirement Analysis.
TECHNICAL EXPERIENCE
Microsoft Suite, Brio/InfoAccess, Hyperion Web Client, EIS Dashboard, SAS Enterprise Guide, IWE, Adobe, Sharepoint, Cognos, MS Access, SPAIS, Excel - Visual Basic, SQL, OneNote, Point Of Sales, TSO, Microsoft Windows ,Statistical Analysis and Thinking Skills, Knowledge of Actuarial and Pricing concepts, Test Strategies (Regression, Negative, Stress, Load, System), Market and Regulatory research tools, including rate and form circulars issued by Rating Bureaus, Analyze financial results, profitability, and forecasting, Development Life Cycles (Integration, User-Acceptance (UAT), Mock, Live and Production)
· Reporting Analysis |
· Project Management |
· Communication Skills |
· Programming Experience |
· Data Analysis |
· Process Improvements |
· Testing Analysis |
· Application Development |
· Project Life Cycle |
PROFESSIONAL EXPERIENCE
Liberty Mutual Insurance, Boston, MA 03/2011 – 03/2017 Created and Maintained the Business and Affinity GAP Reports.
Business Analyst II – Commercial Insurance Actuarial – Profitability Monitoring Reporting Team
· Enhanced and maintained the following Actuarial Metrics Reports: Business Insurance – Middle Market Gap Reports, Affinity Gap Report, Distribution/Underwriting Monitoring Tools, CSO/Involuntary Report, NUALP Premium Reports, AJG/HUB/USI Compensation Reports, and USI BOR/Acquired/Non-Acquired Reports
· Analyzed the metrics in each report and share results with the team
· For Ad-Hoc requests, provide Middle Market, LMAC(RCG), and Affinity datasets, pivot table reports, and SAS Code Projects
· Received two Bravo awards and two Thank You – Certificates from peers for exceptional work
· Attended the following training classes: Actuarial – Underwriting, Reinsurance, Involuntary Market, Ratemaking Part 1, Predictive, Modeling/GLMS, and CAT Modeling, SAS – Intro to SAS EG & Programming, SAS Macro Language: Essentials, SAS Programming 3: Advanced Techniques & Efficiencies, SAS Report Writing 1: Using Procedures & ODS, SAS SQL 1: Essentials, Others – Intermediate Excel, Business Writing, and Presentation Skills, Root Cause Problem Solving, Cognos – Report Studio
· Developed reports/dashboards (e.g., different data sources, date ranges, one-to-multiple relationships, data manipulation, multiple data displays, etc.) Utilized and built queries (using SAS or SQL) & macros to automate and share desired information.
· Interacted with other departments within Commercial Insurance for data, information and application support
· Created and maintained the department’s Sharepoint site
· Worked with other Commercial Insurance departments to provide and receive data files, methodologies, questions and solutions
· Tested and provided feedback for the new MMU Gap and UW Monitoring Tool Reports in Cognos
· Manipulate data in Excel, SAS, Access and other software, identifying and researching trends/anomalies
Liberty Mutual Insurance, Boston, MA 06/2006 – 03/2011
Created and Maintained the Auto Dislocation Models and Auto Reports.
Business Analyst II – Personal Insurance Reporting Team
· Enhanced, Maintained and included accommodating metrics for 4 reports using SAS, SPAIS and POSU data Reports: Auto New Business and Prior Carrier, Auto Data Accuracy, Prior Dec and Auto In-force Project. They are distributed to many different departments and higher management. (Including the President of Personal Markets)
· Using SAS and SPAIS to provided individuals with auto Ad-hoc data.
· Completed over 120 Auto Dislocation models for state reviews and numerous special requests.
· Received four prestigious Bravo Awards and ten Thank You – certificates from peers for exceptional work
· Added quality control methods and various documents to make the team more efficient.
· Provided auto dislocation model training for all state analysis.
· Attended the following training classes: Access Level 2, Pricing & Rating Making in Plain English, Latitude Series 1 & 2, SAS Enterprise Guide, OASIS/EDW/QSS, SPAIS, Excel VBA, Advanced Analysis, Presentation Skills, Lean 6 Sigma, Intermediate Data Retrieval, SPAIS through SAS EG and Managing Projects Effectively
· Able to communicate and interact with the regions/states analysts, DSO(s) and mangers to complete my work and to help others.
Liberty Mutual Insurance – Adecco Technical, Boston, MA 03/2006 – 06/2006
Created and Maintained the Auto Dislocation Models.
Business Analyst II – Consultant
· Learned about the Liberty Mutual Insurance Company.
· Started working on easier models.
· Provided data analysis for the team.
· Was able to work independently after 3 months with confidence.
· Trained myself to retrieve Inforce auto data, for the models, using Brio/InfoAccess.
CVS - Adecco Technical, Woonsocket, RI 08/2005 – 12/2005
Test Analyst for the Information Systems Department
Test Analyst - Consultant
Citizens Bank – Kenda Systems, Warwick, RI 12/2004 – 07/2005
Business Analyst/Quality Tester for the Conversion of Charter One Bank into Citizens Bank
Business Analyst/Quality Tester - Consultant
Allmerica Financial - Software Quality Associates, Worcester, MA 02/2004 - 05/2004
QA Tester for NJ Personal Lines Auto Insurance
QA Tester - Consultant
Allmerica Financial - Software Quality Associates, Worcester, MA 09/2003 - 11/2003
Data Mapper/Analyst - MIS - Integrated different Allmerica databases into one group database warehouse.
Data Mapper/Data Analyst - Consultant
The Hartford Insurance Group - Edge Technology Services, Farmington, CT 11/2002 06/2003
Quality Analyst for Personal Lines - Auto Insurance - Underwriting
Quality Analyst – Consultant
AMS Services Inc., Windsor, CT 06/1996 - 03/2002
Programmed and Tested Commercial and Personal Lines Auto Insurance
Programmer Analyst- Clients included The Hartford, Travelers, Cigna, Allstate, ISO etc
· Programmed in Turbo Pascal, Quick Basic and a high level proprietary language (ART) to create and maintain the legacy comparative rating products for automobiles in all states.
· Tested the comparative rating products by the following Test Strategies – (Regression, Negative, Load, System)
· Verified and tested data for each state specific insurance company manual. For example: The Hartford, Travelers, Cigna, Allstate, ISO etc.
EDUCATION
Associates Degree in Computer Science, Three River Community Technical College
Additional Courses: Statistics, Accounting, Numerical and Non-Numerical Computations, "C", Programming, Assembly Language, FORTRAN, DEC VAX/VMS, PASCAL and COBOL