Junru(Lily) Chen
Waterloo,Canada
Summary
Detail-oriented and tech-savvy professional with extensive experience in transaction processing, data entry, and financial reporting. Proficient in advanced Excel functions (Macros, VLOOKUP, Pivot Tables, INDEX-MATCH) and experienced in operating ERP systems like Oracle. Adept at ensuring accuracy and compliance with industry regulations in a fast-paced, high-volume environment. Demonstrated ability to work well under pressure, quickly adapt to new systems, and contribute to team effectiveness. Currently pursuing the Chartered Financial Analyst (CFA) designation to further enhance financial analysis and operational skills.
Overview
7
7
years of professional experience
Work History
Treasury Analyst
Shenzhen Metro Real Estate Group Co., Ltd.
07.2021 - 02.2024
- Spearheaded the daily management of corporate liquidity, ensuring optimal cash flow and handling significant wire transfers aligned with corporate financial strategies.
- Prepared detailed Monthly cash forecasts on a rolling 6-month basis, continually updating forecasts based on actual banking activity and analyzing variances to maintain sufficient liquidity.
- Collaborated with Accounts Payable/Receivable and Finance Operations to assess short-term funding needs and model the cash flow impacts of long-term financial trends.
- Spearheaded strategic initiatives including the issuance of Asset-Backed Securities (ABS) and led the successful issuance of a $276 million real estate REIT, performing due diligence, strategic planning, and operational execution. Emphasized compliance with ESG principles in the development of the company's first carbon-neutral REITs.
- Prepared and presented detailed treasury reports using Advanced Excel and Word, extracting detailed ledger data from Oracle financial systems. Reports included cash flow forecasts, cash allocation statements, budget variances, and financial expense budgets.
- Managed over $1 billion in development loans and shareholder borrowings, negotiating reduced interest rates based on market trends to save $28 million.
- Performed monthly bank reconciliations and cleared transactions to guarantee accurate financial reporting; prepared treasury-related journal entries including adjustments for bank fees and interest.
- Facilitated internal and external audits by providing essential documents and effective communication, ensuring adherence to established financial policies and regulatory standards.
- Evaluated banking relationships to optimize service levels, minimize fees, and maximize interest income on excess balances.
- Collaborated with IT to develop and implement a treasury management system, automating financial reporting and enhancing data accuracy.
- Actively engaged with cross-functional teams to ensure seamless financial operations and to drive process improvements across the treasury function.
Assistant Auditor
GuangDong ZhongZhiXin Certified Public Accountants
07.2019 - 09.2019
- Verified over 300 vouchers against invoices to ensure accuracy in financial reporting.
- Utilized advanced Excel functions including RAND, VLOOKUP, Pivot Tables, and INDEX-MATCH for detailed audit data analyses and sampling tests.
- Collaborated with client finance teams to expedite audit processes and deliver reliable financial assessments.
Customer Service Assistant
China Construction Bank
06.2018 - 09.2018
- Managed over 10 daily banking tasks such as money transfers, withdrawals, updating personal information, and issuing replacement debit cards, leveraging digital tools to ensure accuracy and prompt service.
- Proactively identified and fulfilled customer needs by introducing credit card products during interactions, successfully facilitating issuance of over 20 credit cards during spare time.
- Recognized and acted upon potential investment opportunities for clients by engaging in meaningful conversations, promptly referring them to financial advisers to explore further financial solutions.
Administrative Intern
Guangzhou Hengjian Investment Holdings Co., Ltd.
Guangzhou, China
06.2017 - 07.2017
- Supported investment project management through effective information organization and data entry, aiding in project execution and decision-making.
- Assisted in the preparation of project documentation, ensuring compliance with company standards and regulatory requirements.
- Reduced errors in data entry tasks by maintaining thorough attention to detail and verifying information before inputting it into the system.
Education
Bachelor of Commerce, Finance Specialist -
University of Toronto
06.2020
Skills
- Advanced Excel Skills
- Basic programming skills (Python, SAS, SQL)
- Strong Typing Skills (67 wpm)
- Strong Attention to detail
- Tech-savvy and Quick Learner of New Systems (ERP, Oracle)
- Excellent Communication Skills (English, Mandarin)
- Office Administration
- Financial Reporting and Month-End Journal Entries
Hobbies
Passionate about music, proficient in playing guitar, ukulele, and piano through self-directed learning. Enjoys singing and a variety of leisure activities including computer gaming, board games, and hiking. Values quality time spent outdoors and socializing with friends through engaging and interactive experiences.
Timeline
Treasury Analyst
Shenzhen Metro Real Estate Group Co., Ltd.
07.2021 - 02.2024
Assistant Auditor
GuangDong ZhongZhiXin Certified Public Accountants
07.2019 - 09.2019
Customer Service Assistant
China Construction Bank
06.2018 - 09.2018
Administrative Intern
Guangzhou Hengjian Investment Holdings Co., Ltd.
06.2017 - 07.2017
Bachelor of Commerce, Finance Specialist -
University of Toronto