SUMMARY

• Expertize in extensive backend code on the Oracle server - side using PL/SQL, including packages, stored procedures, functions, database triggers, TKPROF, EXPLAIN PLAN, Hints, PL/SQL Collections, Ref Cursors, Performance Tuning, Batch Processing, STAR Schema, co-related queries and complex joins for existing and new programs.
• Over 6 years of experience with Oracle development and proven background of technical problem solving as a Certified Oracle Professional
• Great ability to write Unix Shell (ksh) Scripts and an expertise in writing SQL*Loader scripting to work with various file types.
• Experience with Informatica in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Excel, Oracle, SQL server
• Good working knowledge with Oracle Workflow, DataStage, Crystal Reports and Discoverer, Oracle Business Rules Management System (BRMS), TelecomOSS/BSS and StarTeam to save the project documents, in dealing with clients to gather requirements, understanding the Business requirements, product demonstrations, database management tools such as TOAD, and providing product support on 24/7 basis
• Strong back-end processing with DBA skills including enhancing database performance, experience in understanding database architecture, data analysis, development, testing, and documentation of projects, expertise in using configuration management tools such as WinCVS, HP Open View, Service Call, and StarTeam 2006, Clear Case and good experience in using SQL*Loader to fetch data from Legacy Systems to Oracle Databases
• Comprehensive and in-depth experience in the System Development Life Cycle and the role of Database in this process and a self-motivated, responsible, and reliable team player with a set of strong technical skills.
• Extensive experience in Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Experience in working with Oracle forms and reports.
• Experience in Dimensional Data Modeling using Erwin and participated in designing the Logical and Physical Data Model.
• Experience in Database Design and Implementation of Discover Operational Data Store (ODS) and Enterprise Data Warehouse (EDW) and Data Marts (DM).
• Experience in working with Java developers to coordinate Web-based functionalities with Oracle Database. Knowledge in XML, HTML and JavaScript.
• Excellent knowledge on Clarify CRM .
• Good knowledge on P&C insurance domain.
• Involved in jobs scheduling, monitoring and Production Support in a 24/7 environment.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, MS SQL SERVER 2000/2005/2008/2012 , MySQL5.x, MS Access 97/2000, DB2/UDB, Teradata(EDW), My SQL, OLTP, OLAP, WFS, Data Warehouse, Impala

Tools: Toad, Ultra Edit, Oracle Forms, Oracle Reports, SQL*Plus, Microsoft Office.

ETL Tools: Informatica Powercenter 9x

Languages: ASP.NET, C. C++, C#, SQL/PL SQL.

Web Tech: HTML, UML, VBScript, JavaScript.

Operating systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows 7/NT/XP/98/95/2000 &Windows XP MS-DOS, MAC OS X.

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Oracle Developer

Responsibilities:

• Interacting with the Stake holders, domain expertise for requirement
• Gather requirements and analyzing the requirements
• Designing the logical, conceptual and physical schema and schema objects
• Migrating data from legacy systems to oracle 11g
• Extensively worked with oracle SQL Developer tools
• Responsible for Partitioning & Sub - Partitioning Large Tables into smaller tables using Range Partitioning and List Partitioning.
• Designed global temporary tables
• Designed tracking packages for better practices
• Defined user defined exceptions
• Worked with materialized views
• Worked with UTL FILE package to extract and load data into stage database
• Defined stored procedures for ETL tasks, and loaded the target tables
• Expertize in extensive backend code on the Oracle server-side using PL/SQL, including packages, stored procedures, functions, database triggers, TKPROF, EXPLAIN PLAN, Hints, PL/SQL Collections, Ref Cursors, Performance Tuning, Batch Processing, STAR Schema, co-related queries and complex joins for existing and new programs.
• Great ability to write Unix Shell (ksh) Scripts and an expertise in writing SQL*Loader scripting to work with various file types.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL/SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Worked on impala database.
• Worked on Oracle Forms.
• Debugged Pl/sql from .NET.
• With Impala we have query data, whether stored in HDFS or Apache HBase.
• Worked with Oracle 10G Multi-Terrabyte data warehouse and executed the DDl statements to create data warehouse.
• Amdocs clarifyCRM benchmark were tested using the oracle database.
• Worked with cognos reports: Framework manager, Report studio and Power play.
• Worked in Property and Casual insurance domain (P&C) with business analysts.
• Worked with Risk Marking Systems and concepts required with specific understanding of Market-to-Market and VaR Concepts.

