✓ Collaborated with stakeholders to understand business problems, conduct deep-dive analysis, discover patterns, present findings, and incorporate feedback.
✓ Led the development of a Q&A bot using GenAI, Gemini, and RAG to assist branch staff finding responses to their questions from a vast job aid document repository, improving accuracy from 46% to 87%.
✓ Contributed to the extension and optimization of the Transaction Prediction model using PySpark and advanced statistical techniques, resulting in a 5% increase in recall at 5, raising it to a minimum of 85%.
✓ Built a referral model for Tangerine to Scotiabank GWM using LGBM, achieving an F1 score of 0.16, which identified 12 qualified leads, resulting in $3.7MM in closed deals and $19MM in the pipeline.

✓ Facilitated weekly meetings with business partners to discuss challenges, showcase findings, address any roadblocks, and incorporate feedback for refining model accuracy.
✓ Developed Customer-Value-Index (CVI) and Affluence Index for targeted campaigns; both indices ranked among the top 5 predictive features when integrated with other models.
✓ Built and tuned a Chequing cross-sell model with XGBoost, Scikit-learn, GCP BQ, AI Platform, and Bayesian optimization, achieving a response rate increase of up to 1.25% and driving around 2,500 new product sales.
✓ Implemented 3 end-to-end machine learning pipelines for data collection, preprocessing, feature engineering, and prediction using Python, Docker, and GCP, achieving a time savings of approximately 30% per run.
✓ Created a customer segmentation model using KMeans clustering and Factor Analysis to group customers by journey, enhancing customer insights and supporting a client-first approach.

✓ Engineered an automated, large-scale data pipeline for ETL processes, integrating data from the Enterprise Data Warehouse into the GIC pricing model utilizing SAS, SQL, DB2, and crontab.
✓ Oversaw data pipelines for machine learning models, proactively resolving ETL process issues.
✓ Generated two new data features that improved customer clustering model optimization.
✓ Aggregated 7 years of GIC sales data using PySpark and conducted Exploratory Data Analysis (EDA) to extract insights into customer laddering behaviors, employing Python, Pandas, and Seaborn.

✓ Led a team of 4 software developers, guiding them through various phases of the software development cycle.
✓ Collaborated with stakeholders to gather high-level requirements, analyze them, and ensure alignment with application specifications and database architecture.
✓ Designed and implemented a scalable service-oriented architecture for more than 8 web applications, utilizing C#, ASP.NET, MVC, SQL, and LINQ.
✓ Developed database entity models and coordinated data migration and ETL processes from legacy systems to new data models using SQL Server Integration Services (SSIS).
✓ Maintained and enhanced 5+ legacy applications written in VB6, adding new functionalities and performing debugging and testing to meet business needs and ensure reliability and efficiency.
✓ Created dashboards and reports to deliver high-value insights to stakeholders using ASP.NET, C#, SQL, HighCharts, JSON, Stimulsoft Reports, and SQL Server Reporting Services (SSRS).

✓ Streamlined workflows by developing core backend functions of 4 web-based office automation applications using C#, ASP.NET, ADO, and SQL.
✓ Built comprehensive database models in Microsoft SQL Server, including tables, views, stored procedures, functions, and triggers for seamless use by other developers.
✓ Leveraged data from various sources and generated reports using SQL and Crystal Reports.
✓ Designed 5 cross-browser compatible websites using ASP.NET, HTML5, CSS, and JavaScript.
✓ Enhanced user experience across 9 websites by improving UI in collaboration with stakeholders.
✓ Trained 100+ end-users on application usage and features empowering them to maximize efficiency.