Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Project Tools
Supply Chain Management
Personal Information
Erp Crm
Timeline
Generic
Hemant Patil

Hemant Patil

DATA ANALYST
Pune

Summary

Experienced Data Analytics & BI Professional with 6+ years of expertise in data analytics & Analysis, Business Analysis, intelligence, and reporting. Skilled in SQL, Python, Power BI, ETL and SAP, delivering actionable insights for decision-making. Proficient in supply chain analytics, procurement, MDM optimizing data processes. Adept at data visualization, automation, and cross-functional collaboration within Agile methodologies to improve operational efficiency

Overview

7
7
years of professional experience
3
3
years of post-secondary education
3
3
Certifications
4
4
Languages

Work History

Consultant

Aligned Automation
PUNE
12.2022 - Current
  • Designed and implemented interactive dashboards in Power BI using DAX to create dynamic calculations and track key performance metrics, enabling data-driven decision-making
  • Used Python, including libraries like numpy and pandas, for efficient data handling, cleaning, and manipulation to support analytical and reporting tasks.
  • Skilled in data processing, cleansing and data governance to maintain accurate and well-structured data for strategic analysis and decision-making.
  • Led end-to-end project lifecycle including Business Requirement Document (BRD) preparation, User Acceptance Testing (UAT), and successful project deployment, ensuring timely delivery and stakeholder alignment
  • Involved in Power BI components like power query editor, power view, power pivot, power map.
  • Developed and optimized SQL scripts to efficiently query data required for analysis and project execution.
  • Collaborated with stakeholders across multiple departments to gather requirements and ensure accurate, comprehensive project documentation including BRDs, process flows, and UAT sign-offs.
  • Analyzed a $341 million USD spend for the Technical Services category in a Buy vs. Rental project, achieving $14 million in savings through data-driven decision-making
  • Led a tail spend management Analytics project, achieving a 14% reduction in total spend through data analysis, vendor consolidation, and vendor deletion strategies
  • Expertise in buying and procurement, managing vendor relationships, contract negotiations, and purchase order execution

Data Analyst

British Petroleum
Pune
02.2021 - 08.2022
  • Developed a Power BI dashboard using DAX to assess carrier efficiency, integrating multiple data sources for real-time performance insights.
  • Developed an Export Vessel Fill Rate tool in Python to optimize container load utilization, increasing efficiency from 67% to 92%.
  • Involved in creating the workspaces and apps, gateways for refreshing the reports.
  • Utilized SQL to extract, transform, and analyze data, integrating it into internal systems to streamline workflows and enhance operational efficiency for global teams.
  • Maintained master data (Vendor & Customer) for oil and gas products, ensuring data consistency across SAP and Salesforce.
  • Performing data cleansing, data preprocessing, data transformation and data manipulation of huge product and customer data.
  • Develop and maintain standard process documents in a well-structured and organized manner, ensuring all essential details are accurately recorded.

Supply Chain Business Analyst

Tata Motors
Pune
10.2018 - 01.2021
  • Leveraged SQL processes and Power BI to analyze procurement data, optimize sourcing strategies, and develop interactive dashboards to monitor supplier performance.
  • Preparing database of all projects including the status of under development parts and creation of dashboard in Power Bi.
  • Part of power Bi dashboard team and responsible for creation of dashboard for BS6 projects.
  • Involved in Power BI components like power query editor, power view, power pivot.
  • Involved in connecting with different data sources like excel, SQL SERVER, SharePoint.
  • Negotiated contracts with suppliers, achieving cost savings while maintaining quality and compliance with company standards.
  • Overlooked Procure to Pay (P2P) processes, ensuring timely processing of invoices, matching them with purchase orders.
  • Skilled in supply chain planning, ensuring demand forecasting, capacity planning, and resource allocation for seamless operations.

Education

Bachelor of Engineering - Mechanical

Pune University
PUNE
07.2015 - 07.2018

Skills

Certification

Advanced Data Science & AI, 12/11/24, Skill slash institute

Accomplishments

  • Innovator of the quarter, BP, 2021, Recipient of 'Innovator of the quarter Award as a recognition for improvement in process.
  • Commitment to Excellence Award, TATA MOTORS, 2019, Recipient of 'Excellence awards as a recognition of successful completion of BS6 project.
  • Automation Award, Aligned Automation, 2024, Recipient of 'Best Automation' Award for automation of savings calculation process using python.

Project Tools

  • JIRA
  • Monday.com

Supply Chain Management

  • Contract Management
  • Procure to Pay
  • Stakeholder management
  • Material Planning and buying
  • Lean six sigma

Personal Information

Date of Birth: 09/09/96

Erp Crm

  • Salesforce
  • SAP MDG
  • SAP MM
  • SAP PLM
  • Teamcenter
  • SharePoint

Timeline

Consultant

Aligned Automation
12.2022 - Current

Data Analyst

British Petroleum
02.2021 - 08.2022

Supply Chain Business Analyst

Tata Motors
10.2018 - 01.2021

Bachelor of Engineering - Mechanical

Pune University
07.2015 - 07.2018

Similar Profiles

CREATE PROFILE
Hemant PatilDATA ANALYST