SUMMARY

• Around 7+ years of experience in Application Development using Oracle 10g/11g, PL/SQL and performance tuning.
• Experienced in interacting with Business Users, Business Analyst, IT Leads,Developersand System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQLandSQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Rich experience in writingSQLQueries, Views, Materialized Views, PL/SQLProcedures, functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System, reference Cursor, DynamicSQL, Exceptions
• Created Indexes and partitioned the tables to improve the performance of the query.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) usingSQLTrace, TKPROF,explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time - constrained performance.
• Strong knowledge of Extract, Transform and Load (ETL) processes using UNIX shell scripting, SQL, PL/SQLandSQLLoader
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• Experience working on different applications using UNIX shell-scripting.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Worked Extensively in Oracle Purchase Order (PO), Order management (OM), Quoting (Quote) and Inventory (INV).
• Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies including Implementation, Interfacing, Conversion, Data Migration and Data Conversion.
• Good understanding and functional knowledge in Purchasing Module and basic Knowledge of iProcurement Module, Oracle ISupplier Portal, Sourcing and Oracle Inventory
• Expertise in developing business applications using Oracle SQL,PL/SQL 9i, 10g and 11g databases and Forms 6i, 9i, 10g and Reports 6i, 9i.
• Tools used include PL/SQL,C,Pro*C,OEM,Rman,Nameserver,Web Forms and Reports.
• Pro*C: Oracle precompiler, Cursors, embedding static/dynamic SQLs in 'C' code
• Designed and implemented pre and post processing Pro*C programs for the PRISM ETL process.
• Developed numerous forms, reports and utilities using Oracle forms 4.5, Pro*C, C, Awk, Sed.
• Modified various existing Pro*C reports and Pl/Sql code.
• Build several Unix Shell wrappers for Pro*C programs to schedule them on Cron.
• Wrote different reports and batch programs in Pro*C.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages andSQLScripts using PL/SQL.Created Indexes and partitioned the tables to improve the performance of the queries.
• Loaded the data into database tables usingSQL*loader from text and excel files.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V arrays, Records, Materialized views, Dynamic SQL.
• Developed data model,SQLCoding,SQLQuery tuning process and Schemas.
• 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/sqlblocks and even has experience with exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the halp of UTL MAIL.
• Developed Database objects like Views,, Indexes, Sequences, and Synonyms.
• DevelopedSQLand PL/SQLscripts to transfer tables across the schemas and databases.
• Loaded data from legacy systems (ETL Operations) using PL/SQLandSQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with javadevelopersto repair and enhance current base of PL/SQLpackages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Created and maintained Forms and Reports (Designing the new forms as a GUI to make interactions with the database transactions for the end user to make changes in the database which includes many validations. Modified the existing forms as the requirement changes.
• Modified interfaces for an application using Oracle Forms 6i.
• Responsible for the design/maintain the Conversion applications for Carolina Power and Lights' Oracle Financials. Duties included writing PL/SQL packages, Pro*C,C programs to move data from IBM mainframe to Oracle Financials. Other duties include the troubleshooting and correction of Oracle /UNIX problems.

Environment: Oracle 11g,SQL, PLSQL,SQL*Loader, UNIX Shell script, TOAD, Java.

Confidential, Milwaukee, WI

PL/SQL Developer

Responsibilities:

• DevelopedSQLand PL/SQLscripts for problem solving and generated reports using Report builder
• Established onsite/offshore communication between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Created index on all key fields and analyzing tables is done to reduce query return times. Materialized views are created in many cases for frequent refreshes of data and also to improve performance.
• Involved in SDLC including designing, coding and testing.
• Created database objects like tables, views, procedures, packages using Oracle tools likeSQL* Plus, PL/SQLand TOAD.
• Wrote complexSQLqueries including inline queries and sub queries for faster data retrieval from multiple tables.
• Using associative array from perl programming for indexing and performance issues in unix environment.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables. Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g,SQL, PLSQL,SQL*Loader, UNIX Shell script, TOAD, Java.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Created various Database triggers using PL/SQL.
• Involved in Performance Tuning.
• Has converted old data from Flat files to Oracle database Using SQL * Loader
• Wrote various kinds of SQL queries involving correlated sub-queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
• Scheduled the tasks using Autosys.
• Built Perl programming/libraries to acquire and process multiple varied data formats.
• Developedshell scriptsto execute the program.
• UsedAutosysextensively for scheduling.
• Wrote synchronization code using Perl and Unix Shell Scripts. Used Unix commands and Perl scripts to format the output, also comparing and validating the output data.

Environment: Oracle 10g/11g,SQL, PL/SQL,SQL*Plus, PL/SQLDeveloper, TOAD 8.0, UNIX, Shell programming.

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling of data.
• Used SQL Loader to load data into the database coming from Knipper and FICO.
• Used export/ import and expdp/impdp database utilities for data transfer.
• 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.
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
• Creating and working with GTT (Global Temporary Table).
• Made use of Sub query Factoring (WITH clause) to make complex SQL statements simple and make them more efficient.
• Using set operators in PL/SQL like Union, Union all, Intersect and minus.
• Performed exception handling for the procedures created.
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail.
• Experience in resolving anomalies in the production database.
• Created indexes for faster retrieval and improved query performance.
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance.
• Support for the development, test and the production databases.
• Used SQL plus and TOAD to develop database applications.

Environment: Oracle 9i /10g (SQL, PL/SQL), Oracle Developer Suite 10g, TOAD 9.0, Erwin 4.0, UNIX, VSS, Perl.