Learning Program languages
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
Data analytics
Technically Equipped
Process Streamlining
Analytical & Problem Solving
Time management
Proficient in Excel, MS Access, PowerPoint and SQL
Leadership
Teamwork
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
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