Standard chartered Bank is one of the leading global health banking offering wide range of services in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc., The project was to provide data into EDM and to third party vendor (Success Factor) based on data provided in to EDM. I was responsible for analyzing data source to target as per the business rules and also applying the transformation logic and validate the data in the testing environment.