• Executed overall data integration, cleansing, manipulation, aggregation, data model designing and process improvement for reporting and visualization within credit risk analytics platform from application (origination) facility file to decision file and account performance in SQL, VBA, SAS and Python• Streamlines excel base reporting to advanced data visualization applications like Tableau and Power BI within more insightful and storytelling KPI dashboards. Overall business impact 30%-man hours reduction• Develop master files for regular reporting and ad-hoc analysis support from sourcing data and designing complex relational data model for Origination Master, Performance Master, Collection Master and Recovery Master• Prepare various analysis from default base vs non-default, default by delinquency buckets (#, $), Roll rate analysis, annualized loss rate analysis and prepare MIS on BCR and performance tracking dashboard• Develop ad-hocs supports on credit risk assessment to the stakeholders over time and automate the reporting process• Analyse requests from management to determine the credit risk analysis of the assigned portfolio and prepare reports with findings to help the management making decisions on lending and creditworthiness • Develop complex data model designing in SQL & SAS for connecting customer analytics support through the journey from origination to current usage analysis• Segment customer based on usage and revenue to track their performance over time. timely trigger the behaviour and work on customer retention strategy for Credit Card Portfolio