ishan Raj choudhury

SAS Team LeadFull Time

• Job Details:The scope of the project is to make Abu Dhabi Commercial Bank (ADBC ) make IFRS9 compliant before 01.01.2018 (mandatory date set by IASB). As part of the project, my responsibility are Design Datawarehouse: · Gather all data requirements from interaction with members of Credit Risk , Finance and E&Y · Design data Silos along with custom built Excel Import Utility for manual uploads by Credit Risk team · Design the entire Datawarehouse and data flow processes as per Bank’s standards and get it approved by the Architecture Review Board Develop ETL · Design and develop ETLs as Oracle procedure and provide the scripts to developers who in-turn creates SAP BO based ETL’s as per Bank’s standard · Identify test case scenarios with inputs from business · Create test cases for ETL testing and get it executed before moving ahead with UAT testing Hardware Infrastructure Setup · Comprehend the Hardware sizing requirements from SAS · Co-ordinate with the hardware procuring team and server team in setting up the Servers for the project · Verify the server setup along with SAS before SAS installation · Installation of all SAS servers and other components including SAS Metadata Server, Hadoop file system and SAS Visual Analytics Server User Management · Identify different type of user in Finance and Credit Risk Department, IT-Administration and IT-Helpdesk · Create User Roles and User Groups in SAS Management Console · Streamline SAS Management Console to read details from Microsoft Active directory and automatically assign access to users and define role for basic SAS Tools and solutions Develop Reports · Generate standard and ADHOC reports for Credit Risk Team by : • Transform the data from SAS files and amalgamating it with data from other reporting systems • Create reports in accordance with the requirements set up by business

Senior Software EngineerFull Time

• Job Details: Set up project architecture while creating value added BI solutions by :- -Analyzing requirements and finding different approaches to get the reporting solution. -Identify the steps to get the solution and document into design documents. -Development of efficient codes in SAS Base, SAS Macro, SAS SQL using SAS EG and SAS DI tools. -Develop SSAS cube and dynamic reports using SSRS tool -Reviewing codes for Business logic implemented -Creating Test cases for the solutions -Resolve basic programming defects and errors during functional testing. -Interact with Danish counterparts to manage the scope of the projects to meet the project deadlines. Working as a SAS Programmer. Responsible for Complete development using SAS tools Understanding the business requirements and define the logic Analysis, design and development of codes using SAS. On time delivery of reports.