Siddharth Dewangan
Manager – Sales Analyst | FMCG Domain
- Role
- Manager (Sales Analyst) at PepsiCo
- Location
- Hyderabad, TG, IN
- LinkedIn followers
- 500 followers
About Siddharth Dewangan
Manager with 10+ years in Data Analysis, BI, and Data Visualization | Expert in Power BI,…
Experience
Manager (Sales Analyst)
Apr 2023 — Present
Responsibility: Analytics/Management Reports/Process AnalyticsA. Development/Automation Projects a. Plan, design, and deploy an Excel-based reporting dashboard for the region and the account’s stakeholders. b. Automated and modified the existing manual Excel-based dashboard into PowerQuery (saves 80% of the time). c. Deployed Power BI market visit dashboard for the Southeast Region’s zones and markets (saves 90% of the time). d. Deployed PowerBI dashboard for repetitive business review slides (saves 90% of the time).B. Monitor / Control a. SPOC for Southeast Region Reporting and Adhocs Division. b. Managing changes and regular push of weekly/monthly reports for the region and accounts (Publix & Rouses). c. PowerPoint deck modification, template creation, and push updates as per business requirements (RBT/POR/Sr Staff/Deep Dive).C. Expertise a. CoPilot for PowerBI (DAX)/ ChatGPT & CoPilot for queries / Stakeholders management / TAT / UAT / Unify Report / Numerator Report / Data Visualization / Data Insights / Data Modelling / Data Quality Health Checkup / Analytical & Problem-Solving SkillsD. Appreciation a. Received appreciation for automation and TAT.Tool: Power BI, PowerQuery, Advanced Excel, PowerPoint, SharePoint.
Education
Vikas Education Institute, Visakhapatnam
Intermediate
2004 — 2006
Shri Shankaracharya college of Engineering & Technology, Bhilai, Chhattisgarh
B.E
2006 — 2010
Aegis School of Business & Telecommunication, Navi Mumbai
MBA in Telecom Management (MPTM) & PGDM in Business Administration
2011 — 2012
Skills
- Data Analysis
- Microsoft Office
- R
- Microsoft Excel
- Customer Relationship Management (Crm)
- Market Research
- Requirements Analysis
- Ms Project
- Customer Service
- Mysql
- Telecommunications
- Analysis
- Project Management
- Competitive Analysis
- Sql
- Sas Base
- Business Analysis
- Business Strategy
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.