PROFESSIONAL SUMMARY:

• Overall 5 years of programming experience as an Oracle PL/SQL developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design Development, testing, implementation and maintenance with timely delivery against aggressive Deadlines.
• Main responsibilities include understanding of client requirements & develop solutions.
• Experience in Client - Server application development using Oracle 11g/10g/9i, SQL, PL/SQL,Oracle Developer Suite (Forms & Reports), TOAD, HTML, & CSS.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Created Tables, Views, Constraints and Index
• Developed materialized views for data replication in distributed environments.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Developed Complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL/SQL.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience on Requirement Analysis, Project Documentation, UAT, Training 7 Support.
• Ability to be an effective team player and work under time constraints.

TECHNICAL SKILLS:

Operating System:: Linux & Windows.

RDBMS: Oracle 9i, 10g & 11g.

Tools: SQL Plus, Oracle Forms and Reports Builder, SQL * Loader, Toad, SQL Developer.

Language: SQL, PL/SQL, HTML, CSS.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Responsibilities:

• Developed System using PL/SQL packages, procedures, triggers, functions, Indexes and Collections to Implement business logic using Oracle Developer and toad.
• Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
• Investigated data quality issues and implemented appropriate solutions.
• Helped to improve the performance, scalability and stability of database systems.
• Identified and implemented programming enhancements.
• Developed technical system documentation.
• Understanding and Collecting requirements from Business user side or Business Analyst and to Convert that requirement to SQL queries or PL/SQL.
• Convert the business need in to Technical complex queries.
• Use different strategies of database development to meet the client functional requirement.
• Work with SQL and PL/SQL programming, developing complex code.
• Creating Pl/SQL packages, procedures, Functions, Triggers, Views and Exception handling For retrieving, manipulation, checking and migration complex data sets in Oracle.
• Creating the indexes on tables and partitioning the table for SQL tuning purpose.
• Writing procedures, functions, views, materialized views as required.
• Writing complex SQL queries for reporting purpose.
• Support the users of application with using multiple SQL and PL/SQL techniques
• Support all day to day activities related to database like data consolidation, data Migration scripting.
• Creating complex views, materialized views on multiple table as per customer Requirement.
• Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk Collect for mass update as performance improvement process.
• Migrated data from flat files to tables using SQL*Loader.
• Work with Data migration using import and export user excepting
• Manage unit testing for UAT

Confidential

Oracle Programmer

Responsibilities:

• Involved in resolving issues present in the product by analyzing the cause of the issue and solving the same.
• Involved in allocation of work and verification of program specifications done by fellow team members.
• Involved in preparing documents for program change specification and program specification for various changes that need to be done in the existing ERP product.
• Handled modifications in stored procedures, functions, packages, tables, views at the backend and also, in PL/SQL coding both at backend and front end.
• Involved in unit testing for all the self-made changes made respectively in our team.
• Created database structures like tables, sequences and procedures as per the requirement for solving the issues and also for new enhancements.
• Made use of TOAD as an editor to handle with backend database.
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique That makes the applications more flexible and versatile.

Confidential, Hoffman Estate, IL

Oracle Programmer

Responsibilities:

• Involved in gathering customer specification and their requirements from the design team
• Analyzing the business requirement and to enable to fit to the product as a technical requirement.
• Involved in writing SQL scripts for SQL reports that has to be developed as a basis in the product.
• Created and managed tables, established relationships between tables, created constraints.
• Created database objects including tables, views, indexes, Stored procedures, Functions etc.
• Handled modification in packages, stored procedures and functions for the new enhancement to be made.
• Involved in Database design for the new development in database for the requirement of the project.
• Created Business Requirements and converted them into System Requirements Specifications, technical and functional requirements.