Summary

• Around 5 Years of Experienceas an Oracle PL/SQL Developer with Proficiency in
• Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 10g/9i/6i, Report Builder 10g/9i/6i.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 Forms, Reports Oracle Developer Suite 10g and other front-end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility TKProf.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types.
• Experience in UNIX Shell Scripting.
• Worked with query tools like Toad, SQL Plus, PL/SQL Developer, Sql Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Expertise in handling errors using Exceptions.
• Experience in creating Materialized Views and DB links.
• Good knowledge on ETL and data integration developing ETL mappings and scripts using Informatica Power Center 9.x.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

Technical Skills

PROJECT:

Confidential

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• 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.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 6i and Oracle Forms builder 6i respectively.
• Using Oracle developer Database tools to write triggers and procedures, Function.
• Archived many applications in the existing system and retrieval of necessary data from them.
• performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF,
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE Sql DEVELOPER for creating PL/SQL trigger, sequence, stored procedure .

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

Confidential

Responsibilities:

• Maintained and monitored jobs.
• Developed and maintained stored procedures to load monthly data into tables.
• Analyzed and modified shell scripts and stored procedures as per new client requirements and Issues.
• Involved in handling Exceptions through PL/SQL Blocks.
• Standard Report Scheduling, Custom Report Scheduling
• Setup and Maintenance of Package links, Determining Eligibility of Reports
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas. Master Case Maintenance
• Created design and impact analysis documents.
• Responsible for developing Forms and Stored Procedures.
• Involved in Production Support.

Environment: Oracle 10g, SQL, Suite, UNIX, D2K Oracle 6i 10g, Forms Reports , Windows XP/2003, UNIX Shell scripting,

Confidential

Oracle PL/SQL Developer

Responsibilities :

• Analyzed, created new and modified existing forms, reports, scheduled reports, Oracle, PL/SQL, Stored Procedures, Functions, Packages, and Triggers etc.
• Designed, developed and enhanced custom Forms and Reports according to the functional specification.
• Did code reviews of other developers and provided suggestions to improve performance
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Converted Forms Reports from 6i to 10g.
• Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Shell Scripts.
• Involved in handling Exceptions through PL/SQL Blocks.
• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.
• Developed SQL Loader scripts to load data from flat file to Oracle 10g database tables.
• Tuned batch jobs and other daily/monthly reports/downloads.
• Used Toad for creating and modifying procedures, functions and triggers.
• Developed complex Oracle Forms providing extensive GUI features multi-selects drag and drop, graphical charts, automated system alerts and notifications etc .
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.

• Modifying forms, reports and stored procedures packages, triggers, functions etc to meet the business requirements.

Environment: Oracle 9i, Windows XP/2003, SQL Developer, Toad, Informatica Power center 9.0

Confidential

Oracle Developer

Responsibilities:

• As a part of 3-member team, was involved in design, development and implementation of the module.
• Provided Production Support and 24x7 support.
• Developed Stored Procedure to support front-end application to display potential customers for the campaign.
• Tuned stored procedures and triggers identified for better performance.
• Creating Tables, indexes constraints and improved database performance.
• Involved tuning and applying the SQL statements and PL/SQL processes.
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
• Involved in complete documentation using MS Office.

Environment: Oracle 8i, MS Access, MS Excel, PL/SQL, HTML, C, Windows 98.