Oracle Pl SQL developer

Meenakshi Padmanaban E-mail: ****.***@*****.***

Contact: +1-646-***-****

Experience Summary

Over 3 years of professional experience as an Oracle PL/SQL developer across application development, maintenance and support lifecycle using the Oracle Relational Database Management System (RDBMS)

Expertise in UNIX programming and shell scripting

Hands on technical experience in developing applications using Core Java, Servlets and JSP

Involved in requirement review, design, development and testing phases of Software Development Life Cycle (SDLC)

Worked with applications like Banking Information Systems and Financial Accounting.

Confident, positive attitude and eagerness to learn new things and highly adaptable

Enjoys working in team and has fine communication and interpersonal skills.

Ability to be an effective team player and work under compressed timeframes

Technical Skills

Programming Languages

Core Java, UNIX-Shell scripting,PL/SQL, C

Databases

Oracle 9i,10g,DB2

Scripting Languages

HTML, XML, JavaScript

Operating System

Windows, UNIX

Tools

Rapid SQL, Toad, Control-M, ServiceNow, Sharepoint, Introscope, Sitescope

Configuration management tool

PVCS, TFS

Employment History

Name of the Company

Designation

From

To

Cognizant Technologies Solutions, India

Programmer Analyst

Nov 2011

Jan 2015

Education

Degree

College/University

Score

Bachelor Degree (B.E) in Electronics and Communication Engineering

Anna University India

80%

Higher Secondary Certificate

NSNMHSS, Tamil Nadu State Board India

88%

Secondary School Leaving Certificate

NSNMHSS, Tamil Nadu State Board India

86%

Relevant Project Experience

Organization: Cognizant Technology Solutions, India

Project: Global Securities Lending (GSL)

Title Global Securities Lending

Client Leading US based financial services organization

Operating System Windows, UNIX

Tools Eclipse, Rapid SQL, Remedy, Toad, Control M, ServiceNow, SharePoint

Language Core Java, XML, Unix Shell scripting, PL/SQL

Database Oracle 10g

Team Size 30

Period Apr 2012 – Jan 2015

Project Description

The Global Securities Lending (GSL) suite of applications facilitates the Securities Lending business operations which can be defined as the temporary transfer of securities by the beneficial owner (the lender) to another investor/intermediary (the borrower). GSL is a lending agent, given the duty of managing the transaction and executing the lender’s investment objectives. These agreements arise when a holder of securities agrees to provide them to a borrower for a period of time. Securities held in the portfolio of the clients are provided to the broker for a fee. The Bank and the client share in the proceeds of that fee. The process ensures that lending of securities and attaining the proper collateral occur seamlessly. The division is also responsible for ensuring that all collateral and securities are balanced and accounted for and properly recorded within the Securities Lending Division. The division also ensures that earnings generated from the program are properly allocated to the appropriate parties (Client/Bank).

The Securities Lending Division of this leading financial services uses DB2/Oracle to house data from the mainframe and other sources. Oracle acts as a data warehouse for reporting purposes. The scope of this project is the on demand Development of Cobol/DB2, UNIX and Java codes and Oracle stored procedures for the Global Security Lending System.

Assignment 1: GSL Expense Docket Team (13 months)

Worked as part of Expense Docket team and involved in project enhancement tasks

Roles and Responsibilities

Extensive client interaction and business user interaction for requirements gathering

Worked on Docket projects from requirement analysis till production phase (Analysis, Coding, Testing, Reviews, UAT with Client BA’s, production installs and end user signoff after successful installation)

Creation of Oracle table and procedure for client management reporting

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

Modified several UNIX shell Scripts according to the changing needs of the project and client requirements

Improved performance and stability of database systems

Maintained documentation for technical systems

Trained new members on business and application

Prepared project monthly status report, weekly status report and sent the metrics to the client

Assignment 2: GSL Production Support Team (7 months)

Been part of production support team which involves resolving issues and ad-hoc user requests

Roles and Responsibilities

Involved in the continuous enhancements and fixing of production problems.

Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.

Investigated and implemented solutions for data quality issues.

Responding to user queries and resolving the job abends without compromising the SLAs

Communicating and working along with clients during outages and handling the situation

Providing temporary and permanent fix to resolve issues during UNIX job abends

Coordinating with upstream and downstream teams during job delays and outages

Assignment 3: GSL Development Team (15 months)

Worked as part of major development projects

Roles and Responsibilities

Coordinated with the front end design team to provide them with the necessary stored procedures and the necessary insight into the data.

Responsible for developing UNIX script and Java code for sending reports as pdf files and sending reports embedded in Email

Involved in developing codes, testing and ensured coding standards for development project

Assisted in designing and programming for the system, which includes development of Process Flow Diagram, Entity Relationship Diagram, Data Flow Diagram and Database Design

Involved in Transactions, login and Reporting modules, and customized report generation, Testing and debugging the whole project for proper functionality and documenting modules developed

Been responsible in developing table loading procedures using PL/SQL

Wrote SQL, PL/SQL programs required to retrieve data using cursors

Created and modified Java scripts for data conversions.

Developed and maintained proper data extraction processes

Personal Details

Name Meenakshi Padmanaban

Marital status Married

Date of Birth 2-SEP-1989

Nationality Indian

Visa Type H4 – EAD

Validity till 02-12-2018

Languages known English, Tamil and Hindi

Residential address 2229, Riverside Station Blvd.,

Secaucus, New Jersey 07094

Mobile # +1-646-***-****

Contact this candidate