*

Surjit Singh Harvinder Singh

Contact : - +91-962*******

Email ID : - ac385x@r.postjobfree.com

CAREER OBJECTIVE

To be in a highly challenging position, where I can apply my knowledge, acquire new skills and work closely with a team of highly experienced professionals. SYNOPSIS

Strong knowledge in UNIX SHELL SCRIPTING,HDFS,HIVE,PIG,OOZIE,REGEX,IMPALA,SQL

Extensively used Shell Scripting to achieve different project goals

Extensively used HIVE for structured data and used HIVE Serdes for formatting raw logs

Extensively used Cloudera distribution

Good knowledge on Oozie scheduler & Monitoring

Using IMPALA connectivity for tableau visualisation

Working on a live 80 nodes Hadoop cluster

Extracted the data from RDBMS into HDFS using Sqoop

Developed PHP webpages to store customer data in RDBMS.

Developed Android apps (Health Monitoring System, PAT app) SKILL SET

Primary skill : Unix shell scripting, HDFS, Hive, Pig, Oozie, Sqoop, Impala, Java, Python, PHP, SQL, PL/SQL. Regex

Tools & Eco-system : Hadoop Ecosystem, Cloudera Distribution, Android, Informatica, Ab Initio, Cognos

Databases : Oracle, Teradata, MySQL

ACADEMIC QUALIFICATIONS

Degree Institute Year of Passing Grade

BE (Computer

Science)

Vidyavardhini’s college of engg

and technology, Mumbai

University.

2015-2016 7.02(CGPI)

HSC

Thomas Baptista college of

Science and commerce,

Maharashtra state Board.

2012 79.67%

SSC

Holy Family convent High school,

Maharashtra state Board.

2010 86.91%

WORK EXPERIENCE

Capgemini

Designation : Software Engineer

Duration : July 2016 – Present, Pune, India

2

KEY PROJECTS HANDLED

BAM (Business Activity Monitoring)

Client : Morgan Stanley

Organization : Capgemini

Duration : October 2016 to Present

Team Size : 10

Role Played : Hadoop developer

Skills Used : Hive, Sqoop, Pig, Oozie, Impala, Regex, UNIX, Cloudera Distribution, HDFS, Python, Tableau

Project Description:

BAM is in-house developed Anomaly Detection dashboard for business activity monitoring goals of identifying anomalous usage behaviour that could present data security risk to the firm

Objectives:

Design BAM application for MSWM applications as identified by MS risk team.

Classify applications based on asset risk ratings, export/download capability, info-sec classification ratings, along with other attributes as available in TAI. Also, categorize applications based on their logging mechanisms.

Onboard the classified/prioritize applications on BAM framework

Integrate BAM dashboard with archer system to auto-create anomaly activity

Enable risk team with self-serve interface for querying anomaly activity Responsibilities:

Developed shell scripts to achieve project goals

Also Developed Pig scripts and Python scripts

Developed Oozie workflow for the project

Create tableau extracts after applying multiple aggregations to the data using PIG

Used Unix to develop wrapper scripts for Pig, Hive, python. ACADEMIC PROJECTS

To Automate Placement and Training cell of college using application and Cloud Server An online system which will completely automate all task of placement and training department. This system will have access to entire database of college, developing system as a final year project to enhance technical skills.

OTHER PROJECTS

Developed a prototype version of management System (Desktop GUI application) in Java.

Health management system using mobile app (android application) and Arduino belt

CRM web application to extract data from email and dump into cloud database.

Banking analysis system to perform ETL on bank data using Informatica and generating reports based on that data using Cognos Reporting tool.

CERTIFICATIONS

Oracle Certified SQL expert OC1647211

3

PERSONAL INFORMATION

Nationality : Indian

Date of birth : 27 June 1994

Gender : Male

Marital Status : Unmarried

Address : B-302, Mirchandani Garden Daffodil Chsl, Suncity, Vasai West, Dist-palghar, 401202

Languages Known : English. Punjabi, Marathi, Hindi. Interests : Cricket, Music & Dance.

DECLARATION

I hereby declare that information furnished above is true to best of my knowledge. Date:

Place: SURJIT SINGH

.

Contact this candidate