PROFESSIONAL SUMMARY:

• Six plus years of IT experience as an PL/Sql developer, Oracle Developer, System Analysis, Design, Development & Support of Oracle Database 9i,10g and 11g in Production,staging and Development environments.
• Involved in all phases of SDLC(Software Development Life Cycle), from analysis,design,development,testing,implementation and maintenance with timely delivery againstaggressive deadlines.
• Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures,Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.
• Very good experience in Oracle tools like SQL*PLUS, SQL*Loader, SQL Developer using TOAD in secure databases.
• Very good knowledge of SQL, PL/SQL especially writing queries with join, sub - queries, rollups, cubes, Set Operators.
• Extensive experience in using Oracle seeded packages like DBMS OUTPUT,DBMS SCHEDULER, UTL FILE, DBMS SQL, DBMS STATS .
• Expertise in handling errors using Exceptions with RAISE application clause.
• Experience with Oracle utilities like Export/Import and data pump utilities.
• Knowledge of Materialized Views .
• Expert in Creating Public Synonyms, DB Links.
• Managing security by creating and granting roles and privileges to users.
• Experience in developing External Tables, Table, Views, Joins, Cluster indexes, Cursors
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref.cursors, varrays, nested tables and Dynamic SQL.
• Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables,
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Very good knowledge of advanced features like overloading subprogram, Persistent state of package (PRAGMA SERIALLY REUSABLE).
• Proficient in Query/application tuning using optimizer hints, Explain plan.
• Extensive use of Crontab in UNIX environment for scheduling routine tasksExperience in designing data models using ErwinGood experience working with various FTP protocols like SFTP, SCP using SSH protocol.Experience with data warehouse design using Star Schema and Snowflake schema
• Results oriented, quick and eager to learn any concepts, programs or procedures that may serve to enhance company growth potential.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.
• 24/7 Production Database Support & Maintenance.

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Sun Solaris 5.8/5.9/5.10 , IBM AIX 5.2/5.3,Windows NT/95/98/2000/XP

Databases: Oracle 11g/Oracle 10g,Oracle 9i, Ms Access

Utilities: SQL*Loader, Data Pump, Explain Plan, FTP,SFTP,SCP

Tools: Import,Export, TOAD 9.5, Putty, SQL Developer, Erwin, SQL*Loader, SQL*Plus, MS-FrontPage, MS Office Suite, Hummingbird 10,iSql Plus

Languages/ Edittor: SQL, PL/SQL, UNIX Shell Programming,Vi Editor

Others: MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge,NJ

PL/Sql Developer

Responsibilities:

• Involved in loading data through Oracle SQL* Loader from text files.
• Constructed Tables, Views, Synonyms and Indexes for security, faster execution and resource Utilization.
• Used Cursors to capture many rows within a PL/SQL block and applied business rules on them
• Customized data by adding calculations, summaries and functions.
• Widely used joins, sub queries and set operators to generate report for complex business requirement.
• Created packages, stored procedures, and functions.
• Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQLTRACE.
• Used overloading subprogram to create complex package structure with multiple procedures with same name.
• Created triggers to track and store invalid data entry in separate table
• Modified existing Oracle Procedures, Functions & Packages to understand business logic.
• Understanding business rules & Created intermediate views for queries involving complex joins .
• Extensively used bind variables to improve query performance.
• Used Bulk Collect,Bulk Insert, Forall statements
• Worked on User-defined and also the System defined exceptions to handle different

Environment: UNIX, Oracle 11g, PL/SQL, SQL * PLUS, PL/SQL Developer, ToadSQL Developer, Erwin

Confidential, Newyork City,NY

PL/Sql developer

Responsibilities:

