▪Published and Produced Signage:Responsible for overseeing the publishing and production of signage for our valued clients.▪Data Analysis: Applied SQL and Tableau to perform advanced data analysis, extraction, and visualization, presenting insights from weekly Instore signage advertising data to key stakeholders▪Collaboration with Cross-Functional Teams:Collaborated closely with Client Services, Lowes Marketing, and Pricing/Merchandising teams to analyze, manipulate, upload, and export weekly Instore signage advertising data. This included managing promotion prices, dates, and content, integrated seamlessly into Quad’s client-facing software.▪Building Client Trust:Established a high level of trust with clients through prompt response to requests and effective incident resolution.▪Process Automation and Workflow Enhancement:Contributed significantly to the automation of various processes, resulting in a more efficient and accurate workflow. Proactively identified opportunities to enhance duties by updating Standard Operating Procedures (SOPs) for a smoother team workflow.▪Issue Recording and Reporting:Recorded and reported software issues to the IT team for research and improvement. Ensured issues were promptly addressed to enhance the functionality of Quad’s client-facing software.▪Subject Matter Expertise:Served as an expert on the software, taking the lead in addressing any client inquiries and providing comprehensive support.

▪Merchandising Optimization:Ensured optimal merchandise placement on shelves by collaborating cross-functionally with the visual space team and product merchants.▪Strategic Store and Product Reorganization:Led the evaluation of existing steel and determined future needs for large-scale store and product reorganization (50+ item categories). Managed the complex process, including ordering necessary parts to successfully complete projects.▪Data Analysis and Planogram Development:Extracted data from an Oracle database using SQL and conducted in-depth analysis in large Excel worksheets. Utilized insights to contribute to the creation of planograms for item/section reconfiguration, aimed at driving increased sales.▪Project Analysis and Action Plan Enhancement:Analyzed project plans and action plans using conditional formatting and macros to identify data discrepancies. Employed Excel tools such as Pivot Tables, Power Queries, Index/Match, Vlookup, Conditional Formatting, and complex formulas to analyze current vs. future state needs, ensuring efficient project completion.

▪Data Management and Analysis Specialist:Leveraged advanced Excel skills to streamline inventory processes and enhance data accuracy for a diverse range of products.▪Inventory Lifecycle Management:Assigned to Product Lifecycle Management, efficiently updated lifecycle codes for 10,000 inventory items using Vlookup, sort, and filter functions in Excel.▪Data Extraction and Analysis:Extracted over 1,000,000 rows of inventory data from Oracle Discoverer, performing in-depth data analysis and generating insightful reports.▪Automation and Process Efficiency:Built Macros to significantly reduce processing time (less than 20 seconds) for creating new items and updating attributes, enhancing overall efficiency.▪Cross-Functional Collaboration and Issue Resolution:Collaborated with IT Support, Finance, and Distribution to resolve system and inventory errors. Created error log spreadsheets and ensured timely resolution.▪Spreadsheet Design and Project Planning:Designed spreadsheets using Index/Match and Conditional Formatting to track updates on high-importance procedures. Proactively planned and prioritized data/project requests, organizing 5+ reports/files daily while meeting deadlines.▪Global Database Updates:Performed ad hoc uploads using Filezilla to update the global database, ensuring accurate and up-to-date information.

▪Retail Analytics Specialist:Leveraged data analysis to optimize product mix for limited retail space, driving up to $1M in monthly sales.▪Pricing Strategy and Profitability:Generated pricing reports and meticulously analyzed data to ensure precise profit margins. Implemented pricing updates, discounts, and sales strategies to maximize profitability.▪Strategic Purchasing and Budget Management:Strategically created purchase orders, considering factors such as sales volume, limited shelf space, and budget constraints, to maximize profit.▪Data Cleaning and Inventory Management:Cleaned data for end-customers and reports, enhancing accuracy in analyzing item inventory and sales. Maintained accurate inventory for 50,000 items through accurate record-keeping and physical counts.▪Supplier Relations and Issue Resolution:Collaborated with 50 suppliers, resolving order discrepancies, and requesting credits for mispicks and damaged products.▪Project Management and Collaboration:Excelled at managing up to 5 unique projects simultaneously, prioritizing tasks effectively. Worked closely with 15 co-workers across the store on various projects and daily assignments, collaborating with key members of different store departments to achieve shared company goals.