Brandon Gabrielson, Mba, Cfa Email & Phone Number

Rapid City, Sd, Us

Rapid City, Sd, Us

Rapid City, South Dakota, United States

Rapid City, South Dakota, United States

- Utilize Python to analyze data for the BOD regarding diverse turnover rates- Developed model to calculate and scenario test incentive payout of over $20 million to 3,000+ employees- Developed multiple regression pay equity model to predict expected compensation for each employee- Summarized and explained results of pay equity model to senior leadership; helped develop report for BOD- Create presentation material for BOD including data on merit pay, promotion rates, executive compensation, annual bonus pay, and turnover rates- Designed and presented model to senior management to scenario test modified incentive payout plan for executive employees- Created workbooks to help standardize the year-end awards process for VPs and directors- Analyze, compile, and create reports on equity in administration of annual key employee and project bonus program, as directed by senior leadership- Led Excel training sessions for HR team and regularly assist with problems when needed - Created model for comparing annual wage growth of union vs. non-union employees- Complete internal equity and offer reviews to determine appropriate place in pay range for job candidates - Complete market reviews of new positions to determine appropriate grade in company salary structure- Perform numerous research projects as requested- Develop annual budgets for projected incentive payout

Rapid City, South Dakota Area

NERC Certified Reliability CoordinatorManage load forecasts, actual load, and available resources to ensure reliable electric service Analyze and react to market conditionsConduct trades via contacts with producers, traders and power delivery organizations Assist in analyzing resources and market opportunities to maximize margins for real-time transactions

Analyze, consolidate, and communicate results for financial performance reportingAnalyze, maintain, and utilize rate base models to assess performance and report ROE Updated and redesigned rate base model Researched and presented at CFO conference regarding disruptive threat of distributed solar generationDeveloped capital and O&M reports and communicated with operations personnel to assess performance Coordinated meetings and worked as a member of a team to analyze and explain variances Developed models for calculating depreciation and AFUDC based on capital budgeting forecastsCreated model for analyzing gross margin Assist in developing and entering capital and O&M forecasts, strategic plans, and budgetsRetrieve and upload data regularly for reporting and data entry via SmartView and Peoplesoft

Analyze costs associated with mobile equipment. Write SQL queries to extract data from large databases. Assist with implementation and utilization of mobile equipment management software.Create and maintain statistical metrics

Created in Microsoft Excel a spreadsheet capable of analyzing historical inventory usage data and producing useful business metrics. Created a tool kit utilized by various departments to standardize the request for proposal process.

Master Of Science - Ms, Analytics

Master Of Business Administration (Mba), Business Administration And Management, General

Activities and Societies: Beta Gamma Sigma Honor SocietyMBA

Bachelor Of Science (Bs), Business Applications In Science And Technology