SUMMARY

• 7 plus years of IT experience as an Oracle Developer on a variety of UNIX (Solaris, Linux), Windows / XP platforms with Oracle 9i/10g/11g.
• Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support.
• Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, and Triggers.
• Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD in many development projects.
• Good at Shell scripting and Pearl scripting and used Crontab for scheduling jobs regularly.
• Extended knowledge of Relational Database Management Systems (RDBMS).
• Extreme experience in using SQL*Loader for loading data into single table and multiple tables.
• Experience in using oracle packages such as DBMS STATS, DBMS JOB, UTL FILE and utilities like UTL SMTP.
• Experience in developing External Tables, Joins, indexes and Database Triggers.
• Extremely used of the latest features to optimize performance like Bulk Binds, Bulk Collect, Ref. Cursor and Sys ref cursor.
• Proficient in using advance features for PL/SQL programming like Using cursor variables, Ref. cursors, System Ref. cursor and Dynamic SQL.
• Extreme Use of exception handling methods along with pragma exception init in order to associate our own created exception names.
• Experience in creating Global Temporary Tables.
• Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization and de-normalization.
• Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
• Experience with Database SQL and PL/SQL tuning and query optimization tools like Explain Plan, DBMS PROFILER, and SQL TRACE.
• Extreme Knowledge of transferring data between different servers using Export/import and Data Pump utilities like expdp/impdp.
• Experience in working high transacted OLTP systems.
• Expertise inDynamic SQL, CollectionsandException handling.
• Worked on Informatica sessions/mappings /transformations.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines. Able to work independently and as team member.
• Worked as a Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.

TECHNICAL SKILLS

Databases: Oracle 11g,Oracle 10g,Oracle 9i, MS-Access

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows NT/2003/2000/XP/98

Utilities: SQL*Loader, Export / Import, Expdp / Impdp, Oracle Wrap, FTP,SFTP, Cute FTP

Languages: SQL, PL/SQL, Shell Programming, C

Tools: TOAD, SQL Developer, Win CVS, Win SCP, Putty, F-Secure Client 5.3, SQL*Loader, SQL*Plus, OracleJ Developer 10.1.3.3, ERWIN, Informatica, SSH Tectia

Operating Systems: Unix, Red Hat Linux, Sun Solaris 5.8/ 5.9/5.10, IBM AIX 5.2/5.3, HP-UX, Windows NT/20X/9X, Windows XP, Windows Server 2003

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Extensively involved in System Study & Business Requirements Analysis.
• Involved in the preparation of Functional Specs as part of the solution team.
• Co-ordination with the Business for the requirement and translate the business needs into Technical design.
• Strong analytical skills in resolving and providing solutions.
• Handling Major /Minor Enhancements for the application.
• Involved in MIGRATION of source systems from Oracle to Teradata.
• Responsible in Designing and development of Logical& Physical Data models, Forward and Reverse engineering using Microsoft Visio.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Create Oracle Partition tables like Range/List/Hash/Composite.
• Developed shell scripts for batch processing and database transactions.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Generating trace files using TKProf and analyzing the explain plan.
• Worked on the solution designing and giving inputs to handle complex solutions.
• Worked on the design of Business Objects Universe and developed the web intelligence reports as per the business requirement.
• Worked on UNIX-shell Scripting.
• Prepared the technical document as per the Functional specifications.
• Worked on Informatica sessions/mappings /transformations.
• Worked on queries using Teradata SQL assistant.
• Provided support during the UAT/BAT/QA phases.

Environment: Oracle 11g, PL/SQL, Toad 10.6.13, Informatica 9.5.1, SSH Tectia, Windows 2003/XP, UNIX, Microsoft Visio

Confidential, Santa Clara, CA

Oracle PL/SQL Developer

Responsibilities:

