Sql Server Data

Summary of Qualifications .

*+ years of experience as a Technology associate with a solid understanding with SDLC, Pl/SQL, Java, JavaScript, Bootstrap & in Data analysis using SQL Server and Microsoft Excel for data analyzing, compiling, validating, querying and reporting.

Experience of testing applications using Junit, Mockito and Selenium Web drivers.

1+ year of SQL Data Analyst Experience with exceptional record of delivering cost effective, high performance technology solutions to meet challenging business demands.

Developed various web applications during my masters based on Java language required for the completion of courses.

Technical & Other Skills

Languages: C, C++, Java, SQL, PL/SQL, HTML/CSS, XML, Java Script, JQuery, Angular JS

Databases: Oracle, MS SQL Server, MySQL Database, Tomcat

Tools: MS Visio, MS Project, Visual basic, Aqua Data studio, Adobe Dreamweaver CC, Eclipse, Dreamweaver, NetBeans, Web Storm, Tableau, Salesforce

SDLC Methodologies: Waterfall, Agile

Professional Experience

Miami Growers Inc. Jersey City, NJ Data Analyst Nov 2015 to Dec 2016

Extracted, compiled and tracked data, and analyzed data to generate reports.

Developed optimized data collection and qualifying procedures. Leveraged analytical tools to develop efficient system operations.

Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access)

Designed, coded, tested and debugged custom queries using Microsoft T-SQL.

Infobizzs Solutions Gujarat, India

Technology Associate June 2013 to Aug 2015

Worked as a developer to create the web application using Java. Developed HTML/CSS and JavaScript to enhance Functionalities.

Responsible for Data migration to MySQL Database. Wrote SQL Statements to extract Data from Tables to verify the output Data of the reports.

Created and validated business process models using UML Diagrams such as system flow diagrams Context Diagrams, Data Flow Diagrams, Activity Diagrams that include modeling of all the activities of the business from the conceptual to procedural level. Extensive Knowledge of Relational Database Management System.

Participated in sprint session meetings, JAD Sessions, daily scrums. Facilitated business requirements gathering sessions with the client, and manage the creation of Business Requirement Document (BRD), Functional Requirement Specification (FRS) and user story.

Possess Analytical, conflict resolution and excellent problem solving, written and oral communication skills.

Education

New Jersey Institute Of Technology Newark, NJ

Masters of Science in Computer Science Jan 2017

Gujarat Technical University(GTU) Gujarat, INDIA

Bachelors of Computer Engineering May 2014

Course Projects

Online IT store for the implementation of RDBMS

Analysis of requirements along with logical and physical design.

Interface Design using HTML, CSS, JavaScript, Java and MySQL.

Html pages was used to fetch the inventory from the database and display on the webpage.

Used various SQL Queries to execute the same.

Online Bookstore

Online book store web application was made using JAVA IDE, fetching data from connected MySQL database.

GUI, Oracle Code Testing of each of its modules was done using Junit, Selenium and Mockito

SQL Injection Testing was done using Pangolin SQL Injection Tool.

Performance Testing performed using Gatling Tool.

Load Testing was conducted using WEB-PERFORMANCE testing tool.

Apriori Algorithm Implementation (Data Mining)

Developed JAVA code to implement Apriori algorithm on the datasets to produce meaningful correspondence between the items in the datasets. Datasets used were the example of transactions from Amazon, Walmart to find relationship between the items which are sold together.

UX Design for Mobile Application

Mobile Application Prototype development. Built Personas, Problem Scenarios, Storyboard and Activity Scenario relevant to the development of mobile application design.

Created Wireframes, performed Claims Analysis, created mock up scenario based design, presented stakeholders and target Demographics, interviewed the target demographics to create relevant personas, filtered the worst case and best case scenario. Finally, created & presented the entire key path and information scenario.

Environment: Atom, Framework7, Axure 8, HTML/CSS

Link to my Prototype: https://web.njit.edu/~kv98/is661/key-path-scenario/index.html

Contact this candidate