Livermore Ca. *****
Day Phone 510-***-****
Home Phone 925-***-****
********@*******.***, Judith D. Guin
Experience 8/08 - Present Daymon Worldwide @Safeway Pleasanton
Ca.
Business System Analyst
. Edit and write queries for Teradata and QMF.
. Trainer for Daymon users on SSIMS, PACS, QMF, QMF Windows, Crystal
Reporting and Teradata.
. Worked with Pricing, Consumer Demand, Daymon Team, and Safeway Project
and Strategy Teams for creating a process for Item Type Codes, Manufacture
Type Codes and Brand codes.
. Worked with Pricing and Consumer Demand dept to complete the competitor
brand match of items.
. Trained the Suppliers on Forecasting Integration Planning system (FIP).
. Created PowerPoint slides for training in FIP.
. Setup Daymon Analyst locally via Safeway network for AC Nielsen
connections instead of going through citrix. Tested access for any issues
that may occur for analyst, walked them through download setup.
. Transition Daymon laptops to Safeway laptops for 80 users within a two
month time frame.
. Troubleshoot issues for Supplier such as forecasting issues, late
forecast, demand, and shorts.
. Create step by step processes for the Safeway systems so Daymon users
could navigate through them without any issues.
. Ordered Daymon laptops or placed request for Safeway laptops for new
hires.
. Upon employee terminations sent emails out to all appropriate parties for
removing access for Safeway and Daymon.
. Asset tracking, troubleshooting any software/hardware issues for IRI and
AC Nielsen. The main point of contact for Safeway and Daymon on any IT
issues with laptops.
. Installing software, virus scans, set up of new laptops and Outlook email
accounts
. Created Access Databases for Asset Recovery Programs, Training and IT
issues.
. Created Training matrix and class schedules reviewed with upper
Management.
. Setup computers for training to make sure all systems were working
. Create all material for training and post via shared drives.
Accomplishments:
Three projects completed in less than a year's time.
Experience 08/07-08/08 Daymon Worldwide @Safeway Pleasanton
Ca.
Category Analyst-Main Meal/Main Meal Ingredients
. Run IRI and AC Nielsen data for category-such as Sales, Units, and
Promotions
. Runs Teradata PSW reports weekly for team.
. Creates pivots tables for Business Managers.
. Category Reviews in PowerPoint.
. Create Reports for other Analyst and Teams using QMF and Teradata.
. Trains Daymon people in Safeway systems such as SSIMS-QMF-PACS.
. IT person with Installation of SSIMS, PACS, QMF and Teradata.
. Troubleshoot for Safeway system issues for the Daymon employees
. Year over Year Analysis 2008 for Suppliers that include Promo Price for
past current and future, Unit Cost, Retail Cost for year 2007 and
. Run volume reports in IRI and QMF for Business Manager Monthly.
. Worked with Safeway Admins to make sure Daymon new and terminated
employees are either set up for all Safeway systems or removed from
Safeway systems.
Accomplishments:
Learning to write SQL
Experience 8/06-8/07 Daymon Worldwide @Safeway Pleasanton Ca.
Business Unit Services
. Ran on Hand reports daily for Suppliers modifying them and adding
calculated the weeks on hand.
. Ran Service Level Reports Daily for Suppliers and a few Main Meal
Suppliers.
. Sent and modified copy of Forecast Report to Suppliers.
. Created New Item Forms and turned into the Safeway Associate Buyer
Consumer Brands.
. Updated costs from the suppliers and sent them to the Consumer Brands
Associate Buyer.
. Created Processes for Daymon and Safeway.
. Inputted all Edeals for my suppliers
. Set up Edeal Accounts for the Daymon Suppliers.
. Liaison between Buyer and Suppliers for any issues or concerns with
orders, OOS, late deliveries, PO shorts.
. Created Access Database for Daymon discontinued items.
. Sent out daily/weekly reports of discontinued items or transition items
that may have wrong status in SSMIS.
. Trained Homecare staff on how to modify forecast reports for Suppliers
and how to understand SSMIS for forecasting and buying.
. Entered PO's into Daymon system OMS.
. Joined the Safeway Scorecard Meetings for my Suppliers, helping with
Action Plans concerning Supplier for the Daymon/Safeway side of things.
Accomplishments:
I started other Business Units on helping out the Safeway with the
Scorecarding side of things-such as creating reports, simplifying forecast
reports for Suppliers so they understand it better.
Experience 03/06-8/06 Safeway Pleasanton Ca.
Schematic Supervisor
. Created/Updated schematics for Spices, Breakfast, Canned fruits,
vegetables and meats, Salty Snacks, Coffee/Tea/Cocoa, and Baking Products
for all division.
. Monthly conference call on categories to see if any problems or concerns
for upcoming resets.
. Ran issue list for Consumer Demand for no PO's or any other issues that
may cause delay for resets and projects.
. Made sure UPC's were correct in the system and on schematic before
release to stores.
. Created add and delete list for CD and Stores.
. Performed store check s of categories to see that product was set by
schematic.
. Delegated to Vendor Partners what needed to be done for Projects, Reset,
Remodel and Pull in Plugs
. Made sure vendors followed guidelines to reset room such as cleaning up,
safety and shelf space.
. Liaison between Vendor and Consumer Demand.
. Liaison between store stocking and Consumer Demand.
Experience 09/02-03/06 Safeway Pleasanton Ca.
Procurement Specialist
. Bought and created PO's for all Cough Cold, Allergy, School products,
Paper, Family Care, Home Care, Maintenance, and Garden.
. Ran daily reports on Finances, late PO's, warehouse inventory levels, age
inventory, restricted items, shorts and on hand quantities.
. Lead Buyer for the GM/HBC buyers, helped out with issues when and if
needed.
. Backed up the Manager when on vacation
. Communicated with vendors and warehouse daily on any issues with
products.
. Training Coordinator for New Buyers
. Trainer for Outlook
. Point person for special projects within my Procurement team and
Consumer Demand.
. Inventory Management to keep my cost down.
. Created and updated excel spreadsheets for Vendors on their discontinued
items and age inventory in warehouse.
. Assisted Manager's with special projects.
. Updated Return to Vendor Access Database.
. Sarbanes-Oxley (SOX)
Accomplishments:
. Received GEM Award by fellow buyers.
. Received Recognition from Procurement VP.
Education:
1978-1982 Livermore High Livermore CA. High School
Graduate.
1984-1985 1 year College Los Positas
2010 Working on Microsoft Certifications
Computer Knowledge:
Word 97-2007
Excel 97-2007
Access 97-2007
PowerPoint -97-2007
Outlook 97-2007
Win 95-2000
Windows XP
Windows 7
Visio
SAP
Adobe Acrobat
Tera Data
IRI
AC Nielsen
Crystal Reports
Business Objects
Certificates:
. Quality Training (ISO 9001)
. Access 97 -2000 Intermediate & Advance,
. Word 97&-2000
. Excel 97-2000
. Windows XP