Highlights:Excellent bilingual skills in English and Mandarin Chinese. Proficient in conducting financial reporting and analysis, forecasting, and performing corporate valuation. Skilled in designing streamline projects using advance Excel functions. Experienced in using Oracle/SAP systems in both private and public sectors.

Skills:US GAAP, Microsoft Access, Cost analysis, Microsoft Excel, Microsoft Word, Oracle, Financial reporting, Mandarin Chinese, English, Microsoft Powerpoint, Adobe Photoshop, Streamline project management, IFRS, IAS, Customer service, Excel Macro, Pivot Table, Vlookup, Training, CMA certified, CPA eligible, Financial modeling, Access query, Access report, variance analysis, bank reconciliation, SAP, Sage 50 accounting, contract review

Goal:Certified Management Accountant (CMA) with 5 years' accounting experience and masters in accounting seeks full-time position.

Membership:Beta Gamma Sigma, Member Institute of Management Accountants, Member AICPA, Member

Certification:CMA (Certified Management Accountant), USA; IMA (Institute of Management Accountants), 04/2014, No. 41932 Certificate of Accounting Professional, China; Shanghai Municipal Finance Bureau, 06/2011 Certificate of China Banking Professional (CCBF), China; Shanghai Banking Association, 08/2009

Honor:B.S. Economics with Honors (International Economics and Trade) B.A. Business with Honors (Industrial Business Management) Beta Gamma Sigma, Member

Accountant 08/2012 - current
University of Illinois at Chicago, CUPPA, Urban Transportation Center, Chicago, IL United States
Industry: Transportation, Education
Financial reporting, financial analysis for approx. 3 million funds from over 30 grants contracts and other sources.
Prepare journal entries, monthly financial reports and ad hoc reports. Reconcile ledgers to UIC accounting system monthly. Analyze budget/cost variances and unusual transactions to resolve irregular postings and to correct errors. Write queries and assist in developing reports for a productivity database which monitors and measures efficiency of work done on research projects. Assist financial director as needed with financial and administrative functions. Achievements: * Design compatible Excel templates for productivity data import which doubled data input efficiency. * Work on a special streamline project for Illinois Dept. of Transportation to design an automated RFP (Request for Payment) system for federal and state grants. Decrease average error rate of reports preparation and payment review by more than 80%. Create central database for data collection and analysis using Excel macros, pivot table and Access database.--
Accountant for Corporate Service 07/2008 - 07/2011
China Construction Bank, International Business Department, Shanghai, Shanghai China
Industry: Bank, International Trade
Perform bookkeeping, financial analysis, customer service, staff training at district center branch serving over 500 corporate customers.
Reviewed and recorded average 60 transactions per day. Processed average 30 applications per day for currency exchange payments and deposits. Performed financial reporting and extensive analysis for the Branch's executive team. Conducted inquiries for corporate customers and answered questions to clarify government regulations and requirements. Achievements: * Completed five-year trainee program for five positions in three years with outstanding performance. Revise and update internal manual and training materials for three positions. * Led workflow optimization project for letter of credit issuance, shortening the internal process time by 50%. * Won best thesis award in 2011 youth creative forums of China Construction Bank, Shanghai Branch. Presented the thesis to headquarter executives.--

Shanghai University 09/2004 - 06/2008
Shanghai, Shanghai, China
Degree: Bachelor's Degree
Major:International Economics and Trade
GPA 3.32/4.0(Top 6%) First Prize Scholarship

Lubing Zhang Resume * CMA certified; CPA eligible * Excel Macro/Pivot Table/VLookup * Streamline project management * Customer service/Training * Financial analysis/modeling * Access query/report design * Cost/Variance Analysis * Bank Reconciliation * Bilingual in English & Mandarin * SAP, Oracle, Sage 50 Accounting * US GAAP/IAS/IFRS reporting * Contract review