PROJECTS
Python-Powered Data Analysis for Business Query Resolution
Leveraged Python programming and pandas library to clean and analyze data, providing actionable insights to
address business queries effectively
● Proficient in data cleaning and analysis methodologies using Python programming language
● Utilized the pandas library extensively to manipulate and transform data sets efficiently
● Applied Python programming skills to address various business queries through comprehensive data analysis
● Recognized for attention to detail in identifying and resolving inconsistencies and errors within data sets
● Demonstrated ability to extract actionable insights from data to facilitate informed decision-making in a
business context
Restaurant Database Management System (RDBMS)
Engineered PostgreSQL database for restaurant operations, enabling efficient data management and insightful
analytics
● Constructed a comprehensive PostgreSQL database for a restaurant, featuring tables for customers, orders,
and food items
● Developed SQL queries to extract pertinent business insights from the database
● Conducted detailed analysis of customer data, including total customer count and order history
● Identified popular and unpopular food items through thorough examination of order data
● Utilized time-based queries to gain insights into daily order volumes and monthly sales
Data Transformation and Analysis with Tidyverse and dplyr
Employed Tidyverse library in conjunction with dplyr to manage and analyze the nycflights13 dataset, facilitating data
transformation processes within the R environment.
● Utilized Tidyverse and dplyr to efficiently manage and analyze the nycflights13 dataset.
● Applied advanced data transformation techniques to preprocess and derive insights from the dataset.
● Demonstrated proficiency in data manipulation, filtering, and summarization using R packages.
● Enhanceddata analysis skills through hands-on experience with real-world datasets.
● Contributed to data-driven decision-making processes by extracting actionable insights from the dataset.