SUMMARY:

• 8 Years of IT experience in analysis, design, development, testing, implementation & maintenance of application software in Oracle, SQL, PL/SQL, and Unix
• Expert in creating tables, packages, stored procedures, advanced queries, triggers, views, indexes and functions for databases using SQL *PLUS, and PL/SQL.
• Worked extensively on performance tuning like giving the stats and also the Hints.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 11g, 10g, 9i.
• Strong knowledge on oracle architecture and database design.
• Experience in Database design using Normalization and E/R diagrams using tools like ERWIN, VISIO.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Extensively worked with collections to reduce the overhead and improve the performance using bulk collect and bulk bind. Also handled exceptions in collections using Save Exception and %BULK EXCEPTIONS.
• Experienced with DBA activities like granting and revoking privileges on database objects, creating synonyms and database links.
• Worked with Explicit Cursors, Inline cursors and REF Cursors and performed data manipulations.
• Worked on user defined exceptions, WITH clause, pipelined functions, retrieval of bulk data from collections using table () function.
• Experience in programming using Perl scripting
• Worked with data transformations and loading using Export/Import file packages and SQL* Loader and also created external tables to manage data which is stored at the operating system.
• Created Instead of triggers for updating join views with DML operations.
• Created Global temporary tables to maintain session data and improved the performance of data retrieval and created views, indexes on them.
• Resolved mutating table errors using the new functionality in Oracle 11g through Compound triggers.
• Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
• Expertise in optimizing and tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF & hints, and scheduling the tasks using DBMS JOB/DBMS SCHEDULER.
• Created batch files for Windows environment for running the script files and scheduled them using Windows scheduler.
• Expertise in working with built - in packages like DBMS LOB, DBMS SQL, DBMS SCHEDULER, DBMS JOB, UTL FILE.
• Experience in unit testing and maintenance of the developed code.
• Strong experience of complete software development life cycle (SDLC) and software quality procedures and practices.
• Expert level experience with Oracle 11g, 10g, 9i.
• Expertise in working with development tools like SQL developer and TOAD.
• Excellent analytical skills, logical reasoning, and interpersonal skills.
• Unit testing and debugging the code using error log package.

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle9i, MS ACCESS

Languages: SQL, PL/SQL, C, C++

DB Dev. Tools: SQL Developer, TOAD, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, ERWIN

Scripting: Unix shell scripting

Operating Systems: UNIX, Windows XP, MS DOS

XML Technologies: XML

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr PL/SQL Developer

Responsibilities

• Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
• Created Stored Procedures, Packages, and Functions to massage data, validate data and to implement complex business rules.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Developed database objects such as stored procedures, packages, functions, types.
• Reviewed the business requirement, functional requirement document for various modules so as to have good understanding of the application.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Played an important role in performance tuning most complex SQL queries using
• Hints, Indexes.
• Extensive documentation of the source and target tables and the description of the objects in the Excel document and developed Excel Report using the procedural code.
• Worked on Table structures along with the Triggers, Indexes like Bitmap and Function based Indexes.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL developer, TOAD.

Confidential, Los Angeles, CA

Oracle Developer

Responsibilities:

• Creating the packages, Procedures and scheduling the Jobs.
• Analyzing the Business Requirements Document thoroughly and providing the inputs to the business analysts.
• Extensive experience on Working with the Unix Script, Creating the UNIX script so as to automate the Jobs.
• Extensively worked on production issue tickets and solving them.
• Collaborated with Team on increasing the performance.
• Extensively usage of ref cursors and cursors.
• Good experience in Team Management Software and well versed with TFS.
• Expertise on debugging the code and creating exceptions to handle the bad data.
• Worked with Collections and improved the performance of multi-row queries.
• Modified procedures, functions to use autonomous transactions, for all bulk collect and more exceptions as needed.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Loaded the data into the created tables using TOAD and SQL*plus.

Environment: Oracle 9i/10g/11.2, PL/SQL, SQL*Plus, Toad

Confidential, Littlerock, Arkansas

Oracle Developer

Responsibilities:

