Jasmine Li
Cell: 647-***-****; Email: ********@*******.***
** ****** ****, ***********, ** L5M 1G7
EXPERIENCE
Walmart Canada, Nov 2004 - Present
(Walmart Canada operates a growing network of more than 300 stores across
the country with annual revenue more than 20 billion, employing over
85,000, headquartered in Mississauga, Ontario)
Senior Financial Analyst, Commercial Finance Division, (Mar 2007 -
Present), Ontario, Canada
. In charge of Merchandise planning and analysis for General Merchandise
Departments with 65 categories and CAD 700 million annual sales
. Partnered with VP Merchandising, directors and category managers to
deliver sales, gross profit and inventory targets across the business
units
. Prepared annual and quarterly budget at department and category level;
liaised with finance and merchandise divisions to negotiate
adjustments and achieve final commitments
. Provide Merchandising team with comprehensive product analysis to help
support future line plans
. Prepared monthly and quarterly financial and merchandise forecasts;
achieved high forecast accuracy, actively contributed to merchandise
teams in developing action plans,
. Responsible for pre-season and in-season sales/inventory analysis,
maintained monthly markdown and open-to-buy processes
. Provided value added information and advice to VPs, directors and
category managers in developing timely promotion, inventory and
purchasing strategies,
. Performed ad hoc analysis for various merchandise initiatives such as
ROI analysis for new product line and modular; inventory risk control;
category performance improvement; price parity and price gap analysis,
etc.
. Developed various Excel models to perform sales/inventory analysis,
mark-down/profit analysis, trend analysis, seasonal sell
thru/liability inventory control analysis and "what-if" scenario
analysis
. Trained Merchandise teams in utilizing finance reports, understanding
budgets and preparing forecast
. Trained fellow Merchandise Planner and summer interns
. Successfully completed a finance transformation project in Walmart
China during summer of 2012; helped establish its Merchandise Planning
team and system and train the Planning team based on Canadian HQ
planning model
Project Manager, Store Planning Division, (Nov 2004- Feb 2007), Ontario,
Canada
. Managed eight store opening, relocation and renovation projects
throughout Canada
. Responsibilities include project budget control, time and resource
planning, business training, system setup and intensive cross-
department coordination
. Managed project teams with about 20 people
. Obtained excellent performance reviews
Walmart China, Dec 1995- Oct 1998
Senior Fixture Buyer, Store Planning/Fixture Division, Shenzhen, China
In charge of fixture and equipment procurement for Wal-Mart Supercenter
fresh food department
. Performed start-up planning for the first five Wal-Mart Supercenters
and Sam's Clubs in China
. Established a fixture vendor network based on long-term relationship
and highest ethic standard
Mickey's Corner Stores Ltd., China, July 1992- Nov 1995
Operations Manager Shenzhen, China
. Managed eight Mickey's Corner stores, duties include merchandising,
distribution, store display, employee training and accounting
. Successfully turned around two unprofitable stores through marketing
campaigns, operation optimization and expense control
EDUCATION
University of Toledo, Toledo, Ohio
MBA, Dec 2000
Major: Information Systems Minor: Accounting
Wuhan University, Hankou Campus, Wuhan, China
BA, July 1992
Major: Chinese Language and Literature
COMPUTER SKILLS
Advanced MS Excel, MS Essbase, MS Access, Quaryman(SQL based), PowerPoint,
Retail Link, P4P, SAP,APT