Summary
Quote
Overview
Skills
Work History
Education
Interests
Why Learn Programming ?
Timeline
CustomerServiceRepresentative
Gugan P

Gugan P

MIS | Data Analyst | Business Analyst | 11 Years Exp
Chennai

Summary

To excel in Data analytics and Business analytics in any industry by taking every day as a learning experience & opportunity for Personal & Organizational growth

Quote

Your future is Created By What You Do today, Not Tomorrow
Robert T. Kiyosaki quotes

Overview

11
11
years of professional experience
3
3
years of post-secondary education
2
2
Languages

Skills

    Business Operations analysis

undefined

Work History

Senior Executive

Sun Direct TV. Pvt. Ltd
Chennai
11.2016 - Current
  • Good knowledge of Marketing Operations, telecom & DTH business analysis, & other operations.
  • Prepare complete retention of relevant insights, analysis, and reasoning for forecast figures.
  • Prepare, formulate, maintain and support customer churn forecasts and revenue forecasts on annual and monthly basis by utilizing historical data, reports, and analysis.
  • Manage and monitor forecasts daily and distribute estimates internally in organization lading to discuss with management for churn increase/decrease.
  • Prepare detailed analysis of deactivated bucket /cohort analysis/base addition analysis for increases/decrease in customer Churn rate.
  • Manage and resolve escalation of customer complaints.
    Identify major test scenarios for preparing & conducting the UAT while launching the new product and maintaining or updating databases, dashboards, systems, and methods.
  • Creating interactive PowerPoint presentations for Organizational Heads.
  • Demonstrated abilities in creating new analytical reports and improving efficiency and consistency of existing reports.
  • Generate and distribute management reports in accurate and timely manner.
  • Capable of understanding and implementing logic for ad-hoc analysis

Executive

Bharti Airtel Ltd
Chennai
09.2012 - 11.2016
  • Responsible for preparing reports and presentations for all operational reviews
  • Prepare Prepaid Revenue & Customer Usage growth/drop analysis report.
  • Prepared complete reports for monthly forecast (flash) meetings – Relied On weekly, monthly & yearly trends.
  • Reviewed and reported retailer and other sales incentive schemes for top management analysis.

Executive

First Source Solution Ltd
Chennai
12.2010 - 09.2012
  • Generate Daily/Monthly/Yearly reports by using MS access & excel functions.
  • Client’s reports & Daily Comparison Reports.
  • MS Excel & MS Access to the team member's knowledge transfer.

Education

Bachelor of Science - Physics

Arignar Anna Government Arts & Science College
Villupuram, Tamil Nadu
06.2005 - 05.2008

Interests

Learning Program languages

Why Learn Programming ?

  • Having SQL queries, Database management knowledge, Statistical languages, and basic coding can be helpful for the business analysts to simplify work.
  • The world is automated online. Coding skills can improve how you do business
  • It improves Problem-solving, logic, and critical thinking skills

Timeline

Senior Executive

Sun Direct TV. Pvt. Ltd
11.2016 - Current

Executive

Bharti Airtel Ltd
09.2012 - 11.2016

Executive

First Source Solution Ltd
12.2010 - 09.2012

Bachelor of Science - Physics

Arignar Anna Government Arts & Science College
06.2005 - 05.2008
Gugan PMIS | Data Analyst | Business Analyst | 11 Years Exp