SUMMARY:

• Over 7 years of Oracle experience in Oracle 11g/10g/9i, SQL, PL/SQL as an Oracle developer/PL/SQL developer in Analysis, Design, Data Modeling, and Implementation of Business Applications using the Oracle Relational Database Management System
• Over 5 years of experience in full life cycle Data Warehousing projects and creating ETL framework
• Experience in financial, insurance and health care.
• Over 5 years of experience in writing shell scripting on different type of shells Bourne shell, Korn shell using Unix/Linux and scheduling jobs using Crontab in Unix environment.
• Strong Data modeling experience, using ER diagram, Dimensional/Hierarchical data modeling using tools like Erwin.
• Well experienced in Query Optimization and Tuning using index, bulk collections, Hints, Explain Plan.
• Applicable knowledge of tools like SQL PLUS, SQL Loader, export/import, TOAD and data pump utilities like expdp/impdp.
• Transferred data using data transfer tools like FTP File Transfer Protocol and SFTP Smart FTP
• Mastery of creating of Complex SQL queries, PL/SQL Stored Procedures, Functions and Packages for business needs.
• Expertise inData Migration, Data Mapping or Table mapping, data loading and exporting by using Import Exportand UTL File Utilities.
• Strong knowledge in dealing with CLOB, BLOB using DBMS LOB package
• Experience in creating mappings usingInformatica.
• Creative, independent, good team player with and ability to accept responsibilities and meet tough deadlines.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, JAVA, C , UNIX shell Scripts

RDBMS: Oracle 11g/10g/9i/8i/8.0/7.0, MS-SQL Server 2000/2005, MySQL.

ETL Tools: Informatica 9.5, IBM Datastage.

GUI:Oracle Forms Reports 10g/11g.

Database Tools: TOAD 10.6, SQL Developer 3.1, Oracle Enterprise Manager OEM , Erwin 4.14/4.0, VI Editor, Oracle Apex

Operating System: Linux Redhat/Ubuntu , IBM AIX 5.2/5.3, Windows 7/XP

Data Utilities: SQL Loader, Export/Import, Data pump, Explain Plan, Oracle Wrap

PROJECT SUMMARY:

Confidential

ETL Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Involved in maintaining and updating the procedure for ETL process.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• WroteUNIX shell scripts to automate processes like data load and sending notification mails.
• Executed upload and load procedures to check the data feed is correctly getting loaded into the tables.
• Extensively used Bulk Collect and Bulk Binding along with SAVE EXCEPTIONS clauseto speed up data retrieval.
• Used exception handling methods along with pragma exception initin order to associate our own created exception names.
• Created Materialized Views to calculate and store summary data beforehand, dramatically speeding up 'aggregate' queries
• Modified existing SQL and PL/SQL Code to improve performance usingindexing, table partitioning, hints, explain plan, profiler and etc.
• Modified existing forms and reports and registering those in Application.
• Modeled the Data Warehousing Data marts using Star Schema.
• Directly interacted with users and helped in the development of functional specifications.
• Wrote technical specifications for all the procedures developed in the module. Maintained log files during analysis and subsequently report any performance defects.

Environment: PL/SQL, TOAD, SQL Loader, Oracle 11g, UNIX, Erwin, SQL Plus, and Oracle Forms.

Confidential

Oracle PL/SQL Developer/BA

Responsibilities:

• Was involved in fast paced AGILE Environment.
• Programmed in T-SQL to implement Stored Procedures and Functions for different tasks.
• Prepared tech documentation for easy understanding by other developers.
• Created stored procedures, packages, generated triggers for security purposes using TOAD.
• Used Wrappers for data security which encrypts the PL/SQL code hide the customer information .
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Created the Temp tables in the stored procedure for different applications.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS.
• Loaded data from flat files into Database using SQL loader.
• Created Unix Shell Scripts for automating the execution process.
• Used DBMS SCHEDULER package for job scheduling.
• Created XML supported document.
• Performed code reviews through APEX.
• Worked on Web application development with APEX.
• Used Oracle APEX for development, code documentation unit testing.
• Involved in Unit testing, Integration test and writing the Test plan.
• Trained end users on the functionality and operability of the application.

Environment:Oracle 11g, APEX, Solaris 5.8, PL/SQL,T-SQL,SQL PLUS 9.2.0.3, TOAD 10.6, SQL Developer 3.1, Oracle Enterprise Manager, HTML 5, Mercury Test Director 9, UML 2.3, MS Visio 2010.

Confidential

PL/SQL Developer

Responsibilities:

• Gathering business requirements
• Experience working with Market Data obtained fromTrading venues
• Provided highly specific support and development fixes by leveraging knowledge of financial market products, such as Futures, Options and other Derivatives
• Used export/ import andexpdp/impdp database utilities for data transfers
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating and working with GTT Global Temporary Table
• Made use of Sub query-Factoring WITH clause to make complex SQL statements simple and make them more efficient
• Involved in programming database triggers for automatically updating tables and views
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Used SQL Loader and external tables for moving the data from flat files to staging area tables.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans, profiling and Trace sessions for Cost based Optimization
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 10g, Windows, PL/SQL, SQL Loader

Confidential

Sr.Oracle Pl/sql Developer

Responsibilities:

• Created new tables, views, queries for new enhancement in the application using TOAD.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client usingSQL Loader.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, functions, and triggers and handled errors using Exceptions for implementing role based security access for VIAONE reporting system.
• Tuned the queries using Explain Plan and packages, procedures and functions using sql trace.
• Created technical documentation for all the scripts written for future reference.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Performed ETL Process by using Informatica Power Center.
• Created Mappings by using the Informatica Designer and applied the joiner, aggregate, expression, rank, filter, router Transformations.
• Developed mappings using informatica to convert TPA data of different clients into JURIS claim management system.
• Used conversion tool to know what sources are to be mapped to the targets to get required transformed data.
• Converting all the completed trades into flat file to send to back office, loading everyday customer accounts with stock position and cash balance using Perl DBI .
• Debugged the mappings using debugger option in informatica tool to validate the data conversion mapping.
• Created workflows using workflow Manager for loading the converted data into the target tables.
• Packages are created for data validations to make the data supported by JURIS claim management system.
• Developed Unix Shell Scripts to create parameters to automatically connect mappings to defined sources and targets of different schemas.
• Created shell scripts to maintain the log files of the target tables, to know whether the data inserting into the target tables is according to the JURIS standards and weather the data is meeting client's requirements.

Environment: Oracle 9i/10g, SQL Plus, Perl, TOAD 8.6.1, Informatica Power Center 8.5, UNIX, Power Term, Conversion Tool.

Confidential

PL/SQL Developer

Responsibilities:

• Developed tables, views, stored procedures, functions, and user-defined data types
• Created table structures along with the triggers, indexes like bitmap and function based indexes
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Maintained the data integrity and security using constraints and database triggers
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Troubleshoot performance issues within packages and stored procedures using explain plan and DBMS OUTPUT
• Responsible for tuning the application with the help of team members Oracle support
• Improved the query performance using better joins and hints appropriately
• Developed packages, procedures and functions for complex reports
• Used SQL Loader for loading the data into the tables from files
• Developed batch programs using UNIX shell scripts
• Participated in the design and code reviews and verified compliance with the project's plan
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, Sun Solaris 2.6, SQL loader, UNIX