Senior Data Engineer (Burlington, CT)

Effective at applying statistical analysis, text and data mining techniques to solve business problems in such areas as Actuarial, Claims, Underwriting, Marketing, Reinsurance, Human Resources and Analytical Units.

BUSINESS EXPERIENCE:

Full Capture Solutions, Inc. (FCSI) 2005-2007
Providing Text Mining Analytics for the Insurance Claim Industry to determine Liability for Subrogation purposes by reading claim adjuster notes (Automobile, Property and Workers Comp).
Senior Data Engineer

• Designed, created and implemented the necessary tools to improve Text Mining Models.
• Developed and implemented new concepts for Text Mining Analytics.
• Developed and designed Model Score Effectiveness on Text Mining Variables, built composite client warehouse to evaluate current models across clients for improvements in Text Mining.
• Automated Statistical Text Mining Models to better utilize Staff resources and bring consistency to the modeling process.
• Evaluated and improved techniques for scoring clients’ data.
• Researched activities in handling text mining solutions and improvements to build more effective models.
• Re-calibrated client models when Text Mining Models changed and evaluated scoring impacts.
• Provided ETL for clients’ data in preparation of modeling activities.
• Mentored new staff members in learning Text Mining Methodologies.

Deloitte &Touche – AQS (Advance Quantitative Services) 2004-2005
Senior Consultant

• Created Underwriting Risk Models for Insurance Industry clients (Automobile and Property).
• Performed ETL for clients’ data in preparation for modeling.
• Created and implemented Matching algorithms to enhance client data with information from such sources as D&B and Experian.
• Developed data utilities to improve staff productivity and meet target deadlines.
• Mentored and advised existing staff in using the SAS software effectively to produce client models.
• Participated in projects where and when needed.

The Hartford Insurance Group-Corp. Actuarial 1994-2004
Senior Actuarial Consultant

Project: SAS application under ALPHA/VMS system
Cash Flow Model for $6 Billion Premium Revenues
30 Lines of Business, 4 Billing Systems, 25 Bill Plans
5 Payment Credit Plans with payment cycles of up to 48 months
Ability to Forecast Cash flow on a monthly basis using Monthly parameters for a 30 month period

Working without specifications, created a working model in 4 weeks using Annual vectors. After reviewing the draft model, customer needed to define the requirements and necessary data/systems for further analysis to produce an enhanced application to reflect the actual business activity. Design switched from annual vector parameters to monthly with additional enhancements within a 4 week period. Client is completely satisfied and project completed on time.

Developed and implemented web-enabled Corporate Profit Model using SAS and Excel. Ongoing project with continuous enhancements, including deploying Data Warehouse, Data Mart and Data Mining capabilities.

Self Employed 1993 - 1994
PDPC, Ltd.

Hartford Steam Boiler Inspection and Insurance Company 1979 - 1993
One State Street, Hartford, CT
Manager, Reinsurance Services 1986 - 1993

Developed new reinsurance automation systems to enhance flexibility of marketing strategy while supporting marketing staff and clients to increase market share and create market barriers for competitors.

* Manager, Financial Analysis and Budgeting 1984 - 1986

Developed expense allocation programs, computer models to forecast insurance premiums, and on-line distributed budgeting system. Re-engineer budget work flow and process.

* MIS Consultant and Manager, Statistical Department 1982 - 1984

Supervised staff of twelve providing accurate and timely management reports of $300 million insurance revenues. Re-engineer work flow and cross training to manage staff reduction and increase productivity.

* Personnel Consultant 1981 - 1982

Created ad-hoc reporting system for company officers on human resource management issues: personnel administration, manpower planning, employee benefits, employee expenses and training.

* Information Consultant 1979 - 1981

Evaluated, installed, and maintained commercial software used by clients. Supervised two professionals responsible for the support and training of 300 clients in the use of end user computer tools.

Aetna Life & Casualty, Hartford, CT
Studies Specialist 1978 - 1979

Produced statistical studies used to maintain company rate bases.

Life Insurance Marketing Research Association (LIMRA), Farmington, CT
Senior Research Associate 1976 - 1978
Developed studies used for financial marketing.

Education, Certifications and Affiliations:

• BS in Mathematics, Central Connecticut State University
• 40 Graduate hours in Statistics, QPA 3.9
• Society of Actuaries I & II, LOMA I & II, HIAA I & II
• Association of Internal Management Consultants - Northeast Program Director
• Hartford Area SAS Users Group - Founder, Committee Member & Former Chairperson
• SAS Consultant Special Interest Group - Founder and Webmaster

• SAS expert in building management information systems and applying statistical techniques: BASE, FSP, AF/SCL, Graph, STAT, ETS
• Skilled in MVS/TSO, VM/CMS, Unix, APL, MS-DOS, WINDOWS, WORD, EXCEL, ALPHA/VAX, QMF, SQL, DB2, Oracle

LIMRA Aggregate Expense Analysis, LIMRA 4 Year Long Term Lapse Study
The Fuzzy Feeling SAS Provides - Electronic matching of files without common keys
SAS Resources on the Internet - WWW.SAS.RESOURCES.HELP
SAS, EXCEL and the Intranet
Conference Speaker - Institute for Graphic Communication, HASUG, BASUG, NYSUG, NESUG, DCSUG, SUGI

Addendum of Statistical, Modeling & Consulting Assignments

Miles, Inc:

• Complete level 1 to level 2 data conversion for two FDA drug submissions (Nisolidipine and Nimodipine). Developed automated tools to aid in FDA documentation of programs and data conversions. These tools saved approximately one man week per drug in the documentation process. Finished project ahead of schedule and to satisfaction of client. Used MVS/TSO and SAS system.
• Developed numerous statistical tables and customized reports for Nimodipine according to client's specifications. Incorporated these on-line reports into existing ISPF menus. Finished project ahead of schedule and to complete satisfaction of customer. Used MVS/TSO and SAS system.
• Designed and developed an on-line computer hardware and software inventory system of personal computers and various hardware components. Finished project in one week and ahead of schedule which included converting data from WordPerfect. Used MVS/TSO, AF/SCL, FSP/SCL and SAS system.

• Convert Easytrieve ad-hoc reports to SAS reports. Build an on-line menu selection/parameter driven reporting system. Will convert the above system to SAS/AF/SCL application when client acquires SAS/AF. On going project with no dead lines.
• Automate eligibility data for Third Party Vendors. Convert manual and tape creation of data submission to Electronic Data Transfer. Involves fourteen vendors and approximately forty clients. The intent is to reduce the manual effort of submitting data to vendors and eliminate human error.
• Document and create new QMF and SQL queries for business analysts of unit. Once SAS/AF and ACCESS is acquired, convert existing and new QMF queries to an on-line selection/parameter driven SAS/AF SQL Reporting system.

• Re-engineer current method of delivering reporting services to clients. Stream line and increase productivity of reporting services utilizing current SAS and MVS utilities. Managed to increase productivity by 20% within 1 month for reporting services personnel while increasing accuracy to 99% of all scheduled production runs.
• Maintain current reporting structure while developing new reports for clients. Developing new and more effective ways to deliver information to customers within existing environment. Using SAS Macros to make existing and new reports parameter driven to increase flexibility for customer requests.
• As the need arises, will migrate existing reporting systems from MVS environment to Client Server platform utilizing MS products and PC SAS.

Contact: Contact information available to DataShaping clients.

URL: www.datashaping.com/resumes16183r.shtml
Please mention datashaping.com when contacting me. Thank you.