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