Summary
Overview
Work History
Education
Skills
Websites
Projects
Awards
Responsibilities Held
Timeline
Generic

Karthick Devaraj

Bangalore,India

Summary

Results-driven Business Analyst with a proven track record at The Brooklyn Creamery, leveraging Power BI and SQL to enhance order fulfillment efficiency by 10%. Adept at designing predictive models and optimizing data processes, while fostering collaboration across teams to drive impactful business solutions. Strong analytical skills combined with effective communication.

Overview

5
5
years of professional experience

Work History

Business Analyst

The Brooklyn Creamery
Bangalore, India
03.2021 - 11.2022
  • Analyzed online delivery sales data from multiple platforms (Swiggy, Zomato, and direct website orders) to identify customer purchase patterns, leading to a 10% improvement in order fulfillment efficiency
  • Developed and maintained a real-time order tracking dashboard using Power BI and SQL, integrating data from various sources to provide daily sales insights to management
  • Optimized SQL queries for the company's online sales database, reducing report generation time by 30%, ensuring faster decision-making
  • Implemented automated ETL pipelines to extract and transform online order data from third-party delivery platforms into the company's internal data warehouse, reducing manual data processing by 50%
  • Designed and deployed predictive models using Python and Power BI to forecast demand fluctuations in online orders, helping reduce stock shortages by 12%
  • Collaborated with marketing and operations teams to analyze the impact of discount campaigns and delivery fees, leading to a 7% increase in profit margins
  • Scoped, designed, and configured custom business solutions to enhance order processing workflows, reducing average order dispatch time by 20%

Business Analyst

UberEats India
Bangalore, India
11.2017 - 01.2020
  • Focused on managing discount budgets for restaurants, optimizing promotional strategies to drive customer engagement
  • Conducted fraud analysis to identify and mitigate fraudulent activities, enhancing overall security and reliability of operations
  • Developed Power BI reports for business insights, aligning with the reporting requirements of this role
  • Utilized Business Systems, SQL Server Reporting Services (SSRS), and additional tools to streamline reporting and data analysis processes
  • Designed and automated 15+ dashboards in excel, ensuring real-time business insights for stakeholders
  • Implemented data validation and compliance audits across 500K+ records, enhancing data integrity and reporting accuracy
  • Designed a dashboard integrating JIRA issues with test cases in Zephyr, facilitating streamlined issue tracking and test management
  • Utilized Telescope and UQuery Uber dashboards to provide comprehensive and real-time visibility into operational performance, improving decision-making across teams
  • Analyzed data from Telescope and UQuery to track and optimize courier operations, ensuring efficient delivery performance and operational excellence

Education

MS - Data Analytics

Swinburne University

Skills

  • Spark
  • Hadoop
  • Kafka
  • Streaming
  • AirFlow
  • Hive
  • Visualization
  • Warehousing
  • Ingestion Pipelines
  • Delta Lake
  • Python
  • Data Structures and Algorithms
  • Power BI
  • BigQuery
  • Excel
  • SQL
  • Tableau
  • Matplotlib
  • Seaborn
  • MySQL
  • MongoDB
  • AWS
  • PostgreSQL
  • Windows
  • Linux
  • Jupyter
  • Django
  • Flask API

Websites

Projects

AI-Driven Laboratory Design Tools, Developed a secure, scalable backend with FastAPI, integrating AI models (GPT-3.5, DALL-E) and databases (PostgreSQL, MongoDB) to support real-time content generation for promoting ISO/TC 336 standards. Spotify ETL Pipeline, Developed a serverless ETL pipeline using AWS (S3, Lambda, Glue, Athena) to extract Spotify data via API, transform it with Python (Pandas), and load it into a Glue Data Catalog for querying. Automated workflows using EventBridge and S3 triggers, enabling efficient and scalable data processing.

Awards

  • Spot Award, UberEats, Recognized for achieving key performance metrics (KPIs) for restaurant partnerships and customer support in Bangalore, India.
  • Web Scraping with Python, Ryan Mitchell, View on LinkedIn
  • SQL for Data Analysis, Nikiya Simpson, View on LinkedIn

Responsibilities Held

  • Technical Events Head: ABACUS'17, a National Level Computer Science Technical Symposium, CEG.
  • Workshop Organizer: Speaker of the workshop 'DATA SMART' in the 4CCon-2nd National Conference of Free Software Movement of India 2017.
  • Event Organizer: Conducted online programming contest in Kurukshetra'16, a National Level Techno-Management Fest.

Timeline

Business Analyst

The Brooklyn Creamery
03.2021 - 11.2022

Business Analyst

UberEats India
11.2017 - 01.2020

MS - Data Analytics

Swinburne University

Similar Profiles

CREATE PROFILE
Karthick Devaraj