PROFESSIONAL SUMMARY:

• 7 yearsof programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise on System Support via Testing, after production support, UAT and setting business processes.
• Excellent experience in directly working with end customers, managing internal and external customer relationship and communicating verbally and in writing on a daily basis.
• Adept in identifying Functional Points and converting Business Needs into Business Requirements Design (BRD) & Software Requirement Specifications (SRS), and user interface specifications.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS and TOAD.
• CreatedTables, Views, Constraints, Indexes.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Excellent technical and analytical skills with clear understanding of implementing the requirements.
• Extensively used Dynamic SQL for implementing various business requirements in different insurance modules.
• Worked extensively onRef Cursor, External TablesandCollections.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8i/9i/10g/11g

Developer Tools: SQL Plus, SQL Developer, PL/SQL Developer, TOAD and Eclipse

Reporting Tools: Oracle Reports

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts, C, C++

Version Control System: Visual Source Safe, SVN

Operating Systems: Windows XP/2007/Vista/2000/98/NT, UNIX

Document Management: SharePoint

Office Tools: MS word, MS Excel, MS Access, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

Product Analyst, Oracle PL/SQL Developer

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Added/modified table data using Toad tool for new configuration of business rules.
• Responsible for preparing SQL queries to do the initial analysis of issues reported on production and update the Developers to fix defects.
• Used Dynamic SQL to implement different search options to access quote/policy/application
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Good understanding of database objects and ability to triage issues.
• Trained business & IT users on various modules like Application entry, issuance, endorsements, rating, cancellation, billing system.
• Responsible for conducting, UAT with end users and defects life cycle.
• Involved in the continuous enhancements and fixing of production problems.
• Conducting regular meetings with customer to get the status of testing of defects and identify new business needs that needs to be implemented.

Confidential

Product Analyst, Oracle PL/SQL Developer

Responsibilities:

• Conducted User on this new implementation of standalone billing administration system supporting Single Billing, Account Billing & Agency Billing.
• Responsible for ensuring smooth execution of various interfaces i.e. flat files received from their Policy Administration system.
• Involved in daily discussion of issues identified in UAT.
• Continuous handholding provided for testing of the application.
• Developed various SQL queries to analyze the UAT test data and updating the developers to fix the defects.
• Analyze the business logic coded in PL/SQL to identify the root cause and discuss with developers to fix the issues and determine the impact of this change.
• Implemented various DDL and DML scripts to setup new master records required for application.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.

Confidential

 Product Analyst, Oracle PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, Indexesand Collectionsto implement business logic.
• Worked on Oracle Reports for designing various output forms that needed to be produced out of the application.
• Worked with ref cursors and collections.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application.
• Extensively used advanced features like Records, Nested Tables and Dynamic SQL.
• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Provided production support and user
• Worked in Production Support Environment as well as QA/TEST environments for project work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Creation of database objects liketables, views, procedures and packagesusing oracle tools likeToad, SQL DeveloperandSQL* plus.
• Used Toad for doing the code reviews for my team members to ensure that coding standards were followed and to identify any performance issues in the SQL query that was developed.