Soumya Lal
Mumbai
Summary
Power BI Developer with 7.5 years of experience turning complex data into clear, meaningful insights. Skilled in building interactive dashboards, intuitive data models, and using SQL to extract and transform data across various platforms. Known for solving problems, paying attention to the details, and working closely with teams to deliver BI solutions that support real business goals
Overview
8
8
years of professional experience
1
1
Certification
Work History
Power BI Developer
Nelco Ltd. (A Tata Enterprise)
06.2024 - Current
- Developed and maintained interactive Power BI dashboards and reports to provide real-time business insights for the NOC department.
- Created Risk management and Financial Power BI dashboards, enabling stakeholders to conduct weekly departmental and executive reviews, which contributed to a 85% faster identification and resolution of business risks.
- Collaborated with stakeholders to gather and translate business requirements into effective data models and compelling visualizations.
- Utilized SQL and Power Query for data extraction, transformation, and loading (ETL) from various sources to ensure data accuracy and consistency.
- Implemented advanced DAX calculations to support complex analytics and KPI tracking aligned with business goals.
- Optimized report performance, ensured data security, and maintained Power BI solutions for seamless user experience.
- Provided training and support to end-users to maximize effective utilization of Power BI reports
Power BI Developer
Accenture
10.2021 - 06.2024
- Developed insightful business dashboards to conduct trend analysis for the business user of various markets in the FMCG industry and electronics sectors.
- Experienced in data modelling, transformation, visualization, and dashboard creation.
- Implemented security using Row Level (RLS) and Column Level (CLS)
- Used different visuals to generate the reports, such as tables, pie charts, bar charts, line charts, and slicers.
- Hands-on experience in creating bookmarks, tooltips, hierarchies, and drilldown reports.
- Experience in connecting with multiple data sources like SQL Server, Azure, Synapse, Databricks, Salesforce, Azure Blob, Excel from Power BI to build
complex Datasets - Optimized the reports to reduce the refresh times. Knowledge of Power BI services, scheduled refresh, incremental refresh, and workspace access.
- Knowledge on Power BI services, Schedule refresh, incremental refresh, workspace access.
- Hands on experience on Azure Databricks. Migrated SQL codes to Azure Databricks.
- Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
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
Mumbai06.2022
Post Graduation Diploma in Data Science - Data Science
International Institute of Information Technology
Bengaluru08.2021
B.Tech - Electronics And Telecommunication
Symbiosis Institute of Technology
Pune06.2017
Skills
- Microsoft Power BI
- SQL
- DAX
- Microsoft Excel
- Project planning
- Tableau
Personal Information
Certification
Completed Microsoft certifications like PL-300, PL-900 and DP-500
Accomplishments
- Received Best Graduate Hire Award in IBM -2018
- Received Sparkling Start Award in Accenture - 2022
- Received Tech Crusader Award at Nelco - 2024
Timeline
Power BI Developer
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)
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