SUMMARY

• Oracle Developer with over 7 years of IT experience in development, testing, and deployment of custom reports, forms, and workflows.
• Knowledge of Relational Database Management System (RDBMS).
• Extensive experience in writing PL/SQL Packages, Functions, Procedures & Triggers to implement the business logic.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs, UTL FILE to read and write from database.
• Extensive knowledge of SQL*LOADER.
• Experience in Data migration Projects which uses SQL Loader, PL/SQL programming, coding Procedures, triggers and functions.
• Good experience and understanding of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database
• Strong working experience in Data Analysis, Modeling, Logical and Physical database design.
• Experience in creating different kinds of Partitions on tables and indexes for managing large tables.
• Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Expertise in creating shell scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Strong experience with DATAPUMP utilities like EXPDP/IMPDP.
• Developed shell scripts to run the HYPERION (SQR PROGRAM) Reports.
• Worked on Database links and materialized views.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Good knowledge of tuning SQL, PL/SQL queries using hints, Explain Plan and SQL Trace, TKPROF.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers.
• Expertise in handling errors using Exceptions.
• Hand on experience in creating different kinds of partitions for managing large tables.
• Experience in working with high transacted OLTP systems.
• Worked on operators in PL/SQL like Union, Union all, Intersect and Minus.
• Worked with different types of sub queries (Inline, correlated) and used loops to enhance performance of the SQL queries.
• Used PRAGMA AUTONOMOUS TRANSACTION with the procedures.
• Experience on User - defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Strong work experience with tool like Toad, SQL Navigator, SQL Developer, SQL*PLUS, ERWIN.
• Hands on experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure and Winscp.
• Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing.
• Developed Unix Shell Scripts to Schedule jobs in Crontab.
• Used database objects to create Reports according to requirements using Crystal Reports.
• Familiar with the features enhancements in Oracle 11g.
• Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Ability to understand Functional specifications, Business requirements and technical Design documents.
• Excellent team player with the ability to work independently and interact with people at all levels.
• Good understanding of SQL tuning parameters.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

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

Databases: Oracle 11g, 10g, 9i, MS-Office.

GUI / Tools/Utilities: SQL* Loader, TOAD 8.0/7.1, PL/SQL Developer, Data Pump (Import/Export)SQL* PLUS, ERWIN 3.5/4.0, SQL Navigator MS VISIO, VI Editor, Oracle Wrap, FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint.

Operating Systems: Unix/Linux RHEL 5, Sun Solaris 2.x/7/8, HP-UX 10/11i, Windows XP/ NT 4.0/ 2000.

Scripting: Unix Shell Scripting

Reporting Tools: Crystal Reports 9.0

PROFESSIONAL EXPERIENCE

Confidential, MI

PL/SQL Developer

Responsibilities:

• Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java Scripts, Jsp and EJBs.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL and SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader.
• Involved in analysis, design, coding and Testing.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Generated SQL and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Executing and maintaining the data warehouse extract transform load (ETL) process
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Interacted with client to gather the requirements and implement the same in the project.

Environment: Oracle 10g/11g, HP-Unix, Oracle Enterprise Manager, SQL*Loader SQL*Plus, PL/SQL Developer, UNIX Shell Scripting.

Confidential, MA

Oracle Developer

Responsibilities:

• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Coded complex SQL queries to retrieve data from the database depending on the business logic.
• Designed Dimension and Fact tables for Star Schema and Snow Flake Schema to develop data warehouse
• Executing and maintaining the data warehouse extract transform load (ETL) process.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.
• Developed the ETL mappings in PL and SQL via packages, procedures, functions, views and triggers.
• Worked on DBMS SCHEDULER to schedule jobs.
• Worked on UTL FILE to read and write data from database.
• Work towards a balanced, risk-driven SDLC target.
• Worked on DBMS STATS and DBMS PROFILER to enhance performance of PL/SQL programs.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Created Logical and Physical Models using ERWIN.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Worked on DBMS STATS and DBMS PROFILER to enhance performance of PL/SQL programs.
• Used features like bulk collect to process large amount of data in data base.
• Created Logical and Physical Models using ERWIN.
• Managing Partitioned tables and Indexes for efficient and robust access of data.
• Written PL/SQL cursors for transaction processing.
• Involved in interacting with the end-user (client) to gather business requirements.

