Summary
Overview
Education
Skills
Projects
Achievements
Certification
Hobbies
Timeline
Generic

APRANJAL SINGH

Bareilly,UP

Summary

Highly motivated and results-driven recent graduate with a Bachelor's and Master's degree. Possess a solid foundation in programming languages Python, SQL. Eager to apply academic knowledge and develop professional skills in a dynamic work environment. Demonstrates strong problem-solving abilities, teamwork, and a keen attention to detail. Ready to contribute to the success of a forward-thinking tech company and learn from experienced professionals.

Overview

1
1
Certification

Education

M.TECH - ELECTRONICS AND COMMUNICATION

Dr. APJ ABDUL KALAM TECHNICAL UNIVERSITY
Lucknow, India
01.2024

B.TECH - ELECTRONICS AND INSTRUMENTATION

MJP ROHILKHAND UNIVERSITY
Bareilly, India
07.2019

Skills

  • Proficient in Python Programming language
  • Jupyter Notebook
  • Excellent knowledge of SQL Queries
  • Familiar with Microsoft Excel, VLOOKUP function, Pivot Table
  • Basic concept of Open Computer Vision
  • Data Visualization tools Power BI
  • Good Knowledge of python libraries - NumPy, Pandas, Matplotlib, seaborn
  • Understanding of Data Analysis, Data cleaning, Data processing
  • Strong analytical and Problem Solving skills
  • Excellent communication and teamwork abilities

Projects

1. Music Store Data Analysis.

- Analyzed the sales and inventory data of a music store using SQL to enhance business decision-making and operational efficiency.

- Retrieved data across multiple tables including sales, products, customers and inventory.

- Analyzed Customer purchasing patterns to support targeted marketing campaigns and personalized recommendations.

2. Super Store Sales Data Analysis

- Developed interactive power BI dashboard for super store sales data analysis, enabling stake holders to visualize key metrics and trends at glance.

- Implemented interactive filters and slicers in Power BI dashboards, empowering users to explore sales data dynamically and uncover actionable insights.

- Created geospatial visualizations in Power BI to analyze regional sales performance and identify high-potential markets for expansion.

3. Exploratory Data Analysis.

- Performed exploratory data analysis (EDA) using Pandas, Matplotlib, Seaborn and Jupyter Notebook

- Improved customer experience by identifying potential customers across different states, occupation, gender and age groups.

- Improved sales by identify and most selling product categories and product, which can help to plan inventory and hence meet the demands.

4. Walmart Sales Data Analysis.

-Conducted a comprehensive analysis of sales data for Walmart using MS-Excel to identify trends, patterns, and opportunities for improvement.

- Developed a dynamic and visually appealing dashboard using Excel pivot table features.

- Strong analytical skills combined with the ability to translate data into meaningful insights and actionable recommendations.


Achievements

1.Python- 3 Star Silver medal, Hacker Rank  

2. SQL- 3 Star Silver medal, Hacker Rank 

3. Badge 1- Leet code,SQL

Certification

Oracle SQL ,Data Visualization with POWER BI

Hobbies

Listening music, Travelling, Playing Sports

Timeline

M.TECH - ELECTRONICS AND COMMUNICATION

Dr. APJ ABDUL KALAM TECHNICAL UNIVERSITY

B.TECH - ELECTRONICS AND INSTRUMENTATION

MJP ROHILKHAND UNIVERSITY
APRANJAL SINGH