Rahul Nayak ac5xd1@r.postjobfree.com

312-***-****

Chicago, US

linkedin.com/in/rahul-nayak

WORK EXPERIENCE

**/**** – 07/2016

Software Engineer

HCL Technologies

Bangalore, India

Client: Victorian Roads

Developed BI reports by gathering and understanding the business requirement .

Implemented using Cognos as the reporting tool

integrating with a backend database on DB2.

Improved performance by fine-tuning queries to meet client's SLA requirements.

Worked on change requests, provided support and

maintenance by analyzing and resolving tickets.

08/2012 – 06/2014

Software Engineer

HCL Technologies

Chennai, India

Client: Common Wealth Bank of Australia

Provided L2 support on escalated issues resolving any data discrepancies in the ETL tool.

Implemented and troubleshooted queries for for daily, weekly and monthly business reports.

Provided support and maintenance for ETL with Datastage and storing data into Teradata datawarehouse.

EDUCATION

01/2017 – 06/2018

Masters in Information systems

Depaul university

Chicago,usa

Database design Database Programming

IT Project Management Data Analyis and

Regression

Data Science Data Warehousing

Information systems

Strategies and Policies

Big Data using Hadoop

Big Data using Spark Business Intelligence

08/2008 – 05/2012

B.Eng in Computer Science

visvesvaraya Technological University

Nitte, India

SKILLS

Business Intelligence SQL/PLSQL Cognos Reporting

Tableau DB2 Teradata Microsoft Sql Server

Oracel Sql Developer Data Warehousing R SPSS

Python Big Data Hadoop Spark

IT Project Management Unix SDLC Power BI

ACADEMIC PROJECTS

Predicting Wine Quality (07/2017 – 08/2017)

Built multiple linear regression using R for predicting the wine quality to select the best model.

Formulated the best model by removing the least significant variable for each iteration of Regression, checked for multicollinearity by using the measure VIF and removed variable with highest VIF. Designed OLAP System to Load Data into Data

Warehouse (09/2017 – 11/2017)

Led efforts to analyze data for source/target mappings and created the ETL architecture using Microsoft Sql Sever 2016. Integrated and transformed the Data using SSIS.

Designed a dimensional model in star schema and loaded data into data warehouse.

Analyzed Automobile MPG data using Hadoop

(01/2018 – 03/2018)

Extracted data from source systems, loaded into HDFS for staging and transformed using Sqoop and visualized in Tableau. Implemented hive queries to find the best performing cars based on horse power and mpg.

Analyzed E-commerce Customer Data using Spark

(01/2018 – 03/2018)

Determined the yearly amount spent by the customer on company app/website using PySpark in Databricks platform.

Built multiple linear regression model, performed feature selection to determine the best model and what are the factors dependent on independent variable yearly amount spent.

AWARDS AND HONORS

HCL Live Wire award for best performance in 2013.

CERTIFICATIONS

Big Data Using Hadoop by IPD

Big Data Using Spark By IPD

Business Intelligence

Business Intelligence

Courses

Contact this candidate