PALLAVI KHAIRNAR
Data Analyst
Pune
Summary
With over two years of experience as a Data Analyst, specialization lies in leveraging Power BI to craft dynamic reports and dashboards. Expertise lies in adeptly collecting, transforming, and summarizing data, delivering timely insights to senior management. Proficient in SQL query optimization and bug resolution, ensuring efficient operations and delivering high-quality solutions, maintaining project agility to meet evolving client needs.
Overview
5
5
years of post-secondary education
3
3
Languages
Work History
Data Analyst
Axis Bank
3 2019 - 3 2021
- Extracted and transformed data from various banking systems and databases using SQL queries.
- Cleaned and validated data to ensure accuracy, consistency, and completeness, utilizing Excel and SQL.
- Analyzed large datasets to identify trends, patterns, and insights relevant to banking operations. Developed interactive dashboards and reports using Power BI to visualize key performance indicators (KPIs) such as customer acquisition, loan portfolios, transaction volumes, and fraud detection.
- Assisted in risk assessment and compliance activities by analyzing historical data and identifying potential risks or anomalies.
- Ensured data quality, integrity, and security in accordance with regulatory requirements and industry standards.
- Collaborated with cross-functional teams, including business analysts, IT professionals, and compliance officers, to understand requirements and deliver solutions that meet business needs.
- Deployed predictive analytics models to forecast future trends
- Developed customized reports, summarizing and presenting data in visually appealing format
Account Assistant
B V PASALKAR (Construction Firm)
01.2018 - 06.2018
- Managing financial records, processing invoices and payments, reconciling bank statements, preparing financial reports, monitoring budgets, and supporting financial audits.
Education
MBA - Finance
Dr. D Y Patil Institute of Management & Research Pune
Pune, India 07.2015 - 05.2017
BBA - Finance
Ashoka Center For Business And Computer Studies
Nashik, India 06.2012 - 05.2015
Skills
Microsoft Power BI- Report and dashboard creation, Data Modelling, Advanced Dax, Data transformation using power query
SQL- T-SQL
Database - SQL Server, Excel, AWS, CSV
Microsoft Excel- Pivot Table, VLOOKUP
Internship
Tata Virtual Internship: - Data Visualization: Empowering Business with Effective Insights
Personal Information
- Date of Birth: 12/27/94
- Marital Status: Married
Timeline
Account Assistant
B V PASALKAR (Construction Firm)
01.2018 - 06.2018
MBA - Finance
Dr. D Y Patil Institute of Management & Research Pune
07.2015 - 05.2017
BBA - Finance
Ashoka Center For Business And Computer Studies
06.2012 - 05.2015
Data Analyst
Axis Bank
3 2019 - 3 2021
Similar Profiles
Lakshay SharmaLakshay Sharma
Deputy Manager at Axis Bank (On Payroll Of Axis Bank)Deputy Manager at Axis Bank (On Payroll Of Axis Bank)
Preethi VPreethi V
Relationship Associate at Axis Bank - Axis Max Life InsuranceRelationship Associate at Axis Bank - Axis Max Life Insurance
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
ANIL BASAKANIL BASAK
Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)
CHIRAG DAVECHIRAG DAVE
Senior Sales Manager at Maestro RealtekSenior Sales Manager at Maestro Realtek