SUMMARY:

• 7 years of experience in developing applications using Oracle 10g/11g/12c.
• Experience in HealthCare and Banking domains.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
• Expertise includes application development using Oracle 10g/11g, PL/SQL, T - SQL, Stored Procedures, Packages, Database Triggers, UNIX, SQL Server and working with partitions.
• Experience in multiple Relational Database Management systems (RDBMS).
• Expertise in writing various PL/SQL objects like Procedures, Functions, Packages, Cursors, Views and Triggers in accordance with the business needs.
• Extensive experience in utilizing advanced PL/SQL concepts like Collections, Bulk collect and Dynamic SQL to boost performance.
• Experience using Cursors and Ref-cursors for processing the data.
• Experience in Query Optimization, Performance tuning of SQL queries and PL/SQL procedures using various types of Hints, Partitioning and Indexes.
• Experience in using Oracle-defined exceptions, Non-predefined oracle exceptions and created User-defined exceptions for Exception handling .
• Used supplied packages to extend the functionality of PL/SQL programs such as UTL FILE to read and write from database.
• Expertise in Regular expressions.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records and Exception handlers.
• Experience with logical backup utilities like EXPDP/IMPDP.
• Experience on advanced feature like Global temporary table (GTT), PL/SQL tablee.
• Abilty to analyze the query and it’s execution plan to check whether query is executed in best possible way .
• Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required
• Worked on partitioned tables, local and global indexes, materialized views and database links.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs.
• Created new several AUTOSYS jobs and updated existing AUTOSYS jobs according to the requirement.
• Proficient in oracle tools and utilities such as SQL Loader, SQL developer, SQL PLUS and TOAD.
• Hands on experience using Query Builder.
• Knowledge on Oracle architecture and database design.
• Knowledge in Star schema, Snowflake schemas, Fact and Dimension tables.
• Knowledge on AWS IAM and S3.
• Knowledge on Data Modeling(ERWIN tool).
• Knowledge on PostgreSQL.
• Effective written, oral and interpersonal skills to present technical ideas to teammates, stakeholders and non-technical individuals.
• Ability to work individually as well as in a team with excellent problem solving and trouble- shooting capabilities .
• Demonstrated ability to identify root causes of problems, considering both long-term and short-term impact of proposed solutions.

TECHNICAL SKILLS:

Operating Systems: Linux, Solaris, Windows XP/10 .

Languages: SQL, PL/SQL, C, HTML

Databases: Oracle 9i/10g/11g/12c, Microsoft SQL Server

IDE: TOAD, SQL Developer, SQL Plus, PUTTY

Version Control: CVS,SVN

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Developer

Roles & Responsibilities:

• Responsible for designing, developing, and maintaining complex PL/SQL applications built off of Oracle 11g and 12c environment.
• Participated in designing and development of Database using agile development practices
• Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Worked on AutoSys Jobs which will kick off the scripts at the scheduled time automatically.
• Created different merge statement to make insert and update the table .
• Created materialized views.
• Involved in writing the database triggers to furnish the audit details.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Created new AUTOSYS jobs and updated existing AUTOSYS jobs according to the requirement.
• Used Analytical functions DENSE RANK, RANK and ROW NUMBER in our project whenever required.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in Unit Testing, written unit test cases.
• Worked with ALM(Application lifecycle management) Tool to raise tickets.
• Experience with Jenkins for build and IBM urban code Deploy to deploy the code into different test environments.
• Coordinated with various teams like Database, UNIX, Release Engineering teams to set up environments and for day to day activities.

Environment: Oracle 11g/12c, PL/SQL, SVN, TOAD, SQL*Loader, Windows 10, UNIX, HP ALM.

Confidential

Oracle Database Developer

Roles & Responsibilities:

• Handling modules related to project development for logistics applications at the GENCO that includes analyzing,developing,debugging and testing code, in the real time application environment.
• Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Used BULK COLLECT in Stored Procedures for the better performance.
• Analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Created materialized views.
• Involved in writing the database triggers to furnish the audit details.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
• Involved in Unit Testing, written unit test cases.
• Worked with BMC Remedy Tool to raise tickets.
• Coordinated with various teams like Database, UNIX, Release Engineering teams to set up environments and for day to day activities.
• Followed Enterprise Naming Standards to create any new objects in Database.

Environment: Oracle 11g/12c, PL/SQL, SVN, TOAD, SQL*Loader, Windows 8, UNIX, AutoSys, ER Studio.

Confidential

Oracle Database Developer

Roles & Responsibilities:

• Involved in Database design, creating tables and defining relationship between tables.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Participated in designing and development of Database using agile development practices
• Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Loaded data from excel sheet to tables using SQL Loader.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files Involved in Data Extraction using UTL FILES in PL/SQL.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Involved in Unit Testing, written unit test cases.
• Worked with ClearQuest Tool to raise tickets.
• Worked with DBAs to tune long running queries and to analyze query execution plan
• Coordinated with various teams like Database, Release Engineering teams to set up environments and for day to day activities and Supported UAT.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
• Resolved Priority Production Support Issues and Defect Fixes.
• Followed Enterprise Naming Standards to create any new objects in Database.

Environment: Oracle 11g, PL/SQL, SVN, TOAD, Windows 8, UNIX, ER Studio, SQL*Loader, MSExcel, WinCVS, WinSCP, WinMerge.

Confidential

Oracle Database Engineer

Roles & Responsibilities:

• Actively participated in gathering requirements along with team member and Business users to satisfy the needs of the organization.
• Actively participated in Database design, creating tables and defining relationship between tables.
• Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Worked on Composite Table Partitioning to create partitions and sub-partitions on a table.
• Extensively used PL/SQL tables to code Procedures and Functions.
• Optimized queries by looking at the cost of the query, providing hints and adding indexes when and where needed.
• Worked on Dynamic SQL and Ref Cursors.
• Used FOR ALL and BULK COLLECT in Stored Procedures for the better performance.
• Involved in Unit Testing of Stored Procedures and Functions
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
• Documenting changes related to application design for reflecting New, modified and obsolete features in the shared repository, accessed centrally.

Environment: TOAD, SQL Developer, Windows XP, WinSCP, Rational Rose.

Confidential

Associate Consultant (Oracle PL/ SQL Developer)

Roles & Responsibilities:

• Involved in gathering the requirements.
• Designed and Developed back-end routines using Oracle PL/SQL, Stored procedures/Packages, Functions, Triggers and cursors.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Co-ordination with various problem resolution groups like Database, QA teams.
• Created materialized views, Inline Views and normal views as per business requirements.
• Improved performance for several processes reducing the execution time. (PL/SQL queries for Oracle 11g Database with Toad 10).
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Wrote database triggers for audit and data validation.
• Developed Stored Procedures, Functions, SQL statements and Packages using TOAD.
• Worked on PL/SQL Error/Exception handling.
• Used Synonyms to give alternative names to the objects.
• Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.
• Created Synonyms for read only objects to maintain the security and restrict access to specific users.

Environment: Oracle 10g, SQL, PL/SQL, Windows XP, CVS, TOAD, SQL Developer, SQL Plus.