Data Sql Server

Shashank Kondoor

781-***-****) **************@*****.***

CAREER OBJECTIVE

To associate myself with an esteemed organization wherein I can utilize my technical and interpersonal skills in contributing effectively towards the growth of the organization that offers me professional growth while being resourceful, innovative, and flexible.

EDUCATIONAL BACKGROUND

New England, Henniker, NH March 2018

Master of Science in Information Systems

Courses: Data warehousing and development, Database Design, Business intelligence, Database management systems, Client-side Web Programming, Web Application and Web Design Development, Computer Security, Mobile Web Development, Network Communication

Swami Vivekananda institute of technology, India Nov. 2011

Bachelors of technology, Information Technology.

TECHNICAL-SKILLS

Software Development Model: Agile (Scrum), Waterfall, SDLC

Languages: TSQL, PHP, HTML, CSS

ETL Tools: Microsoft Visual studio (SSIS, SSAS), Apache Nifi, Talend

Databases: SQL, MYSQL, PostgreSQL, Oracle, Vertica (Linux)

Data visualization tools: Power BI, tableau, Qlik sense and Looker

Other: JIRA Client/ Web, MS Project Management, BI and analytics VMware, Notepad++

PROFESSIONAL EXPERIENCE

I Focus Systec Inc., Banglore, INDIA Jan 2013– July 2015

Carried a research on comparing different ETL tools– Talend, SSIS

Integrated datasets from Oracle and SQL Server into Oracle database

Carried Data pull requests through dashboards, reports, visualizations and analytics using Qlik Sense followed by ETL to integrate different data subsets from 4 different databases SQL server, MySQL, Postgres and Oracle

Created ETL scripts under SQL server and Oracle database platform

Carried Data integration tasks on Qlik Sense management console

Carried Data visualization and analysis on Data sources provided using Qlik Sense and accessed reports generated through Qlik sense cloud

Automated the manual data loading procedure using Talend

Produced reports and created dashboards using Tableau, Qlik sense

Developed meaning insights using Tableau, Qlik view and power BI

ACADEMIC PROJECTS

Titanic Ship Wreck Data Analysis (Kaggle) March 2018

Implemented feature Data engineering, feature extraction, cross validation using Data visualization tool called tableau

Performed analysis based on the Data sets provided by Kaggle and have been introduced to Predictive analysis based on the analyzed survivor list obtained successfully

Data warehousing and Business intelligence - ETL Nov 2017 – Dec 2017

Carried a research between various ETL tools like Talend and SSIS for cleaning data anomalies

Worked with four databases simultaneously to load and unload data from – for ETL which includes Oracle, MYSQL, SQL server and PostgreSQL

Worked with Linux platform databases while carrying research between Data visualizations tools like Qlik sense, Tableau and Power BI

Compared the processing time between ETL tools based on various database platforms

Developed dashboards and generated various reports using Qlik sense, power BI and tableau

Carried research between tableau and Qlik sense depending upon the data sets in SQL server and Oracle

Provided with required data search results using TSQL and later on generated reports on the clean data set obtained using Qlik, Power BI and Tableau

Inventory Management Application Nov 2017 - Dec 2017

Web programming, New England College, New Hampshire

An inventory management application has been developed on PHP using MySQL. The main aim of this project is to manage all the details about products, customers, users etc. using XML and JAVA

Two users have been developed namely Customers and Admin. Admin has been given the capability of adding, modify, delete users, products, product types, stocks

Later we have been asked to test our project, link it to the Home page, publish it and provide with an URL

Travel Photography Website May 2017 - June 2017

Web Application and Web Design Development

Developed a photography website using basic web skills like HTML, CSS and jQuery

Created fully responsive website using media queries by using bootstrap

Improved loading time by using bootstrap framework

Finally linked it to JavaScript files to improve cross browser compatibilities

Contact this candidate