Devanshi Pandya Email & Phone Number

Brøndbyvester, Capital Region, DK

• Implemented an automated reporting system, reducing report generation time by 40%, eliminating manual processes, and significantly improving operational efficiency and accuracy.
• Generated comprehensive reports and visual presentations for stakeholders, effectively translating complex datasets and communicating monthly progress and key metrics using Tableau and Looker.
• Established the data and reporting infrastructure from the ground up using Tableau,SQL and Excel, providing real-time insights into product performance, marketing funnels, and business KPIs.
• Conducted A/B testing to optimize marketing strategies, which led to data-driven decisions that improved campaign performance.
• Utilized Agile project management methodologies, resulting in a 34% increase in project delivery speed and improved cross-functional collaboration.
• Developed and managed 15 dashboards and 35 ad hoc reports using business intelligence tools such as Tableau and Google Charts to streamline decision-making and problem-solving processes.

Basking Ridge, NJ, US

• Utilized SQL, TensorFlow, and Long Short-Term Memory (LSTM) networks to predict equipment replacement timelines with a Root Mean Square Error (RMSE) of 16, thereby reducing budget overruns.
• Developed a machine learning model using Python and Linear Regression to predict future sales, achieving an 85% accuracy by analyzing the impact of advertising costs across various media and creating insightful data.
• Implemented Site Project Management (SPM) protocols to seamlessly track and analyze project milestones, from initiation through close-out, across all U.S. locations.
• Designed and deployed Tableau dashboards for the FUZE application, integrating SQL data streams to improve infrastructure monitoring and decision-making, resulting in an 18% faster project delivery.
• Utilized R for advanced statistical modeling, performing hypothesis testing, regression analysis, and time series forecasting, ensuring data-driven project management strategies.
• Developed custom Excel and Power BI models for financial forecasting and project analysis, streamlining the reporting process and improving data transparency for stakeholders.

Los Angeles, CA, US

• Performed detailed data analysis using SQL to extract, clean, and manipulate large datasets, generating actionable insights to support key decision-making processes.
• Managed food inventory and order tracking from vendors, including US Foods and LA Produce, ensuring timely deliveries and maintaining accurate records for all USC dining halls and restaurants.
• Generated automated monthly revenue reports for accounting and senior leadership, providing insights into sales and ensuring compliance with royalty fee criteria by excluding ineligible items.
• Collaborated with cross-functional teams to streamline the tracking of orders, receipts, and payments, resulting in improved operational efficiency across dining services.
• Utilized SQL and advanced Excel to develop custom reporting tools that tracked key performance metrics, delivering actionable insights on food ordering patterns and optimizing procurement schedules.
• Built and monitored data pipelines to ensure accuracy and consistency in sales reports, which informed senior leadership decisions.

Basking Ridge, NJ, US

• Utilized Python, and SQL for data extraction, cleaning, and analysis, ensuring data accuracy and reliability.
• Improved the accuracy of churn prediction models by 18%, enabling targeted retention strategies and reducing customer attrition.
• Designed and executed A/B tests to evaluate the impact of new features, promotions, and service changes on customer behaviour and engagement.
• Leveraged clustering techniques such as K-means and DBSCAN to create actionable segments for targeted marketing campaigns.
• Presented complex data findings to non-technical stakeholders, translating technical results into actionable business insights.

• Leveraged SQL and Excel to extract, clean, and aggregate data, optimizing data processing workflows to improve analytical efficiency and accuracy across diverse datasets.
• Developed comprehensive reports and interactive dashboards in Power BI, effectively translating complex data into actionable insights for senior management, driving data-informed decision-making in marketing and sales.
• Conducted detailed analysis of customer data to identify key segments based on usage patterns, demographics, and geography, enabling precise targeting for marketing campaigns and personalized service offerings.
• Monitored and analyzed key performance indicators (KPIs) to evaluate the success of marketing and sales initiatives, providing insights on effectiveness and ROI to guide strategic optimizations.
• Identified and resolved inefficiencies in data workflows by implementing process improvements

Master Of Engineering - Meng, Ece

Bachelor Of Engineering - Be, Electronics And Communication