Portfolio Performance Dashboard
→
Summary
Developed a comprehensive Power BI dashboard to provide real-time visualization of critical portfolio health metrics.
Highly analytical Finance-focused Data Analyst with over a year of experience specializing in portfolio analytics, MIS reporting, and compliance tracking within the banking sector. Expertly transforms complex financial data into actionable business insights using Advanced Excel (VBA, Macros), Power BI, and Python (Pandas, Numpy, Matplotlib). Proven ability to automate reporting, streamline processes, and develop impactful dashboards that drive strategic decision-making and enhance operational efficiency for credit and operations teams.
Portfolio Analyst
Gurugram, Haryana, India
→
Summary
As a Portfolio Analyst at IndusInd Bank, Rishikesh Raj manages nationwide deferral tracking, penal charge reporting, and audit support, transforming raw financial data into actionable business insights.
Highlights
Developed and deployed weekly and monthly MIS and deferral reports, providing critical insights into overdue loan trends and overall portfolio risk for enhanced financial oversight.
Automated key reporting processes, including UVR, stock statements, and compliance reports, leveraging Excel dashboards and Power BI to significantly improve data accuracy and reporting efficiency.
Spearheaded the coordination of penal charge data collection and follow-ups, directly contributing to the recovery of over ₹26.9 lakh and strengthening financial compliance.
Collaborated cross-functionally with credit, sales, and product teams to ensure the timely submission of UFCE certificates and external ratings, optimizing compliance workflows.
Managed and ensured the timely closure of audit pendencies across diverse financial lines, including insurance, valuation, and ABS, maintaining robust compliance standards.
Operations Representative
Gurugram, Haryana, India
→
Summary
As an Operations Representative at Concentrix Daksh Services India Pvt. Ltd., Rishikesh Raj processed medical and pharmacy claims, optimized reporting, and resolved discrepancies to ensure compliance and efficiency.
Highlights
Processed a high volume of medical and pharmacy claims with meticulous accuracy, ensuring strict adherence to documentation compliance and regulatory standards.
Automated daily reporting procedures using advanced Excel templates, which boosted task efficiency by 25% and streamlined operational workflows.
Developed and generated operational reports to monitor Turnaround Time (TAT), leading to a 30% improvement in claims resolution rates.
Effectively liaised with medical and insurance representatives to swiftly resolve discrepancies, ensuring the integrity and accuracy of critical patient records.
→
Master of Science
Applied Physics
→
Bachelor of Science (Hons.)
Physics
Issued By
Udemy
Issued By
Udemy
Issued By
Udemy
Issued By
Udemy
Issued By
Coursera
Issued By
Coursera
Issued By
Coursera
Advanced Excel (PivotTables, VBA, Macros), Power BI (Dashboard Creation, DAX, Visualizations), Python (Pandas, Numpy, Matplotlib), Data Automation, Data Storytelling, MIS Reporting, Trend Analysis, Segmentation Analysis.
Portfolio Monitoring, Penal Charge Management, Compliance Reporting, Audit Coordination, Financial Data Transformation, Risk Management, Loan Health Analysis.
Analytical Thinking, Problem Solving, Strategic Insights, Decision Support, Process Improvement.
Communication, Collaboration, Attention to Detail, Stakeholder Management.
→
Summary
Developed a comprehensive Power BI dashboard to provide real-time visualization of critical portfolio health metrics.
→
Summary
Conducted in-depth credit risk analysis using Python to identify and visualize key deferral patterns and risk triggers.
→
Summary
Performed a comparative analysis of loan behavior before and after the COVID-19 pandemic using advanced analytical tools.
→
Summary
Executed segmentation analysis on Netflix and Udemy datasets to derive strategic insights into user behavior and preferences.