Pallawi Dosh

About Pallawi Dosh

At Finastra, my work in developing key analytical dashboards has significantly improved cash flow forecasting and billing processes, leading to substantial reductions in overdue balances and process delays. With a foundation in Computer Science from SHUATS, I leverage my expertise in data analysis and visualization to deliver actionable insights, driving a 25% reduction in Days Sales Outstanding for our stakeholders.My proficiencies lie in SQL, Tableau, and Excel, essential tools that have enabled our team to enhance metric tracking and response times. Our collaborative efforts have culminated in a 20% increase in customer retention and a notable boost in quarterly revenue, underscoring my commitment to driving business performance through data-driven strategies.

Experience

1. Analytics Analyst

   Finastra

   Oct 2023 — Present · Bengaluru, IN

   Developed an STP Dashboard for Cash and Collections, improving cash flow forecasting and prioritization of high-risk accounts,reducing overdue balances by 15% and accelerating collections by 10%.• Managed a 5-KPI dashboard for the billing team, enhancing metric tracking and TAT monitoring, which identified owners not meeting standards. This led to a 20% improvement in response times and a 15% reduction in process delays, streamlining billing cycles.• Developed a DSO (Days Sales Outstanding) Dashboard for the Cash and Collection Team, resulting in a 25% reduction in DSO and improved cash flow management for stakeholders.• Developed a Billing Cube Dashboard for the billing team, improving visibility into billing details by business unit and leading to a 30% reduction in discrepancies.• Developed a ServiceNow Dashboard for the Procurement team to track tickets by assignment group and resource allocation, improving ticket resolution efficiency by 25% and enabling better resource management for enhanced operational performance.• Developed a 24-month revenue report in Excel using Power Pivot and migrated it to a Power BI dashboard, improving data accessibility and reducing report generation time by 40%.• Maintained the Daily AR Aging and AR Collection report for the Cash and Collection team as part of BAU. Currently migrating the existing dashboard to Microsoft Fabric to leverage its capabilities, automate tasks, and reduce manual effort by 30%, enhancing overall efficiency.• Streamlined AR Status Dashboard and App for Enhanced Financial Operations, contributing to a 15% reduction in overdue accounts.

Education

• Sam Higginbottom University of Agriculture, Technology And Sciences (SHUATS)

  Bachelor of Technology - BTech

  2016 — 2020