06/06/2025 updated

**** ******** ****
20 % partially available

Data Analytics Consultant with expertise in Market Mix Modelling and ROI Optimization

Bengaluru, India
Only remote
B.Sc Eco(Hons.)
Bengaluru, India
Only remote
B.Sc Eco(Hons.)

Profile attachments

Dristi's Resume - 2025

Data AnalysisBusiness IntelligenceBig DataDatabasesData VisualizationForecastingMarketing MixFurnishingMarketingLinear RegressionMaintenanceReturn On Marketing InvestmentVisualizationMicrosoft Power BIWriting DocumentationSQL DatabasesStatisticsSalesforce TableauModelling SkillsConsumer Packaged GoodsDemonstration SkillsCampaignsDatabase Administration
Market Mix Modelling
Expertise in developing and implementing marketing mix models to analyze campaign effectiveness and optimize ROI across multiple industries including toys, furniture, and FMCG.

Data Analysis & Visualization
Proficient in extracting, cleaning, and analyzing large datasets to generate actionable insights using Excel, SQL, Tableau and Power BI.

Statistical Modelling
Strong background in building linear regression models, response curves, and attribution models to forecast demand and optimize marketing budget allocation.

Microsoft Office Suite
Advanced skills in MS Excel, Word, and PowerPoint for data analysis, documentation, and presentation creation.

Database Management
Experience with Normative Database compilation and maintenance, ensuring consistency across 1500+ projects.

Business Intelligence Tools
Proficiency in Tableau and Power BI for creating data visualizations and interactive dashboards.

ROI Optimization
Specialized in developing strategies to improve marketing ROI through data-driven insights and budget allocation recommendations.
 

Experience

Professional experience0 - 5 years
Freelancer since2025

Languages

EnglishGood

Project history

Consultant

Analytic Edge Pvt. Ltd.
Working on Normative Database compilation, Marketing Mix Modelling using statistical analysis, and extracting insights from large datasets to enhance marketing strategies. Successfully contributed to projects generating maximum revenue for company.

Analyst

Excel Simulation
Created an excel simulation to forecast the business for the insurance company.

Data Analyst

Power BI & Tableau (Meal Delivery Company)
Made a story that talks about the level of demand in each center and forecasted the demand for meal for next 5 weeks.

Market Mix Modelling Analyst

Mattel (Toys and Entertainment Industry)
Extracted, cleaned, processed, prepared data validation file. Analyzed the data and built linear regression model, forecasted and converted the analysis into business sense. Worked on deep dives and built response curves to understand marketing tactics effectiveness.

Market Mix Modelling Analyst

Meta-Beliani (Furniture Industry)
Extracted, cleaned and analyzed data. Built linear regression model and implemented analysis into business understanding. Worked on short term and long term model and calculated ROI to understand which tactics give better return, developed attribution model that refined marketing spend allocation.

Marketing Ambassador

Godutch
Introduced ideas to grow go dutch brand as a role of marketing ambassador. Created brand awareness by posting it on social media. Target-based internship where successfully promoted the app to get 60 people to download it.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in