Prathamesh Kakade

• Analyzed financial transaction datasets across multiple payment processors (20M+ records/month), implementing automated data validation frameworks that reduced reporting discrepancies by 20% and strengthened compliance reporting. • Built SQL- and Python-based forecasting models in Snowflake to predict transaction volumes and cash flow patterns with >90% accuracy; enabled proactive infrastructure scaling and improved financial risk management. • Partnered with finance, compliance, and marketing teams to standardize KPIs and derived metrics (approval rates, chargeback ratios, lifetime value), reducing reporting turnaround by 30% and improving audit transparency. • Designed Power BI executive dashboards tracking revenue trends, customer acquisition costs, and profitability metrics; presented insights weekly to leadership, directly influencing budgeting and strategic allocation. • Developed attribution models to evaluate campaign ROI and customer lifetime value, providing data-driven recommendations that optimized acquisition spend and improved lead quality.

• Collected and analyzed circulation and digital usage data across 200 thousand items; identified high-demand resources, reduced shortages by 12%, and streamlined allocation across multiple library branches. • Designed Power Query models to automate resource tracking, improving demand forecasting accuracy and enabling proactive restocking decisions. • Assisted over 1,000 patrons daily, combining customer service with data-driven insights, optimizing user satisfaction. • Coordinated with a 5-member team to design, plan, and execute weekly student programs, improving engagement scores and fostering a collaborative library environment.

• Built end-to-end Power BI dashboards and SQL reports for multinational clients, optimizing joins, subqueries, and blending pipelines across 10M rows of customer data; reduced manual reporting by 30%. • Designed Power BI dashboards and SQL pipelines across 10M+ rows of multinational client financial and marketing data, improving KPI accuracy by 15% and directly supporting client retention decisions. • Conducted financial data quality audits to reconcile discrepancies across currencies, identifiers, and corporate actions; improved accuracy of client-facing reports by 25%. • Partnered with stakeholders to redefine reporting structures and valuation metrics, enabling executives to monitor profitability, revenue attribution, and cost optimization in near real time. • Delivered client-ready data visualizations highlighting market performance, ROI, and revenue drivers, supporting strategic portfolio optimization decisions.

• Developed Power BI dashboards for warehouse KPIs (inventory utilization, lead times, order fulfilment rates) covering more than 50,000 monthly transactions; reduced order delays by 10% through proactive insights. • Conducted demand forecasting models using 6 years of sales history; improved purchasing and stock planning strategies, reducing overstock and stockouts. • Automated ETL workflows by integrating datasets from PostgreSQL, SQL, and Python; reduced data processing cycles by 20% and improved accuracy of reporting pipelines.