Madeline Layson Mercado Email & Phone Number

Honolulu, Hi, Us

Responsible for assisting in the preparation of all reports and analyses projecting future financial results of Matson, Inc. (the Company). This includes, but is not limited to, developing and publishing the Three-Year Annual Operating Plan and the Mid-Month Estimate (MME or monthly forecast). These documents are for the internal use of Matson’s Senior Management and Board of Directors. Collaborate with management and staff throughout the company and its subsidiaries to ensure that the Company’s financial objectives are met and that various reports and analysis are prepared accurately on a timely basis. Responsible for managing the budgeting and forecasting system (Vena Solutions).

Honolulu, Hi, Us

Horizon Lines Hawaii operations was acquired by The Pasha Group and the remainder of the company was acquired by Matson Navigation in May 2015. Worked for Matson Navigation as a full time consultant to assist on various transitions and special projects that may include but not limited to: (1) Payroll Transition which includes costing, reporting requirements, and process improvements, (2) Development and implementation of the consolidation function within the Matson Oracle General Ledger module, (3) Improvements to the General and Administrative expense reporting process, and (4) Implementation of a forecasting and budgeting software (Vena Solutions).

Charlotte, Nc, Us

Manage budgeting and quarterly forecasting which includes consolidation, allocation of shared services, preparation of P&L statements and other budget reports, and functional administration of Hyperion Planning and Smart View. Oversee/process monthly closing and functional maintenance of Oracle and other financial systems. Manages two Financial Analysts responsible for accounting of $188M of labor and fringe expenses, $1B of revenue, and $6M volume and early pay discounts. Reports directly to the Corporate Controller.

Charlotte, Nc, Us

Monitored the operation of the Labor/Fringe system by maintaining system tables, coordinating system problems, enhancements and improvements, and preparing and updating user documentation. Prepared monthly/quarterly/annual Labor/Fringe reports for Corporate Management and external parties. Designed an excel budget model to accurately budget and forecast the Non Union Labor and Fringe expenses of $70M Prepared estimated $70M annual budget of Non Union Labor and Fringe. Prepared monthly overhead expense reports to send to all department heads.Reported directly to Manager of Financial Planning and Systems.

Charlotte, Nc, Us

Performed account analyses of various payroll and fringe accounts of Horizon Lines and its branches. Recorded cost of weekly/monthly domestic exempt, non-exempt, union, non-union and payroll tax and fringe via Labor/Fringe system and ensure proper and timely recording of these cost to General Ledger. Reported directly to Manager of Financial Planning and Systems.

Charlotte, Nc, Us

Performed due diligence for sold Asia branches of Sealand to Maersk including Oracle GL clean up. Played a major role in the conversion of mainframe based labor accounting system to Oracle.

Responsible for general and financial accounting functions for Singapore-based branch (Sealand Service Inc.), and its subsidiary (Sealand Logistics). Performed month-end closing, prepared balance sheet analysis, bank reconciliation, intercompany reconciliation, and coordinate with internal and external parties regarding the branch financial or accounting issues. Supervised associates handling the accounting functions of Sealand Logistics Asia companies. Reported directly to Finance Director.- Prepared process maps for all companies handled by the Finance Department of Sealand’s Asia processing center.- Picked from a team of 30+ to come from Philippines to United States to perform due diligence project.

Responsible for general and financial accounting functions for Singapore-based branch (Sealand Service Inc.), and its subsidiary (Sealand Logistics). Performed month-end closing, prepared balance sheet analysis, bank reconciliation, intercompany reconciliation, and coordinate with internal and external parties regarding the branch financial or accounting issues. Reported to Process Lead- Conducted onsite interview in Singapore for the work transition process for centralization of the accounting functions.- Trained Singapore finance personnel on the Oracle system specifically the GL Functions.

Conducted financial and operations audit of company’s accounting office and reviewed audit results of various branches. Responsible for preparation of audit plans and strategies. Supervised 6 junior auditors and reported directly to the Audit Manager.

Responsible for bookkeeping, customer billings, and disbursements. Reported directly to VP of Finance.- Prepared financial statements and performed bookkeeping functions.- Prepared daily cash position report and other financial reports.- In charged with disbursements scheduling and billings to customers

Managed time sheets, data entry, processed payroll, and prepared payroll reports required. Reported to the Payroll Master.- Processed payroll and other related payroll related reports to Government Agencies. - Assisted Payroll Master in improving the Payroll Department’s process.

Master Of Business Administration (M.B.A.), Accounting

Bachelor Of Science (B.S.), Accounting