KOKULA

Mobile: 312-***-****

Email: acn4g9@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ** ******** *********** life cycle experience in Software Design,

Development and Implementation of Oracle, SQL, PL/SQL applications .

Expertise in Dynamic SQL, Collections and Exception handling.

Good knowledge of key Oracle performance related features such as Query

Optimizer, Execution Plans and Indexes.

Excellent Database Administration skills in Oracle 10g/11g.

Strong Skills in Oracle Database Installation, server upgrade to suit the

database needs, configuration and troubleshooting Oracle RDBMS in Windows

NT as well as in Linux environment.

Effectively made use of Table Functions, Indexes, Table Partitioning,

Analytical functions, Materialized Views, Query Re-Write and Transportable

table spaces.

Good knowledge of Data flow diagrams, Database normalization techniques and

Entity relation modeling.

Expertise in Implementation/Administration/Identification of root cause

analysis of all types of backup & recovery with or without RMAN.

Expertise in tablespace management, flashback technologies and performing

online /offline backup.

Strong knowledge on Oracle Architecture, Backup & recovery, RMAN.

Proficient in Oracle tools-Oracle Configuration Assistant, Database

Configuration Assistant, Net Configuration Assistant, Net Manager,

Enterprise Manager, SQL*Loader, Export/Import utilities, EXPDP/IMPDP,

Recovery Manager (RMAN).

Expertise in managing Rollback Segments, Redo logs, Control files, and

Table spaces.

Strong skills in WebLogic and WebSphere administration.

Involved in all phases of the SDLC (Software Development Life Cycle) from

analysis, design, development, testing and implementation.

Good knowledge in Data modeling and Data ware house(ETL) concepts.

Good knowledge in data modeling techniques ( star schema model and snow

flake model ).

Developed Complex database objects like Stored Procedures, Functions,

Packages and Triggers using SQL and PL/SQL.

Strong in using tools such as PL/SQL developer, TOAD and SQL Developer .

Successfully implemented AMLOCK and SWIFT application at Srilanka's third

largest private sector bank- Sampath Bank PLC.

Good understanding of Agile and waterfall methodologies

Ability to work under pressure situations and meet deadlines.

Experience to handle more than one Client existing in different Regions

(APAC, EMEA, South Asia Region) at a time.

A Team member with good communication, analytical, logical and problem

solving skills.

TECHNICAL SKILLS

Operating Systems : UNIX(Sun Solaris, LINUX),Windows XP

Programming Language : PL/SQL

Application Server : WebSphere 6.0/6.1, Pramati 4.1/5.0,Weblogic

Database : Oracle 9i,10g and 11g, SQL Server 2000/2005,

Oracle Core DBA

Software Tools : Microsoft Office, TOAD, PL/SQL Developer, SQL

Developer

PROFESSIONAL EXPERIENCE

Client : Newedge

Duration : Nov 2014 - Till date

Role : Oracle PL-SQL Senior Developer

Environment : Oracle 11G, SQL Developer, Toad, UNIX

Newedge primarily serves institutional clients, offering products involved

in global asset execution, global asset clearing, prime brokerage

solutions, global asset financing and market research.

The firm is also versed in navigating money

market instruments, bonds,currencies,equities and commodities on

the OTC market. In addition to these products, Newedge offers an electronic

platform for trading and order routing, cross margining, and the processing

and centralized reporting of client portfolios.

Responsibilities:

Developed PL/SQL Packages, Procedures and Functions for Various Extract

Process run through UC4 Jobs.

Coded PL/SQL Packages and Procedures using Bulk Binding, for all

Statements, Dynamic SQL and Cursor Variables.

Tuned PL/SQL Packages and Procedure to manipulate large no of data using

collections like nested tables and arrays.

Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

Created Schema Objects like Tables, Views, Materialized views, Sequences,

Constraints, and Indexes.

Designed, Developed and Tested application in UAT environment and Deployed

in Production.

Provided Productions supports and ongoing user supports for the

application.

Involved in creating and managing tables, indexes, db links and

