Bhavik Gadani
Mumbai
Summary
Accomplished Data Analyst with 18 years of extensive experience in leveraging data-driven insights to drive strategic decision-making and optimize business performance. Proficient in advanced analytics, statistical modeling, and data visualization techniques, with a proven track record of managing large datasets and delivering actionable insights. Expertise includes SQL, PowerBI, Excel, PowerPoint, Tableau, Alteryx
Overview
20
20
years of professional experience
Work History
Assistant Manager Data Analyst
Tech Mahindra
07.2008 - Current
- Work alongside Operations Leaders to develop solutions that are applicable at a global level in the form of automated reports, dashboards or tools.
- Design, implement, and support platforms that provide ad-hoc access to large datasets.
- Develop and manage interactive dashboards and reports using tools such as Power BI, and Excel.
- Throughout my career, I supported senior colleagues with important research, analysis and preparatory work.
- Conduct in-depth data analysis to identify trends, patterns, and insights, supporting data-driven decision-making across the organization.
- Present findings and recommendations to senior management and stakeholders, translating complex data into actionable insights.
- Manage and prioritize multiple projects, balancing short-term and long-term business need.
Customer Care Executive
Convergys
05.2005 - 06.2008
Customer Service Executive
GTL
04.2004 - 04.2005
Education
Bachelor of Commerce - Commerce
South Gujarat University
Valsad, India04.2003
Skills
- Data Cleaning
- Data Visualization and Presentations
- ETL processes
- SQL
- PowerBI
- Tableau
- Alteryx
- Data Analysis
- Microsoft PowerPoint
- Data Modeling
- Report Preparation
Accomplishments
- SQL: Reduction in Average Handle Time (AHT) through Agent Performance Analysis.
Developed an SQL-based solution to analyze and reduce Average Handle Time (AHT) in a call center by identifying agents with low talk time and high wrap time. The project aimed to improve overall efficiency and customer satisfaction by providing actionable insights into agent performance. Wrote complex SQL queries to calculate key performance indicators (KPIs) such as talk time, wrap time, and AHT for each agent. Successfully identified agents with low talk time and high wrap time, enabling targeted training and coaching interventions. Achieved a significant reduction in AHT by 15% within three months of implementing the solution.
- PowerBI Dashboard: https://1drv.ms/u/s!AtXjad_Sxonna8Heg-IYnqRE2ks?e=mUr282
- Tableau Dashboard: https://public.tableau.com/views/HRAnalyticsDashboard_17023955930810/HRANALYSTICSDASHBOARD?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link
Timeline
Assistant Manager Data Analyst
Tech Mahindra
07.2008 - Current
Customer Care Executive
Convergys
05.2005 - 06.2008
Customer Service Executive
GTL
04.2004 - 04.2005
Bachelor of Commerce - Commerce
South Gujarat University
Similar Profiles
Hemanth Kumar BangaruHemanth Kumar Bangaru
Team Lead at Tech Mahindra, Tech Mahindra Pvt LtdTeam Lead at Tech Mahindra, Tech Mahindra Pvt Ltd
SHASHI SHARMASHASHI SHARMA
Senior Software Test Engineer at Comviva Mahindra (A Tech Mahindra Company)Senior Software Test Engineer at Comviva Mahindra (A Tech Mahindra Company)
Ravi Ranjan OjhaRavi Ranjan Ojha
Lead Software Developer at Tech MahindraLead Software Developer at Tech Mahindra