Resume PL/SQL Developer

****** M V

Mobile: + Show contacts E-Mail:

*******************

O

BJECTIVE

:

Keen to work in technology driven projects to utilize my knowledge and
experience for the growth and development of the organization thereby

contributing to my overall personal growth through continuous learning

P

ROFESSIONAL

S

UMMARY

:

- Over

9 years of programming experience as an Oracle PL/SQL developer in

Analysis, Design and Implementation of Business Applications using Oracle
Relational Database Management System (RDBMS).

- Adept at all stages of software development life cycle (SDLC), from business

requirements and technical definitions to other stages comprising of

Analysis, Design, Coding, Testing, debugging, UAT support, Implementation,
Documentation and Maintenance including trouble shooting and root cause
analysis.

- Worked on Domains such as DataWare Housing, HR Management, Finance

and Retail.

- Excellent Communication and interpersonal skills and strong ability to work

well in a team or as an individual.

- Good knowledge on logical and physical Data modeling using normalization

technique.

- Experience in query optimization, performance tuning using Explain Plan,

TKPROF, Hints, Partitioning, Bulk Collect and Indexes.

- Rich experience in writing sql queries, views, materialized views, Ref

cursors, cursor variables collections, records, dynamic sql, exception

handling.

- Experience with Oracle supplied packages such as DBMS_SQL,

DBMS_METADATA, DBMS_AQ, DBMS_UTILITY, UTL_FILE, UTL_MAIL etc.

- Good experience on design and development of Oracle applications

involving PL/SQL, Pro*c, Oracle Forms and Oracle Reports.

- Experience in Writing PL/SQL stored procedures to interact with XML and

also invoking web services.

- Exposure to data disguising technology of confidential data such as

customer personal identifiable information (PII) through data obfuscation
and data masking.

- Familiarity with Oracle Data warehousing features such as materialized

views, Bitmap Indexes, Index organized Tables, External tables,
Dimensional Modeling (Data Marts, Facts and Dimensions) and Data

Modeling and Database schemas like Star schema and Snowflake schema.

- Knowledge in Data warehouse concepts and experience in ETL techniques,

analysis and reporting with reporting tools such as Business Objects.

- Experience in UNIX Shell scripting, SSH, FTP to extract and work with data,

scheduling jobs using AUTOSYS to automate procedure execution from Unix

- Familiarity with common database vulnerabilities and best practices for

hardening against threats such as SQL injection.

- Familiarity with Hashing, Salting, and other cryptographic methodologies

and approaches.

- Basic experience with working in API and Core Java.

S

KILLS

:

•

Oracle (SQL, PL/SQL), Performance Tuning

• Business Objects

•

SQL Plus, SQL Loader

•

Autosys

•

Unix Shell Scripting

•

Data Modelling

•

Version Control using CVS, SVN, GIT

•

Documentation: Atlassian Suite

•

Eclipse

•

Pro*C

•

Core Java

W

ORK

H

ISTORY

:

FEB

2006

–

SEP

2017

AS

T

ECHNICAL

L

EAD

TECHNICAL

LEAD

/

ORACLE

DATABASE

DEVELOPER

JAN

2015

–

SEP

2017

• Responsible for interacting with the client / onsite coordinator to

understand the requirements of a project from their perspective and base
lining the business requirement Document.

• Responsible for managing scope, planning, tracking, change control,

aspects of the project.

• Responsible for effective communication between the project team and

the onsite coordinator.

• Provide day-to-day direction to the project team and weekly project

status to the client.

• Translate customer requirements into formal requirements and design

documents, establish specific solutions, and leading the efforts including
programming & testing that culminate in client acceptance of the results.

• Involved in deploying test data and masking sensitive test customer PII

data to meet security requirements and business data rules of integrated
systems.

• Involved in writing PL/SQL programs using advanced concepts of

Records, Collections, Ref Cursor and Dynamic SQL.

• Modified various existing Pro*C code and Pl/SQL code.
• Involved in DB migration from Oracle 11g to 12c.
• Used joins, indexes effectively in where clauses for Query optimization
• Involved in full development cycle of planning, analysis, design,

development, testing and implementation.

• Exposure to writing new Java classes and methods and invoking Java

methods and run Java applications from DB, Invoking Java API from
Oracle stored procedure.

• Involved in improving query performance using partitioning, explain plan

for the queries for optimization of Oracle SQL Queries.

SENIOR

