SUMMARY:

• Dynamic, Result - oriented professional with around 8 years’ experience in Oracle Database with proven success record in working as Oracle PL/SQL developer.
• Expertise in working with Oracle Versions such as Oracle 11g, Oracle 10g and Oracle 9i.
• Expertise in working complete System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Extensive knowledge of Relational Database Management System (RDBMS) Concepts.
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms, Stored Procedures, Functions, Exceptions, Triggers and Packages.
• Exposure on HTML and XML scripts. Experience in creating scripts to process XML data.
• Extensive use of Crontab and Cronjobs in UNIX environment for scheduling routine tasks and other UNIX commands as per need. Knowledge of UNIX shells scripting
• Efficient in Creating and Using Cursors and Ref Cursors in processing of data.
• Experience in creating different kinds of Partitions on large tables and creating indexes in order to improve performance.
• Experience in Query optimization/Performance tuning using Explain Plan command, SQL Trace, TKPROF
• Used Collections and Bulk Techniques to improve performance.
• Effectively worked on Oracle provided packages DBMS OUTPUT, DBMS JOBS, DBMS SCHEDULER, DBMS SQL and UTL FILE.
• Handled exception in PL/SQL using Pragma Exception init, Raise Application Error and error trapping functions and knowledge in managing exception conditions by using the exception handling features of PL/SQL in order to make the programs robust.
• Expertise in using PL/SQL Wrappers to protect the PL/SQL Procedures and Packages.
• Performed Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center and SQL*Loader for Flat files.
• Worked on Oracle utilities SQL*Loader, export/import and data pump, dblink to load data from another database and text file to oracle database
• Created Batch Job Interface using Unix Shell Scripts for daily file transfers using FTP, SFTP and Connect Direct.
• Experienced to translate reporting and analytical needs into technical solutions.
• Experience working with Test Data Creation, Analysis and Production Support.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle 9i

Languages: SQL, PL/SQL

Operating Systems: Windows XP, Windows Vista, UNIX, LINUX

Office Tool: MS Office

Database Utilities: SQL*Loader, data pump IMPDP/EXPDP, IMP, EXP, External tables, TKPROF

Environment: UNIX (AIX 6.1, Sun Solaris 5.8, 5.9) Windows 98/2000/2003/ XP

Tools: TOAD 8.5/8.6/9, SQL*Plus, SQL Developer, PL/SQL Developer, Putty, SQL* Loader, CVS & SVN and Clear Case for Version Control, Informatica power center 8.x/7.X.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Senior Oracle Developer

Responsibilities:

• Project required creating an OLTP application and all effort was Development only.
• Requirement Gathering through BRD (Business Requirement Document) Discussion with end users and clients for Analysis.
• Created scripts to process XML data coming from front end and to return data back to Front End.
• Developed Code Units, tested, debugged and implemented business rules using SQL and PLSQ (functions, procedures, packages, triggers).
• Used the advanced PL/SQL like Variable arrays, Records, Nested Tables, Bulk collect and Dynamic SQL for high performance of stored procedures.
• Handled exception using Pragma Exception init, Raise Application Error and error trapping functions
• Designed and implemented logic to capture errors in Error Log table, and DML actions into Audit Log tables, procedures as Pragma Autonomous Transaction and Row Level Triggers to automate process.
• Used Oracle provided packages DBMS OUTPUT, DBMS METADATA and UTL FILE in different requirements.
• Managed code version using Tortoise SVN

Environment: Oracle 11g, SQL Developer, SQL Loader, SVN, Windows 2010

Confidential, Saint Louis, MO

Senior Oracle Developer

Responsibilities:

• Participated in all phases of development System Analysis, Design, Coding, Development and Implementation and provided support to existing client databases.
• OVALS NSP is an OLAP application and project required part Development and part Production Support.
• Production Support involved resolving daily tickets, Outages, writing complex queries for Ad-hoc Data Requests as per client requests.
• Most requirements included creating batch interfaces with other applications and writing scripts to manipulate data received.
• Created High Level Design Documents, estimated development effort timelines for agile projects.
• Developed Code Units, testing, debugging and implemented business rules using SQL, PLSQ (functions, procedures, packages, triggers), SQL*Loader, Unix Korn shell scripts
• Involved in creation of tables, partitioned tables, correlated sub queries, nested queries, views, and sequences, synonyms for the business application development and as per the business rules from client.
• Extensively used the advanced features of PL/SQL V arrays, Records, Nested Tables, Bulk collect and Dynamic SQL for high performance of stored procedures.
• Used Oracle provided packages DBMS OUTPUT, DBMS SQL, DBMS SCHEDULER and UTL FILE in different requirements.
• Optimized daily database jobs running by generating statistics, creating indexes, SQL, PL-SQL code tuning using hints, Explain Plan, , SQL Trace, TKPROF
• Handled exception in PL/SQL using Pragma Exception init, Raise Application Error and captured errors into Error Log Table using Procedure as Pragma Autonomous Transaction.
• Used SQL*Loader to load data into Tables.
• Created Batch Job Interfaces for Data Cleaning, processing and loading using shell scripts and SQL Loader.
• Created Batch Job Interfaces using Unix Shell Scripts for daily file transfers using FTP, SFTP, and Connect Direct.
• Managed code changes using CVS and SVN using Eclipse 4.3.

