Data Analyst Information Technology

Ryan Heerwagen *********@*****.*** https://github.com/ryanwagen 817-***-****

Profile

Intelligent, task-oriented analyst. Good attention to detail. Creates a positive work environment. Passion for information technology. Motivated to succeed and improve.

Experience

Capital One Auto Finance- Plano, TX April 2016-Present

Senior Data Analyst

Created segmentations of our population using SQL and in many cases automated segmentation processes in Python.

Managed the data needs for a population-wide sweepstakes, including verifying entries, scripting for automatically notifying customers of their entries, and working with a third-party vendor to select and fulfill prizes.

Stewarded database containing user-created tables for purposes of managing access to non-public information, and controlling space used and skewness.

Wrote process to identify emails engaged with company for the last year, built automated controls on that process, and worked on cross enterprise team to analyze and purge non-engaged emails from all databases.

Dent Zone- Irving, TX Sept 2013-March 2016

Data Analyst

Queried SQL database to create unique reports in Excel.

Automated the creation of Excel reports using VBA for rapid processing.

Manipulated data from Great Plains and SQL using Excel.

Worked with Linux and PHP scripts to process data on the server.

Tax Ease - Dallas, TX Sept 2012-July 2013

Data Analyst

Responsible for acquiring and processing Texas property and tax data.

Extracted, transformed and loaded millions of records using SQL, Access, and Excel.

Cleansed property records to ensure correctness, completeness, and utility.

Created automated data extraction scripts using VBScript and iMacros.

Dr Pepper Snapple Group - Dallas, TX Oct. 2010-Aug 2012

Route Auditor

Corrected errors in SAP's invoice database and created invoices.

Communicated via phone and e-mail with branches of the company to request information and address concerns of the branches.

Brainstormed with team and worked to develop a solution for employee concerns.

One of the fastest auditors in the department.

Skills

SQL, Python, VBA, R, Unix, HTML, Excel, Microsoft Word, PowerPoint, Access, Javascript, Java, data analysis, leadership, and public speaking. Willing to learn skills or refine existing ones.

Education

University of Texas at Dallas

Bachelor of Science, Finance and Bachelor of Science, Economics. May 2010

GPA 3.67 on a 4.0 scale

Certifications

Intro to Data Science - Udacity 2015

Yellow Belt in Lean Six Sigma - DPSG 2011

Activities

HackerNest Organizer May 2014 to Present

Coordinate Hackernest events by working with venues and sponsors to ensure everything runs smoothly.

Contact potential sponsors to arrange acquiring necessary supplies for group.

Create an environment where IT workers can socialize.

C3 Volunteer for the Dallas Museum of Art May 2014 to Present

Assist guests to the Dallas Museum of Art in their needs and requests.

Maintain the C3 area for guests so they may enjoy themselves.

Work with museum staff to take care of tasks needed for functioning of C3.

Skeptical Theological Discussion Jul 2014 to Present

Research and select intellectually challenging and engaging works.

Guide discussions on business related books in a manner promoting learning, thought, balanced conversation, and good experiences while discussing a contentious topic.

Organize group events and promote group activities.

Dallas Business Intellectual Book Club Jan 2016 to Present

Research and select intellectually challenging and engaging books.

Guide discussions on business related books in a manner promoting learning, thought, and good experiences.

Organize group events and promote group activities.

Read high quality business literature.

Adult Sunday School Email Assistant for First Unitarian Dallas Feb 2016 to Present

Research and select intellectually challenging topics and provide handouts.

Coordinate with the moderator team to ensure every discussion is adequately moderated.

Communicate topics in advance and inform attendees of any upcoming changes.

Generation Y Coordinator for Dallas Mensa Feb 2014 to Dec 2014

Plan great opportunities for younger Mensans to meet and socialize.

Facilitate and guide fruitful conversations.

Contact this candidate