SUMMARY:

• Around 8 years of experience in Data-Analysis, Design, Development, Testing, Debugging.
• Extensively worked in application development usingOracle 11g/10g/9i/8i/7.x, Oracle SQL Developer, SQL, PL/SQL, and UNIX Shell Scripting.
• Extensively worked on Backend Programming using PL/SQL Stored Procedures, Functions,Analytical Functions, Packages, Anonymous Blocks, Databasetriggers for Oracle 10g/9i/8i/7.x.
• Good Knowledge on Object Oriented languages like java,C ,XML,jsp.
• Good working Knowledge of Data Acquisition, Data Integration and Data Loading.
• Well Experienced in Tuning SQL Queries by Creating Indexes, Optimizers, and Hints and analysing the Explain Plan.
• Excellent knowledge in using Views, Synonyms, Indexes, Sequences, Joins and Sub-Queries.
• Extensively Used Cursors, REF Cursors, Exceptions and Hints. Worked heavily with Table Partitioning.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Extensive experience with SQL Loader tool with both direct and indirect load methodologies.
• Sound Knowledge in customization using Forms Reports6i and interfacing with third party applications.
• Good knowledge of using Function Based Indexes, Sequences and Inline View.
• Good Understanding of Data modelling Concepts.
• Excellent knowledge in developing UNIX Shell Scripts for process automation.
• Extensive involvement in development and Performance tuning of SQL and PL/SQL using HINTS, BULK-COLLECT, Global Temporary tables, Explain Plan,Tkprof, Table Partitioning, Indexes and Join Optimization.
• Exposed to varied environments in the areas of application development with emphasis on all stages of Software Development Life Cycle SDLC .
• Involved in testing, debugging, fixing bugs and documentation of the system.
• Excellent written, organisational and verbal communication skills.
• Expert in understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle PLSQL developer

Description:

Confidential services to operate, maintain and electric- generation facilities. Confidential power services provide electricity to homes and business. It had several tools to be used by consumers to better manage their energy services.

Responsibilities

• Played key role in designing and implementing Strategic and Tactical sourcing of data from various systems, processing it and feeding into Data marts and various external systems.
• As part of implementing rules, developed generic shell scripts, procedure, functions, packages, table and index definitions, partition schemes considering optimal performance in terms of storing and retrieving the data.
• Extensively made use of Sql-Loader, Shell scripting, PL/SQL and Automated ControlM jobs to automate the entire Strategic Batches which were run one per region AMS, EUR PAC
• Redesigned and Developed Table partitioning maintenance framework, which in conjunction with the new tablespace strategy achieves optimal space utilization.
• Implemented parallel direct path load for loading huge files into Staging tables, which saved 20 to 30 minutes on certain jobs as part of tuning the Strategic batch to meet the SLA.
• Expertise in developing forms using Oracle Forms/Reports 6i.
• Involved in Unit testing and Integration testing of Forms and Reports
• Implemented Basel III functional rules by coordinating with BA's to understand functional specifications and prepared technical specs and given demos to Data Mart users.
• Extensively involved in analyzing and tuning long running jobs in production.
• Preparing Test Plan and traceability matrix.
• Test Scenario and Test Case preparation based upon Functional specifications.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL Loader, SQL Plus and PL/SQL programs that run as nightly interfaces.
• Develop and reviewed technical design documents to ensure the changes fit into existing architecture and, follow all the guide lines and all programming changes are recorded for audits and future reference
• Work closely with Testing FT and UAT teams in resolving issues while testing

Environment: Oracle 11G, SQL, PL/SQL, Oracle Forms/Reports 6i,Framework design, Erwin, Toad, SVN, SQL Loader and Data Modeling Shell scripting,Windows XP.

Confidential

Sr. Oracle PLSQL developer

Confidential a Confidential leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems.

Responsibilities

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Used Oracle Exadata database storage servers to reduce IT costs through consolidation, store up to ten times more data, improve performance of all applications, deliver a faster time-to-market by eliminating systems integration trial and error, and make better business decisions in real time.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Customization of code as per the user requirements.
• Involved in the analysis of the existing database.
• Designed and extensively worked on Project Documentation.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases

Environment: Oracle 11G, SQL, PL/SQL,Framework design, Erwin, Toad, SVN, SQL Loader and Data Modeling Shell scripting,Windows XP.

Confidential

Oracle PLSQL developer

Confidential is a comprehensive set of reform measures, developed by the Basel Committee on Banking Supervision, to strengthen the regulation, supervision and risk management of the banking sector. Confidential is already on B 2.5 and now implementing BIII and scheduled to go live Confidential.

Responsibilities:

• Played key role in designing and implementing Strategic and Tactical sourcing of data from various systems, processing it and feeding into Data marts and various external systems.
• As part of implementing rules, developed generic shell scripts, procedure, functions, packages, table and index definitions, partition schemes considering optimal performance in terms of storing and retrieving the data.
• Extensively made use of Sql-Loader, Shell scripting, PL/SQL and Automated Control jobs to automate the entire Strategic Batches which were run one per region AMS, EUR PAC
• Redesigned and Developed Table partitioning maintenance framework, which in conjunction with the new table space strategy achieves optimal space utilization.
• Implemented parallel direct path load for loading huge files into staging tables, which saved 20 to 30 minutes on certain jobs as part of tuning the Strategic batch to meet the SLA.
• Implemented Basel III functional rules by coordinating with BA's to understand functional specifications and prepared technical specs and given demos to Data Mart users
• Extensively involved in analysing and tuning long running jobs in production.
• Responsible for creating and managing deployments scripts and managing code merges using SVN.
• Develop and reviewed technical design documents to ensure the changes fit into existing architecture and, follow all the guide lines and all programming changes are recorded for audits and future reference
• Work closely with Testing FT and UAT teams in resolving issues while testing

