Sreejesh S Email & Phone Number

Chennai, Tamil Nadu, India

Chennai

 Developed Hive queries for user requirement to perform adhoc analysis. Responsible for Data Ingestion, Data Cleansing, Data Enrichment and Data Processing. Developed Hive managed and external tables based on the requirement Implemented Partitioning and Bucketing on Hive tables for better performance Applied transformation logics in Pyspark such as Cleansing, join, enrichments, filtering and concatenations. Created dataframes using Pyspark and performed transformation and aggregation on the same and stored as json, orc and parquet. Using Pyspark, handled data from different sources such as file systems and DBs. Developed Pyspark scripts to load the data into S3 bucket and created tables in Athena for data analysis. Automated the tasks by creating workflows using Apache Oozie framework.

Bangalore Urban, Karnataka, India

 Importing data between HDFS and Teradata using Sqoop. Creating external and managed Hive tables with appropriate buckets and partitions. Used Parquet and ORC data formats to store into HDFS. Used HIVE to do transformations, joins and aggregations on data. Used Spark SQL to read different data formats such as CSV, JSON, ORC and Parquet and load into Hive tables. Created dataframes using Spark and performed transformation such as Data Cleansing, Data Enrichment and Data Processing. Integrated Spark streaming to dynamically receive Kafka record and process it and store it with Schema RDDs and write it to Hive. Built Scala Spark scripts to load data to S3 and Redshift Scheduled the jobs using Oozie workflow.

Chennai, India

 Customize and enhance the existing application based on customer needs using SQL and PL/SQL Tuning long running SQL Queries using Explain Plan. Created indexes on the tables for faster retrieval of the data to enhance database performance Creating Materialized Views and scheduling the Materialized Views for data refresh.

Chennai

 Expertise in PL/SQL programming like writing Packages, Procedures and Functions in oracle.  Created Tables, Views, Constraints, Indexes Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Installation and configuration of oracle database in windows platform.  Creating Oracle Database users and granting roles. Designed strategies for performing database backup and recovery.

Master Of Computer Applications (M.C.A.), Computer Applications, 82

Bachelor Of Science (B.Sc.), Computer Technology, 68

Higher Secondary, State Board, 76