SUMMARY:

• Competent Professional over 8 years of experience as Oracle PL/SQL developer in Business Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
• In - depth understanding of Software Development Life Cycle (SDLC) and industry best practices.
• Strong verbal and written communication skills. Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Involved in designing various Applications and Reports by interacting directly with End Users and Business Analysts.
• Worked as a Module lead in multiple assignments and successfully tracking them to closure.
• Involved in all phases of the SDLC (Software Development life Cycle) from Analysis, Design, Development, Testing, Implementation and maintenance with timely delivery against aggressive timelines.
• Experience in building and maintenance of Banking Application Database and Reporting.
• Gathers and documents reporting requirements from business owners and/or business analysts, prepares functional and technical design documents.
• Conduct JAD sessions with end users to gather functional and technical requirements, perform GAP analysis, and documenting business processes and flows.
• Works closely with end-users to gather report requirements and ensure proper testing/validation.
• Supports user acceptance testing on production data loading and new features
• Expert in data analysis using various tools and writing SQL queries against various databases including Oracle
• Scope new projects, interpret business needs, translate technical issues, identify and model data requirements, identifying business rules requirements, and test requirements.
• Expertise in Client-Server Application Development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Created various schema objects like Tables, Views, Constraints, Indexes.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using cursors, dynamic SQL, exceptions, analytical and hierarchical queries etc.
• Experience in PL/SQL performance Tuning.
• Analyze the performance of queries using Foglight.
• Programming and unit testing experience in PL/SQL and Oracle 11g.
• Involved in the analysis and solving of several Adhoc Production Request / issues.
• Loaded data into Oracle Table using SQL Loader.
• Experience working on TFS, CVS & SVN (Source code management tool).
• Experience working on UNIX and UNIX shell scripting.
• Created Shell Scripts for Invoking SQL Scripts.
• Developed Jasper Reports using iReport tool.
• Developed HTML web pages.
• Expertise in Java Scripting for input validation.
• Exceptional Communications and team building skills with proficiency at grasping news functions and technical concepts and ability to communicate at all levels.

TECHNICAL SKILLS:

Modeling Methods: Waterfall, Iterative & Agile

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

Languages/Utilities: SQL, PL/SQL/UNIX Shell Script, Java Script, XML, HTML, C

Operating System: Windows XP/7/8, UNIX

Office Tools: MS Word/Excel/PowerPoint/Outlook

Other Tools: HP Quality Centre/ TOAD, iReport, SVN, CVS, TFS, Foglight

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. PL/SQL Developer

Environment: Oracle 11g, SQL * Plus, SQL Developer, UNIX, Windows XP

Roles & Responsibilities:

• Creation of database objects like tables, views, materialized views, procedures and packages
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Involved in the continuous enhancements and fixing of production problems.
• Created records, tables, collections for improving Query performance by reducing context switching.
• Performed SQL and PL/SQL tuning and Application tuning using Explain Plan.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created materialized views required for different external applications.
• Involved in Unit Testing of the developed code.
• Utilized SQL*Loader to load flat files into database tables.
• Resolving Production severity Issues in time and meeting the SLA.

Confidential, Washington D.C.

Sr. PL/SQL Developer

Environment: Oracle 11g, SQL * Plus, TOAD, SQL Developer, Foglight, SQL*Loader, UNIX, Windows XP

Roles & Responsibilities:

• Coordinated with Clients in Requirements gathering, Analysis and Estimation.
• Involved in Design, creating Logical Data Models
• Provide data analysis and process improvements, to identify various business requirements.
• Create Requirement Specification based on interviews with end users.
• Facilitate interaction between different Business and IT Managers to process data for update into the system.
• Worked in Agile methodology for software development process.
• Work closely with the DBA to understand the performance of the system and suggest indexes and partitions as required.
• Tested the performance of the system using performance-analyzing tool - Foglight.
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL
• Analysis of Issues in Production Runs and Implementing Production Fixes.
• Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques.
• Involved in Creating Indexes and Materialized Views for better performance.
• Actively involve in system production support to resolve the issue on daily basis.
• Attend business requirement calls and TDR reviews.
• Created sequences and indexes for faster data retrieval and enhancing the database performance.
• Analyzed the assigned projects and distributed tasks to members as per their area of expertise.
• Offshore - onshore coordination.
• Participated in the daily status call with the offshore team to work in sync with the team.
• Performing Unit Testing for the developed codes.
• Preparing unit test cases and reviewing the test cases prepared by team mates.
• Responsible for work allocation and ensures that all deliverables /tickets are completed as per baseline.

