Sign in

Data Sql Server

Brookline, Massachusetts, United States
February 26, 2018

Contact this candidate


**C Smith Street. Boston, MA **** 617-***-**** Education

Northeastern University, Boston MA Dec 2017

Master of Science in Information Systems

Coursework: Advances in Data Science, User Design Testing, Application Engineering Development, Data Management and Database Design, User Experience and Web Design, Business Analysis, Data Warehousing & BI University of Mumbai, Mumbai India Nov 2014

Master of Science in Information Technology

Technical Knowledge

Web Technologies: JavaScript, Angular.js, HTML5, CSS3, PHP, Bootstrap UI, WordPress, NodeJs, Express, JQuery, Spring MVC, JSP, J2EE, Hibernate, Web Services REST, JSON, AWS Database Systems: MS SQL Server, MySQL, Postgre SQL, Oracle 11g, MongoDB, Canssandra, Hadoop, Azure, HBase Hive, Pig, MapReduce, Jira, Jenkins

Programming Languages: Java, C++, C#, R, Python

Tools/IDE: Eclipse, Visual Studio, JIRA, Talend, Axure, PowerBI, Tableau, Qlik, Toad Modeller, WebStrom Version Control/Servers: Git, Bitbucket, SVN, Apache Tomcat, WAMP/LAMP Stack, HortonWorks Experience

Samsung Neurologica Corporation, Danvers, MA

Software Engineer- GUI Co-op. Jan 2017-Aug 2017

Designed and developed responsive and dynamic web pages using NodeJS, CSS, AJAX and JQuery.

Developed interface between NodeJS application and other components of the system using TCP/IP socket and Google Protocol Buffers. Implemented Agile methodology using JIRA in project for better bug and story management

Optimized the code by connecting the web pages using Express and improved the quality of the graphics for charts using D3 library. Designed My SQL Database schema for the website and optimized stored procedures for efficient execution.

Deployed database on Azure cloud for global access and scalability. Also, Improved the security using Spring Security. Data Analyst at Maple Digital Technologies, Mumbai, India Jun 2013 – Dec 2013

• Developed self-service dashboards using Qlik Sense from robust data sets queried using SQL Developer and reduced the usage of spreadsheets by 80%. Integrated Hadoop into traditional ETL for loading unstructured data.

• Accountable for creating and maintaining Requirements Traceability Matrix (RTM) for tracing business requirements through various phases (analyze, design up to deployment). Direct weekly cross-functional team meetings as part of the forecast, inventory, and sales operations continuous improvement process.

• Served as an administrator for internal reporting server and optimized the current data pulls to improve run-time accuracy and scalability. Prepared technical data reports to ensure workflow and productivity. Projects

Data Warehousing & Business Intelligence project with Talend, SSIS, Tableau & Qlik Dec 2017

• Integrated large-scale data from the Retail database employing Talend and SQL Server Integration Services (SSIS). Integrated the email feature in Talend, which would send a report to the targeted user when a data integration job fails.

• Modeled the Data Warehouse by creating a multi-dimensional schema consisting of Facts and Dimensions, flattened to Star Schema and performed source to target mapping. Implemented error handling, Load Statistics, Change Data Capture. Slowly Changing Dimensions and Currency Conversion for Data Integration process.

• Performed data discovery and visualization by creating various dashboards in Tableau, PowerBI, Qlik Sense, and PowerPivot Implemented Slowly Changing Dimensions (SCD) of Type 2 to track enable historical data reporting. Business Analyst project with NeuLife using AxureRP & Sketch August 2017

• Created wireframes, hi-fi mockups and prototypes outlining the user flow and interaction. Created Swim lane and data flow diagrams for better understanding of system requirements. Mapping of current and future business processes.

• Defined testing parameters, ensured mock-ups met both visual and textual branding standards. Developed user personas and scenarios in order to enhance functionality and usability for key audiences. Data Science project with Detection of Diabetic Retinopathy with Keras, Tensor Flow Dec 2016

• Used deep learning package Keras along with Theano machine learning backed to build data analysis model.

• Assimilated CNN with increased convolutional, pooling, dropout and ReLu layers. Optimized loss function using cross entropy and achieved prediction accuracy unto 84%. Database project with Patient In-Take System with PHP and SQL Server 2014 May2016

• Developed the database for Patient In-Take System a desktop application which keep’s the record of the patient.

• Updating the recording the information of the patient depending on the type of the patient. Created triggers and stored procedures to insert data into tables and also update and delete data in different tables

Contact this candidate