Analyst Six Sigma

**** ***** ** * **** Apple Valley, MN ***** • 952-***-**** • ***********@*****.***

Andy Hawkinson

HIGHLIGHTS OF QUALIFICATIONS

Over 2 years of analyst experience

Experience identifying, analyzing, and interpreting trends/patterns in complex data sets

Expertise in research, analysis, problem solving, and collaboration

Excel and Access 2010 Certification

Advanced user of macros, pivot tables, and complex formulas

Knowledge and experience with healthcare organizations and medical terminology

CERTIFICATIONS

Six Sigma White Belt Certified - Aveta Business Institute April 2013

Excel 2010 Certified April 2013

Access 2010 Certified June 2013

SKILLS

Excel, Access, Word, Power Point, Outlook, SharePoint, Crystal Reports, Visio, Macro Express, 10

Key, SQL, QlikView, CarePartner, CareCentral, EBS, Huston, Anchor

PROFESSIONAL EXPERIENCE

Business Analyst - Contract October 2012 – December 2012

Client: United Health - Optum

Minnetonka, MN

Created multiple Excel report templates which increased efficiency 250% by use of macros and

advanced formulas

Created and maintained 3 weekly reports and dashboards in Excel

Enhanced teamwork skills by collaborating with a team of 5 Business Analysts on projects

Data Analyst & A/R Clerk & Auditor - Contract July 2011 – July 2012

Client: Health Partners

B loomington, MN

Wrote and edited over 20 macros for complex tasks that improved efficiency up to 50%

Trained 4 co-workers to write and read macros

Created and maintained dashboards, reports, and forms in Excel, Access, Visio, and Crystal

Reports with use of pivot tables, macros, queries and advanced formulas

Performed daily ad hoc analysis and data mining assignments dealing with large datasets

1 2Page

6583 158th St W 302c Apple Valley, MN 55124 • 952-***-**** • ***********@*****.***

Andy Hawkinson

PROFESSIONAL EXPERIENCE - CONTINUED

Loan Review Analyst - Contract January 2010 - December 2010

Client: Wells Fargo

Eagan, MN

Reviewed 25 FHA loans daily to ensure they were complete and accurate

Identified problem loans and described deficiencies for review by loan processor

Internship - Park Operations Department May 2009 – October 2009

Valleyfair, Shakopee, MN

Performed efficiency tests of 15 current employees identifying areas for improved efficiency

Completed audits of 8 amusement park rides to determine costs and for budget control

Audited employment documentation and training certifications

EDUCATION

Bachelor o f Science i n B usiness A dministration e mphasis in Finance 2 009

University of Wisconsin-Stout

Menomonie, WI

R elevant courses taken:

Statistics Data Structures MIS - Excel

Calculus I & II Business Finance Office Automation

Willing to Relocate

2 2Page

Contact this candidate