Kathleen A. Arroyo
Denver, CO **206
PROFESSIONAL
EXPERIENCE TUFF SHED, INC.-DENVER, CO
Data Analyst-Home Depot Division
Sept. 2007-
March 2009
• Implemented any SKU price changes, Spec Updates or other item maintenance for the Home Depot System
• Addressed any Home Depot Call Center SKU Issues such as short pays, cost errors or item descriptions in a timely manner
• Usage of JD Edwards system to manage sales, lot shed orders, and management of Home Depot Store information
• Used Business Objects to build, run, and analyze sales reports
• Advanced use of Microsoft Excel to clean and organize data, paying strict attention to detail
• Administrative Duties: Arrange business travel and take care of expenses for the Director of National Sales
TRUE VALUE COMPANY- CHICAGO, IL
Merchandising Assistant - Merchandise Supply Chain, Appliances & Electronics Dept.
Jan. 2006-
Sept. 2007
• Fielded incoming requests and concerns from Members/True Value store owners and vendors and acted on them appropriately
• Served as a liaison between Members and other operational functions (marketing, accounting, inventory management, distribution, etc).
• Item maintenance: Create, discontinue, update existing items and created price changes
• Heavy vendor interaction
• Involved closely in item line reviews
• Coordinated the semi-annual True Value Market shows-organizing vendor booth space, oversee the creating of show drop ship and warehouse order forms, ensure that new items are showcased, answer Member store product and availability questions
• Negotiating special dating and costs for the Markets
• Created vendor credit and debit memos when necessary
• Daily usage of Microsoft Access/Excel/Word in my job duties
Dec. 2002- WALGREENS CORPORATE OFFICES- Deerfield, IL
Jan 2006 Administrative Assistant- Purchasing Health & Wellness Oct. 2003-Jan. 2006
• Communicated with vendors on a day-to-day basis
• Customer service: assisted customers with product inquiries and concerns
• Assisted stores and distribution centers with problems and concerns
• Assist Diabetes State Manager with Diabetes Continuing Ed. Programs
• Thorough use of ADR7(Purchasing System) to write deals, enter and update item and vendor information
• Item Maintenance: Set up new items, discontinued items, coordinate returns for stores/DC’s, maintained item costs/retails
• Answered phones for my category managers.
• Work closely with merchandisers building planograms for stores
Quality Assurance Technician- Deerfield- IL Dec. 2002 – Oct. 2003
• Analyzed and tested new releases of Intercom Plus (Pharmacy Software) for errors prior to store rollout.
• Tested other issues such as Livelink and live insurance lines for the new NCPDP 5.1 Version.
• Created test plans, using Microsoft Office, for each new enhancement or fix.
• Visited Pilot Stores within the area to test IC+ hands-on
• Used Structured Query Language (SQL) and UNIX in order to test IC+ systems efficiently.
Query language is used to manipulate data through the database.
• Troubleshoot errors with computer programmers when analyzing an identified problem within IC+.
Marketing Internship June 2001 to August 2001
Illinois State Redbirds, Normal, IL
• Marketing Assistant to Director of marketing for the Redbird Sports.
• Handled several business accounts that advertised with the Mens’ Basketball/Football programs.
• Responsible for proofing/placing account ads in the Men’s Sports souvenir programs.
• Started or renewed advertising contracts with businesses.
EDUCATION: Bachelor of Business Administration in Marketing, August 2002
Illinois State University Normal, Illinois
OTHER SKILLS:
• Experienced with Microsoft Excel, Microsoft Office and Microsoft Frontpage
• Completed a UNIX class online (www.mindleaders.com).
• Type 85+ WPM