KUNDAN PATIL
Bengaluru,India
Summary
- Experienced Database Management Expert skilled in Microsoft SQL Server and PostgreSQL. Demonstrates expertise in database setup, query optimization, and data integrity management.
- Experienced in utilizing Tableau and Python to visually present and analyze data, demonstrating a strong aptitude for data extraction and interpretation.
- Proficient in Alteryx and expert-level in Microsoft Excel, with a strong track record in data preparation, analysis, complex manipulation, and reporting.
- Agile Project Manager: Utilizes Jira and Kanban methodology to enhance project efficiency and teamwork in fast-paced environments.
- Experienced in utilizing SQL and Python for data extraction, cleaning, and analysis, as well as leveraging Azure for cloud-based data solutions.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
Moody's Ratings
08.2023 - Current
- Utilized Alteryx to extract, transform, and load financial data from diverse sources, ensuring data quality and consistency.
- Developed and maintained MySQL databases to efficiently store and retrieve financial data while also optimizing query performance.
- Designed & created interactive reports and dashboards in Tableau for intuitive visualizations of financial data, aiding decision-makers.
- Leveraged Excel for financial data cleansing, advanced analysis, and modeling to provide actionable insights.
- Conducted thorough financial data analysis to identify trends, patterns and anomalies for supporting data-driven decision-making.
- Collaborated with stakeholders in the business requirement analysis process, translating their analytical needs into actionable data solutions for financial data and research.
- Generated regular and ad-hoc reports, providing key financial performance indicators (KPIs) and actionable recommendations for ongoing financial research efforts.
- Applied statistical techniques and predictive modeling to forecast future financial trends, contributing valuable insights to financial research projects.
- Implemented data quality checks and validation process for consistent and accurate financial data.
- Collaborated closely with cross-functional teams to analyze financial data and research, providing valuable insights for business initiatives and strategic decision-making.
Data Analyst
Eurofins It Solutions
03.2022 - 11.2022
- Performing SQL queries in SQL server for extracting, transforming, and loading.
- Responsible for managing master data, including creation, updates, and deletion.
- Identify, analyze, and interpret trends or patterns in complex data sets.
- Responsible for Data Clean Up by Using Microsoft Excel, including Data Filter, Data Cleansing, Data validation, and Dashboard.
- Importing and Cleaning/Transforming the raw data – Using MS SQL Server Management Studio.
- Management, monitoring, and development of Eurofins' enterprise service bus.
- Code deployment and scripting of smoke test and cron jobs.
- Gathered and documented requirements.
- Creating functional and technical documents of business requirements.
Data Analyst Intern
Data Gyan
08.2021 - 02.2022
- Communicating with Clients to Understand Business Requirements related to data.
- Analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.
- MS Excel: We gather all the data into Excels sheets for each category from internal sources as well as external sources for cleaning the data and keep it ready for further analysis.
- MS SQL: We import each category data into the database server in order to combine and transform single data information to a complete master data using SQL Queries.
- Tableau: We develop an appropriate visualization using this tool for making important decisions for business optimization of the company.
- Create Daily, weekly and monthly Analytics report of product KPIs.
- Supplying qualitative and quantitative data to colleagues & clients.
- Performing daily system checks.
Education
MBA/PGDM - Operations Management
Sage University
Indore07-2021
B.Tech/B.E. - Mechanical
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV)
Indore07-2018
Skills
- SQL
- Python
- Alteryx
- Tableau
- MS Excel
- Power BI
- Linux
- R Studio
- Jira
- Azure
Certification
- Scrum Certification 2023 +Scrum Master+ Agile Scrum Training.
- SQL and Relational Databases.
- Azure Data Factory
Languages
- English
- Marathi
- Hindi
Timeline
Business Intelligence Analyst
Moody's Ratings
08.2023 - Current
Data Analyst
Eurofins It Solutions
03.2022 - 11.2022
Data Analyst Intern
Data Gyan
08.2021 - 02.2022
- Scrum Certification 2023 +Scrum Master+ Agile Scrum Training.
- SQL and Relational Databases.
- Azure Data Factory
MBA/PGDM - Operations Management
Sage University
B.Tech/B.E. - Mechanical
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV)
Similar Profiles
Jessica RaabJessica Raab
Vice President - Data Manager at Moody's RatingsVice President - Data Manager at Moody's Ratings
Michael DzemaMichael Dzema
Product Analyst at Moody's RatingsProduct Analyst at Moody's Ratings
Asta ZiukieneAsta Ziukiene
Manager, Global Middle Office at Moody's RatingsManager, Global Middle Office at Moody's Ratings