SUMMARY:

• Oracle Certified Java Associate, with about 6 years of experience in Designing, Development, Testing and Production support using Oracle SQL, PL/SQL, and UNIX. Has experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and
• Post Implementation surveys. Has High skills in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database. Has excellent noledge of all teh phases of software development life cycle and SDLC methodologies such as Waterfall, Agile. Expertise in
• Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports. Has hands on in handling errors using Exceptions. Has experience in making structural changes to teh database objects. Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors etc. Quick learner with ability to master new concepts and applications.Excellent analytical, problem solving, communication and inter - personal skills to manage and interact with individuals at all levels.

PROFESSIONAL EXPERIENCE:

Oracle PL/SQL Developer

Confidential - D.C

Responsibilities:

• Involved in Requirements gathering from teh client.
• Responsible for teh preparing teh Specifications, Designs, Test plan and test cases documents for teh Oracle Utilities provided to me.
• Created database objects like Tables, Sequences and Constraints as per teh business requirement.
• Worked on various stored functions, procedures and packages based on requirement.
• Wrote PL/SQL scripts to call teh developed packages.
• Worked on utility performance analysis.
• Used DBMS DATAPUMP packages to develop Backup and Restore Utility.
• Created Various Form Level, Block Level and Field Level Triggers.
• Created records, tables, collections (nested tables and arrays) for improving Query performance
• Tuned Database by using Explain plan, Tkprof, SQL Trace, Hints, query tuning and optimization.
• Extensive experience in Exception Handling.
• Created PL/SQL scripts to extract teh data from teh RBMS into text files using UTL FILE package
• Improved teh performance of teh slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively worked with teh Business Analysts and teh testing team to understand teh requirements properly and fix teh defects dat were logged through testing.
• Hands on experience with REF Cursors and Dynamic SQL.
• Worked on complex Update and Extract Utilities.
• Performed debugging of teh PL/SQL codes using teh DBMS OUTPUT.
• Provided support for teh development, test and teh production databases.
• Involved in Unit Testing Stored Procedures and Functions.
• Involved in developing various data models using MS VISIO.

Oracle PL/SQL Developer

Confidential -New York, NY

Responsibilities:

• Assisted Business Analysts and Users in requirement analysis.
• Created Designs for teh Back End PL/SQL based upon requirement documents.
• Created database objects like Tables, Sequences and Constraints as per teh business requirement.
• Created DDL scripts to create, alter tables, views, synonyms and sequences
• Created database views and materialized views.
• Created database triggers based on requirement analysis.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries
• Developed stored functions, packages based on requirement.
• Developed various stored procedures which were basic input for teh crystal reports.
• Worked in review of ETL architecture, design, analysis and technical specification.
• Created test scripts documentation for procedure testing.
• Worked to improve teh database performance using various performance tuning tools like Oracle optimizer.
• Developed procedures using Dynamic SQL.
• Supported Production issues.
• Involved in PL/SQL code review and modification for teh development of new requirements.

Environment: Oracle 10g, 9i Windows, PL/SQL, SQL plus, oracle forms 6i/10g, oracle reports 9i/10g, TOAD 9.0, Oracle Developer Suite 10g

Jr. Pl/SQL Server Developer

Confidential - New York, NY

Responsibilities:

• Involved in various stages of Software Development Life Cycle like analysis, design etc.
• Created various database table keeping normalization in attention.
• Coded several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Experienced Dynamic SQL, PL/SQL Collections and Exception handling.
• Coordinated with teh front end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data
• Involved into updating procedures, functions, triggers, and packages based on teh change request.
• Performed Technical Validation on production Release day and send a Success/ failure report accordingly.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.

Environment: Oracle 11g, PL/SQL, PL/SQL Developer, Unix Sun Solaris 2.6, WINDOWS NT Workstation.

Jr. Sofyware Developer

Confidential

Responsibilities:

• Gathering business requirements.
• Participated in designing teh entire project based upon teh requirement documentation.
• Creating database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions to suite teh improved business requirements
• Created records and nested tables in teh procedures for handling of data
• Assisted in page designing using JSP and CSS
• Implemented JavaScript for teh expression validation.
• Integrated all screens and made changes as per teh requirement.
• Involved in Interconnectivity of teh Oracle database through JDBC.
• Developed GUI for various screens using JSP.
• Performed Unit Testing of on various components using JUnit.

Environment: JSP, HTML, CSS, Servlets, JDBC, Oracle SQL, HTML, JavaScriptEclipse.