Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Shagun Agarwal

Shagun Agarwal

Data Analytics, Business Analytics, Business Planning & Strategy
Mumbai,Maharashtra

Summary

Enthusiastic and experienced Business & Data Analytics Professional with 7+ years of experience to work in a corporate as well as start-up environment. Good in performing data analysis and presenting insights that will help businesses in their growth strategies and problem solving.

Overview

9
9
years of post-secondary education
9
9
years of professional experience

Work History

Data Analytics, Business Analysis, Market Study

Freelancer
Mumbai, Maharashtra
01.2020 - Current
  • Data Analytics: Undertook various data analysis projects on Freelancing websites. Also involved in making PPTs for Mgmt.
  • Market Study: Helped Angel Broking in Industry level study- Gamification in Digital App, Mobile Apps Key metrics and how to improve it.

Products Head, Business Analytics

FunOnGo Media & Entertainment LLP
Mumbai, Maharashtra
09.2015 - 05.2018
  • Revenue Maximization, Business Planning, Strategy & Analytics to drive Business Growth
  • Products: 1) WAP (Managed multiple OEM Portals) 2) APP (CHILLX) Multi-lingual Play store based Regional App to provide entertainment 3) White Label Platform development (App ready) VOD OTT platform for B2B Clients 4) Chillx 3.0 (UGC Platform): User generated App to be launched soon
  • Cross functional Teams Co-ordination: WAP Development Team, Android Development team, Creatives Team, Content Team, Sales Team, Business Heads
  • Responsibilities: Handled complete product right from Features/New functionalities, UI & designing aspects, Industry trends, App Analytics, Revenue driving, Business Model/Strategy Plan, Ads Integration/Placement decisions, OEM Deals & decisions to drive Sales, Content Featuring & Management (Dynamic Refresh & Relevant Content)
  • Defined Key App Metrics to judge overall performance and to present Analytics to CEO/Investors
  • Involved in all new business initiatives taken by the FOG- Investor meet, Product Launch, Business decisions and presentations, new business ideation & implementation, machine learning and analytics implementation

Associate Vice President

Motilal Oswal Financial Services Ltd, MOFSL, AVP
Mumbai, Maharashtra
09.2014 - 09.2015
  • Business Analysis & Business Consulting: Defined a full-proof Business Model for Broking & Distribution business, Projection Models (5 Year Business Planning), BD Business Dashboard Implemented & Benchmarking introduced for major KPIs
  • Corporate Planning & Data Analytics: Acted as Shadow CEO to the Broking & distribution business helping him in achieving his key Strategic goals, Undertook number of data analytics Projects to help business Projects: Brokerage Slabs Understanding & actions to drive profitability through the same, City-wise Broking Industry Potential defined, Monthly/Quarterly Review Mechanism made more insightful for Business to take quick decisions, etc.
  • Skills: Exposure to MS-Excel, PowerPoint PPT, Advanced level Analytics using MS-SQL
  • Opportunity to interact with Business CEOs, External Consultants, and Directors

Chief Manager- Management Department

Angel Broking, CSO, Head Office
Mumbai, Maharashtra
07.2010 - 09.2014
  • Business Analysis & Business Consulting: Broking Business Model; Future Revenue Foresting/Projection Models; Understanding various business verticals & suggesting, tracking and benchmarking KPIs; Age analysis Study; Various critical analysis as needed by Top Mgmt. Team/Directors at Transaction/Client/SB/Branch /Region/Zone level.
  • Corporate Planning & Strategy: Industry Analysis, Competitor analysis, Country Study, Company Business Analysis, Defining Business potential for Angel (Pin code level analysis-Demat Accounts), Target Setting (Service & Sales Target). Projects: SB Industry Performance; Clients Age analysis approach, U.S/India/Korea/brazil Study, Ameri Trade Study, U.S Online brokers, Zerodha Business Model, Various Industries study & their potential, Demat Account based Potential Estimate, etc.
  • Business Analytics & Business Process Improvement: Scorecard & advanced Business Analytical Dashboards empowering faster decision-making & action-oriented approach Projects: Scorecards & Advanced Analytical Dashboards for Top Management and other Business stake holders. KYC form Optimization and MIS Reports automation.
  • Online Marketing: Online Marketing Strategy, Vendor Management, Lead Generation, SEM, SEO, Campaign Selection, Management and Optimization, Conversion Tracking, Reporting & Planning. Projects: SEM/SEO/E-mailer/Branding/Other campaigns, Ad Banners/Creatives, Content, Dynamic Landing Pages, Google AdWords, Campaign Management and Optimization.
  • Skills: Exposure to MS-Excel, PowerPoint PPT for Top Mgmt. .Advanced level Analytics using SQL. Opportunity to interact with Business heads and Directors.

Summer Internship

Bank of Baroda
Mumbai, Maharashtra
05.2009 - 07.2009
  • Asset-Liability Management System (Risk Management Dept.) Understanding various types of risks faced by banks; Norms and guidelines banks need to comply with; Studying ALM system of BOB and comparing with its peers; Various tools used for liquidity and Interest Rate risk management.

Education

MBA - Finance

N.L. Dalmia Institute of Management Studies
Mumbai
06.2008 - 05.2010

B.E - I.T

D.J. Sanghvi College of Engineering
Mumbai
03.2004 - 05.2008

HSC - Science

Mithibai College
Mumbai
04.2002 - 02.2004

SSC -

Bombay Cambridge School
Mumbai
03.2001 - 03.2002

Skills

Data analytics

undefined

Accomplishments

  • 9% & Secured Highest Marks 96/100 in “Business Maths and Statistics” Distinction holder in MBA SEM-2, 4th Ranker in MBA SEM-3 with 72.9% Certificate held for highest marks (149/150) in Mathematics in S.S.C NCFM Certification: Capital Market (Dealers) Module & Derivatives Market (Dealers) Module Non-Academic Pursuits (includes extra & co-curricular activities): Attended a 3-Day Outdoor “Personality Development Camp” during MBA Volunteered and organized events as a Member of Computer Society of India[CSI] in degree College Certificate held in “Maharashtra Talent Search Examination” & “Elementary & Intermediate Drawing Examination” Certificate held in 3rd National I.T Aptitude Test in NIIT in 2007.

Timeline

Data Analytics, Business Analysis, Market Study

Freelancer
01.2020 - Current

Products Head, Business Analytics

FunOnGo Media & Entertainment LLP
09.2015 - 05.2018

Associate Vice President

Motilal Oswal Financial Services Ltd, MOFSL, AVP
09.2014 - 09.2015

Chief Manager- Management Department

Angel Broking, CSO, Head Office
07.2010 - 09.2014

Summer Internship

Bank of Baroda
05.2009 - 07.2009

MBA - Finance

N.L. Dalmia Institute of Management Studies
06.2008 - 05.2010

B.E - I.T

D.J. Sanghvi College of Engineering
03.2004 - 05.2008

HSC - Science

Mithibai College
04.2002 - 02.2004

SSC -

Bombay Cambridge School
03.2001 - 03.2002
Shagun AgarwalData Analytics, Business Analytics, Business Planning & Strategy