Shantan Tanuku
London,United Kingdom
Summary
A results-driven Data and Business Analyst with over 5 years of experience in supply chain management, cost optimization, data analytics, and business process transformation across finance, automotive, retail, and customer care industries. Proven expertise in optimizing supply chain operations, developing real-time reporting systems, and implementing AI-driven solutions to improve efficiency, reduce costs, and drive strategic decision-making. Specialized in building and automating real-time dashboards that provide actionable insights to key stakeholders and enhance business performance. Strong background in cost optimization initiatives, leading to significant savings and improved operational efficiency. Skilled at collaborating with cross-functional teams to design and implement solutions that integrate business requirements with technology systems. Proficient in Agile methodologies, process automation, and data visualization using Power BI, Tableau, SQL, and Python. Expertise in translating complex data into user-friendly insights and working closely with clients to define project scope, prioritize backlogs, and deliver business value.
Overview
6
6
years of professional experience
1
1
year of post-secondary education
Work History
Supply Chain Optimization | Data Analyst
Scuderia Car Parts
London
06.2023 - Current
- End-to-End Supply Chain Management : Managed a network of 20+ suppliers across the UK & Europe, ensuring seamless procurement of high-value automotive components requiring specialized handling and compliance.
- Warehouse & Fulfilment Strategy – Led inbound logistics and centralized inventory operations at Barnsley, UK, optimizing stock levels and enhancing B2B order fulfilment efficiency.
- AI-Driven Pricing & Revenue Growth – Led the implementation of a Python & SQL-powered dynamic pricing model, integrating competitor analysis, stock availability, and lead time predictions, resulting in a 20% increase in sales and higher profit margins.
- Strategic Procurement & Cost Optimization – Conducted data-driven supplier analysis, identifying vendors based on lowest cost, fastest fulfilment, and reliability metrics, ensuring cost-effective procurement while improving supplier performance.
- Shipment Route Optimization & Cost Reduction – Planned and assessed an AI-driven route optimization strategy, identifying the most cost-efficient shipping routes and suppliers based on pricing, lead times, and transit reliability. This analysis lowered logistics costs, improved fulfilment speed, and enhanced customer satisfaction by ensuring timely deliveries.
- Freight Consolidation & Logistics Optimization – Reviewed and implemented shipment consolidation strategies, grouping orders to maximize bulk shipping discounts while ensuring timely order processing and cost savings. This approach reduced freight expenses without impacting service levels.
- Process Documentation & Improvement Planning – Documented all key business processes, system implementations, and optimizations to track improvements, ensure compliance, and facilitate further scalability. Developed standard operating procedures (SOPs) and visual workflows to enhance process transparency and operational efficiency.
- ERP Integration & System Enhancement – Managed the integration of Sage with the ERP system via SharePoint and Power Automate, automating data extraction and posting, reducing manual errors and improving data accuracy.
- Financial Reporting & Analysis – Created detailed financial reports for revenue vs. sales data reconciliation, ensuring accuracy for both internal and external stakeholders.
- Budget Planning & Forecasting – Collaborated with finance teams to improve budgeting accuracy, integrating historical financial trends, sales forecasts, and supply chain costs into predictive models.
- Data Analysis & Cost Management – Developed automated variance analysis models to compare revenue and sales reports, identifying discrepancies and improving financial accuracy.
- Expense & Cost Control Optimization – Conducted thorough cost analysis across supply chain and marketing functions, identifying inefficiencies and implementing cost-saving measures, leading to substantial operational savings.
- Power BI-Driven Operational & Financial Insights – Designed and deployed interactive Power BI dashboards to provide real-time visibility into supply chain, logistics, and financial performance metrics.
- Inbound & Outbound Lead Time Analysis – Monitored supplier-to-warehouse and warehouse-to-customer transit times, identifying delays and optimizing fulfilment schedules to improve service levels.
- Inventory Turnover & Stock Efficiency – Analysed demand fluctuations, improved replenishment cycles, and prevented overstocking and stockouts by leveraging data-driven forecasting models.
- Supplier Performance & Procurement Cost Analysis – Evaluated vendor efficiency, tracking cost fluctuations, fulfilment speed, and on-time delivery performance to improve supplier negotiations and purchasing decisions.
- Freight & Logistics Cost Monitoring – Created a real-time freight cost tracking dashboard, identifying cost-saving opportunities in carrier selection, route planning, and fulfilment execution.
Financial Performance Dashboards – Built Power BI dashboards integrating SQL queries & Excel-based financial data, providing clear, actionable insights for executive decision-making. - Revenue Optimization & Pricing Strategy – Developed an AI-driven dynamic pricing model using Python and SQL, integrating real-time sales trends, competitor pricing, and market demand, leading to a 20% increase in sales and improved profit margins.
- Process Automation & Data Quality – Automated financial data workflows using Python scripts and ETL pipelines, ensuring timely and accurate data integration across multiple systems.
- ERP Data Structuring & User Field Optimization – Designed and optimized user-defined fields in ERP systems to improve financial reporting accuracy, enhance budget tracking, and streamline operational processes.
- Cross-Functional Collaboration & Business Impact – Worked closely with finance, sales, and marketing teams to ensure that supply chain adjustments, pricing strategies, and financial reporting optimizations directly contributed to cost control, revenue growth, and enhanced customer experience.
- Continuous Improvement & Performance Benchmarking – Established data-driven performance tracking systems, continuously refining procurement, logistics, financial, and pricing models to drive cost savings and operational efficiency.
Artificial Intelligence Developer
Icom Solutions City
City of London
11.2022 - 03.2023
- Customer Sentiment Analysis: Designed AI models using NLP in Python for sentiment analysis, classifying customer feedback from multiple channels. Enabled proactive responses, reducing churn and enhancing user experience.
- Predictive Analytics for Customer Experience: Built multi-class prediction models to categorize customer interactions, addressing key pain points and tailoring services, leading to improved satisfaction scores.
- Python-Driven Automation: Automated data processing and real-time analysis using Python, accelerating insights and enabling agile strategy adjustments based on customer trends.
- Voice of Customer (VoC) Analysis: Employed IBM Watson to convert call centre speech data into text, facilitating analysis and actionable insights, reducing manual effort and improving service quality.
- Exploratory Data Analysis (EDA): Conducted EDA in Python to uncover trends in customer behaviour, using heatmaps and visualizations to inform strategic enhancements in customer engagement.
- AI Model Optimization: Refined 12 AI models for customer identification, increasing accuracy and responsiveness. Regular validation ensured high confidence levels and personalized customer support.
Tableau Developer
Styxtech
City of London
06.2022 - 10.2022
- Dashboard Development & Data Visualization: Designed strategic Tableau dashboards for Sales, Finance, and IT teams, improving decision-making. Applied best practices, increasing user comprehension and adoption by 30%.
- SQL & Data Extraction: Built efficient SQL views for data extraction, boosting report accuracy and reducing retrieval time by 40%. Collaborated with data engineering teams to ensure high data integrity and seamless access.
- User Training & Enablement: Led Tableau training sessions and workshops, enhancing data analysis skills for 50+ business users. Developed training materials, increasing self-service analytics by 25%.
- Tableau Server Administration: Managed Tableau Server performance and security, maintaining 99.9% uptime. Optimized server settings, reducing load times by 20% and improving user experience.
- Technical Documentation & Requirements Translation: Documented processes and translated requirements into technical specifications, accelerating project delivery by 15%. Ensured clear communication between technical and business teams, enhancing project outcomes and user satisfaction.
Associate Data Analyst
V2VALUE BIZ Solutions Private Limited
Hyderabad
06.2019 - 12.2020
- BAU : Transaction Classification: Developed robust system using Python and SQL for classifying transactions by advertiser brand, purchase channel, purchase type, geographic location, and category vertical. Streamlined data organization enabled faster, more accurate analysis and decision-making.
- Rule Corpus Building: Collaborated in building comprehensive rule corpus, defining classification rules and patterns using Python. Established reliable foundation for accurately categorizing large-scale transaction data.
- Regex Query Optimization: Designed and executed complex SQL queries with regular expressions (Regex) to extract brand names from millions of transaction records. Optimized query performance, reducing manual extraction time and improving brand identification accuracy.
- Automated Merchant Identification Using Clustering: Led development of automated clustering pipeline in Python to identify unknown merchants in transaction data. Utilized advanced pattern recognition techniques for efficient merchant identity assignment.
- Efficiency Gains for Merchant Intelligence Team: Implemented automated solutions using Python, reducing manual workload for 25-member team, saving significant time and resources by eliminating manual pattern detection tasks.
- Scalable Brand Data Analysis: Enhanced brand data analysis framework using SQL and Python, scaling system capacity from thousands to millions of merchants with minimal manual intervention.
- Location Corpus Automation: Developed comprehensive USA location corpus using Python, standardizing geographic data for improved accuracy in Master Location Capture (MLC) model. Automated location data validation and standardization processes.
- Custom Spell-Checker Logic: Created custom spell-checking algorithm in Python to correct and standardize city names within transaction data. Cross-referenced with ZIP codes and state attributes, significantly improving data reliability and accuracy.
Intern Data Analyst
V2Value BIZ Solutions Private Limited
Hyderabad
01.2019 - 05.2019
- Data Interpretation and Statistical Analysis: Analysed complex datasets using statistical techniques and programming languages like Python and R. Provided insights that informed business strategies and supported decision-making.
- Data Processing and Integrity Verification: Conducted extensive data processing, cleaning, and verification to ensure integrity and accuracy. Critical preparation steps enabled reliable, insightful analysis.
Interactive Data Visualizations and Reporting: Created interactive visualizations and reports to communicate insights to non-technical stakeholders. Enhanced team’s ability to make data-driven decisions effectively. - Feature Selection and Model Optimization: Identified relevant features for machine learning models, optimizing classifiers to enhance model performance. Strengthened machine learning expertise, resulting in more accurate predictive insights.
Education
MSc - Data Science
Kingston University
London 01.2021 - 06.2022
Bachelors Of Technology - Mechanical Engineering
Pragati Engineering College
IndiaSkills
- Power BI
- Python
- Excel
- SQL
- Quantitative & Quantitative Analysis
- HubSpot CRM
- Cost Analysis
- Pricing Strategies
- Data Science
- Google Analytics
- Machine learning
- Predictive modelling
- Statistical Analysis
- Data Visualisation
- Pricing strategy development
- Marketing strategy development
Timeline
Supply Chain Optimization | Data Analyst
Scuderia Car Parts
06.2023 - Current
Artificial Intelligence Developer
Icom Solutions City
11.2022 - 03.2023
Tableau Developer
Styxtech
06.2022 - 10.2022
MSc - Data Science
Kingston University
01.2021 - 06.2022
Associate Data Analyst
V2VALUE BIZ Solutions Private Limited
06.2019 - 12.2020
Intern Data Analyst
V2Value BIZ Solutions Private Limited
01.2019 - 05.2019
Bachelors Of Technology - Mechanical Engineering
Pragati Engineering College
Similar Profiles
Filimon WeldemichaelFilimon Weldemichael
Warehouse worker at Euro Car PartsWarehouse worker at Euro Car Parts
Leah RobinsonLeah Robinson
Regional administrator - South East at LKQ Euro Car PartsRegional administrator - South East at LKQ Euro Car Parts
Callum ThomCallum Thom
Stocktaker at ASV Euro Car PartsStocktaker at ASV Euro Car Parts