DBMS, SQL, OracleSQL,ETL, CDC

Shivam Shastri

+1-862-***-**** • ****************@*****.*** • https://www.linkedin.com/in/shivam-shastri- 369a32192/ • https://github.com/jarvis3198

EDUCATION

New York University, Tandon School of Engineering, Brooklyn, NY May 2021 Master of Science, Computer Engineering, GPA: 3.56/4.00 Relevant Coursework: Principals of Database Systems, Advanced Project in Database Systems, Data Structures & Algorithms, Computing Systems & Architecture, Intro to Java Gujarat Technological University, Babaria Institute of Technology, Ahmedabad, India June 2019 Bachelor of Engineering, Computer Engineering, CGPA 8.02/10.00 Relevant Coursework: Database Management Systems, Computer Networks, Web Technology, Data Structures, Object Oriented Programming, Software Engineering

TECHNICAL SKILLS

Coding Languages: C, C++, CSS, Java, HTML, Python, SQL Operating Systems: Windows, Linux

Other Skills: Odoo Framework, Data modeling, Database Design EXPERIENCE

Software Engineering Intern (Backend), Kanak Infosystems, Vadodara, India Jul 2020-Sept 2020

• Develop database designs for clients on Oracle Data Modeler.

• Enforcing architectural procedures for projects.

• Design, Development and testing of Odoo (OpenERP) addons, projects, products and interfaces. Database Systems Graduate Teaching Assistant NYU, New York, NY Jan 2020-May 2020

• Helped design the course, construct tests, prepare materials, grade assignments.

• Work with students one-on-one; learn about problems they are having with the course material. Student Ambassador, NYU Eats, NYU, New York, NY Aug 2019-Dec 2019

• Marketing NYU meal plans to incoming graduate and undergraduate students, and parents. PROJECTS

Health Information Management System (Django,OracleSQL,MySQL,SQLLoader) Fall 2020

• Created a health information management system, with a Web Interface, backend OLTP database, Data Warehouse, ETL (Extract,Transfer,Load) scripts, having a CDC approach. Used Django for Web Interface, MySQL for OLTP, OracleSQL for DW. Also made use of External Tables and Partition Tables.

Database project for a Insurance Network (OracleSQL, PHP, HTML, CSS, JS) Spring 2020

• Designed a database schema with Data Modeler, and a web application with CRUD functionality. Used HTML, CSS, JS, PHP and MySQL, for a given business case regarding insurance network Web Application for Sentimental Analysis (ML,NLP,TenserFlow,HTML,CSS,JS,Django,Python) Fall 2018

• Created a system which can perform a sentiment analysis on sample input text by a user and return a polarity based on how negative or positive the entered text is, with the help of Machine Learning and Natural Language Processing Techniques as well as a Data Visualization module which would visualize the resultant data.

Yahtzee Game (Java) Fall 2020

• Created the board game Yahtzee in Java. Made use of the Java Swing library for the GUI. ACTIVITIES

Gujarat Hackathon, Finalist (2018) – Finalist in a Hackathon organized by Govt of Gujarat. Advanced Animation Certification – Certified in 3D modeling and rendering by Arena Animation

Contact this candidate