Sanjay Kumar Panda Email & Phone Number

Bengaluru, Karnataka, India

Work on collection and recovery analysis projects to optimize the institution's debt collection processes. Proficiency in various software tools, such as SAS, Excel, SQL, Python, Power BI, and Tableau for performing these tasks effectively. Analyze portfolio data to assess the performance of credit card products and programs. Evaluate key performance indicators (KPIs) such as acquisition rates, retention rates, and profitability.  Track KPIs such as transaction success rates, payment processing time, and customer satisfaction metrics. Analyze collection strategies, recovery rates, and delinquency patterns to optimize debt collection processes. Identify opportunities for improvement and recommend strategies to minimize credit losses Using SAS and SQL programming, create process improvement automation tasks for sourcing data from Database Server into analytical Datamart’s. Conduct ad-hoc analyses to investigate performance issues or anomalies.

Bhubaneswar, Odisha, India

• Developed loan origination dashboards using Power BI to monitor and analyze KPIs for commercial business loan applications, improving process efficiency and data-driven decision-making for the origination team.• Curate Credit Risk Master files, including Origination Master, Performance Master, Customer Master, and Bureau Master files. Integrate and structure data models for daily MIS reports and ad- hoc analyses in support of decision-making processes.• Using SQL, Python and Power BI to analyze and tracked KPIs like loan application volume, approval rate, and time-to-decision to assess demand, underwriting efficiency, and process effectiveness.• Calculated and visualized loan conversion rates to identify successful application-to-funding transitions.• Tracked origination costs and operational efficiency to pinpoint cost-saving opportunities and streamline processes.• Designed interactive Power BI dashboards that display real-time insights on loan origination metrics, enabling management to make informed lending decisions.• Transform Excel-based reporting into advanced data visualization applications like Power BI, creating insightful and storytelling KPI dashboards. Achieve a 30% reduction in man-hours, positively impacting overall business efficiency.

Ernakulam, Kerala, India

• Key responsibilities involve in leveraging various tools like SQL, Power BI, Tableau and Excel to gather and manipulate data extracted from customer sells record. This data is then used to craft comprehensive acquisition and product analysis reports on a regular basis, ranging from weekly to monthly.• Utilize SQL, Power BI, Tableau and Excel for analytical modelling in the retail industry. Creating reports and interactive dashboard using Power BI or Tableau for our clients for them to understand customer experience, and creating targeted campaigns. This aims to recognize customer needs and offer the most relevant products and services, ultimately increasing ROI while ensuring customer satisfaction.