SOFTWARE

ENGINEER

/

ORACLE

DATABASE

DEVELOPER

JAN

2011

–

DEC

2014

• Modified various existing Pro*C code and Pl/SQL code.
• Involved in writing stored procedures to generate reports and using Unix

mail feature to mail the reports to the specified user.

• Involved in writing Stored Procedures using PL/SQL and functions and

procedure for common utilities.

• Involved in tuning the queries and applying hints for faster and better

performance of the SQL queries.

• Used UTL_FILE (file handler), wrote Unix Shell Scripts, undertook Code

Optimization and Performance tuning of the application.

• Wrote packages for unit testing using PL/SQL and debugged using DBMS

debug packages.

• Involved in migrating the existing Pro*c files to PL/SQL sources.
• Coded PL/SQL packages and procedures to perform data loading, error

handling and logging.

• Defining and reviewing the coding standards besides reviewing the code.
• Detailed review of code and identification of each and every logic used in

the code to match it with the existing business process.

• Translate customer requirements into formal requirements and design

documents, establish specific solutions, and leading the efforts including

programming and testing that culminate in client acceptance of the
results.

• Preparation of Checklists, identify Test Cases & prepare Test Plans.
• Involved in development, unit testing, Implementation and maintenance.
• Involved in giving KT about the project to new members joining the team.
• Involved in Peer-to-Peer Code reviews, Performed SQL, PL/SQL tuning

using various tools like explain plan, TKPROF.

SENIOR

SOFTWARE

ENGINEER

/

ORACLE

DATABASE

DEVELOPER

OCT

2009–

DEC

2011

• Production issues assigned as tickets on a sprint basis. During the sprint

period responsible for completing the analysis, construction along with
unit testing and implementing the sources in UAT for testing.

• Provide day-to-day updates in the ticket and weekly sprint wise updates

to the team lead.

• Involved in tuning the queries and applying hints for faster and better

performance of the SQL queries.

• Involved in creating test scripts and preparing test plans for unit testing

the functionality of the application.

• Written Stored Procedures using PL/SQL and functions and procedure for

common utilities.

• 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 Tablespace,

creating views.

• Involved in development, unit testing, Implementation and maintenance.

SENIOR

SOFTWARE

ENGINEER

/

ORACLE

DATABASE

DEVELOPER

JUL

2007

–

SEP

2009

• Translate customer requirements into formal requirements and design

documents, establish specific solutions, and leading the efforts including

programming and testing that culminate in client acceptance of the
results.

• Set up autosys jobs to automate the loading of data from OLTP to OLAP

environment at a certain intervals of time.

• Involved in writing stored procedures to populate data from OLTP to

OLAP environment for reporting purpose.

• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve

performance.

• Coded PL/SQL packages and procedures to perform data loading, error

handling and logging.

• Involved in tuning the queries and applying hints for faster and better

performance of the SQL queries.

• Used UTL_FILE (file handler), wrote Unix Shell Scripts, undertook Code

Optimization and Performance tuning of the application.

• Used Pragma Autonomous Transactions.
• Modify Business Objects universe to insert new tables, new joins, detect

and resolve loops and contexts if any. Creating new classes and objects
and providing necessary security for generating adhoc reports.

• Schedule Webi reports, create pre-canned desktop reports.
• Involved in Peer-to-Peer Code reviews, explain plan for the queries for

optimization of Oracle SQL Queries.

• Involved in development, unit testing, Implementation and maintenance.

SOFTWARE

ENGINEER

/

ORACLE

DATABASE

DEVELOPER

FEB

2006

–

JUN

2007

• Participated in developing/modifying packages, procedures, functions

and triggers based on change requests.

• Using Unix and SQL*Plus environment for compilation and testing.
• Responsible for daily support to monitor the flow of data from

source tables à staging tables à data tables à aggregate tables.

• Responsible for analyzing the root cause for any non-processed / missing

data, correcting the scripts/ DB objects and reprocessing the data and
also verify that the requested data has been published successfully to the
subscriber in the downstream.

• Preparing test scenarios and Involved in Unit testing, test plan and

Integration testing for new requirements.

• Involved in support during UAT phase of testing.
• Involved in Production Cut Over and Production Implementation

activities.

E

DUCATION

:

2005 Bachelor of Engineering (Telecommunication):
Visveswaraya Technological University, Karnataka, India

R

EFERENCES

:

References available on Request