Marketing Campaign Dashboard – Excelerate
→
Summary
Developed an interactive dashboard to visualize key marketing performance metrics and optimize ad spend efficiency.
About
Results-driven Business Analytics professional with hands-on experience in leveraging data for strategic decision-making and operational efficiency. Expert in dashboard design, BI reporting, SQL, Python-based analysis, and predictive modeling, with proficiency in Power BI, Tableau, and Salesforce CRM. Proven ability to optimize campaign performance and generate actionable sales and donor insights, seeking to apply advanced analytical techniques in data-driven marketing, sales, or operations roles.
Work
Excelerate
|Project Lead Intern
→
Summary
Leads a team of 8 in managing diverse datasets, performing data wrangling, and developing interactive dashboards for marketing and sales KPIs to deliver actionable business intelligence.
Highlights
Directed an 8-member team to manage 7 complex datasets for a live business intelligence case, ensuring data integrity and accessibility for analysis.
Engineered and maintained PostgreSQL databases, performing comprehensive data wrangling to construct a unified master table.
Developed interactive dashboards using Power BI and Looker Studio, visualizing key marketing and sales KPIs to enhance stakeholder decision-making.
Automated reporting processes and generated actionable insights through DAX measures and custom visuals, improving operational efficiency.
MedTourEasy
|Data Analyst Trainee
→
Summary
Developed predictive models for donor retention and analyzed cosmetic datasets, delivering actionable insights and visualizations to inform strategic decision-making.
Highlights
Developed a predictive logistic regression model using TPOT to forecast donor retention from 748 samples, enhancing strategic planning.
Optimized data pipelines and engineered features, improving donor forecasting accuracy by 30%.
Conducted in-depth analysis of cosmetic datasets to discover trends, increasing insight delivery speed by 25% for timely business responses.
Created compelling visualizations of product popularity using Matplotlib and Seaborn, directly guiding strategic decision-making for product development.
K.G.N Garments
|Marketing Intern
→
Summary
Led strategic market analysis and streamlined operational workflows to enhance customer targeting and client feedback efficiency.
Highlights
Led comprehensive SWOT and STP analyses to precisely identify key customer segments, significantly improving targeting accuracy for marketing campaigns.
Streamlined presentation and sampling workflows, reducing client feedback time by 15% and accelerating project cycles.
Education
Western Business School
Pune, Maharashtra, India
→
Post Graduate Diploma in Management (PGDM)
Business Analytics
Woosong University
Daejeon, Korea (Republic of)
→
Student Exchange Program
Data Visualization, Marketing
Baba Farid Group of Institutions
Dehradun, Uttarakhand, India
→
B.Sc.
Agriculture
Awards
Outstanding Intern Recognition
Awarded By
MedTourEasy
Recognized for exceptional performance and significant contributions during the Data Analyst Trainee internship.
Certificates
Power BI for Beginners
Issued By
Simplilearn
Google Foundations: Data, Data Everywhere
Issued By
Coursera
Data Visualization for Business
Issued By
Tata Forage Program
Accenture Data Analytics Simulation
Issued By
Forage
PwC Power BI Job Simulation
Issued By
Forage
Red Bull Sales Strategy Simulation
Issued By
Forage
Skills
Programming & Databases
Python, Pandas, NumPy, SQL, PostgreSQL, R.
BI & Visualization Tools
Power BI, Tableau, Excel (Pivot Tables, Power Query), Looker Studio, RStudio.
CRM Platforms
Salesforce (Sales Cloud, Marketing Cloud).
Data Analysis & Modeling Techniques
Data Cleaning, EDA (Exploratory Data Analysis), Regression, Classification, DAX, Dashboard Design, Forecasting, TPOT.
AI/ML Tools
OpenAI.
Projects
Cosmetics Product Trend Analysis – MedTourEasy
→
Summary
Conducted comprehensive analysis and visualization of cosmetic product preferences to identify market trends and inform business strategy.
Predict Blood Donations – MedTourEasy
→
Summary
Developed a predictive model to forecast blood donations, enhancing resource allocation and planning.