Data Analyst Power

BLAKE HILTON

303-***-**** *********@*****.***

SKILLS

·Power BI

·Azure DevOps

·SQL

·R

·Data Analytics

·Python

·Microsoft Excel

·Reporting

·SSRS

WORK HISTORY

JANUARY 2019-July 2020 CONTRACT

Business Analyst – Data Analyst H&R Block Kansas City, MO

·Completed automated Power BI reports that projected the end-date and completion of project from an online service that was used for a daily report and for upper level management to improve the management decisions.

·Constructed complex M queries and DAX formula’s for Power BI.

·Organized rules, boards, and changes for Azure DevOps boards so they were faster and more efficient for teams.

·Proposed and implemented suggestions and changes to reporting and workflow processes so the process is easier and clean.

·Created one off Excel reports for managers and Vice Presidents that helped improve business decisions.

OCTOBER 2017-APRIL 2018

Business Intelligence Analyst – Revenue Accounting Frontier Airlines Denver, CO

·Developed and managed dashboards using Power BI and R with over 50 million data points.

·Developed and improved data gathering, analysis and visualization procedures with strategic optimizations.

·Created Power BI Report though an API exhibiting on-ground time between competing airline to identify which airports were more efficient for the business.

·Produced journal entries and reconciliations for accounts over 1 million dollars.

·Generated reports, updated spreadsheets and presented results.

·Made Excel reports for accountants.

JULY 2016-OCTOBER 2017

Database Administrator KEMET Electronics Corporation Greenwood Village, CO

·Tested SQL database and completed necessary modifications.

·Collaborated with Product Managers to ensure data was concise and clear.

·Modified and implemented new tables in SQL to meet the standards of new electronic parts.

EDUCATION

2014

Bachelor of Science: Finance

Kansas State University, Manhattan, KS

ADDITIONAL

INFORMATION

Boy Scouts of America: Eagle Scout

Delta Tau Delta: President

Experienced Analyst, analytical, highly motivated, and results focused.

PROFESSIONAL SUMMARY

Contact this candidate