PROFILE

• 7 years of professional experience in RDBMS and PL/SQL Involved in all phases of the SDLC Software Development Life Cycle from planning, analysis, design, development, testing, implementation maintenance with timely delivery against aggressive deadlines
• Designed logical and physical data models for star and snowflake schemas using Erwin. Proficient in developing Databases, and handling performance issues running long or having significant CPU consuming jobs Proficient in advance features of PL/SQL programming like using Bulk Collections, Ref.
• Cursors, Nested tables and Dynamic SQL Experience writing complex SQL queries and creating views to hide underlying tables Fine - tuned procedures/SQL queries for maximum efficiency in various databases Wrote shell scripts to automate database maintenance and create DDL/DML and data loader scripts Proficient in system performance monitoring using tool such as autotrace, explain plan, tkprof, SQL Session monitoring, and dbms xplan.display Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and recover database utilities Database migration experience from Oracle to DB2 and DB2 to Oracle Database and SQL statement access plan optimization experience Database backup and recovery experience with online full and incremental backups,
• nline and offline transaction log archiving, restore and rollforward including redirected restore, and recover database utilities Job and script scheduling experience using dbms, crontabs, AutoSys, and Control-M job schedulers Database analysis, design, and reverse-engineering experience using Power Designer
• Data Architect, ERwin, and SQL Developer Extensive experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alert notification, and reporting using the DB2 utilities and Command Line Processor CLP with the Windows Shell and Control-M job scheduler Involved in short term consulting assignments for capacity planning load testing Worked with different clients in various capacities in different domains

Confidential

Role: Sr. Oracle PL/SQL Developer

Confidneital is the 3rd largest telecommunications corporation in the world. I was part of the development and production support team for the financial systems specifically the ADRM Alliance Data Relationship Management team. Along with development and administration activities, I played a major role in enhancing and tuning their existing PL/SQL packages and provided several automated solutions.

Responsibilities:

• Developed new PL/SQL packages and database objects. Responsible for the design, development, and administration of Oracle 11g. Enhanced existing packages with the use of bulk collections, functions, and several other mechanisms which were tested and proven to benefit the existing systems. Created objects such as tables, indexes, primary keys, foreign keys, sequences, PL/SQL triggers and stored procedures. Automated the construction of web JSP pages by the use of PL/SQL procedures and functions. Provided data de-duplication and cleansing solutions. Enhanced existing exception handling with the use of new exception handlers down to every DML for better debugging and logging practices. Provided weekly on-call production support. Provided CPU statistics for production systems and provided solutions for any unexpected delays in processing of existing packages. Delivered tasks on time without compromising quality of work.

Confidential

Role: Sr. PL/SQL Database Developer

• Confidential is the world's first and largest specialized staffing services firm. Confidential staffing divisions place highly skilled professionals on a temporary, temporary-to-hire and full-time basis in the accounting and finance technology office administration legal and creative, marketing and design fields. I was a key part of the data migration project as the PL/SQL Database developer. The purpose of the project was to migrate flat-file based data of 16 countries from legacy systems into relational databases.
• Responsibilities: Primary database and PL/SQL resource for the legacy systems data migration team. Responsible for the design development of new Oracle and DB2 databases with a total of 14 schemas in Oracle and 2 schemas in Db2. Assisted with logical modelling and created the physical model using ERwin Data
• Modeler. Created objects such as tables, indexes, primary keys, foreign keys, sequences, PL/SQL triggers, and PL/SQL stored procedures. Worked on SQL Loader to load data from flat files obtained from various facilities. Provided data de-duplication and cleansing automation solutions. Wrote complex stored procedures to fetch data from different tables in local and remote databases using joins, sub queries, and database links. Leveraged the usage of dynamic sql in several stored procedures. Used for loops and cursors for row-by-row processing of records. Automated many DDL DML requests by automatically building a script. Implemented auditing procedures for database tables. Wrote and scheduled daily database table level backup scripts. Provided performance tuning for database and PL/SQL procedures. Converted DB2 9.7 LUW databases to Oracle 11g. Supported application teams and delivered requirements with optimal CPU performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures. Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures. Fulfilled all business requirements promptly with quality assurance and met all critical deadlines.

Confidential

Role: PL/SQL Database Developer

Confidential, also known as Amex, is an Confidential services corporation headquartered in Manhattan's Three World Financial Center in New York City, United States. I was a key part of two teams - the database infrastructure and database migration teams. The database infrastructure team was responsible for all of Confidential 's online card account applications. For the infrastructure team I assisted with numerous development, support, and change management tasks. The data migration project was for an internal AmEx tool helpful in monitoring all server statistics within our platform wherein I lead the database pl/sql migration from Oracle 11g to DB2 9.7 on AIX.

Responsibilities:

• Delivered Oracle 11g to DB2 v9.7 LUW migration solutions through all SDLC phases for a leading Fortune 500 credit card company. Initial responsibilities were to support database development for use by applications, write ETL stored procedures, and provide database solutions for optimal efficiency of CPU resources. Provided precise change management instructions to implement production changes and new databases. Migrated an OLTP database from Oracle to DB2 9.7 LUW which included 120 user tables and 66 ETL user-defined stored procedures. Worked nights to work with offshore application team for migration support. Created korn-shell scripts scheduled in Control-M to automate stored procedure calls.
• Jobs included a stored procedure to maintain table daily and weekly partitions, a script to export data from Oracle database using automatically generated SQL queries. Extensively supported test and production environments to monitor issues such as lock timeouts and provide resolutions. Tuned SQL's in stored procedures and redesigned database indexes to provide lower
• CPU cost quicker response times. Additional responsibilities included interviewing potential candidates for development and production environments and training new resources.

Confidential

Role: PL/SQL Database Specialist

Responsibilities:

• Involved in all phases of database development, from needs assessment to QA/QC, design, and support. Create new monitored old procedures and fixed data error conditions. Developed ETL procedures to convert flat-files into relational format. Worked extensively with triggers and sequences. Configured HADR disastor recovery for several databases with company standard procedures, implemented backup and recovery procedures of DB2 Oracle databases. Wrote shell scripts for automation of statistics gathering, index and table rebuilding, and other jobs. Performed database and SQL tuning and extensively used explain plans for analyzing. Created database maintenance procedures, scripted database jobs, and set up e-mail alerts to notify when a job ran unsuccessfully. Created test environments for the new databases and populated test databases with relevant data from various production files and databases. Along with many database related duties, my role as a technical resource also included providing guidance, advice, and training to new resources on the database and application teams.

Confidential

Role: Software Engineering Intern

Responsibilities:

• Went through many technical database and sql courses, concentrating on concepts and hands on training. Worked as a part of iQuadra's internship program on Oracle and DB2 databases. Installed operating systems such as Ubuntu, Linux, Unix, and Windows and installed DB2 v7 and v8 and Oracle 9i.
• Created several databases for in-house projects and took on many complex tasks which involved all areas of DB2/Oracle development and administration. Installed and developed objects in star snowflake database schemas, PL/SQL stored procedures, PL/SQL triggers, and KSH shell scripts for automation of jobs using database crontab scheduler. Wrote and set up database maintenance cron jobs such as runstats, reorg, and table db level backup. Coordinated with the management to discuss business needs and designed database solutions accordingly. Fully immersed into learning all concepts of database architecture design, pl/sql programming, and UNIX shell scripting.

TECHNICAL COURSES

RDBMS PL/SQL 20072009 Advanced Computer Science 20052006 C, C 20042005 Java 20032004