John Mitchell
Brantford, Ontario, N3R 7E8
*************@*******.***
PROFILE
A self-directed, customer service oriented professional with 12 years of
experience within the food services industry. Key strengths include
excellent analytical, creative problem solving and organizational skills
and is also a team player who is highly motivated and detail oriented.
Works most efficiently in a fast paced, ever changing work environment and
can be relied upon to consistently get the job done. Committed to
continuous learning and professional growth.
Professional Experience
Loblaw
Reporting Lead - Business Intelligence Pricing:
2012 - Present
o Lead discussions with committee for business pricing report
requirements
o Develop and maintain ad hock pricing reports
o Facilitate testing for all BI pricing reports
o Implemented training seminars for central merchandising on SAP
pricing data
Pricing Manager:
2010 - 2012
o Provide strategic insight, recommendations and analytical information
to execute effective pricing strategies.
o Implementation of weekly pricing transaction for Loblaw banners
nationally.
o Validation of SAP data including legacy data cleaning and system
testing for pricing procedures.
o Design, develop, and maintain pricing tool that utilizes system
information and provides users with excel interface.
o Maintain procurement product database for Produce business unit.
o Development of ad hock databases for merchandising and store
operations team.
Sobeys Ontario
Business Analyst:
2008 - 2010
o Responsible for all grocery department retail pricing for the Foodland
and IGA banners.
o Developed and maintain database to report on weekly sales analysis.
o Gather and analyze the requirements for reporting projects and project
opportunities.
o Reporting and analysis of banner pricing with projected impact to
overall margin, reflecting market changes.
o Cleansing of inconsistent SAP data, improving weekly processes by
approx. 80%.
Lumsden Brothers - Division of Sobeys Ontario
Data Integrity/Pricing Analyst:
2005 - 2008
o Reporting and analysis on banner rejected data.
o Modified merchandising databases to comply with SAP.
o Consistently provided customer support for store information system.
o Manage databases for Tradeshow and seasonal merchandisers.
o Provide category analysis using AC Neilson Databank.
Sobeys- Peterborough
Store Receiver/File Maintenance Clerk/ Cash office Clerk:
2001- 2005
o Responsibility of all store monies and pricing integrity.
o Perform nightly office balance, and weekly reset procedures.
o Provided cashier supervision and training.
o Accurately received approx. 30 orders weekly.
o Supervised implementation of new store pricing system.
Education
o Graduated Sir Sandford Fleming College in the Computer Support Technician
Program, 2003.
Professional Development and Achievements
o Sobeys Star Award, 2004.
o Sobeys Value Champ Winner, 2007.
o Received 5 Loblaw "Above and beyond the call of duty" awards
o Numerous internal workshops and seminars including:
Dealing with difficult conversations, 2006.
The art of influence, 2007.
Advanced Microsoft Access, 2009
Project management Essentials, 2012
Computer Skills
o Proficient in SAP, Powerterm software, AS 400, and BW (Business
Warehouse).
o Creation/Manipulation of Access databases.
o Computer Programming in C++, Visual Basic.
o Business intelligence Software - Webi/OLAP/SAS/SQL server
o Microsoft Operating systems/ Microsoft Office.
VOLUNTEER/COMMUNITY EXPERIENCE
o Active volunteer at Round Lake Cottagers Association.