Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

Girish Dhavan

Pune

Summary

Driven Data Analyst with a strong foundation in the financial services industry. Proficient in SQL, Power BI, Python, and Excel showcasing advanced analytical and problem-solving capabilities.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

Reval Analytics Ltd (Royal Bank Of Canada)
Pune
09.2022 - Current
  • Mastered complex SQL queries for efficient data extraction and analysis, ensuring access to accurate and relevant data for strategic decision-making.
  • Utilized Python for sophisticated data manipulation, analysis, and visualization, streamlining data preparation process and uncovering valuable insights.
  • Applied intermediate machine learning techniques to refine analytical models, enhancing predictive accuracy and effectiveness of customer behavior analyses.
  • Excelled in creating interactive dashboards and reports using Tableau/Power BI, effectively illustrating customer behavior trends and insights to stakeholders.
  • Specialized in exploratory data analysis to identify key churn factors, enabling development of targeted strategies for churn prevention and customer retention enhancement.
  • Demonstrated agility in working closely with clients on daily basis, adapting processes and documentation swiftly to meet evolving requirements and goals.

Data Analyst

Decimal Point Analytics Ltd (Quotemedia Client)
Mumbai
09.2020 - 09.2022
  • To Conduct comprehensive data cleaning on raw US mutual fund data and Identified and deleted unnecessary data to streamline datasets for further analysis
  • Implemented data storage procedures to ensure accuracy and integrity of information
  • Monitored and processed corporate actions related to specific funds and update to MySQL database based on changes resulting from corporate actions
  • Leveraged SQL queries to extract, manipulate, and analyze data from database
  • Worked closely with clients to understand their reporting requirements and translated them into effective SQL queries.

Education

Masters of Business Administration - Finance

MET Institue Of Management
Mumbai
01.2021

Bachelor of Science - Physics

Fergusson College
Pune, India
01.2019

Skills

  • SQL (MYSQL, Postgre)
  • Power BI (DAX, Power Query)
  • Python (Pandas, Numpy, Seaborn, Matplotlib)
  • MS Excel (Vlookup, Hlookup, Conditional Formating, Data Validation, etc)
  • Powerpoint

Languages

English
Hindi
Marathi

Certification

  • Masters in Data Science
  • SQL For Data Analytics
  • Certified Power BI analyst
  • Excel for Financial Analysis

Timeline

Data Analyst

Reval Analytics Ltd (Royal Bank Of Canada)
09.2022 - Current

Data Analyst

Decimal Point Analytics Ltd (Quotemedia Client)
09.2020 - 09.2022

Masters of Business Administration - Finance

MET Institue Of Management

Bachelor of Science - Physics

Fergusson College
Girish Dhavan