Robert Kayorie, Cpa, Mba Email & Phone Number

• Managed budget and forecast process for entire company with $125M in revenue including shifting to a monthly forecast process to enable leadership to identify annualized expense savings over $4 Million• Created Actual vs. budget reporting and began monthly cadence with department leaders resulting in improved relationships with department leaders and ability to identify over $250,000 in savings during a downturn in business • Provided analytic support for development of an India Center of Excellence resulting in over $10M in annual savings• Led FP&A migration into adaptive insights leading to faster turnaround time for forecasts and reporting. • Developed and managed entry-level analysts complete with training sessions, daily meetings, performance feedback and reviews, and driving for improved work product• Created quarterly Board of Director presentations for forecast and actual financials and annual budget presentation

Chicago, Illinois, United States

• Liability analysis for regulatory and telecom taxes to help establish liability• Managed Indirect Tax Filings through outside service provider• Managed audits and tax dispute with state taxing authorities• Created Federal Excise Tax Filings for past 3 years • PUC bond and regulatory filings related to PUC Bonds. • Exemption Certificate catalog and validation• Manage Property Tax Payments

Chicago, Illinois

Full P&L, Budget, Forecast and Variance Analysis responsibility for cost centers with over $650 Million in annual revenue. Pricing reporting and analytics to support all cost centers. Created and maintain pricing model for recent acquisitionReporting to support all business leadersReporting to support sale of business to private equity firm. Customer and sales analytics to support under-performing business unit.

Greater Chicago Area

• Developed improved method for developing internal and external GAAP financial statement forecast for four domestic regions and 3 international regions • Provided reporting and analytic support to investment bank during $133Million IPO• Modeled Market Ranking file to evaluate the performance of all company segments• Produced analytic reports required by lenders for $1.3B Asset Backed Revolving Line of Credit• Developed Annual Incentive Plan model and used this model to build accruals for annual payouts based on monthly performance of business units• Worked with investment banks to assess potential $850 Million bond refinance• Created and participated in presentation for credit ratings agencies• Prepared financial analysis used to evaluate $1.1 Million merger• Negotiated $20M in Equipment Leasing arrangements, provided operating and buy vs. lease analysis using discounted cash flow analysis• Refined Pricing and Profitability Model to allow field sales evaluate the profitability of customer orders• Partnered with Treasury to create internal cash projection based on equipment financing arrangements and to evaluate our short-term working capital needs• Built value added modeling to evaluate extra margins earned on more complex processing items• Created expense forecast and investigated variances to evaluate effectiveness of cost savings initiatives implemented during a market downturn• Served as a member of the analytics committee set up to share best practices, implement and test new systems, and improve analytic support to internal clients

Chicago, Il

Winston Salem Customer Financial Services Transition Team Managed two high-profile teams totaling eleven analysts and six contractor employees while managing my own account responsibilities. Coordinated transition of high profile accounts to Winston-Salem. Worked in cross-functional teams to resolve outstanding issue prior to final transition. • Led meetings with the Winston-Salem Senior Leadership Team to discuss KPIs, escalation process, and other internal procedures• Conducted both classroom and hands-on training for the new Customer Financial Services teams • Developed improved shipment and syndicated data reporting for high-profile accounts to enable analysis at multiple customer levelsEast Region Team LeadLead team of 6 analysts and two contract employees in completion of daily tasks while managing my own account responsibilities. Coordinated escalation process and worked to resolve outstanding issues. Served as liaison to other departments. Analyzed and researched variances from forecast and plan. Coached and developed team members. • Coached and developed direct reports by sharing best practices and providing performance feedback on areas of opportunity • Drove transaction efficiencies through the management of trade spending and analysis to increase the effectiveness of targeted trade promotions across Quaker, Tropicana, and Gatorade• Partnered with Sales Finance in forecasting by providing critical information in a timely manner as well as by accurately capturing strategic trade settlements within PepsiCo’s SAP system• Successfully partnered with Field Sales and Sales Finance to drive resolution of over $1,000,000 in customer non-compliant billing within first four months of role and facilitated fluid communication and strong relationships

Greater Chicago Area

Analyst I/II – Customer Financial Services 2009 to 2012Analyst (contractor) – Customer Financial Services 2008 to 2009Performed analysis of customer volume movement and promotional spending. Validated movement and attempted to resolve invalid customer activity. Assisted sales in development of annual promotional plan. Partner with other Finance groups to resolve forecast/actual variance, overspends, and analyze outstanding issues. On-board, develop and mentor junior analysts. • Effectively partnered with cross-functional teams and built strong business rapports to drive cost savings, profitability, and process improvements• Negotiated the recovery of $600,000 in customer non-compliant activity during first two months • Reduced customer administrative fees by $80,000 annually resulting from conflicting policies• Partnered with Sr. Financial Analysts to investigate discrepancies between actual spends versus forecasts and recommended process improvements to minimize future discrepancies • Developed analytical reports to assist in critical credit analysis of high-risk customers and to enable the determination of shipment allotments• Recognized as a go-to person for training team, identifying process improvements, and testing new procedures during PepsiCo’s transition to SAP

Mba, Finance And Strategy

Bachelors, Finance

Activities and Societies: Finance and Accounting Club Member, Member Indiana CPA Society Case Study Competition TeamGraduated with Honors

Diploma