SHREEDHAR KHAIRNAR
Pune
Summary
Aspiring Data Analyst with a strong foundation in statistical analysis and data visualization. Proficient in SQL, Power BI, and Excel. Completed several academic projects involving data cleaning, analysis, and reporting. Seeking data analyst position to apply analytical skills and contribute to data-driven decision-making business processes.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data intern
Federal Bank
02.2022 - 01.2023
- Department: Retail Asset Department
- Assist in collecting, cleaning, and analyzing data sets
- Collaborate with the data analysis team to identify trends and patterns
- Contribute to the development of data visualization dashboards and reports
- Support in creating presentations to communicate findings to stakeholders
- Learn and utilize various data analysis tools and techniques
- Use data to quantify the business impact of potential customers
Lead Generation Executive
XDBS Private
03.2021 - 10.2021
Browsing existing buyer profiles to determine the probability of
a lead showing interest in their product or service.
Identify viable leads and collaborate with the sales team to focus
their efforts on interested companies.
Initiate cold calls, emails, and other outbound communications;
Organize lead data with CRM tools.
Education
Bachelor of Science - Mathematics
P.E.S. MODERN COLLEGE , PUNE
PUNE06.2019
Skills
Technical skills-
Data visualization:
Power BI, Excel for visual dashboards
Data Management- to collect, organize, and store data in a efficient way, SQL,Data Warehousing, Data Modeling, Business Intelligence
Spreadsheet tools- MS excel for data entry and preliminary data analysis
Soft skills-
Communication,
Critical thinking,
Problem solving
Adaptability and Flexibility
Certification
- Power BI
- SQL for data analysis
Vitals
Prabhat colony, Pawar Nagar Lane no.2, Old Sangavi, Pune, 411027, 7588266956, khairnar1996@gmail.com
Projects
1. Customer classification Analysis 2. Loan Default Prediction 3. Home Loan Interest Rate Analysis 4. Transaction Trend Analysis
Objective: Segment bank customers based on their transaction behavior.
Tasks:
Use customer transaction data (e.g., transaction amounts, frequency, types of transactions).
identify distinct customer segments.
Visualize the segments and summarize their characteristics.
Outcome: A report detailing different customer segments and strategies for targeted marketing.
Objective: Analyze loan data to identify factors that contribute to loan defaults.
Tasks: Obtain a dataset of loans with features like income, credit score, loan amount, and default status.
Perform exploratory data analysis (EDA) to identify trends and correlations.
Build a logistic regression model to predict default likelihood.
Outcome: A predictive model and insights on risk factors associated with defaults.
Objective: Analyze the impact of interest rates on savings account balances over time.
Tasks: Gather data on interest rates and corresponding savings account balances.
Analyze how changes in interest rates affect customer savings behavior.
Visualize trends and correlations between interest rates and balances.
Outcome: A report discussing how interest rate policies can influence customer savings.
Objective: Analyze transaction patterns and trends over time.
Task: Develop time series visualizations for transaction volume and value, with filtering options.
Outcome: Insights into peak transaction periods and customer behavior.
Timeline
Data intern
Federal Bank
02.2022 - 01.2023
Lead Generation Executive
XDBS Private
03.2021 - 10.2021
Bachelor of Science - Mathematics
P.E.S. MODERN COLLEGE , PUNE
- Power BI
- SQL for data analysis
Similar Profiles
Prerna SoniPrerna Soni
Loan Processing Intern at FEDERAL BANKLoan Processing Intern at FEDERAL BANK
KANCHAN JOSHIKANCHAN JOSHI
Head of Sales at FEDERAL BANKHead of Sales at FEDERAL BANK
Arularasu VArularasu V
Associate Vice President-Treasury Sales at Federal BankAssociate Vice President-Treasury Sales at Federal Bank