About project- Support world leading bank from North America, in terms of providing data management and business intelligence reporting support for product portfolio monitoring and insight generation on a periodic reporting and visualization to the client support system (CSS)Applications: SAS, SQL, Qlikview and Qliksense, Tableue, Power Point and ExcelMethodology- Programming, Modelling, Designing and ReportingMaintain database management and DataMart design for regular reporting• Prepare data model design from source file Origination data to Account Management and Collection Strategy. • Connect data from DB2 (Transaction al data) to SAS using Unix platform and prepare period dataset and combine data into meaning full pattern for regular reporting. • Prepare DataMart for 1. Origination Data, 2. Account Performance Data 3. Collection strategy Data• Design data model to capture information mapped from Account Origination and booked account to account performance • Prepare delinquent, charged off account datasets on a periodic basis for collection strategy reportingAutomation and streamlining projects• Prepare regular reporting and automate the redundant reporting process in SAS Macro and Excel VBA