Yiran Zhang

818-***-**** ac6n87@r.postjobfree.com www.linkedin.com/in/elaineyzh

QUALIFICATIONS

7+ years of Professional Finance experience Versed in multiple Financial Software Knowledge in Advanced Excel EDUCATION

Pepperdine University, Graziadio School of Business and Management Malibu, CA Master of Science in Applied Finance, Investments December 2016

• Volunteer: Special Olympics Southern California, Food Forward Shanghai University of Finance and Economics Shanghai, China Bachelor of Management July 2009

• Leadership: Chairman of Student Affairs Department at Office of Self-support Study PROFESSIONAL EXPERIENCE

Rapid Logistics LLC Los Angeles, CA

A developing provider of courier, logistics and transportation services in Southern California. Staff Accountant, Accounting Department Mar 2018 – Aug 2018

• Process daily final checks and semi-monthly payrolls for over 160 employees at 6 sub-companies

• Improve payroll processes and create standard operation procedures, increasing accuracy and productivity by 25%

• Assist the transaction from ADP RUN to ADP Workforce Now, becoming a master of ADP systems Mob Scene, LLC Los Angeles, CA

A full-service agency creating advertising and marketing content that connects with consumers across all mediums Accounting System Associate, Accounting Department May 2017 – Jan 2018

• Maintain/update Oracle cloud ERP system setup, making sure that changes related to new projects/jobs, system upgrades and accounting requirements are reflected timely

• Prepare and process biweekly payroll for over 150 employees with ADP, tracking compensation and applying deductions such as health insurance, 401(k), wage garnishments, taxes, etc.

• Create/update Oracle User’s Procedure, helping users to operate the system effectively

• Provides financial and payroll related reports in support of various business inquiries. Diamond Game Enterprises Chatsworth, CA

A public company that specializes in gaming products for North American lotteries and alternative gaming markets. Accounting Specialist(Internship), Accounting Department October 2016 – May 2017

• Process customer invoices, credit memos and post sales orders via Microsoft NAV for 2,241 machines

• Update revenue and commission analyzing models as well as invoices generating template on excel

• Comply Bank reconciliations and manage bank accounts for 6 accounts, total amount more than $1.7 million

• Assist in internal and external audits, ad hoc reports Tian’an Life Insurance Company Limited of China Beijing, China A rapidly developing nation-wide life insurance company with 170 branches across developed provinces of China. Supervisor, Financial Management Department of the headquarters July 2011 - May 2015

• Managed a team of four in launching and maintenance of Oracle Budgeting and Planning System, customized financial reports module, saving $112,500 and 7,800 in man-hours per year over an 8-month period

• Built over 38 financial models and 61 key performance indicators every year in Excel to forecast, test, and evaluate cash flows, revenues, expenses, and losses for Senior Management

• Analyzed sales and operating performance data through SAP and Excel for quarterly FP&A update across three sales channels totaling $86 million; Evaluated over $40 million in enterprise projects and $50 million in provincial branches New China Life Insurance Company Limited of China Beijing, China One of the four largest life insurance companies in China and one of the Fortune Global 500 in 2014. Accountant, Financial Management Department of the headquarters July 2009 - June 2011

• Managed 11 expense accounts of $308 million in headquarters on SAP platform, precisely reporting real-time statement to back up cash flow management

• Updated and presented annual expense-controlling guidelines for 16 departments within headquarters ADDITIONAL

• Financial Systems: SAP CO/FI, Oracle Hyperion Planning System, HAND Cost Controlling System, Microsoft NAV, QuickBooks, ADP RUN, ADP Workforce Now

• Computer Skills: Advanced Excel functions, VBA coding, Advanced financial modeling, PowerPoint, Word

• Language Skills: Fluent in English and Mandarin Chinese