Data Sql Server

KUNAL SINGH DEORA

**** * ******* ***, *** ***, Chicago, 60615 *****.*@*****.***.*** 339-***-**** https://github.com/kunaldeora

EDUCATION

Northeastern University, College of Engineering, Boston, Massachusetts Aug 2017

Master of Science in Information Systems

Relevant Coursework: Application Engineering, Web Design & User Experience, Web Development Tools & Methods, Database Design & Management, Engineering of Big-Data Systems, Big-Data System Engineering using Scala

Rajasthan Technical University, India Jun 2012

Bachelor of Technology in Electronics & Communication Engineering

Relevant Coursework: Computer Systems & Networks, Data Structures & Algorithms, Object Oriented Programming

TECHNICAL SKILLS

Programming Languages: Java, C#, VB.NET, JavaScript, R, SQL, Oracle PL/SQL, Python, Scala

Web Technologies: HTML5, CSS3, Bootstrap, AJAX, JavaScript, jQuery, Spring MVC, Hibernate, Play, AngularJS, NodeJS

Big-Data Technologies: Hadoop, MapReduce, Mahout, Apache Spark, AWS EC2, MongoDB, DeepLearning4J

Databases & Visualization Tools: SQL Server, MySQL, Oracle11g, TimesTen, PostgreSQL, Tableau, Qlik Sense

Operating Systems & Servers: Windows, Linux, Ubuntu, Apache Tomcat 8.0, SQL Server 2008

IDE & Tools: Visual Studio, Eclipse, IntelliJ, STS, Cygwin, VMWare Workstation, Git, Tortoise, TFS, SVN

SDLC: Agile and Waterfall Methodology, Object Oriented Designing

PROFESSIONAL EXPERIENCE

Software Development Co-op, AIR Worldwide, Boston, MA May 2016 – Dec 2016

AIR Worldwide Touchstone provides flexible and resilient risk modelling and analytical solutions to gain real-time insights

Skills- C#, .NET, SQL Server, PostgreSQL, Unit testing

Developed resource management C# tool by extrapolating data from TFS and SharePoint API and populating SQL Server DB

Gathered business requirement and converted it into optimized SQL stored procedures for a database specific projects

Built optimized UDFs in PostgreSQL using Windows Analytical functions to calculate customers claim money

Developed reports in SSRS and QlikView for business executives and managers to understand the data properly

Redesigned database schema for migration of the stored procedures from SQL Server to PostgreSQL

Reduced overhead time of the sprint breakdown charts from 45 to 2 seconds by refactoring history table in database

Achieved 85% code coverage by implementing unit tests and integrated SQL test scripts to ensure data authenticity

Programmer Analyst, Tata Consultancy Services (TCS), Mumbai, India Feb 2013 – May 2015

TCS Bancs is a Risk Management System that develops and supports multi asset and multi market Security Trading Solutions

Skills- Business & Data Analysis, PL/SQL, Query & Performance Optimization, MS Excel, VB.NET, OLTP

Minimized time taken by critical process (Start of Day) from 134 to 25 minutes by using SQL optimization & tuning techniques

Developed Stop Loss Order functionality in the broker’s existing trading system using VB.NET and Oracle PL/SQL

Implemented Mail and SMS feature by using CLOB database objects to automate alerts to business users

Researched and resolved data issues related to existing data and the processes in place before my tenure

Monitored and tuned database resource and activities for Oracle 10g and 11g database

Generated detailed risk analysis crystal reports using DB Scripts for analyzing the trading patterns of clients

Acquired comprehensive functional knowledge of capital markets – Equity, Derivatives and Mutual Funds

PROJECT EXPERIENCE

Image Classification Using Scala and Spark – Big-Data Application (DeepLearning4J) Jan 2017-Apr2017

Built 63% accurate predictive model to classify and tag businesses among multiple labels using 200k yelp images as train data

Implemented DeepLearning4J with Scala and Spark to build architecture of convoluted neural network for image classification

Machine Learning on Yelp Dataset – Big-Data Application Aug 2016 – Dec 2016

Designed prediction model using SVM algorithm in python to predict user ratings of new and upcoming restaurants

Performed sentiment analysis using MapReduce to achieve sentiment score on user reviews launched on Amazon EMR cluster

MealPal Food Delivery System – Java Application Implementation of Particle Swarm Optimization Jan2017-Apr2017

Used particle swarm optimization to reduce travel cost & find optimal solution for single capacitated vehicle routing problem

Integrated GraphStream & JFreeChart API to visualize and compare routes between drop-off location and MealPal depot

IoT enabled Smart Food Donation System – Java Swing Application Nov 2015 – Dec 2015

Developed a singleton design pattern based desktop application to track, manage and categorize quality of refrigerator food

Integrated Google Distance Matrix API to compare and find the nearest driver by distance and time from food pickup location

Contact this candidate