SUMMARY

Having Knowledge of Big Data Analyse, Design, Development and unit testing of software applications which includes Oracle SQL and SQL Testing

Well Knowledge in Different Hadoop Ecosystems like - Hive, Sqoop and Hdfs

Working Knowledge in Hadoop Distributed File Systems (HDFS)

Well knowledge in Hive Partition and Bucketing to split the data based on the requirements.

More Knowledge in Hive Managed Table and External Table.

Worked on Dynamic Partitioning of both Hive Internal Tables and External Tables.

Worked on different hive files RC, ORC, Text file based on the requirements.

Good knowledge in HIVEQL-Sort by, Group by, Order by and Joins.

Worked on importing and exporting data from different databases like Oracle, MySQL into HDFS and Hive using Sqoop.

More knowledge in different hive string function like trim, substr, concat, etc.

Good knowledge in hive performance tuning concept like - map join, partition, bucket in ect..

Worked on different HDFS commands like get, put, copyFromLocal, CopyToLocal, mkdir.

Good knowledge in Oracle SQL 11g.

Well Knowledge in Oracle DDL, DML, TCL query language.

Worked extensively on View, Index, Constraints to improve the query performance and security.

Good knowledge of Oracle sql joins –inner join, left, right outer joins.

Have capability with Performance Tuning for Oracle RDBMS using Explain Plan.

Loaded Data into Oracle Tables using SQL Loader.

Designed Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Created Tables, Views, Constraints, Index

Experience oracle advanced function -CASE function, NVL and SET operators-union, union all.

Well knowledge Unix basic commands – mkdir, chmod, cp, rm and more.

EDUCATION

ME-Power Electronics and Drives DMI College of Engineering, Chennai 2014

B.E - Electrical and Electronics Engineering J.P. College of Engineering, Agarakattu - 2012

Diploma- Electrical and Electronics Engineering A.S.A Polytechnic College, Tenkasi - 2009

H.S.C- Nehru Higher Secondary School, Tenkasi – 2006

S.S.L.C- Punitha Arulanandar High School, Agarakattu – 2004

TECHNICAL SKILL SET

Operating System

Windows, UNIX/Linux,

Database/RDBMS

Oracle 11g, MySql

Hadoop Ecosystem

HDFS, Hive, Sqoop

Languages

HiveQL,SQL, Unix Shell scripting,Python

Job Scheduler

Crontab, Control-M

Administration Tools

SQL Plus, Sql Developer, Putty, Jira

WORK EXPERIENCE

NON IT EXPRIENCE

Assistant Professor in ECE Department at DMI college of Engineering, Palanchur, Chennai. 2014 to 2019

Project :02

Project Name

TAX ADVISORY DATA MANAGEMENT

Duration

Feb-2020 to Till date

Environment

Hadoop, putty, Jira, Sql developer

Responsibilities

Involved in full development of Analysis, Design, Development and unit testing.

I have developed design document as per the business requirement.

Created Hive DDL script and DML load script based on requirement.

Extracted the data from different source system flat file and Oracle table source.

Created ORC and Text hive table to load the data from source to temp table.

Created partition tables using date column based on requirement.

Implemented merge query to load the data from temp to target table.

Used different hive parameters to achieve the good performance.

Implemented different joins for the lookup data.

Project :01

Project Name

MSRA-MICHAEL STARS RETAIL AND APPAREL

Environment

SQL Plus, SQL Developer, PUTTY

Responsibilities

Involved in Oracle SQL developer like creating Database object like table, view, index

Worked different environment like Design, Development and unit Testing.

Involved to create the DDL and DML script based on requirement.

Loaded different source data into temp table by using different requirement logic.

Created merge query to load the data from source table to warehouse table

Working with testing to fix the issues.

Created table constrains, view, joins and advanced function case and NVL.

Implemented different SQL string and number function.

Created UNIX shell scripts to create new tables, views, queries for new enhancement in the application.

MILTON JESU RAJAN

Contact this candidate