Summary
Overview
Work History
Education
Skills
Technology Skills
Timeline
Generic

Tammy Rodriguez

Summary

Accounting Manager with twenty years of corporate accounting and financial reporting experience, primarily in the Food & Beverage industry. A meticulous professional with strong analytical skills, and proven ability identifying and implementing process improvements. Highly organized and articulate, with effective communication skills and a history of achieving departmental objectives and work results in a timely manner.

Overview

13
13
years of professional experience

Work History

Accounting Operations Associate Manager

PepsiCo
11.2020 - Current
  • Responsible for approximately $2B National Fountain P&L
  • Oversee and manage a team of 2 accountants, ensuring accurate and timely completion of financial statements, general ledger entries, Q-schedules, Rep Letters, account reconciliations, and SOX compliance including documentation of quarterly testing and annual walk-throughs
  • Manage and Prepare P&L COC periodically and perform analysis vs. forecast/plan, present results to senior leadership
  • Forecast/Review CF for AR and Inventory quarterly, as well as periodical analysis vs. forecast and PY
  • Prepare weekly QTG reconciliation analysis; resolve any sales variances
  • Collaborate with cross-functional teams to analyze and interpret financial data, providing valuable insights and recommendations to senior management
  • Streamline processes for increased efficiency and time savings within the team
  • Mentor team members to enhance professional development and accountability in workplace

Accounting Operations Senior Supervisor

PepsiCo
06.2019 - 11.2020
  • Participated in the monthly, quarterly, and year-end closing process including the preparation of journal entries and Balance Sheet reconciliations and communicated risks and opportunities to Senior Management
  • Prepared and presented Balance Sheet analytics to Senior Management, comparing POP, YOY, and YE account balances to ensure reasonableness, and identify irregularities or aged balances
  • Prepared YE Charitable Contribution and Distribution tracking
  • Reviewed and approved journal entries and account reconciliations completed by analyst periodically
  • Maximized personal competency through continuous professional development.
  • Analyzed metrics to identify areas of opportunity, drive performance improvements and consistently exceeded operational goals.

Control & Reporting Analyst

PepsiCo
12.2016 - 06.2019
  • Prepared and processed all closing responsibilities for US Bottling periodically: current provision and deferred income tax journal entries in accordance with SFAS 109 for U.S. Federal and State income taxes, FAS109, and account reconciliations
  • Derivative and hedging activity: prepared and processed periodic activity and tax provision journal entries; Completed Q19 Schedule
  • Prepared and managed quarterly forecast for US Bottling
  • Prepared Provision 2 Return and Tax Basis Balance Sheet for processing in annually based on M-1 Tax schedules
  • Prepared Government Reporting Quarterly (QFR200, BE125, BE11, BE577)
  • Assisted with ASU 2015-17 implementation for NAB division



Accounting Operations Associate Analyst

PepsiCo, Inc.
11.2012 - 12.2016
  • Responsible for approximately $36MM Budget related to School Funding;
  • Forecasted FY cash flow & PY accrual reductions monthly based on the updated forecast trends
  • Maintained Master File funding listing of approximately 800 schools: processed FOBO payments using EPM and COBO payments via journal entries
  • Submitted, Monitored and Audited all Local CDA Payments and Billings
  • Prepared and processed all journal entries related to School Funding including accruals, reclasses, amortization and miscellaneous transactions, and Local CDA
  • Managed Error report as per SOX requirement
  • Submitted, Monitored and Audited all Local CDA Payments and Billings
  • Initiated process improvement by implementing SharePoint site which centralized funding payment contracts, resulting in improved resource allocation
  • Collaborated with cross-functional teams to set up COBO contracts into TPM application

Financial Analyst

PepsiCo
03.2011 - 11.2012
  • Responsible for all periodic, quarterly, and year-end financial close processes and reporting the appropriate accounting of over $400MM of Integration and $80MM of Restructuring costs related to severance, bonuses, plant closures, etc.
  • Prepared and consolidated Q23 schedules and Pre/Post close Submissions for PAB
  • Prepared forecast to actuals analysis
  • Reconciled Integration and Restructuring Balance Sheet accounts
  • Analyzed the timing of accrual payments to support Cash flow and tax processes
  • Prepared period costs reports for Finance Leads

Education

MBA - Finance

Ashford University
San Diego, CA
01.2019

BBA - Accounting

Monroe College
The Bronx, NY
08.2002

Skills

  • Strategic Planning
  • P&L Management
  • Operations Management
  • Financial Data Analysis
  • Process Implementation
  • Team Management
  • Risk Management
  • Financial Reporting & Analysis
  • User Acceptance Testing
  • Project Management
  • DE&I Ambassador
  • NABA Coordinator

Technology Skills

  • Microsoft Excel
  • Word
  • PowerPoint
  • SAP
  • Oracle
  • Power BI
  • BO Reporting
  • Sales Invoicing Processing System
  • Hyperion Financial Management

Timeline

Accounting Operations Associate Manager

PepsiCo
11.2020 - Current

Accounting Operations Senior Supervisor

PepsiCo
06.2019 - 11.2020

Control & Reporting Analyst

PepsiCo
12.2016 - 06.2019

Accounting Operations Associate Analyst

PepsiCo, Inc.
11.2012 - 12.2016

Financial Analyst

PepsiCo
03.2011 - 11.2012

MBA - Finance

Ashford University

BBA - Accounting

Monroe College

Similar Profiles

CREATE PROFILE
Tammy Rodriguez