Learn Data Skills
Beta

Andrew Redston

Business Analytics Associate

Kairos Living

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Track

Data Analyst

Quantitative detective, solving mysteries and uncovering truths in data.

My Work

Take a look at my latest work.

DataLab

black_jack

course

Introduction to R

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Kairos Living | May 2021 - May 2022

Business Analytics Associate

Created and maintained numerous Power BI dashboards to track internal KPIs including: vacancy rate, construction turnover days, property yield, and acquisition rate. Wrote Data Analysis Expression (DAX) code to create these dashboards Assisted with property master status implementation for enhanced property tracking data which enabled more convenient reporting; additionally led the property and lease loading process in Yardi for over 4000 properties Created numerous custom excel reports, utilizing SQL code, for multiple teams to speed up their work by dynamically highlighting team specific KPIs Created many daily automated emails based on performance triggers to assist multiple teams identify properties and leases in need of special attention. Utilized SQL code to create these email reports Maintained two monthly financial reporting workbooks to track investor metrics including: net operating income, property management fees, and cash flow. Incorporated excel power query to make all reports dynamic and easily refreshable
Show More

Home Partners of America | Jun 2019 - May 2021

Accounting Associate

Lead fixed asset segment of accounting software transition from Yardi to NetSuite, responsibilities include Fixed Asset Module development, NetSuite system testing, and fixed asset report customization Created monthly financial reports to analyze key property operating metrics including: core revenue, net operating income, and cost to maintain Oversee Yardi Fixed Asset Module transactions for property acquisitions, dispositions, and depreciation for a portfolio of over 17,000 properties, and 100,000 assets Prepared monthly real estate tax accrual in accordance with state real estate tax payment schedules, and internal treasury data for property real estate tax payments Used SQL to pull general ledger transaction queries to analyze large quantities of data for turnover expense and capital expenditure analysis

Deloitte Tax LLP | Sep 2016 - Jun 2019

Tax Consultant

Analyzed expatriate assignment cost projections for large multinational corporations; determine the tax implications of various compensation structures and country combinations for senior executives and C-Suite employees Prepared more than 100 U.S. individual tax returns incorporating the reporting requirements for expatriate employment and international asset holdings Consulted large multinational corporations on their global equity to proactively implement rewards packages with a beneficial tax status, and assisted with the corporations’ global reporting requirements Researched international tax treaties and totalization agreements for cross-border tax and permanent establishment issues

My Education

Take a look at my formal education

Bachelor of Science in Business in Finance and AccountingIndiana University Bloomington | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free