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

Soham Sarkar

Summary

Accomplished Business Intelligence Consultant with a robust background in data analysis, process optimization, and strategic decision-making. Expertise in crafting and deploying advanced BI solutions leveraging Power BI, SQL, and cloud technologies. Demonstrated success in leading cross-functional teams to generate actionable insights that drive business growth and operational efficiency. Committed to enhancing organizational performance through innovative data handling and reporting techniques.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Business Intelligence Consultant

Principal Global Services
09.2021 - Current
  • Leading a BI Team and collaborating with business stakeholders to understand the business requirements.
  • Extracting data from various cloud and on-prem sources, and cleansing them for consumption in the reporting layer.
  • Modernization and automation of the reporting platform with the use of Power BI leading to time and cost saving.
  • Improved report speed and accuracy by creating efficient Power BI data models.
  • Automation and scheduling using Power Automate,batch scripting and SAS macros.
  • Collaborating with the data science team to present insights on models and make real-time changes using Power App.
  • Creating interactive dashboards involving several sources, using data flows and data marts.
  • Using Power Query script to get data from multiple files and folders, and set up automatic scheduling.
  • Implementation of RLS to give appropriate access.
  • Extracting and modifying data with the use of SQL.
  • Developing end-to-end applications with the use of Power App, Power BI, and Power Automate.
  • Use of Power BI Report Builder to create self-serve Power BI paginated reports with multi-parameter functionality sourced on ODBC connection.
  • POC using Power BI Co-Pilot.
  • Using SAS to extract data from DB2 sources and build flows for reporting.
  • Documented business processes and created technical specifications for BI solutions.
  • Provided technical expertise in developing, deploying and optimizing Business Intelligence solutions.
  • Optimised data collection methods to ensure accuracy and reliability of information.
  • Produced detailed reports and visualisations to communicate complex information clearly.
  • Delivered training sessions on BI tools and analytics techniques, improving team competencies.

Business Intelligence Analyst

Tata Consultancy Services
11.2015 - 09.2021
  • Power BI for building reports on SAP HANA.
  • Using SQL scripting in SAP HANA to build models and do reporting on SAP BO.
  • Using SQL to extract data from Data Lake in AWS Databricks.
  • Use of BEx queries and designing universes in BO.
  • Performance tuning.
  • Generated reports from multiple sources.

Developer

Cognizant
06.2012 - 11.2015
  • Using SAP Business Objects and SQL on an Oracle database to build universes and reports.
  • Collaborating with the team and onsite partners for deliveries.

Education

B.Tech - Information Technology

WBUT
06-2012

XIIth - Science

CISCE
04-2008

Xth -

CICSE
03-2006

Skills

  • Data analysis and visualization
  • Power BI
  • SQL

Secondary Skills:

  • Power Automate
  • Power App
  • Power BI Paginated Report
  • Business Objects
  • SAS Enterprise Guide
  • Modelling in SAP HANA
  • AWS Databricks
  • AWS Cloud Practitioner Certified

Additional Information

  • Modernize the reporting platform using Power BI.
  • Time optimization using automation
  • Performance tuning.
  • Building insights for the Data Science Team to work on.
  • Client Onboarding.
  • Extracting, data modeling, visualization, security setup for analysis for financial reporting, customer care, and marketing.
  • On-premise to Cloud migration
  • Production support.
  • Working on several projects on SAP BO with several backend systems.

Certification

AWS Certified Cloud Practitioner

Personal Information

  • Passport Number: U7702955
  • Date of Birth: 06/29/89
  • Gender: Male
  • Nationality: Indian

Timeline

Business Intelligence Consultant

Principal Global Services
09.2021 - Current

Business Intelligence Analyst

Tata Consultancy Services
11.2015 - 09.2021

Developer

Cognizant
06.2012 - 11.2015

B.Tech - Information Technology

WBUT

XIIth - Science

CISCE

Xth -

CICSE

Similar Profiles

CREATE PROFILE
Soham Sarkar