Financial Analyst

Andrew Nielson

******.*******@*****.*** •801-***-**** •https://www.linkedin.com/in/andrewkylenielson

SUMMARY OF QUALIFICATIONS

Skilled in: Microsoft Word, Excel, PowerPoint, R, Java, SQL, Redshift; Qualtrics survey certification

EDUCATION

David Eccles School of Business, University of Utah Salt Lake City, Utah

Master of Science in Finance/ Graduate Certificate Information Systems Expected March 2017

Related Courses: Financial Engineering, Database Theory and Design, Data Structures and Java,

Excel for Finance, Statistics for Finance, Data Mining, Data Warehousing, Financial Modeling

Jon M. Huntsman School of Business, Utah State University Logan, Utah

Bachelor of Science in International Business December 2014

Minor in Mandarin Chinese

Dean’s List, GPA 3.53

Chinese language Honor Award Beijing Jiaotong University

Beijing Jiaotong University; Language Immersion Training Mandarin Chinese Program

Related Courses: Corporate Finance, Big Data Analytics, International Finance, Supply Chain Management

EXPERIENCE

Intermountain Healthcare Salt Lake City, Utah

Financial Analyst Budget Team 06/2016 – Present

Build and maintain dashboards in OBIEE for department managers using SQL

Build ETL processes in Java to automate monthly admits query extract

Pull data from OLAP cube and analyze the financial status

Build reports for finance directors/upper management in Hyperion Reporting Studio

Email hospitals and get explanations regarding discrepancies in budget

Monumetric Farmington, Utah

Demand Testing Analyst/Account Manager 12/2014 – 06/2016

Implemented and tested new demand sources in advertising and analyzed test results

Created case studies for successful demand source implementations and presented to managing partners

Pushed new demand sources live throughout the network of twelve hundred publishers

Manipulated price triggers and floors in the advertisement waterfall on a daily basis to maximize profits

Routinely participated in teams to work on solving specific company projects and challenges

SearchSino Marketing Research Firm Xian, China

Marketing Research Intern 05/2013 – 08/2013

Researched the American semi-truck manufacturing business for a client seeking potential entry

Became a liaison between SearchSino and an American marketing company Service Evaluation Concepts

Created business development by inviting companies to subcontract mystery shopping to SearchSino

RELATED SCHOOL EXPERIENCE

Organized a text analysis for Dragon Dictation using Clarabridge

Created data visualization for the foreign assistance given by the US utilizing Tableau

Built Neural Networks, Support Vector Machines, and Decision tree models in R

Implemented a Mock Oracle Database Created views and SQL queries to analyze the data

Built CMO payment spreadsheet and Merrill Lynch arbitrage worksheet in excel

Built neural network in Python to analyze and predict currency exchange rate

Contact this candidate