Organized and motivated employee eager to apply time management and organizational skills in various environments. Seeking opportunities to expand skills while facilitating company growth.
Overview
10
10
years of professional experience
Work History
Oracle PL/SQL Developer
Peri Software Solutions Inc
Chennai
08.2020 - Current
Wrote complex Oracle SQL using joins, sub queries and correlated sub-queries for Performance tuning
Developed Perl scripts to implement the designed functional components like different kind of searches
Implemented SQL*Loader utility to write into and extract from flat files for the transformation module
Used SQL*Plus to execute PL/SQL programs, procedures and packages
Created SQL*Loader scripts as a part of conversion process to load the legacy Coded and deployed application in test and production environment
Developed PL/SQL routines to extract data from other database and load it into the Oracle database
Support Engineer
Peri Software Solutions Inc
Chennai
01.2019 - 07.2020
The implementation was to make ETL with Big Data Ecosystems.
Transformation was made from OGG -> Hive -> transformation with spark -> final load in elastic search.
I Was responsible for monitoring a ETL pipelines in scala-spark.
Collaborated with Business to understand health care business critical transformations and handled the customer tickets.
Monitored and maintained elastic search indexes.
Created a standard SQL queries for unit testing purpose.
Learning and Development Trainer
Peri Software Solutions Inc
Chennai
06.2014 - 01.2019
Developing training programs and customizing training materials such as online learning modules, software manuals and quick reference guides
Develop, maintain and deliver product training courses, webinars and online training to the business
Prepared training materials and conducted training sessions on Django -MVC pattern
Continuously improved training with latest technologies in AWS likeEC2,S3,RDS,CloudWatch,SNS
Strong Knowledge with SQL,PERL,PYTHON and good conceptual knowledge of Joins, Sub query Object, Nested TableUsing Object etc.