Sumit Agarwal

Sumit Agarwal Email and Phone Number

Senior Associate Analyst @ ZS
India
Sumit Agarwal's Location
New Delhi, Delhi, India, India
About Sumit Agarwal

Sumit is currently working as a business analyst and B2B sales manager for Constl, an enterprise-grade B2B telecom startup. The developing a next-gen high capacity, low-latency digital infrastructure by laying own fiber pan-India to provide express connectivity to hyperscalers, OTT/ CDN, Telcos and ISPs. Previously, he worked with National Ecommerce Head (NSM) as an Ecommerce analyst for Orient Electric ( A CK Birla Group Company) to share exploratory data insights to identify gaps, suggest areas of improvement and help in strategy planning.Previously, he worked as a senior business analyst for Cognizant Technology Solutions for 1.25 years.>> He has worked as a senior analyst on 3 highly granular product evaluation and enhancement studies end to end for Enterprise/ Covid Centers/Metro schedules/ Map boundaries to suggest areas of improvement (10% or above) for the "navigation product" based on data driven insights derived from large datasets( 30000 and above depending on scope) per study for various metrics across various dimensions and multiple markets world-wide with detailed competitor benchmarking and relative KPI tracking on Excel-based dataHe was a student of PGPM class of 2019-2021, at esteemed MBA institute MDI Gurgaon. He served as a product manager at UnitedHealth Group, world's largest insurance service provider company, during his two month internship during MBA and handled three projects simultaneously.He has worked as a software associate under job title- Deployment Manager for ABS Prod project under AT&T at Tech Mahindra in Pune for 1.5 years months where his role was to handle and supervise the changes made in live environment viz-a-viz At&t telecom applications Premier and BC Services. He holds a B.Tech. graduate in Information Technology from JSS Academy Of Technical Education , Noida, under APJ Abdul Kalam Technical University,formerly known as UPTU(Uttar Pradesh Technical University). He has done academic projects in various programming languages - C, C++, Java, PHP, C# during UG days. During his MBA days, he won a national street play competition organized by IIM Lucknow. He indulges in swimming to alleviate stress and keep himself fit. He also likes to pen down poems once in a while to express himself with floral devices.

Sumit Agarwal's Current Company Details
ZS
Senior Associate Analyst
India
Website:
zsassociates.com
Employees:
16726
Sumit Agarwal Work Experience Details
  • Zs
    Senior Associate Analyst
    Zs
    India
  • Constl
    Business Alliances Manager
    Constl May 2023 - Present
    Gurugram, Haryana, India
  • Orient Electric
    Ecommerce Analyst
    Orient Electric Aug 2022 - Apr 2023
    New Delhi, Delhi, India
    •Developed/ maintained/ tracked primary sales/ secondary sales dashboard to capture granular sales trends, KPIs including GOLY/GOLM, forecast billing monthly/quarterly/yearly closing and maintain historic data trends against current sales pattern to generate rich-data insights for strategic planning across all revenue streams (D2C, Alpha sellers, MP).• Developed a category and SKU-level demand plan accuracy dashboard to analyse reasons for low accuracy from both demand and supply-side. RSP accuracy showed a gradual improvement of ~20% over the months.• Created a category and SKU-level fulfilment dashboard to identify gaps between POs and billing to bring transparency which reduced operational gaps and enhanced volume fulfilment rates by ~10%.• Created, maintained, and updated PSI sheet monthly to forecast closing inventory at platforms to strategize stock planning. Over 3 months, OOS reduced by ~7%.• Created CXO-level decks to highlight trends, gaps, and achievements in sales/ inventory planning/NPD progress among other KPIs.• Developed BU-wise trackers with category teams to analyze overall market size, competition profile, OEL market share, OEL product rankings, R&R etc. to benchmark OEL portfolio against competitors.• Co-ordinated with stakeholders (KAMs/operations/demand planning/Category/Product/SCM teams) cross-functionally to collate large data sets, create ad-hoc reports/presentations after requirement gathering and analysis to fulfil business needs timely.• Co-ordinated Fans Liquidation Project to liquidate PAN-India OEL inventory of ~78000 fans before implementation of BEE star-rating for certain models.
  • Cognizant
    Senior Business Analyst
    Cognizant May 2021 - Aug 2022
    Pune, Maharashtra, India
    • Conducting market research, feasibility studies, pilot studies and preparing excel data models for a "global navigation giant" for its product evaluation studies• Identifying KRAs, capturing/monitoring/performing Root Cause Analysis (RCA) on KPIs through exploratory data analysis to generate data-driven business insights for product enhancement after requirement gathering and analysis• Automating the reports with relevant KPI numbers/charts for easy handling of large sampled datasets• Preparing executive client decks with recommendations and deep-dive business analysis to identify trends/patterns/gaps in data to improve product performance with respect to the competitor profile• Communicating with stakeholders in a cross-functional setup to decide workflow/attributes for data collection and drive regular metric review calls till study completion• Tracking project milestone progress/timelines and executing end to end delivery of project study reportsAchievements/ Learning:Worked as a senior analyst on 4 "navigation product" evaluation and enhancement studies end to end related to Enterprise/ Covid Centers/Metro schedules/ Map boundaries to suggest areas of improvement (10% or above)on data driven insights on large datasets( 30000 and above depending on scope) per study for various metrics across various dimensions and multiple markets world-wide with detailed competitor benchmarking and relative KPI tracking on Excel-based data modeling.
  • Unitedhealth Group
    Product Management Intern
    Unitedhealth Group Apr 2020 - Jun 2020
    Bangalore
    • Suggested a go-to-market strategy for a healthcare solution after an extensive secondary research of the market being targeted by Optum• Proposed a business platform model with a cost-benefit analysis after analyzing opportunities and challenges of the proposed solutions
  • Tech Mahindra
    Software Engineer
    Tech Mahindra Aug 2016 - Jan 2018
    Pune, Maharashtra
    • Communicated with client and other stakeholders to understand objective and goal of AT&T’s telecom business application modules live environment changes in code and prepare activity plans for execution• Ensured cross-functional collaboration by identifying resources to execute planned changes in app• Handled escalations and ensured timely resolution as single Point Of Contact during deployment runs• Created end to end reports for stakeholders detailing incidents/activities/escalation resolutions during deployments to gather insights for process efficiency and optimization

