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
2015.12 - 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 2012.07 - 2015.05
Logistics & Supply Chain Management - undefined
MITSDE
Pune, Maharashtra 2021.07 - 2023.05
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
2021.07 - 2023.05
Senior Supply Chain Analyst
JMVD MULTITRADE PRIVATE LIMITED
2015.12 - Current
B.Tech in Civil Engineering -
A.P.J. Abdul Kalam University
2012.07 - 2015.05
Certification in Power BI Virtual Casse Experience by PWC
Certification in Data Science by Console Flare
Certification in Power BI by Infosys Springboard
Similar Profiles
Raunak AryanRaunak Aryan
Assistant Sales Manager (Developee) at Sankhwar Multitrade Private LimitedAssistant Sales Manager (Developee) at Sankhwar Multitrade Private Limited
SARAVANAN MOORTHYSARAVANAN MOORTHY
Senior QA Analyst at Veryon Private Limited (Formerly known as Rusada Avaiation Private Limited)Senior QA Analyst at Veryon Private Limited (Formerly known as Rusada Avaiation Private Limited)
Sumit GargSumit Garg
Assistant General Manager - Finance at Trident Hills Private Limited (Formerly Known As IREO Fiveriver Private Limited)Assistant General Manager - Finance at Trident Hills Private Limited (Formerly Known As IREO Fiveriver Private Limited)