Summary
Overview
Work History
Education
Skills
Additional Information
Key Strengths
Websites
Community Involvement
Work Availability
Quote
Timeline
Generic
DIVYA GAUTAM

DIVYA GAUTAM

Summary

Qualified and Highly experienced Business Intelligence/Data Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.

Overview

13
13
years of professional experience

Work History

Sr. Data Analyst

TD Bank
Toronto, ON
01.2023 - Current
  • Performed statistical analysis on Performance data to identify patterns and correlations.
  • Developed complex SQL queries to analyze large datasets for trends and insights into Retail Goal Building.
  • Created data visualizations in Tableau to present findings to stakeholders.
  • Designed, developed and implemented ETL processes for data integration from multiple sources like Product, Finance and Performance data systems.
  • Established KPI metrics and monitored performance of data analysis projects.
  • Utilized machine learning algorithms to predict customer behavior based on past interactions.
  • Provided data-driven recommendations for marketing campaigns and product development initiatives.
  • Analyzed web traffic using Google Analytics tools to inform optimization strategies.
  • Implemented predictive models to forecast sales trends for inventory management purposes.
  • Automated daily reporting processes with Python scripting techniques.
  • Lead the design, implementation, maintenance, and support of enterprise data systems architecture solutions.
  • Collaborated with cross-functional teams across departments such as Sales, Marketing, Product, Finance.
  • Developed dashboards in PowerBI to provide real-time business intelligence insights.
  • Maintained accuracy of datasets by performing regular quality assurance checks.
  • Investigated root causes of anomalies in datasets using exploratory data analysis.

Operations Analyst

TD bank
10.2018 - 01.2023
  • Acted as a subject matter expert on the Branch Scorecard and leveraged branch dispute submission data to recognize emerging trends, identify opportunities for enhancements, and make recommendations for optimization of current processes.
  • Supported in the identification and delivery of process improvements & engage business partners as required to build technological solutions.
  • Cleaned up manual files, optimized and created new Mainframe SAS programs and/or other findings on our systems. Continually looked for opportunities to streamline and improve the adjustment and audit processes.
  • Prepared dashboards for Senior management which helped in Dispute SLA analysis.This involved working on complex Dispute pull through SQL, used Power BI and Excel.
  • Provided project management support for the development of new products, services, or processes.
  • Conducted research on industry trends and best practices to inform decision-making.

Financial Advisor

Bank of Nova Scotia
12.2017 - 10.2018
  • Developed financial plans and strategies tailored to clients' individual needs.
  • Conducted detailed analysis of clients' current financial situation, including risk assessment, cash flow management, and retirement planning.
  • Analyzed potential investments such as stocks, bonds, mutual funds, real estate and insurance products for clients.
  • Provided advice on tax-advantaged investment opportunities.
  • Monitored client portfolios to ensure that recommended investments remain in line with their goals and objectives.
  • Assisted in the preparation of presentations for prospective clients outlining services offered by the firm.
  • Reviewed existing client accounts to identify any gaps or areas needing improvement.
  • Researched economic trends and market conditions to provide up-to-date information on investment options available to clients.
  • Prepared quarterly performance reports for existing clients detailing the progress of their investments over time.
  • Maintained accurate records of all client interactions and transactions in accordance with company policy and regulatory requirements.

Priority Banking Relationship Manager

Standard Chartered Bank
11.2014 - 09.2017
  • Wealth and Assets Management
  • Efficiently handled a portfolio of CAD 16 Million worth wealth book size and generated more than the target revenue from portfolios month on month.
  • Closed 1.8 Million CAD wealth business within first 60 days in the role via referrals and networking
  • Ensured full awareness of all policies and procedures issued in relation to money laundering prevention and KYC.

Relationship Manager

HDFC Bank
Pune, India
04.2011 - 11.2014
  • Accountable for acquisition of new preferred customers and managing existing portfolios of individual/business accounts.
  • Involved in enhancement of the relationship by cross-selling products and services as per the profile and need of the customers.
  • · Anticipated and forecasted business specifications against financials and performed ratio analysis.

Education

MBA - Marketing & IT

Balaji Institute of Modern Management
01.2011

B Sc. Honors - Chemistry

Punjab University
01.2008

Skills

  • Macros - VBA
  • Data Management
  • Statistical Analysis
  • Reporting Skills
  • Analytical Software (SAS)
  • SQL
  • MS Excel and Power point
  • Gap Analysis
  • Variance Analysis
  • Operational Modelling
  • Data Modeling
  • Strategic Planning
  • Business Analysis
  • Project Management
  • Geographic Trend Tracking
  • Data Mapping
  • Process Improvement
  • Data and Analytics

Additional Information

  • Above and Beyond - Q4 2022, Q2 2022, Q4 2021, Q4 2020
  • Great work - Q4 2022, Q2 2021
  • Quarterly Spotlight Award – Q3 2020 (Awarded for overall exceptional performance and development of colleagues new to role)

Key Strengths

· Ability to analyse / interpret complex data and present logical interpretation using tools like SQL, Tableau, MS Excel and Power Query.

· Proficient in managing requirements with agile tools such as Jira and Confluence.

· Expert in creating Use Cases, Sequence Diagrams, Activity Diagrams, State Diagrams, Class Diagrams, communication Diagrams and Business Intelligence Tools.

· Proficient in business modeling using UML standards and tools like Rational Rose, MS Visio.

· Excellent communication skills and ability to interact with stakeholders and senior management.

· Proven skills in being able to meet deadlines under pressure.

Strongly adhere to processes and controls in place and pro-actively react when forese

Community Involvement

  • United Way Ambassador @TD Bank (Oct 2018 to Present) - Organize and communicate campaigns, Fund Raising and Corporate Events.
  • Social Committee member @TD Bank (December 2020 to present) - Organize team building activities as well as office parties. Made sure all the events are inclusive and represent all communities/minorities.
  • Niagara Animal Rescue and Shelter (January 2022 to present) - Volunteered for fostering and other rescue related activities.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Timeline

Sr. Data Analyst

TD Bank
01.2023 - Current

Operations Analyst

TD bank
10.2018 - 01.2023

Financial Advisor

Bank of Nova Scotia
12.2017 - 10.2018

Priority Banking Relationship Manager

Standard Chartered Bank
11.2014 - 09.2017

Relationship Manager

HDFC Bank
04.2011 - 11.2014

MBA - Marketing & IT

Balaji Institute of Modern Management

B Sc. Honors - Chemistry

Punjab University

Similar Profiles

CREATE PROFILE
DIVYA GAUTAM