Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shubham Tomar

Renton,WA

Summary

Dedicated professional with demonstrated strengths in the field of data - developing, implementing and optimizing ETL pipelines, analytical dashboards. Good at troubleshooting problems and building successful solutions. Experienced in working both as an individual contributor as well as leading a team of data professionals. Excellent verbal and written communicator with strong background cultivating positive relationships and exceeding goals.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Lead Engineer

HCL America Inc
04.2023 - Current
  • Discussion and meeting with client and different project stakeholders for the project sprint planning, work prioritization, requirement analysis, design discussion, project deployment
  • Understanding and gathering the client requirements, guiding, and helping the team build a robust solution for workplace analytics platform
  • Analyzing and designing data models which serve best fit as per the requirements
  • Writing complex DAX measures and calculated columns in Power BI which fulfills the metric requirements and delivers required insights
  • Managing data pipelines to perform data cleanup and transformation using Synapse analytics
  • Plan work, collaborate on code development using Azure DevOps.

Lead Engineer

HCLTech
09.2021 - 04.2023
  • Analyzing and designing data models which serve best fit as per the requirements
  • Developing visual appealing and high performance power bi reports to deliver insights to the end user
  • Writing complex DAX measures and calculated columns in Power BI which fulfills the metric requirements and delivers required insights
  • Writing complex power query logic, functions to perform data cleanup and transformation in Power BI
  • Localizing power bi reports to deliver insights to customers of different geographies in their own locale
  • Designing the Power BI reports to meet accessibility compliance standards to serve the need of a wider audience
  • Perform data analysis, cleanup and transformation using Azure Databricks
  • Creating fault-tolerant ETL pipelines using Azure Data Factory with the desired cadence.

Software Engineer

HCLTech
03.2018 - 09.2021
  • Reading telemetry data from cosmos and performing data cleansing, transformation, and aggregation on terabytes of data
  • Setting up ETL pipelines using Azure Data Factory for the data processing and movement from cosmos to Azure SQL DB
  • Setting up automated pipeline monitor system to detect failures using Azure monitor and Azure logic apps
  • Creating tables, views, indexes, stored procedures etc
  • With AzureSQL DB and Synapse Analytics
  • Creating and maintaining Azure analysis service tabular models which powers the Power BI reports and further enables the user to get insights using Excel
  • Understanding the insights requirement and developing power reports and dashboards accordingly, performing data transformation or cleanup activities using power query
  • Writing complex DAX measures, calculated columns for Power BI reports and Azure analysis service metrics
  • Detecting anomalies in the data from the report visualizations and reporting to the client.

Test Engineer

BULL IT Services
08.2017 - 03.2018
  • Extracting raw data from Cosmos/Kusto, data cleansing and transformation using Azure Data Lake Analytics
  • Writing U-SQL scripts used to cleanse and aggregate raw data as per the business requirements
  • Creating data pipelines using Azure Data Factory to ingest data into Azure SQL DWH, Azure Storage
  • Using Azure Machine Learning for data modelling and creating forecasts pipelines
  • Creating Tables, Views, Stored Procedures, UDFs in Azure SQL DWH
  • Creating Power BI visualizations and interactive dashboards for timely business insights.

Education

Bachelor of Technology - CSE -

Uttar Pradesh Technical University
Noida, Uttar Pradesh
06.2017

Skills

  • Azure Data Factory
  • Azure Databricks
  • Azure Data lake
  • Azure Synapse Analytics
  • Azure Analysis Service
  • Power BI
  • SQL
  • DAX
  • Python
  • Apache Spark
  • Microsoft Fabric

Certification

  • Microsoft Certified Azure Data Engineer
  • Microsoft Certified Data Analyst
  • Analyzing and Visualizing Data with Power BI
  • UDEMY - Taming Big Data with Apache Spark and Python

Timeline

Lead Engineer

HCL America Inc
04.2023 - Current

Lead Engineer

HCLTech
09.2021 - 04.2023

Software Engineer

HCLTech
03.2018 - 09.2021

Test Engineer

BULL IT Services
08.2017 - 03.2018

Bachelor of Technology - CSE -

Uttar Pradesh Technical University

Similar Profiles

CREATE PROFILE
Shubham Tomar