Python SQL Azure

SAHIL KUMAR

Cupertino,CA **************.**@*****.*** +1-408-***-****

EDUCATION

Purdue School of Engineering and Technology, IUPUI Jan 2019-Present Master of Science in Electrical and Computer Engineering,(Majors in Computer Engineering) YMCA University of Science and Technology Aug 2014-May 2018 Bachelors of Technology,(EIC)

SKILLS

Programming Skills:- Python, C,SQL, Data Structures and Algorithms Development tools:- T-SQL,Mysql, Postgre-SQL, Azure Data Factory(Learning), MongoDb(Basic) Industry skills:- Writing complex SQL Queries, SQL functions, Stored procedures, views, Triggers, Indexes

--Data warehouse management, Data Modeling

--Data Structures and Algorithms

--Efficient in using various python libraries for performing data analysis, cleaning, visualization PROFESSIONAL EXPERIENCE

6-months Internship at Cekatainers Pack Tek India Limited,Faridabad(Haryana) (July-December,2017)

-wrote the code in HTML and CSS for adding the description/Images of the products sold by the company.

-Designed the database system by creating different tables (departments, products, orders, orderdetails) created views, wrote queries as demanded by the team. ACADEMIC PROJECTS

Smart Parking Lot Spring 2020 Spring 2020

-Developed Parking lot automation, based on the availability of the parking slots which improves the efficiency of the parking garages as well as saves time of a driver looking for space.

-Interfaced The NXP FRDM-K64F with the Number of Infrared Sensor Modules each substitute as a parking slot

, with An SG-90 Tower Pro Micro Servo Motor to depict the entrance gates of the parking lot.

-Further, the Number of Empty Parking Slots are published on a Thing-speak channel via a Wi-Fi interface,using ESP8266 Wi-Fi to check the slot availability.

Inventory Automation Using Electronically Connected Shelves Fall 2019

-Programmed the HC-SR04 ultrasonic sensors to monitor the real time avaialbity of the stocks on the shelf

-HC-SR04 is using the FRDM-K64f to calculate the distance and send the data to the warehouse manager using the ESP8266 Wi-Fi Module (I used thingspeak cloud to send data)

-All programming is done using embedded C and compiler used was Mbed Online compiler.

-Data from the cloud is used to generate the future sales of the particular product using the machine learning algorithms.

Student to Student Marketplace Spring 2019

-Created a Website where the students of the university can sell and buy products from other students of the university

-We used PostgreSQL for creating the database for the application which had tables like products,orders, customers

(basically students),order_details.

-For writing the logic and for Updating, Retrieving data from database, Python is used

-For the Frontend part we used HTML5, Css and Javascript.

- For the framework part of website, Django is used

Polling Web Application Summer 2020

-Used python to write all the working of the application.

-Wrote python code to connect PostGRESQL(ElephantSQL) with the application and all queries were run using python like updating in the database, retrieving data etc.

-There were 7 different operations that can be performed like CREATE POLL, VIEW ALL POLLS, VIEW ACTIVE POLLS, WINNER OF A PARTICULAR POLL, OWNER OF A POLL, POLL WITH MAXIMUM VOTES.

Social Network Analysis with Machine Learning Fall 2020

-Compiled COVID-19 data and geographic data in order to familiarize with the process of data collection, and cleaning of large data-sets.

-Data-sets containing, COVID-19, tourism,economic, and geographic data were gathered from various international databases. These data-sets were compiled in a single csv using Python in order to visualize the top 20 countries for a number of categories.

-Demonstrated the impact of day of the week on new COVID-19 cases by country, compared COVID-19 trends using a 7-day moving average utilizing matplotlib and sea-born libraries.

-Designed a network among countries to show the relationship of friendliness among countries using Networkx Library in Python.

-Using Covid-19 data,generated and analyzed growth rate to find out positive correlations and negative correlations of two countries

Contact this candidate