David Granstrom

David Granstrom Email and Phone Number

Sr. Manager, Utilization-Based Leasing and Analytics @ GATX
Chicago, IL, US
David Granstrom's Location
Chicago, Illinois, United States, United States
David Granstrom's Contact Details

David Granstrom work email

David Granstrom personal email

n/a
About David Granstrom

Experienced Analytics Manager with a demonstrated history of diverse roles in the railroad industry. Skilled in IBM Cognos, Salesforce, Power BI, SAP Business Intelligence, Compilation of Financial Statements, and Business Process Improvement. Strong project management professional with a Master's degree in Accounting from the University of Illinois at Urbana-Champaign.

David Granstrom's Current Company Details
GATX

Gatx

View
Sr. Manager, Utilization-Based Leasing and Analytics
Chicago, IL, US
Website:
gatx.com
Employees:
899
David Granstrom Work Experience Details
  • Gatx
    Sr. Manager, Utilization-Based Leasing And Analytics
    Gatx
    Chicago, Il, Us
  • Gatx
    Manager, Fleet Assignments & Renewals
    Gatx Oct 2023 - Present
  • Gatx
    Manager, Utilization Lease & Fleet Analyst
    Gatx Mar 2021 - Present
    Chicago, Illinois, United States
    Consolidate per diem metrics into a dynamic reporting tool to immediately assess earnings across growing 15,000 per diem car fleet. Evaluate performance & utilization by car type, customer, contract, and maintenance exposure. Focus collective attention of Sr. Staff, Fleet, and Commercial teams on earnings above and below expectations.Ensure appropriate application of default and negotiated hourly, mileage, and appurtenance rates. Administer monthly rate setting for expiring and newly assigned contracts. Challenge effective default rates on grandfathered boxcars, subsequently increasing rates on over 500 cars. Enter into market rate negotiations to successfully attain favorable rate increases on over 13,000 cars. Collaborate with Sr. Officers to develop reporting metrics on collective marketplace of 1.64 million rail cars. Refine industry data for investor and board of director presentations. Fine-tune external license agreement language to protect best interests of GATX.
  • Gatx
    Senior Utilization Based Leasing Analyst
    Gatx Jun 2018 - Mar 2021
    Chicago, Illinois
  • Smbc Rail Services, Llc
    Program Manager
    Smbc Rail Services, Llc May 2015 - Jun 2018
    Chicago, Il
    Integrate 30,000 cars into existing 25,000 car legacy fleet. Lead weekly shop network calls to ensure SMBC expectations are communicated to repair networks. Manage combined fleet during shop maintenance across 70+ facilities.Plan and manage 3,000+ annual tank car shoppings for regulatory compliance. Coordinate between internal sales team, mechanical officers, major shop network sales representatives, plant managers, 3rd party maintenance management teams, and the customer's personnel to execute on the shopping program. Select the optimal location within the approved shop network considering negotiated price agreements, lessee freight implications, while monitoring cycle times to both reduce out of service time and rental abatement. Leverage vendor relationships to secure materials more quickly such that cycle times are met. Drive total average compliance shoppings down to sub-60 day turns including jacketed + lined cars.Strengthen relationships with lessees to work towards a common goal to clear any outstanding billing disputes. Resolve disputed items including but not limited to HM216B inspections, coil tests, valve replacement / maintenance, and linings. Reach an agreement with the lessee during shop estimate and prior to final invoicing to ease workload on finance teams for both entities.Develop annual maintenance business plan for both legacy SMBC and recently acquired ARL fleets, factoring in varying cost assumptions. Areas of focus centered on running repairs, shoppings, requalification events, tank car retrofits, inspections, management fees, and ad valorem tax. Significant efforts to model compliance plan with breakouts for volume, expense, capitalization, deferrals, and abatement expected by month and account. Budget followed by monthly reviews of actual spend and volumes against approved plan.
  • Smbc Rail Services, Llc
    Financial Analyst
    Smbc Rail Services, Llc May 2013 - May 2015
    Chicago, Il
    Complete the full accounting cycle including, but not limited to, customer invoicing of over 275 contracts, customer cash receipt, vendor disbursement, asset funding, contract set-up and termination, issue loan requests, and other ad hoc requests.Perform approximately 75% of month-end journal entries and closing functions - recording and reconciling all of the company's accrued expenses, deferred expenses, loan, interest and other amortizations, accumulated depreciation on over 17,500 assets, etc.Liaise between Finance and Operations / Mechanical teams by coordinating monthly spend meetings to track and project future car spend maintenance, consolidating budget estimates into a manageable monthly plan, and assisting with any ad hoc information requests.Collect and Analyze full year mileage data for over 17,500 rail cars to generate mileage equalization and high mileage utilization invoices for over 275 customer contracts in connection with the contractual agreements.
  • Union Pacific
    Financial Analyst
    Union Pacific May 2011 - May 2013
    Omaha, Nebraska
    Maintain the general ledger across the railroad and over 100 subsidiary companies – 1,000 balance sheet accounts; 1,000 cost element/income statement accounts, cost centers, costing sheets & internal orders (overheads & settlements), and monitor inter-company balances.Assist in month-end close – ensure entries post to the correct month across entire rail system, perform foreign currency valuations, subsidiary revenue / expense eliminations, and record equity company income / loss.Maintain sawtooth leases – review monthly SAP entries which adjust asset / liability balances in the millions of dollars, record quarterly asset / liability re-class, adjust schedules based on rent holidays, equipment casualties, and early buy-outs.Prepare railroad-only versions of 10K and 10Q; assist in industry reporting to Surface Transportation Board (R-1); prepare executive reports for the proxy; and compile financial statements for UP Foundation and a jointly-owned interchange company.
  • University Of Illinois At Urbana-Champaign
    Summer Orientation Student Worker
    University Of Illinois At Urbana-Champaign May 2010 - Aug 2010
    •Assist incoming freshman and transfer students register for classes, suggesting both class load and sequence.•Act as the first student contact for the incoming student offering insight into their first semester at Illinois.
  • Johnson & Johnson
    Financial Analyst
    Johnson & Johnson Jun 2009 - Jan 2010
    Compile and input accrual journal entries for contracted services – submit summary report to finance controllersCreate Excel templates for worldwide sites to submit capital expenses and month / year-end budgetsIndividually collect and format data from worldwide sites to prepare and submit worldwide monthly headcount report to Board of Directors

