PRIYANKA KUMARI PAUL

• Built a comprehensive analytics solution using SQL Server, Tableau, Tableau Prep, and SSRS to improve visibility into patient behavior, order lifecycle, regional performance, and operational efficiency.
• Segmented patient journeys into New, Repeat, and New-to-Therapy cohorts, enabling therapy teams to track onboarding success and monitor drop-off trends.
• Designed interactive dashboards in Tableau to visualize order lifecycle stages (Placed → Shipped → Delivered/Canceled), helping supply chain teams reduce late shipments by 17%.
• Conducted regional analysis of incoming orders and delivery performance, leading to a 22% reduction in customer complaints by addressing location-specific delays.
• Optimized and modernized legacy SSRS reports, aligning with evolving BI needs and reducing report generation time by 40%, resulting in faster and more accurate business decisions.
• Collaborated with cross-functional teams (supply chain, clinical, operations) to define KPIs and create actionable insights that supported data-driven strategies.

• Centralized 10+ siloed dashboards into a single, unified Tableau dashboard, increasing report transparency and consistency across 4 Strategic Business Groups (HBT, AERO, SPS, PMT).
• Reduced manual reconciliation and reporting confusion by 40% by standardizing calculations, filters, and visual formats, saving ~15 hours per week in manual effort.
• Cut root cause analysis turnaround time by 35% by enabling drill-down views for real-time identification of variance drivers and operational anomalies.
• Improved stakeholder confidence by 50%, based on internal survey feedback, by delivering accurate and consistent KPI tracking across functions and leadership tiers.
• Supported 20+ leadership stakeholders with faster, data-informed decisions by delivering a single source of truth that replaced fragmented reporting across regions and teams.
• Reduced dashboard maintenance time by 60% by optimizing Tableau data sources using Tableau Prep and SQL Server, improving dashboard load speed and reliability.

• Implemented customer segmentation models using Alteryx Designer to perform ETL on large datasets, loading cleansed data into SQL Server and Amazon Redshift, reducing data prep and processing time by 30%.
• Performed cohort analysis in Tableau to evaluate customer retention and churn behavior over time, helping identify critical drop-off periods and optimize re-engagement strategies.
• Conducted churn analysis using transactional and behavioral data in Amazon Redshift, identifying at-risk customer groups and enabling targeted retention efforts that led to a 15% reduction in churn.
• Developed product usage analytics in SQL Server and Redshift to track feature engagement and surface customer preferences, influencing product development and personalization tactics.
• Visualized key customer insights such as Customer Lifetime Value (CLV), retention curves, and usage behavior through interactive Tableau dashboards—supporting leadership with real-time, data-driven decision-making.
• Reduced manual reporting by 40% by delivering self-serve dashboards and automating performance insights, improving marketing and product alignment across teams.

Analyzed inventory data using SQL Server, identifying overstock and understock trends across product categories—leading to a12% reduction in holding costs and improved stock turnover rates.

• Performed financial data analysis by extracting and transforming data from multiple sources to identify revenue trends, cost anomalies, and growth opportunities—supporting quarterly forecasting and risk mitigation strategies.
• Built interactive supply chain dashboards in Tableau, enabling visibility into delivery timelines, warehouse utilization, and shipment flow—helping reduce delivery delays by 18% and optimize route efficiency.
• Developed executive-level visualizations in Tableau to present KPIs and cross-functional performance metrics, empowering business leaders with real-time insights for faster, data-driven decisions.
• Collaborated with operations and finance teams to align reporting on inventory movement, cost drivers, and supply chain risks, streamlining reporting cycles and reducing manual reconciliation effort by 30%.

• Led market research using Excel, uncovering trends that boosted campaign targeting efficiency by 20%.
• Imported and transformed large datasets in SQL Server, improving data accessibility and reducing prep time by 30%.
• Wrote advanced SQL queries with JOINs, filters, and stored procedures, increasing reporting accuracy by 25%.
• Identified key business metrics and delivered actionable insights, helping stakeholders make faster decisions and drive 15% growth in key segments.

• Built sales forecasting models using Excel and SQL, improving quarterly revenue prediction accuracy by 25%.
• Analyzed customer behavior and churn patterns for subscription products using SQL and Tableau, enabling proactive retention strategies.
• Increased customer retention by 20% by implementing data-driven targeting based on behavioral insights and lifetime value analysis.
• Calculated Customer Lifetime Value (CLV) metrics to prioritize high-value segments and inform marketing and product strategy.