privileges.

Utilized SQL*Loader to load flat files database tables.

Extensive use of several Oracle provided packages such as

UTL_FILE,DBMS_JOB,and DBMS_SCHEDULER.

Partitioned large Tables using range partition technique.

Controlling User Access and Granting System privileges as per Client

requirement.

Fine-tuned procedures/SQL queries for maximum efficiency in various

databases using

oracle hints.

Used Pragma Autonomous Transaction to avoid mutating problem in database

trigger.

Generated AWR reports for analysing the performance.

Extensively used the advanced features of PL/SQL like Records, Tables,

Object types and Dynamic SQL.

Client : Millennium Pharmaceuticals, MA

Duration : July 2013 - October 2014

Role : Oracle PL-SQL Developer

Environment : Oracle 11G, SQL Developer, Toad,UNIX

Drug Sales Tracking System (DSTS) was initiated to restructure the business

process for tracking the sales volume. This application was developed for

the top Executives to view, analyze the gain/loss revenue. Involved

extraction of customized data from Core system into the warehouse to help

in report development and decision making to analyze and improve the

performance.

Responsibilities:

Developed PL/SQL Packages, Procedures and Functions for Various Extract

Process run through UNIX Jobs.

Coded PL/SQL Packages and Procedures using Bulk Binding, for all

Statements, Dynamic SQL and Cursor Variables.

Tuned PL/SQL Packages and Procedure to manipulate large no of data using

collections like nested tables and arrays.

Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

Created Schema Objects like Tables, Views, Materialized views, Sequences,

Constraints, and Indexes.

Developed UNIX Shell Scripts for Autonomous Jobs.

Experience in developing logical and physical database design, data

modeling using Erwin.

Designed, Developed and Tested application in UAT environment and Deployed

in Production.

Provided Productions supports and ongoing user supports for the

application.

Designed Development Documentation and Support Documentations.

Involved in creating and managing tables, indexes, db links and

privileges.

Utilized SQL*Loader to load flat files database tables.

Involved in converting database to Archive Log mode as well as enabling

Flashback mode.

Extensive use of several Oracle provided packages such as

UTL_FILE,DBMS_JOB,and DBMS_SCHEDULER.

Partitioned large Tables using range partition technique.

Controlling User Access and Granting System privileges as per Client

requirement.

Client : GlaxoSmithKline GSK, Parsippany, NJ

Duration : August 2012 - July 2013

Role : PL-SQL Developer

Environment : Oracle 11g, Windows XP, PL/SQL, SQL*PLUS, SQL Developer,

UNIX.

GSK is science-led global healthcare company that researches and develops a

broad range of innovative medicines and brands. In this we worked for

solutions to our clients to improve their customer services. This helped to

increase the systems online order processing.

Responsibilities:

Gathering business requirements from end users.

Request reports from frond end report module and then Running modified

reports using UNIX shell scripts.

Developed complex scripts for the data analysis to check the quality of

data using regular expressions at database level.

Developed various procedures, functions and packages to implement the new

business using Oracle PL SQL.

Statement level, row level database triggers were developed for auto

updating the data.

Responsible for code development using PL/SQL in UNIX environment.

Responsible for scheduling jobs from CRON using SHELL scripting

Responsible for Data migration using SQL loader and PL/SQL code.

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

database performance.

Performed SQL, PL/SQL tuning and Application tuning using various tools

like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an

optimum query execution plan.

Created PL/SQL scripts to extract the data from the operational database

into simple flat text files using UTL_FILE package.

Used Pragma Autonomous Transaction to avoid mutating problem in database

trigger.

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.

Responsible in code review and design document preparation.

Was responsible to communicate with End client to support the application

and analyze the issue and fixed the issue.

Preparation of Test Plans.

Company : 3i-infotech Pvt Ltd.

Clients : ICICI BANK,State Bank of India,Axis Bank,Sampath Bank

Duration : May 2007- July 2012

Role : PL-SQL Developer and Oracle Database Administrator

Product : AMLOCK

