Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Certification
Timeline
Generic
N Sanjay Rao

N Sanjay Rao

Business Analyst & Programmer (Basic)

Summary

Bachelor of Technology in Electronics and Communications with a passion for generating data driven insights. Proficient in Structured Query Language and MS Excel for data wrangling. Working knowledge of Python libraries for data analysis. Communicate complex data stories to support decision making. Detail-oriented team player with strong organizational skills. Ability to manage multiple priorities.

Overview

11
11
Certifications
3
3
Languages

Work History

Data Wrangling

Technology used: Excel

Analyzed large sets of sales data in the following three phases

  • Data sense - Analyze gaps in data using data quality framework by checking the data quality dimensions like - Consistency,Completeness,Accuracy,Validity and Timeliness
  • Exploratory data analysis - Identify top performing territories and sales trends for seasonality, market share, market share growth (%)
  • Insights –
  • Key products contributing to top performing territories
  • Market share captured or lost
  • SWOT analysis for territories and products
  • Sales vs Market share growth for territories and key accounts in reference to national average

IoT- Smart Calling Bell and Security System

Technology Used: ESP32 cam board and Telegram Bot
  • Developed wireless calling door bell that can buzz without the need of physical touch and provide live images of the site to monitor outside house door using the following techniques:
  • Esp 32 cam microcontroller - takes pictures and sends it to the telegram bot by passing a command.
  • IR sensor module - detects outside activity and alarm via buzzer
  • Telegram bot - interacts with esp32 board and sends a command to take picture from Ov2640 camera present in esp32 board

Education

Bachelor of Technology -

Vignan's Institute of Information Technology
07.2019 - 2023.04

Higher Secondary School -

Don Bosco Higher Secondary School
01.2015 - 2018.01

Secondary School -

Neingulie Memorial High School
01.2014 - 2015.01

Skills

undefined

Accomplishments

  • Used Microsoft Excel to develop inventory reports.
  • Collaborated with team of 5 People in the development of Final Semester Project on Smart Calling Bell and Security System

Software

Cloud Computing

Google Compute Engine

Network Architecture

Relational Database Management System

Python

Certification

Foundations: Data, Data, Everywhere

Timeline

Google Data Analytics

04-2023

Data Processing Techniques

03-2023

Agile Methodology Virtual Experience Program

10-2022

Introduction to Networks

07-2022

Databases and SQL for Data Science with Python

02-2022

Responsive Web Design

05-2021

Professional Certificate in Architecting with Google Compute Engine

10-2020

Cybersecurity Essentials

09-2020

Introduction to Cybersecurity

08-2020

Professional Certificate in Google IT Support

07-2020

Foundations: Data, Data, Everywhere

02-2020

Bachelor of Technology -

Vignan's Institute of Information Technology
07.2019 - 2023.04

Higher Secondary School -

Don Bosco Higher Secondary School
01.2015 - 2018.01

Secondary School -

Neingulie Memorial High School
01.2014 - 2015.01

Data Wrangling

Technology used: Excel

IoT- Smart Calling Bell and Security System

Technology Used: ESP32 cam board and Telegram Bot
N Sanjay RaoBusiness Analyst & Programmer (Basic)