Results-driven Power BI Analyst with over 6 years in data analysis and business intelligence, specializing in procurement analytics. Expert in transforming complex data into actionable insights that enhance cost savings and operational efficiency. Proficient in Power BI, SQL, and Excel, with a strong grasp of supply chain management and vendor performance analysis. Aiming to leverage analytical skills to support strategic decision-making initiatives.
Overview
6
6
years of professional experience
Work History
Senior Associate BI Analyst
Tata Consultancy Services
Chennai
05.2022 - Current
Develop and maintain interactive Power BI dashboards and reports that provide insights into procurement activities, including spend analysis, supplier performance, and contract compliance.
Collaborate with procurement managers to track key performance indicators (KPIs), such as supplier delivery times, cost savings, and order fulfillment accuracy.
Analyze large datasets from ERP and procurement systems (SAP MM and Ariba) to identify trends, opportunities for cost reduction, and areas for process optimization.
Streamline data reporting processes by automating regular procurement reports, and creating self-service analytics solutions for the procurement team.
Implement data governance practices to ensure the accuracy, consistency, and security of procurement data.
Provide actionable insights to procurement stakeholders through clear and compelling visualizations, driving data-driven decision-making for supplier negotiations and procurement strategies.
Create comprehensive procurement analytics presentations for the senior management team, highlighting the procurement team's performance on KPIs.
Collaborated with category teams to optimize working capital, and conducted spend analysis to identify cost-saving opportunities with suppliers.
Procurement Senior Analyst
Flextronics Technologies India Pvt Ltd
Chennai
03.2019 - 05.2022
Partnered with Product Engineering and Category teams to identify new suppliers, gather RFQ data (MOQ, SPQ, price, lead time), and provide insights for sourcing and negotiation.
Coordinated with the Demand Planner to review weekly MRP signals, place purchase orders, and update the ERP with supplier confirmations to ensure on-time delivery, minimize backorders, and optimize inventory shortages.
Managed inventory turnover through pull-ins, cancellations, and push-outs, based on MRP signals.
Creating and maintaining supplier data in ERP systems.
Timely updating of data in the ERP whenever a notification comes from the supplier for changes.
Working with the warehouse team on receiving challenges for the smooth receipt process.
Interacted with local and international suppliers in the Asia and Americas regions in the electrical and electronics segment.
Collaborated with suppliers to address product defects, initiating the Return Material Authorization (RMA) process, and ensuring timely returns and replacements.
Worked with Product Engineering to resolve material issues, ensuring quality standards, and addressing discrepancies quickly.
Partnered with finance and suppliers to resolve invoice discrepancies, ensuring timely payments, and smooth supply chain operations.
Education
BE - Mechanical Engineering
SKR Engineering College
Chennai, TN, India
04-2018
Skills
Data analysis
Data Modeling
ETL and Data Cleaning
Data visualization
Procurement Analytics
Spend analysis
Power BI
SQL
Advanced Excel
SAP MM and SAP Ariba
Accomplishments
Tail Spend Analysis and Cost Reduction: Conducted a thorough analysis of procurement spend for tail spend, identifying high-spend categories with non-contract suppliers. By strategically focusing on these categories, the team negotiated a 15% cost reduction across multiple areas, leading to annual savings of approximately $500K.
Suppliers Optimization and Working capital improvement: Utilized Power BI to conduct a detailed spend analysis across multiple suppliers providing similar products and services, focusing on both pricing and payment terms and presented opportunity to leadership team which improved the cashflow.
Star performer of the quarter for Q1 2023 (Sep-Nov) and Q3 2024 (Mar-May).