Kuldeep Kaur-480-***-****

Senior Oracle Developer

acczrn@r.postjobfree.com

Summary:

. Oracle PL/SQL Developer with Over 10 years of experience in

developing and supporting all stages of systems life cycle

including Analysis, Development, Testing, Implementation and

Support using Oracle SQL, PL/SQL on UNIX and Windows

environment.

. Hands on experience working on Oracle 8i/9i/10g/11g databases

on various platforms like SUN SOLARIS, UNIX, Red Hat Linux and

Windows (98/XP/2000).

. Hands on experience in UNIX shell Scripts, Perl Scripts, Connect

Direct NDM, MQ Series, and CDftp.

. Extensive experience in developing Database Objects, Triggers,

stored procedures, Functions, Packages. Materialized views.

. Developed Oracle based (SQL and PL/SQL) programs for the

creation of ad hoc queries/reports, including requirements

gathering, design, coding and unit testing.

. Extensively involved in writing SQL queries (Sub queries and

Join conditions), PL/SQL programming and Query Level

Performance tuning.

. Extensively worked on Collections, Bulk Binds, Bulk Collects

and Table Partitioning.

. Excellent in writing Shell Scripts using (Sh, Ksh, Bsh) for

database transactions and batch processing.

. Experience in using different Transformation tools like DTS

packages, BCP, and BULKINSERT, familiarity with SSIS.

. Experience in performance tuning of using EXPLAIN PLAN,

TKPROF, SQL Trace, and Oracle Hints to improve the

performance.

. Having good knowledge with crystal reports.

. Proficient in using Oracle tools such TOAD, SQL Developer,

SQL*PLUS and SQL Navigator.

. Experienced in Loading data into multiple tables using DB

Management Tool like SQL*LOADER, Import/Export, Data pump.

. Strong interpersonal, analytical and communication skills,

proven ability as an efficient team member in System Analysis,

Design, Development, Migrating and documentation.

. Experienced in providing quality operational Support for

Production Environments.

. Good knowledge of domestic/international equities trading and

Fixed Income Trading.

Technical Skills:

Databases: Oracle 8i/9i/10g, MS SQL Server, MS Access

Operating Systems: Windows 95/98/XP/2000/NT 4.0, UNIX, Linux and Sun

Solaris

Tools & Utilities: PL/SQL Developer, SQL*Plus, SQL Loader, Toad

8.6.1, SQL Developer, IBM MQSeries-5.1/5.3, Connect Direct NDM 3.3/3.6.

Reporting Tools: Oracle Report 6i

Tuning Tools: STATSPACK, TKPROF, EXPLAIN PLAN

Internet Technologies: ASP 2.0, JavaScript, HTML, XML, Coldfusion

Languages: C, C++, Java, SQL, PL\SQL, VB

Version Control: CVS, Clear Case

IT Concepts: Relational Database Management System, OOAD, Data

Warehousing

Educational Qualifications

Bachelor of Engineering in Computer Science from Punjab University, Punjab,

India-2001 (70 %)

Oracle SQL/PLSQL 9i certified professional

ITIL Certified

Professional Experience:

Deutsche Bank, US

Senior Oracle Developer - May 07 - till date

NYBOSSS, Deutsche Bank Securities - NJ

Description:

NYBOSSS is the New York Back Office Securities Settlement System of

Deutsche Bank. NYBOSSS consist of set of various applications dealing with

back-office securities settlement which receives the trade from trade

capture systems and sends them to third party systems, clearing agents for

processing. The DTE (Distributed Trade Entry) Equities system deals with US

domestic equity settlements and has interfaces to DTCC (Clearing

Corporation), SIAC (Shared gateway for NYSE and AMEX) and ADP BPS (external

vendor used for clearing and book-keeping). The reporting is done through

ADP's BPSA system.

Responsibilities:

. Involved in interaction with the client to identify the functional

requirements.

. Involved in the Analysis, Design, Coding, Testing, Implementation and

Support of the applications.

. Involved in the development of packages, materialized views,

procedures, functions which were used by the front end/back end system

. Tuned the queries using the oracle hints and creating the necessary

indexes using EXPLAIN PLAN utility.

. Supported the front end system developed by ColdFusion, Java

. Wrote shell Script KSH, Perform job schedule on CRONTAB on Solaris 8/9

and generate reports

. Did various up gradations to the present application as per the

customer request

. Wrote Complex Queries, Store Procedures/Functions, Views, Triggers and

Synonyms to maintain the Business Rules.

. Extensively used SQL*LOADER to load data from flat files received from

various facilities on daily basis into the database tables

. Worked with Offshore Team and fix the troubleshooting in DBMS and

Applications to support the customers remotely

. Involved in migration of entire database from Oracle 9i to Oracle 10g.

Environment: Sun Solaris, Oracle10g, Shell Scripting (KSH), Perl Scripting,

