SUMMARY

• Working as Oracle Developer with over 7 years of IT experience in analysis, design, development, testing, Production support and deployment of custom reports, forms, and workflows.
• Strong work experience with tool like Toad, SQL Navigator, SQL Developer, SQL*PLUS, ERWIN.
• Conceptual knowledge of Oracle SQL, PL/SQL, Oracle server (11g/10g/9i).
• Expert level skills as an Oracle backend developer. Includes PL/SQL and SQL coding; Stored procedures, Packages, Functions, Cursors, Triggers, Constraints, DDL and UNIX scripting for loading data to implement business logic.
• Extensive experience in Application development using Oracle Forms and Reports.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• 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.
• Experience in Data migration Projects which uses SQL Loader, PL/SQL programming, coding Procedures, triggers and functions.
• 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
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Strong working experience in Data Analysis, Modeling, Logical and Physical database design.
• Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Developed UNIX Shell scripts to run various utilities.
• Expert in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Worked on Database links and materialized views.
• Expertise in handling errors using Exceptions.
• Proficient in Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Analyze and Auto trace.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers.

TECHNICAL SKILLS

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

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

GUI / Tools/Utilities: SQL*Loader,TOAD 11.0/8.0/7.5, PL/SQL Developer, DataPump (Import/Export), SQL* PLUS, ERWIN 3.5/4.0, SQL Navigator MS VISIOVI Editor, Oracle Wrap, FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint.

Operating Systems: Unix,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 - Milpitas, CA

PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Scheduling jobs in control M and handling them.
• Making changes to the existing apex applications in the production.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Programed inUnixshell scripts to provide a user interface toOracle formsandreports.
• Oracle Forms developed and deployed in allUNIX environmentthrough Dev, Test, and Prod in an Oracle Applications environment.
• Performed system analysis and Unix scripting within the development and support work environment in the company.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions, Triggers) usingPl/SQL for RETEK-12.
• DevelopedC/C++, Pro*CBatch programs usingMultithreading Programmingfor handling
• Have involved in data modeling and designing of custom tables.
• Support modules for implementation usingPL/SQL Scripts, Unix Shell ScriptsandPro*C.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g/10g,Forms 9i, Reports 9i, C++, pro*C Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite, 11gR2.

Confidential - Charlotte, NC

PL/SQL Developer

Responsibilities:

• Involved in developing SQL *Loader scripts for data loading.
• Created database objects like tables, synonyms, sequences and views.
• 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 with Bulk Collects to improve the performance of multi-row queries.
• Worked on profiling and tracingPL/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 TuningSQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code. .
• Analyzed Oracle objects and createdPartitions for very large tables to reduce disk contention and improve performance.
• Partitioned tables based on data using LIST partitioning, Range Partitioning.
• Created indexes for faster retrieval and improved query performance.
• Worked on PL/SQL Tables, Records and Collections.
• 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 11g, TOAD 9, SQL Tuning, SQL*Loader, UNIX Shell Scripting, MS Excel, Data Pump(Export & Import).

Confidential, Cambridge, MA

PL/SQL Developer

Responsibilities:

• Analyzed and understand the business flow of Blackbaud Inc, according to the business requirement.
• Involved in all phases of the project Life cycle- Requirementgatheringand Analysis, Databasedevelopment, Development, Test, Implementation and Support.
• Wrote and modified storedprocedures, functions, Packages, SQLscripts to facilitate the functionality for various modules.
• Extensively involved in writing SQLqueries (Subqueries and Joinconditions) and PL/SQL programming.
• Extensively used DynamicSQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Used mergewith insert and updatestatements.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FORloops while developing procedures.
• Used composite data types like %ROWTYPE and %TYPE.
• Worked on user-defined and also the system defined exceptions to handle different types of errors like NO DATA FOUND,TOO MANY ROWS, and PRAGMAEXCEPTION INIT.
• Experience of using Oracle supplied package like UTL FILE, DBMS JOBS, DBMS SCHEDULAR, etc.
• Use of rollup, inlineviews, cubeoperators, merge and update statement.
• Wrote complexSQLscripts and was responsible for Performancetuning of SQL Queries.
• Used set operators in PL/SQL like unions, unionall, intersect and minus.
• Used analytical functions like Rank, Dense rank, Row number
• Used JIRA for the requirementtracking, planning and building.
• Utilized SQLdeveloper and PL/Sqldeveloper tools in developing all back end database interfaces.
• Involved in technical documentation, writing implementation plan and test plan documents.
• Provided production support and played a major role in debugging errors during implementation and deployment.
• Provide test data QA team to validate front end application and also involved in unit testing.
• Client interaction for the business process.

Environment: Oracle 10g, PL/SQL, Oracle Forms 6i,PL/Sql Developer, SQL Developer 2.1,SVN, Crufish, Putty, Windows 7, UNIX.

Confidential - Bartlesville, OK

PL/SQL Developer

Responsibilities:

• Wrote and modified Oracle PL/SQL, SQL statements procedures and functions in Toad for Oracle 11.0.
• 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.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Work towards a balanced, risk-driven SDLC target.
• 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 11g.
• 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.
• Migrated data from MS Excel sheets to Flat files.
• 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 11g, Toad for Oracle 11.0, Oracle Enterprise manager, SQL*Loader, Unix Shell Scripting, Humming Bird 10.0.0.14

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC.
• Developed capacity plan for the database, estimated the table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for protecting data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among the various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.

Environment: Oracle 10g, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML, ultra-edit