Sql Data

Madhu Reddy

SUMMARY:

. * years of experience in Application development and Production

support using Oracle SQL, PL/SQL.

. Expertise in performing Data export, Import and various operations

using TOAD, SQL DEVELOPER, FORMS AND REPORTS.

. Extensively worked in Client-Server application development using

Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and

Export Utilities.

. Experience in application development using various advanced features

of Oracle like Bulk Collections, Table Functions, Autonomous

Transactions, Dynamic SQL, Object types and Records.

. Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic

SQL.

. Developed Complex trigger using PL/SQL for data integrity and

enforcing business rules.

. Moved columns of data in and out of database tables using PL/SQL

program units by passing collections as parameters.

. Extensive experience in data migration techniques using Oracle

External Tables, SQL* LOADER, UTIL file loader and batch processing.

. Experienced in data analysis, data modeling, development, testing and

documentation of projects.

. Carried out testing in test database for upgrading/migrating from

Oracle 9i to Oracle 10g.

. Experience in developing logical and physical database design, data

modeling using Erwin & Informatica (Power Center 6.1).

. Involved in creating mappings, transformations in Informatica, tuning

& monitoring workflows.

. Developed Pro*C programs as required to interface with the existing

systems in place.

. Used Cursor Variables to pass query results sets between PL/SQL

programs and client application.

. Extensively worked on the Extraction, Transformation and Load (ETL)

process using PL/SQL to populate the tables in database.

. Experience with DBA activities like creating table spaces, granting

and revoking privileges on database objects.

. Developed and maintained data preparation and validation routines to

support data warehousing

. Improve the performance of the slow SQL queries by implementing

indexes, using FORALL and BULK COLLECT.

. Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH

applications using STATSPACK, Explain Plan, TKPROF, Hints in Oracle

9i.

. Experience in UNIX Shell Scripting for batch processing.

. Comfortable to work with a team or work individually.

. Highly motivated self-learner with ability to develop proficiency and

adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:

RDBMS Oracle 11g/10g/9i/8i

Oracle Tools SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL

Navigator, Developer

2000 (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g),

SQL*Plus, Discoverer, Power Builder 12.

ETL Tools Informatica Power Center 8.6.X/6.1, Data stage

Data Modeling Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Tools

Data Analysis Requirement Analysis, Business Analysis, Detail Design,

Data Flow Diagrams, Data Definition Table, Business

Rules, Data Modeling, Data Warehousing, System

Integration.

Programming Unix Shell Scripting, Perl Programming, XML, C,

Languages C++,Java, HTML,XML

Environment Sun Solaris 2.6/2.7/2.8/8.0, Red Hat Linux,Windows

NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

EDUCATION:

Bachelors in Engineering

JNTU-INDIA

Contact this candidate