NAYONIKA ROY

Edison, NJ ***** 719-***-**** ac10jb@r.postjobfree.com www.linkedin.com/in/nayonikaroy

DATA ANALYST PROFILE

Innovative Data Analyst experienced in interpreting, analyzing data and providing business effective solutions with proficiency in Data Mining and a passion to learn new things with a “can do” attitude

SKILLS

Programming and Scripting languages: Python, R, Java, PowerShell

Data Analytics: SQL Server(proficient), ETL, SSIS, SSAS, SSRS, SAS Miner, Tableau, ERP(SAP), Visio, Project, Excel, Access

Management/Business: Project Management, Agile Scrum Framework, Software Development Life Cycle

EDUCATION

Master of Science in Computer Information Systems May 2017

Colorado State University (CSU), Fort Collins, Colorado, USA GPA: 3.6

Relevant Courses: Data Mining and Analysis, Business Database System, Advance Project Management, Software Development Methodology, Object Oriented System; Enterprise Computing and System Integration, E-Business Application Technologies

Bachelor of Engineering in Information Technology Jun 2015

University of Mumbai, Mumbai, Maharashtra, India GPA: 3.5

DATA ANAYTICS ACADEMIC PROJECTS

Data Preparation for Vehicular Service Model

Performed data preparation to remove malicious records using SSIS (ETL Tool), Excel and SQL which resulted in error free database enabling the Predictive Analysis of the business problem

Optimum Data Model for Predictive Analysis

Developed a match winning forecast model of the European Soccer League with working knowledge in SQL, SAS Miner

Interpreted the transactional dataset by implementing machine learning techniques like Decision Trees, Neural Network, Regression Analysis to support the hypothesis and generated analysis reports in SAS Miner

ERP Dashboard and Reporting

Designed an ERP dashboard in Excel, VBA macros to promote sales of a Virtual company in SAP simulated ERP system that served as a primary tool for the Sales Manager to take business critical decisions

Increased the company revenue with 93% efficiency and reduced the manufacturing time (hours) by half

Valley Vineyards SQL Queries and Stored Procedures

Developed data tables applying UML modelling techniques in Visio, and prepared it for ETL phases using complex SQL queries and stored procedures resulting in disclosing meaningful insights to company’s sales

WORK EXPERIENCE

Teaching Assistant – College of Business, CSU, Fort Collins, USA Sep 2016 – May 2017

Course: CIS 350 Operating Systems and Networks taught by Dr. Dan Turk

Created 150+ Virtual machines in VMWare vSphere web client and installed Linux Server (Ubuntu 16.04.1), Windows Server 2016, Windows 10 for 45+ students

Automated grading scripts in PowerShell ISE for evaluating assignments and generating score reports in Excel

Associate Help Desk – College of Business, CSU, Fort Collins, USA Sep 2016 – May 2017

Guided 50+ international undergraduates & graduates with coursework material for Java, SQL, and PowerShell per week

Managed databases & generated reports of student entries in Excel and analyzed the pivot charts created to see patterns

Developer Intern- NPCIL, Mumbai, IN Jun 2013 - Jul 2013

Developed a Lunch Booking system in Java using Visual Studio and SQL Server as the back-end for about 1500+ employees

HONORS & ACTIVITIES

Organized programs and communicated cultural awareness as the President of the Indian Students Association, 2016-17

Mentored and led more than 20 International students as a Cultural Mentor and volunteered for CSU Orientation Fall 2016

CERTICATIONS

Data Science A-Z, Intro to Python for Data Science, Data Science and Machine Learning with R(pursuing)