David Granstrom Email and Phone Number
David Granstrom work email
- Valid
- Valid
David Granstrom personal email
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.
-
Sr. Manager, Utilization-Based Leasing And AnalyticsGatxChicago, Il, Us -
Manager, Fleet Assignments & RenewalsGatx Oct 2023 - Present -
Manager, Utilization Lease & Fleet AnalystGatx Mar 2021 - PresentChicago, Illinois, United StatesConsolidate 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. -
Senior Utilization Based Leasing AnalystGatx Jun 2018 - Mar 2021Chicago, Illinois -
Program ManagerSmbc Rail Services, Llc May 2015 - Jun 2018Chicago, IlIntegrate 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. -
Financial AnalystSmbc Rail Services, Llc May 2013 - May 2015Chicago, IlComplete 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. -
Financial AnalystUnion Pacific May 2011 - May 2013Omaha, NebraskaMaintain 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. -
Summer Orientation Student WorkerUniversity 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. -
Financial AnalystJohnson & Johnson Jun 2009 - Jan 2010Compile 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
David Granstrom Education Details
-
Accounting -
Accounting
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 AssociationSchaumburg, Il2avma.org, k-state.edu
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial