Data Analyst

Andrew Coyle

************@*****.***

619-***-**** (Cell)

***** ******* ***** ** ~ Ramona, CA 92065

QUALIFICATIONS

Over seven years of reporting design, creation, and management experience with a specialties in SAS, SQL, and VBA. Strong knowledge of office related programs and procedures. Ability to quickly pick up and excel with new programs and processes. Proven ability to head projects of diverse levels of importance and difficulty. Experience in developing inter-company plans, strategies and processes. Known to exceed at troubleshooting using abilities which include, but are not limited to; analytical skills, adaptive problem solving, and effective communication techniques.

EDUCATION

The Art Institute of California – San Diego 2004 – 2007

Bachelor of Science, Game Art and Design

RELATED KNOWLEDGE AND TRAINING

Analysis and Report Creation

Business Intelligence Analysis

Microsoft Office with a focus in Excel

Advanced VBA skills

Programming in SAS

Programming in SQL

Programming in MEL Script

Programming in C++

Unix

Experience with flat, relational, and

hierarchical database systems

Salesforce Development/Administration

Wire-Framing

Process Analysis

Lean Six Sigma

WORK EXPERIENCE

– Medimpact – Client Data Analyst 08/17 – Present

Working with the Client Technical Solutions department to assist in the creation of various reports, file conversions, SQL queries, and database management. Report creation and SQL queries through Oracle database with both ad-hoc and customized preset queries. Database management and file metadata analysis carries out through Unix interface. Creation and improvement numerous automation tools, file conversion processes, and various training materials using VBA and other Microsoft products. Project supervision of custom client website usage and access as well as IT department ran reports through several CRM programs.

– Encore Capital Group – Data Analyst 01/16 – 07/17 Analyst work primarily with the Consumer Support Services to manage SAS datasets and develop analyst reports. Technology used was typically SAS, Salesforce, and VBA. Reports ranged from internal business analysis and evaluation, to communication of progress to outside clients and firms. Close work with fellow analyst team to develop programs as well as review the business effects and outcomes. Assignments could range from concept to completion projects to ad-hoc requests.

– ARS National Services – Client Reporting Supervisor 02/15 – 01/16 Managed a team of Client Reporting Analysts to evaluate and report complaints directly to clients. While assisting with the analysis, I developed and managed several different reports reviewing areas for risk management and profit potential. Through the use of Visual Basic programming to create office efficiency tools and optimization techniques, I was able to drop overtime spending by 96%.

– Bridgepoint Education – Student Inquiry Coordinator 07/10 – 01/15 Initial duties included proactively contacting prospective students to meet service levels and performance indicators, as well as assist with policy and procedure improvements to greater efficiency and enhancement of the student experience. Additional duties included development of software tools and databases for the tracking of employee work utilization and productivity, with the goal of business intelligence reports and dashboards for senior management in the direction, planning, and optimization of the departments.

PROFILE

A motivated and proficient work ethic with a proven ability to work projects to beyond expectations. Project management and task oriented skills with a drive of continuous learning and improvement. Creative and analytical problem solving abilities in both individual and collaborative projects.

Contact this candidate