David Granstrom Skills

Sap Microsoft Office Business Intelligence Clarity Fsr Jde One World Cognos Lotus Notes Outlook Intercompany Transactions Intercompany Accounts Bex Analyzer Positive Pay Compilation Of Financial Statements Jd Edwards Leases Process Improvement Budgets Financial Statements Finance Sarbanes Oxley Act Microsoft Excel Financial Reporting General Ledger Accounting Internal Controls Financial Analysis Us Gaap Financial Accounting Budgeting Project Management Data Analysis Salesforce.com Regulatory Compliance Dispute Resolution

David Granstrom Education Details

Frequently Asked Questions about David Granstrom

What company does David Granstrom work for?

David Granstrom works for Gatx

What is David Granstrom's role at the current company?

David Granstrom's current role is Sr. Manager, Utilization-Based Leasing and Analytics.

What is David Granstrom's email address?

David Granstrom's email address is da****@****ail.com

What schools did David Granstrom attend?

David Granstrom attended University Of Illinois At Urbana-Champaign, University Of Illinois At Urbana-Champaign.

What skills is David Granstrom known for?

David Granstrom has skills like Sap, Microsoft Office, Business Intelligence, Clarity Fsr, Jde One World, Cognos, Lotus Notes, Outlook, Intercompany Transactions, Intercompany Accounts, Bex Analyzer, Positive Pay.

Who are David Granstrom's colleagues?

David Granstrom's colleagues are Garrett Barnett, Bill Wozencraft, Zeeshan Naqvi, Nancy Soto, Stuart Southern, Nicholas Feldman, Michael Doyle.

Not the David Granstrom you were looking for?

  • David Granstrom

    Assistant Executive Vice President, American Veterinary Medical Association
    Schaumburg, Il
    2
    avma.org, k-state.edu

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.