Data Professional Experience

Rajyavardhan Handa

*** ***** ******, ******, ** *7102

***********@*****.*** 860-***-****

EDUCATION

Rutgers University, New Brunswick, NJ May 2017

M.S. in Computer Science, GPA: 3.25/4.0

Visvesvaraya Technological University, Karnataka, India June 2013 B.E. in Information Science and Engineering, GPA: 8.65/10.0 TECHNICAL SKILLS

Programming languages: Python, PL/SQL, Java, R, Perl, JavaScript, HTML/CSS Operating systems: Unix Solaris, Linux Ubuntu, Windows Databases: Oracle 10g/11g, SQLite, MySQL, MS SQL Server Tools and Technologies: PyCharm, Eclipse, SQLPlus, Oracle SQL Developer, Informatica, Tableau, SAS, SPSS, ER-Studio, Hadoop, HiveQL, Sqoop, Spark, Amazon Web Services, S3, EC2, EMR, Git, Jira, JSON/XML files Frameworks: Django, Flask, cx_Oracle, Unittest, Numpy, Pandas, Matplotlib, Seaborn, Scikit-learn, MapReduce, Agile PROFESSIONAL EXPERIENCE

Siemens Corporate Research, Princeton, NJ, USA May 2016 – Aug 2016 Grad Intern

• Developed data mirroring and monitoring module of a predictive analytics tool, Power Monitor using Python 2.7 in Agile environment

• Responsible to collect data from Siemens power sensors, cleaning and transforming it using PL/SQL queries to store in Oracle database

• Improved processing time of frequently requested queries by developing Hive database, transferring data from Oracle to HDFS using Sqoop and executing HiveQL queries on top of Spark shell

• Optimized and de-bugged Python code by building unit test cases using unittest module and fine-tuned PL/SQL queries by indexing Ernst and Young (E&Y), Bangalore, India June 2013 – May 2015 Analyst – IT Risk and Assurance

• Designed ETL process and built data pipelines using Informatica 9.1 and PL/SQL queries to perform data analysis and IT audits, thereby helping clients derive decisions aligning to their business objectives

• Developed stored procedures and OLTP/OLTP queries using PL/SQL to automate the processes of data profiling and wrangling in ODS and data warehouse

• Developed and implemented an optimized framework for providing comprehensive view of performance of 1000+ applications by creating database schemas and data models and working along with IT directors, software/database developers and business analysts

• Managed a team of 2 analysts, and multiple projects of national and global scope simultaneously ACADEMIC PROJECTS

Stock Predictor, 2017

• Developed a stock predicting web application that predicts future price of stocks based on historical data by implementing SVM algorithm

• Utilized Python Django 1.9 MVC framework to create user's account in the backend SQLite database and display portfolio information Credit Card Fraud Detection, 2016

• Analyzed credit card data to predict fraud transactions using Logistic Regression (LR) and Support Vector Machine (SVM) algorithms

• Validated the LR model by techniques like area under the curve (AUC), precision/recall and concordant/discordant in Python 2.7 MapReduce on chess data, 2015

• Implemented MapReduce on AWS to find total number of games won by white/black pieces in a given 1GB chess dataset TEACHING EXPERIENCE

• Instructed Java, JavaScript, HTML/CSS and object-oriented programming concepts to a total of 70 undergraduate students

• Mentored students seeking admission to Rutgers Business School CERTIFICATIONS/TRAINING PROGRAMS

• ITIL V3 Foundation certified, December 2014

HONORS

• Honored with EY Excellerator Award by Ernst & Young for executing exceptional team performance during client engagements, 2015

Contact this candidate