SRI SWRNA VIDYA NATARAJAN

Email: ad4rjl@r.postjobfree.com

Mobile: 669-***-****

Linkedin: https://www.linkedin.com/in/sriswrnavidya-natarajan Professional Summary

● 12+ years of programming experience as an Oracle SQL, PL/SQL Developer in Analysis, Design, ETL Expert and Implementation of Business Applications using the Oracle RDBMS.

● Developed complex Stored Procedures and Queries for implementing business logic and process in backend, for data extraction and reports.

● Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

● Database /ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions.

● Extensive experience in automation of the ETL processes using DBMS_SCHEDULER jobs.

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

● Developed materialized views for data replication in distributed environments.

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

● Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL_FILE, SQL*Loader and External Tables.

● Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

● Experience design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (RPD) using Oracle BI Administration Tool.

● Worked extensively on Ref Cursor and Collections.

● Expertise in Dynamic SQL, Collections and Exception handling.

● Experience in writing ETL processes for extracting, transforming and loading data into Oracle tables

Education

● B. Tech. (Information Technology) from Muthayammal Engineering College

(Anna University) (TamilNadu) with 75% in 2006.

SRI SWRNA VIDYA NATARAJAN

Technical Skills

Databases: Oracle 8i, 9i, 10g, 11g, 12c

Languages: SQL, PL/SQL

Tools & Utilities: PLSQL Developer 6.x/7.x, SQL*Loader, SQL* Plus, TOAD 9.5, DBeaver Datawarehouse OLAP Tools: OBIEE 11.1- RPD

GUI: Oracle D2K (Reports 9i, Forms 9i)

Cloud: AWS RDS

Work Experience

ORACLE INDIA PVT LTD DECEMBER 2015 – JUNE 2018

Project: GMSS (Global Marketing Shared Service)

Location: Bangalore, India

Role: ETL Developer

Environment: Oracle 12c, 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, UNIX Scripts, Windows.

Description

The Global Marketing Operations and Shared Services team is a critical part of the Oracle Marketing line of business, working to create demand for Oracle products and services through the use of Oracle Marketing applications, systems, and processes Responsibility

● Backend Programming using PL/SQL

● Writing stored procedure, database triggers, views, materialized views, reference cursors, sequences, implicit cursors, explicit cursors, sequences, Packages etc

● Manual testing

● Involved in tuning the queries and stored procedures.

● Used collections like variable arrays, nested tables for bulk collect

● Used DBMS_SCHEDULER jobs for reports generation

● Designed ETL processes for extracting, transforming and loading data into Oracle tables IBM INDIA PVT LTD JULY 2011 – NOVEMBER 2015

Project: Advanced Sales Automation Platform:

Location: Bangalore, India

Role: Senior Oracle PL/SQL Developer

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, UNIX, Windows XP

Description

SRI SWRNA VIDYA NATARAJAN

The Advanced Sales Automation Platform is a cutting-edge application that helps AT&T Account Executives perform the design, pricing, proposing sales process in a streamlined and efficient manner. The platform provides an interface that guides the AE through the entire sales process, from the initial opportunity identification to contract generation Responsibility

● Backend Programming using PL/SQL

● Writing stored procedure, database triggers, views, materialized views, reference cursors, sequences, implicit cursors, explicit cursors, sequences, Packages etc Manual testing

● Worked on SQL*Loader to load data from flat files to table

● Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

● Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE.

● Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

● Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

KELLY SERVICES (INDIA) PVT LTD APRIL 2010 – JUNE 2011 Project: GDQ-Helpdesk Template

Location: Bangalore, India

Client: Oracle India Pvt Limited

Role: PL/SQL Developer

Environment: APEX, Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Windows XP, HTML

Description

GDQ HD Templates is an application that consists of certain predefined GDQ Helpdesk Templates that are used to send requests to the GDQ team to work on it. Responsibility

● Backend Programming using PL/SQL

● Writing stored procedure, Function, Packages, database triggers, views, sequences.

● Involved in tuning the queries and stored procedures.

● Manual testing.

● Effectively used conditional control statements in programs.

● Used bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

● Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

● Used pipelined functions for faster data accessibility. SRI SWRNA VIDYA NATARAJAN

ACS (Affiliated Computer Services) MAY 2009 – MARCH 2010 Project: P-CARD

Location: Bangalore, India

Role: SQL Developer and Analyst

Environment: Oracle 9i, PL/SQL, SQL Server 2005, SQL * Plus, SQL*Loader, SQL Developer, Windows XP

Description

P-cards are intended to make the procurement process faster and more efficient, as they allow employees to make purchases directly from suppliers or vendors without the need for approval from supervisors or procurement specialists.

Responsibility

● Backend Programming using PL/SQL

● Writing stored procedure, database triggers, views, sequences etc.

● Involved in tuning the queries and stored procedures

● Involved in generating SQL Reports.

● Automation of Reports

● Manual Testing

BEL (BHARAT ELECTRONICS LTD) OCTOBER 2007 – MAY 2009 Project: Quality Check System of Payroll

Location: Bangalore, India

Role: Lead Developer

Environment: Oracle 9i, PL/SQL, SQL * Plus, SQL*Loader, SQL Developer, Windows XP Description

The main objective of this project is to maintain accuracy and transparency in payroll processing. By performing regular audit checks on various aspects of payroll, the project ensures that all employees are paid accurately based on their attendance, leaves, overtime, and other applicable factors

Responsibilities:

● Backend Programming using PL/SQL

● Writing stored procedure, database triggers, views, sequences etc.

● Involved in generating SQL Reports.

● Optimize existing PL/SQL packages.

● Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Contact this candidate