SUMMARY

• Over 7 years of experience in system study, design, development, support, maintenance and implementation of client/server applications, database applications with Oracle11g/10g/9i/8i, DB2 and MS - Access 2010/2008/2002 as backend.
• Responsible for technical architectures, analysis, design, development, test and implementation on production. Developed database design (logical and physical models) by applying Normalization techniques and understanding relational database concepts such as Indexes, Primary and Foreign Keys and Constraints.
• Extensive experience in Oracle11g/10g/9i/8i Enterprise Edition Database Server configuration, performance tuning and upgrade on IBM AIX, Solaris, Linux and Windows O/S.
• Developed schema objects scripts to create tables, indexes, views on the Development, QA and Production Oracle11g/10g/9i/8i databases
• Sound capabilities and solid experience of creating DB Objects, PL/SQL packages, Procedures, Functions, Triggers and scheduled jobs to manipulate and migrating complex data sets in Oracle Databases.
• Experienced in Performance Tuning and sql Optimization.
• Extensively used TOAD, SQL Developer tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations and Web application development.
• Extensive experience in advanced PL/SQL constructs such as Oracle supplied Packages, Nested tables, arrays, Records, Types, Dynamic SQL
• Extensively used dynamic SQL within Oracle stored procedures for run time actions and troubleshooting the performance problems caused by the SQL and optimizing the SQL code for better performance
• Experience in extraction, transforming and loading (ETL) data flows using PL/SQL, Oracle Apps
• Extensively used SQL*Loader to load data from the Legacy systems into Oracle databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables. Used EXPORT/IMPORT Oracle utilities to help the DBA to migrate the databases from Oracle9i to Oracle11g/10g.
• Have extensively used Global Temporary Tables, Data Base links and Partitioned Tables/Indexes, Index organized tables, Clustered Tables, Analytical Functions, Pipelined Functions
• Experience in performance tuning using EXPLAIN PLAN, TKPROF, SQL Trace, OEM, ADDM and various types of hints, partitioning of tables and indexes.
• Extensively developed Oracle SQL utilities using SQL*Plus, PL/SQL for production data migrations and data fixes on Oracle11g/10g environments
• Experience in providing 24X7 technical supports and providing work-around to keep production activities smooth till issues are resolved.
• Efficiency in handling production application and data issues and in analyzing them to replicate and resolve.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• Strong analytical and conceptual skills in database design and development in client/server applications
• Team player with excellent interpersonal skills and ability to work individually as well as part of a team
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP/Vista/7,SUN solaris, UNIX (HP-Unix)

Databases: Teradata, Oracle 11g/10g/9i/8i, DB2, SQL Server 2000/2005 and MS Access

Tools: Toad, Teradata SQL Assistant, ILM (Data Archiving Tool) SQL LOADER, MS Visio

Database Performance Tuning Tools: EXPALIN PLAN, TKPROF, OEM, AWR, ADDM

Languages: C, C++, SQL, PL/SQL, UNIX (KSH, BASH), JCL, XML, HTML

ETL Tools: Informatica Power Center 9.1/9.0/8.x, Informatica Metadata manager, Informatica Power Exchange

Domain Knowledge: Banking and Finance, Telecom

Scheduler: Control-M, Corn tab, CA7

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Senior Oracle PL/SQL Developer

Responsibilities:

