SUBASISH MONDAL
Bengaluru,KA
Summary
Results-driven Senior Data Analyst and BI Manager with over 6 years of experience specializing in digital payments, finance, HR, and compliance analytics. Proficient in aligning analytics solutions with business strategies, optimizing processes, and fostering strong stakeholder partnerships. Demonstrated expertise in Tableau Desktop, SQL, Python, and advanced MS Excel, including pivot tables, VBA automation, and financial modeling. A solid foundation in ETL processes, data governance, and compliance reporting complements a proven track record in risk management, system testing, and leading cross-functional IT projects.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Business Intelligence Manager
HSBC
11.2024 - Current
- - Drove compliance and digital payment analytics strategy on 6000+ Diamond clients along with P50 marker, building dashboards in Power BI & Advanced Excel(Power Query, VBA) using data extracted using GBQ & GCP Warehouse for fraud monitoring and merchant risk management enhancing STP rate by 36%.
- - Automated ETL pipelines using SQL, Python, GITHUB, Apache Jenkins and Google Cloud Platform; streamlined reporting with Excel macros and pivot tables hence enhancing efficiency of report extraction by 75%.
- - Drove SQL query optimization, data extraction automation, data manipulation and developing key KPI dashboards on Looker Studio to showcase story based KPIs to high level stakeholders hence enhancing BAU business decision making by 50%.
- - Drove data based KPIs using complex SQL queries on database from EMEA, MENAT, APAC and USA providing hourly statistics and bucketing of L1/L2 or manual handling of payments and hence assisting AI based models to improve STP rate by 60% at a global level.
- - Automated issue monitoring using JIRA tool and developed JIRA workflow, Reports and dashboard.
- - Mentored junior analysts on BI tools, data governance, and advanced Excel analytics.
HR Reporting Analyst
News Corp India
05.2022 - 10.2024
- - Designed workforce and payroll dashboards using GBQ, Excel, and Looker to support decision-making and improving efficiency by 60%.
- - Applied forecasting models for attrition/hiring trends; optimized workforce planning reports with Excel VBA automation.
- - Collaborated with HR and Finance stakeholders to ensure compliance and governance in reporting.
Systems Engineer
Tata Consultancy Services
02.2019 - 05.2022
- - Managed finance & reinsurance analytics dashboards using SQL, PL/SQL, Excel, and Looker; improved reporting accuracy by 70%.
- - Automated financial reconciliation and chargeback handling using Excel VBA and PL/SQL, reducing manual effort by 60%.
- - Delivered BRDs, risk assessments, and IT project coordination for finance and payments systems.
Education
B.Tech - Electronics & Communication Engineering
Haldia Institute of Technology
West Bengal, India07-2017
Skills
- BI & Analytics: Power BI, Tableau, Looker, Excel (Advanced: Power Query,VBA, Macros, Pivot Tables)
- Data Engineering: SQL, PL/SQL, Python, Google Cloud Platform, BigQuery
- Digital Payments: Risk management, compliance, name screening, STP enhancement, chargeback handling, client onboarding
- Project Management: Stakeholder coordination, IT project delivery, governance & testing
- Issue Management: JIRA tool, JQuery, JIRA Workflow
- Stakeholder engagement and documentation
Websites
Certification
- Advanced Tableau Certification – Tableau Data Analyst
- PL/SQL Advanced Course – LinkedIn
- Machine Learning & Data Analytics – IIT Ropar & INSEAD
KEY HIGHLIGHTS
- Implemented 300+ reports and dashboards, improving decision-making efficiency by 50%.
- Automated financial workflows with Excel & SQL, reducing processing effort by 70%.
- Received Best Team Player Award at TCS for SDLC Project delivery.
Languages
English
Advanced (C1)
Bengali
Bilingual or Proficient (C2)
Hindi
Upper intermediate (B2)
Timeline
Business Intelligence Manager
HSBC
11.2024 - Current
HR Reporting Analyst
News Corp India
05.2022 - 10.2024
Systems Engineer
Tata Consultancy Services
02.2019 - 05.2022
B.Tech - Electronics & Communication Engineering
Haldia Institute of Technology