Shuo Yang
Mississauga,Canada
Summary
Analytical and detail-oriented data professional with 7+ years of experience in retail and market data environments, including current experience at TJX Canada. Strong background in inventory reporting, dashboard development, forecasting, and data-driven decision support. Advanced Excel and SQL skills with proven ability to optimize reporting processes and support business strategy. Seeking to leverage analytical expertise and retail knowledge in an Allocation Analyst role to drive profitable sales and inventory performance.
Overview
9
9
years of professional experience
1
1
Certification
Work History
- Additional experience in financial services, customer service, and administrative roles developed strong:
- Communication skills
- Stakeholder collaboration
- Process compliance
- Organizational abilities
Data Clerk
TJX Canada
06.2023 - Current
- Develop and maintain advanced sales and inventory dashboards to support allocation and distribution decisions.
- Analyze store-level performance data to identify trends, sales variances, and inventory imbalances.
- Support distribution modification processes to improve product flow and store assortment alignment.
- Generate routine and ad-hoc reports to assist business teams in tracking inventory-to-sales ratios.
- Assist in data validation and reporting accuracy to ensure alignment with sales plans.
- Collaborate with cross-functional teams to support data-driven decision-making.
- Improve reporting efficiency by streamlining data extraction and dashboard automation.
- Relevance to Allocation Analyst: Direct experience supporting inventory reporting, store-level analysis, and distribution adjustments within TJX’s retail environment.
Market Research Data Associate
Numerator
06.2017 - 05.2023
- Built and maintained dashboards tracking KPIs, sales performance, and consumer trends.
- Performed SQL-based data extraction and transformation for large retail datasets.
- Developed forecasting and predictive models to identify business growth opportunities.
- Conducted trend analysis to support strategic recommendations for stakeholders.
- Managed reporting environments including data sources, security, and metadata governance.
- Partnered with cross-functional teams to optimize reporting processes and improve efficiency.
- Presented analytical insights to senior management to guide strategic planning.
- Key Skills Demonstrated: Trend forecasting, sales analytics, cross-functional collaboration, strategic recommendations.
Accounts Receivable Clerk
Curtis International
10.2016 - 05.2018
- Generated AR aging and reconciliation reports to support financial planning.
- Investigated discrepancies and improved reporting accuracy.
- Maintained detailed financial records and ensured compliance with accounting standards.
Education
Bachelor of Arts - Honours Economics (Minor: Sociology)
McMaster University
Hamilton, ON06.2015
Skills
- Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, VBA, Power Query)
- SQL (BigQuery, MySQL)
- Data Visualization: Tableau, Power BI
- R Studio, Python
- Forecasting & Statistical Analysis
- ETL & Data Management
- Inventory & Sales Reporting
- Microsoft Office Suite
- Google Workspace
- Microsoft Dynamics GP
- GAAP Knowledge
- Fluent in English & Mandarin
Certification
Google Data Analytics Certificate
Timeline
Data Clerk
TJX Canada
06.2023 - Current
Market Research Data Associate
Numerator
06.2017 - 05.2023
Accounts Receivable Clerk
Curtis International
10.2016 - 05.2018
Bachelor of Arts - Honours Economics (Minor: Sociology)
McMaster University