• Responsible for technical architectures, analysis, design, development, test and implementation on production.
• Generated schema scripts to create database objects (Tables, Indexes, Views, Sequences, Primary and Foreign keys and Constraints).
• Responsible for designing and interpreting web application database models (Logical &Physical) by applying Normalization techniques and understanding relational database concepts such as indexes, primary and foreign keys and constraints. Developed schema scripts (Table, Indexes, views, sequences, primary and foreign keys, constraints) to deploy them into DEV, QA and PROD environments.
• Extensively developed Oracle stored packages, functions, procedures and database triggers using PLSQL11.0/10.0 to perform Oracle back-end validations, data manipulations and legacy data conversions on Oracle11g/10g database environments.
• Developed Oracle packages, functions and procedures to sync the modified legacy information into new web application’s Oracle tables.
• Extensively used dynamic SQL, Ref-Cursors and Oracle Types within Oracle packages, functions and procedures to perform actions dynamically during the system run time. Responsible for troubleshooting and optimizing SQL code used within Oracle packages, functions and procedures. Extensively used EXPALIN PLAN, TKPROF and TOAD to monitor query performance. Created necessary indexes and used hints for better query performance.
• Implemented database logging by developing Oracle packages to capture various system events and scheduled DBMS Oracle Control M jobs to clean-up unwanted logged information from the log tables periodically.
• Developed Oracle PLSQL procedures, SQL routines and mapping tables to convert Legacy data into Web application’s oracle database system.
• Extensively used SQL*Loader to load the legacy tables data into Oracle11g database tables by using control files and Oracle external tables.
• Extensively used TOAD, SQL Developer for developing Oracle stored packages, functions, procedures. Developed SQL utilities using SQL*Plus for Web application development, data migrations and conversions.
• Worked on Oracle11g/10g database schema refresh from Production to Development and QA environments and performed post refresh activities such as re-setting sequence generators, validating packages and granting the necessary table privileges to the users
• Implemented system security at database and application level by creating roles, profiles, views, grants and application users with limited privileges
• Extensively worked on system-defined packages like DBMS OUTPUT, UTL FILE and DBMS JOB for scheduling the jobs.
• Responsible for Production and QA Support for various database and application related issues.
• Developed application technical design documents and user guides for training.

Environment: Oracle 11G/10G(SQL*Plus, SQL*Loader, EXP/IMP, DATAPUMP), MS-Access2010/2008, TOAD, SQL-Developer, ANSI SQL, PL/SQL11.0/10.0, Control M, Sub Version, ITSM

Confidential, Summit, NJ

Sr. PL/SQL Developer

Responsibilities:

• Designed the VPD centralized framework architecture for all the databases with the Information one eco system
• Designed and Developed Privacy Information Frame work to determine the PI columns for VPD framework to ensure protection of personal information (PI) and personal identifiable information (PII) by working with the Chase IRM.
• Designed various levels of PI categories for users to access the data based on the Job Function
• Assisted the DBA’s to install VPD
• Implemented Automation to Mask PI data for ASCII delimited and Fixed Width files
• Assisted the Info1 central team to build the UI for the schema owners to enable PI policies
• Built a user friendly framework/process for all the File Based Test Data Management needs using the Informatica product “TDM”.
• Implemented the Test data Management Strategy for both File Based and database in the lower environments
• Built the Masking routines using the tool TDM for all the SOR’s that lands in the Info1 eco system and keep them evergreen
• Built a repeatable and sustainable Test Data management framework in the Lower environments with tighter governance.
• Conducted Brown Bag sessions across the Shared user community on the usage of the VPD framework and Data Subset/Masking process
• Responsible for technical architectures, analysis, design, development, test and implementation on production.
• Generated schema scripts to create database objects (Tables, Indexes, Views, Sequences, Primary and Foreign keys and Constraints)
• Worked on application database design (Logical &Physical) by applying Normalization techniques and understanding relational database concepts such as indexes, primary and foreign keys and constraints. Developed Schema scripts (Table, Indexes, views, sequences, primary and foreign keys, constraints) to deploy them into DEV, QA and PORD environments with the proper storage parameters and standards.
• Extensively developed Oracle stored packages, procedures, functions and database triggers using PL/SQL11/10 for ETL process, data handling, logging, archiving and to perform Oracle back-end validations for batch processes.
• Extensively used dynamic SQL to perform DDL operations within Oracle stored packages and procedures and responsible for optimizing and troubleshooting the SQL code.
• Extensively used SQL*Loader to load data into Oracle databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables.
• Implemented Oracle11g/10g Fine Grained Access Control (FGAC) feature to allow for easier application development and row level security.
• Enabled Oracle11g/10g Advanced Security Option to protect sensitive data in Transit or At Rest by combining network encryption, database encryption and strong authentication.
• Implemented system security at database and application level by creating roles, profiles, views, grants and application users with limited privileges.
• Extensively used Oracle tools like Oracle Enterprise Manager, TOAD, SQL*Plus for database PLSQL code development and performance monitoring.
• Scheduling the DBMS Jobs for periodic execution of PL/SQL code.
• Writing Shell scripts to automate the daily processes using Control - M job.
• Providing necessary Oracle backend support to development teams in the areas of debugging stored procedures, DB triggers.
• Extensive experience in SQL optimization, performance tuning, Oracle AWR/ADDM configuration to collect the database statistics and for evaluating, Analyzing database schemas for collecting latest statistics for COST based optimizer.
• Extensive experience in writing UNIX shell scripts using Unix Vi utility for Oracle ETL process, batch processes, Oracle Server Hot Backups, Analyzing database schemas to collect latest statistics, cleaning-up log files to reclaim the disk space on IBM AIX-Unix/Linux environment.
• Developed application technical design documents and user guides for training.

