PRANJAL KAUSTUBH

#** *** *** **** ***, Union City, 07087

Email: acwt1w@r.postjobfree.com Phone: 669-***-****

OBJECTIVE: A highly motivated graduate student with newly acquired skills and insatiable intellectual curiosity; actively seeking full time opportunities in data/business analytics to leverage my educational qualification and knowledge in a dynamic environment.

EDUCATION: Stevens Institute of Technology New Jersey, USA Aug15- Dec16

Master of Science in Information Systems GPA 3.84

Amrita Vishwa Vidyapeeth Karnataka, India May09-May 13

B. Tech in Electronics and Communication Engineering GPA 3.5

SKILLS: Programming Languages: R, Python, Java ETL: SSIS, Informatica

Front End: HTML, CSS Big Data:Hadoop,MapReduce,HDFS,Hive,Pig,

Process Analytics:Fluxicon Disco,BPMN, ProM Data Mining/Analytics: Rapidminer, Tableau

Databases: Oracle 11g/12g,CouchDB,Hbase Platforms: Windows, Unix

COURSES: Technology Core: Analysis of Info System, Data Knowledge Mgmt., Process Optimization Analytics, Social Analytics

MOOC (Edx, Coursera): Intro to R, Statistics with R, Machine Learning(Python), ETL with SSIS,Customer Analytics

PROJECTS: Behavioral Risk Factor Surveillance System Data Exploratory Analysis Summer 2016

Performed exploratory data analysis using R to explore research questions related to health status of the population, behaviors which might cause poor health and effect on health conditions.

General Social Survey Inferential Analysis Summer 2016

Performed inferential data analysis using R to explore dependency of social condition on difficulty of access to higher education.

ACME Patient Flow Analysis & Improvisation Using Process Mining Fall 2016

Improvised hospital?s patient flow problem with infrastructural constraints and worked on the process flow improvement using Fluxicon Disco and Signavio BPMN 2.0

IMDB/Rotten Tomatoes Earning Prediction Spring 2016

Applied Probability and Statistics to create multiple linear regression for lifetime earnings with IMDB/Rotten Tomatoes scores, and a number of other predictors to determine lifetime revenue for sci fi horror movies.

Best Ride Spring 2016

Designed unified application, which assesses the best ride available for the user by prioritizing needs based on the inputs entered, using 3 point criteria modeled an analytical hierarchal process to implement the same.

PROFESSIONAL

EXPERIENCE: Cognizant Technology Solutions Tamil Nadu, India Oct13 ? May 15

Programmer Analyst: Lloyds Banking Group, UK

Collaborated with business analyst to perform goal driven data warehouse requirement gathering focussing on capturing business goals that the DW is expected to serve.

Verified data transformation by executing multiple SQL queries to verify rules according to business requirements.

Applied data transformation logic; the logic performed data threshold validation check, record check before and after application of transformation logic, data flow validation from the staging area to the intermediate tables.

Performed load test on the database with peak expected production volumes to ensure that the ETL processes within the agreed timeframe can load the data .

Implemented the Batch Processing for SQL Procedures for SSIS Packages

Performed integration testing with data equivalent to production data to ensure that the ETL process functions well with other upstream and downstream processes.

Identified critical system bottlenecks and scaling issues prior to production, improved 91% in response time.

Participated in production release validation to ensure successful deployments of products.

ADDITIONAL Indian Institute of Science Karnataka, India June12 ? June13

EXPERIENCE: Research Intern: Aerospace Department

Designed and built an efficient energy harvester and implemented in a vehicular system.

LEADERSHIP: Achievements and Activity Participations

Mentored Entry Level Trainees creating 2 valuable resources for team and conducted Knowledge Transfer Sessions.

Co-Founded Campus Bazaar Inc. an e-platform for student trade and exchange networks.

President IEEE Amrita Student Chapter 2011-2012, organized speeches and talks on various emerging technology.

Led Robotics football team at Federation of International Robotic Association World Cup10.

Represented State in under 17 National Level Table Tennis Championship in India.

Contact this candidate