Reporting Analyst

PROFILE:

A proactive and technical reporting and financial analyst with experience in the Public Service Organization, Information Technology, Education, and Mining industries. More than 5 years reporting analysis experiences: recommending improvements to automate and streamline overall reporting summary and design; reviewing, analyzing and understanding the data and data sources to ensure that all business requirements are met; familiar with business process and SQL database. With Master Degree of Accounting, I have solid understanding of business concepts and control requirements. Very proficient with Excel VBA, SAP, SQL and MS Access; able to work comfortably with large data sets and provide meaningful analysis of financial results and business process. Strong communication skill, able to work closely and effectively with cross-function departments and cross- entity employees. Very proactive to solve problems and seek out improvement and new methods. CORE COMPETENCIES:

• Technical computer skill • Strong analytical skill • Time management

• Self-starting/ self-motivated

• Communication / Interpersonal Skills

• Strong organizational skill

• Teamwork/ Collaborative

• Critical thinking

• Troubleshooting

TECHNICAL SKILLS:

• MS Access • VBA • MS Office

• Advanced Excel • SQL • SAP

CAREER PATH:

Quadient Canada Inc.

Accounting Analyst 2016 - Present

• Independently troubleshooting production issues and data irregularities and recommending improvements to automate, streamline and improve overall reporting summary and design.

• Analyzing and understanding the data and data sources to ensure that all business requirements are met. Validating the quality and integrity of the reporting processes and the data included in the reporting packages.

• Automating accounting manual process and highly improving the efficiency and accuracy.

• Performing standard weekly/monthly/quarterly reporting to help guide business decisions.

• Applying design and data analysis to illustrate data in visually innovative ways to make it easier to understand and be actionable by users. Performing testing, identifying any data quality or performance issues.

• Working closely with other regions’ offices and learning about their best practices and documenting the process; incorporating and making the best practices useful to business.

• Working closely with head quarter’s SAP support team to fix SAP errors, improve SAP settings, perform UAT for integration project of uploading Excel data into SAP; helping other regions (Mexico and Brazil office) to implement SAP system and providing training of SAP functionalities. Yang Zou 1108A, 9608 Yonge Street Richmond Hill, Ontario L4C 0X4 Telephone: 647-***-**** Email: *********@*****.*** Page 2 of 2

DE BEERS CANADA INC.

Accounts Payable Support 2015 - 2016

• Automated the expense batch run process and GL account reconciliation process by using excel VBA which saved 10 working hours per month and improved accuracy.

• Improved and streamlined the AP process to improve efficiency; documented the changes.

• Performed good cost control and cash management; reviewed and analyzed event-based allocations.

• Prepared expenditure reports to different divisions’ managers; tracked budget of cost assignments.

• Assisted with month end and year end close. Provided finance support to employees and managers. THE IELTS PREP CENTER

Financial Analyst 2015

• Captured and managed business requirements and led the translation of those requirements into technical and tool requirements to help deliver efficient and effective management solutions.

• Familiarity and comfort following the reporting lifecycle processes such as intake, business requirements, process maps, change request and user acceptance.

• Monitored business trend; performed financial budgeting and forecasting analysis.

• Updated financial data in databases to ensure that information was accurate and immediately available. JINAN RING EXPRESSWAY

Financial Analyst 2010 – 2012

• Worked directly with business audiences to structure analytical problems and approaches; structured the appropriate analytical approaches in a way that business audiences understood.

• Supported business requirements gathering to meet business needs. Used VBA and SQL to extract and analyze data sets and provided ongoing support and training to downstream users.

• Accurately and timely completed the preparation of financial reports, public service financial analysis and account reconciliations; provided finance support to employees and managers.

• Generated customized management reports and analysis reports using SQL and VBA.

• Identified improvements for month-end close process and internal control. EDUCATION AND PROFESSIONAL DEVELOPMENT

Chartered Professional Accountants of Canada (CPA), Chartered Professional Accountants of Ontario, expecting completion in 2019 Master Degree of Accounting,

Brock University, Canada, 2014

Bachelor Degree of Financial Management,

Shandong University of Finance and Economics, China, 2012

Contact this candidate