SUMMARY

• 7 years of Oracle technical Experience (SQl, PL/SQl, Forms) having good knowledge in Software Development Life Cycle (SDLC).
• Extensive hands - on expertise in Oracle 10g, 9i, Oracle Forms 6i.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Re-usable Components, Standards, Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT.
• Sound Business knowledge in Insurance domain.
• Proficient knowledge in developing packages, procedures, views, triggers and applications/modules.
• Having Experience in Performance Tuning, SQL Tuning, Table Space Partitioning, creation of indexes for faster database access and better query performance.
• Strong skills in creating Unified Modeling Language (UML) diagrams using Microsoft Visio.
• Possess strong coding and Design experience.
• Sound knowledge in creating Unit Test Plan (UTP) and Integration Test Plan.
• Ability to provide Innovative approaches to tackle Technical issues and provide optimized solutions.
• Ability to handle complex situations independently as well in Team.
• Having experience in leading team and possess good communication and interpersonal skills.
• Ability to quickly grasp new technology, new concepts technical and business related and utilize as needed.
• Received multiple awards for significant contributions with exemplary Leadership, excellent support for ensuring time deliveries, training and knowledge sharing.

TECHNICAL SKILLS

Database: Oracle 10g/9i, MS Access, SQL Server

Languages: SQL, PL/SQL, C/C++,Visual Basic

Data-modeling: Microsoft Visio

Tools: & Utilities: Oracle Forms Developer, SQL Navigator, SQL *Plus HP Quality Centre, PVCS Version Manager

Internet Programming: HTML, XML

Operating Systems: Windows XP/2003/NT, Unix

PROFESSIONAL EXPERIENCE

Confidential, CT

PL/SQL Developer

Responsibilities:

• Technical Lead in understanding the Business Requirements and converting it into technical design document.
• Perform Detail design, Coding, Unit Testing, Integration Testing, and Documentation and assign work products to the Team.
• Transform the Business Requirement into design document using Microsoft Visio.
• Actively involved in designing and implementing new interface screens containing Menus, LOV’s using Oracle Forms 6i.
• Created and ModifiedPLSQLPackages, Procedures, Functions and Triggers.
• Delivered coding in sync with the coding standards.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL SQL scripts for transfer of data between databases.
• Performed command executions with SQL *Plus and SQL Navigator.
• Worked on performance tuning and used EXPLAIN PLAN for tuning the queries.
• Deliver Quality Work on Schedule.
• Managing and leading the Support team.
• Participated in code reviews and took ownership for the deliverables of the Team.
• Estimation of effort for the work requests obtained for maintenance and service enhancements.
• Worked on production issues.
• Performance testing and SQL tuning.
• Involved in peer reviews and capturing the review defects.
• Provide Root Cause Analysis.
• Co-ordination with offshore team and Onsite.
• Have independently worked on critical requests which have reduced manual effort in handling around 50 production support tickets per month with Nil SIT/QA/Production defects.
• Support in Project management activities.
• Participate in internal and external audits.
• Provide knowledge transition sessions for new members in the team.

Environment: Oracle PL/ SQL 10g,9i, Oracle Forms, SQL *Plus, SQL Navigator

Confidential, AZ

PL/SQL Developer

Responsibilities:

• Perform PL/SQL development of Procedures, Functions, Cursors, etc.
• Code development of new tables, views and triggers.
• Worked on creating shell scripts.
• Involved in Code Review and Unit Testing.
• Worked on Project Closure activities.
• Attending client meetings and defect triage meetings at during Requirements Analysis phase.
• Requirements clarification with offshore team

Environment: Oracle 9i, PL/SQL, UNIX, Shell scripting

Confidential

PL/SQL Developer, Programmer

Responsibilities:

• Involved in Requirement gathering and analysis.
• Develop plsql coding for Trading, Settlement modules.
• Creating Unit and Integration Test Plans
• Execute test cases.
• Validation of test results.
• Create scripts to generate output files.
• Load the files using script
• Compare output files between the two systems and generate report.

Environment: Oracle PL/ SQL 9i, SQL *Plus, SQL Navigator, Microsoft Visio

Confidential

Developer

Responsibilities:

• Creation of interface screens based
• Establishing connection to SQL Server
• Perform Macro Coding
• Perform Testing
• Execute test cases.

Environment: Macros,Visual basic,SQL Server,Microsoft Excel

Confidential

Java Developer

Responsibilities:

• Creation login screen interface.
• Establish database connection to store the data.
• Perform coding
• Perform Testing
• Execution of test cases.

Environment: Java, JDK 1.4.1,Derby

Confidential

Responsibilities:

• Analyzed and participated in the activities to control and manage busy routed traffic lines.
• Exercised analytical skills in coming up with ideas on how to improvise the present system of navigation and both independently as well as in a team.
• As part of the team embarked on field trips, visiting places where navigation of the router lines was carefully monitored, giving me a better understanding of telecommunications management and its accompanying systems.