Sumit Agarwal Skills

Java C/c++ Php Css Html Microsoft Office Microsoft Excel Customer Service Management Microsoft Word Powerpoint Public Speaking Research Project Management Leadership

Sumit Agarwal Education Details

Frequently Asked Questions about Sumit Agarwal

What company does Sumit Agarwal work for?

Sumit Agarwal works for Zs

What is Sumit Agarwal's role at the current company?

Sumit Agarwal's current role is Senior Associate Analyst.

What schools did Sumit Agarwal attend?

Sumit Agarwal attended Management Development Institute, Jss Academy Of Technical Education, Noida, Delhi Public School Aligarh, Delhi Public School Aligarh.

What are some of Sumit Agarwal's interests?

Sumit Agarwal has interest in Social Services, Economic Empowerment, Civil Rights And Social Action, Education, Poverty Alleviation, Science And Technology, Animal Welfare, Health.

What skills is Sumit Agarwal known for?

Sumit Agarwal has skills like Java, C/c++, Php, Css, Html, Microsoft Office, Microsoft Excel, Customer Service, Management, Microsoft Word, Powerpoint, Public Speaking.

Who are Sumit Agarwal's colleagues?

Sumit Agarwal's colleagues are Sharan Sathwik K P, Raghav Tiwari, Karim Tajik, Ketan Mittal, Kyle Ouellette, Yingzi Cui, Sudipto Saha.

Not the Sumit Agarwal you were looking for?

  • Sumit Agarwal

    Dei Advisor To Fortune 500 Companies | Linkedin Top Voice | Niti Aayog (Moc) | National Keynote Speaker | Icon Of The Election Commission | Sdg Ambassador For Diversity And Inclusion | Featured On Forbes And Fortune |
    Bidhannagar
  • Sumit Agarwal

    Cat 98P | Gate Air 77 | Project Strategy And Planning | Execution And Management | Power T&D | Solar, Ev And Renewables
    Jaipur
  • 2
    yahoo.com, unilever.com
  • Sumit Agarwal

    Founder & Ceo
    Moradabad
    1
    igp.com
  • Sumit Agarwal

    Sr. Bdm@Espire Infolabs | Mba | Mica | Demand Generation | New Client Acquisition | Digital Marketing
    Delhi, India
    4
    gmail.com, tatainteractive.com, syntelinc.com, xebia.com

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.