Assisting in end-to-end portfolio risk analytics (starting from data extraction to analytics & reporting), Automation & monitoring of reports; supports in calculating the Business portfolio for any department in the company and requirements as per business.
Business Reporting & MIS ï‚§ Monitors Data and Prepares MIS on daily/weekly/ monthly basis. ï‚§ Support in Investor Presentation w.r.t reporting and analytics.
Data Management and Analysis for Policy Review ï‚§ Conducts data extraction for minimizing Bounce Rate, Loss management, policy review, product changes, third party services. ï‚§ Writes and updates the SQL/Python codes according to business requirements. ï‚§ Perform data analysis to create reports that generate insights, extract riskier segments (partner specific) for Policy review. ï‚§ Prepares Deck and Month End tables on Tableau.
Report Automation: Actively engaged in working towards automating reports such as: ï‚§ Monthly TTD population analysis (Acquisition Monitoring for every partner) ï‚§ Automate tracking of Cohorts/portfolio performance on monthly basis ï‚§ Publishing delinquency Cuts Reports ï‚§ Publishing partner Specific Reports ï‚§ Cater ad hoc data requests from other team members and other functions. ï‚§ Investor cuts Report for Compliance Department
Automatic Framework for Third Party Service Analysis ï‚§ Creation of framework for analysis of value addition from various third-party services ï‚§ Prepare and present analysis on regular intervals (monthly/quarterly
Role Proficiencies:
Must have hands on Tools: SQL, Python and Tableau or any other BI Tool, Data Structure
Good to have: Credit Risk Knowledge, Domain Knowledge, statistics concepts, PL/SQL, AWS Athena, Decision Tree or other decision-Making Tool