Ankita Kamilkar
Bengaluru
Summary
Data Analyst with a Bachelor's degree in Computer Science and hands-on experience in SQL, Power BI, Tableau, Python, and Excel. Skilled in data extraction, validation, dashboard development, KPI reporting, data quality assurance, and business intelligence. Experienced in transforming raw data into actionable insights through reporting, visualization, and trend analysis to support operational and strategic decision-making.
Overview
1
1
Certification
Work History
Sales Customer Analysis Dashboard
Personal Project
Bengaluru, India
- Executed comprehensive analysis of over 8,500 sales records utilizing SQL, Python, Excel, and Power BI.
- Analyzed sales data to establish KPI metrics, including total sales, average sales, items sold, and customer feedback ratings.
- Created dynamic dashboards to visualize sales trends and enhance decision-making processes.
- Implemented data cleaning and validation techniques to optimize accuracy and consistency in reporting.
Data Analyst
Personal Project
Bangalore, India
- Wrote and optimized SQL queries to extract, validate, transform, and analyze data for reporting and business intelligence initiatives.
- Designed interactive Power BI dashboards tracking KPIs including sales performance, customer ratings, and casualty trends.
- Performed data cleaning, transformation, and validation on datasets exceeding 8,500 records.
- Created advanced DAX measures for trend analysis, KPI monitoring, and year-over-year comparisons.
- Analyzed trends, patterns, and anomalies to generate actionable business insights.
- Delivered stakeholder-ready reports and dashboard enhancements using SQL, Python, Excel, and Power BI.
- Analyzed data trends to support decision-making and improve operational efficiency.
Road Accident Analysis Dashboard
Personal Project
Bengaluru, India
- Developed a robust reporting framework utilizing SQL Server, Excel, and Power BI to enhance data visualization capabilities.
- Executed SQL case statements and pattern matching techniques to enhance data standardization and ensure quality assurance.
- Determined an 11.9 metric to assess performance standards.
- Created advanced DAX measures for precise tracking of monthly and annual performance metrics.
Education
Bachelor of Engineering - Computer Science and Engineering
Shri Sant Gajanan Maharaj College of Engineering
Shegaon, India07-2019
Skills
- Skilled in Python programming
- Efficient data retrieval
- DAX analytical skills
- Data transformation expertise with Power Query
- Data analysis using Pandas
- Proficient in NumPy library
- Data exploration analysis
- Data quality assurance
- Data quality assurance
- Data quality management
- Power BI data visualization
- Tableau analytics experience
- Excel data analysis skills
- Interactive dashboard creation
- Performance metric reporting
- SQL Server management
- Database management with MySQL
- Database management with SQLite
- Database management with MongoDB
- Data structure design
- Data reporting
- Insightful data presentation
- Data analysis expertise
- Stakeholder engagement skills
- Collaborative teamwork
- Analytical problem solving
- Requirements analysis
Certification
- Python for Data Science, Learnbay
- SQL MongoDB, Learnbay
- Tableau Power BI, Learnbay
- Sectoral Analytics Fundamentals (Finance), IBM
- Data Science and AI for Managers and Leaders, IBM
Timeline
Sales Customer Analysis Dashboard
Personal Project
Data Analyst
Personal Project
Road Accident Analysis Dashboard
Personal Project
Bachelor of Engineering - Computer Science and Engineering
Shri Sant Gajanan Maharaj College of Engineering