Monali Samantaray
Bengaluru
Summary
Detail-oriented Data Analyst with 1.5 years of experience in SQL, Python, Power BI, Tableau, and Excel. Proficient in data cleaning, wrangling, visualization, and reporting, with a proven ability to translate complex datasets into clear, actionable insights. Skilled at building interactive dashboards, optimizing queries, and automating reports to improve efficiency. Adaptable to diverse industries, with experience applying data-driven solutions in finance, operations, and business strategy.
Overview
2
2
years of professional experience
Work History
Data Analyst
Equentis Wealth Advisory Services Pvt Ltd
Bengaluru
01.2024 - 03.2025
- Analyzed client portfolios and identified trends that improved financial recommendations.
- Built optimized SQL queries (joins, CTEs, window functions) to generate insights from financial datasets.
- Automated portfolio and financial reporting with PowerPivot and Excel, improving reporting efficiency.
- Created management dashboards highlighting key KPIs for faster decision-making.
- Partnered with cross-functional teams to align business requirements with reporting solutions.
Data Analyst Intern
Mahanadi Coalfields Limited
Sambalpur
06.2023 - 08.2023
- Partnered with Treasury team to develop mutual fund allocation strategies and budget sheets.
- Improved reporting accuracy by cleaning and analyzing financial data with Excel.
Finance Intern
Primite Marketing Solutions
Bengaluru
05.2023 - 06.2023
- Conducted stock performance analysis using Excel and technical indicators.
- Built trend charts and visual summaries to support investment recommendations.
Education
MBA - Finance
CMS Business School, Jain Deemed University
Bengaluru05-2024
Bachelor of Science - Zoology
G.M. University
Sambalpur07-2021
Skills
Technical Skills
- SQL, Python (Pandas, NumPy, Matplotlib)
- Power BI, Tableau, Excel (Advanced, Power Query, PivotTables)
- Git, MongoDB, Orange (basic ML/EDA tool)
- Big Data Fundamentals (Hadoop, Spark basics)
Analytical Skills
- Data Wrangling & Processing
- Data Visualization & Storytelling
- Predictive Analytics & Trend Analysis
- Business Analytics (Finance & Operations)
Projects
- Pizza sales dashboard (Power BI / Excel): built an interactive dashboard with DAX to analyze sales performance, revenue, and product contribution
- IMDb movies SQL analysis: queried movies and directors data using joins, CTEs, and window functions to analyze revenues, bankability, and trends
- E-commerce data analysis (Python, Pandas): performed data cleaning and exploratory analysis, identified top-selling products and customer patterns with visualizations (Matplotlib, Seaborn)
Timeline
Data Analyst
Equentis Wealth Advisory Services Pvt Ltd
01.2024 - 03.2025
Data Analyst Intern
Mahanadi Coalfields Limited
06.2023 - 08.2023
Finance Intern
Primite Marketing Solutions
05.2023 - 06.2023
MBA - Finance
CMS Business School, Jain Deemed University
Bachelor of Science - Zoology
G.M. University
Similar Profiles
Priya GuptaPriya Gupta
Infrastructure Engineer II at Equentis Wealth Advisory Pvt LtdInfrastructure Engineer II at Equentis Wealth Advisory Pvt Ltd
RADHIKA S RRADHIKA S R
Senior Wealth Advisor at Equentis Wealth Advisory Services Ltd. - Research And RankingSenior Wealth Advisor at Equentis Wealth Advisory Services Ltd. - Research And Ranking
Kranti RajputKranti Rajput
Sr. Associate- HRBP at Equentis Wealth Advisory ServicesSr. Associate- HRBP at Equentis Wealth Advisory Services
Mehzabein SayyadMehzabein Sayyad
Senior Executive at Sobha LimitedSenior Executive at Sobha Limited
KARTHIK BKARTHIK B
Senior Associate at BMW Techworks India Pvt LtdSenior Associate at BMW Techworks India Pvt Ltd