Pradeep Mendem

Key Achievements & Responsibilities: • Sales & Performance Analytics: Analyzed sales trends and performance using LinnWorks, SQL, and Power BI, leading to a 25% revenue increase by identifying underperforming product categories and implementing targeted strategies. • Inventory Forecasting & Optimization: Implemented data-driven inventory management strategies, reducing excess inventory by 10% and minimizing stockouts by 5%, resulting in an overall cost saving of £8,000. • Database Management: Designed and optimized SQL queries to extract, transform, and analyze large datasets, enhancing data accessibility for business teams. • BI Dashboard Development: Created dynamic Power BI dashboards for real-time tracking of inventory levels, sales, and customer demand patterns, improving decision-making. • Data Integrity & Governance: Maintained 99.9% data accuracy by implementing strict data validation checks in inventory records, reducing errors and improving reporting reliability. • Stakeholder Communication: Provided weekly data-driven insights to senior management, aiding in strategic planning and budgeting decisions. • A/B Testing & Trend Analysis: Conducted A/B tests on pricing strategies and marketing campaigns, leading to a 12% increase in conversion rates. • Competitor & Market Analysis: Utilized Python and Web Scraping techniques to track competitor pricing and trends, enhancing strategic positioning in the fashion industry.