Soumya Lal
Senior Business Analyst
Mumbai
Summary
Results-driven Data & Business Analyst with 7+ years of experience delivering insights through data visualization, reporting, and analytics. Proficient in Power BI, SQL, and Advanced Excel, with a strong background in building interactive dashboards, automating reports, and enabling data-driven decision-making across B2C industries. Skilled in data modeling, transformation, and stakeholder collaboration, with a proven ability to convert complex data into actionable business strategies
Overview
7
7
years of professional experience
6062
6062
years of post-secondary education
1
1
Certification
Work History
Senior Business Analytics - PMO Office
Nelco Ltd. ( A Tata Enterprise)
06.2024 - Current
- Leveraged Power BI and advanced SQL to consolidate multi-source data and extract strategic insights driving key business decisions.
- Conducted trend, pattern, and correlation analysis to identify performance gaps and recommend corrective actions.
- Designed and implemented interactive dashboards and visualizations for tracking KPIs, project health, and financial performance, streamlining executive reporting.
- Created risk management dashboards, financial dashboards, and business scorecards to support critical strategic and operational decisions.
- Supported the Strategy Head in conducting performance reviews, enabling data-driven evaluation of department-wide initiatives.
- Acted as a liaison across cross-functional teams to streamline data collection processes and ensure on-time reporting.
- Led the migration of manual Excel-based reports to automated Power BI solutions, significantly enhancing reporting efficiency and data reliability.
Power BI Developer
Accenture
10.2021 - 06.2024
- Developed insightful business dashboards and conducted trend analysis for stakeholders across FMCG and electronics markets, enabling data-driven decisions.
- Proficient in data modeling, transformation, and visualization using Power BI, with hands-on experience in Power Query, DAX (calculated columns & measures), and multiple visualization techniques.
- Connected Power BI with diverse data sources like SQL Server, Azure, Synapse, Databricks, Salesforce, Azure Blob, and Excel to construct complex and scalable datasets.
- Ensured data security with Row-Level (RLS) and Column-Level (CLS) security implementations.
Business Analyst
RBL Bank
12.2019 - 09.2021
- Developed and maintained project management and financial dashboards in Power BI to support spend analysis and compare actuals against forecasts for the technology division.
- Migrated manual Excel reports, including payment trackers, into automated Power BI solutions, enhancing efficiency and accuracy.
- Automated procurement workflows using Kissflow, streamlining approval processes and reducing manual intervention.
Financial Analyst
IBM
02.2018 - 12.2019
- Financial Consultant for Media and entertainment in UK: Hands on E-business suite of Oracle Application and SQL.
- Experienced in accounts Payables ( I-Expenses). Rectifying bug in the P2P.
- Maintaining the Daily Monitoring tracker
Education
Post Graduation Diploma in Business Management - Information Technology And System Management
Narsee Monjee Institute Of Management Studies
Post Graduation Diploma in Data Science - Data Science
International Institute of Information Technology
B.Tech - Electronics And Telecommunication
Symbiosis Institute of Technology
Skills
Microsoft Power BI
SQL
DAX
Microsoft Excel
Project Planning
Tableau
Accomplishments
- Received Best Graduate Hire Award in IBM -2018
- Received Sparkling Start Award in Accenture - 2022
- Received Tech Crusader Award at Nelco - 2024
Certification
Completed Microsoft certifications like PL-300, PL-900 and DP-500
Timeline
Senior Business Analytics - PMO Office
Nelco Ltd. ( A Tata Enterprise)
06.2024 - Current
Power BI Developer
Accenture
10.2021 - 06.2024
Business Analyst
RBL Bank
12.2019 - 09.2021
Financial Analyst
IBM
02.2018 - 12.2019
Post Graduation Diploma in Business Management - Information Technology And System Management
Narsee Monjee Institute Of Management Studies
Post Graduation Diploma in Data Science - Data Science
International Institute of Information Technology
B.Tech - Electronics And Telecommunication
Symbiosis Institute of Technology
Similar Profiles
Soumya LalSoumya Lal
Senior Business Analytics - PMO Office at Nelco Ltd. ( A Tata Enterprise)Senior Business Analytics - PMO Office at Nelco Ltd. ( A Tata Enterprise)
Debraj MukherjeeDebraj Mukherjee
Head of Sales-Key Segment at Nelco Ltd.Head of Sales-Key Segment at Nelco Ltd.
Chinmay Kaluram PatilChinmay Kaluram Patil
Program Executive at Tata NelcoProgram Executive at Tata Nelco
Suraj SethSuraj Seth
Assistant Manager – Direct Tax at CBV & Associates LLPAssistant Manager – Direct Tax at CBV & Associates LLP
Aditya ApteAditya Apte
Product Manager at ProgIST Solutions LtdProduct Manager at ProgIST Solutions Ltd