• Configured and designed Entity Relationship Diagram (ERD) with Data Design Team to illustrate the logical structure of database
• Involved in Requirement gathering and writing Functional and Technical documents
• Wrote both Implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them, mainly to update data within table
• Used exception handling methods along with pragma exception initin order to associate our own created exception names
• Created materialized views & normal views where business requirements needed
• Extensively used the DBMS OUTPUT, UTL FILE oracle supplied packages.
• Widely used ROLLUPS and CUBES to in query to generate super aggregate and cross-tabulation rows for certain business requirement
• Frequently used conditional control structure with explicit cursor to update stored information in table.
• Extensively used Partition of table for transactional entry of data.
• Created sequence for customer ID allocation.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customerinformation).
• Changed package specification to alter persistency of package state using PRAGMA SERIALLY REUSABLE clause.
• Involved in Tuning, Performance and Optimization of queries and standardization of the code.
• Extensively created and used the composite data type (Records and Collections) within procedures and packages.
• Build the triggers with condition predicates to restrict invalid entries in table with clause RAISE APPLICATION ERROR.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Extensively used Cartesian product to generate large amount of data for testing environment.
• Defined various constraints at the level of creation of table to restrict data entry.
• Wrote UNIX Shell Scripts to automate load process, scheduling batch jobs in Crontab.
• Worked in unit, integration and performance testing.
• Prepared Technical Documentation for easy understanding by other developers.

Environment: Oracle 10g,SQL Developer, SQL Loader, UNIX/AIX.

Confidential, Pittsburgh,PA.

Oracle PL/Sql Developer

Responsibilities:

• Responsible for Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Used PL/SQL tables, PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problems in database triggers
• Scheduled batch jobs for loading database tables from flat files using SQL*Loader.
• Developed stored procedures and complex packages using PL/SQL for maintaining Patient Information.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Use of EXPLAIN PLAN, ANALYZE, HINTS,Tkprof to tune queries for better performance
• Extensively used the advanced features of PL/SQL like collections, nested table, varray.
• Used Oracle 10g new feature data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server.
• Used a CALL statement enables you to call a stored procedure, rather than code the PL/SQL body in the trigger itself.
• Created Indexes and sequences for faster retrieval of the customer information andenhance the database performance.
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Extensively used the DBMS SESSION, DBMS STAT, DBMS SCHEDULER oracle supplied packages.
• Created Documentation of development code and the test cases involved.
• Developed flat files using UTL FILE Oracle supplied packages.
• Worked extensively on exception handling, to trouble-shoot PL/SQL code.

Envirnoment: Oracle 10g, Putty, TOAD 8.5, UNIX/Sun Solaris, Oracle Enterprise Manager, Crystal

Confidential

PL/Sql Developer

Responsibilities:

• Designed and developed a custom database (Tables, Views, Functions, Procedures, andPackages).
• Monitoring existing SQL code and performance tuning if necessary
• Extensively involved in new systems development with Oracle 9i.
• Interact with business analysts to develop modeling techniques.
• Documentation of all modules for user level.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code
• Used Import/Export utilities of Oracle.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Writing Tuned SQL queries for data retrieval involving complex join conditions.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Read data from flat files and load into Database using SQL*loader.
• Created the External Tables in order to load data from flat files and PL/SQL scripts for monitoring
• Involved in Unit Testing of newly created PL/SQL blocks of code.
• For increasing the performance of all the collection-based DML used FORALL and also scanned the collections using FIRST, LAST and NEXT in loops.
• To conserve the resources used the anonymous blocks within the IF statements.
• Used the pragma Exception Init to name the system exceptions that are raised by the program.

Environment: Sun Solaris UNIX, Oracle 9i, ERwin 4.0,Oracle Forms 6i., SQL*PLUS

Sql Developer

Confidential

Responsibilities:

• Active Participation in the System Study.
• Assisted in designing the system flow.
• Created tables, indexes and views
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design. conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Performed the set up the VSS source code architecture for the client.
• Performed code reviews.
• Used SQL Navigator to reverse engineer the model of the legacy applications.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Managed and resolved design issues during development.
• Improved query performance using better joins and Hints appropriately.

Environment: Oracle 9i, SQL*Plus, PL/SQL, Toad, MS Windows 2000