Ravi Garg

Experience

• 

  Avon Technologies (I) Private Ltd.

  Aug 2014 - Nov 2019

  Data Analyst/Engineer
• 

  Amazon

  Apr 2020 - Jul 2023

  Business Data Analyst/Engineer

  Create scalable data solutions using AWS and various Amazon internal toolsWork collaboratively with Business Analysts, Data Scientists, and other internal partners to identify opportunities/problemsDeveloped a stow tool using Python, AWS, Amazon Redshift, SQL and internal amazon tools to efficiently send associates to right aisles and bins to stow items resulting in a significant increase in stow rate per hour by 4%. Developed a staffing tool using Excel macros (VBA) to efficiently assign daily tasks to a team of approximately 200 Associates, resulting in a significant reduction of inferred time by 60-70%.Optimised shift comparison reports by leveraging Excel BA, formulas, and functions to incorporate hourly tracking data, expected goals, and actual goals. This enhancement improved workflow within the warehouse and facilitated better decision-making.Created visually engaging Excel tables and charts to track and analyse the daily goals of the outbound department. This visual representation provided Senior Managers with a clear understanding of the actual rate versus the target rate.Conducted thorough analysis of quality concern cases, including missing or defective products, by running SQL queries on Hubble. Identified and tracked instances of concern to minimize the amount of time products remained unaccounted for.Conducted in-depth research on defect trends to identify patterns and areas for improvement.data collection and entry as needed to support projects.Generated charts and graphs for reporting purposes to effectively communicate data-driven insights.Developed, maintained scalable data pipelines using Apache Spark or Amazon EMR to process and transform large volumes of data efficiently,ETL processes to ingest data from various sources into Amazon S3, Amazon Redshift, or Amazon DynamoDB.AWS Glue and AWS Data Pipeline to automate data workflows, ensure data consistency,reliability.Experience with JSON, internal web data pulls using Python, VBA Show less

• 

  Freelance (Self employed)

  Aug 2023 - now

  Independent Data/Business Analysis Consultant

  E-commerce Analysis: Used AWS for customer analysis, boosting sales by 20%. Developed Python-based sales dashboard for insights.Social Media Sentiment: Conducted Python/NLP sentiment analysis for brand perception.Real-time IoT Pipeline: Designed scalable Kafka/Spark pipeline for IoT data.Sales Forecasting and Customer Segmentation: Employed AWS Glue/Redshift for segmentation, increasing engagement by 30%. Built AWS ML models, improving forecasting accuracy by 15%. Analyzed and predicted churn for retention strategies.Financial Forecasting: Provided strategic insights using Python/SQL for finance data. Created AWS-based dashboard for KPI tracking and insights.Utilized data mining techniques and problem-solving skills to extract valuable insights and solve complex challenges. Show less