Web Developer Sales

DIANE DIANE TING TING

**** *. ******** ****, *** G7, Hacienda Heights, CA 91745 626-***-**** *********@*****.*** EDUCATION

UNIVERSITY OF CALIFORNIA, LOS ANGELES Graduation: June 2013 Major: Economics Minor: Film GPA: 3.53

WORK EXPERIENCE

CBS GLOBAL DISTRIBUTION GROUP Financial Analyst Jun. 2013 – May 2015

Reconciled 90 bank accounts and ledgers monthly and helped update the bank reconciliation process to be more efficient, making the process shorten from a month to half a month to complete

Followed through with respective groups to clear reconciling items to be in SOX compliance

Processed royalties and entitlements and reconcile the deferred income ledger; processed all outstanding entitlements and left with a balance of $0.00 in the deferred income ledger

Tested new Access Database to streamline the process and wrote entitlement reports in updated Data Warehouse

Prepared and analyzed month end reports to create and process journals to assist with the month end close

Trained 2 interns to assist with entitlements, bank reconciliation and journal uploads; managed and reviewed tasks Financial Analysis and Reporting Intern Nov. 2011 – Jun. 2012

Created monthly TREC invoices for airline billings and assisted with fact-finding and data analysis through TVR

Prepared various ad hoc financial reporting and uploaded journal entries for month-end close UCLA COMPUTER SCIENCE Academic Personnel Assistant Jun. 2011 – Jun. 2012, Oct. 2012 – Jun. 2013

Prepared professors’ merit cases by completing forms regarding advised students and grants, compiling and verifying publications and other works, and ensuring accuracy and consistency across all sources

Relayed information and facilitated communication across departments to consolidate information for dossiers WALT DISNEY STUDIOS Production Finance/Post Production Intern Jun. 2012 – Sep. 2012

Audited bank signers on open bank accounts through constant communication with Treasury and Controllership

Compiled information on past shows’ shooting locations and their tax incentives and tracked each states’ tax incentive requirements that is used to help executives brainstorm and decide on locations to scout for new shows

Reconciled 12 shows through SAP, Global Vista and PSL3 for the Post Production Accounting department KCET Program Marketing Intern Mar. 2011 – Jun. 2011

Created proposals for programs that are used by Sales Team to sell underwriting spots to local businesses

Posted Nielsen ratings for all programs with close attention to detail for the Sales Team to deliver promised ratings to their clients, to generate interest for renewing contracts and to generate interest in prospective clients

Created a Ratings Comparison Report between KCET’s ratings and PBS’s ratings that is used by top executives for decisions on broadcasting schedules and that is used by the Sales Team to generate leads on sales LEADERSHIP / ACTIVITIES

ASIAN AMERICAN TUTORIAL PROJECT Finance and Transportation Director, Signatory Mar. 2012 – Jun. 2013

Applied for different sources of funding throughout the year and was awarded more than $10,000

Budgeted UCLA’s finances by distributing funds to transportation, food, printing, clerical supplies and special supplies and by monitoring these expenses as well as managing the inter-collegiate bank account

Planned transportation for 150 tutors and directors through buses and vans for weekly sites and special events Summer Co-coordinator Jun. 2012 – Aug. 2012

Organized teaching agendas, activities, and science experiments for 50 students and 15 tutors for 5 sites 4th Grade Tutor Apr. 2011 – Mar. 2012

Tutored students in Math and English for two hours every Saturday morning in Los Angeles’ Chinatown

Mentored them to start caring about school and help them overcome personal and cultural struggles SKILLS

Operating Systems: Microsoft Windows, Apple Mac OS X

Software: Microsoft Word, Excel, PowerPoint, Outlook, Access, Oracle, SAP, PSL3, HTML, CSS

Language: Conversational Mandarin Chinese, Basic Korean

Contact this candidate