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…
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 on creating Stored Procedures, Functions, Views, and Indexes in SQL Server and Azure Data Bricks. Having good experience in 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. Experience on Power BI (Desktop and Service) with different data sources such as SQL Server using Live Connection as well as Importing data, Excel Sources. Hands on experience in development using Power BI (Power BI Desktop, Service) Experience on gathering and translating end user requirements into effective & efficient dashboards. Experience in Data preparation in Enter Data and shaping data in Edit Query like add column, split column, pivot column, unpivot column, changing data type, and Merge queries and Append queries. Experience on understanding DAX Functions in Power BI and created calculated columns and measures using DAX. Expertise in monitoring the job failures and fixing the issues in SQL Server and Azure data factory. Good Knowledge on Tableau Reporting tool.
Experience
Associate Technical Leader
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
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
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
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
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