PROFESSIONAL EXPERIENCE

Confidential

PL/SQL Developer

Responsibilities:

• Created lots of Triggers for validation.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS and GIT.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in - line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Generation of ER Models with ER Studio
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.

Environment: Oracle 12c/11g, MS Access 2003, MS Excel, TOAD, Microsoft Office,tableau, Business Object,qlikview,Advanced JavaScript

Confidential

PL/SQL Developer

Responsibilities:

• Requirements analysis and translation to technical specifications.
• Created lots of procedure, package, and functions.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• I used Informatica Tool for ETL Process.
• Tuned SQL queries and performed code debugging using TOAD.
• Developed a variety of Management reports for users, using Crystal Reports 2008.
• Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way; formatted the reports as per the user requirements.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Data modeling (relational, dimensional and hierarchical).
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.

Confidential

PL/SQL Developer

Responsibilities:

• Team lead - Allocated tasks, Performed System integration testing, generated Daily Status Report, Monthly status report and Test summary report.
• Involved in testing Televisit Transactions to validate my test cases and verify bugs
• Perform testing - self and independent (Functional, Integration, System) - as per defined processes and guidelines to ensure accurate program output; identify and resolve defects, if any.
• Conducted extensive data analysis/verification by writing and executing complex SQL queries in ORACLE
• Customizing and optimizing existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Worked closely with UI specialists to improve testability of requirements specifications.
• Unit testing the developed code and providing support during integration testing
• User Acceptance testing support
• Working with business user and sorting out their issues faced in the application, monitoring the interface jobs, working on bug fixes in the business layer and the database layer, resolving claims and provider issues.
• Working with Business to find the difficulties faced in the application and strategizing solutions for the same.
• Writing the database triggers and using Dynamic SQL in oracle Forms and Oracle Reports.
• Conduct Impact Analysis, create Design (Unit Test Cases, System test plans, Integration Test Plans)

Confidential

PL/SQL Developer

Responsibilities:

• Team lead - Allocated tasks, Performed System integration testing, generated Daily Status Report, Monthly status report and Test summary report.
• Involved in ETL Process Validation for data completeness, data correctness and data transformations according to the requirements.
• Worked with Sr. Architects/Lead Developers to set up the design of all ETL mapping to load it to EDW as target systems.
• Responsible for setting up ETL functions in PL/SQL using stored procedures, packages for aggregation and summations.
• Performed Positive and Negative Testing Manually.

Confidential

PL/SQL Developer

Responsibilities:

• Team lead - Allocated tasks, Performed System integration testing, generated Daily Status Report, Monthly status report and Test summary report.
• Unit testing the developed code and providing support during integration testing
• User Acceptance testing support
• Working with business user and sorting out their issues faced in the application, monitoring the interface jobs, working on bug fixes in the business layer and the database layer, resolving claims and provider issues.
• Business Rules and Correspondence support.
• Working with Business to find the difficulties faced in the application and strategizing solutions for the same.
• Creating Oracle tables, views, packages & procedures.
• Developing new forms and new reports using Oracle forms and Reports.
• Customizing and optimizing existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Writing the database triggers and using Dynamic SQL in oracle Forms and Oracle Reports.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in creation of Low Level Design including sequence diagrams and class diagrams to understand the existing architecture.
• Understanding of the Functional specifications, based on that prepared design documents.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL
• Using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing
• Handling code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary
• Tuning of Queries, Packages using Oracle utilities Explain Plan, DBMS Prof.
• Developing procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Developed the different components of application such as JSPs, Servlets and used VSS and GIT for version control.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in requirements, design, and development and testing phases of project.
• As a Functional tester, was responsible for analyzing the Requirements, designing test scenarios, test cases & test data, performing System Integration Testing by analyzing the benefits covered, logging defects, defect tracking & retesting.
• Involved in Unit Testing, System Testing, System Integration Testing.
• Used Test Director to keep track of the Test Cases.
• Used Clearcase for each release of project.
• Involved in Promotion of code to UAT, PRODUTION.
• Analysis of client requirement in the initial development phase and provide the best solution for any requirement.
• Developed PL/SQL Stored Procedures, Functions and Packages, Triggers for searching all types of book in advance search model.
• Extensively involved in tuning of Oracle databases, using Oracle utilities Explain Plan
• Used Views, Materialized Views, Cursors, REF Cursors, Partitioning, Exception handling, Bulking Techniques
• Extensively involved in loading the data from different files using SQL LOADER utility, Creation of different control files and used fillers in those files for selective loading.
• Restructured packages, procedures to improve performance.
• Involved in improving the performance of loading and manipulations using Bulk Binds, Creation of different types of indexes.
• Involved in developing procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.

Confidential

PL/SQL Developer

Responsibilities:

• As a module lead involved in testing various modules of the system within the scope of the project. I have been involved in analyzing the gaps between the current state, risks/concerns and industry best practices especially with respect to offshore component.
• Prepared and reviewed Test cases, created test data & was responsible for System Integration Testing using the detailed Design & Technical Specification documents.
• Responsible for Regression Testing, resource planning, status reporting and has always given the quality deliverable in time.
• Worked in developing database table design, ERD and creating the DDL scripts for the new oracle database.
• Extensively involved in creating Tables, Views, Indexes, Stored Procedures, User Defined Functions and Triggers, Cursors, SQL/PL-SQL, Code optimization and performance tuning. Responsible for client side validation and server side validation for the modules.
• Worked with DBA team to assign grants and roles on database objects.
• Attended meetings and review to discuss current issues and processes to tackle critical issues.
• Experience with FTP to put and get the files.
• Used Clear case for each release of project.
• Responsible for Tuning of application with the help of Other Team Members & Oracle Support.
• Utilized tools like TOAD during development of the application.
• Developed Stored Procedures, Functions, SQL statements and Packages for the processing of sum of defect points on a track using TOAD.
• Used joins, indexes effectively in where clauses for Query optimization.
• Developed stored procedures to implement loader integration.