Prachi Patel Email and Phone Number

Driving analytics efforts for AI powered digital marketing solution that personalizes cold call outreach and SMS outreach at scaleReduced variable product cost by 20% by collaborating with business development team on implementing cost-effective methods for producing personalized audio files, all while maintaining the product quality and effectivenessOptimized product pricing strategy by performing in-depth analysis of over 500 companies’ pricing plans across different market segmentsImplemented a product health tracking dashboard using Tableau to monitor usage and quality of the product across different clients and marketsContributing to the development of AI-driven solutions that transformed how customers communicate and collaborate, enhancing overall customer satisfaction and engagement.

Extracted data from multiple sources using Python and created centralized data warehouse in BigQuery to analyze the call summary dataBuilt automated workflow to derive specific topics discussed over sales calls using BigQuery (SQL)Gained 26% improvement in sales call success rate by ranking most relevant discussion topics using Random Forest ClassifierGenerated actionable insights for sales teams by performing sentiment analysis on sales call transcripts using Pandas, Skit-learn and NLTK libraries in PythonEffectively Communicated the insights and recommendations to the sales team by developing dashboards with KPIs and metrics in Tableau

Built data pipelines using SQL to store construction contracts data into a data warehouse for streamlined analysis and reporting.Improved the data quality by eliminating error prone manual process with data automation and data tuning increasing team’s efficiencyCreated insightful Tableau visualizations to provide senior management with a clear overview of project expenditure and progress, enabling data-driven decisions aligned with KPIs and metrics.Developed automatic anomaly detection using python to capture design errors which helps take proactive safety measuresDesigned a methodology to increase profitability of various projects using SQL by identifying areas for cost reduction (e.g. Identifying profitable subcontractors, comparing materials cost across vendors)Conducted multiple ad hoc analysis to answer data-driven business questions from key stakeholders using Excel (Pivot, Lookup etc)