PROFESSIONAL SUMMARY

• Decisive, action oriented and result focused professional offering nearly 16 years of experience in the field of Information Technology.
• Strong skills in SQL, PLSQL, Oracle Developer 2000, SQL Plus, SQL Loader, Oracle Forms, SQL Developer/TOAD and UNIX shell scripting
• Strong in RDBMS Data Modeling Concepts, and excellent working knowledge of database design, creation, writing Complex Stored Procedures, Triggers in Oracle.
• Hands on experience in all levels of Software Development Life Cycle SDLC includes Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation Support.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Expertise in designing and developing strategic Test plans, Test Cases, Test Scenarios, Test Reports for Manual Testing.
• Skilled in writing scripts/cases for manual testing of Insurance business applications
• Worked at different levels of development process that involved gathering information from end user and communicating with the organizational people to resolve key issues.
• Good team player, hardworking and have consistently exceeded client's expectation during engagement performance reviews.

TECHNOLOGIES

Languages Tools: SQL, PL/SQL,SQL Developer, SQL Loader, Toad

RDBMS: Oracle RDBMS 8, 8i, 9i, and 10g,

Clients: Oracle 9i/10g/11g, Oracle Forms 4.5/6i/9i/10g, Designer 6i,

Operating Systems: Windows NT/2000/2003/XP, Linux

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle Developer Analyst

Responsibilities:

• Involved in Enhancement and Maintenance of Policy and Claims Module. Policy Module covers Prospect, Quotation, Policy and Endorsement. Claims Module covers Claims Reporting Processing, Claims Reserves and Claims Payments
• Analyzed Business Requirements documents and created Functional and Technical Requirements documents.
• Interacted extensively with the BAs and SMEs to identify the business needs and prepared programming standards and Functional and Technical design specifications.
• Designed the Front end screens and Developed the code for various complicated Transactions using Oracle Forms
• Developed and Maintained Several Transaction forms and shell scripts
• Developed and executed various Stored Procedures, Database Triggers, Packages, functions, and cursors using PL/SQL Programming, perform code Review, defect Analysis.
• Involved in the Testing, Tested various Transactions in Unit level, Functional level and Integration level
• Tuned various SQL Queries and PL/SQL Stored Procedures using Explain Plan, TOAD
• Provided production support to business units as well as worked on several critical projects.
• Responsible for Initial testing, Unit Testing, Functional Testing, Integration Testing and Migration testing

Environment: Oracle 9i/10g, Forms 6.0/6.0i/10g,PL/SQL,SQL Loader, SQL Plus, SQL Developer, Import/export Unix Shell scripting

Confidential

Lead Oracle Developer

Responsibilities:

• Created PL/SQL stored procedures, functions, packages and triggers to transform and load staging table data into fact dimension tables, by applying critical business needs of Aviation Industry.
• Maintained log of unprocessed records by writing efficient exceptions in PL/SQL programs.
• Responsible for interacting with business analysts to apply data transformation rules in PL/SQL programs.
• Created and maintained Partitioned Tables and Indexes that helps in maintaining large tables efficiently.
• Written functions and procedures for implementation of the business logic as per the client requirement
• Created Materialized Views to leverage speed of extracting data from large fact tables.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Maintained data security by creating database triggers to populate audit trail columns in dimension, lookup and cross-reference tables.
• Performed SQL PL/SQL tuning using Explain Plan and TKPROF
• Used TOAD Schema Browser to navigate through various objects and SQL Editor to test and tune complex SQL Queries
• Designed database schema using Erwin tool.
• Created the database schema objects like tables, views, synonyms, indexes, procedures, and functions.
• Written UNIX shell scripts to transform load data from flat file to staging tables.

Environment: Windows 2000, HP UNIX, Forms 6i/9i,SQL, PL/SQL with Oracle 11i, Oracle 9i, Pro C, Designer 6i, TOAD, SQL Loader, SQL Plus.

Confidential

Lead Oracle Developer

Responsibilities:

