Dhandapani A S
Nagari
Summary
Data-driven Digital Marketing Analyst with expertise in Excel, SQL, and Power BI for analyzing campaign performance, lead funnels, and marketing KPIs Proficient in automating reports, creating dashboards, and delivering insights to enhance conversion rates, ROI, and customer engagement. Skilled at integrating marketing data from platforms like Google Ads, Meta Ads, and CRM systems, and transforming them into actionable insights. Strong ability to communicate findings to stakeholders, ensuring data-backed marketing decisions and strategy optimization.
Overview
5
5
years of professional experience
Work History
DATABASE ASSOCIATE
Success gyan india LLP
Chennai
01.2023 - Current
- Analyze lead generation data and marketing campaign performance using Excel dashboards and Power BI visualizations.
- Extract and manipulate marketing data using SQL queries to identify trends, drop-offs, and conversion bottlenecks.
- Automate weekly and monthly campaign performance reports using Excel and Power Query.
- Build dynamic Power BI dashboards to track campaign spend, CTR, CPL, impressions, and lead quality metrics.
- Collaborate with the performance marketing team to provide real-time insights for ongoing ad optimizations.
- Support A/B testing analysis and audience segmentation using data tools.
- Conduct trend analysis, error tracking, and performance reviews based on operational data for weekly/monthly reporting.
- Develop and maintain interactive dashboards and visual reports in Power BI using bar charts, pie charts, line graphs, slicers, etc., for various business teams.
- Extract, clean, and transform large datasets using SQL queries (e.g., SELECT, JOIN, WHERE, GROUP BY) from SQL Server for business reporting.
MIS Executive
Star Health Insurance
Chennai
11.2020 - 04.2023
- Maintained a database of customer information, including contact details, preferences and purchase histories.
- Implemented automated processes to streamline daily operations and reduce manual workloads.
- Developed MIS reports to track customer service performance and identify areas for improvement.
- Created dashboards and visualizations to present data insights in an easy-to-understand format.
- Developed and maintained comprehensive MIS reports to facilitate decision-making processes for senior management.
- Designed and implemented efficient data collection systems to optimize information flow and reporting accuracy.
- Created and updated user-friendly spreadsheets on daily basis.
- Created tables, pivot reports, and charts for information tracking purposes.
- Maintained knowledge of advances in information technology systems and applications.
Education
Engineering - Mechanical Engineering
NBKR Institute of Science And Technology
04-2017
Skills
- SQL querying
- Power BI
- Campaign reporting
- Microsoft office
- Data analysis
- Performance reporting
- Excel automation
- Reporting tools
- Looker studio
- Macro
- Zoho Analystic
Languages
- Tamil
- English
- Telugu
Hobbies and Interests
- Browsing
- Listening music
- Watching cricket
Personal Information
- Date of Birth: 29/03/196
- Marital Status: Married
- Religion: Hindu
Timeline
DATABASE ASSOCIATE
Success gyan india LLP
01.2023 - Current
MIS Executive
Star Health Insurance
11.2020 - 04.2023
Engineering - Mechanical Engineering
NBKR Institute of Science And Technology
Similar Profiles
Shailja BhatejaShailja Bhateja
Associate Director-Client & Industry at PricewaterhouseCoopers India LLP ( PwC, India)Associate Director-Client & Industry at PricewaterhouseCoopers India LLP ( PwC, India)
Shivani WankhedeShivani Wankhede
Software Developer (Experienced) at Amdocs Development Centre India, LLP, Pune, IndiaSoftware Developer (Experienced) at Amdocs Development Centre India, LLP, Pune, India
Hariharan N Hariharan N null
Accountant at Hiregenics India LLP (Oracle India PVT LTD)Accountant at Hiregenics India LLP (Oracle India PVT LTD)
Manikanta PManikanta P
Sr. Accounts Executive at Apollo Pharmacies LimitedSr. Accounts Executive at Apollo Pharmacies Limited
Harshitha RaghavarajuHarshitha Raghavaraju
Devops Engineer at Tech MahindraDevops Engineer at Tech Mahindra