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)
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)
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
Mumbai01.2021
Bachelor of Science - Physics
Fergusson College
Pune, India01.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
Similar Profiles
ANIRBAN BASUANIRBAN BASU
QA Manager at TCS CANADA (Client - Royal Bank Of Canada)QA Manager at TCS CANADA (Client - Royal Bank Of Canada)
Ashok Kumar PeddinaAshok Kumar Peddina
Senior Consultant at Capgemini, Canada, Royal Bank of CanadaSenior Consultant at Capgemini, Canada, Royal Bank of Canada
PARMEET KAURPARMEET KAUR
Collections Officer at Royal Bank of Canada, RBCCollections Officer at Royal Bank of Canada, RBC