SUMMARY

• A dynamic professional with eight years and 10 month of experience in Software Development as a Database Developer.
• Expertise in Database Design and Development using Oracle 12c/11g/10g, PL/SQL back end applications SQL Developer, PLSQL Developer, SQL Navigator and Toad.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Indexes, Constraints, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Records and Types for DML operations for better performance.
• Experience in Performance Tuning by analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
• Experienced in Tuning Queries for better performance with large volume of data.
• Experience in handling very large data files using Export-Import utilities.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Intermediate working knowledge in Core java and UNIX Shell Scripts.
• Intermediate working knowledge in implementing ETL (Extract, Transform and Load) by using Oracle Warehouse Builder.
• Expertise in Product and Tariff Configuration of the Rating and Charging Engine Confidential SingleView.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

TECHNICAL SKILLS

Operating Systems: Windows 7, HP-UX, UNIX and LINUX.

Languages: PL/SQL, Core Java, HTML5, java script, Shell Scripting.

Databases: Oracle 11g/10g/9i.

Tools: Oracle Warehouse Builder, Toad, SQL Navigator, SQL Developer, PL/SQL Developer, Magic Draw, Eclipse, Visual SourceSafe, Subversion, Perforce.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

PL/ SQL Oracle Developer

Responsibilities:

• Events are received in XML formats which are stored in LOB, parsing of XML using PL/SQL.
• Extensively used PL/SQL programming for functions, procedures, packages to implement the functionalities.
• Customizing the application to meet requirements of each different Airlines.
• Working extensively on tuning of SQL queries using EXPLAIN PLAN.
• Worked in optimization and restructuring of existing PL/SQL code for speeding up performance.
• Involved in documentation of Low Level Design and other project documents.
• Extensive testing of the application for error free results.

Confidential, Atlanta, GA

PL/ SQL Oracle Developer

Responsibilities:

• Events are received in XML formats which are stored in LOB, parsing of XML using PL/SQL.
• Extensively used PL/SQL programming for functions, procedures, packages to implement the functionalities.
• Created complex Oracle views
• Working extensively on tuning of SQL queries using EXPLAIN PLAN.
• Worked in optimization and restructuring of existing PL/SQL code for gearing up performance.
• Involved in documentation of Low Level Design and other project documents.

Environment: Oracle 11g, SQL Developer, UNIX, WinSCP, Rational Application Developer, IBM Websphere.

Confidential, Chicago, IL

PL/ SQL Oracle Developer

Responsibilities:

• Knowledge gathering of data models and identifying database tables and fields required for implementation of BTD/ BTB/ JCP.
• Extensively used PL/SQL programming for functions, procedures, packages to implement the functionalities.
• Interacted with team and with clients during implementation and analyzed new business requirements and enhancements.
• Created complex Oracle views, stored procedures, functions, packages, tables & triggers, data modeling & analyzing data.
• Involved in writing Procedures, Functions, Triggers, Cursors, Dynamic SQL and Views.
• Experience in creating different DB objects like views, sequences, synonyms etc.
• Worked with PL/SQL result cache, Collections, Bulk Collection techniques for speed optimization.
• Worked with temporary database tables for intermediate data processing and manipulation for faster performance.
• Involved in writing Test Cases and Test Codes using Test Driven Language and FitNesse.

Environment: Oracle 11g, SQL Developer, PL/SQL Developer, SQL*LOADER, SQL*PLUS, UNIX, Perforce, NX Client, FitNesse.

Confidential, Chicago, IL

PL/ SQL Oracle Developer

Responsibilities:

• Knowledge gathering of the pre-existing code base of Re-rating Application.
• Configuration of rating engine and event formatter and dispatcher module for processing event details records to be re-rated.
• Writing Stored Procedures for retrieving faulty events that are processed incorrectly.
• Developed unit test cases for the Re-rating processor application using Junit.
• Multiple Product and Tariff Configuration in the Rating and Charging Engine Confidential SingleView required for Unit Testing.
• Prepared mock applications using core Java for test execution.
• Documentation of the Service Design for Re-rating Application based on the existing code base.
• Performance tuning of SQL Queries for the Re-rating Application.
• Created Shell Scripts to launch the Re-rating process.

Environment: Oracle 11g, SQL Developer, Eclipse, Junit, UNIX, Perforce, NX Client, FitNesse.

Confidential, Chicago, IL

PL/ SQL Developer

Responsibilities:

• Worked on Service Design of the use cases for the Product Mobile Money System.
• Worked on the existing data models and the class diagrams.
• Created sequence diagrams for the multitier architecture of MMS.
• Developed Java packages for implementing the use cases using Software Patterns like Singleton, Factory Pattern.
• Worked on PL/SQL codes for adhoc requirements.
• Product and Tariff configuration of the Rating and Charging Engine Confidential SingleView for MMS.
• Worked with Solution Architect for creating new use cases.

Environment: Oracle 11g/10g, SQL Developer, Magic Draw, Eclipse, Perforce.

Confidential

Database Support

Responsibilities:

• Involved in running the housekeeping utility for different database tables.
• Maintaining the tables that has been cleaned and tracking the duration of data has been removed.
• Maintaining a schedule for all the database tables that has to be cleaned.
• Keeping track of the database space that has been freed up on housekeeping the tables.
• Verifying the data loaded in staging area, with customer, before removing them completely.
• Interacting with client regularly for providing updates and getting inputs on the duration of the data to be removed from individual tables.

Environment: Oracle Database 10g, UNIX, SQL Developer, PL/SQL Developer.

Confidential

PL/SQL Developer

Responsibilities:

• Designing and developing an automated housekeeping solution for large database tables.
• Designing and developing an automated index conversion solution for partitioned tables.
• Identify data from the large database tables that are old and can be removed from the tables.
• Developed packages, functions, and stored procedures using PL/SQL.
• Developed PL/SQL codes using collections, bulking techniques to increase performance.
• Created various PL/SQL scripts for verification of the required functionalities.
• Analyzed the business requirements and wrote Test Plans.
• Developed and maintained the design documentation to support the team and business.
• Involved in developing maps using OWB for adhoc project requirements.

Environment: Oracle 10g, Shell Script, SQL, TOAD, PL/SQL, Oracle Warehouse Builder, Subversion.

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed data received from various systems and ensuring data integrity across the systems.
• De- duplication and pattern matching of data from different system available in different formats.
• Designed and developed an automated solution for data analysis across various systems.
• Created stored procedures for various attributes of the network as required by customer.
• Developed PL/SQL codes using indexes, bulking techniques and partition to increase performance.
• Maintained packages to run the stored procedures using DBMS JOB.
• Created PL/SQL procedures for generating reports using UTL FILE utility.
• Created various ad hoc reports as required by customer.
• Worked on Database Links to connect to various customer end databases.
• Developed and maintained the design documentation to support the team and business.
• Modified, maintained and developed the SQL codes to develop new enhancements.

Environment: Oracle 9i, PL/SQL, SQL*PLUS, SQL Developer, SQL Navigator, SQL* Loader, Toad, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Formulated SQL queries and stored procedures on assigned modules.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Developed PL/SQL codes using collections, bulking techniques and partition to increase performance and efficiency of already existing reports and various programs.
• Worked on Data Loading using SQL* Loader.
• Developed and maintained the design documentation to support the team and business.
• Modified, maintained and developed the SQL codes to develop new enhancements.
• Developed the PL/SQL codes on the basis of the RFC’s (Requests for Change).

Environment: Oracle 9i, PL/SQL, SQL*PLUS, SQL Developer, SQL Navigator, SQL* Loader, Toad, Visual SourceSafe.