SteelAlborz

- Successfully designed and implemented a Power BI dashboard that integrated monthly MRP data from multiple Excel files and many other sources, utilizing R programming language to clean and standardize the data. The dashboard displayed consumption trends, on-hand inventory history, shortages by MRP, safety stock history, lead time analysis, and average consumption rates for over 5000 items. Custom visuals were created to enable easy identification of sudden changes in item performance, allowing for better decision-making and improved team tracking.
- Improved supply chain traceability and reports accuracy, resulting in a significant increase in delivery index from 35% to 84% after two quarters, by implementing drill-down tables and identifying delays and surplus shipments.
- Utilized R programming language and various libraries such as tidyverse, lubridate, stringr, and ggplot2 to clean data and generate multiple reports. Also, utilized Power BI and Power Pivot to create custom measures in DAX and compare weekly production planning with forecasted MPS, highlighting deviations and production bottlenecks.
- Designed dashboards using Excel Power Pivot and Power BI, utilizing advanced Power Query (M language) and DAX techniques to calculate department performance indicators and generate weekly reports. Developed new order tracking reports for factories using ETA and MRP periods, resulting in better order tracking and stainless steel converting ratios.
- Developed an MBO tracking report utilizing advanced Excel formulas, including conditional formatting, to identify incomplete and unfinished tasks and notify relevant teams. Successfully introduced the OKR approach to our department by conducting a mini workshop and holding multiple meetings with each supervisor.
- Developed expertise in MRP, BOM, and MPS, as well as the fixed order interval method for inventory control and periodic ordering based on EOQ principles.

Supply Planner Specialist

- Proficient in Python (pandas and numpy) and R programming, which were utilized to automate reports and daily routines, resulting in increased accuracy and preparation speed. Examples include preparing not shipped orders report to customers with details such as number of each product, destinations, and order issued date, facilitating better prioritizing of shipments.
- Recognized for being a friendly, hardworking, and punctual employee.

Sales planner Employee

Keiashyan Petro Steel

- Successfully acquired proficiency in Excel, DAX, and VBA, and applied business intelligence and data analyst concepts to design and implement a sales management dashboard. The dashboard automated the issuance of PI and invoice, calculated total sales, revenue, and profit, monitored inventory levels, and tracked debt amounts owed to/from customers/suppliers. This resulted in a significant increase in company turnover by approximately 200% and improved customer satisfaction.

Sales Support Specialist

Learned advanced Excel skills which led to significant improvements in document archiving and streamlining of daily routines. Developed efficient templates for various reports and presentations, resulting in increased productivity and accuracy. Collaborated with team members to identify areas for process improvement and implemented solutions through Excel automation.

Sales Employee

Self-motivated, proactive, hard-working and passionate about business intelligence and data analysis, particularly in the supply chain field with 3+ years of experience in creating interactive dashboards for sales, production, and delivery tracking that allow stakeholders to view KPIs and identify bottlenecks.

Highly motivated to learn new skills and expand current abilities and knowledge. Skilled in R programming, Power Query, DAX, Python and familiar with SQL. Seeking new opportunities and have strong analytical skills. Aim to share my knowledge and skills with my colleagues while also learning from them.

Taplio

Alireza Shahinmehr's Linkedin Analytics

Alireza Shahinmehr

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Alireza Shahinmehr's Linkedin Analytics

Alireza Shahinmehr

Want to drive more opportunities from LinkedIn?

Alireza Shahinmehr's Linkedin Analytics