Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Hobbies and Interests
Projects
Locations
Timeline
Generic

Kunal Mavi

Bangalore

Summary

Results-focused Senior Analyst with over eight years of experience in data analytics, automation, and process optimization, leveraging a quantitative approach to enhance business efficiency and strategic decision-making. Proven track record in developing secure, automated solutions aligned with business goals, coupled with strong leadership skills in mentoring and training teams. Proficient in delivering insights and technical information effectively to both technical and non-technical audiences.

Overview

8
8
years of professional experience

Work History

SENIOR ANALYST

Salesforce
02.2024 - Current
  • Developed and implemented automated data collection, analysis, and reporting processes, reducing reporting time by 90%
  • Created automation scripts using Python, JavaScript, and Bash to schedule tasks, monitor performance, and generate insights
  • Integrated Snowflake and Slack with Python to enhance end-to-end automation, ensuring secure data handling and process integrity
  • Designed and deployed a chatbot to streamline case handling, reducing case resolution time by 80% and improving response efficiency
  • Conducted workshops and mentoring sessions on Alteryx, building team capabilities in data analysis and automation

ANALYST

Salesforce
09.2021 - Current
  • Automated audit tasks and report generation using VBA and Python, saving 110 hours per week
  • Spearheaded data visualization and analysis with Tableau, creating dashboards to drive actionable insights in sales compensation
  • Extracted and managed large datasets using SQL, improving data processing efficiency
  • Conducted training sessions to enhance team proficiency in advanced Excel and Python for data management

SENIOR LEAD ANALYST

American Express
01.2020 - 09.2021
  • Enhanced computer systems for user efficiency, contributing to improved business outcomes
  • Automated manual incentive compensation tasks and developed innovative solutions using Python, VBA, Alteryx and SQL
  • Developed Tableau dashboards to visualize metrics for stakeholders, simplifying complex data for decision-making
  • Provided leadership in troubleshooting and resolving technical issues, ensuring compliance with company policies

SYSTEM ARCHITECT

American Express
09.2019 - 01.2020
  • Collaborated on automating team tasks using RPA tools, including Blue Prism, reducing manual workload by 90%
  • Supported team-wide data visualization improvements, creating dynamic dashboards in Tableau
  • Maintained a secure environment for customer information by implementing rigorous data management protocols

ANALYST

HCL Technologies
07.2017 - 09.2019
  • Utilized Alteryx and SQL for data analysis, optimizing workflows and enabling efficient handling of large datasets
  • Provided insights on agent performance, generating targeted feedback and contributing to operational efficiency
  • Supported application testing and created Tableau dashboards to track and improve customer service KPIs

SERVICE DESK ENGINEER

HCL Technologies
11.2016 - 07.2017
  • Strengthened team collaboration by assisting colleagues with complex technical issues and maintaining positive client relationships
  • Ensured timely customer service within a 1-minute response target, enhancing satisfaction and efficiency
  • Diagnosed and resolved system issues through effective troubleshooting, maintaining high operational performance
  • Supported budget accuracy with financial forecasting and optimized workflows to increase productivity
  • Utilized Alteryx, SQL, and VBA to analyze large datasets, forecast traffic, and streamline data extraction for relevant insights
  • Developed Tableau dashboards to provide clients with insights into customer traffic, resolution rates, and team productivity

Education

Master of Science - Data Science,Technology And Innovation

University of Edinburgh
12.2023

MBA - Human Resource Management

INDIRA GANDHI INTERNATIONAL OPEN UNIVERSITY
New Delhi
12.2023

Bachelor of Technology - Mechanical

MANAV RACHNA INTERNATIONAL UNIVERSITY
Faridabad
06.2015

Skills

  • Advanced Excel
  • VBA
  • Python
  • SQL
  • Tableau
  • Alteryx
  • Blue Prism (RPA)
  • JavaScript
  • Snowflake
  • Strategic planning
  • Quantitative analysis
  • Metrics-driven decision making
  • Effective communication with technical and non-technical audiences
  • Team mentoring and coaching

Accomplishments

  • Innovation Award, 04/01/24, Salesforce

Languages

English

Hobbies and Interests

  • Writing Stories
  • Playing Games
  • Making Websites

Projects

Ticket/Case Prediction System, Developed a predictive model for case management utilizing email IDs to enhance ticket resolution efficiency. SOQL Query Generator, Designed a tool to streamline the creation of Salesforce Object Query Language (SOQL) queries, optimizing data retrieval. Python + Slack Integration, Implemented an integration for server audits, providing real-time updates and notifications through Slack. Automated Manual Audits, Successfully automated 24 manual audit processes, significantly reducing time and effort. Transition from Python to Alteryx, Spearheaded the migration of data workflows from Python to Alteryx, improving process efficiency and performance. Multi-Solution Chat bot, Developed and deployed a versatile chat bot to enhance customer support and streamline interactions with automated solutions. COVID Cases Dashboard, Created an interactive dashboard to monitor and analyze COVID-19 case data, providing actionable insights. Automatic Outlook Mail Response, Developed an automated response system for Outlook to handle ticketing efficiently and improve response times.

Locations

  • Bangalore, Karnataka, 560068
  • Delhi, Delhi

Timeline

SENIOR ANALYST

Salesforce
02.2024 - Current

ANALYST

Salesforce
09.2021 - Current

SENIOR LEAD ANALYST

American Express
01.2020 - 09.2021

SYSTEM ARCHITECT

American Express
09.2019 - 01.2020

ANALYST

HCL Technologies
07.2017 - 09.2019

SERVICE DESK ENGINEER

HCL Technologies
11.2016 - 07.2017

Master of Science - Data Science,Technology And Innovation

University of Edinburgh

MBA - Human Resource Management

INDIRA GANDHI INTERNATIONAL OPEN UNIVERSITY

Bachelor of Technology - Mechanical

MANAV RACHNA INTERNATIONAL UNIVERSITY
Kunal Mavi