Soham Bhattacharya
Data analyst
Mumbai
Summary
Experienced in utilizing SQL, Excel, Power BI, and Tableau. Aspiring Data Analyst with a strong background in financial data analysis, auditing, and business insights. Expertise in data cleaning, visualization, and reporting. Keen eye for identifying trends and optimizing processes. Passionate about using data-driven strategies to enhance business efficiency. Dedicated to leveraging skills to drive impactful results.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
4
4
Languages
Work History
Financial Data Analyst
Accenture
07.2024 - 01.2025
- Conducted data validation and cleansing on large datasets, ensuring 99% accuracy.
- Used SQL queries to extract and analyze financial transactions, identifying revenue discrepancies.
- Designed Power BI dashboards to visualize financial performance and cost-saving opportunities.
- Automated data entry and reporting processes, reducing manual effort by 40%.
- Boosted stakeholder satisfaction by consistently delivering high-quality analyses that informed crucial business decisions.
Data Analyst Intern
VKM & CO.
05.2022 - 12.2023
- Analyzed financial audit reports to detect anomalies and improve compliance.
- Automated tax filing reports using Excel macros, reducing processing time by 30%.
- Collaborated with the finance team to build expense tracking dashboards in Tableau.
- Extracted and interpreted client data to support decision-making in tax strategy.
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
Education
HSC -
Model college
01.2019 - 01.2021
Bachelor of Accounting & Finance - undefined
S.K Somaiya College
01.2021 - 01.2024
Skills
Data Analysis: SQL, Excel, Python
Data Visualization: Power BI, Tableau
Database Management: MySQL, PostgreSQL
ETL & Data Cleaning: Pandas, Excel Macros
Reporting & Dashboarding
Communication
Teamwork
Attention to Detail
Financial Analysis Expertise
Projects
Expense Optimization for a Real Estate Firm (2024)
Tools Used: Excel, SQL, Tableau
- Analyzed ₹50L+ in operational expenses to identify cost inefficiencies.
- Built a real-time dashboard in Tableau to track expenses vs. revenue.
- Recommended procurement adjustments that led to a 15% reduction in costs.
Tools Used: Python, SQL, Power BI
- Processed 1M+ customer transactions to identify churn patterns.
- Developed a predictive model to forecast customer attrition with 85% accuracy.
- Suggested retention strategies that improved customer retention by 12%.
Certifications
🎓 Google Data Analytics Professional Certificate
🎓 Microsoft Power BI Certification
🎓 SQL for Data Science – Coursera
Timeline
Financial Data Analyst
Accenture
07.2024 - 01.2025
Data Analyst Intern
VKM & CO.
05.2022 - 12.2023
Bachelor of Accounting & Finance - undefined
S.K Somaiya College
01.2021 - 01.2024
HSC -
Model college
01.2019 - 01.2021