Robert Ayers Email & Phone Number

Kansas City, MO, US

Kansas City, Missouri, United States

Developed internal cost calculator and proposal analysis model for internal Cloud (AWS) costing exercises utilizing price and product lists from AWS. Responsible for annual expense planning and monthly/quarterly forecasting and reporting for $350M (annual) Engineering organization. Work closely with senior leadership teams to forecast needs of the business.

San Francisco, CA

• Built $220M annual capital and expense budget along with a model used to create monthly forecast updates.
• Provided actionable insight to management by preparing monthly budget variance reports and narrative analysis focusing on current month and year-to-date views.
• Developed monthly reporting package summarizing both financial and operational metric result performance.
• Created reconciliations and supporting files as part of the triennial regulatory rate case submission.

Overland Park, KS

• Augmented the effectiveness of the Sprint executive team by developing a standardized financial model used to evaluate the profitability impact of operational scenarios.
• Responsible for creation of a $1B annual expense budget.
• Created multi-channel, multi-product financial modeling for a rolling expense and revenue forecast, incorporating a wide range of drivers.
• Provided variance analysis for budget and rolling forecast.
• Successfully integrated iPhone product line with unique cost structure into existing models.

Overland Park, KS

• Responsible for the monthly results and variance reporting for two executive organizations with a combined annual budget of $200M.
• Created a financial model to facilitate salaries budgeting for an organization of over 3,000 employees.
• Developed and implemented a new process to create ad hoc results reporting using a database and Excel programming that not only provided an improved view of the organization’s operations but was also easier to use.

Overland Park, KS

• Built a financial model as part of the business case for the launch of a new line of business, incorporating multiple geographies/channels/products and including flexibility for several factors to facilitate scenario.
• Redesigned line of business reporting package for quarterly trends to increase its effectiveness as a management tool. Developed a streamlined and repeatable process to increase efficiency in production of the package.
• Led project to analyze the geographic profile of the business and how it drives returns and margins and presented findings to the executive team.

Overland Park, KS

• Received the Sprint company-wide quarterly award for individual excellence for achieving annual savings of $28M by creating a workforce optimization model covering a 3,000 technician workforce. The model incorporated.
• Key contributor to the team that received Sprint’s highest global award for developing a technician productivity reporting system that achieved annual savings of $20M and a global productivity increase of 25%.
• Provided financial analysis for development of an incentive plan for technicians and supervisors to increase productivity and profitability.

Kansas City, MO

• Supervised staff of four and was responsible for all accounting activities, as well as preparation and review of all month-end and year-end financial statements.
• Assisted with pricing, sales analysis and manufacturing efficiency studies.

Bethesda, MD

• Prepared individual company and consolidated financial statements and performed month-end closing for each of five companies.

Kansas City, MO

• Responsible for monthly close, preparation of monthly financial statements, annual budget and reporting to state and federal regulatory agencies.

Bsba, Finance / Economics

Masters, Accounting