Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Languages
Timeline
Generic

ARUN PRASATH SENGUTTUVAN

Toronto,Canada

Summary

Adept at enhancing data capabilities and optimizing risk-return strategies, my tenure at Bank of Montreal showcased significant achievements, including the development of a consolidated Power BI reporting framework. With proven expertise in data visualization and a knack for insights generation, my work has consistently driven business growth and decision-making excellence.

Overview

12
12
years of professional experience
1
1
Certification

Work History

MANAGER, Business Banking Credit Risk

Bank of Montreal
12.2022 - Current
  • Responsible for enhancing the Data capabilities of the Credit Risk Strategy Analytics Team to ensure efficient reporting & to optimize the Risk-Return for the Small Business Portfolio
  • Selected as the Top Performer of the team in F23 for contributions in improvement of data quality, reporting and strategy enhancements
  • Created consolidated reporting framework in Power BI to monitor the Portfolio Performance of the Canadian & US Business Banking
  • Created Self-serve analytical tools for Strategy and Portfolio Monitoring, which is used widely across ERPM
  • Created curated datasets with standardized definitions enabling consistency in Reporting and Strategy development
  • Streamlined the reporting process bringing down the turnaround time from several weeks to few hours
  • Created Pre-Delinquency model to identify the vulnerable population; providing an early warning for account management activities
  • Collaborated with multiple stakeholders across various data teams to address the gap in the data quality
  • Created Business Banking knowledge base in Confluence, which is used both within credit risk and other stakeholders
  • Involved in the strategy pruning, implementation and validation for F24 helping in optimizing the risk return for of the portfolio
  • Owns the generation & presentation Quarterly Business Review for the portfolio to the executives
  • Works closely with the Senior executives in the generation of the visualizations & insights for the presentations to the CRO
  • Go to person for Data and Automation related queries in NA credit risk
  • Facilitated team discussions on creating F24 goals for BB Credit Risk and achieving team consensus on Employee Engagement
  • Coached Sr Analyst/Intern in data mining and insight generation

BUSINESS INSIGHTS ANALYST

DYNATA INC
11.2019 - 12.2022
  • Responsible for aiding the international operations and panel team with actionable insights through ad-hoc reports and customizable dashboards
  • Created Workload Models to analyze the Project Manager utilization
  • Created Revenue Forecast Model to aid the sales team leads track the performance of the salesforce and set optimal business target
  • Led a cross functional team to standardize KPIs and create semantic layer
  • Created reports to monitor the survey user effectiveness & utilization
  • Analytics POC for user journey & email campaign management using AWS pinpoint
  • Created a consolidated report for the C-level executives to serve as one stop dashboard for day-to-day reporting

PRINCIPAL DATA ANALYST

SAVANT TECHNOLOGY
02.2017 - 08.2019
  • Company Overview: Under Contract To
  • Responsible as the subject matter expert to support a big data project lifecycle and provide analytics solutions that create business values and actionable insights for business teams
  • Functioned as the lead point of contact to understand, analyze, and gather the requirements of the land transport operations center for the designing of the Emergency response system
  • Worked on commuter analytics services to generate actionable insights on the commuter crowd at each public transport node
  • Hands on work in Python & R for the Data Mining & generation of various KPIs using rules-based engines and Machine Learning Models
  • Hand on work in Tableau for creation and automation of dashboards to showcase the KPIs generated
  • Demonstrated understanding of the AWS cloud services for the implementation of the analytics solutions in the Hadoop big data platform
  • Designed and develop quality assurance checklists and validation work plans to assess the performance & ensure smooth functioning of the monitoring system
  • Conducted regular review of the KPIs generated by the system to improve the reliability of the insights provided
  • Developed a monitoring & reporting framework to ensure all the key components of the system is fully functional
  • Under Contract To

SENIOR DATA ANALYST

MU SIGMA BUSINESS SOLUTIONS PVT LTD
01.2014 - 12.2015
  • Lead Data Analyst to team of analysts working for world's largest home improvement retailer, enabling them to make data driven decisions
  • Designed & implemented automated frameworks in tableau to monitor the traffic and other KPIs of various website - site sections of the financial services organization and presented the dashboard to the clients
  • Led an analytics team working for a Financial Service Organization, providing support in their digital market space and led the engagement from the offshore
  • Worked in the website analytics for the financial Services Organization - performed A/B Testing to improve the performance of the site sections
  • Worked on Sentiment Analysis using R to understand the voice of the website users based on their reviews in blogs, twitter and mails
  • Organized regular meetings with end-users to discuss system requirements, specifications, costs and timelines
  • Trained the newly hired employees in SAS & Tableau and conducted their performance review as MSU's teaching assistant

DATA ANALYST

MU SIGMA BUSINESS SOLUTIONS PVT LTD
09.2012 - 12.2013
  • Part of a 20-member team that worked for world's largest home improvement company, enabling them to make data driven decisions
  • Collaborated with the Financial Planning and Analysis team of a US based home improvement retailer to provide analytical support and aid them in their business decisions
  • Formulated comprehensive methodology to drill down into the Company's Profit% in terms at category/subcategory level for the C level executives of the Organization and presented the results to the stakeholders in a call
  • Worked on the Market Basket Analysis to identify the association pattern in the selling of products
  • Designed a dashboard to help the business user understand the impact of cost & retail changes on company's profit%
  • Built a mathematical model to estimate the cost of each product based on their attributes and identify the split up of the cost in-terms of various attributes and identified a potential cost out opportunity of $5M
  • Designed an integrated & automated tableau visualization to help the clients to get a better visibility about the performance of various products, vendors, categories, and sub-categories by tracking various KPIs

Education

COMPLETED COURSEWORK TOWARDS MASTER OF IT - BUSINESS -ANALYTICS

SINGAPORE MANAGEMENT UNIVERSITY
12.2016

COMPLETED COURSEWORK TOWARDS BACHELOR OF ENGINEERING - ELECTRONICS AND COMMUNICATION

ANNA UNIVERSITY
05.2012

Skills

  • Data visualization
  • Insights generation
  • Story telling
  • Problem Solving
  • Design Thinking
  • Data Mining
  • Verbal communication
  • Written communication

Certification

  • AWS certified Cloud Practitioner
  • Tableau certified Desktop Associate
  • MangoDB basic certification from MangoDB university
  • SAS Base Programming Specialist

Personal Information

  • Age: 34
  • Gender: Male

Languages

English
Full Professional

Timeline

MANAGER, Business Banking Credit Risk

Bank of Montreal
12.2022 - Current

BUSINESS INSIGHTS ANALYST

DYNATA INC
11.2019 - 12.2022

PRINCIPAL DATA ANALYST

SAVANT TECHNOLOGY
02.2017 - 08.2019

SENIOR DATA ANALYST

MU SIGMA BUSINESS SOLUTIONS PVT LTD
01.2014 - 12.2015

DATA ANALYST

MU SIGMA BUSINESS SOLUTIONS PVT LTD
09.2012 - 12.2013

COMPLETED COURSEWORK TOWARDS BACHELOR OF ENGINEERING - ELECTRONICS AND COMMUNICATION

ANNA UNIVERSITY

COMPLETED COURSEWORK TOWARDS MASTER OF IT - BUSINESS -ANALYTICS

SINGAPORE MANAGEMENT UNIVERSITY
ARUN PRASATH SENGUTTUVAN