• Created the procedures and maintained them.
• Extensively worked on Cursors.
• Worked with SDLC methodologies.
• Worked on Siebel for design, development, marketing, and support of Customer Relationship Management(CRM) applications
• With the help of Siebel worked on marketing and customer service applications
• Worked with collections and increased the performance of multi-row queries.
• Resolved mutating table errors by creating global variables inside a package.
• Created views pointing to different databases to get the data from interface modules.
• Design, develop, unit test, and support ETL mappings and scripts for data marts using Informatica, KSH, Perl, and PL and SQL in UNIX, Linux, and Windows environments.
• Worked with the database links to get the data from different database.
• Created new tables according to the requirement and used them in the procedure which is created.
• Assited the client for changing the datatypes of the columns.
• Analyzed data to increase the performance of stored procedures using Explain plan and Hints.

Environment: Oracle 11g, SQL, PL/SQL, Toad 10.8, SQL TRACE, TKPROF

Confidential, Needham, MA

Oracle Developer

Responsibilities:

• Created dynamic sql queries using Execute Immediate statements.
• Worked on agile methodology.
• Extensively used SQl loader and import/export toolbar to load the data from excel files into oracle.
• Extensively used REF cursors to pass out the required data set to the front end team working on VB.net
• Extensively worked on cursors, sql joins (inner join, outer join, anti join), views, packages, procedures, functions.
• Involved in several discussions with the client team discussing the modification and giving updates of the project.
• Good experience in Team Management Software and well versed with TFS.
• Worked with data dictionary views to query the required information about the status of the procedure, looking for any indexes etc.
• Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Worked on export/import commands to move the structure and the data from development to production.
• Conducted ETL performance tuning, troubleshooting.
• Worked with XML technology.
• Exposed and learned to create web services.
• Maintained a thorough understanding of the business processes, ETL processes.
• Created batch files for automation of sql script files and scheduled those using windows scheduler.
• Unit testing the PL/SQL code.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL Developer 3.0.03

Confidential, Grand Rapids MI

Oracle Developer

Responsibilities:

• Involved in development and enhancement of various modules.
• Involved in all phases of SDLC from requirement, design, development, and testing.
• Involved in discussions with data analysts in gathering the requirement and with client for any better enhancement of the application.
• Exposure to Java language
• Wrote packages, stored procedures for storing the client information and modifying the views to resolve any possible bugs.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tablesand invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Good experience in Team Management Software and well versed with TFS.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Used DBMS JOB to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Performed the uploading and downloading flat files from UNIX server using Confidential .
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project.
• Avoided mutating table errors using the new functionality in Oracle 11g i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Used SQL loader for importing the flat files which consists of several records of customer’s information into the different tables in the database.
• Unit testing the PL/SQL code.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL developer, UNIX.

Confidential, Baltimore, MD

Oracle Developer

Responsibilities:

• Developed and modified stored procedures for retrieval of data according to search criteria like readings from a particular location during a period of time.
• Generated SQL queries to fetch complex data from different tables in the database using joins, and formatted the results.
• Good experience in Team Management Software and well versed with TFS.
• Involved in implementing data integrity validation checks through constants and triggers.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
• Used Nested tables, Varrays extensively with bulk collect for accessing complex data resulted from joining of large number of tables to extract data from database.
• Resolved mutating table errors by creating global variables inside a package, then creating a row level trigger including the global variables and then creating a statement level trigger implementing the required functionality.
• Created complex SQL queries using inline views, sub queries, correlated sub queries.
• Worked with package DBMS JOB for scheduling the tasks.
• Created SQL loader control files to load multiple records into the database.
• Extensively used cursors, ref cursors and exceptions in developing packages, procedures and functions.
• Debugging the code and created error log package to record all the bad records along with error codes and error message.
• The flat files are transferred from locations at local machine or remote machines to specified directory using UNIX commands like mv, cp and Confidential .
• Creating shell scripts to run stored procedures, packages and SQL scripts and automate those using crontab.

Environment: Oracle 10g, SQL, PL/SQL, Sql trace, TK PROF TOAD 9.5, UNIX

Confidential

Oracle developer

Responsibilities:

• Involved in design and development phase of the business requirement.
• Created PL/SQL code to implement business rules through triggers, procedures, functions and packages using SQL editor or Toad.
• The data from flat files are to be loaded into the database using SQL Loader.
• Enabling and disabling of roles at runtime, based on user responsibility.
• Worked extensively on complex SQL scripts which were used for reporting purpose.
• Analyzed high volume data to increase the performance of stored procedures using Explain plan and Hints.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created database triggers to enforce security and worked with shell scripts.
• Monitored log files regularly for data extraction and taking actions based on the problems.

Environment: Oracle 9i, SQL, PL/SQL, SQL Developer, UNIX