Summary
Overview
Work History
Education
Skills
Personal Information
Certification
Accomplishments
Timeline
Generic

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
Mumbai
06.2022

Post Graduation Diploma in Data Science - Data Science

International Institute of Information Technology
Bengaluru
08.2021

B.Tech - Electronics And Telecommunication

Symbiosis Institute of Technology
Pune
06.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
Soumya Lal