Information Technology Data

AKASH PAREKH

+1-312-***-**** ************@*****.*** linkedin.com/in/akashnparekh

EDUCATION

Illinois Institute of Technology, Chicago, IL, USA 2016 - 2017 Masters in Information Technology Management, Data Management GPA: 3.60 / 4.00 Relevant Coursework:

Object Oriented Application Development - Java, Advanced Topics in Data Management, ITM Frameworks - ITIL, Data Warehousing, Data Analytics, Database Security, Object Oriented Modeling and Design, Client/ Server Technologies – Hadoop, Data Mining, Intelligence Device Applications – Android Gujarat Technological University, Ahmedabad, India 2011 - 2015 B.E. in Computer Engineering, GPA: 3.23 / 4.00

SPECIALIZED SKILLS

Database Administration: Oracle 12c, MySQL, SQL Server 2008, MS Access, SQLite Operating System: Windows, Mac, Ubuntu, Android

Languages: C++, Java, JavaFX, SQL, PL/SQL, Android Data Tools: SAS, R, MS Excel, SSIS, Weka, Hadoop, Sqoop, Hive, Pig, Python Web Technologies: HTML, CSS, PHP

Software Application: Android Studio, MySQL Workbench, PHP MyAdmin, Virtual Box, Vagrant, VMware, NetBeans, Eclipse, Sublime Other: ITIL, Agile Technologies, BIND, Google Analytics ACADEMIC EXPERIENCE

ILLINOIS INSTITUTE OF TECHNOLOGY

Data Mining - IPL Dataset Jan-May 2017

2008-2016 dataset containing information of balls, matches, players and teams.

• To classify players into category of All-rounders

§ Pre-processing of data to get batsman and bowling statistics of every player

§ The bowling and batting average were calculated through AHP, TOPSIS using R

§ Decision Tree technique to classify player into 4 categories using Python and Weka

• Get the outcome of the match

§ Features selected that are calculated before starting of match

§ Created 8 models i.e. for each team and Trained 2008-14 by Naive Bayes, Random Forest and SVM using Weka

§ Tested 20015-2016 and compared the actual output by probability of winning using Python and Weka Understanding of Hadoop Ecosystem Jan-May 2017

• Calculated most frequently visited Web Page per month and per day

• Understood by Map Reduce java code, SQL command, Sqoop, HiveQL and Pig Latin Script Strategy for Tax Increase Aug-Oct 2016

• Planned a tax strategy for the Illinois State. Studying the 2013 census data to achieve the maximum tax from the state.

• Using SAS, performed k-means clustering on dataset which contains 58000+ observations

• Compared the value of R^2, cluster centroid, standard deviation for k=15 and k=20

• Profiling and Grouping of the clusters was made on some variables to maintain equity of tax increase among people

• Based on analysis, new tax strategy was proposed and charts of tax increase per group and average increase per person per group were produced Text Analysis – Pharmaceutical Company Oct-Dec 2016

• Created Corpus, Term Document matrix and got KEIs for a pharmaceutical company using their 15 years DEF filings

• Used R to automate the process to extract required section from HTML file for further analysis, cleaning the dataset and text mining

• Based on KEIs, all incidents were analyzed and Word Cloud was generated by the frequency of words appearing in Corpus NSA Data Warehouse Jun-Jul 2016

• A warehouse to store data for each American citizen and non-citizen in USA using Inmon approach

• Created Database schema for 28 Tables – STAR Schema, Performed ETL operation and used SCD type 2 to load data into dimensional table

• Destructive and incremental loading approach were followed to load dimensional and fact table respectively and created end user application to access the data

Election Voting Application System Jan-May2016

• Java Application designed using JavaFX to make an application where one can cast a vote and result is generated

• Role based user – Admin, Voter, Candidate and database designed in Oracle using CRUD functionality to all entities

• Project in MVC pattern using CSS styling as result was visualized on pie chart Improvement in Orkut’s IT Strategy Plan Jan-May 2016

• Followed steps to implement new features and modifications for existing features for a social website which was closed due to flaws

• Used Information Technology Service Management (ITSM) stages with Information Technology Infrastructure Library (ITIL) LEADERSHIP

• Vice President Operations, TEDxIIT 2016-17

• Introduced Tammera L. Holmes, Aerostar Consulting Corporation Founder, TEDxIIT 2016-17

• Introduced Baseball Player Jim Mecir and ImprovTalk Founder Ellen Schnur, TEDxIIT 2015-16

• Illinois Tech Table Tennis Champion 2015-16

• Elected General Secretary of SCET campus in National Student Union of India

• Event Developer and OCVP at Google Box Event 2014

Contact this candidate