Summary
Overview
Work History
Education
Skills
Languages
Extra-Curricular Activities
Disclaimer
Timeline
Manager
Prathik Musthyala

Prathik Musthyala

Summary

Experienced marketing expert with a strong background in database management. Skilled in presenting data to clients through Power BI dashboards. Demonstrated success in creating and delivering interactive dashboards to partners, resulting in a significant shift in the company's market strategy and a remarkable 25% increase in revenue within one year.

Overview

8
8
years of professional experience

Work History

Manager

Liberty General Insurance Limited
06.2022 - 08.2023
  • Enhanced marketing and operations responsibilities
  • Managed various facets of business operations such as activation, optimization, and reporting.
  • Collaborated with management to distribute MIS and leverage it in marketing strategy.
  • Ensured strong COR and LR with OEM dealers.


Projects:

  • Power BI Sales Performance Dashboard: Designed and implemented a dashboard to visualize sales data across multiple regions, enhancing the marketing team's ability to identify performance trends and make data-driven decisions.
  • Customer Segmentation Analysis: Utilized Power BI to perform clustering analysis for a motor dealer database, helping to tailor marketing strategies to distinct OEM dealers.

Assistant Manager

Kotak Mahindra General Insurance Company Ltd
11.2019 - 05.2022
  • Managed marketing, sales, and operations responsibilities
  • Conducted analysis of business number generation from Pvt Car dealers using Power BI tool.
  • Developing and maintaining PowerBi reports, dashboards and data models to align organizational data sources with analytic needs.
  • Proactively supported stakeholders, serving as the go-to person for dispute management
  • Ensured consistent good COR and LR with OEM dealers
  • Ensured smooth business performance by closely monitoring MIS metrics.


Relationship Manager

Aditya Birla Insurance Brokers Ltd
02.2016 - 10.2019
  • Drove operational and sales improvements effectively
  • Managing projects related to data visualization, including setting timelines, prioritizing task and coordinating with cross-functional teams
  • Responsible for overseeing CMS and ACH activity, ensuring adherence to service standards through effective coordination with service partners.
  • Worked closely with IT team to ensure seamless development of the Insurance broking portal and successfully conducted UAT activity.
  • Formatting reports and dashboards to meet the needs of executive stakeholders, ensuring clarity, conciseness and visual appeal.

Education

PGDM - Operations and Marketing

Asia-Pacific Institute of Management
New Delhi, DL
01.2016

Bachelor of Technology - E.C.E

St. Mary's Engineering College, JNTU
Hyderabad, TG
01.2011

Skills

  • MS Excel
  • PowerPoint
  • Power BI
  • DAX
  • Python
  • People Management
  • Reporting Skills
  • Business Negotiation

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Telugu
Upper intermediate (B2)

Extra-Curricular Activities

  • Winner in the Cricket - sports day competition, Asia Pacific College.
  • Winner in the Basketball - sports day competition, Asia Pacific College.
  • Won many prizes in sports (Hockey, Volley ball, Kho-Kho).
  • Karate Blue Belt 2nd Dan (OKINAVA).

Disclaimer

I hereby solemnly affirm that the details furnished above are true to the best of my knowledge.

Timeline

Manager

Liberty General Insurance Limited
06.2022 - 08.2023

Assistant Manager

Kotak Mahindra General Insurance Company Ltd
11.2019 - 05.2022

Relationship Manager

Aditya Birla Insurance Brokers Ltd
02.2016 - 10.2019

Bachelor of Technology - E.C.E

St. Mary's Engineering College, JNTU

PGDM - Operations and Marketing

Asia-Pacific Institute of Management
Prathik Musthyala