Cheryl E. Email & Phone Number

New York, New York, United States

Greater New York City Area

Assistant Retail Analyst-Temporary 2015-2015• Developed many ad hoc reports and produced the Markdown Report Summary Report, Weekly Returns, New Title Buys, Weekly Marketing Coupons, and Bestselling Report for the Finance, Merchandise Planning, and Allocation Team in order to analyze the data to improve merchandise profitability.• Created various report packs in Barnes and Noble’s Open to Buys System to view specific financial details for the Planning Team.• Recognized by the Senior Director of Merchandise Planning for converting PDF Files into Excel File Format to extract data in an efficient manner.• Contributed to the Allocation and Planning Team through assistance with miscellaneous projects, such as organizing information, preparing materials for Open to Buy Meetings, and scribed for the Allocation Special Events Meetings.• Proofread the Inter Department Microsoft Office Files to ensure that the proper Digital Asset Management Folder Hierarchy procedures were followed.

•Pull the Not in Location Report for the Inventory Analyst to review financial overages and shortages at our seven distribution centers.• Prepare the Destroy in Field Report to see how many beauty items has been destroyed at our distributions centers periodically.• Generate the Gift with Purchases On Hand Report quarterly for the buyers to review non retail merchandise which should b repurposed, donated or destroyed.• Produce the Home Markdown Report seasonally to view the Home’s departments damaged items and customer returns to our various warehouses.• Review the Merchandise Activity Journal to view any large Debit Memo or Credit Memo variances periodically.• Create the Image Charge Back Report on a monthly basis to charge the vendor for incorrect images entered into our Stella System.• Prepare the Universal Product Code Expense Offset Report monthly for all of the UPC’s added into Macy’s Catalog.• Update the Markdown Allowance and Cost Rebate Reversal information periodically to see why there were so many reversals during the period.

Fashion Accessories and Outerwear Planner• Worked in partnership the GMM and Buyer in plan development, revision and execution.• Attended weekly OTB meeting with GMM and manager, merchants and planners.• Communicated with stores as needed to understand inventory concerns.• Prepared Store Analysis Report for the Buyer’s cross country store visits. • Revised in season location plans as part of weekly OTB meetings.• Allocated accessories and outerwear merchandise to stores at the style color/level.• Executed assortment by style to fill unit need taking into account:o Seaonality of producto Brand/Designero Price Pointo Event Requirementso Classification and color assortment objectives

• Provided superior service to ensure customer satisfaction.• Increase departmental sales by completing financial transactions.• Displayed new merchandise in case line and Top of counter to maximize the current sales trend. • Replenished merchandise consistently to increase sales turn.• Inventoried jewelry merchandise seasonally to ensure merchandise accuracy.

Assistant Merchandise PlannerForecasted seasonal sales trends for the Gold Jewelry Department based on the categories, class, and stock keeping unit statistical information.• Estimated our quarterly sales projections based on the seasonal sales trends and corporate advertisements.• Developed semi annual category plans using the Arthur Planning System.• Partnered with the buyer, the vendor, and the field merchants, with the direction of the planner, to determine which merchandise should be expanded or marked down.• Identified and recommended opportunities for new top merchandise sellers utilizing various sales reports which illustrated key selling items.• Recommended transferring slow turning merchandise to other store locations which improved sales dramatically.• Analyzed allocation strategies with the Planner to update and create new location traits/allocation mask profiles based on current sales trends• Created and maintained the semi-automatic replenishment system levels to ensure adequate inventory levels are maintained.• Maximized each of the company’s category sales by writing, allocating, and tracking merchandise orders for over 615 stores. • Increased Gold Chain sales 3.5 % and Gold Earring sales 7.9% over Sales Plan of $9,948,000 and $5,817,000 respectively. • Trained new Assistant Planners to ensure accurate knowledge of our RETEK system.