Manjunathan Gopi

Organization providing maintenance services from vendor to multiple customers. In order to collect accurate data and take appropriate decision regards the contract maintenance

Responsibilities:

• Established a conceptual design and sized up the Technology Options

• Produced flexible Data models on Azure SQL Datawarehouse databases to create Operational Datawarehouse Reporting Platform

• Involved in designing the strategy for extracting data from OLTP database and ingesting into Azure Data Lake Storage Layer

• Analysis and Design of CDC(Change Data Capture) Mechanisms in ETL jobs

• Designed and developed Data Ingestion Pipelines for Incremental load using Azure Data factory

• Developed Data Ingestion Pipelines to updated SCD Type2 Dimension and Fact tables

• Implemented Advanced Dataflow Activities to Pre-Process the source data

• Designing the Deployment Pipeline and Release Strategies to promote the code into higher environments

• Configuring Necessary Security Settings on Azure Cloud platform

Tech stack: Azure Data factory, Azure Data lake and Azure SQL

Network Rail UK provides a safe, reliable experience for the millions using Europe's fastest-growing railway each and every day. In this Project we developed application (Backend and Frontend) for Network Rail using Wonderware and Intouch OMI. Signals generated from sensors on the railway track are received and manipulated in wonderware backend scripts to generate alarms and notify operator about the same through the frontend application.

Responsibilites:

• Automated data ingestion and transformation processes using Microsoft Azure Data Services - Azure Data factory

• Loaded data in Azure SQL Warehouse using Azure Data Factory

• Developed stored procedures to implement incremental load for Slowly Changing Dimension (SCD’s) and for full load to Azure SQL Database and Data Warehouse.

Tech stack: Azure Data factory, Azure Data lake, Azure SQL

The application is a Retail Loan Management System. The BMW FS offers loans to dealers, brokers and lease to customers too, against BMW/non-BMW cars. The application is used by the BMW Employees and Dealers only.

Responsibilities :

• Proficient in SQL Server and T-SQL (DDL and DML) in constructing table.

•Good Knowledge in creating stored procedure, view and User Defined Functions.

• Advanced extensible reporting skils using SQL Server 2008 Reporting Service (SSRS).

• Designed and created report templates, bar graphs and pie charts based on the financial data.

Tech stack: MS SQL, SSRS