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.
-
Senior Associate AnalystZsIndia -
Business Alliances ManagerConstl May 2023 - PresentGurugram, Haryana, India -
Ecommerce AnalystOrient Electric Aug 2022 - Apr 2023New 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. -
Senior Business AnalystCognizant May 2021 - Aug 2022Pune, 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. -
Product Management InternUnitedhealth Group Apr 2020 - Jun 2020Bangalore• 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 -
Software EngineerTech Mahindra Aug 2016 - Jan 2018Pune, 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
Sumit Agarwal Education Details
-
Marketing And Finance -
Information Technology -
93.4 % -
95.20 %
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 RenewablesJaipur -
Sumit Agarwal
Bengaluru2yahoo.com, unilever.com -
1igp.com
-
Sumit Agarwal
Sr. Bdm@Espire Infolabs | Mba | Mica | Demand Generation | New Client Acquisition | Digital MarketingDelhi, India4gmail.com, tatainteractive.com, syntelinc.com, xebia.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial