Data Analyst Power

Garrett Lipps

**** *********** ***** **********, **** 45230 614-***-**** **********@*****.***

EDUCATION

Xavier University Cincinnati, OH

Bachelor of Science, Major in Actuarial Science Graduation: December 2019

COMPUTER SKILLS

Software: Excel, Word, PowerPoint, Bloomberg, Power BI; SQL

Proficient in programming: Java, VBA, Python; R

RELEVENT TECHNICAL SKILLS

VBA Macro Building Power Bi Dashboard Building

VBA Connection to SQL Power Bi R Script Experience

VBA Data Pull & List Building Power Bi Query Connection & Building

Access Form Development Access Query Development

Data analysis using Excel Data analysis using Power Bi

SQL table building SQL table modification

WORK EXPERIENCE

U.S, Bank Cincinnati, OH

RCA Data Analyst July 2019-Present Link access to SQL to collect department data using forms built specifically by the metrics team

Retrieve department data from SQL to build daily, weekly, and monthly reports in excel and power bi

Macro building in excel using VBA to build list and other metrics for reporting

Macro building to balance data and to verify accuracy of reports being sent

Dashboard building in power bi connected to SQL for live data feeds

Access form development to be used by processing team for data entry

Data analysis of volume received to analyze department efficiency and accuracy

Stellar Construction Cincinnati, OH

Mason’s Assistant June-August 2017

Revised construction plans and directed employees

Assisted in demolition and reconstruction of the worksite

ACTIVITIES and LEADERSHIP

Xavier Senior Research Cincinnati, OH

Math Understudy August 2019-Present

Studied the relevance of Bayesian Probability on the Stock Market

Applied R model to research conducted

Actuarial Science Club Cincinnati, OH

Board Member August 2015-August 2019

Coordinated visits to insurance companies to expand further knowledge of work environment

Worked in study groups for future actuarial exams

Xavier ROTC Cincinnati, OH

Cadet August-December 2016

Assembled workout plans for daily physical training

Lead combat-based situations and put military models into practice

Contact this candidate