Lawrence Thill

Berwyn, IL ***** adrrly@r.postjobfree.com 630-***-****

PERSONAL QUALIFICATIONS/ATTRIBUTES

Passionate about data quality

Extremely detail oriented

Expert at identifying and resolving data quality issues

Highly adaptable to changing situations

Successful as independent contributor and as a member of a team

Committed to getting the job done

Able to multi task to accomplish goals

A skilled writer and communicator

PROFESSIONAL EXPERIENCE

Equifax, Skokie, IL (PayNet was acquired by Equifax) 2019-2021

Manager, Data Integration/Production

Managed the performance of two teams of two dedicated to

integrating new member commercial loan/lease data into our system and

loading and reviewing monthly production data for stability, completeness and accuracy

Provided final approval of all member integrations, enhancements, and conversions

Revamped all of our Excel based Diagnostics to expand the number of validation checks and decrease the required review time by 50%

Primary contributor to develop reporting requirements to identify and track suspension of commercial loan/lease payments in response to COVID as well as the issuance of PPP loans

PayNet, Skokie, IL 2013-2019

Senior Data Validation Analyst (2017–2019)

Developed Excel-based tests as well as associated SQL queries to generate the raw data files for testing and provide drilling capabilities into suspected data issues within multiple diagnostic tools:

Integrations Diagnostic - designed to ensure a new member's data or an existing member's conversion or enhancement data is ready to move into production,

Load Diagnostic - designed to ensure the monthly data file is complete and consistent with past data files and

Production Diagnostic - designed to identify whether the data submitted by members who purchased analytical products is fit for use.

Maintained/Updated diagnostic tools and the SQL queries supporting them.

Contributed to many ad hoc data research projects for the Analytics and Sales teams.

Data Quality Analyst - Level II (2013–2016)

Reviewed all member monthly data to ensure stability, completeness and accuracy.

Designed automated evaluation system of member monthly data which cut analysis time by 50%.

Developed numerous SQL-based tests for evaluating the reliability of specific data elements during the integration process for new clients.

American Association of Insurance Services (AAIS), Wheaton, IL 1988-2013

Manager, Data and Automation Support (2011–2013)

Took the lead in testing new statistical processing system (off AS400 to an Oracle database):

Redesigned/Updated all data validation rules (over 1,500 rules) within Excel-Based rules engine

Designed and documented 10,000 test records to ensure effectiveness of data validation rules

Verified that data was stored, processed, and validated properly.

Supported vendors seeking to implement AAIS Insurance Programs into their policy issuance and claims systems

Performed comprehensive review of non-AAIS business owner’s data to determine quality gaps. Found over 50% of reported rating units were not reported accurately. These findings allowed actuarial unit to utilize data to support AAIS loss costs without distortion.

Senior Data Analyst (2010–2011)

Maintained COBOL and VB.net data validation programs and added hundreds of data validation checks to increase accuracy of reported insurance data.

Wrote AAIS statistical record layouts in XML to provide alternate reporting options.

Constructed MS Excel-based rating worksheet for AAIS’s Commercial Properties line of insurance as a verification tool for a vendor’s proprietary rating engine.

Manager, Statistical Services (1996–2009)

Managed the performance of a team of two receiving, processing, and reviewing statistical data submissions and preparing all required regulatory reports.

Provided AAIS senior actuary with rate-making databases and special reports to support rate filings.

Achieved significant increase in the amount of ‘good’ data utilized to support homeowner rate filings (from 60% up to 95%).

Collaborated with programming staff to recommend additional logic for data validation programs.

Composed error messages (over 700) associated with the data validation rules.

Managed content, design, and format of all AAIS statistical plans.

Composed statistical education collateral to clarify reporting requirements.

Performed comprehensive review of key competitor’s reporting requirements to enable mapping of said data into our own reporting structure.

Statistical Specialist (1994–1996)

Supervised one person in receiving, processing, and reviewing statistical data submissions.

One of three team members to perform a comprehensive review of 12 different statistical plans to expand the length of the reporting record and to normalize all reporting fields and codes.

Performed a comprehensive review of data reporting concerns for over 100 different reporting companies in preparation of their transition to an expanded record layout.

Conducted local and out-of-state seminars to explain expanded reporting requirements.

Prepared all required regulatory reports (DOI’s, AIPSO, and NAIC) on behalf of our members.

Actuarial Analyst (1988–1994)

Received, processed, and reviewed incoming statistical data from reporting affiliates.

Prepared all statistical exhibits supporting increases/decreases to insurance rates/loss costs for several property and casualty personal and commercial lines of insurance.

Automated and streamlined creation of actuarial exhibits.

EDUCATION

Bachelor’s Degree, Mathematics – Cornell College, Mount Vernon, Iowa

SOA/CAS (Actuarial) Exams 1, 2, 3A, 3C and CAS Exam 3B

TECHNOLOGIES

Strong knowledge of Excel

Fluent knowledge of Word

Strong knowledge of SQL (not a developer)

Some exposure to COBOL, VB.net and XML

Contact this candidate