SUMMARY

• Over 6 years of experience as Oracle Developer in development and production environments.
• Extensive working experience in Oracle Database 11g/10g/9i . SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Experience in Oracle cursor management and exception handling.
• Experience with various DDL functions like tables, Indexes, Materialized Views, and Partitioning tables.
• Worked in debugging and Tuning the PL/SQL code with the help of Explain plan for the Oracle database.
• Exposure in using tools like TOAD, PLSQL Developer and SQL Developer for writing PL/SQL programs.
• Experience in front end development using Oracle Forms/Reports.
• Managing the end-to-end implementation of the project including designing, development, testing, implementation and support of software applications.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in using several built in database packages, as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS SQL are few to be named.
• Working Experience of Loading Data into Oracle Tables using SQL Loader.
• Experience in query optimization, Performance Tuning PL/SQL using SQL Trace, TKPROF, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Good knowledge to the existing APEX applications in the production.
• Used various Indexing and partition techniques to improve the query performance.
• Expertise in all phases of the software development life cycle including analysis, physical and logical design code development.
• Worked on 24 7 environments to provide support.
• Good team spirit and organized working habits with a willingness to learn new concepts.
• Involved in offshore team coordination. Working with them to provide necessary requirement documentation, validating the development work and bug tracking.

TECHNICAL SKILLS

Databases : MySQL, Oracle 9i/10g/11g, Oracle reports 10g, SQL Server 2005,

Microsoft Access.

Programming languages : C, C , java and UNIX

Web Technologies : CSS/CSS3, HTML/HTML5, PHP.

Operating systems : Win Xp, Vista, Win 7 and Mac Os.

Development Tools : TOAD, PLSQL Developer, SQL plus, Dream weaver,

VM ware, Oracle developer.

PROFESSIONAL EXPERIENCE

Confidential

Role: Oracle developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Experience in creating scripts to create new tables, views and queries for new enhancement in the application-using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Creating new Forms, Reports as per business requirement.
• Modified existing triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g, Reports 10g/9i/6i, Forms 10g/9i/6i, PL/SQL, SQL, Sun Solaris, Unix.

Confidential

Role: Oracle developer

Responsibilities:

• Performed query tuning and performance monitoring.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers
• Used different types of Cursors implicit, explicit and Ref to capture many rows within a PL/SQL block.
• Used TYPE and ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Actively involved in coding SQL statements in PL/SQL.
• Developed various Complex Queries, Views for Generating Reports.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Performed off site on call 24x7 production support for Oracle 10g database administration activities.
• Extensively involved in writing PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Created public synonyms on the database links for easy reuse.
• Used built-in functions in oracle forms.
• Created database links to retrieve data from multiple servers.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.

Environment: Oracle10g/11g, SQL, PL/SQL, Toad for Oracle, SQL Plus.

Confidential

Role: Oracle developer

Responsibilities:

• Involved in the maintenance and enhancement of the application
• Maintained good rapport with Business Analyst Business Users to identify information needs as per business requirements
• Document the business process flows
• Schedule meetings and present technical issues to business users and developers.
• Performed discussions with data modeler to update the data model for new requirements
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables
• Used Pl/Sql tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility
• Create maintained box jobs using Shell Scripts.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Communicate issues and progress to project manager.
• Solving day-to-day problems, giving support to the users.
• Worked with Dynamic SQL, Global Temporary Tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Import/Export utility is used for transforming data from one place to another from testing to Production.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views.
• Involved in Production Support and troubleshooting data quality and integrity issues
• Custom tables and new custom objects were designed as per business requirements.

Environment: Oracle 10g/11g, Oracle Applications 12/11i, SQL, PL/SQL, Toad for Oracle, SQL Plus.

Confidential

Role: Oracle developer

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database Triggers to validate complex integrity.
• PL/SQL Procedures, Functions, Cursors, Triggers and Packages were created using TOAD.
• Developed and maintained Oracle Forms and Reports for various applications using SQL Plus and PL/SQL.
• Developed PL/SQL procedures to support Forms and perform standalone functions.
• Developed complex SQL Coding and used in creating Reports and Forms.
• UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
• Responsible for SQL Tuning using Explain Plan and SQL trace facilities.
• Performed unit testing and Integration testing for the scenarios mentioned in the test scripts.

Environment: Oracle 10g, Solaris, Reports 6i, Forms 6i, TOAD, SQL Loader, PL/SQL, SQL Plus

Confidential

Role: Oracle developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.
• Created Control Files and used SQL Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Upgraded Oracle 10g to 11g software in different environments for latest features and also tested databases.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Involved in database Performance Tuning and monitoring.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: ORACLE 10g, Reports 6i, PL/SQL, SQL Loader, SQL.