Developed design patterns for ingesting data into the data lake from disparate sources and standardized it to provide benchmarking and comparison capabilities at enterprise level. Implemented Lakehouse Architecture in Azure data lake Gen2 storage. Expert in building Data Bricks notebooks, extracting the data from various source systems and perform data cleansing, data wrangling, ETL processing and loading to Data Lake.

Analyzing the compatibility and feasibility of data to be migrated to Azure. Data Validation between EIP SQL Server data and migrated Azure Data Lake Store data. Managing data migration from on-premises SQL to Azure Data Lake using Azure Data Factory.

Design database objects for on premises DB(OLTP) and analyze the movement of data and design efficient database objects for (OLAP) Azure Cloud Datawarehouse and DataMarts structures. Create pipelines for moving data from Staging to Azure Cloud databases.

Auto DW BIX: Data center migration project is to migrate the database from on premises to Azure SQL, without having any business impacts. This project work is being worked on for the LOB (Line of business) consumer lending dealer services, automobile loan division.

Hogan Integration: The Auto data warehouse shall retain and store EIWP (Enterprise Information Warehouse Production Database) data, so that all data received/accessed can be used to develop new reports needed to enable and monitor the Hogan Integration efforts and for manual review/update by the business.

Hogan Notifications: Auto DW receive updates from Hogan for changes to ECNs and Phone Consent are sent and processed to AFS as part of nightly batch processing.

SRS Value Stream: As part of this project, we are providing a semantic layer to the business to develop reports on top of it

Nexsure is a comprehensive and intuitive web-architected agency management solution. Nexsure offers the sophisticated features and functions that insurance professionals have not found in traditional management system offerings. These advanced features translate into a more efficient agency workflow and a superior service experience for their clients.Nexsure provides reporting options crystal reports and SSRS reports for Business users which help in taking critical decisions.

Auto DW BIX Data center migration project to migrate the database from on premises to Azure SQL without having any business impacts. Hogan Integration for storing EIWP data. SRS Value Stream to provide a semantic layer for business reporting.

Design and implement effective database solutions and models to store and retrieve company data. Examine and identify database structural necessities by evaluating client operations, applications, and programming.

BMX deals with rationalize the process and tools by which revenue forecasts are determined across the Enterprise and Partner Group (EPG), Small and Midmarket Solutions and Partners Group (SMS&P), and Services of Microsoft. EBMS includes financial vs. budget metrics to analyze the business growth. EBMS Reports are being used by corporate business owners and across globe.

This Project is involved in creating a data model and the schema for the new warehouse system and creates the Warehouse from different Source systems and populates the data from those sources using SSIS. Writing stored procedures to get the data for different reporting needs. Creating Reports using Excel Services and SSRS and get the data from stored procedures.

The Scorecard developed is the key for Microsoft Enterprise Sales team business and monitored by around 3500 field managers round the globe and is presented by Microsoft’s’ Chief Operating Officer Kevin Turner during MYR (Mid-Year Reviews)..

This Project involves in creation of Enterprise Scorecards which helps the Microsoft Sales excellence business groups which is the central infrastructure to drive accountability and assess the health of the enterprise business. The EAF system will effectively identify and monitor the key goal metrics and the key performance indicators that help for changing strategies and making decisions by higher management within Enterprise Group (EPG). The Scorecard developed is the key for Microsoft Enterprise Sales team business and monitored by around 3500 field managers round the globe and is presented by Microsoft’s’ Chief Operating Officer Kevin Turner during MYR (Mid-Year Reviews).

Business Rule Engine: This tool was developed to capture the technical and feed specification through ASP.Net Rad controls UI and populate the data into SQL SERVER database (backend) instead of maintaining huge number of Word documents which were created manually by the Business Analyst. The information stored in the backend would be exposed to Metric/Feed Owners through SSRS reports they can view the specifications and provide sign-off or else can request for any changes to the specifications. The change requests would also be captured by the tool and their history is also maintained which would also be shown in the SSRS reports. Metric/Feed Owners can also export the SSRS reports into Word or PDF to view the

Conducted Gap Analysis to get Business Requirements, built BI Solution for the Application. Developing SSIS packages according to the ETL specifications for the staging area and warehouse data loading using SQL Server Integration Services and SQL Server 2008R2.