Summary
Overview
Work History
Education
Skills
Projects
Languages
Personal Information
Timeline
Generic
Piyush Sharma

Piyush Sharma

Gurgaon

Summary

Results-driven Data Analyst with 10+ years of experience in collecting, analyzing, and interpreting complex datasets to support business decision-making. Proficient in utilizing advanced analytical tools and techniques, including Excel, SQL, Python, to transform raw data into actionable insights. Strong problem-solving skills combined with the ability to communicate complex data findings to non-technical stakeholders. 7+Years of experience in Telecom Industry (Bharti Airtel)

Overview

12
12
years of professional experience

Work History

Manager – Business Analyst

Apollo Health Co Limited
09.2022 - Current
  • Rollout of standard business dashboards and Generating insights that helps the business to drive
  • I’ve created Dash boards to track daily/weekly and monthly KPIs of Digital marketing.(Attribution and Appsflyer Orders, FB Appsflyer Orders Tracker, Install to uninstall tracker, New-Repeat Appsflyer orders)
  • Customer segmentation on the basis of profile and purchase history
  • DAU Funnel Tracking
  • Working on Ad-hoc / automated reports to measure performance of the Product Promotion Activities

Analytics Lead

myclassroom Learning services Pvt. Ltd.
03.2022 - 09.2022
  • Design, Programming and Rollout of standard business dashboards e.g
  • Student Enrolment and Revenue, Lead Stage and Activity Booking, Biometric Enrolment, Student Form dashboard
  • Digital marketing campaign tracking (Clicks, Impression, CTR, CPL, Leads)
  • CRM Tool Lead Squared Automation to track Lead Stage, Lead Activities and other KPIs with Sources

Assistant Manager- Analytics/Product Ops

Bharti Airtel Limited
12.2019 - 03.2022
  • Pre/Post Analysis of new product launch and change in existing product e.g
  • (zone realignment, data blocking, base rate changes, county addition)
  • Discovered new customer needs basis on data analysis and launched pack portfolios which meet those needs: Long duration packs
  • (Targeted 10% incremental revenue/ month)
  • New product configurations, business operation
  • In an industry first move, transformed customer experience by giving greater power and control in the hands of the customers (pre booking/Data tracking/Data blocking)
  • Rollout of standard business dashboards and Generating insights which helps the International roaming business to drive e.g
  • Pack activation/ roamers / P&L/channel performance dashboard
  • Working on Ad-hoc / automated reports to measure periodic performance of the product

Senior Executive- Analytics/ Product Ops

Bharti Airtel Limited
07.2016 - 11.2019
  • Core team member of International Roaming Marketing Team
  • Drawing relevant conclusions from the reports developed/ submitted and providing the same to the top managements in taking critical decisions
  • Customer segmentation of international Roamer
  • Operations Handling of Partnership with make my trip
  • Handling outbound call Centre to Improve pack adoption (30% of total activation)
  • Data Analytics and configuration of new IR packs (Smart packs / Foreign pass)
  • System, IR revenue and pack adoption increased by 32% and 8% respectively
  • Launched ‘Roam without fear’, one of a kind in the industry to ensure no bill shock to customers while on international roaming, reducing customer complaints by 78%

Executive- Analytics

Bharti Airtel Limited
09.2014 - 06.2016
  • Design, Programming and Rollout of standard business dashboards
  • Advanced level programming using SQL with DB2
  • Creation of regular AD-HOC SQL script for business team
  • Ensuring Data accuracy & consistency in all BI / related Information Systems
  • Understand the new requirement of Business Team and support to pulling out the data
  • Single point of contact in organization for international Roaming related data and business Insights

Network Engineer

Accenture services
08.2012 - 09.2014
  • Worked as L1 Engineer to perform first level trouble shooting on network related issue

Education

B.E. - E&C

Rajasthan University
01.2009

Skills

  • SQL
  • Python
  • Excel
  • CleverTap
  • Marketing
  • Data mining
  • Data visualization and presentations

Projects

Customer Segment   

  • Created Customer segment on the basis of family profiles added by customer and past purchase History.

19 mins Delivery 

  • To find high demand zones and optimal focal points for dark stores of 19 min delivery, aggregated the demand (online/offline/RWA) at S2id12 level.

Order Attribution.

  • Worked on order attribution based on different touch points of customers with App.

Languages

  • English
  • Hindi

Personal Information

Nationality: Indian

Timeline

Manager – Business Analyst

Apollo Health Co Limited
09.2022 - Current

Analytics Lead

myclassroom Learning services Pvt. Ltd.
03.2022 - 09.2022

Assistant Manager- Analytics/Product Ops

Bharti Airtel Limited
12.2019 - 03.2022

Senior Executive- Analytics/ Product Ops

Bharti Airtel Limited
07.2016 - 11.2019

Executive- Analytics

Bharti Airtel Limited
09.2014 - 06.2016

Network Engineer

Accenture services
08.2012 - 09.2014

B.E. - E&C

Rajasthan University

Similar Profiles

CREATE PROFILE
Piyush Sharma