This project is about working on the enhancements and maintainence of the EDW application. As a developer need to perform the SCD mappings and provide L3 support and fix for the daily production run

Worked as prod support lead for L2 activites and managed the team of 7 members. As a lead need to take care the overall job monitor activities and intimate to developer team about the issues with initial level analysis and make sure the Jobs are completed with in the SLA time with the company

In this project we need to decomission the unwanted jobs as the application was about to be decommisioned. We need to identify the CTRL-m jobs which are specific to that application and do the impact analysis for the downstream applications.

Self-service strategy deals with creation of new tables and loading existing tables that are required for Professional Financial advisors to make better solutions which will in turn help business to grow. Added advantage is that, Interdependencies to establish better solutions is reduced through self-service strategy. Ultimate aim for this project is that all users will be acting as a business user (IT) down the line