• Standardize and integrate diverse monthly sales reports using Python,transforming disparate file formats into a cohesive dataset optimized for analysis. Apply advanced data wrangling techniques to streamline revenue, cost, and profit calculations, followed by in-depth trend analysis and statistical outlier detection to extract actionable insights for high-level strategic decision-making. • Manage and maintain critical datasets for customers and products, including data cleaning, updates, and integration of key information such as pricing and rebates.• Generate and automate monthly sales reports by sales representative, utilizing Python for advanced calculations tailored to individual reps, customers, and provincial data.• Collaborate cross-departmentally to develop inventory reports, employing Python to streamline data processing and enhance reporting accuracy.• Support the sales analysis dashboard in PowerBI by maintaining and updating data visualizations and underlying datasets.• Design and maintain data pipelines to import customer data from external sources into company databases, improving data accessibility and accuracy for business operations.

• Developed a sophisticated prediction model employing Deep Learning techniques to accurately forecast energy consumption for each store nationwide, enabling data-driven decision-making and operational efficiency. • Collected and manipulated data from internal databases using SQL and external sources via Python, ensuring accuracy and readiness for analysis. Collaborated with various departments to support data alignment.• Developed and maintained a PowerBI dashboard to visualize model predictions and compare them against other forecasting models, providing stakeholders with clear, actionable insights.• Partnered with team members to analyze renovation costs and developedpredictive models for future expenses, incorporating data on store inventory, depreciation, and other cost drivers.• Deployed the Deep Learning model to production in collaboration with the Data Engineering team and ensured its ongoing functionality and improvement for sustained usability.