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
Power BI Developer at Nelco Ltd. (A Tata Enterprise)Power BI Developer at Nelco Ltd. (A Tata Enterprise)
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.
Hardik ShahHardik Shah
Representative - South Asia at EHL Hospitality Business SchoolRepresentative - South Asia at EHL Hospitality Business School
Shivam BhatShivam Bhat
Senior Consultant at EYSenior Consultant at EY