Shruti Naik
**** * ********* ******, ******* IL *0616 312-***-**** ******@****.***.*** www.linkedin.com/in/shrutinaik1991 Summary and Objective
A Computer Science Graduate efficient at querying back-end Database using SQL, PL/SQL, performing ETL operations, and carrying out Data analytics using python and R. Job Experience
Graduate Teaching Assistant (Data Mining), IIT, Chicago, IL – Sep 2016 – Present Assisting professor in helping students learn Data Mining concepts. Assisting professor in grading and organizing Assignments/Projects/Exams for students. Helping students learn technologies - Python, R, Orange, and Weka. Software Engineer Intern (Heroku), zensupplies.com; Chicago, IL – June 2016- Jul 2016 Developing integrated Reporting and Analytic solution for zensupplies application hosted on Heroku cloud platform which aims to organize the order placement and inventory management dental supplies between dentists and distributors. Understand the application working as well as provide training to dental assistants and supplier coordinators of newly enrolled clients.
Systems Engineer (SQL ETL Developer), Infosys Ltd; India - 2013-2015 Developed SSIS Packages for relational Data and SSAS Cubes for Dimensional data using SQL Server Data Tools. Database source was Oracle, SQL and Target was SQL. MS SQL Server used for Stored procedures, functions, and triggers used in SSIS and SSAS. Databases transformed and loaded incrementally using scheduled Jobs.
• Successfully developed and deployed SSIS Packages and SSAS cubes to development and Production Server with zero client complaints and meet each deliverable and Milestone on time.
• Assessed and Co-ordinated a Team of four, distributed geographically for development, testing, and maintenance of Emerson Database project. Provided Training with hands-on and knowledge transfer to new project joiners. Worked on Data Mining services to predict future Quotes and order by clients. Software Engineer (Web Developer), Venus Electronics and Controls Pvt. Ltd; India 2012-2013 Designed and developed cross browser compatible websites for e-commerce, inventory, and social media with wireframes provided by client. Provided website maintenance and technical assistance for troubleshooting and upgrading live websites on Drupal CMS 6 and 7.
• Delivered and tested websites across cross-platform on numerous browsers for functionality and presentation. Designed customized and tweaked existing Themes and Modules upon client’s requirement.
• Worked on 4 different website development projects like, in-house inventory interface, community website, social media, and delivered prospective client’s prototype website for e-commerce. Projects
Current Projects (2017) : Yelp data Challenge, Architectural book review – Using Python BallotReady: Project to study 2016 US Election Voter Demographics – Dec 2016 - Present
• Collecting BallotReady Data from ballotready.org, of user session clicks & preferences. Using US Census data to classify users based on ‘Tract’ to understand user Demographics, using SQL & Python. Online Social Network Analysis – Python, Twitter API, Facebook LIKE, IMDB – Fall 2016
• Using Twitter API constructed a social network of political influential accounts. Using Facebook “Like” Data implemented community detection and link prediction algorithms. Performed Sentiment Analysis to determine whether a movie review at IMDB.com expresses a positive or a negative sentiment. Using list of genres for a movie implemented a content-based recommendation Algorithm. Cloud Computing - Hadoop, Spark, Java – Spring 2016
• Sorting 100GB dataset generated on demand on Amazon S3, using Amazon EC2 by creating 1-node & 17- node Master-Slave cluster architecture with Hadoop, Spark, and Shared Memory(Java). CloudKon clone with Amazon AWS, by developing task execution framework to convert images into videos in Java using Amazon EC2, S3, SQS, and DynamoDB.
Advanced Database Organization - C Programming, Linux Platform – Fall 2015
• Using C programming language developed Storage Manager, Buffer Manager and Record Manager in Linux environment which resembles Database storage system. Education
Masters of Science in
Computer Science,
Illinois Institute of
Technology; 2015-May
2017
Courses: Advance Database
Organization (C++, SQL),
Data Mining (Weka,
pageRank, MapReduce),
Cloud Computing (Hadoop,
Spark, Amazon AWS), Data
Integration Warehousing and
Provenance (SQL and
Datalog queries), Software
System Architecture (Java),
Advance Data Mining
(python, R)
Bachelors of Engineering
in Information
Technology Atharva
College of Engineering,
Mumbai University;
2008-2012
• Ranked 3rd in Final year of
college; Ranked 53rd
across Mumbai University.
Skills Set:
Database Tools: SQL
Server Data Tools 2012, IBM
Cognos, MS SQL Server
Management Studio 2012
Databases: SQL, PL/SQL
Web Frameworks: Drupal
CMS 6 and 7
Data Mining Tool: Weka
Languages: Java, R, C++,
HTML, CSS, PHP, Javascript,
jQuery, XML, PERL, python
Operating System:
Microsoft Windows, Linux
Certificates:
Advance Excel Analysis -
March 2014
Querying Microsoft SQL
Server 2012 (70-461) -
March 2015
Data Mining with Weka by
University of Waikato – Sep
2016