At Scotiabank, I streamlined data remediation processes by integrating data from SQL Server, Salesforce, and SharePoint to enhance referral tracking. I developed dynamic Power BI dashboards featuring multi-level row-level security, providing stakeholders with real-time KPI monitoring. I automated financial reporting using Python and Excel macros, reducing processing time by 70%. I also migrated legacy MS Access workflows to Alteryx, improving scalability.

I led a team in analyzing over ten years of aviation parts data to uncover trends in maintenance cycles and part replacements. Using Python, I performed extensive data preprocessing and comparative analysis to prepare the dataset for insights. I developed interactive Tableau dashboards to support data-driven, cost-effective maintenance planning. Additionally, I engineered features and benchmarked machine learning models to improve predictive accuracy, contributing to a 10% reduction in operational losses.

Led a team of four and developed an AI-powered chatbot using Langchain and advanced LLMs (GPT-4, GPT-3.5, LLaMA) to handle internal employee queries. The chatbot was optimized through prompt engineering and benchmarking to ensure accurate, context-aware responses. I mined and preprocessed internal documents using Python to build the knowledge base, and created a user-friendly React.js frontend integrated with a FastAPI backend. This solution improved chatbot performance by over 10% and reduced employee inquiry response time by 40%.

At The Social Media Agency, I automated the aggregation of over 10K daily social media engagement metrics across Instagram, Facebook, and LinkedIn using Python, cutting manual reporting time by half and accelerating the delivery of client insights. I also analyzed monthly ad spend data with SQL and Power BI to identify underperforming campaigns and recommended targeted optimizations that increased client ROI by 18% quarter-over-quarter.