Yan Jing Yang
Ottawa,Canada
Summary
Analytical and detail-oriented professional with experience in financial analysis, data management, and procurement support. Skilled in working with large datasets, developing pricing tools, and supporting policy development through research and collaboration. Proven ability to streamline processes, communicate effectively across teams, and apply data-driven insights to support strategic decisions in public sector environments.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Accounting Assistant
Public Services and Procurement Canada
08.2023 - Current
- Worked under the Procurement Branch, Procurement Support Services Sector
- Self-studied to better streamline data-related processes, improve accuracy and efficiency in financial reporting.
- Researched industry trends and market pricing using public sources and private databases; drafted trend reports to inform management-level price negotiations.
- Replaced third-party pricing with publicly sourced rates by replicating rate structures previously generated by FTSE Russell, increasing transparency and reducing external dependency.
- Reviewed and updated financial rates, cost benchmarks, and pricing models for use in large-scale procurement and pricing assessments.
- Led the Rate Card Project, overseeing the extraction of contract data, building a searchable rate database, performing analysis, and building a new standard to be used by the department.
- Supported the FinCap project by conducting reviews and analyses of financial statements to assess companies’ financial health
- Contributed to major publications, including the Practitioner’s Guide for Procurement Pricing updates and Policy Notifications (PN) release.
- Conducted research on modern accounting practices, pricing methodologies, and technical financial issues to strengthen procurement policies.
- Interviewed guide users to gather feedback and recommendations for future updates, incorporating user experience into documentation improvements.
- Developed and maintained tools, guidance, and training materials to support financial advisory and procurement operations.
- Proofread and enhanced internal guides on contract pricing, rate negotiation, price certification, and policy compliance to ensure clarity and consistency.
Server
Edoko Japanese Steak House
02.2023 - 07.2023
- Developed time management and prioritization management, particularly during high-pressure holiday seasons.
- Managed cash transactions with accuracy and reported daily net earnings, great attention to detail and numerical proficiency.
Junior Analyst
Statistics Canada
01.2023 - 04.2023
- Worked under Global Measurement - International Accounts and Trade Division (IATD)
- Gained working knowledge of the structure and operations of multinational enterprises (MNEs) through applied data analysis and participated in the publish of RY2022 AMNE research article on The Daily.
- Developed familiarity with key international trade characteristics, supporting economic and trade-related research. Participated in the publish of RY2022 TEC TIC research article on The Daily.
- Created and refined Excel pivot tables to organize complex datasets and extract meaningful insights.
- Imported, coded, filtered, and sorted large datasets for analytical use, ensuring data integrity and usability.
- Utilized SQL in SAS Enterprise Guide (EG) to process and analyze high-volume data for statistical reporting.
- Conducted targeted research and recorded key financial details from corporate annual reports and annual information forms to support analytical projects.
- Supported senior analysts with ad-hoc data analysis requests, ensuring accurate results were delivered in a timely manner.
Office Associate
N-able
05.2022 - 11.2022
- Data Entry & Data Hygiene on Salesforce
- Data import, sort, check and fix on Excel
- Help departments with company projects and month-end reports
- Ad-hoc projects from the management team
- Represent company's products and services with a comprehensive understanding and identify how our solutions meet consumer needs
- Identify prospect's needs and suggest appropriate products/services
- Proactively seek new business opportunities in the market
- Generate leads, find new potential sales and build relationships
- Identify best practices to refine the company's lead generation playbook
- Utilize SalesForce, cold calling, and email to generate new sales opportunities
- Report to sales manager with weekly, monthly, and quarterly results
- Set up appointment and follow up on calls
Server
Japanese Village Restaurant
11.2018 - 02.2020
- Demonstrated strong multitasking skills by managing multiple tables simultaneously without compromising service quality.
- Served food and beverages promptly with focused attention to customer needs.
- Collaborated with team members during busy shifts for efficient workflow and excellent guest experiences.
Online Trader
Self-employeed
01.2012 - 12.2015
- Online marketing and trading in a virtual game evolved into real money trading and generated decent $ as a teen.
Performer
CultureLink Settlement and Community Services
06.2011 - 09.2011
- Worked with 7 other youths in The Summer Youth Theatre Program support by the Canadian Summer Jobs program.
- Gave performances on stage for Enrichment Foundation's 'Multicultural Day'
Education
Honours Bachelor of Commerce - Specialization in Accounting
Telfer School of Management At The University of Ottawa
12.2025
Honours Bachelor of Commerce - Finance
Telfer School of Management At The University of Ottawa
12.2024
BBA - Financial Mathematics
Toronto Metropolitan University
04.2018
Skills
- Data inputting
- Microsoft Excel proficiency
- Financial analysis
- Data entry
- Attention to detail
- Data analysis
- Finance
- Expense tracking
- Data processing
- Cost accounting
- Budgets and forecasting
- Financial statement analysis
Websites
Certification
- Excel Fundamentals - Formulas for Finance
- Worker Health and Safety Awareness in 4 Steps
- Japanese Language Proficiency Test N3
- Smart Serve Ontario
- JPMorgan Chase - Investment Banking Job Simulation
Languages
English
Native or Bilingual
French
Elementary
Chinese
Native or Bilingual
Japanese
Professional Working
Degree
Dual degree, BCom Finance & Accounting with Cum Laude distinction, BSc Financial Mathematics
Accomplishments
- Collaborated with team in the development of first ever database in PSPC.
- Used Microsoft Excel to develop cell automation to save the need for manual data entry
- Successfully released the data on time through effectively improving the data entry process
Timeline
Accounting Assistant
Public Services and Procurement Canada
08.2023 - Current
Server
Edoko Japanese Steak House
02.2023 - 07.2023
Junior Analyst
Statistics Canada
01.2023 - 04.2023
Office Associate
N-able
05.2022 - 11.2022
Server
Japanese Village Restaurant
11.2018 - 02.2020
Online Trader
Self-employeed
01.2012 - 12.2015
Performer
CultureLink Settlement and Community Services
06.2011 - 09.2011
Honours Bachelor of Commerce - Specialization in Accounting
Telfer School of Management At The University of Ottawa
Honours Bachelor of Commerce - Finance
Telfer School of Management At The University of Ottawa
BBA - Financial Mathematics
Toronto Metropolitan University
Similar Profiles
Terry CaetanoTerry Caetano
Project Development Coordinator at Public Services and Procurement Canada | Services publics et Approvisionnement CanadaProject Development Coordinator at Public Services and Procurement Canada | Services publics et Approvisionnement Canada
Jennie RathwellJennie Rathwell
Senior Planning Advisor (AS-06) at Government of Canada – Public Services and Procurement Canada – Departmental Oversight Branch – Business planning and Management servicesSenior Planning Advisor (AS-06) at Government of Canada – Public Services and Procurement Canada – Departmental Oversight Branch – Business planning and Management services
Alexander BouvierAlexander Bouvier
Casual Contract - Administrative Assistant at Public Services and Procurement CanadaCasual Contract - Administrative Assistant at Public Services and Procurement Canada
Jayden McDonaldJayden McDonald
Customer Service Sales Specialist at LCBOCustomer Service Sales Specialist at LCBO
Daniel OkankwuDaniel Okankwu
Server at Sunrise of WindsorServer at Sunrise of Windsor