Ashish Shakya

Designed interactive dashboards in Power BI to track key supply chain KPIs. Automated data extraction and processing workflows using Python and SQL, saving 4+ hrs/week. Developed ETL pipelines using SSIS to integrate and transform supply chain data. Conducted root cause analysis to improve the efficiency of dashboards. Collaborated with cross-functional teams to implement automation solutions, reducing manual errors by 30%. Email automation using python for bulk dispatch supplier’s follow-up.

Automated PO creation process using selenium + python, reducing manual work load by 30%. Published power BI dashboards for real time supplier’s performance tracking. Developed ETL pipe lines to improve the dashboard performance. Root cause analysis for the jobs failed to perform in SSMS. Provided training on SSIS, Power BI, VS-code and deployment of packages in SSMS to subordinates. Developing cost effective vendors through spend analysis. Taken training on Power automate.

Responsible for direct sourcing of materials for different product lines such as Pressure pumping. Developing cost effective vendors through spend analysis. Category analysis RUCA(Russia caspian region). Vendor rating for parameters based on category such as price, quality and service. Resolving GR and Invoice and payment issues. Plant rating for (RUCA) and APAC region. Successfully executed the savings of 40Million including inventory netting and supplier negotiation.

MIS executive