Understanding Business requirements for portfolio risk analytics using SQL, Tableau etc. 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 Requirement Understanding ï‚§ Understanding requirements from various teams/departments and suggesting analytical solution to different problem statements ï‚§ Coordinating across teams/departments for any follow ups and successful delivery handovers ï‚§ Defining TAT for requirements basis priority and nature of work
Business Reporting & MIS ï‚§ Monitors Data and Prepares MIS on daily/weekly/ monthly basis using SQL, Python etc. ï‚§ Preparing reports in Tableau and presenting to management ï‚§ Supports in Investor Presentation w.r.t reporting and analytics
Data Management and Analysis for Policy Review ï‚§ Analyzing data on various cuts to eliminate riskier segments and help policy team in developing policy for such segments ï‚§ 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 ï‚§ Support and train other team members within and across functions (Compliance, collection, ops, product, business) writ
Report Automation: Actively engaged in working towards automating reports in visualization toll Tableau etc. such as: ï‚§ Acquisition Monitoring for every partner ï‚§ Cohorts/ portfolio performance on monthly basis ï‚§ Delinquency Cuts Reports ï‚§ Partner Specific Reports ï‚§ Disbursal Reports ï‚§ Ad hoc Reports ï‚§ Automating Investor cuts Report for Compliance Department ï‚§ Attrition Metrics ï‚§ TTD Monitoring
Internal Audit ï‚§ Prepares Data and other pre-requisites RBI Audit ï‚§ Conducts Data Quality Checks, Process or Product Specific Checks and Data Validation from partner
Role Proficiencies:
Minimum Qualification required: < Graduate >
Must have hands on Tools: Tableau, SQL, Python and any BI Tool, Data Structure, Credit Risk Knowledge