Oracle Developer Deployment Manager

SHENBAGASABITHA.N

*******************@*****.*** +91-994*******

Experience Summary

Having 8 years of experience in IT industry majorly on Development of Database and Data Warehousing Projects.

In-depth knowledge of PL/SQL with the experience in constructing the Triggers, Collections, Functions, User defined data type etc.

Strong in writing Packages and Procedures.

Good hands-on knowledge in Ambari Hadoop ecosystem and its components such as Hive & HDFS.

Hands-on experience in working with development teams as subject matter expert for developing Hadoop applications and providing solutions.

Experience in job scheduling applications like Control-M.

Has excellent work knowledge in Requirement Analysis, Design, Development, Application Maintenance and Testing.

Hands - on experience in Azure Cloud Services, Azure Synapse Analytics, SQL Azure, Data Factory, Azure Analysis services, Azure Monitoring, Azure Data Lake.

Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.

Used SQL Assistant to querying Teradata tables.

Experience in developing end-to-end solutions to analyse large data sets efficiently.

Exceptionally good and experienced in handling problems and troubleshooting.

Comfortable to work with a team or work individually.

Having good organizational and presentation skill.

Technical Summary

Operating System: Windows, Unix

RDBMS: ORACLE 10g,11g

HADOOP: AMBARI

Cloud Computing: AZURE, GCP

Programming Knowledge: Oracle SQL, PL/SQL, TERADATA, Unix shell scripting, Hadoop, Hive HQL.

Educational Qualification

Course

Discipline/Specialization

School/ College

Board/Univ

ersity

Year of

passing

%

BE

Computer Science

The new Royal college of

Engineering and

technology

Anna

University

2012

71.7

HSC

Computer Science

Sri Kalaivani metric

Higher Secondary School

state

2008

71.5

SSLC

SSLC

Sri Kalaivani metric

Higher Secondary School

metric

2006

71.2

Job Experience

•Working for CIGNAS SOLUTIONS, Chennai as a PL/SQL Developer from NOV 2013 to APR 2017.

•Working for SCIO HEALTH ANALYTICS, Chennai as an ORACLE Developer from MAY 2017 to

SEP 2018.

•Working for TATA CONSULTANCY SERVICES, Chennai as a ITA from OCT2018 to May 2020.

•Working For SWORD GLOBAL(INDIA) PRIVATE LTD, Chennai as a Senior Software developer from Jul 2020 to Mar 2021

•Working For Latent View Analytics, Chennai as a senior Analyst from Apr 2021 to present.

Relevant Project Experience

Project #1

Domain

Health Care

Skills Used

Teradata

Duration

Apr 2021 To Present

Cloud Computing

Azure

Roles & Responsibilities:

Prepared Business requirement documents, ETL specification documents according to the business requirements from clients.

Followed the SDLC Agile methodology.

Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.

Tuning SQL Queries to overcome spool space errors and improve performance.

Worked extensively in Tuning queries by elimination cursor based store procedure and using the set based UPDATE statements.

Worked with BTEQ in UNIX environment and execute the TPT script from UNIX platform.

Also involved in creating Views, Conformed views and mapping them from the table.

Worked to create TPT script template for all medical, eligibility and pharmacy flat file coming.

Conducted design review meetings with the senior architect for any new requirement to get the approval and designed the mappings according to the company standards.

Worked with complex SQL queries to test the data generated by ETL process against target data base.

Used SQL Assistant to querying Teradata tables.

Designed complex mappings Involving target load order and constraint-based loading.

Performance tuning, bug fixing and error handling.

Involved in creating table for medical, pharmacy and eligibility claim files based on the requirements from the clients and from the layouts.

Have good experience working with Azure BLOB and Data Lake storage and loading data into Azure SQL Synapse analytics (DW).

Worked on migration of data from On-prem DB to Cloud databases (Azure Synapse Analytics (DW)).

Project #2

Domain

Finance

Skills Used

