I am a results-driven business analyst with 4+ years of experience leveraging SQL, Python, and BI tools across e-commerce and retail to turn data into strategic decisions. I specialize in financial planning, P&L analysis, statistical modeling, and dashboard automation. I partner with cross-functional teams to translate data into actionable insights, delivering measurable ROI improvements, more accurate forecasts, and streamlined reporting through automated ETL pipelines and AI-powered analytics.

Arkaprabha Ray

I am a results-driven business analyst with 4+ years of experience leveraging SQL, Python, and BI tools across e-commerce and retail to turn data into strategic decisions. I specialize in financial planning, P&L analysis, statistical modeling, and dashboard automation. I partner with cross-functional teams to translate data into actionable insights, delivering measurable ROI improvements, more accurate forecasts, and streamlined reporting through automated ETL pipelines and AI-powered analytics.

Available to hire

I am a results-driven business analyst with 4+ years of experience leveraging SQL, Python, and BI tools across e-commerce and retail to turn data into strategic decisions. I specialize in financial planning, P&L analysis, statistical modeling, and dashboard automation.

I partner with cross-functional teams to translate data into actionable insights, delivering measurable ROI improvements, more accurate forecasts, and streamlined reporting through automated ETL pipelines and AI-powered analytics.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent
German
Intermediate
Hindi
Fluent
Bengali
Fluent

Work Experience

Business Analyst at Cosmo Beauty Brand House GmbH
August 1, 2025 - August 1, 2025
Led end-to-end business analysis across sell-in/sell-out performance, pricing, supply chain, and product lifecycle (200+ SKUs). Partnered with brand, category, and key account teams to drive double-digit YoY growth and improve forecast accuracy by 15%. Created logistics performance dashboards tracking 3PL and retail KPIs, achieving 98% delivery quality and 97% on-time fulfillment. Designed and automated ETL pipelines using SQL (BigQuery, PostgreSQL) and SAP Analytics Cloud (SAC), improving reporting speed and efficiency by 35%, leveraging AI-powered insights (SAP Joule, Predictive Analytics) to generate forecasts, uncover trends, and enhance decision-making accuracy. Developed and implemented A/B testing frameworks for pricing, creative, and promotions, with post-launch dashboards that increased campaign ROI by 20% and enhanced future sales forecasting. Conducted P&L and profitability analyses to guide pricing strategy and led KPI workshops aligning operational performance with strateg
Operations Manager at Her One GmbH
August 1, 2023 - August 1, 2023
Oversaw end-to-end supply chain planning and operations for wellness products, integrating procurement, demand planning, and 3PL logistics. Built and automated forecasting models and campaign simulators in Google Sheets and Excel, reducing manual reporting effort by 30% and minimizing out-of-stock risks by 20%. Consolidated Shopify and Amazon Sales data into centralized BI dashboards, enabling retention analysis, ROI tracking, and improved decision-making for marketing and supply teams. Managed vendor relations and 3PL performance, enforcing SLA compliance and achieving 96% on-time delivery. Partnered with finance and operations teams to align demand forecasts with procurement budgets and cash flow planning.
Operations and Logistics Analyst at Vanilla Steel GmbH
March 1, 2023 - March 1, 2023
Designed and maintained Tableau dashboards to monitor real-time logistics KPIs, delivery performance, and 3PL operations across international markets. Utilized Power Query and advanced Excel automation to digitize product catalogues and streamline data pipelines, improving reporting speed and accuracy. Delivered actionable insights on auction dynamics, RFQ performance, and eShop pricing, driving conversion optimization and competitive positioning. Developed and standardized operational documentation while monitoring supplier SLAs to ensure consistent service quality and on-time delivery. Partnered with account management and finance teams to automate invoice and PO workflows, increasing transparency and reducing reconciliation time. Conducted pricing and logistics data analyses to evaluate market competitiveness and optimize freight cost structures in the B2B metals marketplace. Supported product testing, QA, and feature rollouts via Jira and Confluence, ensuring alignment between busi
Logistics Operator at Amazon
August 1, 2021 - August 1, 2021
Managed end-to-end inbound and outbound logistics workflows, consistently achieving EU-level KPIs for pick rate, dispatch accuracy, and throughput efficiency. Conducted root cause analyses of operational incidents, delivering data-backed corrective actions to minimize shortages, damages, and process losses. Optimized labor allocation and standard operating procedures (SOPs) using real-time performance tracking, improving workforce utilization and shift productivity. Supported continuous improvement (CI) initiatives focused on process optimization, contributing to reduced downtime and faster order execution. Collaborated with shift leads and operations managers to align floor planning, inventory flow, and KPI reporting.
Production and Logistics Intern at Vivere GmbH
August 1, 2020 - August 1, 2020
Developed Excel-based raw material forecasting models and supported lean production scheduling, reducing overstocking and improving automation efficiency across multiple product lines. Analyzed production, inventory, and logistics workflows using Google Data Studio (Looker), recommending continuous improvement initiatives that removed bottlenecks and increased plant throughput. Coordinated procurement and supplier negotiations, tracking inbound and outbound shipments to align material availability with real-time demand forecasts. Documented and standardized SOPs for 3PL, warehouse, and FBA/D2C operations, reducing onboarding time for new staff and improving operational consistency. Collaborated with production and planning teams to integrate data from ERP and logistics systems, ensuring accurate visibility of materials and order flow.

Education

Bachelor of Science in Mechanical Engineering at Hochschule Rhein-Waal
January 1, 2016 - January 1, 2021

Qualifications

OCI Generative AI professional
November 1, 2025 - November 10, 2025
Data Analytics Essentials
September 1, 2025 - November 10, 2025
Forward Learning
July 1, 2025 - November 10, 2025
Cyber Awareness
October 1, 2024 - November 10, 2025

Industry Experience

Retail, Manufacturing, Transportation & Logistics, Wholesale & Distribution, Professional Services