 Design and automate data sourcing from the database server to analytical DataMart’s using SAS, SQL, and Python programming  Streamline excel-based reporting to advanced data visualization tools like Power BI  Prepare automated reporting and performance tracking for 70% of regular work, with support for 20-30% in Ad-Hoc Analysis and Streamlining projects using Excel reporting, Tableau, and Power BI  Utilize Excel, SQL, SAS, Power BI for comprehensive loan portfolio… Show more  Design and automate data sourcing from the database server to analytical DataMart’s using SAS, SQL, and Python programming  Streamline excel-based reporting to advanced data visualization tools like Power BI  Prepare automated reporting and performance tracking for 70% of regular work, with support for 20-30% in Ad-Hoc Analysis and Streamlining projects using Excel reporting, Tableau, and Power BI  Utilize Excel, SQL, SAS, Power BI for comprehensive loan portfolio analysis.  Develop and maintain automated processes in Excel, SQL, SAS to extract, transform, and load loan data from multiple sources  Use SQL queries to retrieve loan data from databases, perform aggregations, filtering, and complex calculations  Create interactive dashboards and reports in Power BI and Excel to visualize loan portfolio performance metrics, trends, and key risk indicators  Analyze loan portfolio composition, including loan types, customer segments, geographic distributions, and industry exposures  Conduct credit risk analysis by assessing creditworthiness, credit ratings, and credit migration within the loan portfolio  Monitor loan delinquency rates, default rates, and prepayment rates to identify potential risks and make informed decisions  Perform scenario analysis and stress testing on the loan portfolio to evaluate its resilience under adverse economic conditions  Develop and implement portfolio optimization strategies to maximize returns while minimizing risks. Show less