Summary:

• 8 Years of experience in Oracle Database Programming using PL/SQL, SQL, Database Design both Physical and Logical , Database Modeling Designer 2000 , Application Support, Performance Tuning, Software Maintenance, User Security Management, Oracle Tuning Optimization.
• Extensive experience in database development 11g/10g/9i/8i using various Oracle objects like cursors, ref-cursors, collections nested tables, Varrays , Functions,Procedures,triggers, packages, views,DB Links,DB Export/Import utilities,External Tablesand indexes, Materialized Views.
• Strong experience on Extraction, transformation and Loading ETL logic using PL/SQL.
• Competent in creating Unified Modeling Language UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams using Microsoft Visio and Erwin.
• Experience in Data migration Projects which uses SQL Loader, Import/Export PL/SQL Programming, coding Procedures, triggers and functions.
• Strong experience using Unix Shell Scripting, Pro C, HTML, Oracle 11g/10g/9i/8i, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22
• Exposure in using CASE tools like TOAD, SQL Navigator and SQL Developer for writing PL/SQL programs.
• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Backup and Recovery Planning, Testing and Implementation.
• Extensive experience in a Data warehousing environment.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Knowledge on Informatica 8.6, BI publisher, DAC, OLAP, OLTP,XML, Oracle Argus,SSRSand OBIEE.
• Followed Agile and Scrum development methodologies in delivering the deliverables.

Technical Skills:

Professional Experience:

Confidential

Senior Lead Oracle PL/SQL Developer

• Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
• Writing ad-hoc queries to analyze the desired output from the relational model.
• Identify in-efficiently written SQL's for fine tuning in order to improve performance.
• Bulk updates/inserts using Merge statements.
• Optimize the PL/SQL code using collections and bind variable for bulk operations.
• Writing analytical queries for faster processing and better performance.
• Using appropriate hints and query techniques for faster retrieval of information.
• Conversion and mapping of data, verifying the data integrity and validations.
• ETL activities like retrieval of data from external file using external table for data transformation.
• Loading detailed atomic data into dimensional structures using SQL Loader utility
• Exporting the database using data pump expdp/exp utility.
• Balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.
• Structure dimensional models around business processes.
• Creating sample data for unit and integrated testing for end-to-end process.
• Perform functional testing to ensure technical accuracy based on functional specification document.

Environment: Oracle 10g/11g, MS SQL Server 2008, SQL, PLSQL, Cognos, Informatica, TOAD, Unix, Windows

Confidential

Role: Senior Oracle PL/SQL Developer

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 10g/11g, SQL Developer, Quality Center, SVN, Informatica, Cognos,TFS,Remedy,

Oracle Argus,ArisG

Confidential

Senior Oracle Developer

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Create detailed documentation for user approval.
• Create and modified data migration scripts/Pull Scripts.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages.
• Writing database triggers for automatic updating the tables and views.
• Create User Schemas, tables, indexes, sequences, views, directories.
• Verify, validate data using SQL queries.
• Modified existing Code according to the requirements.
• Day to day production support.
• Troubleshoot and debug system and/or data errors.
• Tuned SQL queries using Tkprof utility to improve performance.
• Involved in Testing, Integration System test, Implementation test with users .
• Converted data from legacy system to Oracle 10g using PL/SQL programs.
• Responsible for creating complex views.
• Use VSS and SVN for source control.
• Involved in migrating MS-Access systems to Oracle Database.

Environment:Oracle 11g/10g, Windows XP, VSS, SQL Loader, JIRA, TOAD, Erwin, QC

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Created procedures for Daily reports, Intraday reports, Monthly reports, etc.
• Developed PL/SQL Triggers, Stored Procedures, Functions and Packages to replicate data in real time which is used by trading system.
• Created programs scripts using Shell Script for developing batch jobs using Crontab.
• Used SQR and created Procedure related to them and used Dynamic SQL to create table, drop table and insert data during run time environment.
• Involved in the modification of the logical model of the database for the trading system by reverse engineering methodology developed the entire ERD using Erwin.
• Migrated Data from Sybase to oracle and used both database for creating Shell script/ Perl scripting to send data in email or fax or print in format rtf, xls, lis, csv, html, doc for decision support system.
• Used Shell scripting to put and get data on/from the ftp and remote procedure call RPC too.
• Created new Tables, integrity constraints Primary Key/Foreign Key in Oracle 11G.
• Involved in debugging various defects relating to implementation of business logic.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 11g.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs. Developed triggers and packages to delete stored session data from various tables.
• Worked closely with DBA for tasks such as import/export, query performance and urgent bug fixing in batch. Working closely with traders and quantitative analysts in a highly fast-paced environment to fix production issues and provide enhancements as per requirements.

Environment:Oracle 11g/10g, AS400, Windows, SQL Loader,TOAD,Unix

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, DB triggers, Indexes and Collections.
• Developed database triggers for automatic updating the tables and views.
• Involved in development of User Interface Objects Forms9i and Reports9i and Testing of entire module.
• Analysed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Involved in migrating forms from 6i to 9i using migration assistant.
• Documented all the packages, procedures and functions involved in ETL process.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Created reports using data providers like universes, freehand SQL.
• Used PL/SQL collections, Bulking techniques, Table Partitioning to increase database performance.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Used SQL Server Business Intelligence to make SSIS packages as part of ETL process.
• Implemented SQL Loader direct path option for bulk inserts into database.
• Designing new universes and modify existing universes using features like aliases, loops, contexts, joins. Creating dimensions, measures and detail objects which are grouped into classes.
• Involved in Unit testing the Oracle developed scripts.
• Modifying existing scripts for query performance using TOAD.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan

Environment:Oracle 11g, Datastage, Autosys, Abinitio, Cognos, Remedy tool.

Confidential

Software Engineer

Responsibilities:

• Rewritten the stored procedures, packages and functions in Oracle PL/SQL in Windows platform.
• Eliminated deadlocks in report generation process DBR .
• Creating Oracle jobs Using Oracle 10G DBMS SCHEDULER to automate the report generation process.
• Tune the time consuming SQL queries.
• Defined and implemented performance tuning techniques using Oracle hints, creating indexes and collecting statistics.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Perform unit testing and track the defects in QC.
• Involved in Designing, Testing and Coding of New Reports using Crystal Reports 9.
• Discussion with the core users and end users for requirements freezing.
• Create control files and load data from flat files to tables using SQL Loader.
• Generate trace files with the help of DBA's and identify the problematic SQLs.
• Client Specific Report Customization Using IFS Report Builder and Oracle Reports 6i.
• Provide training to the IT department on Crystal Reporting tool.
• Plan, participate and prepare documents for Data Migration using Oracle 10g PL/SQL and Reports Development using Crystal Reports 9.

Environment:Oracle 10g, Windows OS, Informatica 8.6, SQL Developer