SUMMARY

• Oracle Certified Programmer offering 10 years of experience in OLTP and Decision Support Systems Analysis, Design, Development, Enhancement, Production Support, Testing and Implementation.
• Strong experience in PL/SQL programming in creating Stored Procedures, Functions, Packages, Triggers, Collections, Autonomous transactions, Records, Dynamic SQL and Analytical Functions.
• Expertise in performance analysis, monitoring and SQL query tuning to reduce response time using Explain Plan, SQL Trace, Statistics and Hints.
• Expertise in writing Complex SQL queries.
• Extensively worked in performing tasks such as Strategic Planning, Logical and Physical Data Modeling.
• Experience in SQL*loader, UTL FILE and Unix Shell scripting.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys.
• Excellent Analytical and Debugging skills with SQL and PL/SQL.
• Provided user training and interacted with Clients to understand business flow.
• Expertise in using tools such as Oracle Developer, PL/SQL Developer, and SQL*Plus.
• Well versed with all stages of Software Development Life Cycle.
• Appreciated with recognition award from client.
• Possess customer interaction, excellent interpersonal, analytical, troubleshooting and team building skills.

TECHNICAL SKILLS

Technology / Programming Languages: Oracle - SQL, PL/SQL Microsoft-SSIS, Ab initio

Technology / Language Details: SQL, PL/SQL

Databases: Oracle 10g/11g

Operating Systems: Windows 2000, Windows XP client, Linux 5.9

Tools: / Packages: Developer 2000 (Forms and Reports), TOAD, SQL-Developer

Domain / Functional Area: General Insurance (Household), Capital Markets

PROFESSIONAL EXPERIENCE

Confidential

Senior PL/SQL Developer

Responsibilities:

• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Design and architect current system changes and new components using Oracle PL/SQL.
• Analyze functional requirements to provide design solutions to business.
• Creating Stored Procedures, Functions, Packages and other database objects as per the requirements.
• Tuning of long running SQL queries.
• Reviewing the code, test cases, LLD prepared by self and the team for quality deliverables.
• Helping offshore team to understand the requirements and provide support in coding.
• Providing UAT support for issues.

Environment: Oracle 11g, Linux 5.9, Windows XP OS

Confidential

Senior PL/SQL Developer

Responsibilities:

• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Design and architect current system changes and new components using Oracle PL/SQL, UNIX and Ab Initio.
• Analyze functional requirements to provide design solutions to business.
• Creating Stored Procedures, Functions, Packages and other database objects as per the requirements.
• Tuning of long running SQL queries.
• Reviewing the code, test cases prepared by self and the team for quality deliverables.
• Break Analysis.
• Involved in writing functional and design documents.
• Helping offshore team to understand the requirements and provide support in coding.
• Providing UAT support for issues.

Environment: Oracle 11g, Ab Initio, Linux 5.9, Windows XP OS

Confidential

Team Member

Responsibilities:

• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Creating stored procedures, functions, packages and other database objects as per the requirements.
• Performance tuning and optimization of SQL queries.
• Creating SQL*Loader scripts to load data from flat files into database
• Preparing Test Cases, Unit testing.
• Involved in writing functional and design documents.
• Participation in project scheduling, weekly review meetings, status reporting etc.

Environment: Oracle 10g, Windows XP OS

Confidential

SME - Team Leader (Oracle)

Responsibilities:

• Providing technical support to the users.
• Debugging the errors in CCS application and fixing them.
• Enhancing the application as per client needs.
• Estimation, designing and coding for Tier 2 work.
• Leading a team of 2 software engineers, assigning work, updating project status report.
• Creating front end forms and reports.
• Creating stored procedures, functions and packages.
• Preparing Test Cases, Unit testing.

Environment: SQL, PL/SQL, Oracle Forms and Reports, Windows XP

Confidential

Team member

Responsibilities:

• Providing technical support to the users.
• Debugging the errors in CCS application and fixing them.
• Enhancing the application as per client needs.
• Estimation, designing and coding for Tier 2 work.
• Creating front end forms and reports.
• Creating stored procedures, functions and packages.
• Preparing Test Cases, Unit testing.

Environment: SQL, PL/SQL, Oracle Forms and Reports, Windows XP

Confidential

Team Member (Oracle)

Responsibilities:

• Providing technical support to the users.
• Debugging the errors in OFAS application and fixing them.
• Enhancing the application as per the requirements.
• Creating front end forms and reports.
• Creating stored procedures, functions and packages.
• Preparing Test Cases, Unit testing.

Environment: SQL, PL/SQL, Oracle Forms and Reports, Windows 2000

Confidential

Team Member (Oracle)

Responsibilities:

• Creating front end forms.
• Creating packages.
• Generating reports by writing queries for Client.

Environment: SQL, PL/SQL, Forms and Reports, Windows 2000

Confidential

Technical Support Representative

Responsibilities:

• Troubleshooting and resolving technical issues related to computers, other peripherals and software’s of the customer.
• Providing second level support to the junior agents on the floor.