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.

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