Microsoft Excel spreadsheet development and solutions for small business. Create a new spreadsheet, improve a spreadsheet, or fix a spreadsheet, as well as training. I can create spreadsheets to help manage your inventory, track sales, forecast sales, or manage your raw material. Increase your efficiency and impress your boss by discovering the best analytical tools that took me years to track down/create. - Dash boards- Gantt charts/interactive charts- Data mining- Advanced functions.

★ Prepares, collects, and analyzes data to evaluate current sales goals.★ Developed new sales reporting package tracking KPIs for leadership and the sales team.

★ First year and half reduced pant inventory by 47% or $13.5M, while sales grew +20% or $20M by improving product and purchasing management.★ Developed new materials management process, reducing raw material inventory by 39% while continuing to meet material requirements.★ Served as a senior buyer and inventory planner.★ Directed capacity planning, import logistics and production schedules with global and domestic manufacturers.★ Ensured optimized inventory levels to drive $57 million in annual sales.★ Delivered outstanding product knowledge of professional and uniform apparel, ensuring availability.★ Maintained tariff codes expertise and confirmed assignments for each product.★ Negotiated with individual plants on capacity, adjusted production schedules and procured all raw materials while managing the bills of materials for each garment.★ Developed and executed effective strategies to increase consumer interest in targeted product categories.★ Analyzed product performance and recommended changes to improve profitability.★ Researched historical efforts and industry projections to develop financial projections.★ Ensured product availability by maintaining inventory of all raw materials.★ Fostered positive public/vendor relations.★ Managed exceptions, driving special orders of custom products, delayed or incomplete delivery of orders, preparing inventory control and vendor performance reports.★ Trained future leaders throughout various department tools/systems.★ Implemented and utilized ERP, MRP, forecasting and inventory control technology tools/systems.★ Added new product SKUs and determined initial inventory targets.★ Phased out SKUs and managed decreasing inventory levels, coordinating with sales staff to define phase-out milestones.

★ Achieved positive category sales growth during the great recession.★ Managed retail operations for a book, greeting card, and gift store.★ Served as a merchandising manager to direct Destiny Image and Dayspring Greeting - a division of Hallmark, throughout 300+ stores.★ Established tracking ability to individual cards to manage an $18MM portfolio of 3K+ SKUs.★ Managed a mix of categories, including greeting cards, books, journals, mugs, stationery, gift wrap, ornaments and other products across retail, catalog and website sales channels.★ Launched and managed a base and cover inventory, adjusting levels and parameters to capture an edge based on analytics, trends and customer feedback.★ Collaborated with buyers to assess seasonal projects.★ Developed budgets and merchandise targets.★ Identified opportunities for space optimization and aesthetically managed product displays.★ Maintained product replenishment.★ Served as the key liaison among buyers, suppliers, distribution centers and retail locations.★ Worked with buyers and vendors to achieve sales and gross margins.★ Played a key role in successful assort planning strategies, developing planograms and floor layouts.★ Reviewed and negotiated seasonal return credits of $1MM+ annually.★ Business to business sales responsibilities for DaySpring gifts and greeting cards

★ Participated in the initial development phase of the largest business intelligence and data warehousing project in history for The Centers for Medicare and Medicaid Services (CMS), which would enable the government to better manage healthcare costs and reduce fraud.★ Worked closely with the client manager and account team to identify and understand clients' healthcare information needs. ★ Assured that data management projects were delivered on time, fit for use and within budget. ★ Developed, maintained and documented product design and data enhancement specifications, and presented these to the client. ★ Designed, maintained, executed and documented dataset tests and supported user acceptance testing. ★ Instructed clients on data quality, documentation, and software applications. ★ Recognized and managed out-of-scope activities so appropriate actions could be taken to reset client expectations or obtain additional revenue to support the work being done.★ Managed projects to meet an on-time delivery. ★ Assisted with estimating level of effort for proposed projects. ★ Led data install meetings. ★ Participated in client internal as well as external meetings. ★ Identified the root cause of data quality issues and completed complex data investigations.

★ First year discovered return credit discrepancy that had been on going over a period of 7 years resulting in a positive $574,000 credit collection.★ Directed merchandising and operational aspects of a $200M periodicals category.★ Managed periodicals return credit processing for nearly 1,700 Borders and Waldenbooks Stores.★ Discovered ongoing accounting discrepancy resulting in recovery of $565K in past due credits.★ Built basic and core inventory models, and adjusted core levels and parameters based upon analysis, trends, and feedback.★ Reduced corporate newspaper markdown liability with the transition to consignment.★ Eliminated 7 year back log of refused return claims.★ Partnered with the category team to execute reorders and arrival of replenishment titles from the vendors to the stores and ensure effective management of the allocation strategies.★ Partnered with the receipt of goods team to ensure accurate measurement of each Vendor’s withholding rate.★ Led a special projects team with the international department to transfer return processing to new facilities in the UK and Australia.★ Acted as chief liaison for communication between merchandising, marketing, accounts payable, and inventory control.★ Processed regular replenishment of products, including management of parameters such as lead times, profiles, core and promotional display mins.★ Acted as liaison for communication between the buyers, suppliers, distribution centers, and stores.★ Engaged in stock analysis, monitoring sales against allocation.★ Performed research and analysis to select vendors and appropriate product mix for over 800+ Waldenbooks stores.★ Enhanced industry-wide relationships via vendor communications, building distributor partnerships, negotiations of quarterly refused returns claims and new service contracts.★ Partnered with buyer and category director to achieve sales and gross margin, market share, inventory, turn, and ROI targets for business.

Delivered comprehensive reporting to leadership through P&L reports and daily financial performance, and inventory reports. Handled accounts payable, fuel replenishment, and inventory adjustments for 183 corporate stores in Michigan. Loss prevention. Prepare written investigative loss prevention reports and Suspicious Activity Reports.

Replenish product for distribution. Manage route truck maintenance. Manage pickers. Manage loading of route trucks.