sureshkumar nalam

sureshkumar nalam

Sr. Data engineer
India

About Me

Having around 7years of experience in Data Engineering and Business Intelligence. Experience on MS SQL server development with SSIS , SSAS. Having valuable experience in creating Tabular model Cubes in SSAS. Experience o…

Experience

Associate Technical Leader

Encore IT services solutions Pvt Ltd
Feb 2022 - Present · 4 years 4 months

Extracting data from different sources, transforming using stored procedures and load it into target. Creating SSAS cubes for the reporting. Monitoring jobs and fixing the bugs and optimising long running queries

Sr. Data engineer

Larsen & Toubro Infotech Pvt Ltd
Nov 2020 - Feb 2022 · 1 year 3 months

Expert in identifying the requirements and in finding the system requirements.
Migration of the project from Onprem to Cloud (SQL Server to Azure Data Bricks)
Creating and Monitoring the ADF pipelines.
Developing the SSAS tabular model cube.
Developing Visualization reports and Dashboards using Power BI
Used Page Level and Report Level Filters to create Visuals.
Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
Creating pivot tables with Power Pivot knowledge in Power BI Service, Workspaces, Edit dashboards and implementing Row Level Security
Proficient with ETL tools such as SSIS
Design and develop SQL server stored procedures,Views to be used the ETL process.
Build data transformations with SSIS.
Debug and tune SSIS or other ETL process to ensure accurate and efficient movement of data.

system engineer

Harrier Information Systems PVT Ltd
Dec 2019 - Nov 2020 · 11 months

Giving support and developing the projects to Clients on data development and Business Intelligence using Azure SQL Server, SQL Server, SSIS and Power BI
Creating Views, Stored Procedures, and Functions.
Extracting data from Source and do the transformations using SSIS and load it into Destination.
Developing Visualization reports and Dashboards using Power BI
Used Page Level and Report Level Filters to create Visuals.
Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
Used Edit Interaction functionality to create Interaction between Visuals.
Creating pivot tables with Power Pivot
To document the business process by identifying the requirements.
Used Power Query and DAX Query functionality for derive calculated columns and Calculated Measures

software engineer

Religare Broking LTD
Jul 2017 - Jul 2019 · 2 years

Creating Views, Stored Procedures.
Developing Visualization reports and Dashboards using Power BI
Used Page Level and Report Level Filters to create Visuals.
Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
To document the business process by identifying the requirements.
Used Power Query and DAX Query functionality for derive calculated columns and Calculated Measures

Sr. Data engineer

Encore IT Services and Solutions PVT Ltd
Feb 2022

Expert in identifying the requirements and in finding the system requirements.
Extracting the data from Source using Linked Servers, Dynamic Queries in SQL Server, transforming the data using Stored Procedures, Functions and loading it into the Destination.
Expertise in monitoring the job failures and fixing the issues in SQL Server.
Developing Visualization reports and Dashboards using Power BI
Design and develop SSIS/SQL ETL to acquire and prepare data from source.
Build data transformations with SSIS.
Experience working with SSIS packages

Skills

Computer Science Structured Query Language (SQL) Data Scraping Quality Standard PL/SQL Data Analysis and Reporting SQL Server SSIS SSAS Tabular Model Power BI Power BI Desktop Power BI Service DAX Azure Databricks Linked Servers Dynamic Queries Stored Procedures Functions Views Indexes Azure Data Factory Tableau Excel Power Query Power Pivot Edit Query Quick Measure Row Level Security Workspaces Live Connection Import Data ETL Data Transformation Data Preparation Data Modeling Dashboard Development Report Development
Report this Profile?