Michael Bato

Handled participant statements prepared in various frequency monthly, quarterly and yearly.

• In preparing statements included reviewing contract deals and preparing short briefs for system set ups in SAP.
• Prepared volumes of wire transfers in which verify coding accuracy.
• Prepared P&L analysis and statement reconciliations
• Communicated with IT and various departments on resolving issues.
• Worked with business unit managers to provide quick resolution for submittal to client.
• Extracted data from reporting tools verification and analyze accruacy.

• Prepared quarterly cash flows.
• Prepared P&L analysis and statements reconciliations.
• Prepared monthly payment summaries for various contractual participants.
• Gathered and prepared monthly payment schedules for SOX audits.
• Prepared audit and ad hoc schedules from data sources for management's review.
• Developed automated process and tally verification in preparing multiple statements thru Excel.
• Analyzed and summarize data thru system source such as Peoplesoft Oracle and linked Access database.
• Assisted and resolved IT developers and management on In house systems issues.
• Prepared volumes of wire transfers with accuracy.
• Verifying and adding clients to department system for invoice processing and wire or check payments.

• Evaluate and process new applicants through In-House client repository system.
• Review and analyze contracts for producing accounting statements.
• Other duties are assisting data analyst in database processes with departmental systems such as Media Maestro, RRS and Peoplesoft Oracle systems.
• Participated in resolving with department issues with directors and I.T.
• Ablilty to multitask with various projects and prepared ad hoc schedules for management.
• Handled complex participant contracts such as: DreamWorks Animation Ltd., MGM Entertainment, TSG Entertainment, New Regency and Lucasfilm Ltd in preparing timely statements.

• Preparing monthly and quarterly royalty statements to various participants.
• Conducted and assisted managers on various audits and provided ad hoc schedules for manager's decision making.
• Reviewed home entertainment acquisition agreements on accuracy of statement preparations.
• Maintaining P&L accounts and various calculated rules based on contract agreements.
• Prepared monthly journal entries and accrual adjustments as needed.
• Knowledge with programming in Paradox database, as well as adapted understanding of script writing and complex equations.
• Knowledge on creating scripts, modules and macros in Excel and Lotus Millennium.
• Trained employees with statement processing with various department systems.

• 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.