Priyank Srivastav
Lucknow
Summary
Experienced Data Analyst with 7+ years in Supply Chain and Logistics, skilled in analyzing large-scale datasets and optimizing inventory management across 300+ SKUs. Proficient in using Power BI, SQL Server, and Excel for data-driven reporting, trend forecasting, and demand prediction.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Senior Supply Chain Analyst
JMVD MULTITRADE PRIVATE LIMITED
12.2015 - Current
- Analyzed large-scale datasets of over 300+ Stock Keeping Units (SKUs) using SQL Server to extract, transform, and load (ETL) data for optimizing inventory management processes across multiple warehouses
- Performed weekly and monthly stock counting using Excel’s advanced formulas (VLOOKUP, INDEX-MATCH, and SUMIFS), improving accuracy and reducing discrepancies by 20%, ensuring precise stock levels and timely order placements
- Retrieved and managed expired stock data from SQL Server, implementing automated SQL queries to track and eliminate obsolete inventory, reducing stock wastage by 15%
- Created dynamic, data-driven reports and interactive dashboards in Power BI, enabling cross-functional teams to visualize stock movement and sales performance, reducing manual reporting efforts by 30%.
- Stock Sales Analysis: Designed detailed reports and dashboards to track stock turnover, sales velocity, and inventory aging, ensuring optimal stock availability and minimizing excess inventory
- Future Trend Forecasting: Developed predictive models in Power BI and Excel to forecast stock trends based on historical sales data, improving stock procurement and reducing stockouts by 25%
- Demand Prediction: Utilized time-series analysis and machine learning algorithms to predict future demand patterns, driving data-backed decisions on stock levels and procurement strategy
- Tools Used: Power BI, SQL Server, Excel (VLOOKUP, Pivot Tables, INDEX-MATCH, SUMIFS), Data Analysis Expressions (DAX), Time-series forecasting
Education
B.Tech in Civil Engineering -
A.P.J. Abdul Kalam University
Lucknow, Uttar Pradesh 07.2012 - 05.2015
Logistics & Supply Chain Management - undefined
MITSDE
Pune, Maharashtra 07.2021 - 05.2023
Skills
Power BI: Power Query, Data Modeling, DAX, Power Bi Services, Extract, Transform & Load (ETL), Data Reporting, Data Transformation, Dashboard, Documentation
Projects
JMVD MULTITRADE PRIVATE LIMITED | June 2024 - July 2024
Supply Chain Dashboard
- Developed a Power BI dashboard to monitor stock levels, sales trends, and profitability across 300+ SKUs, improving inventory management efficiency.
- Provided insights on regional sales and category performance, and Geographical Sales Insights helping management focus on high-margin items and adjust stock levels accordingly.
- Category Contribution helped indicating measure of profits from multiple categories and strong customer preferences.
Tools: Power BI, SQL Server, Excel, DAX, Power Query , Power Service.
Personal Project | April 2024 -May 2024
Reatils Sales Analysis
- · Analyzed 12 months of sales data from a retail company to gain meaningful business insights that could optimize sales strategies and improve customer targeting.
- Conducted product bundling analysis to identify frequently bought items together, enabling cross-sell opportunities
- Visualized trends and performance metrics using Plotly to optimize inventory and sales strategies
Personal Project | Jan 2024 - March 2024
British Airlines Service and Reviews Analysis
- Collaborated on British Airlines service analysis by implementing Python and web scraping for data collection and data validation.
- Conducted thorough data cleaning and sentiment analysis to identify and analyze service-related issues.
- Leveraged Azure and Spark tools to process and validate data, uncovering actionable insights.
- Addressed 27% of security and service-related issues, leading to improved monitoring and enhanced customer service solutions.
Certification
Certification in Power BI Virtual Casse Experience by PWC
Timeline
Logistics & Supply Chain Management - undefined
MITSDE
07.2021 - 05.2023
Senior Supply Chain Analyst
JMVD MULTITRADE PRIVATE LIMITED
12.2015 - Current
B.Tech in Civil Engineering -
A.P.J. Abdul Kalam University
07.2012 - 05.2015
Similar Profiles
Raunak AryanRaunak Aryan
Assistant Sales Manager (Developee) at Sankhwar Multitrade Private LimitedAssistant Sales Manager (Developee) at Sankhwar Multitrade Private Limited
GAURAV KUMARGAURAV KUMAR
Business Development Manager at PANSHUL MULTITRADE PVT. LTDBusiness Development Manager at PANSHUL MULTITRADE PVT. LTD
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited