DBMS Programming and automation Manage data from various source file and prepare relational data base model to keep track of history data to the current file Design data model to get insightful information by applying manipulation techniques through expression and actions Access multiple source files for daily loan applications, customer and bureau information’s to facilitate data model and analytical insights on risk segmentation analysis for credit departments of investment… Show more DBMS Programming and automation Manage data from various source file and prepare relational data base model to keep track of history data to the current file Design data model to get insightful information by applying manipulation techniques through expression and actions Access multiple source files for daily loan applications, customer and bureau information’s to facilitate data model and analytical insights on risk segmentation analysis for credit departments of investment companies, commercial and investment banking, credit card lenders, credit rating agencies, and other financial institutionsReporting and visualization Analyze portfolio performance at a granular segment level on an ongoing basis. Identify trends and conduct root-cause analysis to isolate key performance drivers. Communicate findings and recommendations to the Risk Management and broader Line community Prepare BAU reporting based on account origination to performance to collections and MIS to be sent daily, weekly and monthly reporting structure Prepare MIS on Portfolio performance over default vs non-default and default account movement from account receivable/account payable by each delinquency buckets. Prepare strategic regular reporting on loan portfolios balance control ratio to map the collection strategy and capacity planning Automate the reporting process by migrating to advanced data visualization tool like Tableau  Managed to migrate 80% of excel base reporting to TableauStrategy Building and Reporting Develop portfolio lever customer insights to strategize the risk factors for both secured and un-secured portfolios like customer existing relationships, customer across portfolio performance, customer total relationship balance, customer employment history to bureau updates. Align portfolios into economic scenarios  Develop strategy for avoid delinquency and increase profile base default collection capacity planning Develop credit strategies Show less

DBMS Programming and automation Manage data from various source file and prepare relational data base model to keep track of history data to the current file Design data model to get insightful information by applying manipulation techniques through expression and actions Access multiple source files for daily loan applications, customer and bureau information’s to facilitate data model and analytical insights on risk segmentation analysis for credit departments of investment… Show more DBMS Programming and automation Manage data from various source file and prepare relational data base model to keep track of history data to the current file Design data model to get insightful information by applying manipulation techniques through expression and actions Access multiple source files for daily loan applications, customer and bureau information’s to facilitate data model and analytical insights on risk segmentation analysis for credit departments of investment companies, commercial and investment banking, credit card lenders, credit rating agencies, and other financial institutionsReporting and visualization Analyze portfolio performance at a granular segment level on an ongoing basis. Identify trends and conduct root-cause analysis to isolate key performance drivers. Communicate findings and recommendations to the Risk Management and broader Line community Prepare BAU reporting based on account origination to performance to collections and MIS to be sent daily, weekly and monthly reporting structure Prepare MIS on Portfolio performance over default vs non-default and default account movement from account receivable/account payable by each delinquency buckets. Prepare strategic regular reporting on loan portfolios balance control ratio to map the collection strategy and capacity planning Automate the reporting process by migrating to advanced data visualization tool like Tableau  Managed to migrate 80% of excel base reporting to TableauStrategy Building and Reporting Develop portfolio lever customer insights to strategize the risk factors for both secured and un-secured portfolios like customer existing relationships, customer across portfolio performance, customer total relationship balance, customer employment history to bureau updates. Align portfolios into economic scenarios  Develop strategy for avoid delinquency and increase profile base default collection capacity planning Develop credit strategies Show less