We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

SUMMARY:

  • 6+ years of hands - on IT experience in analysis, design and development of complex software solutions in client reporting and wealth management sectors.
  • Experience in IT industry in verticals like Banking and Financial Services, Telecom Domain with emphasis on design, development, implementation and management of projects.
  • Proficient in PL/SQL programming.
  • Have strong collaboration and interpersonal skills and worked with Product Owners, Business Owners, Technical Teams and Functional Teams during design, implementation and testing.
  • Strong experience in entire SDLC process - requirement analysis, design, development, testing and maintenance of projects.
  • Intensive experience in translating business requirements to Database Objects.
  • Expertise in constructing T-SQL and Oracle PL/SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints, Analytical Functions to facilitate efficient data manipulations as per the business rule.
  • Expertise in creating Joins and Sub-Queries for complex queries involving multiple tables.
  • Strong Experience in writing advanced query concepts using having clause, group by etc.
  • Hands on experience in tuning SQL queries for enhancing the database performance.
  • Good knowledge on logical and physical Data Modeling using normalizing Techniques.
  • Worked in AGILE and Waterfall methodologies mode of software development (SDLC).
  • Efficient in design test strategies for performance testing and volume testing of PL/SQL solutions.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Table Partitioning.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Extensively used SQL tools like SQL Developer, SQL Server Management Studio.
  • Received ‘Bravo Award’ by the employer as an appreciation for handling the key deliverable to the client.
  • Excellent problem solving skills, ability to handle multiple projects simultaneously, comfortable in interaction with both business and technical team members.
  • Experience in working with multiple teams under strict deadlines.
  • Quick learner, adaptive and possesses good inter personal skills and work ethics.
  • Excellent communication skills, diligent and good team player.

TECHNICAL SKILLS:

Methodologies and Framework: Agile/Scrum and Waterfall SDLC methodologies, Release Management, Database Design (RDBMS)

Operating System: Windows

Databases: Oracle 10g/11g, SQL Server

Languages: SQL, PL/SQL, C, C++, C#, .Net, HTML, CSS

Configuration Tools: Tortoise SVN, GIT, TFS, Ctrl-M

Documentation: Atlassian Confluence, Windows Office, OpenOffice, Share Point

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Currently working as a database developer in data migration team which is responsible for migration of client data from Trust300 to SWP platform.
  • Creation of new users for the migrated firms and clients to SWP.
  • Create test plans for Volume testing of code that is developed in a sprint.
  • Creating PL/SQL procedures, functions, cursors and sequences using Toad and SQL Developer.
  • Continuous review of Business Critical Database to proactively identify space issues, performance tuning issues.
  • Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
  • Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
  • Developed Row level and Statement Level Triggers for auditing tables in PL/SQL.
  • Developed Views and Materialized Views for specific data retrieval for the reports.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developed SQL *Loader scripts to load data in the Staging tables.
  • Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.
  • Review the code entirely to ensure accuracy, completeness and quality of the deliverables.
  • Incorporating code review comments as a part of code review activity.
  • Fixing the bugs at every level of testing.
  • Analyzing the RCA and ensuring that preventive measures are takes so as to avoid the bugs coming up in the future releases.
  • Version control of the application code.
  • Attending and co-ordinate with offshore and onshore meetings to discuss the progress of the task assigned and the issue faced.
  • Providing Level 3 support for client code release in a live production environment.

Environment: Oracle 11g

Tools: Used: SQL Developer, Toad, GIT, HP QC, Confluence

Confidential

Module: RoBT (Rest of BT) SI (Single Interface)

Senior Systems Engineer

Responsibilities:

  • Participate in the Design Workshops with the different stakeholders of the application and come up with the finalized approach.
  • Design Technical design document based on the business requirements.
  • Prepare technical artifacts, review the design thoroughly and estimate the effort and time required for preparing the requirement document, development of code, mapping it to the architecture.
  • Prepare the High-Level Design and Low-Level Design Document.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collections in PL/SQL objects for improving the performance.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Written PL/SQL Cursors for transaction processing.
  • Used Bulk collect feature to process the data from Cursor/Ref Cursor.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Create PL/SQL procedures using Global Temporary Tables and Dynamic SQL that will be used by the UI.
  • Create reusable views and materialized views that will source data from different tables within or across schemas.
  • Acted as the single point of contact for all Level 3 service requests.
  • Co-ordinate with the incident managers from different geographies and with other stakeholders for incident resolution.
  • Co-ordinate with the Business Analysts and with the users and compile the Low Level Design for the change requests.
  • Created new reports for the operations user using PL/SQL, Global Temporary Tables and PL/SQL collections.
  • Worked extensively with the universe team and database team and users to analyze the gaps.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
  • Carry out internal and external code reviews and then incorporating changes as per required.
  • Worked on TFS, SVN for version control, source control.
  • Figured out the Root Cause Analysis for the issues and documented it in order to prevent it from coming in future releases.
  • Provided support for client code release in live production environment.

Environment: Oracle 10g and ASP .NET 2.0

Tools: Used: SQL Developer, SQL*Loader, SQL*Plus, Tortoise SVN, Visual Studio 2010 and Control M

Confidential

Module: SI (Single Interface)

Systems Engineer

Responsibilities:

  • Involved in entire project life cycle of Business, Database Design, Development, Implementation, Testing and enhancements of the application.
  • Created DDL Scripts for database schema and database objects.
  • Write SQL queries and stored procedures for high volume reports as per the business requirements.
  • Highly involved in query optimization and troubleshooting long running queries
  • Used SQL Profiler, Execution Plan and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries so as to enhance the performance.
  • Worked on deadlock issues and minimized the occurrences of these situations.
  • Created and Worked with Global Temporary Tables.
  • Developed various user defined functions and created different views.
  • Created cursors and triggers to maintain the referential integrity.
  • Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Rebuilding indexes and tables at regular intervals.
  • Created and automated various jobs.
  • Fault Management on QC.
  • Worked on TFS, SVN for version control, source control.
  • Provided 24/7 support for production database and also deployed the code in production environment.
  • Provided RCA for production issues and documented the resolution for the same.
  • Coordinated with onshore, offshore teams and created BRD and FRD documents based on the requirements.
  • Performed code reviews and planned test plans for the project deliverables.

Environment: T-SQL, ASP.NET 2.0

Tools: Used: SSMS 2005, Visual Studio 2008, HP Quality Centre, SVN

Hire Now