DHANDAPANI A S
Chennai
Summary
Database associate with 3+ years of experience in SQL, Power BI, and business analytics. Creates dashboards, KPI reporting, and automated data workflows supporting marketing and revenue teams. Evaluates conversion rates, ROI, and revenue trends to support forecasting and performance management.
Overview
6
6
years of professional experience
Work History
DATABASE ASSOCIATE-L2
Success gyan india LLP
Chennai
04.2023 - Current
- Developed and maintained interactive Power BI dashboards for Digital Marketing, Operations, Revenue, and KPI performance tracking.
- Wrote advanced SQL queries to extract, clean, merge, and validate data from multiple sources for accurate MIS reporting.
- Generated daily, weekly, and monthly reports for Marketing, Sales, Operations.
- Created dashboards to track revenue performance, sales trends, collections, and business growth metrics.
- Prepared KPI reports for team productivity, campaign results, customer acquisition, and operational efficiency.
- Built automated reporting processes using Power BI, SQL, Excel, and Power Query to reduce manual work and improve turnaround time.
- Conducted forecasting analysis for revenue, lead generation, sales targets, and business planning.
- Analyzed operational data to identify bottlenecks, process gaps, and improvement opportunities.
- Supported leadership with data-driven insights for strategic decision making and performance optimization.
- Worked closely with Digital Marketing, Operations, Finance, and Management teams to deliver customized reports and dashboards.
- Created drill-down dashboards for real-time monitoring and faster business decisions.
- Ensured data accuracy, consistency, and quality across all reporting systems.
- Presented insights through charts, dashboards, and summary reports to senior stakeholders.
MIS Executive
Star Health Insurance
Chennai
11.2020 - 04.2023
- Maintained a structured customer policy database, capturing detailed contact info, insurance preferences, claim histories, and renewal schedules.
- Implemented automated workflows to streamline policy management, reduce manual processing, and enhance operational efficiency.
- Developed MIS reports to monitor key performance indicators (e.g., claim resolution time, premium collections, policy lapse rate) and highlight areas needing improvement.
- Built interactive dashboards and visualizations in Excel/Power BI to provide senior management with clear insights into customer behavior, sales trends, and service efficiency.
- Created and maintained daily/weekly MIS reports that supported decision-making related to underwriting, policy issuance, and customer support.
- Designed efficient data entry and collection templates to ensure accuracy and consistency in claim submissions and agent performance tracking.
- Regularly updated user-friendly Excel tools for agents and operations teams to track customer touchpoints, follow-ups, and claim settlements.
- Created pivot tables, summary charts, and slicers for analyzing premium trends, customer demographics, and agent conversion rates.
- Stayed updated on the latest trends in insurance data systems, reporting tools, and customer service technologies to optimize operations.
Education
Engineering - Mechanical Engineering
NBKR Institute of Science And Technology
04-2017
Skills
- Google sheet
- Excel,Macro
- SQL Queries
- Power BI
- Looker studio
- Google analytics
- Data analytics
- KPI management
- Data reporting
- Zoho Analyst
- MIS reporting
- Business intelligence
- Reporting automation
- Advanced SQL
- Excel dashboards
- Power Query
Timeline
DATABASE ASSOCIATE-L2
Success gyan india LLP
04.2023 - Current
MIS Executive
Star Health Insurance
11.2020 - 04.2023
Engineering - Mechanical Engineering
NBKR Institute of Science And Technology