Pulkit Agrawal
Summary
Highly motivated and detail-oriented Data Analyst with a proven track record in pricing analysis, data manipulation, and developing data-driven strategies. Strong skills in SQL, Power BI, and advanced Excel, with a passion for turning complex datasets into actionable business insights.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst - Pricing
Stelling Technologies (Railyatri.in)
Noida
07.2023 - Current
- Development of data-driven strategies for business improvement, resulting in a 7% MoM increase in revenue.
- Assisted in implementing dynamic pricing models, resulting in a 15% increase in revenue.
- Analyzed historical sales data and customer behavior to forecast demand and optimize pricing strategies.
- Collaborated with marketing, sales, and route teams to align pricing strategies with business objectives.
- Conducted extensive data mining and statistical analysis to identify trends and patterns, enabling data-driven decision-making.
- Prepared detailed reports and presentations for senior management, highlighting pricing performance and recommendations.
- Monitored daily and weekly performance of bus services and executed necessary pricing intervention.
- Developed and maintained automated data pipelines, reducing data processing time for effective decision making.
- Collaborated with cross-functional teams to design and implement KPIs and Power BI dashboards, supplying real-time insights to stakeholders.
Data Analyst - Pricing
SHIPROCKET
Gurugram
07.2022 - 07.2023
- Created tools in MS Excel to calculate revenue and margin deltas, providing detailed insights about the changes automatically, which helped reduce the calculation time of drop analysis.
- Assisted in building the custom pricing structure.
- Found the reason behind the churning of clients and plausible solutions.
- Predicted the churn possibility of 300+ clients by relating RTO% and client's SOW (Share of wallet)
- Worked closely with the cross-functional teams to provide critical insights.
Executive - MIS & Logistics
Prataap Snacks Limited
Indore
07.2020 - 06.2022
- Implemented the inventory replenishment model at the Bangalore hub, optimizing stock levels and reducing costs, improving turnaround time, and order fulfillment.
- Prepared and analyzed different freight reports to support appropriate logistics decisions.
- Identified, communicated, and added new logistics partners, and negotiated prices and terms.
- Coordinated with different S&D teams to ensure timely availability of stock to channel partners.
- Supported the sales excellence team for the growth of slow-moving SKUs and new SKUs to help penetrate into different markets.
Education
PGDM (Operation Management) -
Fortune Institute of International Business
New Delhi05.2019
B.Com (Foreign Trade) -
Shri Vaishnav College of Commerce
Indore05.2017
Skills
- Advanced MS Excel
- SQL
- Power BI
- Data manipulation
- Pricing analysis
- Data Warehousing
Accomplishments
- Rockstar Rookie (Shiprocket) - Awarded for best performance in a quarter.
- Selected as a Coordinator for the '23 days Incredible India Rally' at D & P.
- Won the first position in Case Study Competition on 'Patanjali' at FIIB.
Certification
- The complete PostgreSQL Bootcamp - Udemy
- Microsoft excel-Beginner to Advance (Macros and VBA Included) - Udemy
·
Timeline
Data Analyst - Pricing
Stelling Technologies (Railyatri.in)
07.2023 - Current
Data Analyst - Pricing
SHIPROCKET
07.2022 - 07.2023
Executive - MIS & Logistics
Prataap Snacks Limited
07.2020 - 06.2022
PGDM (Operation Management) -
Fortune Institute of International Business
B.Com (Foreign Trade) -
Shri Vaishnav College of Commerce
Similar Profiles
Akash AroraAkash Arora
Area Manager at Stelling Technologies (Railyatri.in)Area Manager at Stelling Technologies (Railyatri.in)
Harish KumarHarish Kumar
Territory Manager at Stelling Technologies Pvt Ltd (Intrcity Smart Bus)Territory Manager at Stelling Technologies Pvt Ltd (Intrcity Smart Bus)
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)