S.Karthik : adg03o@r.postjobfree.com

: +91-890*******

Objective:

To work in a professional managed company with a scope of challenging career opportunity for learning, excellence and continuous improvement. To grow in an environment where performance is rewarded with new responsibilities and challenges

Professional Summary:

3 years and 6 Months of working experience in Oracle development and application, SQL, PL/SQL Development Support, OLTP, OLAP and UNIX.

Strong skills and expert in Oracle Built-In Function.

Experience in extraction, transformation and loading (ETL) data from various sources into Data Warehouses and ETL tool on oracle.

Strong RDBMS concepts including expertise in pl/SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.

Experienced in programming as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling(logical and physical), and Implementation of Business Applications using the Oracle Relation Database Management System(RDBMS)

Experience in Bulk Data Loading into Oracle Table using SQL LOADER.

Experienced in requirement analysis, coding and testing various modules in a software development life cycle using PL/SQL.

Used Pragma Exception_INIT and RAISE_APPLICATION_ERROR to handle exceptions

Used various Exception handling cases for proper flow of data into database tables

Extensively worked on Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader.

Created DDL scripts, database objects like Tables, Views, Indexes, Synonyms and Sequences.

Developed PL/SQL Procedures, triggers, Functions and Packages and used SQL loader to load data into the database.

Strong, clear communication and interpersonal skills

Developed SQL*loader scripts to load data in the custom tables

Created Materialized views & normal views where business requirements needed

Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections, Pipelined Table Function, Bulk Collect, Bulk Bind Variables, Table Fragmentation, Bind and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Professional Experience:

Company Name : Wipro, Bangalore.

Designation : Data Analyst.

Period : March 2017 – Present.

Technical Expertise:

Programming Language : Oracle SQL, PL/SQL and UNIX.

Tools :SQL*PLUS, TOAD 9.2 and PL/SQL DEVELOPER TOOL.

Operating System : WINDOWS XP, WINDOWS 7, UNIX.

Database : ORACLE 9I, 10G, 11G.

Education Qualification:

Bachelor Of Engineering (B.E) from ANNA University, Chennai.

Work Experience:

Project Title : Credit Management Impact on the Performance.

Client : Commonwealth Bank (Aus.).

Role : Oracle PL/SQL Developer.

Description: The Commonwealth Bank of Australia, or CommBank, is an Australian multinational bank with businesses across New Zealand, Asia, the United States and the United Kingdom.

Roles and Responsibilities:

Understanding of Business Requirement Document by communicating with the Onsite Coordinator.

Designing Tables, Views, Materialized Views, Stored Procedures, Functions, Triggers and Adding Constraints to Columns.

Coded business requirements with PL/SQL Packages, Functions, and Procedures to perform data loading, error handling and logging.

Created cursors, ref_cursor and worked with oracle supplied packages such as DBMS_JOBS.

Used SQL loader to load data from the flat files provided by the interfacing applications

Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Prepared Test cases and Unit Testing.

Involved in SQL Query Tuning.

Created new Tables, Indexes, and Sequences where needed.

Created database triggers for data security & Consistency.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Table.

Achievement: Awarded three times during the period from 2019 to 2020. Received multiple Nomination for LOV .

Team Size: 22

Project Title 2 : Bank Operational System

Client : East West Bank (U.S.A).

Role : Oracle Developer.

Description: East West Bank, the primary subsidiary of East West Bancorp, Inc., is the largest independent bank headquartered in Southern California, United States. It was founded in 1973 in Los Angeles to serve the Chinese American community in Southern California.

Roles and Responsibilities:

Understanding of Business Requirement Document by communicating with the Onsite Coordinator.

Designing Tables, Views, Materialized Views, Stored Procedures, Functions, Triggers and Adding Constraints to Columns.

Coded business requirements with PL/SQL Packages, Functions, and Procedures to perform data loading, error handling and logging.

Created cursors, ref_cursor and worked with oracle supplied packages such as DBMS_JOBS.

Used SQL loader to load data from the flat files provided by the interfacing applications

Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Prepared Test cases and Unit Testing.

Involved in SQL Query Tuning.

Created new Tables, Indexes, and Sequences where needed.

Created database triggers for data security & Consistency.

Declaration:

The information provided above is true to the best of my knowledge and belief.

S.Karthik

Contact this candidate