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
Data Analytics
Power BI
SQL
Python
Advanced Excel
ETL
Dax
Power Pivot
Power Query
Data modelling
ERP & CRM
Salesforce
SAP MM
JIRA
Mondaycom
Supply chain Management
Contract Management
Procure to Pay
Stakeholder management
Material Planning and buying
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