• Customized forms and reports using Forms 6i and Reports 6i.
• Converted Oracle Forms 5 to 9i.
• Created common procedures, functions, object groups, record groups and list of values in Forms 9i to be use in all Forms.
• Created PL/SQL store procedures, packages and triggers.
• Created SQL loader scripts to load flat file data into Oracle staging tables.
• Created UNIX shell scripts.
• Involved in web development by developing the forms screens according to the user requirements.
• Involved in the customization of Purchase Order form.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis

Environment: Oracle 10g, PL/SQL, Forms 10g, UNIX, TOAD

Confidential

Lead Oracle Developer

• Involved in the Database design and Technical Design Specifications for enhancement of the application
• Involved in the Data modeling of ER diagrams, Functional flow diagrams, Data Flow diagrams.
• Created table spaces, tables, views, indexes, synonyms, and integrity constraints.
• Designed and Developed the Master and Transaction Forms using Oracle Forms 9i
• Designed and developed 25 Master forms, 30 Transaction Forms using Oracle Forms 10g, and PL/SQL
• Wrote stand alone stored procedures, triggers, functions and packages using PL/SQL
• Developed and executed Template form using Oracle Forms 9i and PL/SQL which is used throughout the application
• Worked on Predefined, User-defined and System defined exceptions to handle different types of errors like NO DATA FOUND, DUP VAL ON INDEX, and PRAGMA EXCEPTION INIT etc.
• Involved in the SQL query tuning of the application using TOAD, EXPLAIN Plan
• Involved in major role of Conversion and Migration of the data from old system in the new System
• Involved in Testing of Unit, Functional Testing and Integration Testing

Environment: HP Unix, Forms 9i, SQL, PL/SQL with Oracle 9i, TOAD, Shell scripting, SQL Loader, SQL Plus,

Confidential

Lead Oracle Developer

• Implemented SDLC Software development Life Cycle as a Senior Developer and worked as a team member in the development of RS, FS, coding and final implementation.
• Performed functi onal, integration testing, and boundary testing of the front end of the application where required for browser and system compatibility.
• Conducted walkthrough with the team in reviewing test plans, test cases and updated the documents accordingly.
• Documented and compared the actual results with the expected results based on the business functional requirements.
• Created tables, views and different schemas of the database-using Oracle 8i, PL/SQL, stored procedures and triggers.
• Documented functional specification, requirement specification and gap analysis.
• Followed the Quality Assurance Life Cycle QALC during the testing by implementing SQA Plans and Test plans which involve thorough testing of the applications by creating Test plans, Test Cases, Bug Reports, Status reports, Test summary reports, Traceability matrix and finally Closure Report.
• Prepared UAT Test plan and coordinated UAT with stakeholders and business users.
• Responsible for determining defect priorities, root cause analysis and tracking defects to resolution.

Environment: HP Unix, Forms 9i, SQL, PL/SQL with Oracle 9i, TOAD, Shell scripting, SQL Loader, SQL Plus,

Confidential

Oracle Developer

• Documented functional specification, requirement specification and gap analysis.
• Implemented SDLC Software development Life Cycle as a Senior Developer and worked as a team member in the development of RS, FS, coding and final implementation.
• Created tables, views and different schemas of the database-using Oracle 8i, PL/SQL, stored procedures and triggers.
• Documented and compared the actual results with the expected results based on the business functional requirements.
• Conducted walkthrough with the team in reviewing test plans, test cases and updated the documents accordingly.

Environment: Windows 95/NT, Forms 6i, SQL, PL/SQL with Oracle 8i

Confidential

Oracle Developer

• Documented functional specification, requirement specification and gap analysis.
• Involved in Object Modeling, Analysis Modeling and Implementation Modeling
• Created tables, views and different schemas of the database-using Oracle 8i, PL/SQL, stored procedures and triggers.
• Developed 3 Master and 5 transaction forms

Environment: Windows 95/NT, Forms 5.0, SQL, PL/SQL with Oracle 8i