Dhruvi Jhaveri

Partnered with Collections, Credit Risk, Bankruptcy, Lease Termination, Repossession, and Servicing Operations teams to translate business requirements into scalable reporting, analytics, and KPI solutions supporting auto loan and lease portfolio management, delinquency reduction, and risk mitigation strategies
Developed and optimized SQL-based reporting and BI solutions using SAS, Cognos, Excel (Pivot Tables, Power Query), Access, Power BI, and Tableau
Delivered automated dashboards, forecasting models, and portfolio analytics covering delinquency roll rates, bankruptcy exposure, repossession pipelines, termination activity, and recovery performance
Built forecasting models and interactive dashboards to support risk forecasting, delinquency trend analysis, charge-off projections, and proactive collections strategy across multiple servicing verticals
Improved data integrity, reconciliation accuracy, and reporting reliability by 30%+ through data validation, data mart testing, and cross-system reconciliation across servicing platforms and Genesys Cloud (dialer) environments
Automated recurring reporting, dashboards, and KPI tracking using SQL, SAS, Python, Excel (Pivot Tables, Power Query, macros), reducing manual effort and enabling near real-time visibility into portfolio performance and operational metrics
Delivered Power BI and Tableau dashboards for call center and servicing operations, improving visibility into agent performance, dialer efficiency, right-party contact rates, and contributing to an increase in productivity and customer engagement outcomes
Applied portfolio analytics and Auriemma benchmarking insights to optimize segmentation strategies, improve delinquency roll rates, enhance bankruptcy resolution workflows, and strengthen repossession and recovery performance aligned with industry best practices

Partnered with Collections, Credit Risk, Bankruptcy, Lease Termination, Repossession, and Servicing Operations teams to translate business requirements into scalable reporting, analytics, and KPI solutions supporting auto loan and lease portfolio management, delinquency reduction, and risk mitigation strategies, Developed and optimized SQL-based reporting and BI solutions using SAS, Cognos, Excel (Pivot Tables, Power Query), Access, Power BI, and Tableau; delivered automated dashboards, forecasting models, and portfolio analytics covering delinquency roll rates, bankruptcy exposure, repossession pipelines, termination activity, and recovery performance, Built forecasting models and interactive dashboards to support risk forecasting, delinquency trend analysis, charge-off projections, and proactive collections strategy across multiple servicing verticals, Improved data integrity, reconciliation accuracy, and reporting reliability by 30%+ through data validation, data mart testing, and cross-system reconciliation across servicing platforms and Genesys Cloud (dialer) environments, Automated recurring reporting, dashboards, and KPI tracking using SQL, SAS, Python, Excel (Pivot Tables, Power Query, macros), reducing manual effort and enabling near real-time visibility into portfolio performance and operational metrics, Delivered Power BI and Tableau dashboards for call center and servicing operations, improving visibility into agent performance, dialer efficiency, right-party contact rates, and contributing to an increase in productivity and customer engagement outcomes, Applied portfolio analytics and Auriemma benchmarking insights to optimize segmentation strategies, improve delinquency roll rates, enhance bankruptcy resolution workflows, and strengthen repossession and recovery performance aligned with industry best practices.

Analyzed and managed datasets across PowerSchool and Frontline systems supporting 10,000+ students and 1,500+ staff, enabling data-driven decisions
Developed 40+ SQL queries and 20+ reports to support state reporting, compliance, and leadership dashboards
Performed data migration, cleansing, and validation of 100,000+ records, improving data accuracy and consistency
Conducted exploratory data analysis on attendance, enrollment, performance, and HR data to identify trends and support planning
Supported testing and validation for 20+ system upgrades and releases, ensuring data integrity and zero critical reporting issues
Built HR and operational analytics (absence trends, staffing metrics), improving workforce planning and reporting efficiency
Delivered reporting solutions and trained 300+ users, increasing adoption and reducing ad hoc reporting requests
Documented data definitions, reporting logic, and workflows to support data governance and consistency across systems

Analyzed and managed datasets across PowerSchool and Frontline systems supporting 10,000+ students and 1,500+ staff, enabling data-driven decisions, Developed 40+ SQL queries and 20+ reports to support state reporting, compliance, and leadership dashboards, Performed data migration, cleansing, and validation of 100,000+ records, improving data accuracy and consistency, Conducted exploratory data analysis on attendance, enrollment, performance, and HR data to identify trends and support planning, Supported testing and validation for 20+ system upgrades and releases, ensuring data integrity and zero critical reporting issues, Built HR and operational analytics (absence trends, staffing metrics), improving workforce planning and reporting efficiency, Delivered reporting solutions and trained 300+ users, increasing adoption and reducing ad hoc reporting requests, Documented data definitions, reporting logic, and workflows to support data governance and consistency across systems

Assisted with SQL-based analysis of sales, partner performance, and revenue trends for IP cameras, IP phones, and networking products using AWS services (S3, RDS, Athena, Redshift) to support reporting and business decision-making
Built and maintained basic BI dashboards (Power BI/Tableau/QuickSight) using AWS-hosted datasets to track KPIs such as sales performance, partner activity, pipeline status, and inventory movement
Supported data extraction and simple ETL tasks using AWS EC2 and Lambda to move and prepare data from ERP/CRM systems into S3 and Redshift for reporting
Worked with sales and operations teams to gather requirements and translate them into basic reporting views, dashboards, and SQL queries
Performed basic segmentation of customers and partners (VARs, distributors, integrators) using SQL on Athena and Redshift to support pricing and sales strategy discussions
Helped identify operational gaps in order processing and inventory tracking by analyzing data in RDS and Redshift, contributing to process improvement recommendations
Assisted in UAT testing for ERP and AWS-based reporting systems by running SQL queries on Athena/RDS to validate data accuracy and resolve reporting issues
Prepared simple reports and dashboard summaries for management using AWS-backed data sources (S3, Redshift, Athena) to support weekly and monthly business reviews

Assisted with SQL-based analysis of sales, partner performance, and revenue trends for IP cameras, IP phones, and networking products using AWS services (S3, RDS, Athena, Redshift) to support reporting and business decision-making, Built and maintained basic BI dashboards (Power BI/Tableau/QuickSight) using AWS-hosted datasets to track KPIs such as sales performance, partner activity, pipeline status, and inventory movement, Supported data extraction and simple ETL tasks using AWS EC2 and Lambda to move and prepare data from ERP/CRM systems into S3 and Redshift for reporting, Worked with sales and operations teams to gather requirements and translate them into basic reporting views, dashboards, and SQL queries, Performed basic segmentation of customers and partners (VARs, distributors, integrators) using SQL on Athena and Redshift to support pricing and sales strategy discussions, Helped identify operational gaps in order processing and inventory tracking by analyzing data in RDS and Redshift, contributing to process improvement recommendations, Assisted in UAT testing for ERP and AWS-based reporting systems by running SQL queries on Athena/RDS to validate data accuracy and resolve reporting issues, Prepared simple reports and dashboard summaries for management using AWS-backed data sources (S3, Redshift, Athena) to support weekly and monthly business reviews