Oracle PL/SQL, SQL, Unix

Duration

Jul 2020 to Apr 2021

Cloud Computing

Azure

Roles & Responsibilities:

Performed data migration enforcement tasks from one Database to another using Cloud AZURE

Develop technical documentation defining operational procedures and work instructions that can be used by the Support Teams.

Work closely with customer implementation teams on new builds and deployments of newly developed products

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.

Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Project #3

Domain

E-Commence

Skills Used

Oracle SQL, Unix, Control-M

Hadoop Hive, HDFS, SQOOP

Duration

Oct2018 to May2020

Cloud Computing

GCP

Roles & Responsibilities:

Performed data migration enforcement tasks.

Formulated data reports from updated Oracle database.

Performed data cleansing enrichment and mapping tasks.

Monitoring Control –M job.

Work out of our Remedy ticket tracking system to work on Trouble Tickets and Change Requests.

Work with other operation support teams to improve process flow

Work closely with the vendors to make sure solutions are implemented correctly.

Develop automation solutions leveraging shell and Java Scripts to increase the operational efficiency.

Designing, implementation and support of Unix infrastructure that utilizes both cloud based and physical servers.

Scripting skills with the following languages (Ksh, Bash)

Identify root causes of technical issues in production and out of box failures.

Leveraged Sqoop to import data from RDBMS into HDFS

Developed ETL framework using Hive (including daily runs, error handling, and logging) to clean useful data and improve vendor negotiations

Performed cleaning and filtering on imported data using Hive and MapReduce.

Worked on google cloud platform (GCP) services like compute engine, cloud load balancing, cloud storage, cloud SQL, stack driver monitoring and cloud deployment manager’s

Project #3

Domain

Health Care

Skill Used

Oracle SQL,PL/SQL,DB2

Duration

May2017 to Sep2018

Roles & Responsibilities:

To identify potential over payment cases over a period for a claim and a member and pull reports based on business requirements.

Improved the performance of the application by rewriting the SQL queries & using HINTS.

Creating PL/SQL functions/ procedures to seamlessly work in complex cases involving data load into Monthly, Weekly frequency Tables

Created Tables, Objects, Collections (Nested Table) for improving Query performance by reducing context switching.

Working with PL/SQL collections to load and delete Claim data which are within 6 months [insert] and delete [older than 6months] data.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams

Writing complex queries to pull the data from Data mart tables and DB2 tables.

Project #4

Domain

Banking

Skill Used

Oracle SQL, PL/SQL, Unix

Duration

Aug 2015 to Apr 2017

Roles & Responsibilities:

Analyzed the business requirements of the project by studying the Business Requirement Specification document

Worked on XML along with PL/SQL to develop and modify web forms.

Involved in the preparation and planning of incident and change management procedural documentation for clients.

Used Pragma autonomous transaction to avoid mutating problem in database trigger

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and PL/SQL Developer

Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain plan, and Auto trace

Project #5

Domain

Banking

Skill Used

Oracle SQL, PL/SQL, Unix

Duration

Nov 2013 to July 2015

Roles & Responsibilities:

Automation of monitoring activities using Shell scripting in UNIX for data capture, database bulk updates, file transfers, log retrieval etc.

Extensively used For all and Bulk collect fetch large volumes of data from table.

Created B Tree indexes, Function based indexes, Bit mapped indexes on Tables, columns to minimize query time and achieve better performance.

Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.

Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Expertise in loading data from legacy systems using SQL*Loader.

Achievements

I have received several appreciations and receive awards for excellent work from SCIO Health analytics.

Got great supportive reward from Cignas Solutions.

Personal Details:

Name : Shenbagasabitha N

Date Of Birth : 04.10.1990

Languages Known : Tamil, English

Passport No : T6998773

Current location : Chennai, Tamil Nadu

Declaration

I hereby acknowledge that the details furnished above are true to my knowledge and belief.

(Shenbagasabitha N)

Contact this candidate