About
Data Analyst with 3+ years of experience transforming complex ERP and operational datasets into actionable insights that drive cost optimization and operational efficiency. Expertise in SQL, Power BI, and Advanced Excel to deliver supplier performance analytics, spend analysis, and executive dashboards. Proven track record of contributing to 1-1.5% cost reduction on high-value procurement spend through data-driven decision-making. Strong collaboration across procurement, finance, and engineering teams with domain expertise in infrastructure, FMCG, and technology environments.
Skills & Expertise (17)
Work Experience
Data Analyst (Procurement)
SUCG Infrastructure India Pvt Ltd
Sep 2021 - Jan 2024
Built complex SQL queries analyzing 50,000+ procurement records to track supplier performance, delivery delays (average 15-day variance), quality defects, and post-delivery service metrics. Conducted cost optimization analysis across major materials and logistics categories, contributing to 1-1.5% cost reduction (500K+ annual savings) on high-value procurement spend. Developed supplier risk assessment framework using Python and SQL, scoring 150+ suppliers on historical performance, financial indicators, and delivery reliability. Identified procurement trends and anomalies through time-series analysis of 2+ years historical data, supporting proactive sourcing decisions and reducing stockouts by 25%. Translated engineering and commercial requirements into data-driven RFP evaluation frameworks, processing 30+ RFPs with quantifiable scoring metrics.
Analyst - Operations
DotPe
Mar 2021 - Aug 2021
Developed and optimized 30+ SQL queries supporting finance and sales reporting for 10,000+ daily transactions. Created analytical reports using Excel and Power BI enabling revenue tracking, identifying 15% revenue growth opportunities. Performed data validation and quality checks ensuring 95%+ accuracy during monthly reporting cycles.
Assistant Engineer - Procurement Analytics
SUCG Infrastructure India Pvt Ltd
Jul 2018 - Aug 2020
Extracted and analyzed ERP (Tally) data covering 100,000+ records related to POs, consumption, inventory, and vendor transactions using SQL and Excel. Designed and maintained 3 store and asset dashboards monitoring material utilization and stock movement for $5M+ inventory. Created structured item master data models (5,000+ SKUs with codes, categories, pricing) improving reporting accuracy by 30%.
Data Analyst - Procurement & Contracts
Shanghai Tunnel Engineering Co., Ltd.
Feb 2024 - Present
Analyzed multi-source procurement datasets (POs, invoices, claims) serving 500+ transactions monthly, generating insights that informed $10M+ sourcing decisions for senior stakeholders. Designed 5+ interactive Power BI dashboards tracking procurement KPIs (supplier lead time, cost variance, quality performance, savings realization) with drill-down capabilities, reducing reporting time by 60%. Conducted spend analysis and supplier benchmarking across 200+ vendors using SQL queries, enabling data-backed negotiation strategies that improved supplier terms by 8-12%. Performed contractual risk analysis mapping obligations and claims exposure, identifying $2M+ in potential financial impact through structured dataset analysis. Automated MIS reporting workflows using Power BI and SQL, eliminating 15+ hours of manual reporting weekly and improving data accuracy by 95%. Presented analytical findings to cross-functional teams (procurement, finance, engineering), directly supporting 20+ strategic sourcing decisions.
Education
Bachelor of Technology in Mechanical Engineering - GLA University, Mathura
2014 - 2018 · Afghanistan
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Depends on Offer