• Involved in system analysis, Design, Coding, Data Conversion, Development and Implementation.
• Data transfer from Input tables to the Output tables using procedure.
• Used overloading function to define several closely related versions of a procedure without having to differentiate them by name.
• Wrote Package containing several Procedures and Functions in PL/SQL to validate the Bond Balances before loading into Application database.
• Created various database objects like views, indexes, sequences, synonyms.
• Used Wrappers for code security of the procedures and packages.
• Extensively involved in writing SQL queries (Sub queries and Join conditions) and PL/SQL programming.
• Involved in Creation of tables, partitioning tables, Join conditions, and correlated sub queries, for the business application development.
• Experience in partitioning and sub-partitioning like range, list, and hash.
• Worked on user-defined and also the system defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT.
• Expert knowledge in cursor, ref cursor, system ref cursor, collection and dynamic SQL.
• Made use of for all and bulk Collect feature to process the data from cursor/ Ref Cursors and put the processed data into a collection.
• Interaction with the ETL team during the back end data repository.
• Monitored function based indexes with analytical function.
• Creation and usage of global temporary tables and temporary tables in the stored procedure for different applications.
• Managed table spaces for the tables created in my schema.
• Used automation of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in various UNIX platforms.
• Experience of using Oracle supplied package like UTL FILE, DBMS JOBS, DBMS SCHEDULAR, etc.
• Used set operators in PL/SQL like unions, union all, intersect and minus.
• Communicated with Oracle support via the Meta link in order to troubleshoot important issues.

Environment: Oracle 11g, PL/SQL, Toad 9.7, SQL Developer 2.1, Putty, Windows 2003/XP, UNIX, Win CVS.

Confidential, Richardson, TX

Oracle PLSQL Developer

Responsibilities:

• Heavily involved with the Logical and Physical Design of the Database.
• Creation of database objects like tables, views, procedures and functions.
• Developed PL/SQL-Packages, SQL Scripts and Database Triggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Wrote complex SQL queries with Co-Related Sub queries, nested loops for faster data retrieval from multiple tables.
• Extensively used cursors (refcursor, sys refcursor), sequences in the procedures according to the requirement.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS, and DBMS PROFILER.
• Used crontab, dbms job and dbms schedular for scheduling of jobs.
• Used Dynamic SQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Used SQLCODE and SQLERRM for the exceptions error code.
• Extensively worked on SQL Loader for loading data into tables from flat files and CSV files.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Developed UNIX shell scripts (Korn/Bourne/bash) for routine tasks.
• Used rollup, cube operators, merge with insert and update statements.
• Developed flat files using UTL FILE Oracle supplied packages.
• Creating and worked with GTT (Global Temporary Table).
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops while developing procedures.
• As a team member, involved in interacting with business users, gathering business requirement.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 10g, Solaris 5.10, UNIX, Windows XP, SQL Developer

Confidential, Atlanta, GA

ORACLE PL/SQL Developer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing.
• Utilized SQL developer tool in developing all back end database interfaces.
• Developed user documentation for all the application modules.
• Developed complex packages, stored procedures and functions to implement business logic.
• Worked extensively on exception handling to trouble-shoot PL/SQL code.
• Created Indexes and sequences for faster retrieval of the visitor information and enhance the database performance.
• Created table partitioning by range, list, hash and indexes for managing large tables, normalization and de-normalization.
• Data was loaded from flat files into to database tables using SQL* loader.
• Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQL TRACE.
• Extensive use of several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER.
• Used Crontab to run PL/SQL Scripts and stored procedures at a particular date and time.
• Generated DDL Queries for creation of new database objects like tables, views, indexes, triggers, stored procedures, roles and granting privileges.
• Designed Star Schemas to optimize user ease-of-use and retrieval performance by minimizing the number of tables to join to materialize a transaction.
• Involved in performance tuning with EXPLAIN PLAN and Indexes.
• Implemented Join conditions, group by functions, correlated sub queries.
• Created PL/SQL procedures and functions necessary for validation of transaction records into interface tables.
• Involved in technical documentation, and writing test plan.

Environment: Oracle 10g, SQL*Plus, Windows 2000 Professional, SQL*Loader

Confidential

ORACLE PL/SQL Developer

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC
• Involved in Requirement gathering & Analysis, Database designing and normalization of database tables.
• Used a CALL statement enables you to call a stored procedure, rather than code the PL/SQL body in the trigger itself.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Involved in the development of database objects.
• Involved in Oracle User creation & assigning Roles & Privileges.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Used the pragma Exception Init to name the system exceptions that are raised by the program.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Writing SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and ref cursor.
• Used Import/Export utilities of Oracle.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Good exposure in creating and maintaining UNIX Shell scripts.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX

Confidential

ORACLE PL/SQL Developer

Responsibilities:

• Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Created dynamic SQL to support dynamic nature of front to end applications.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used DBMS Supplied packages like DBMS PROFILER, DBMS JOB, etc.
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Wrote complex queries to generate reports as per client request as a part of production support.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX