SHANE RATHBUN

**** ******* ***** **. *********, KY 40511

(847) 691 - 8996 abhzfj@r.postjobfree.com

PROFILE

Project Management ~ Business Process Improvement ~ Ad-Hoc Analysis ~ Data

Analysis

Intuitive and precise business/programmer analyst with exceptional

experience producing competitive advantages for industries and individuals

as seen through work with HSBC and Hewitt Associates. Professional systems

designer as witnessed through archival plan creation employed by the

Discover Financial Services Historical Solicitation Database that

coordinated with programmers' schedule reducing peak-hour database

downtime. Proficient in Microsoft Office (Excel, Access, Word,

PowerPoint), Enterprise Guide, IBM Mainframe, JCL, SQL, SAS, ORACLE, UNIX

and Windows Platforms.

PROFESSIONAL EXPERIENCE

HSBC, Mettawa, Illinois 2007-Present

Business Information Analyst

. Partners with Risk Management Analytics in creating and implementing

numerous Dashboards to present to Senior Management, including but not

limited to, Beginning of Month Productivity Dashboard, HMC Governance

Deck, and Business Scorecard Dashboard.

. Updates and maintains current Charge-off and Potential Charge-off

processes.

. Provides data integrity by auditing accounts ensuring the program code

meets the criteria set forth by the requesting parties.

. Works with and trains associates from our offshore team on various

processes across different projects.

. Effectively demonstrates time management skills on project delivery work

by coordinating and delivering multiple projects simultaneously.

HEWITT ASSOCIATES, Lincolnshire, Illinois 2004-2007

Calc Engine Analyst

. Coordinated directly with management regarding resolution status of

project issues.

. Updated code for participant data to correct assigned system errors.

. Analyzed and implemented project changes into the Calc Engine

environment, including break-in-service logic, new vesting service

calculations, and early retirement factor adjustments in order to

determine pension plan benefits.

. Assisted the Ongoing Development Group in analyzing and resolving

production database errors.

. Ensured data integrity by documenting Baseline Workflow for modules

associated with Calc Engine Environment.

System Configuration Analyst

. Partnered with testing manager in creating Excel spreadsheets used for

testing configuration updates for integration and acceptance testing.

. Designed and executed Integration Test Plans, using the project change

order and current Plan Provision Requirements.

. Provided quality assurance services to systems analyst through performing

regression testing prior to production implementation of the testing

database.

DISCOVER FINANCIAL SERVICES, Riverwoods, Illinois 2000-2003

Senior Analyst

. Collaborated with database project manager and outside vendor to update

and maintain the Historical Solicitation Database.

. Coordinated information with external vendors to model and select scored

mail campaigns.

. Researched and implemented behavior of card members by zip code to enable

modelers to create more successful campaigns.

. Coordinated with production team to streamline scored model samples and

ensure historical data accuracy, which resulted in a 10% enrollment

increase for scored campaigns.

. Assisted marketing in evaluating post-booking information for various

list vendors to determine which list vendors would be solicited in the

future, including evaluation of decline trending.

. Improved direct mail campaign deliverability through analyzing enrollment

and response from regular mail and samples to provide more accurate

addresses.

ALLSTATE INSURANCE COMPANY, Northbrook, Illinois 1996-2000

Technical Assistant

. Developed, executed and maintained the measurement of policyholder impact

of SAS and PL/1 programs for homeowners and private passenger auto rate

revisions.

. Produced standard homeowner exhibits using SAS and APL for actuarial

teams.

. Researched and implemented Wyoming homeowners rate change.

. Developed a more efficient property indications program with systems

analysts.

. Produced data using TSO/ISPF Mainframe for actuarial resource field

contacts, data support centers and state insurance departments.

. Worked with finance department to produce monthly expense information

required to state supplemental exhibits.

ALLSTATE LIFE SERVICE CENTER, Vernon Hills, Illinois 1994-1996

Senior Data Prep Specialist

. Processed final actions on ALSTAR (issues, non-issues and drops) to

assist life underwriters.

. Collected data for claims processing and life insurance new business

applications.

. Supported miscellaneous underwriter functions, including posting

requirements and maintaining requested follow-ups.

EDUCATION

ROOSEVELT UNIVERSITY, Schaumburg, Illinois

Bachelor of Arts in Mathematics, 1999

COLLEGE OF LAKE COUNTY, Grayslake, Illinois

Associates Degree in Accounting, 1997

Contact this candidate