Environment: Oracle 10g/11g, HP-Unix, Oracle Enterprise Manager, VSS, SQL*Loader, SQL*Plus, Toad Data Modeler, UNIX Shell Scripting.

Confidential, VA

Oracle Developer

Responsibilities:

• Created Database Objects like Tables and Views as per Client Requirements.
• Actively Participated in different phases of SDLC.
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing the Queries to enhance the performance.
• Analyzed Indexes on regular basis.
• Involved in the optimization of Oracle queries.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Design, development and implementation of complex ETL Processes with Informatica 7.1.3
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.
• Implemented Triggers based on the business rules.
• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Worked with Dynamic Queries(SQL).
• Served as a technical expert in developing database designs for Data Warehouse.
• Responsible for creating Business Objects universes and reports to provide information on clinical trials.
• Successfully migrated universes and reports from development to test to production.
• Created users privileges and managed user roles and grants.
• Worked on DBMS SCHEDULER to automate jobs.
• Made use of DB LINKS for accessing data across different databases.
• Stored data in the audit log tables using the old and new column attributes.
• Loading data into the Database using SQL* LOADER.
• Used the Oracle Import/Export utilities for taking the backup of a particular partition data.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.

Environment: Business Objects XI r2, Oracle 9i/10g, HP-Unix, Oracle Enterprise Manager, VSS, SQL*LoaderSQL*Plus, Toad Data Modeler

Confidential, AZ

Oracle Developer

Responsibilities:

• Involved in developing SQL *Loader scripts for data loading.
• Created database objects like tables, synonyms, sequences and views.
• Gathered business requirements.
• Created procedures and functions to implement business requirements.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.
• Worked on Materialized view.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Wrote shell scripts in Crontab to automate Backend Jobs.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code. .
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.
• Created indexes for faster retrieval and improved query performance.
• Worked on PL/SQL Tables, Records and Collections.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Worked on Database Links to import/export data.
• Implemented triggers based on the business rules.
• Extensively involved in Export (expdp) and Import (impdp) utilities to move data between different databases and schemas.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Complete end to end validation of the data, comparing the old and new system, extracted all the discrepancies and maintained the data integrity.
• Support for the development, test and the production databases.

Environment: Oracle 10g, UNIX/LINUX RHEL5, Oracle Enterprise Manager, Win CVSERWIN 3.5, Toad 7.5, Crystal reports 9.0, ASP.NET 4.0, XML, HP-AIX

Confidential

PL/SQL Developer

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Resolved application problems to maintain high level of customer satisfaction.
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Managed tables, indexes, constraints, views sequences, synonyms and stored program units.
• Developed database triggers required for the Integrity constraints.
• Created Logical and Physical Models using ERWIN.
• Performed performance tuning and query optimization.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Written PL/SQL cursors for transaction processing.
• Written Queries for the management in the form of stored procedures and packages.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Created partitions on the tables to improve the performance.

Environment: Oracle 9i, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle

Confidential

PL/SQL Developer

Responsibilities:

• Implement PL/SQL Tables of Records to improve performance and provide a temporary storage area.
• Migrated data from Text file to Oracle database.
• Developed SQL queries to fetch complex data from different tables in remote databases using database links.
• Used Oracle Pre Defined Packages DBMS SQL, UTL FILE.
• Handled the application errors using RAISE APPLICATION ERROR built in procedure.
• Created Materialized Views.
• Utilized tools like TOAD during development of the application.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Fine tuning SQL queries to improve the execution time.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Participated in application planning, design activities by interacting and collecting requirements from the end users.

Environment: Oracle 9i, VB 6, UNIX, SQL* Loader, SQL