BRETT L BENSON

**** **** *** ****

Bartlett, IL *0103

Cell: 630-***-****

Email: ac0ax6@r.postjobfree.com

Summary: Detail and customer service oriented Database/Data Analyst professional with experience in evaluating and providing information in the direct marketing and payroll service fields; experience in SQL and Access to crunch data to meet client and vendor needs. Self-starter as well as a valued team member with both corporate and non-profit working experience.

JOB HISTORY

CVS Health – Northbrook, IL – Pharmaceutical Benefits Provider

December 2014- Present

Data Analytics Consultant

Put together company mailings in Access and SQL to clients, members and prescribers.

Mailings were about lowering drug costs using generics, Government warning releases and Formulary purges among other type of mailings.

Mail merged word templates using Excel.

Meijer Stores – Bloomingdale, IL – Retail

March 2006 – December 2014

Produce Clerk – Part Time

Stocked produce on sales floor.

Updated produce inventory book.

Cleaned floor, back room and cooler

Paylocity, Inc. – Arlington Heights, IL – Payroll Service

September 2008 - October 2014

Partner Integration Support Analyst

Set up file transmission of 401K Programs, HSA, FSA and unemployment to various vendors for Paylocity clients. This helped clients eliminate the task of uploading their 401K contributor and benefits information manually to their 401K vendors

Troubleshot issues with transmissions that had missing and/or bad data file information as well as discrepancies in amounts between what was in their reports and what was being reported on the data file to the vendor.

Worked with vendors to get client information for compensation reports by developing queries in Access and SQL.

Developed and enhanced my skills in SQL. Helped create a way to setup queries in SQL to help clients get their financial and benefits downloaded into an Access environment.

Independent Contractor

November 2007 – September 2008

Data Analyst

Import customer data from Excel and Access to create a list ready for client mailings, print letters and process customer orders. Help saved clients up to 15% in postage costs by sending out the individual pieces at a lower per piece rate from USPS.

Analyzed and tracked Email marketing results using advanced Excel programming.

Produced master database of Account Reps, Vendors and Support team information for a Fortune 500 computer company using Excel and Access programming.

Produced mailing lists for clients using Visual Basic and FoxPro programming.

Batch imported data for UPS shipments. Clients were able to save 10% on UPS delivery costs.

Veritas Document Solutions – Buffalo Grove, IL - Printing and IT Solutions

December 2006 – November 2007

Data Analyst

Imported customer data from Excel and Access to create a list ready for client mailings.

Executed a streamlined process of importing data for several large clients to increase productivity.

Extracted customer data and created medical cards using Access and SQL queries. These helped the client get out timely information to their customers for up to 15% less in postage costs.

Batch imported data for UPS and Federal Express shipments.

American Foundry Society – Schaumburg, IL – Nonprofit Trade Organization for the Foundry Industry

April 1999 – August 2006

Information Services Specialist

Executed database extractions for company led mailings and Email promotions using Access queries and FoxPro.

Increased class attendance by 5% through database mining of extracting expired membership names and workers who had not been to an AFS class in 2 – 5 years.

Reorganized database by eliminating duplicate and bad records, Implemented and executed extraction of names for outside mailings for Foundry conferences and/or AFS classes at the rate of two or three mailings a week. Mailings consisted of anywhere from 5000 to 25000 mailing pieces.

Assisted in transition of AFS membership/subscriber database into an SQL based software package.

Maintained network functionality of servers as well as associate computers.

EDUCATION

B.A. in Business Administration, Drake University, Des Moines, IA.

Contact this candidate