SALIL KULKARNI
Oakville,ON
Summary
Enthusiastic team player with a decade of experience identifying actionable insights through data analysis and critical reasoning. A skilled collaborator with a knack for telling stories using data and facts.
Overview
13
13
years of professional experience
Work History
Senior Analyst - Digital Analytics
TD Bank Group
07.2022 - 10.2023
- Concierge for TD Insurance Direct Life teams for all analytics and insights requests to ED&A team.
- Managed relationship with business partners to understand their pain points and provided actionable recommendations.
- Used Strong understanding of web analytics, user behavior, and digital marketing to create deep dive analysis of TD insurance's buying and shopping journeys
- Completed Deep Dives using Adobe analytics data; identified and implemented improvement that lead to 0.5 million is additional value for business.
- Assisted new funnel/ digital experience launches by creating adobe dashboards for visualizations and A/B testing
- Skilled in providing strategic recommendations for customer experience improvements
- Accomplished Digital Analyst proficient in Adobe Analytics, SQL, and reporting.
Analytics Consultant
Alight Solutions
08.2021 - 07.2022
- Reviewed client's current analytics framework and provided recommendations for realignment to stake holder-focused KPIs and technical best practices.
- Managed and coordinated 5-6 client projects simultaneously to deliver ETL, reporting and dashboarding solutions tailored to their needs.
- Designed and created complex ETL flows based on business and technical requirements documentation using MS SQL SERVER tools such as SSIS and SSAS for analytics implementation.
- Developed complex SQL queries to build highly automated and complex dashboards for assisting senior leadership in decision making
Manager, Digital Strategy Collections
Scotiabank
12.2020 - 08.2021
- Built business cases by blending customer behavioral and financial data to to identify customers that may be facing financial hardships in near future
- Achieved additional > CAD 2MM in write-off avoidance by through identification of ideal target population for existing CATs (Customer Assistance Tools)
- Released collections advisor capacity by launching four new self-serve/pre-approved CATs for high- risk clients
- Improved delinquency forecasting by 70% for small business customers by better identifying and aligning insolvency triggers with delinquency outcomes
- Streamlined digital flows to improve client engagement resulting in 40% higher take-up rate (Conversion Rate)
- Tools Used : SAS, SQL, UNIX, PowerBI, SSIS
Senior Audit Analyst
Extendicare Inc
11.2018 - 12.2020
- Demonstrated CAD 15MM annual savings through data mapping and process mapping for end to end
- GL for all revenue assurance transactions as well as payroll transactions as part of new ERP project
- Generated additional CAD 9MM in federal government grant by assisting Finance and payroll in time sensitive implementation of accounting and finance processes for pandemic related expenses under tight deadlines
- Freed up additional capacity in multiple departments systems process redesign (ETL) in advisory role resulting in elimination of redundant controls and manual interventions
- Saved $900K annually by overhauling all audit programs to change their approach from sample-based review to data driven full population reviews using tools such as ACL, VBA, SAS and SQL Server
- Created and implemented IT disaster recovery program to address business continuity and recovery issues raised by external auditors.
Analytics Consultant
BMO Financial Group
06.2017 - 10.2018
- Identified contentious sales transactions performed by front-line employees through behavior policing report/dashboard developed using Power BI to assist managers
- Partnered with various departments within organization for all enhancements and new reports requests taking them from business requirements, user stories to implementation in production environment
- Resolved multiple audit findings by implementing ODBC data cube approach information sharing with various product teams
- Mentored team of analyst interns to support all product campaigns sales reporting for BMO's branch channel.
- Oversaw data visualization projects for scorecard teams, delivering comprehensible and invaluable visuals for presentation to audiences of different technical understanding
Various Developer Roles
TD Bank Group
01.2011 - 06.2017
- Developed and maintained sales reporting infrastructure for TD Canada trust's branch network using SAS, SQL, SQL Reporting services, Access, VBA and Excel tools.
- Conceptualized, developed and maintained digital fluency dashboard for senior leadership and branch managers' to assist with understanding and driving growth of digital self-serve transactions.
- Designed and developed Individual Customer experience index (CEI) Calculator using Tableau for front-line to assist them in front-line employees helping them understand various drivers that have impact on CEI.
- Developed sales management pipeline tool (CRM) using SSIS and SSRS with real-time data reporting capabilities for 100+ FTE business development team resulting in $100K cost savings for business.
- Designed, developed, and implemented software applications for website based on analyzed requirements and understanding of industry technical standards
Education
MBA - Management Accounting
Carleton University
Ottawa2009
BBA - International Business
Carleton University
Ottawa, ON2007
Skills
- MS SQL SERVER, SSIS, SSAS
- Tableau, Power BI
- SAS, SAS Enterprise Guide
- Google Data Studio
- Business Intelligence (BI)
- Campaign Analytics
- Competitive Market Analysis
- Web Analytics
- Data Manipulation
- Communication Skills
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
If statistics are boring, you've got the wrong numbers
Edward Tufte, Statistician
Timeline
Senior Analyst - Digital Analytics
TD Bank Group
07.2022 - 10.2023
Analytics Consultant
Alight Solutions
08.2021 - 07.2022
Manager, Digital Strategy Collections
Scotiabank
12.2020 - 08.2021
Senior Audit Analyst
Extendicare Inc
11.2018 - 12.2020
Analytics Consultant
BMO Financial Group
06.2017 - 10.2018
Various Developer Roles
TD Bank Group
01.2011 - 06.2017
MBA - Management Accounting
Carleton University
BBA - International Business
Carleton University