Data Science Management

Vidhi Kamal Piplani

************@*****.*** +1-857-***-**** Boston, MA www.linkedin.com/in/vidhikamalpiplani EDUCATION

Bentley University, McCallum Graduate School of Business Waltham, MA Sep 2023 - May 2025 Master of Science in Business Analytics

Coursework: Data Management & SQL, Investments, Optimization & Stimulation for Business Decisions, Data Science, Quantitative Analysis for Business, Time series Analysis, Intermediate Statistical Modelling for Business, Data Mining University of Mumbai Mumbai, India Jun 2020 - May 2022 Master of Commerce (Accounting)

University of Mumbai, Thakur College of Science & Commerce Mumbai, India Jun 2017 - May 2020 Bachelor of Commerce (Accounting and Finance)

SKILLS

Programming Language: R, Python, SQL, VBA, C++, HTML Data Analysis & Visualization: Power BI, Tableau, Google Analytics, Excel, Google Sheets, Analytical Solver, Visio Business Intelligance & Productivity: Microsoft Dynamics NAV, Noosh, Ariba, Smartsheet, ClickUp, Slate, Qualtrics, Navigate 360, Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Dassault Systèmes SOLIDWORKS Waltham, MA

Data Analytics Intern Aug 2024 – May 2025

• Automated marketing data pipelines and email tracking processes using R, increasing operational efficiency by 75% through automated URL validation, email performance tracking, and budget allocation workflows for global ad campaigns.

• Designed and maintained Tableau dashboards to track campaign KPIs (clicks, traffic, user growth), enabling data storytelling and supporting marketing strategy modelling and client-facing reporting.

• Performed in-depth analysis across global paid media channels, segmenting data by geography, ROI, and engagement using Excel and SQL, to identify trends and optimize ad spend on global markets.

• Conducted A/B testing and performance segmentation by region to evaluate localization and content variants, improving engagement rate by tailoring messaging to regional behaviour and tracking results via Google Analytics and internal UTM data.

• Led data-driven process improvement initiatives to clean, standardize, and manage marketing data across campaigns, reducing manual reporting time by 40% and enhancing data consistency for accurate stakeholder reporting and analytics. Konica Minolta Marketing Services (Indicia Worldwide) Mumbai, INDIA Business Analyst Dec 2021 – Jun 2023

• Led end-to-end financial data operations using Microsoft Dynamics NAV, streamlining accruals, PO processing, and invoicing workflows, which improved revenue recognition accuracy and gross profit tracking by 65%.

• Developed and maintained consolidated dashboards to streamline vendor performance evaluation, reducing manual reporting efforts by 20% and supporting faster, insight-driven decision-making by business stakeholders.

• Conducted FP&A analysis across 6+ business units, including budgeting, forecasting, and scenario modelling using advanced Excel functions and cross-sheet Smartsheet automations to support strategic planning and financial decision-making.

• Designed and executed SQL queries to financial extract insights from ERP datasets, generating region wise profitability dashboards and P&L summaries across 25+ international markets for client-facing analytics reports.

• Automated vendor data consolidation workflows using Smartsheet, reducing reporting time by 60% and enhancing data accuracy, accessibility, and collaboration across global cross-functional teams.

• Collaborated cross-functionally with finance, procurement, and operations teams to gather business requirements & implement ERP process enhancements, led UAT to validate functionality and optimize (P2P) workflows for improved system efficiency. AB Infrabuild Mumbai, INDIA

Analyst Intern Aug 2021 – Nov 2021

• Built financial models cash flow, P&L, balance sheet to assess project viability for infrastructure contracts valued between

$0.5M and $2.5M, supporting data-driven investment decisions by senior finance leadership.

• Collaborated with cross-functional teams to prepare funding presentations and business cases for a $1.75M infrastructure project, aligning financial projections and growth potential with investor, bank, and grant agency expectations.

• Visualized project performance metrics and cash flow trends using Tableau, and collaborated with project managers to ensure alignment between financial forecasts and on-ground execution timelines. ACADEMIC PROJECT

• Navigating Economic Trends-Analysing Key Indicators & Forecasts: Conducted time series analysis on key economic indicators (GDP, CPI, PMI, Interest Rates) using ARIMA, ETS, and VAR models to provide insights for policymaking

• Sleep & Health Analysis on Stress: Conducted in-depth analysis of sleep and health data using Exploratory Data Analysis

• (Data EDA)Analysis, OLS regression, on Real-estate and cross-Broker validation as Client: techniques Utilized in R Python programming to investigate to analyse the impact changes of in sleep the Price factors of on property stress levels. wrt SqFt. Provide real-estate broker with data driven insights resulting in 15% higher commission on the properties sold.

Contact this candidate