Environment: Oracle 10G, Oracle 11g, Oracle SQL Developer, SQL*Loader, UNIX Shell Scripting.

Confidential, New York

Oracle Developer

Responsibilities:

• Responsible for Partitioning & Sub - Partitioning Large Tables into smaller tables using Range Partitioning and List Partitioning.Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Gather Business rules from the end users that are to be incorporated into the system.
• Extensively worked on the analysis of Tables in both Legacy Data store and new data store.
• Extensively worked on the analysis of Columns in mapping tables for both Legacy Data store and new data store.
• Developed the complete documentation of the project based on the analysis of tables and Columns.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL/SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Utilized tools like PL/SQL Developer during development of the application.
• Developed SQLqueries to fetch complex data from different tables in remote databases using database links.
• Implemented the concepts of Parallelism to improve query performance.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Worked heavily with Bulk Collects whenever I needed to fetch large amounts of data.
• Create External Tables for data loading in and out of Database.
• Worked with cognos reports: Framework manager, Report studio and Power play.
• Worked on .NET framework to call stored procedures.
• Worked on Oracle Forms and Reports.
• Source data residing in Excel formats are exported verbatim to flat files and then accessed via Oracle external tables in order to load into the staging schema, at which point all source data can be efficiently transformed and migrated to the target schema.
• Extensively usedConcepts of Dynamic SQL.
• Extracted data from Flat files using SQL*LOADER.
• Developed Unix Shell Scripts for loading data into the database using SQL* Loader.
• Created partitions on the tables to improve the performance.
• Used clarify link aggregation configuration for the Oracle solaris.
• Participated in application planning, design activities by interacting and collecting requirements from the end users.
• Worked with Risk Marking Systems and concepts required with specific understanding of Market-to-Market and VaR Concepts.

Confidential, Richardson, TX

Oracle PL/SQL Developer

Responsibilities:

• Heavily involved with the Logical and Physical Design of the Database.
• Creation of database objects like tables, views, procedures and functions.
• Developed PL/SQL-Packages, SQL Scripts and DatabaseTriggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Wrote complex SQL queries with Co-Related Sub queries, nested loops for faster data retrieval from multiple tables.
• Extensively used cursors (refcursor, sys refcursor), sequences in the procedures according to the requirement.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS, and DBMS PROFILER.
• Used crontab, dbms job and dbms schedular for scheduling of jobs.
• Used Dynamic SQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Worked with cognos reports: Framework manager, Report studio and Power play.
• The project comprised of processing with C# and Oracle PL/SQL.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Worked on User-defined and System definedexceptions to handle different types of Errors.
• Used SQLCODE and SQLERRM for the exceptions error code.
• Extensively worked on SQL Loader for loading data into tables from flat files and CSV files.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Developed UNIX shell scripts (Korn/Bourne/bash) for routine tasks.
• Used rollup, cube operators, merge with insert and update statements.
• Developed flat files using UTL FILE Oracle supplied packages.
• Creating and worked with GTT (Global Temporary Table).
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops while developing procedures.
• Worked with Risk Marking Systems and concepts required with specific understanding of Market-to-Market and VaR Concepts.
• As a team member, involved in interacting with business users, gathering business requirement.
• Provided 24x7 on-call supports. Worked Confidential regular hours based on business demands.

Environment: Oracle 10g, Solaris 5.10, UNIX, Windows XP, SQL Developer

Confidential

Oracle PL/SQL DEVELOPER

Responsibilities:

• Designing module wise Oracle 8i database structure and its implementation on the client server
• Used PL/SQL table to avoid mutating problem in database trigger
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types
• Created database objects like tables, views, indexes, partitions.
• Taking logical backups using export at object and schema level.
• Performed user administration, space administration on Development and QA databases.
• Worked on tuning the SQL queries and stored procedures.
• Query performance using better joins and used Hints appropriately
• Used EXPORT/IMPORT to do table level and full database de-fragmentation
• Developed packages, procedure and functions for complex Reports
• Modified Stored Procedures and Stored Packaged Procedures.
• Used composite data types like %ROWTYPE and %TYPE
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Scheduling different activityusing Perl scripting
• Created documentation for the application.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Writing small shell scripts for automating jobs

Environment: Oracle 8i, Sun Solaris 2.6, Toad8.0, Windows 2000/NT, SQL plus, PL/SQL