Jacqueline Cottrell

Experience

• 

  The Coca-Cola Company

  Nov 1979 - Feb 2021

  Collaborate with business clients to jointly identify the business systems requirements to support their business needs. Manage systems, applications, interfaces, controls and processes to secure and collect The Coca-Cola Company’s consolidated worldwide financial and volume data. • Steward application controls to safeguard and prove strong governance and compliance, supporting the effectiveness of Sarbanes-Oxley controls and demonstrate effectiveness of key SOX controls with internal, external and SAP auditors • Provide direction and advice to protect data and applications in adherence to Company policies to ensure the Company’s financial statements are free from material errors• Global business steward responsible for providing oversight of user access management to key systems. Ensure sensitive information and data are appropriately segregated and restricted and perform risk analysis procedures to mitigate segregation risks, ensuring sensitive transactions or segregation of duties conflicts are monitored/addressed by existing processes and controls• Analyze business, functional and technical information processes, develop, test, train and deploy new application/system solutions and manage testing teams, including test plan, scripts, project milestones and coordination of user acceptance testing• Leads project management including communication, coordination, execution, and implementation of system change management including development and delivery of training to project members on key application concepts to ensure maximum productivity and development• Provide leadership and accountability for global finance application incident management and problem resolution and tracks accurate metrics to support performance management routines and decision making• Oversee experienced professionals and large project teams, including selection/hiring, objective setting, performance management, coaching, development and training Show less Maintain and test consolidation system application controls to provide reasonable assurance that system and application changes of financial reporting significance are authorized and appropriately tested before implementation in production environment. • Ensure application controls prevent or detect material fraud and provide reasonable assurance that global financial systems and subsystems used to collect, analyze and report worldwide financial and volume data, are appropriately secured to prevent unauthorized use, disclosure, modification, damage or loss of data• Analyze business, functional and technical requirements by conducting information-gathering sessions with clients, analyzing the information, and prioritizing requirements to gain understanding of business needs• Steward the review, testing, and implementation of new/approved data collection programming changes in accordance with business client deadlines. Perform data conversion activities including preparation, execution and validation of data to implement the solution.• Assess the need for education and training standards or policies and develop, maintain and provide technical expertise to transfer knowledge, operating systems and other application component training to provide consistency and business user awareness• Supervise, motivate, inspire and develop up to 10 associates and delegate work assignments, providing sufficient direction so desired business outcomes can be achieved • Execute security changes associated with the SAP P38 DACCARS preprocessor, SAP P28 GPS, SAP P28 FDW and the Microsoft Excel E-Management Book in accordance with Insider Trading requirements Show less Responsible for administering the Marketing (MARKAPP) and Year-End (YREAPP) applications of the Universal Data Gathering System (UNIDAGS) through which the Company collects worldwide liters of finished product, top 20 global customer financial data, global McDonald’s financial data and other year-end supplemental financial information.• Provide UNIDAGS user support for resolution of security access and data collection issues by interacting with worldwide uses and their Headquarters Financial Services representatives• Maintain up-to-date system validation tables, develop new structured file submission forms to keep pace with evolving business information needs and reconcile MARKAPP unit case sales data with unit cases collected through UNIDAGS Financial (FINAPP) application• Work with Global IT and Marketing Data Control Coordinator to test new or changed MARKAPP submission collection and feedback reports• Identify and implement improvements to procedures and processes with a focus on improving customer service, reducing support costs and minimizing errors Show less Provided financial analyst support to the Coca-Cola Nestle Refreshments (CCNR) joint venture on behalf of The Coca-Cola Company and Nestle. Responsibilities included:• Consolidation, review and analysis of Business Plan, Rolling Estimate and Actuals. Identified and explained significant variances versus Budget and Rolling Estimate measures and worked with international and domestic field locations to resolve accounting, reporting and process issues. • Recorded and analyzed monthly Actual and Rolling Estimate joint venture equity income and royalties on The Coca-Cola Company’s books including foreign exchange remeasurement. • Prepared and submitted Cash Flow and Operating Capital information for CCNR. • Provided financial advice and support to Management and Nestle including preparation of trend analysis reports, fulfillment of ad hoc reporting requests using FOCUS query language to extract information from the FINANCE and general ledger databases. • Participated in special projects, both individually and as part of a team. • Maintained Nestea Atlanta income Statement and submitted changes to the monthly Nestea Atlanta Rolling Estimate. • Prepared bi-annual CCNR Board of Director’s presentation, annual Business Plan Meeting presentations used by CCNR Finance Manager and Director, Non-Carbonated Brands and Mid-Year Coca-Cola (KO) joint venture representative presentations. • Evaluated current consolidated reporting processes and identified opportunities for process/efficiency improvements. • Assisted in the development and evaluation of processes related to implementation of new reporting systems (KO Finance) Show less Provided financial analyst support to the Company’s Middle & Far East Group, Corporate Concentrate Operations, Coca-Cola Foods, Headquarters, Global Procurement and Trading and other Company operations which report directly to Atlanta. Responsibilities included:• Review and analysis of the Annual Capital Expenditures Budget Submission, the Bi-Annual Capital Expenditures Commitment Status Report, Capital Project Requests, Requests for Authorization (RFAs), Corporate Structures committee items and other capital and financing agenda items.• Analyzed and facilitated authorization for key capital and financing transactions requiring approval by the Company’s Board of Directors, the subsidiary Board of Directors, the Corporate Structures Committee and/or Senior Management. Composed Board of Directors’ agenda white papers summarizing capital investment plans, financing activities and other transactions requiring review and approval by the appropriate committee or Headquarters function.• Business client consultant to the Electronic Forms Project Initiative. The Electronic RFA Initiative allowed Company-wide users to electronically fill, route, approve, manage, report on and archive RFAs with proper security. The extension of the Company’s on-line communication system allowed electronic transfer of forms with accompanying word processing, spreadsheet and graphic image attachments between all world-wide Company operations. Show less

  • Sr Manager, Consolidated Financial Systems at The Coca-Cola Company

    Nov 2004 - Feb 2021

  • Financial Systems Specialist IV - Lead

    Aug 2001 - Nov 2004

  • Senior Systems Analyst/MKT YRE Administrator

    Nov 1998 - Aug 2001

  • Coca-Cola Nestle Refreshments, Senior Financial Analyst

    Jul 1995 - Nov 1998

  • Controller's Group, Capital Management, Senior Financial Analyst

    Jan 1994 - Jul 1995

  • Controller's Group, Capital Management, Capital Management Administrator

    Dec 1990 - Jan 1994

  • Controller's Group, Capital Management, Senior Budget Assistant

    Apr 1984 - Dec 1990

  • Controller's Group, Budget & Financial Analysis, Budget Assistant

    Jan 1983 - Apr 1984

  • Controller's Group, Risk Management, Principal Staff Clerk

    Nov 1979 - Jan 1983