SUMMARY:

• Over 10 years of experience in the field of Information Technology, principally in development and designing in Oracle database using PLSQL and SQL for different domains like Enterprise mobility, Retail and Telecom.
• Extensive experience in Oracle PLSQL Development using stored Procedures, PL/SQL Packages, Triggers and functions, ref cursors, LOBs, Oracle Jobs, Collections, Bulk processing and usage of external tables, GTT, pipelined table function, Sys refcursors.
• Experience in database query tuning performance tuning using various techniques like analytical functions, with clause, Indexes, Oracle Hints, Explain plan, AWR.
• Strong work experience working with project management and quality management tools tracking like JIRA, Clear Quest, HP Quality Centre etc.
• Experience working in agile software development environment by following SCRUM.
• Experience working with DBA and other teams on preparing implementation plans for different releases of applications.
• Extensive experience in database design like schema, table, views, synonyms, materialized view, database links, indexes and table partitions.
• Experience in data integration using oracle Sql*Loader, External table, Export Import utility.
• Experience in working on multiple projects and performance improvement to meet SLA.
• Experience working in data migration.
• Strong Team Player with excellent analytical, communication skills.
• Received outstanding employee of the year award in 2015 for Automating the Schema upgrade.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

RDBMS: Oracle 9i/10g/11g

Languages: Oracle PLSQL, SQL, UNIX shell Scripting

IDEs: SQL Developer, Pl Sql developer and Toad

Version and Source Control: GitHub, Tortoise SVN and IBM Rational Clear case

Ticketing Tools: JIRA, BMC Remedy, IBM Clear quest and HP Open view service desk

Utility: Putty, Microsoft office, Microsoft Visio, SQL Plus, Text Pad, Ultra Edit, Edit plus, Notepad++, Win Merge, Win SCP and PM Smart

PROFESSIONAL EXPERIENCE:

Confidential

Lead PL/SQL Developer

Platform & Skills: SQL, PL/SQL, dbUnit, J2EE

Tools: Used: Sql developer, Pl Sql developer, SQL*PLUS

Responsibilities:

• Handling various technical aspects like project documentation, system design & integration, coding of modules, monitoring critical paths & taking appropriate actions.
• Coordinating with client to understand the requirement.
• Ensure co - ordination between offshore team and multi-cultural onsite team.
• Analysis & Estimation for Enhancements.
• Preparation of High level and low-level designs, reviewing the functional requirement documents.
• Creating Stored Procedures, Functions, Packages, Triggers and other database scripts.
• Involved in creation of database objects like Tables, Views, Synonyms, Indexes, Materialized view.
• Handled analysis, Performance tuning application, identifying bottleneck sqls affecting performance and tuning.
• Conducting functional tests and analysis of reported defects; Unit Testing, Peer Testing and Preparing project documentation, User manuals, etc.
• Handling testing, debugging and troubleshooting of the application.
• Designing and executing test plans, test cases, gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Responsible for schema upgrade in every major or minor releases.
• Performing various phases of software testing.
• Coordinating in smooth implementation of the project; extending post-implementation and application maintenance support to the client.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Providing support to customer support team in debugging the issues identified at customer end.
• Techno functional trainings & guidance to team members.

Confidential

Sr PL/SQL Developer

Platform & Skills: Oracle 10g, SQL-PL/SQL, VB6, ASP, Oracle Forms, Python, Unix and DCL

Tools: Used: Sql developer, Toad, SQL*PLUS

Responsibilities:

• Preparing functional and technical documents of various applications.
• Involved in providing estimation for different Change requests.
• Analysis, design, coding and testing for the major enhancements with impact analysis.
• Peer code review.
• Identifying bugs in existing system and log problems for the same.
• Root cause analysis (RCA) for the logged problems.
• Preparation of test cases and relevant test data for different change requests.
• Performed integration testing and system testing for different modules.
• Distributing daily tickets among the team members and incident solving.
• Tracking the status of incidents being worked upon and meeting the SLA.
• Providing training to new team members and guiding them on functional as well as technical aspects.

Confidential

PL/SQL Developer

Platform & Skills: SQL, PL/SQL, dbUnit, J2EE

Tools: Used: Sql developer, Pl Sql developer, SQL*PLUS

Responsibilities:

• Worked as a pl/sql developer. Involved in database designing and developing procedures and functions.
• Wrote database triggers and stored procedures/functions, package.
• Involved in creation of database objects like Tables, Views, Synonyms, Indexes, Materialized view.
• Carried out unit testing and System Integrated testing.

Confidential

PL/SQL Developer

Platform & Skills: Oracle 9i&10g, Unix

Tools: Used: Toad, SQL*PLUS

Responsibilities:

• Worked as a pl/sql developer. Involved in database designing and developing procedures and functions.
• Wrote database triggers and stored procedures/functions, package.
• Involved in creation of database objects like Tables, Views, Synonyms, Indexes, Materialized view.
• Carried out unit testing and System Integrated testing.