Confidential

Sr. PL/SQL Developer

Environment: Oracle 11g, SQL * Plus, TOAD, SQL Developer, SQL*Loader, UNIX, Windows XP

Roles & Responsibilities:

• Creating the design document from Master Requirement Document, customizing existing functionality available in Finacle to cater the Banks requirement, creating new Menus (Finacle terms) to include the functionality that is not available in Finacle base product.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Data Validations and testing with Business Users, fixing data issues.
• Wrote Hierarchical queries to generate sales hierarchy.
• Worked on SQL*Loader to load data from flat files obtained from various facilities.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Co-ordinate with DBA for changes in database and data partitioning.
• Involved in data report customization using iReport tool.
• Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
• Developed PL/SQL triggers and views.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Frontend HTML screens using in-house tool.
• Actively involve in system production support to resolve the issue on daily basis.
• Analysis of Issues in Production Runs and Implementing Production Fixes.
• Reviewed the code written by other team members.
• Performed Unit Testing for the developed codes.
• Preparation of daily and weekly status reports
• Created Java Scripts to validate the input Data.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i, SQL, PL/SQL, Toad, Windows XP, Sun Solaris

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Worked in Agile methodology for software development process.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Preparing unit test cases and reviewing the test cases prepared by teammates.
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Day-to-day development tasks involving creating users, tables, indexes, views and other objects , assigning roles and privileges setting up QA environment.
• Analysis of CR’s.
• Involved in Design, creating Logical Data Models
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Performed SQL and PL/SQL tuning, analyzing queries using EXPLAIN PLAN, SQL*TRACE, TKPROF
• Fine-tuned procedures and optimized SQL queries for maximum efficiency using Oracle Hints.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Developed Database Triggers for audit and validation purpose.
• Migrated data from external sources using SQL*Loader.
• Application setup, Test the application with the data provided from client.
• Done User Acceptance testing along with client team.
• Writing validation packages using PL/SQL and tuning them for performance.
• Developed reusable assets that can be readily used.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Worked along with the production support team.
• Analysis of Issues in Production Runs and Implementing Production Fixes
• Developed Frontend HTML screens using in-house tool.
• Created JavaScript to validate the input Data.

Confidential

Systems Engineer

Environment: Oracle 10g, PL*SQL, SQL Developer, iReport, UNIX, TOAD

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements.
• Involved in Unit Testing Stored Procedures and Functions
• Worked on various backend Procedures and Functions using PL/SQL
• Involved in creating various utility scripts to generate log files in the UNIX using Shell Scripting
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Created Cursors, Stored procedures, Functions and Packages to provide backend processing using PL/SQL.
• Created sequences and indexes for faster data retrieval and enhancing the database performance.
• Data migrations from external files using SQL * Loader.
• Involved in Unit testing, functional testing for different modules.
• Done System and Integration testing.
• Done User Acceptance testing along with client team.
• Reviewing the code and Scenarios written by junior Team members.
• Managed internal Releases and Deployment of releases to Testing Team.
• Has done Configuration Control and Defect Prevention activities.
• Provided offshore support on issues and new requirements.
• End-to-end testing of the designed flows.
• Analysis of Issues in Production Runs and Implementing Production Fixes.
• Preparation of daily and weekly status reports.
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Resolving the issues raised by QA on priority basis
• Actively involved in system production support to resolve the issue.
• Responsible for Analyzing and Implementing the Change Requests
• Involved in data report customization using iReport tool.