OS : Windows XP/2000, Linux

Environment : Oracle 11g, Mssql sever 2008,Windows XP, PL/SQL, SQL

Developer,UNIX

Product Description :

AMLOCK, the Anti-Money Laundering and Fraud Detection Software for Banking

and Finance Organization. The AML compliance requirements of Banks,

Insurance companies, Brokerages, Asset Management Companies and Money

Service Businesses enables them to file Compliance Reports. Amlock is an

early-warning system that awakens and sensitizes you to often deep-rooted

and virulent bank abuse. Amlock is a state-of-the-art Anti Money Laundering

and fraud detection software developed for banks and other financial

institutions, which help them to achieve compliance with AML regulations

and thereby protect their integrity and reputation. Amlock facilitates the

identification of transactions that harm the stability and reputation of

the institution and banks from the viewpoint of money laundering. Amlock

enables Banks and Financial Institutions to process transactions either in

real-time or on offline basis, and checks for the abnormal behaviour of a

customer. It enables banks to identify those transactions that harm the

stability and reputation of the banks and financial institution by

involving them in illegal transactions.

Responsibilities :

Involved in the data transfer and creating tables from various tables,

coding using PL/SQL, packages stored procedures and triggers.

Involved in creating and managing tables, indexes, db links and

privileges.

Developed back end interfaces using PL/SQL stored packages, procedures,

functions, Collections, Object types and Triggers.

Utilized SQL*Loader to load flat files database tables.

Developed user documentation for all the application modules.

Involved in converting database to Archive Log mode as well as enabling

Flashback mode.

Partitioned large Tables using range partition technique.

Controlling User Access and Granting System privileges as per Client

requirement.

Review of procedures, functions and other Database objects before any patch

delived to Client.

Provided added security features in the application. Security features

includes password file authentication and authorization, first time login

check, number of invalid passwords check, session management, specific time

login check.

Involved in performance tuning at database level.

Generated AWR reports for analysing the performance.

Used Bulk Collections for better performance and easy retrieval of

data.

Fine-tuned procedures/SQL queries for maximum efficiency in various

databases using

oracle hints.

Involved in the continuous enhancements and fixing of production issues.

Participated in the ongoing process enhancements and modification requests

Coordinated with the offshore support team in resolving critical issues

Worked on database backups using Recovery Manager (RMAN) & used RMAN

backups for recovery.

Company : 3i-infotech Pvt Ltd.

Clients : Agricultural Bank of China, Singapore, National Bank of

Bahrain, ICICI, Axis Bank

Duration : May 2007- July 2012

Role : PL-SQL Developer and Oracle Database Administrator

Product : SWIFT

OS : Windows XP/2000, Linux

Environment : Oracle 10g, MSSql Server 2005, Pramati, WebSphere

Product Description :

Swift: Swift Check (AML system for swift messages)

SWIFT Check is real-time Anti Money Laundering and fraud detection software

for SWIFT Messages, has been developed using Java-J2EE as programming

language and Oracle and SQL Server as database management systems.

Responsibilities :

Worked on development of various types of reports.

Coding of stored procedures (PL/SQL) in Oracle, SQL Server.

Enhancing the Security of the application by adding additional access

permissions for users.

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

Worked on database backups using Recovery Manager (RMAN) & used RMAN

backups for recovery.

Setting up the application at the client place. Understanding client

requirements (change requests) and doing an impact analysis.

Onsite project co-ordination and Responsible for achieving milestones

according to the project plan.

Involved in extensive use of several oracle provided packages such as

UTL_FILE,DBMS_JOB and DBMS_SCHEDULER

Worked on normalizing Techniques.

Involved in performing tests on the newly coded procedures and documenting

the same.

Involved in delta changes (modification related to database with each

release),adding /modifying objects.

Writing technical documents using the functional specifications.

Involved in unit testing and resolving technical issues in team .

Developed user documentation for all the application modules.

Fine-tuned procedures for maximum efficiency in various schema's across

databases using Oracle Hints, execution plan .

Contact this candidate