Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Michael Bato

Rowland Heights,CA

Summary

Position in Finance Department, providing opportunity to make a strong contribution by utilizing and expanding upon related education, skills, experiences and capabilities. I am a self-starter with plenty of years of experience. My strengths are analytical and a responsible worker.

Overview

30
30
years of professional experience

Work History

Senior Contract Reporting Analyst

The Walt Disney Company (Twentieth Century Inc.)
01.2019 - 07.2023
  • Prepared P&L analysis and statements reconciliations.
  • Prepared monthly, quarterly and yearly payments for various participants.
  • Reviewed contracts and prepare briefs for system set ups in SAP.
  • Communicated with various departments on various discrepancies.
  • Prepared wire transfers and verify coding accuracy.

Senior Financial Analyst

Twentieth Century Fox Film Corporation
01.2015 - 01.2019
  • Prepared quarterly cash flows.
  • Prepared P&L analysis and statements reconciliations.
  • Prepared monthly payment summaries with for various participants.
  • Managed monthly department payment schedules for SOX audits.
  • Prepared various audit schedules from collected data sources for management’s review.
  • Developed automated system process of multiple statements with use of Excel with tally verification.
  • Analyzed and summarize data between Peoplesoft and Access databases.
  • Assisted system developers and management on In house systems issues.
  • Prepared wire transfers with accuracy.
  • Verifying and adding vendors to system for payment processing.

Financial Analyst

Twentieth Century Fox Film Corporation
01.2006 - 01.2015
  • Evaluate and process new applicants through In-House vendor repository system.
  • Review and analyze contracts and propose accounting treatment.
  • Other duties are assisting data processor in database processes with department systems such as Media Maestro, RRS and Peoplesoft systems.
  • Participated with managers and I.T. meetings concerning department issues.
  • On a daily basis teams met to solve department’s deadlines.
  • Responsible for high profile statements such as: DreamWorks Animation Ltd., MGM Entertainment, TSG Entertainment, New Regency and Lucasfilm Ltd contracts.
  • Able to multitask with various projects and adhoc schedules.

Royalty Accountant

Twentieth Century Fox Film Corporation
01.1997 - 01.2006
  • Preparing monthly and quarterly royalty statements to various participants.
  • Conducted and assisted managers on various audits and adhoc schedules.
  • Reviewed home entertainment acquisition agreements on accuracy of statement preparations.
  • Maintaining P&L accounts and various calculated rules based on individual licensor's.
  • Preparing monthly journal entries and adjustments as needed.
  • Experienced with programming in Paradox database, adapted understanding of script writing and complex equations.
  • Acquired ability to create modules and macros in Excel and scripts for Lotus Millennium.
  • Training new employees with the statement processing and various company systems.

Staff Accountant

Hurst Graphics, Inc.
01.1994 - 01.1996
  • Preparing monthly financial statement and other month end reports.
  • Maintaining daily cash journals, monthly bank reconciliation and merchandise inventory ledger reconciliations.
  • Managing the accounts receivable department.
  • Maintaining and analyzing aging receivable reports.
  • Handled duties such as credit approvals and collections on delinquent vendors.
  • Experienced in maintaining a billing system in accounts payable area and conducted audits on inventory from physical warehouses.
  • Assisted and processed bi-weekly employee payrolls.
  • Trained new employees and maintained good customer relations.

Education

Bachelor of Science in Accountancy -

Centro Escolar University
Manila, Philippines

Undergrad in Telecommunications - undefined

Devry
Pomona, CA

Skills

Well experienced with various financial systems such as MediaMaestro, Peoplesoft, JDE, Atlas and SAP Certificate of course completion with Excel 2010 and Access 2010 Advance Skilled with Microsoft Office 2017 – 2002 on applications such as Access (creating database queries and building reports), Excel (pivots, conversions, joining formulas as sumifs, vlookups and indexing, writing and developing macros and building modules)

undefined

References

References are available on request.

Timeline

Senior Contract Reporting Analyst

The Walt Disney Company (Twentieth Century Inc.)
01.2019 - 07.2023

Senior Financial Analyst

Twentieth Century Fox Film Corporation
01.2015 - 01.2019

Financial Analyst

Twentieth Century Fox Film Corporation
01.2006 - 01.2015

Royalty Accountant

Twentieth Century Fox Film Corporation
01.1997 - 01.2006

Staff Accountant

Hurst Graphics, Inc.
01.1994 - 01.1996

Bachelor of Science in Accountancy -

Centro Escolar University

Undergrad in Telecommunications - undefined

Devry
Michael Bato