Environment: Oracle 11G/10G(SQL*Plus, SQL*Loader, EXP/IMP, DATAPUMP), MS-Access2010/2008, TOAD, SQL-Developer, ANSI SQL, PL/SQL11.0/10.0, Control M, Sub Version, ITSM

Confidential, Dublin, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Responsible for technical architectures, analysis, design, development, test and implementation on production.
• Responsible for designing and interpreting application logical & physical database models by applying Normalization techniques and understating relational database concepts such as indexes, primary and foreign keys, and constraints. Developed schema objects scripts(Tables, Indexes, Views, Sequences, Primary and Foreign Keys and Constraints) to deploy them into Oracle10g/9i DEV/QA/PROD databases.
• Developed schema scripts to create database objects (Tables, Indexes, Views, Sequences, Primary and Foreign keys and Constraints) .
• Extensively developed Oracle stored packages, functions and procedures for building ETL process to map the data between source system (Legacy) and target database using Oracle PL/SQL 10.0/9.0 code.
• Extensively developed Oracle stored packages, procedures, functions and database triggers using ANSI SQL, PL/SQL to perform Oracle back-end validations, for data migration.
• Extensively developed, maintained and monitored automated routines on daily basis to perform data updates on the warehouse database from the real time production systems using Unix Shell scripts, ANSI SQL and PL/SQL packages.
• Extensively used dynamic SQL to perform DDL operations within Oracle stored packages and procedures and responsible for code optimization and troubleshooting.
• Performance monitoring, Database Tuning and Capacity planning on the production databases.
• Extensively used tools like Oracle10g Enterprise Manager, SQL Developer, and TOAD for Performance monitoring and PL/SQL code development.
• Extensively used Explain Plan, TK-PROF Oracle utilities to troubleshoot the poorly performed SQL queries on QA and Production environments.
• Extensively used SQL*Loader to load data from the Legacy systems into CBG Oracle databases using control files and used Oracle External Tables feature to read the data from flat files into Oracle staging tables.
• Providing necessary Oracle backend support to development teams in the areas of debugging stored procedures, DB triggers.
• Extensive experience in SQL optimization, performance tuning, Oracle STAT pack configuration to collect the database statistics and for evaluating, Analyzing database schemas for collecting latest statistics for COST based optimizer.
• Developed user training material and provided user training.

Environment: Windows XP, Teradata, OBIEE, Oracle 11g, PL/SQL, Teradata SQL Assistance, TOAD, SQL Developer and Shell Scripting,.

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for designing and interpreting system physical database model by applying Normalization techniques and understating relational database concepts such as indexes, primary and foreign keys, and constraints.
• Developed schema objects scripts(Tables, Indexes, Views, Sequences, Primary and Foreign Keys and Constraints) to deploy them into Oracle10g DEV/QA/PROD databases
• Extensively used dynamic SQL to perform DDL operations within Oracle stored packages and procedures and responsible for code optimization and troubleshooting.
• Implemented various constructs relating to packaged collections and Object type references in PL/SQL. Created packaged references and Packaged Cursors to implement business logic.
• Developed new Oracle forms and enhanced the existing Oracle forms as per the business changes.
• Developed functionality for handling online forms for customer’s home equity and direct loans.
• Technical Point of Contact and Technical Support Contact for all business user groups.
• Onsite coordinator for the offshore team.
• Involved in providing technical support to business user groups, writing and running scripts to automatically handle certain situations.
• Handled merging of loans functionality of some restricted business scenarios.
• Involved in Data analysis and Code Reviews.

Environment: Oracle 9i/8i (SQL*Plus, SQL*Loader, EXP/IMP, EXPLAIN PLAN, STATS Pack), TOAD, PL/SQL9.0/8.0 and Shell Scripting.