SUMMARY

• Around 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized viewsfor data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such DBMS SQL,DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuningfor Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2 and MS Access.

Reporting Tools: Oracle reports/froms 6i/10g,xml publisher, Discoverer10g

Operating Systems: UNIX(Sun Solaris, LINUX), Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts,Java, XML, C and Cobol.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Sr Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tablesfor automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma 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 usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP,D2K

Confidential

PL/SQL Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Created management analysis reporting usingParallel Queries, Java stored procedure, HTP Packageand WEB.SHOW DOCUMENT.
• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience incomplete System Development Life Cycle.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance.
• Involved in ETL code using PL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• 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.
• DevelopedUNIX Shell scriptsto automate repetitivedata base processes.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.

Confidential, New York

Oracle Developer

Responsibilities:

• Used OracleJ-Developer to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number ofFormsand for various modules.
• Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used OracleJ-Developer to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Provided user training and production support.
• Improved the performance of the application by rewriting theSQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, TOAD.