Tina Tran
Sr. Financial Analyst at Carling Communications- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Vietnamese -
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
Carling Communications
-
United States
-
Advertising Services
-
1 - 100 Employee
-
Sr. Financial Analyst
-
2018 - Present
-
-
-
Mapp Digital
-
Netherlands
-
Research Services
-
Financial Analyst
-
2016 - 2018
-
-
-
CBS Television Distribution
-
United States
-
Entertainment Providers
-
100 - 200 Employee
-
Financial Analyst
-
2013 - 2016
• Prepared aging reports, monthly revenue forecasts and cash projections to forecast $2 billion in cash receipts o Reviewed licensing contracts with Sales and Legal team to address any issues that delayed signing or prevented payment o Identified and targeted regions with higher sales volume for renewals and potential new business to generate revenue • Collected various stations’ receivables and maintained a 2% or lower 90+ day receivable percentage • Managed monthly domestic and international accounts receivable portfolio that averaged $15 million • Worked closely with domestic and international Sales department personnel regarding account discrepancies and billing adjustments, as well as other internal and external departments to analyze and reconcile accounts when needed • Analyzed each accounts for any monetary or contractual issues to ensure sales projection can be met each month • Reviewed and analyzed daily international cash receipt to management and Executives to report status of monthly projections
-
-
-
MGM Studios
-
1 - 100 Employee
-
Participations Analyst
-
2011 - 2013
• Analyze and evaluate the general ledger in SAP to ensure accurate monthly financial reporting to profit participants • Support monthly closing process and preparation of monthly and quarterly financial statements • Evaluate revenue, participant share, and distribution figures to propose optimal audit settlement terms • Prepare profit participation accounting statements to producers and licensors, in accordance with contracts for rights or services on feature film and television product -Able to process detailed analysis of 100+ statements per quarter • Ensure the compliance of financial statements with complex contractual provisions for movie license deals with other major studios • Generate revenue and expense reports from OP-Pre and SAP that are utilized in monthly analyses to Executives • Handle high profile audits for Films and TV programs such as: James Bond and Rocky Balboa series • Identify and resolve variances between participation statements and the general ledger • Collaborate with Audit and Forecast teams to reconcile reports for pictures by comparing and analyzing plans -Evaluate variances and compare findings with Audit team to ensure accurate reports -Send weekly forecast emails to assist Forecast department in preparation of the annual business plan, along with the annual overhead budget • Create MS Pivot Tables and charts to analyze financial results and variances, identify trends and recommend actions for improvements • Collaborate with Directors and Managers to develop new ACCESS database system -Became subject matter expert of current ACCESS database and continuing progress to modify system, set to launch within the year -Manipulate the contents and inventory of 1,000+ titles from the MGM library
-
-
Education
-
UCSD
Bachelor of Arts (B.A.), Human Development