Environment:Oracle 11G, SQL, PL/SQL, JAVA, JSP, Framework design, Erwin, Toad, SVN, SQL Loader and Data Modelling Shell scripting.

Confidential

Oracle PLSQL developer

Confidential is a global provider of business process and technology management services, offering a portfolio of enterprise and industry-specific services. Genpact serves clients in various industries including banking and financial services, insurance, capital markets, healthcare, life sciences, consumer goods, retail, aerospace, automotive, energy, hitech, transportation logistics, and hospitality.

Responsibilities

• Developed new PL/SQL programs to load and pull the respective data for those Loans eligible to be processed based on various business criteria.
• Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
• Involved in writing DDL and DML operations.
• Worked very closely with functional team to understand their Development related requirements.
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect Minus set operators.
• Extensively used DBMS Scheduler packagein order to schedule the refreshment of the Materialized Views on a periodic fashion.
• Designed and developed several views like Materialized View for data retrieval for the reports.
• Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package.
• Responsible for Tuning of application with the help of Other Team Members Oracle Support.
• Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
• TunedSQLqueries to enhance performance, using the method Explain Plan both at backend and in Toad.
• Created test scenarios for created code and distribute across to the QA along with Knowledgetransfer.
• Written an excellent documentation about the entire NRTO flow.
• Extensively used TOAD tool to increase the productivity and application code quality.

Environment: TOAD, PLSQL Developer, Oracle 11g, 10g,Windows XP,Tortoise SVN, Win Merge.

Confidential

Oracle PLSQL developer

Confidential Priority Health offers a nationally recognized Confidential and other group and individual health insurance plan options. Individual and family plans include Confidential, Medicare Advantage, Confidential, Confidential Medicaid and Confidential plans. Project Deals with maintaining all the insurance coverage's of the customers.

Responsibilities

• Created new database objects such as tables, views, indexes, triggers and synonyms.
• Wrote different new scripts in PL/SQL using Packages, Procedures, Functions and Triggers.
• Extensively worked on writing the SQL queries using joins, Order by and Group by.
• Created Collections for accessing and storing complex data resulted from joining of large number of tables.
• Extensively involved in writing DDL and DML operations.
• Involved in loading and Re-loading the County data into the database.
• Extensively used TOAD tool to increase the productivity and application code quality.
• Understanding the business documents and create statements and modify the scripts.
• Involved in testing all the scripts in test database and moved into the production.
• Schedule jobs using UNIX Crontab and Shell Scripts.
• Involved in Analysis and Documentation of Make UNIX Utility.

Environment: Oracle 10g, TOAD 9.7.2.5, SQL, PL/SQL, Windows XP, SQL Loader, UNIX, WinSCP, GroupWise.

Confidential

Oracle PLSQL developer

Confidential is one of the world's leading management firms for executable strategy, operations, technology, and human capital advisory services. The firms practice is built around integrated core capabilities - people, process and technology and industry expertise - the capabilities needed to help clients to tackle their most complex challenges.

Responsibilities

• Involved in analysis, system design documentation.
• Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Developer.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors using oracle 10G.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception In it, Locks, used save points, commits rollbacks to maintain Transactional consistency database integrity.
• Wrote complex in-line Views which summarized the business needs to the fullest.
• Involved in Migrating the entire database setup from test environment to production.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL in oracle 10g and UNIX utilities.
• Involved in the continuous enhancements and fixing of problems.
• Involved in creating Detail Design Documents for the requirements.
• Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages

Environment: Oracle 10g, TOAD 9.7.2.5, SQL, PL/SQL, Windows XP, SQL Loader, UNIX, WinSCP, GroupWise.

Confidential

Oracle PLSQL developer

Confidential is a leading provider in software services, project I involved during my tenure with the company was ecommerce portal management implementation. This is a complete upgrade to Oracle 10g Enterprise edition from core legacy systems.

Responsibilities

• Designed and implemented ETL processes that scan and read data from more than 20 tables from relational database to staging table doing required transformations.
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Involved in performance fine-tuning of the queries/reports using Explain plan and Tkprof.
• Created stored sub programs with Dynamic SQL and Ref Cursors
• Implemented nightly load processes to read changed benefit and geographic data sent from mainframe as flat files which includes transformations, scanning tables for missing fields, error reporting etc.
• Worked on procedures that load data into Star Schema from staging tables.
• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus.
• Created stored sub programs with Dynamic SQL at both Client and Server side.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Implemented utilities that use DBMS scheduling to scan relational database tables for updates at specified intervals.
• Implemented special precautionary measures to avoid duplicates while scanning multiple tables for changes.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit.
• Extensively used oracle packages, Stored procedures, sequences, ref-cursors, dynamic queries, utl-files, bulk inserts, exception handling, DB Links etc.
• Worked on porting of existing reports based on relational database to Star Schema, which involves defining queries involving fact and dimension tables.
• Closely interacted with testing team to address issues and defects on the timely manner.

Environment: TOAD, PLSQL Developer, Oracle 10g, 9i, Windows XP, PL/SQL, Shell Scripts, InformaticaPowerCenter 5.2/6.2