AYAN MALAKAR
Data Analyst
Kolkata,WB
Summary
Data Analyst with expertise in advanced analytics, data visualization, and performance tracking, leveraging SQL, Python, Power BI, and Excel. Skilled in analyzing business performance, creating interactive data visualizations, and providing trusted insights to drive data-driven decision-making. Experienced in process optimization, stakeholder communication, and issue resolution. Proficient in developing tailored reports and dashboards using Power BI and Excel, with a strong understanding of DAX and SQL for efficient data management and reporting.
Overview
1
1
year of professional experience
1
1
Certification
4
4
years of post-secondary education
Work History
Operation Executive
Diligent AI Research LLP
Kolkata
01.2024 - 11.2024
- Delivered exceptional customer service across multiple channels by leveraging strong communication skills, including active listening and conflict resolution, to ensure client satisfaction
- Collaborated with clients to gather and analyze project requirements, translating business needs into actionable deliverables and solutions
- Collected, cleaned, and transformed data for seamless database integration, improving accuracy and compliance with organizational standards
- Developed and optimized client-facing reports, ensuring accuracy and timeliness while identifying areas for process improvement
- Designed interactive dashboards and prepared reports using Excel (VLOOKUP, Pivot Tables, and advanced formulas) to deliver high-priority client reports within tight deadlines, ensuring data accuracy and actionable insights
- Developed comprehensive SOPs for websites, providing clear and concise guidelines to clients for effective usage and navigation, improving client onboarding and user experience.
Education
Certification - Data Science
Ivy Professional School
Kolkata 07.2022 - 07.2023
Bachelor of Science - Economics
Kalyani Mahavidyalaya (University of Kalyani)
Kalyani 06.2019 - 06.2022
Skills
- Data Analysis
- Statistical Methodologies (Regression, Hypothesis Testing)
- Data Modeling
- Predictive Modeling & Forecasting, Pattern Recognition
- Trend Analysis
- Data Reporting
- Power BI (Row-level Security, Bookmarks, Report Development, DAX, Power Query)
- Advanced Excel (Pivot Tables, VBA, Macros, Advanced Formulas)
- MS PowerPoint
- Python (Pandas, NumPy, Matplotlib)
- SQL, SSMS, TSQL, MS SQL SERVER
- ETL
- Manual Testing
- QA Testing
- Data Documentation
- SOP Development
Certification
Hacker Rank SQL(Beginners) Certification
Hacker Rank SQL (Intermediate) Certification
SQL Certification
Additional Information
Blink-It Sales Analysis Report DASHBOARD
- Analyzed 10,000 records of Blink-it sales data and designed a comprehensive dashboard using Power BI for monitoring online Campaign Performance, Customer feedback, sales performance and Industry trends.
- Highlighted a 4.04% year-on-year growth in sales, leading to 11.01M in revenue, with insights on top-selling products, high-performing locations for Blink-it.
- Visualized customer feedback metrics, including sentiment analysis and Customer ratings, to evaluate customer satisfaction and retention strategies.
- Analyzed online marketing campaign data and identified a 9.9% click-to-conversion rate on social media marketing campaigns through detailed marketing analysis.
HR Analytics Dashboards DASHBOARD
- Designed and implemented dynamic Power BI dashboards to visualize key HR metrics, including employee demographics, attrition rates, training effectiveness, and performance evaluations.
- Enabled HR teams and management to identify trends in attrition by analyzing turnover rates across departments, tenure, and locations, resulting in a 15% improvement in workforce planning accuracy.
- Provided detailed insights on training program participation, resulting in a 20% increase in employee skill development effectiveness.
- Incorporated advanced DAX measures, slicers, and drill-through capabilities to create user-friendly, interactive dashboards tailored to HR teams and senior management.
- Reduced report generation time by 50%, ensuring real-time data availability for critical decision-making.
Timeline
Operation Executive
Diligent AI Research LLP
01.2024 - 11.2024
Certification - Data Science
Ivy Professional School
07.2022 - 07.2023
Bachelor of Science - Economics
Kalyani Mahavidyalaya (University of Kalyani)
06.2019 - 06.2022
Similar Profiles
Kayla GerdesKayla Gerdes
AI Model Evaluator – Chemistry Focus at Multiple Clients: AI Startups, Research LabAI Model Evaluator – Chemistry Focus at Multiple Clients: AI Startups, Research Lab
Leran ChenLeran Chen
Natural Language Processing Research at Peking University AI Research ProgramNatural Language Processing Research at Peking University AI Research Program
Charishma NarayanCharishma Narayan
Technology Consultant at Research in Digitalization, AI and Automation, Siemens Corporate TechnologyTechnology Consultant at Research in Digitalization, AI and Automation, Siemens Corporate Technology
Arpan MistryArpan Mistry
Operator Technician at TranstechOperator Technician at Transtech
Abinash Kumar GuptaAbinash Kumar Gupta
Chief Manager at Bank Of BarodaChief Manager at Bank Of Baroda