Sinclair Liu Email & Phone Number

M&A, Debt Placements, Transactional Advisory

• Conducted financial analysis for the Residuals Department; responsible for the residual and royalty payments for Sony owned features and TV shows. Oversaw billing cycle and invoice processing including reviewing invoice batching and processed invoices for SOX compliance.• Performed routinely data mining and manipulated enormous amount of data in order to generate accurate and speedy payments for various guilds, individual talents on rigid deadlines.• Expert in manipulating large amount of data through Excel and VBA. Heavily utilized common Excel practices such as Pivot Tables, conditional formatting, v-lookups, “if/and” etc. Created templates and macros which shortened the monthly and quarterly payment process while improving accuracy. • Responsible for over $60 million quarterly payments on average. Thorough system knowledge regarding SAP, Cognos, Access.

Santa Clarita, Ca

Financial Analyst May 2011 to September 2011• Assisted CFO and top financial managers directly for the creation of the revenue/cost forecast for the fiscal year 2012; involved in the monthly and quarterly forecasting processes.• Conducted budget vs. actual analysis; prepared monthly financial statement for internal use.• Participated and assisted the budget allocation process towards more than 20 departments; budget size totals more than 1 billion dollars• Created and provided various Excel/VBA templates and models to aid analysis, as requested by financial managers; provided error checking and corrections for team members’ excel sheets and presentations.• Coordinated and extracted financial data from various department for consolidation; analyzed and presented collected data to top management• Provided and presented cost cutting and process optimization inputs to top management

Century City

• Retrieved and compiled various investment researches using company’s data platform and provided additional data gathering services for various managers.• Involved in the template creation and modification processes for visualization of stocks’ performances.• Participated in meetings and seminars regarding investment opportunities; assisted in hosting various business meetings and luncheons.• Provided input and feedback regarding various teams’ investment strategies.

Managed translation and interpretation services for US Drug Enforcement Administration (DEA) and the Department of Homeland Security (DHS)Conducted surveillance and participated in the interrogation process;