Environment: Oracle 11g, Toad 10.6, SQL Loader, UNIX (AIX 6.1), Putty 0.62, Eclipse CVS and SVN 3.6, Windows 2010

Confidential, Raleigh, NC

PL/SQL Oracle Developer

Responsibilities:

• Defining requirements by interacting with business group, application development group.
• Developed and debugged SQL, PL/SQL scripts including Packages, Procedures and Functions & Triggers in ORACLE 11g environment to perform various tasks.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Used advanced PL/SQL features like V arrays, Records, Nested Tables, Bulk collect and Dynamic SQL
• Reviewed existing systems to determine compatibility with projected or identified client needs, selecting appropriate systems, ensuring forward compatibility of existing systems.
• Created Ad-hoc queries to generate data for business analysis.
• Performed unit testing of the applications developed, providing support for the System Integrated Testing.
• Took part in providing after production support to the application which includes training users, handling issues in production.
• Analyzed and designed ETL, batch and online loading processes. Used Informatica to load data into data marts from source table.
• Also participated in managing versions of software programs while developing solutions for rolling back or saving the changes to software programs

Environment: Oracle 11g, TOAD 10.6, Relational clear case 7.1, Informatica 8.6, UNIX (Sun Solaris 5.8, 5.9), Windows 2010.

Confidential, Berkeley, CA

Oracle PL/SQL Developer

Responsibilities:

• Requirement Gathering through BRD (Business Requirement Document) Discussion with end users and clients for Analysis.
• Preparing High Level Design Document, Project Cost Estimation and Project Delivery Schedule for getting Business Approval.
• Created database objects like Tables, Views, Indexes, Sequences, Procedures, Functions, and Triggers.
• Also involved in the Application Tuning of database by identifying the suitable Indexes.
• Also created Packages consisting of group of procedures and functions to protect sensitive data.
• Used PL/SQL Tables to avoid mutating problem in database trigger.
• Used Oracle provided packages such as UTL FILE, DBMS JOB and DBMS SCHEDULER.
• Maintained the data integrity and security using integrity constraints and database triggers. Also used instead of triggers and Pragma Autonomous transaction trigger.
• Handled exception in PL/SQL using Pragma Exception init, Raise Application Error and error trapping functions
• Implemented table partitioning and Sub-Partitioning to improve performance and data management.
• Used Informatica Power Center 8.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Developed Unix Shell Scripts, Cron Jobs and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
• Used Quest TOAD to tune PL/SQL and SQL query performance and also for UNIT TESTING.

Environment: Oracle 11g, Export/ Import, SQL, TOAD 10.6, PL/SQL, UNIX (AIX 6.1), Putty 0.61, Shell Script, Windows 2010, Informatica power center 8.1, MS Visual Studio.

Confidential

Oracle Developer

Responsibilities:

• Involved in the Developing BSPN one the core application of Confidential, to analyze the sales of all insurance policies for the clients, track the entire agent’s personal and down-line commission of each cycle and compare territory business reports for client.
• Provide support to production, development, QA and staging databases.
• Prepared system document explaining the system interactions.
• Designed and implemented software applications to meet client’s requirements.
• Reviewed and modified the programs to ensure technical accuracy & reliability of programs.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Created Stored Procedures, Functions and Triggers to maintain various business rules in the Active Data Warehousing Project. Modified Procedures and Functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling data.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors thoroughly on Performance issues.
• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Created Indexes for faster retrieval and improved query performance and analyzed them on regular basis.
• Used %type and %rowtype for anchoring the variables to the database data types.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Used Bulk Collect feature to process the data from Cursor/Ref Cursor.
• Used Performance Tuning tools like Explain plan, SQL Trace to check optimizer path and improve the database query performance.

Environment: Oracle 10g, Export, Import, SQL,PL/SQL, TOAD 9.7, Windows 2007, MS Visual Studio, Red Hat Enterprise Linux 4, CVS 1.11.23

Confidential

Oracle Developer

Responsibilities:

• Worked mostly with the production support team.
• As part of production support team, participated in Daily Ticket Resolution. Provided support in case of outages and quick query writing for data requests from clients.
• Created Procedures, Triggers, and Cursors in order to meet project requirements.
• Used Package which houses all the functions and stored procedures to maintain and execute the data and extract calculated values and store them.
• Enforced constraints on the tables to ensure data validations.
• Used Explain Plan for the performance tuning of PL/SQL blocks.
• Implemented Materialized view as part of improving the performance of the application.
• Extensively used Bind Variables to improve query performance.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Prepared documentation for Functional and Technical design specifications.
• Extensively used character-manipulation function.
• Coordinated with the offshore support team in resolving critical issues.
• Used PL/SQL table to avoid mutating problem in database trigger.
• Extensive use to data dictionary tables to manage schema objects.
• Worked on tuning the SQL queries and stored procedures.
• Prepared status reports and attended status meetings to understand the resource utilization and assignments.

Environment: Oracle 10g, SQL, TOAD 9.5, PL/SQL, Shell Script, Export, Import, Windows 2007, MS Visio.