Insurance Active Directory, mainframe, SQL records, XML files

WILLIAM J. WESTFALL

MACROBUTTON AcceptAllChangesShown Lebanon, IN *************@*****.*** MACROBUTTON AcceptAllChangesShown 317-***-**** HYPERLINK "linkedin.com/in/william-westfall-24b4931a" linkedin.com/in/william-westfall-24b4931a

Business / Systems / Applications Analyst

SELF-STARTER ● PROBLEM SOLVER ● ANALYTICAL ● QUICK LEARNER

ORAL & WRITTEN COMMUNICATIONS ● LISTENING

MACROBUTTON ACCEPTALLCHANGESINDOC SUMMARY OF QUALIFICATIONS

Dynamic leader that has made a career of utilizing technology to solve today’s tough business problems, with an expertise in the risk, insurance, agriculture, and financial arenas.

Deliver outstanding client services through clear communications, backed by excellent listening and systems skills.

Possesses solid applications, system development life cycle (SDLC) and extensive experience in IT to propose the correct technology for problem resolution.

Works well with ambiguity to develop insightful solutions with complete documentation.

CAREER ACCOMPLISHMENTS

Frequently requested by managers to be assigned to their projects, and even won a recognition award for this effort.

Cited for managing SOX audits as well as an innovative solution to an employee benefit problem with both saving time and passing audits with 100% accuracy.

Created an annual exposure report imputing raw data to identify areas of the country where the company’s exposure was too concentrated, creating data for the sales force to better target markets and improve profitability.

As a Product Specialist collaborated with a cross functional team providing the data which lead to several additional coverages at favorable prices and an increase in new auto policies.

PROFESSIONAL EXPERIENCE

Sabbatical 2016-Present

Substitute Teacher - Lebanon Community Schools

Took time off to spend the winter officiating high school basketball and volleyball games.

STATE AUTO INSURANCE, Indianapolis, IN 1998-2016

State Auto, based in Columbus Ohio, generates $2 billion in premiums from all 50 states, and has assets approaching $4 billion.

Identity and Access Management Senior Analyst, 2014-2016

Managed multiple applications including Active Directory, mainframe, distribution or security groups, email boxes, software and others.

Enabled critical functionality and customer access through timely additions and continuous updates to Active Directory including account creation / disabling passwords, and group administration.

Initiated customized user access for multiple applications: ProWatch (card access system), Guidewire software suite, IBM Netezza, Microsoft Outlook, policy mainframe, easy Vista (tracking tool and others).

Received State Auto kudos for providing documentation, support, and reports compliance audits ensuring correct access for each application, importing and formatting by Excel.

Performed many SOX audit requests with 100% compliance.

(Developer) Applications Analyst, 2009-2014

Senior team member with various business departments and assisted in the annual software upgrades and release management processes.

Led project work using Waterfall. Also familiar with Agile.

Trained a Business Analyst in Application Development to fully integrate into the department.

Led several country-wide projects resulting in ease of use upgrades resulting in improved productivity.

Configured and managed enterprise software used for rating personal insurance through web-based portal application and provided level 3 application support leading to 99.9% accurate quotes to customers.

Increased actuary staff efficiency by designing multiple in-house applications with Visual Studio 2008.

Lead developers in periodic code reviews to provide efficient and consistent coding changes.

Spearheaded the use of an enhanced procedure that led to error-free monthly migration moves.

Business Systems Analyst II, 2006-2009

Served in Lead role in the development of systems requirements for over 25 rate and regulatory projects; wrote analysis and design documents for regulatory requirements, including technical specifications for application modification.

Created business requirement documents supporting rate, form and rules changes as well as new product rollouts.

Product Specialist II, 1998-2006

Chaired product / form and rate review meeting for farm states, facilitating clear communication between product and production departments further boosting production.

AMERICAN STATES INSURANCE COMPANY, 1990-1998

American states operates today as a subsidiary of the $6 billion Safeco Insurance, which is member of the $38.5 billion Liberty Mutual Group.

Product Staff Specialist 1992-1998

Filed rate / rule / product revisions and program rollouts with state insurance departments.

Updated agent manuals in personal lines and created new offerings in the auto lines.

Personal Lines Underwriter 1990-1992

Underwrote auto, home, dwelling, and fire accounts to ensure profitability.

Reviewed existing policies to ensure correct premiums were applied to cover risk.

EDUCATION AND TRAINING

Bachelor of Science, Urban Studies, School of Public and Environmental Affairs MACROBUTTON AcceptAllChangesShown

INDIANA UNIVERSITY Bloomington, IN

FURTHER PROFESSIONAL EDUCATION

Certified Property and Casualty Underwriter (CPCU) Associate in Management (AIM)

Associate in Underwriting (AU) Associate in Insurance Services (AIS)

INSURANCE INSTITUTE OF AMERICA MALVERN, PA

TECHNICAL SKILLS

Applications: Active Directory SQL Server Management Studio Enterprise Manager Query Manager HP Mercury Defect Tracking

Red Gate SQL Data Compare NetXpress Call Logging (Easy Vista) Change Migration System (CMS)

Code Migration Management (CMM) SharePoint Elemetool InsBridge (Oracle) GAIN

Mercury Quality Center Microsoft Word Microsoft Excel Microsoft Project Adobe Acrobat Microsoft Power Point Microsoft SharePoint

Databases: SQL Server Microsoft Access

Contact this candidate