SUMMARY:

• More than 7 years of experience in Oracle 10g/9i/8i, SQL, PL/SQL as an Oracle PL/SQL Developer.
• Excellent skill in Triggers, Stored Procedures and Standard Packages.
• Extensive experience using SQL, PL/SQL, Oracle Reports.
• Extensive working knowledge in database objects like creating tables, views, indexes, sequences, primary key, foreign key constraints, etc.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, Putty, data pump.
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirements, coding and unit testing, integration and system testing.
• Expert in interacting with Business/Technology groups and analyzing business needs.
• Strong skill set in using developer tools such as Oracle Forms 9i/6i, Reports 9i/6i.
• Excellent Interpersonal Skills which helped me to share a good report with co - workers and the management.
• Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL Collections, Cursors, Records, Ref Cursors, Bulk Processes, Merge, Exception handling, Autonomous transactions, and Standard DBMS Packages of Oracle Database, and analytic functions.
• Excellent client handling skills and proven experience.
• Worked on 24*7 environments to provide necessary support.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Working Knowledge on UNIX Shell Scripting.
• In addition to excellent technical abilities possesses strong verbal and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/2000/NT/XP/Vista/7, UNIX

Languages: SQL, PL/SQL, C/C++, VB, UNIX Shell Scripting

Databases: Oracle 11g/10g/9.x/8.x/7.x, DATACOM, Teradata, MS SQL Server 2000/7.0/6.5, MS Access.

Oracle Tools: SQL Developer, Toad, Oracle forms 9i/6i/4.5, Oracle reports 9i/6i/4.5, Oracle Discoverer 4i/9i/10g, SQL*PLUS, SQL*

PROFESSIONAL EXPERIENCE:

Confidential, IA

Oracle Developer

Environment - Oracle 10g, Oracle 11g, SQL*LOADER, UNIX, Windows XP, SQL Developer, SQL*PLUS, TOAD 10.6, Communicator, Lync, Outlook

Responsibilities:

• Involved in ETL processes which used plsql procedures/packages and Perl scripts to provide correct and timely data to downstream.
• Created and modified several stored procedures and functions.
• Modified numerous packages as per requirements.
• Tuned performance of procedures by tuning sql queries using explain plan, tkprof, dml error logging, hints, etc.
• Troubleshot problems by identifying the root cause.
• Worked with Power Designer to view new mappings and model changes.
• Identified problems in data model or mapping which were otherwise thought to be coding problems.
• Created/altered many database objects such as tables, views, indexes, sequences and database links.
• Used AutoSys to run autosys job boxes which in turn called Perl scripts or stored procedures.
• Worked with Perl scripts and modified them as per requirement.
• Modified many jil files to schedule jobs and to maintain proper dependencies between jobs.
• Fixed numerous bugs in pl/sql procedures and packages.
• Used sql*loader to load data into tables from flat files.
• Was actively involved in bug fixing during production/UAT issues.
• Communicated with different people from different departments/regions to get the job done.

Confidential, OH

Oracle Developer

Environment - Oracle 10g, Oracle 11g, SQL*LOADER, UNIX, Windows XP, PL/SQL, SQL*PLUS, TOAD 10.6, Reflection for HP, Communicator, Outlook

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC).
• Created new PL/SQL package for a new process which used oracle data pump to import and export data.
• Created several procedures and functions for the new package and also for various purposes.
• Used several oracle packages such as dbms output, dbms datapump, utl file, etc.
• Involved in manual import and export of data using oracle data pump.
• Used file transfer protocol (ftp) to transfer files between different servers.
• Automated many shell scripts using crontab.
• Created database links for the purpose of running queries from different databases.
• Created many database objects like tables, views, indexes.
• Used explain plan and tkprof to analyze queries and suggested tuning methods.
• Tuned SQL queries using hints to improve performance.
• Involved in bug fixing and error reporting.
• Used SQL*Loader to load data into database tables.
• Created and modified several table partitions.
• Created and modified shell scripts, SQL scripts and SQL queries.

Confidential, TX

Oracle Developer

