Experienced VBA Developer with expertise in automating Excel processes and performing advanced data analysis. Proficient in creating complex macros, integrating Power Pivot and DAX, and developing tools for inventory management, including stock replenishment and excess inventory analysis. Key Skills: 🔢 VBA Programming: Crafting and optimizing macros for data automation, import, and manipulation. 📊 Data Analysis: Conducting detailed analyses, including Pareto (80/20) analysis and dynamic reporting. 📈 Power Pivot & DAX: Utilizing Power Pivot and DAX for sophisticated calculations and large-scale data management. 📦 Stock Replenishment: Designing and implementing tables for efficient inventory restocking and management. 🚚 Excess Inventory Analysis: Developing tools to identify and manage surplus stock, reducing carrying costs and optimizing inventory levels. 🎨 User Interface Design: Creating intuitive user forms and controls to enhance functionality and user experience.