Prepare data analysis and reporting from analytical DataMarts like Origination Data (Application tracking towards approval rate to booking rate), Account performance (presenting delinquent vs non-delinquent base), Account collection and recovery reporting (on DPD to CO for collection performance and capacity planning), Card usage and average balance in saving accounts to track business opportunity for customer acquisition strategy building • Prepare account origination report on vendor specific saving account opened towards accounts on MOB and the relationships with bank for loan portfolio association. Track the # loan application received to final approval and booking rate (%) • See the account performance by loan portfolios to track them into delinquent vs non-delinquent behaviours. Identify the account performance overs delinquent period like accounts cure rate vs improved and roll rate • Access customer transaction data to identify which debit and credit card consumes more transaction and revenue impact by overall revenue projection and track the usage at merchant and vendor base analysis • Analyze the performance of an individual or multiple card types and networks based on the volume. Gain a consolidated view of customer usage across all card rails. Forecast the expected transaction volumes and amounts of these channels and identify early trends that may be unexpected • Usage by merchant category analysis and reporting on credit and debit analytics allow to identify the top merchants based on the number of transactions and the value of the transactions. Analyze the spending habits, and align rewards programs based on where customers are shopping and what they are buying • In this process of reporting, design end to end process automation from SAS, Python Programing output to flat files and excel files and connecting excel to summary reports in excel dashboard and advanced data visualization applications like Tableau and Power BI for dashboard making and publishing to stakeholder