SUMMARY

• Over 6+ years of programming experience as an Oracle PL/SQL Developer with Oracle 9i/10g/11g/12c databases in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong Experience in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE tools, such as Impdp/Expdp, SQL*Loader and SQL*PLUS, SQL Developer and TOAD.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• Developedmaterialized viewsfor data replication in distributed environments.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOB, UTL FILE and Partitioned large Tables usingrange partition technique.
• Heavily worked with SQL HINTS, INDEXES (B*Tree, Bitmap, Unique, function based, Clustered indexes) for performance improvements.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Experience in advanced PL/SQL concepts like Bulk collect and forall.
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• Developed and supported Extraction, Transformation and Load process (ETL) using PL/SQL and to populate the tables in OLTP and OLAP Data warehouse environments.
• Implement and maintain database security such as create and maintain users and roles, assign privileges to roles and grant roles to users.
• Experienced in scheduling the jobs using Autosys, Control-M and Crontab and monitor the batch processing.
• Possess Excellent oral/written communication, presentation and interpersonal skills
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c databases

Operating System: Windows 98/XP,MS Windows 2000/2003/2007/2008, RHEL Linux, suse Linux, IBM AIX, solaris 10/11

Languages: PL/SQL, HTML, XML, UNIX shell script, Java Script

Code Version Control Tools: Wincvs, Tortoise SVN, IBM clearquest

Tools: / Utilities: SQL*Plus, SQL Developer, TOAD, import/Export, Impdp/Expdp, tkprof, SQL*LOADER, SQL navigator, Oracle SQL developer, CVS, Oracle APEX, HTML DB, DTS Package, VI Editor, Autosys 4.5/4.5.1, WinSCP, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Was a part of an Agile Scrum team dealing with daily build.
• Worked directly with application team and product for working on User stories.
• Involved in all the stages of Software Development Lifecycle (SDLC) - design, development, analysis, testing and deployment of Virtual Merchant application.
• Gathered the Requirement from the business users and prepared the program specification and design document for the development of the Application.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database.
• Partitioning of Tables to accommodate large volume of data and faster data retrieval and created local indexes for partitioned tables.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the scripts to create table, views, indexes and sequences.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used SQL Loader in Migration of the data from the previous Virtual Merchant database in SQL Server database to Oracle 11g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used BULK COLLECT to pull the records faster.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.

Environment: Oracle 11.2.0.2,11.2.0.3,11.2.0.4,10g R2 PL/SQL, TOAD, SQL*Loader

Confidential, Houston, TX

Oracle PL/SQL Developer

Responsibilities:

• Writing Stored Procedures, user defined functions, views for implementing complex business logic in PL/SQL
• Performance Tuning of SQL queries using DBMS XPLAN EXPLAIN PLAN, SQL*TRACE.
• Involved in overall trouble shooting and application database support.
• Responsible for writing Triggers and other database objects.
• Analyzing the problems and resolving the same.
• Involved in Design review and code review.
• Providing support, maintenance, enhancement and modification of the system.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers in Oracle 11.2 databases.
• Have extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Written PL/SQL Functions that return complex data types, collections and ref cursors to interface with Java programs.
• Worked with version control tools like wincvs, tortoise SVN.
• Providing production support solving Tickets created using the software Element Tool.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.
• Developed PL/SQL packages, collection of procedures and user defined functions for complex calculations and bundle them into stored package

Environment: Oracle 11g R2/10g R2, PL/SQL, SQL, TOAD

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

• Creating Database Objects and Indexes.
• Writing Stored Procedures, Functions and Triggers keeping the performance aspect in mind.
• Overall trouble shooting and support.
• Creating stored procedures, functions and views to implement various levels of data security and ongoing maintenance of the database.
• Generating Triggers to enforce data integrity and consistency in maintaining business rules.
• Analyzing problems and resolving the same.
• Conducting design review and program review.
• Providing continuous support and resolving queries raised by the end users in all locations.
• Providing maintenance and modification of system.
• Resolving issues with the team and coordinating with my team.
• Preparing checklists for different tasks
• Logging of defects and CR, analyzing and fixing them.
• Involved in data migration.
• Implementing the Module at client side and imparting training to the end users at the Regional offices in Chennai, Mumbai, Delhi, Kolkata and Kanpur.

Environment: Oracle 11g/10g R2, PL/SQL, SQL, TOAD, SQL*Loader

Confidential

Oracle Consultant

Responsibilities:

• Writing Procedures, Functions, Packages and Triggers
• Continuous debugging and overall support Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Use Agile methodology for application development
• Support in requirements gathering from the end users
• Update design documents according to the changes made to the application
• Designed/developed/Modified tables, views, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.
• Actively involved in coding SQL statements in PL/SQL.
• Implementing the system at client side and imparting training to the end users at the Regional office in Chennai
• Causal analysis and fixing of the defects/bugs uncovered during the development.
• Attaining daily client meeting and providing reports to the project manager on the development quality.
• Optimized the Oracle PL/SQL queries by Performance Tuning.

Environment: Oracle 9i/10g/11g, PL/SQL, SQL, TOAD, SQL*Loader