• Designed and implemented a robust Alerting framework using Python and AWS services such as Gluejob, Eventbridge, Lambda, and SNS. This framework automated the tracking of out-of-stock products, sales contributions of multiple brands, and overall margin on an hourly basis. By saving $4,500/month and 75-man hours/month, it significantly improved efficiency for the commercial team.• Led the successful migration of data jobs from legacy AWS Data Pipeline to Apache Airflow, resulting in… Show more • Designed and implemented a robust Alerting framework using Python and AWS services such as Gluejob, Eventbridge, Lambda, and SNS. This framework automated the tracking of out-of-stock products, sales contributions of multiple brands, and overall margin on an hourly basis. By saving $4,500/month and 75-man hours/month, it significantly improved efficiency for the commercial team.• Led the successful migration of data jobs from legacy AWS Data Pipeline to Apache Airflow, resulting in asynchronous job execution and reducing job failures by 20%.• Developed a comprehensive cost tracker dashboard on Quicksight, enabling the commercial team to calculate cost variances across the last 5 purchases from various suppliers. This automation eliminated the need for daily manual checks.• Created a logistics dashboard to analyze the number of orders for the GlobalStore on a country and state level, empowering the logistics team to optimize the logistics process effectively.• Implemented a data-driven approach for the CX team by developing custom Word clouds based on machine learning models applied to customer reviews in multiple languages, enabling them to gain valuable insights.• Conducted FBT (frequently bought together) analysis on private label products, identifying trends in data and customer purchase patterns to drive strategic decision-making.• Integrated a framework with Algolia to enhance customer search results through fuzzy matching and translation, extracting actionable insights from the data to improve user experience.• Consistently demonstrated technical expertise and leveraged innovative solutions to deliver tangible business benefits while driving data-driven decision-making across multiple teams. Show less

• Successfully managed end-to-end execution of projects involving the design, implementation, and maintenance of API-driven integrations using Python.• Provided valuable support in developing and maintaining performance metrics, reports, and dashboards for health, CX (customer experience), and audit teams, enabling data-driven decision-making.• Took initiative in establishing and optimizing a streamlined process for data pre-processing, consolidation, and reporting to regulatory bodies… Show more • Successfully managed end-to-end execution of projects involving the design, implementation, and maintenance of API-driven integrations using Python.• Provided valuable support in developing and maintaining performance metrics, reports, and dashboards for health, CX (customer experience), and audit teams, enabling data-driven decision-making.• Took initiative in establishing and optimizing a streamlined process for data pre-processing, consolidation, and reporting to regulatory bodies within the health industry.• Collaborated closely with the sales team to enhance their understanding of sales data by creating materialized views and complex SQL queries. Additionally, defined key performance indicators (KPIs) to support the development of a mobile application.• Applied ElasticSearch technology and integrated it with the Health team App to build a robust fuzzy-based search system using Python, improving the overall user experience. Show less

• Created and deployed automation bots using Selenium to streamline data extraction and ingestion processes, resulting in increased efficiency and accuracy in populating the data warehouse.• Utilized the Scrapy framework to perform web scraping on partner websites, extracting relevant data and seamlessly integrating it into the Data Warehouse.• Collaborated closely with cross-functional teams, including marketing and product teams, to conduct comprehensive analyses. These insights… Show more • Created and deployed automation bots using Selenium to streamline data extraction and ingestion processes, resulting in increased efficiency and accuracy in populating the data warehouse.• Utilized the Scrapy framework to perform web scraping on partner websites, extracting relevant data and seamlessly integrating it into the Data Warehouse.• Collaborated closely with cross-functional teams, including marketing and product teams, to conduct comprehensive analyses. These insights played a pivotal role in driving strategic decision-making and automating repetitive issues for improved productivity.• Leveraged technical expertise and analytical skills to develop innovative solutions and contribute to the overall growth and success of the organization. Show less