VSS, MQ Series, ConnectDirect FTP, ColdFusion, Java, Reports 6i, TOAD 8.6,

PL/SQL Developer7.0 etc.

Capital Groups, US

Oracle Developer - Aug 06 - May 07

IDI Web-Index Data Information

The IDI-Web is a web-based application for Capital Groups, US envisaged to

share the latest index related information available in a centralized

repository to the users on the intranet. The application maintains the

index information & Constituent information provided by external sources of

MSCI, FTSE, S&P, TOPIX, DJStoxx, HangSeng, SPI, CitiGroup and RUSSELL.

Responsibilities:

. Analysed the business requirements of the project by studying the

Business Requirement Specification document

. Creation of database objects like tables, views, Materialized views,

procedures, packages using Oracle tools like PL/SQL, SQL* Plus,

SQL*Loader and Handled Exceptions.

. Prepared program specifications for PL/SQL Procedures and Functions to

do the data migration and conversion.

. Worked on Perl scripts to transfer files using FTP to all the servers

at one time.

. Maintained documentation of functional/technical designs and test

cases to support development life cycle.

. Assisted QA team User Acceptance Testing performed against the

modified applications.

Environment: Windows, Oracle 9i, Java, Perl Script, Visual Source Safe

(VSS), SQL*Plus, PL/SQL Developer, Eclipse, SQL * Loader, TKProf.

Wipro, India

Oracle Developer - Jan '06 - Jun '06

MYERP-Enterprise Resource Planner

MYERP-Enterprise Resource Planner is an ERP package for Leather line

Tanneries Pvt. Ltd. And Turbo Scaffolding Ludhiana. Under This ERP various

Modules are covered such as Finance, Production, Warehouse, Purchase,

Sales, and Personnel. The Finance Module covers all the vouchers,

maintaining the ledgers, cash Book, Sales Registers, Purchase Register,

Debit Note of any Party and Other Various Features.

Responsibities:

. Designed and Developed Oracle database Tables, Views, Indexes, and

Synonyms with proper privileges.

. Involved in creating stored procedures, functions, database triggers

and packages using Dynamic SQL.

. Involved in design, implementation, testing and deployment of Forms

using HTML, JavaScript, and ASP.

. Involved in generating new reports using Reports 6i and Report

Templates.

. Enhanced the existing UNIX scripts to run batch processes, oracle

background processes using JOBS & achieve better performance and

throughput.

. Responsible for development and testing of conversion programs for

importing data from text files into Oracle database utilizing PERL

shell scripts & SQL *Loader.

. Involved in the Daily maintenance of the database that involved

monitoring the daily run of the scripts as well as troubleshooting in

the event of any errors in the entire process.

Environment: Windows, Oracle 8i, HTML, CSS, JAVASCRIPT, XML, RATIONAL

CLEARCASE etc.

Masiv Solutions, India

Base COM - Database Commercials

Aug '05 - Jan '06

This application handles stock trading data, and was created to

help user enter the trade transactions, to provide reports, and to

maintain data transfers, this handles large transaction data

volume.

Had responsibilities in development and migration of application

from to new database.

Responsibilities:

. Designed and developed database tables and procedures and

triggers.

. Developed common library of functions used in retrieving user

id, passwords and to execute sql scripts from UNIX shell

scripts.

. Modified some UNIX shell scripts to use the common library of

functions written to retrieve the user id, password and to

execute sql scripts.

. Modified and tested the web forms in Interactive Keynote

application based on the design documents.

. Performed User Acceptance testing for the Keynote and

Interactive Keynote applications with modified modules in

place.

Environment: Windows, Java, J2EE, ORACLE 8i.

Masiv Solutions, India

BSNL Telephone Billing Information System

Aug '04 - Jul '05

This application is a web-based information retrieval for Oracle-

based telephone Billing Information Systems.

Responsibilities:

. Had responsibilities in applying a multi-level security for

application front end (online billing statements).

. Developed and source control of table creation scripts,

database functions and triggers.

. Development of Web based programs using HTML, Java Script, and

ASP

. Implementation, System testing and Acceptance testing.

. Development of reports and report generation scripts.

Environment: Windows, Java, J2EE, ORACLE 8i, HTML, JavaScript, ASP.

Masiv Solutions, India

Inventory Control

Jan '03 - Jul '04

This application fulfills office requirements to manage and control

its inventory and warehouse.

It was concerned with minimizing the total cost of inventory. This

application handles Inventory levels of each item in the stock, handles

under-stocked elements, and keeps history of all sales record that helps

mangers to take important decisions.

Responsibilities:

. Development and source control of table creation scripts, database

functions and triggers.

. Development of Web based programs using HTML, Java Script, ASP

. Implementation, System testing and Acceptance testing.

. Development of reports and report generation scripts.

Environment: HTML, CSS, JAVASCRIPT, ASP, ORACLE 8i, Reports 6i

Contact this candidate