Yasawant Sahu

About Yasawant Sahu

Reporting Analyst with DBMS reporting, visualization and automation. Strong analytical skills with attention to details while performing data retrievals, transformation, preparation, manipulation and analysis. Ability to manage complex data from raw file to summary analysis using advanced queries in SQL, SAS, Alteryx and Python and designing KPI metrics to storytelling dashboard using advanced data visualization in Excel, Tableau and Power BI

Experience

1. Advisory Solution Advisor

   Deloitte

   May 2023 — Present · IN

   DBMS Programming, visualization and Automation• Executed overall data integration, cleansing, manipulation, aggregation, data model designing and process improvement for reporting and visualization within credit risk analytics platform from application (origination) facility file to decision file and account performance in SQL, VBA, SAS and Python• Streamlines excel base reporting to advanced data visualization applications like Tableau, Power BI and Qlik within more insightful and storytelling KPI dashboards. Overall business impact 30%-man hours reducedStrategy Building and Reporting• Identify risk association to account origination and performance analysis and prepare risk mitigation strategy over time• Develop portfolio level account performance tracking and prepare internal MI to help business take decisions and account management and collection strategy development• Develop Pre-delinquent behaviour analysis and work with model development team to track performance from pre-post delinquent behaviour and collection capacity planning• Prepare strategy to estimate collection recovery and pay rate optimization over various portfolios• Track delinquent accounts mapping to dialler metrics and performance over collection team

Education

• Kalam Institute of Technology (KIT), Berhampur

  Bachelor of Technology - BTech

  2015 — 2018