Professional Summary:

• Over 7 years of IT experience as an Oracle PL/SQL Developer in Analysis and Implementation of Business Applications using Oracle Relational Database Management System Programming experience in Oracle 11g, 10g, 9i, 8i, SQL, PL/SQL and Performance tuning.
• Extensive work experience in Client-Server application development using Oracle 11g/10g/9i/8i, Forms 9i/6i, Reports 10g/9i/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Discoverer 9.1, Oracle Import and Export Utilities.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Expertise in developing outbound and inbound interfaces.
• Good Exposure to UNIX shell scripting.
• Expertise in dealing with complex data models and object relational database mapping, while producing complex reports
• Extensive usage of Oracle collections and standard API's like DBMS LOB, UTL FILE etc for business logic in user defined API's.
• Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility TKProf.
• Hands on experience in Data migration ETL across different databases via SQL scripts.
• Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
• Experience in requirement gathering, gap-analysis and solution design.
• Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
• Hands on experience as support engineer in a production support environment.
• Thorough understanding and exposure to software lifecycle development in both waterfall and agile methodologies.
• Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
• Great team player and ability to work collaboratively and independently as required.

Technical Skills:

Professional Experience:

Confidential

Role: Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Oracle development Data Base by creating Oracle PL/SQL Functions, Store Procedures, Triggers, Packages, Records and Collections.
• Created .SQL scripts to handle new processes.
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables Nested Tables and Varrays , and performed Error Handling.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Participated in Performance Tuning using Explain Plan.
• Used HINTS to improve performance of the SQL
• Involved in development of process using SQL LOADER, PL/SQL Package.
• Run batch jobs for loading database tables from Flat Files using SQL Loader
• Extensively used TOAD, SQL PLUS, SQL Developer and PLSQL developer for programming purposes.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Created numerous forms as in process for application development.
• Designed CUSTOM forms and reports in order to meet the Business requirements.
• Fixed Bugs during development/testing and Production phases.
• Created UNIX Shell scripts for Batch processing and job scheduling.
• Demand forecasting and workforce scheduling has been done by using Click.
• Fixed errors ad hoc reports using Discoverer 10g.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 10g.
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved in database modeling and database design
• Involved in interacting with the end-user client to gather business requirements.
• Involved in Technical Documentation, Unit test, Integration Test and writing the Test plan.
• Involved in 24/7 on call production support.
• Used Team tracker to track development progress.
• Used PVCS Serena for Version Management.
• Used Toad Comparison Utility for identifying the changes in packages, procedures.
• Used Forms Compare tool to compare the difference between forms.

Environment: Oracle 11g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Unix Scripts, HTML.

Confidential

Role: Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements analysis, development, technical requirement specification, database design and testing phase of the project.
• Responded to ad hoc report/information requests from customers within given time.
• Interacted with various cross functional application teams and shared perspective for change request management and areas of improvement in future releases.
• Worked on developing the database objects i.e., developed scripts for table creation, views, indexes, sequences, materialized views, nested tables, user defined types, bulk collect in oracle collection, Procedures, Packages and functions.
• Wrote complex SQL statements using joins, sub queries, Hierarchical Queries, inline views and oracle analytical functions and Aggregate Functions.
• Transform and load of source data into Oracle database using Oracle external tables and PL/SQL stored procedures.
• Modify existing scripts to create Materialized Views of data merged from multiple staging tables.
• Authored PL/SQL API's for CUD create, update, delete matrix for various tables and additional business logic.
• Defined ref cursors which would be called from UI.
• Create database triggers for automatic data validation and audit mechanism.
• Performed one time seed data setup by collecting information from various in house applications using SQL Loader.
• Created different database indexes like B-Tree index, Bitmap Non Unique and function based indexes in the new data model.
• Performed PLSQL tuning using BULK COLLECTIONS, Optimizer hints, Histograms, TKPROF, Explain Plan, PLSQL Profiling.
• Automate data management and reporting processes.
• Performed unit and user acceptance testing.
• Generate, Review and Analyze Explain Plans.
• Performed data backup using importing, exporting, and linking to various data systems.
• Created SQL Loader scripts to load data into the temporary tables.
• Worked with internal and external IT SOX compliance team and provided requested data for metrics and compliance needs.
• Gatekeeper for Quality initiatives with migration team to ensure that code is Production Ready .

Environment: Oracle 11g, Oracle Apex, PL/SQL, SQL, XML, Ant, Shell Script, UNIX and Windows.

Confidential

Role: Oracle PL/SQL Developer

Description: Project Deals with Design and development of a Centralized datamart to generate different reports on Sales by product, customer and region and Automation of process to Provide Data to Down Stream Application.

Responsibilities:

• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• Used Materialized View and refresh Process to provide data to downstream Application.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
• Developed PL/SQL stored procedures functions using REF cursors collections.
• Involved in creating Pseudo code documents for writing stored procedures.
• Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
• Involved in writing CTL files control files for SQL Loader to load the policy data from Flat files in to oracle tables.
• Performed SQL tuning using Auto Trace, Explain Plan, and Hints.
• Involved in Importing and exporting the Tables, Users and Schemas.
• Involved in migrating from mainframes to oracle 10g.
• Designed the queues and their underlying queue table using an object type implementation in order to pass XML messages

Environment: Oracle 10g SQL, PL/SQL , Reports 10g, SQL Loader, Toad, Perl Scripts, HTML and Linux.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL.
• Used Oracle Forms 10g to design and develop the interface for the system.
• Created Packages to automate transactions from the Oracle Forms.
• Designed, developed various reports using Reports 10g.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used UTL File Packages to Load data from Excel Sheet to Oracle tables.
• Performed the unit testing for procedures, functions and packages.

Environment: Oracle 10g, Oracle Enterprise manager, UNIX Shell Scripting, SQL, PL/SQL, TOAD, SQL Loader.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Materialized Views, Triggers, Sequences, Collections.
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data.
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
• Customized forms and reports as per user requirements using Oracle Developer Forms Reports.
• Interacted with clients in remote locations to verify customer requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, Forms 6i, Reports 6i, Windows.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Involved in full project life cycle like Designed, developed, implemented, maintained and tested the application.
• Ensure conformance to code standards and documentation requirements.
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Created database links to connect remote database.
• Create temporary table in a Stored Procedures.
• Tuned SQL statements and Procedures using Explain Plan and TKPROF.

Environment: Oracle 9i, Oracle Forms and Reports 10g, SQL Plus, TOAD, SQL, PL/SQL, Shell scripting, Serena version control system, BugZilla, Linux, Windows Server 2003, Windows XP.