Maulik Gohil

Tutoring the students on the topics : Fundamental of Internet, Web Programming, Database and Application connectivity, AJAX Call, JSON/XML File parsing

• Course : CIS 408 Internet Computing
• Professor : Dr. Sunnie Chung

• HTML
• CSS
• JavaScript
• PHP
• AJAX
• MySQL

Worked in Infrastructure Team as Database and AWS Cloud Admin which gave in depth knowledge of SQL Sever Database Administration as well as Windows Administration.

Amazon Web Services

• EC2 (VPC, Security Groups, LB), RDS, S3, CloudWatch, Route53, CloudFront
• Automated Backups of EC2/RDS (AMI/Snapshot), Recovery, Lauching Instance
• Traffic routing from CDN to Security Service provider to Web Server
• Alerts using Amazon CloudWatch

Database Administration

• Installation and configuration of MS SQL Server (Stand-alone & RDS)
• DB Server by monitoring CPU Utilization, Error logs, Warnings, log space, Blockings, Deadlocks, Index fragmentation, DBCC commands, Creating Alerts
• Backups, Cleanups and Point in time recovery of Databases
• Automation via Maintenance Plans, SQL Jobs in MS SQL Server, Events in MySQL
• Development of SQL Query, Views, Triggers, Stored Procedures
• Database Migrations (On-premise to Cloud, Self-hosted to Amazon RDS)

Windows Administration

• Installation of software and Configurations in windows systems
• Troubleshooting both staging or production Web server issues
• Hands on with implementation of different types of SSL implementation
• Traffic monitoring by analyzing Web Server(IIS) logs in Kibana (ELK Stack)
• Deployments - Production and Staging Web Application Server
• Experience with Sitecore CMS - Domain Mapping and Configuration of CMS

• AWS
• MSSQL
• MySQL
• DB Server
• Web Server
• SSMS
• SQLyog
• Kibana
• Akamai
• JIRA
• Confluence
• Site24x7
• StatusCake
• Pingdom
• GDPR
• Security
• DR Planning
• High Availibility
• SSL Implementataion
• System Architecture Diagram
• Troubleshooting

Considering the database skills I have, I had been hired as an intern to work in the core database Development & Administration team of Investis Digital infrastructure.

DBA Skills

• Learned MS SQL Server architecture
• Back Ups and Restore, Point in time recovery, Database Migrations
• Maintenance Plans & audits, SQL Server Profiler/Trace
• High availability techniques of database: Log Shipping, Mirroring, Replication
• Concept of CLoud and Virtualization
• Introductory knowledge of Amazon Web Services

• SQL Server
• AWS
• Networking
• Protocols
• Architecture

Web Application (J2EE)

• Every company has its page on social media. Application shows you Social media engagement of that company by considering page share counts
• By entering the URL of that company and it will give you the page share count of those pages hosted on LinkedIn, Facebook, Stumbleupon, Pinterest

• MVC
• Java
• Servlets
• JSP
• JDBC
• API
• MySQL

• Developed Web Application for “Vendor Registration System” where Vendors can fill the form online and submit it for the approval.
• Aim behind this application was to remove conventional hardcopy based application system to make overall process faster, smoother and more Efficient

• HTML
• CSS
• JavaScript
• Bootstrap
• JSP
• JDBC
• MySQL

• Investigated whether the structural variation in use cases affect their use in estimating the effort using use case points/ Use case Size points
• Considering the variation, if the estimation is made using different use case template then that would also vary. So how much difference one may find at the end of estimation process in terms of person hours?
• During the project tenure I had compared four different use case template - Insfran UCT, Oracle UCT, Some UCT and Yue UCT.
• Professor : Dr. Saurabh Tiwari

• Software Engineering
• Research
• Use Case Diagram
• Effort Estimation

▸ Using the dataset available on UCSD site for amazon product reviews, developed a recommendation system in the python using a collaborative filtering Machine Learning technique achieving 80% of prediction accuracy.

• Data Mining
• Python
• Jupyter
• ML
• SVD
• Collaborative Filtering

▸ Implemented Query optimizer where a User can insert a query in a predefined format and software will optimize the query by implementing low-cost join, indexing, modification in correlation of inner-outer query and you will get the final results in a specific format that will have lesser cost than the original query.

• Enterprise Database
• Java
• SQL
• Join
• Indexing
• Correlated Queries
• Cost Analysis

▸ Designed and implemented a single-cycle MIPS processor using VHDL and Quartus on the Altera DE10-Lite system, which performs a subset of MIPS instructions (add, sub, slt, and, or, lw, sw, beq, bne, j).

• Computer Architecture
• MIPS
• VHDL
• Quartus

▸ To solve the issue of 'change of money' in the cafeteria of DA-IICT, we developed an online Web-App "Cafe-Pay" in which every student and cafe-vendors has their account and transaction will be made through QR code.

• Software Engineering
• Process
• Documenation
• AngularJS
• NodeJS
• MongoDB

▸ I implemented the core logic behind the game in java. A user can play using num-pad of the keyboard.
▸ Created [4x4] 2D matrix and constructed a function that generates random number form a string containing 2s and 4s and it comes where there is no value(zero) in the matrix. "0" is used to show blank spaces. As 2048 is found in any place, game ends there.

• Data Structures
• Java
• 2D Array

▸ Designed and implemented a database of telecom service provider companies in MySQL by following all the rules and methods of Database designing to creation.
▸ The process like from SRS document- filtering out different Entities and its attributes, Entity-Relationship Diagrams considering relationships & dependencies, Normalization process for avoiding data redundancy, Data Dictionary, schema creation using DDL and also applied different Integrity checks.

• DBMS
• MySQL
• E-R Diagram
• Normalization
• DML
• SP
• Triggers
• Views

▸ Using two microcontrollers, Arduino and Raspberry PI, and few Sensors created a simulation for smart home/ home automation.
▸ Light intensity controlled by LDR, Fan speed and the temperature was controlled by LM35 Temperature Sensor, Door open-close and person count was done by Proximity sensors, and And for fire/smoke detection, MQ2 smoke detector sensor was used. All the sensors were connected with Arduino where Raspberry Pi was used for sending mail to the respective person if fire/smoke detected in the home/room.

• Embedded System Design
• IOT
• Arduino
• Raspberry PI
• Python
• Sensors

▸ Implemented very frequent system commands like bg-fg, list jobs, deleting jobs, signal handling when signals like SIGCHLD, SIGINT, SIGSTP caught by signal handler. The whole code was written in C Language.

• System Software
• C
• Singnal Handling
• Thread
• Processes