Apeksha Bankar is a Data Analyst with a background in Civil Engineering and expertise in data analysis, statistical modeling, and visualization tools like SQL, Python, and Power BI. She has completed an internship where she developed dashboards and machine learning models, and has worked on various projects analyzing product performance and passenger satisfaction. Apeksha is currently pursuing a Professional Course in Data Science & Machine Learning and is also a skincare and haircare content creator.
Apeksha Bankar is a Data Analyst with a background in Civil Engineering and expertise in data analysis, statistical modeling, and visualization tools like SQL, Python, and Power BI. She has completed an internship where she developed dashboards and machine learning models, and has worked on various projects analyzing product performance and passenger satisfaction. Apeksha is currently pursuing a Professional Course in Data Science & Machine Learning and is also a skincare and haircare content creator.
Apeksha Bankar is a Data Analyst with a background in Civil Engineering and expertise in data analysis, statistical modeling, and visualization tools like SQL, Python, and Power BI. She has completed an internship where she developed dashboards and machine learning models, and has worked on various projects analyzing product performance and passenger satisfaction. Apeksha is currently pursuing a Professional Course in Data Science & Machine Learning and is also a skincare and haircare content creator.
Apeksha Bankar is a Data Analyst with a background in Civil Engineering and expertise in data analysis, statistical modeling, and visualization tools like SQL, Python, and Power BI. She has completed an internship where she developed dashboards and machine learning models, and has worked on various projects analyzing product performance and passenger satisfaction. Apeksha is currently pursuing a Professional Course in Data Science & Machine Learning and is also a skincare and haircare content creator.
Seasoned Data Analyst with a solid background in data analysis, statistical modelling, and data visualization. Transitioning from a Civil Engineering background with a bachelor's degree, contributing strong analytical and critical thinking abilities honed through academic projects and internships. Proficient in SQL, Python, Excel, Power BI, and machine learning for efficient data manipulation and analysis. Adept at extracting insights, driving business decisions, and solving complex problems. Eager to apply analytical skills and technical expertise to support data-driven initiatives within a collaborative team.
Skills: • Programming Languages: Python (data analysis, visualization), SQL (querying, data manipulation) • Data Manipulation: Pandas (data cleaning, transformation), Excel (advanced features, automation) • Data Visualization: Power BI (dashboard creation), Tableau (interactive dashboards), Matplotlib/Seaborn • Statistical Analysis: Hypothesis Testing (validate assumptions), Regression Analysis (predictive modelling) • Machine Learning: Scikit-learn (model building, evaluation), TensorFlow (deep learning models) • Database Management: MySQL (database querying, management), ETL Processes: Extract, Transform, Load • Reporting & Dashboard Creation: Power BI, Excel, Jupyter Notebooks (interactive reports) • Tools & Platforms: Google Colab /Jupyter Notebook (interactive reports), AWS for Games (cloud computing) • Version Control: GitHub (version control, collaboration), Data Analysis & Interpretation: Extracting insights from complex datasets, Problem- Solving: Critical thinking, analytical reasoning
Internship: Data Analyst Intern | Fireblaze Technologies Private Limited March 2024 – August 2024 • Engineered efficient SQL queries to manage and analyse datasets, transforming raw data into actionable insights. • Created dynamic and informative Power BI dashboards, translating complex metrics into comprehensible visualizations. These dashboards empowered stakeholders to make informed decisions, driving business growth. • Demonstrated proficiency in Python for data wrangling, effectively cleansing and processing datasets of up to 500,000 rows. Implemented automation and optimization techniques, achieving a significant reduction in data preparation time. • Developed sophisticated machine learning models in Python, delivering highly accurate forecasts that guided strategic business decisions. Additionally, designed advanced Excel analyses using advanced formulas and pivot tables to uncover trends and support strategic decision- making. Projects: Nike Product Analysis Dashboard | Fireblaze Technology Private Limited, Nagpur March 2024 - April 2024 • Designed and developed a comprehensive Power BI dashboard to analyse and visualize key performance indicators (KPIs) for Nike products. Created interactive visualizations, including overview, insights, and performance tabs, to facilitate data-driven decision-making. • Provided clear metrics on sales, reviews, and ratings to empower stakeholders with actionable insights. Dry Bean Classification Analysis | Fireblaze Technology Private Limited, Nagpur April 2024 - May 2024 • Conducted a comprehensive analysis of dry bean characteristics to classify various bean types using Python. • Processed a dataset comprising 13,611 entries and generated visualizations, including box plots, scatter plots, and heatmaps, to identify significant patterns and relationships within the data for accurate classification. ICICI Bank Management System Project | Fireblaze Technology Private Limited, Nagpur March 2024 - March 2024 • Designed and implemented a robust relational database comprising six interconnected tables using SQL, ensuring efficient data storage and retrieval. • Demonstrated proficiency in data management by inserting data, executing complex queries, and creating views to consolidate and present data effectively. • Successfully completed all project tasks within the stipulated one-week deadline, showcasing exceptional time management and project execution skills. Airline Passenger Satisfaction Prediction Project | Fireblaze Technology Private Limited, Nagpur April 2024 - May 2024 • Conducted a comprehensive analysis of passenger satisfaction factors utilizing Python programming language. • Processed a dataset consisting of 383 entries and generated insightful visualizations such as histograms, count plots, and heatmaps. • Leveraged machine learning techniques to discern patterns and accurately predict passenger satisfaction, achieving an impressive accuracy rate of 92.2%. Education: Rajiv Gandhi College of Engineering June 2018 – June 2022 Bachelor of Engineering in Civil Engineering CGPA: 7.45 Certifications: Professional Course in Data Science & Machine Learning March 2024 – Present Hobbies and Interests: Skincare & Haircare Content Creator: Develop and distribute content related to skincare and haircare routines, product evaluations, and expert advice on social media platforms to connect with a community of beauty enthusiasts.