Environment - Oracle 11g, Reports 10g, Form 10g, SQL*LOADER, Windows XP, Putty, PL/SQL, SQL*PLUS, TOAD 9.6

Responsibilities:

• Involved with design, development testing and production phases of the SDLC.
• Created PL/SQL, procedures, queries for Daily reports, Monthly reports, etc.
• Developed and customized complex Pl/Sql procedures based on client requirement.
• Loaded data into the database using SQL*LOADER.
• Performed SQL Tuning to improve overall system performance.
• Created tables, views, procedures, triggers, sequences and functions and executed them using TOAD.
• Improved system performance by creating indexes.
• Modified reports as per client requirement.
• Handled production issues related to sales force reports.
• Used custom tables to manipulate data obtained daily before loading them into the tables.
• Created and modified various reports using Oracle’s Reports Builder.
• Wrote and executed shell scripts.
• Coordinated with the Quality Assurance/Testing team members to perform user acceptance testing (UAT).
• Developed Materialized views and Ref Cursors for reporting purpose.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections and Triggers.

Confidential, TX

Oracle Developer

Environment - Oracle 10g, Reports 10g, SQL*LOADER, Windows XP, UNIX, PL/SQL, SQL*PLUS, TOAD 9.6/10.5, Putty, Forms 10g

Responsibilities:

• Created Custom PL/SQL procedures, functions and packages.
• Created and modified different Views as per requirement.
• Developed scripts to create tables, views, procedures, triggers and functions and executed them using SQL Developer and Toad.
• Created custom forms and reports using Oracle Forms and Oracle Reports.
• Created indexes to improve the system performance.
• Worked extensively on SQL queries to generate custom reports on a regular basis.
• Customized various Forms 10g and Reports 10g to make them user friendly based on the business requirements of the client’s receivables and payables.
• Developed Reports to extract the Annual sales information.
• Created UNIX batch Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Created tabular forms and reports using Oracle Apex.
• Improved the performance of the system by tuning queries.
• Created database object using Putty, SQL*plus and executed them using Toad.

Confidential, GA

PL/SQL Developer

Environment - Oracle 10g, Oracle Discoverer 10g, PL/SQL, Forms 9i, Reports 9i, TOAD, SQL*Plus, Windows 2000 Professional

Responsibilities:

• Evaluated the feasibility of the requirements by analyzing the source systems.
• Helped to prepare BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
• Prepared program specifications for PL/SQL Procedures and Functions.
• Customized and developed Oracle Reports using Oracle Reports 9i, Discoverer.
• Involved in database development by creating PL/SQL Functions, Procedures, Triggers, Packages and views.
• Involved in Unit testing and integrated system testing.
• Performed the data migration using SQL* loader scripts for importing legacy systems data into AR interface tables.
• Developed new reports and customized existing according to the requirements.
• Developed and worked extensively on SQL* Loader for data transfers. Involved in user documentation and training to end-users for effective usage of developed packages.

Confidential

Oracle Developer

Environment - Oracle 8i, UNIX, PL/SQL, SQL *Plus, Oracle SQL Developer 2000, Oracle Forms 6i, Oracle Reports 6i

Responsibilities:

• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Developed Control scripts and loaded existing data using SQL * Loader.
• Developed Forms /Reports using Forms 4.5 and Reports 2.5 and solved Numerous Problems in Reports.
• Developed stored procedures using PL/SQL to update payment info into Bills.
• Developed Database Triggers to enforce security.

Confidential

Oracle Developer

Environment - Oracle 8i, SQL, PL/SQL, Forms 6i, Reports 6i, UNIX

Responsibilities:

• Developed front end forms using Forms 6i.
• Used PL/SQL Procedures, Packages and DB Triggers, created reports using reports 6i and developed Billing and Policy exhibit reports using Reports 6i.
• Developed reports using Reports 6i to upload information to the policy Accounting system as well as custom reports for internal use.
• Conducted Unit and Functionality Testing of the above modules.
• Performed the documentation of the modules and reports generated.
• Implemented shell scripts for scheduling batch jobs and diagnostics.