Sachin Shinde
Pune
Summary
Experienced data analyst with 8 years of expertise in interpreting and analyzing data to drive successful business solutions within supply chain management. My background includes a strong analytical skill set and the ability to collaborate effectively with others. I am actively seeking a position where I can leverage these skills to contribute to a dynamic team.
Overview
7
7
years of professional experience
Work History
Sr. Supply Chain Analyst
Ecolab Food Safety & Hygiene Solutions Pvt. Ltd
Pune
2024.02 - Current
- Working on Project Management and Stakeholder relation management
- Manage the workspace in terms of Publishing new ports, Creating Apps, and updating the Dashboard
- Completed the training on “Microsoft Fabric” through Microsoft Platform
- Weekly call for project updates and project review
- As Sr. Data Analyst review the Power BI report created by Peers before publishing and validate.
- Trained junior analysts on best practices in data mining and visualization tools.
- Working on Report Standardization and merging Datasets to avoid duplications.
- Worked closely with customers to understand their needs and develop solutions that meet their requirements.
- Merge Data models with 80% Similarities and standardize the reports.
- Collaborated with cross-functional teams across departments such as sales, marketing, finance.
- Established KPI metrics and monitored performance of Blocked Inventory, WHSL and Shipment Metrics.
Data Analyst – Sourcing
Toro Technology Centre Pvt. Ltd.
Pune
2022.05 - 2024.02
- Analyze the request and conduct the data assessment in order to full fill the request.
- Create the visuals to represent the data with Power Bi.
- Help Buyers to update the JIT(Demand) to SAP and validate it with Forecast and compare pricing and find out the total impact.
- Prepare monthly spend report commodity wise and publish it on Power BI for all stake holders.
- Analyze the invoices in the SAP(Due/Not Due) and generate the report to forecast the total payment for the upcoming months.
- Also, add new tool to the Profile i.e Microsoft Power Apps and Power Automate and fulfill the Workflow requirements.
- Completed 4 Power Apps during my Tenure.
- Collect data and analyze if the requirement can be fulfilled and any changes to the requirement will be needed.
- Have regular calls with Project owner/Stake holders and provide timely update on the projects.
- Monthly work on the MPV report and Total Spend and Forecast for next month.
- Validate the forecast against the current data for the accuracy
- Work on the Cost Opportunity supplier wise to get the leverage for the price negotiations based on the forecast and last 3 years purchase.
Data Analyst – Supply Chain
Accenture Solution Pvt. Ltd.
Pune
2020.05 - 2022.06
- Evaluate opportunities and assess spend categories for sourcing. Provide assistance to other commodity managers in strategic sourcing tasks, including facilitating negotiations with business owners to establish contract terms and conditions
- Conduct industry research on best-in-class suppliers for their sourcing responsibility Develop and implement plans to drive KPIs for assigned categories (productivity, working capital, service level improvement and supplier quality).
- Provide timely procurement performance KPI reports to management using Power Bi and SQL
- Work to support Manager and provide guidance and direction to analyst professionals through successful sourcing engagements
- Simplifying and automating reporting dashboards by build solutions to have maximum scale and self-serviceability by users
- Recognizing and adopting best practices in reporting and analysis: data integrity, dashboard design, analysis, and documentation Researched and resolved issues regarding integrity of data flow into databases
- Design, implement, and support business processes and challenges related to planning, supply chain and manufacturing
- Analyze opportunities and conduct assessments
- Gather Data from multiple sources and provide insights and recommendation using report and Power BI visualization
Junior Analyst - Supply Chain Management
Eaton Technologies Pvt. Ltd.
Pune
2017.10 - 2020.05
- Responsible for creating Purchase order through requisitions and quote and helping suppliers with logistics options for different shipments
- Analyze RFx responses to build cost models, answer questions to support category teams Build the category metrics model based on input from the category team to track and monitor performance to the category strategy Expediting and clearing vendor payments and resolving pricing issues
- Partnering with various Business and Technical team to get all access during the transition, also regularly coordinating with technical team to enhance system for development
- Individual contributor for most of BI activities involves, Report generation, Report automation, Dashboard creation on Power BI and Excel
- Identify sourcing opportunities and areas for improvements in the Sourcing process, through analysis of historical events, performance, and trends
- Leading supplier negotiations ensuring a framework for a strategic contractual relationship with limited risk
- Creating Power BI Reports and Dashboards for enabling customers to easily view the performance
- Directing data cleansing activities via Master Data Summary (MDS) for raw materials & vendors
- Work with sourcing leads to prioritize and validate top opportunities for savings projects and support/drive project execution.
Purchase Engineer
Technokraten LLP
Pune
2016.08
- Assist Buyer with providing information to Visual on in-store promotion strategies and placement of markdown goods Assist in monthly/seasonal markdown sessions
- Assist the Buyer with developing the seasonal assortment strategies
- Assisted Associate Buyer in reconciling discrepancies related to Purchase Orders
- Assisted the Buyer in completing the forecast
- Communicated initial set up and ongoing changes of ‘pre-sell’ product to accurately reflect delivery expectations
- Created seasonal final binders and boards that reflect committed buys
- Adopted supplier management methodologies and purchasing strategies to secure improved prices
- Interpreted engineering drawings, part lists and production bills of materials to make informed purchase decisions.
Education
Advance Certification in Data Science – Business Intelligence -
IIIT Bangalore and Upgrad
11.2023
PGDM - Supply Chain Management -
Symbiosis Centre for Distance Learning and International University
12.2020
Bachelor of Engineering -
SKN Sinhgad Institute of Technology and Science's, Pune, India
Pune, India06.2016
HSC -
RBNB, College of Science and Arts Shrirampur, India
Shrirampur, India06.2011
SSC -
SJPV, Shrirampur, India
Shrirampur, India06.2009
Skills
- Python
- Snowflake
- Supply Chain Management
- MS Fabric
- Business Intelligence
- Data Mining
- Data Modeling
- Business Analysis
- Tail Spend/Spend Analysis
- Power BI (Power Query, Power Pivot, DAX, Power View)
Personal Information
- Date of Birth: 11/06/1991
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Languages
Marathi
First Language
English
Advanced (C1)
C1
Hindi
Upper Intermediate (B2)
B2
Timeline
Sr. Supply Chain Analyst
Ecolab Food Safety & Hygiene Solutions Pvt. Ltd
2024.02 - Current
Data Analyst – Sourcing
Toro Technology Centre Pvt. Ltd.
2022.05 - 2024.02
Data Analyst – Supply Chain
Accenture Solution Pvt. Ltd.
2020.05 - 2022.06
Junior Analyst - Supply Chain Management
Eaton Technologies Pvt. Ltd.
2017.10 - 2020.05
Purchase Engineer
Technokraten LLP
2016.08
Advance Certification in Data Science – Business Intelligence -
IIIT Bangalore and Upgrad
PGDM - Supply Chain Management -
Symbiosis Centre for Distance Learning and International University
Bachelor of Engineering -
SKN Sinhgad Institute of Technology and Science's, Pune, India
HSC -
RBNB, College of Science and Arts Shrirampur, India
SSC -
SJPV, Shrirampur, India