Experienced Developer over 13+ years of experience involved in end-to-end software development cycle right from Requirement Gathering, Design, Development, Maintenance, Migration, Integration, Testing based on Multi-Tier Architecture and Solution Delivery Support (SQL Server 2008, 2012, 2016, Azure SQL DB, Azure Data Factory, SSIS, SSRS, SSAS, Power BI) for multiple Clients. Responsible for Database Design, Development, Implementation, ETL, ELT, and Reporting in SQL Server 2012/2016 on-premise and Azure SQL databases.

Technical Skills

• SQL Server 2008/12/14/16
• Power BI
• MSBI - SSRS, SSIS & SSAS
• C#
• Azure SQL Database
• ADD
• Azure Data Factory

Project Name

SHELL NextGen Data Warehouse

Client

SHELL

Technology: Azure SQL data warehouse, Azure SQL database, Power BI, SSRS, Tabular Model, SQL server 2012, ADF

Brief

Shell Lube Analyst is Shell’s leading oil and equipment condition monitoring service. Shell Lube Analyst is an online global database that leverages Shell’s expertise in lubricants and lubrication.

The main objective of the project is to modernize the Shell Lube Analyst application with a solution that provides a portal/collaboration service as well as the supporting infrastructure to run it on Azure. 

◦ Define, align, and document the business requirement

◦ Migrate data from existing legacy system to Azure SQL database.

◦ Comparing the performance across the system.

◦ End to an End Data flow.

Team Size: 8

Role: Senior Data Engineer