Sql Server Data
Resume:
Dallas TX ***** MOH I T MI TTAL
*.**********@*****.***
Web Developer, Intern Mint Dentistry LLC Fall 2016
Developed Web Application using HTML5, CSS3, JavaScript and JQuery and PHP scripting for storing and fetching data from MySQL database.
Developed login functionality for New Patient Paperwork in React.js.
Used JQuery for developing rich user interface of the application.
Created SQL instances and databases as needed.
Implemented Stored Procedures and Views in SQL to interact with the database.
Implemented complex SQL queries.
Interacted with Business Analysts to come up with better implementation of designs of the applications. Data Analyst, Intern Informage Technologies LLC Spring 2015
Responsible for installation and Configuration of SQL Server 2008 and 2012 database and configuration of Report manager.
Developed, deployed and monitored SSIS Packages.
Designed SSIS Packages to transfer data from flat files to SQL Server.
Performed operations like Data validation and error handling to extract data into SQL Server.
Access SQL Server using front end application like VB.
Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
Experience in Development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system.
Software Developer TATA Consultancy Services Dec 2012 - Jan 2014
Involved in programming, debugging and maintaining Java client / server applications.
Designing User Interface using HTML, CSS and JS as per the requirements.
Communicate with different teams such as application development team, batch development team, configuration management team, DBA team, BA team and ensure good progress in our day to day test activities.
Prepared JUnit test cases and executed the test cases using JUnit in Eclipse.
Involved in bug fixing during the System testing, Joint System testing and User acceptance testing.
Requirement analysis, TCDR, Integration testing, System testing, User Acceptance testing, batch testing, regression testing, long duration testing, store like testing, defect logging and management. EDUCATION
Dallas, TX University of Texas at Dallas Spring 2014 – May 2016
M.S in Computer Science, May 2016.
Graduate Coursework: Object Oriented Analysis and Design; Algorithms; Database Design; User Interface Design; Machine Learning; Statistics for Data Science; Big Data Analytics and Management. Projects:
Machine learning (2016). Implemented ID3 algorithm of Decision tree in R. Training, Validation and Test Datasets were used to train, validate and test the problem. Also Implemented different classifiers such as SVM, Neural Networks and Naïve Bayes in R.
Database Design (2015). Library Management System where users are allowed search and simultaneously check-in, check-out books. Java, MySQL
R programming (2015). Map making in R - Plotted and Analyzed the data by plotting it on the United States map. The data was taken from the website: http://www.shsu.edu/eco_mwf/inequality.html Analyzed the data from the wiki page: https://en.wikipedia.org/wiki/Happy_Planet_Index using scatter plots and histograms to observe the HPI indexing variables.
Analyzed the normal distributions of various raw data using qq-plots and histograms.
Big Data Management (2015). Developed a router recommendation system of the California road map, which will give the best routes between the given source and destination. The datasets used in this project are taken from neo4j database. The technologies used are Neo4j for store, handle and query big data in a given data model, Java for data manipulation and analysis and HTML and JavaScript for User Interface.
Knowledge Base and Skillset
Microsoft SQL Server 2008, 2012; SSIS; SSAS;T-SQL; MySQL Workbench 6.3
SQL Stored procedures, Joins, Triggers, Views, DDL, DML Commands.
JavaScript; React.js; HTML; CSS; JQuery; R; Java; C++; PHP
Software Development Life Cycle, white box and black box testing techniques
Visual Studio; Eclipse; Putty; RStudio; MS Word; MS Excel
JIRA; HP Quality Center
Excellent written, communication and interpersonal skills.
Contact this candidate