Name: Ayanita Malik

Job Role: Junior Data Analyst

Experience: 6 Months

Address: Kolkata, India

Skills

Excel 95%
SQL 90%
Data Visualization 90%
PYTHON 80%

About

About Me

As a diligent Data Analyst with expertise in Excel, SQL, Python, Power BI, and Tableau, focused on optimizing data processes and driving business growth. Possess strong critical thinking skills and excel at translating technical information into actionable insights, making a valuable asset to any team.

  • Profile: Data Analytics
  • Domain: Retail, Ecommerce & Digital Marketing
  • Education: Bachelor of Computer Application
  • Language: Bengali, Hindi, English
  • BI Tools: Microsoft Power BI, Looker & Tableau
  • Other Skills: Git, JIRA, Google Analytics & SEO
  • Interest: Exploring New Things, Traveling, Travel Photography

0 +   Projects completed

LinkedIn

Resume

Resume

Aspiring Data Analyst with hands-on experience in data analysis, visualization, and machine learning. Proficient in Excel, SQL, Power BI, Python and Tableau. Demonstrated ability to translate complex data into actionable business insights through academic projects and internships. Strong analytical, problem-solving, and communication skills, eager to contribute to a dynamic team and grow in a challenging role.

Experience


July 2024 - Present

Data Science Intern

CodSoft

CodSoft is a technology and software development company focusing on innovative data solutions.

  • Executed data analysis and modeling for multiple projects, leveraging Python for machine learning and data preprocessing with tools like Pandas and NumPy.
  • Built and optimized predictive models, addressing class imbalances and enhancing model accuracy, resulting in improved decision-making processes.
  • Developed insightful reports and interactive dashboards to present findings and recommendations, significantly aiding stakeholders in strategic planning.

June 2024 - July 2024

Power BI Intern

Cognifyz Technologies

Cognifyz Technologies, a dynamic firm specializing in innovative data solutions and technology-driven insights.

  • Conducted gender-based investment analysis, correlation studies, and trend analysis using Power BI.
  • Created interactive dashboards to visualize investment durations and examined information sources, identifying key investment trends.
  • Provided actionable insights that drove strategic investment decisions, enhancing client satisfaction and engagement.

April 2024 - May 2024

Data Analytics and Visualization (Job Simulation)

Accenture North America

Accenture North America is a leading global professional services company providing a range of strategy, consulting, digital, technology, and operations services.

  • Conducted comprehensive data analysis using Python, SQL, and Tableau, focusing on data cleaning, modeling, and visualization.
  • Developed detailed reports and interactive dashboards, resulting in a significant improvement in data-driven decision-making processes for clients.
  • Presented findings through well-structured PowerPoint presentations to clients and stakeholders, enhancing their understanding of data insights and strategic recommendations.



Education


2021-2024

Bachelor of Computer Application

West Bengal University of Technology

Grade: First class distinction.

2019-2021

Higher Secondary School

Sankrail Abhoy Charan High School

Grade: First class distinction.

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI & ML.

Digital Music Store Data Analysis using SQL

Analyzed music store data using advanced SQL queires to identify gaps and increase the business growth.

Diwali Sales Data Analysis using Python

Performed exploratory data analysis on diwali sales data using Python to improve the customer experience.

Credit Card Financial Dashboard using Power BI

Designed a Power BI dashboard to track and analyze credit card transactions and customer data, providing real-time insights for decision-making.


More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Kolkata, India

Contact Number

+ 91 6289714402

Email Address

ayanitamalik@gmail.com

Download Resume

Click Here