SUMMARY

• Thirteen years of IT experience as Development DBA Sr. Oracle PLSQL/ETL developer in diverse fields - Financial Messaging, Mortgage, Online stock trading, and Electricity trading
• Oracle Certified Professional OCP in SQL, PL/SQL, Forms Reports
• Expertise in Relational Database Modeling techniques for Transactional processing environments, Star/Snow Schema modeling techniques for Data warehouse environments
• Proficiency in Oracle Performance features such as AWR reports, Explain Plans, SQL Traces, SQL Baselines, Tuning Sets, Parallel Query Processing, and HINTS
• Expertise in advanced SQL, PL/SQL programming techniques including SQL Analytical functions, Ref Cursors, Bulk Collect/Binds, Pipelined Functions, Global Temp Tables GTT , BLOBs, Packages and Triggers
• Proficiency in using advanced database structures like Table Range/Hash/List partitioning, sub-partitioning, Indexes, Materialized Views, Transportable Table spaces, External Tables
• Hands-on experience in Oracle Streams Replication Setup and Active Data Guard Replication
• Experienced in RDBMS Tools like SQL Loader, DataPump Export/Import
• Proficiency in ETL development using PL/SQL, Perl Scripting, Informatica Power Center
• Experienced in Perl scripting for job automation - Data extractions, Database maintenance activities
• Experienced in Shell Scripting - invoke SQL scripts for automating Database administrative tasks including Database Statistics gathering, Schema Migration/Fallback
• Expertise in automating PLSQL Unit testing, Functional testing using UT PLSQL
• Proficient in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance
• Five years experience as technical lead, mentoring small teams of developers and testers
• A Self-starter with positive attitude, eagerness to work with new tools/technologies and accept challenges
• Excellent leadership, problem solving, analytical and time-management skills

TECHNICAL SKILLS

• Databases Oracle 11g/10g/9i
• Data Modeling Tool Erwin 4.0/3.5, Oracle Designer, Microsoft Visio
• ETL Tool Informatica PowerCenter 7.x, Abinitio
• Languages PL/SQL, UT PL/SQL, SQL, Shell Scripting, Perl
• Database Tools SQL Loader, TOAD, PL/SQL Developer
• Reporting Tools Oracle Reports 9i/6i, Crystal Report Writer, Excel
• Front End Tools Oracle Forms 9i/6i, Microsoft .NET IDE
• Operating Systems HP-UNIX, Microsoft Windows Server 2003/2008
• Version Control Rational Clear Case, Clear Quest, MS Visual SourceSafe, PVCS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Development DBA

Responsibilities:

• Developed several PL/SQL Packages and optimized using techniques like partitioning of tables, Local Indexes, Bulk Collect/Update, Pipelined functions
• Participated in code reviews ensuring solutions are aligned with pre-defined architectural specifications identify/troubleshoot application code-related issues and provide feedback to the team
• Developed Perl Scripts to automate Daily Partition Management activities such as Adding daily partitions, Marking Archived Partitions/Tablespaces as Read-Only and Dropping expired partitions/tablespaces
• Automated PLSQL unit testing, Component testing using UT PLSQL
• Developed Perl scripts to automate the Daily Data Extraction into flat files
• Developed Perl script to monitor bad SQL Execution plans and Plan switches using Oracle In memory objects SQL PLAN, SQL AREA and also from AWR History
• Developed PL/SQL based data conversion scripts to rollover data from old to new tables. Used standard packages like UTL FILE, DBMS LOB for conversion
• Performance tuned existing PL/SQL stored procedures and SQL queries using AWR Reports, and Explain Plan. Worked on Plan stabilization using SQL Baselines and Hints
• Regression Tested Oracle 11.2.0.4 upgrade for Streams Replication Active Data Guard environments
• Developed UNIX Shell Scripts to automate Ongoing Database Release Management by developing Migration and Fallback procedures
• Functional Testing for RMAN Backup and Recovery process
• Developed SQL Shell scripts to cold start an application database by setting up Users, Roles, Tablespaces, Profiles, Directories and various schema objects like Advanced Queues, Tables, Views, Indexes, Constraints, Triggers, Packages, Procedures, functions, sequences
• Performance Tested New Code module by measuring the CPU/IO/Memory utilization using OS tools like GLANCE. Fine tuned SQL/PLSQL code by reviewing captured Plans from AWR Repository

Environment: Oracle 11g, SQL, PL/SQL, UT PLSQL, Oracle Streams, Active Data Guard, Perl, UNIX Shell Scripting, Exceed, TOAD, Rational Clear Case Clear Quest

Confidential

Sr. Oracle PLSQL/ETL Developer

Responsibilities

• Performed POC for enabling Oracle Total Recall Audit Log to provide the historical query/flashback capability. This feature replaced the existing Trigger based Log tables for audit
• Developed PL/SQL based data conversion scripts to rollover the existing data into new tables
• Automated unit testing, Component testing using UT PLSQL
• Investigated performance issues in PLSQL stored procedures and SQL queries using Oracle features AWR reports, Explain Plans. Enhanced the efficiency of the queries by making use of Oracle Parallel processing, Oracle Resource management features
• Developed High Level Detailed Design Documents, Unit and Functional Test cases
• Developed PL/SQL Batch processes and optimized them using partitioning of Tables, Indexes, IOT's, global temporary tables, pipelined functions, parallel execution queries
• Performed Database Administration tasks such as setting up users/roles/table spaces/Tables/indexes/sequence/packages. Periodic refreshing of Dev/Test environments from production
• Created Summary Materialized views to speed up the performance of batch jobs
• Developed PLSQL based ETL batch jobs that aggregate detailed data into Monthly summaries
• Developed Abinitio ETL process to generate flat data files
• Performed extensive data analysis on Loan/MBS Bonds data to identify data discrepancies

Environment: Oracle 11g/10g, SQL, PL/SQL, UT PLSQL, UNIX Shell Scripting, Abinitio, Autosys, TOAD, SQL Loader, IBM Rational Clear Case Clear Quest

Confidential

Sr. Oracle Developer Jan 2005 Jan 2007

Responsibilities

• Technical Lead for small teams of developers and testers on medium size projects
• Created detailed technical specifications and Relational data model
• Developed new interfaces with external market data providers using .NET web services
• Developed/Enhanced Oracle PL/SQL Packages
• Performed Release management of the projects into TEST, UAT and Production environments
• Performance tuned legacy system SQL / PLSQL and Schema design for critical batch processes
• Developed a custom enqueue/dequeue system to asynchronously and optionally calculate the effect of external market changes

Environment: PL/SQL, SQL Loader, TOAD, Oracle 9i, .NET Web Services, ADO.NET

Confidential

Oracle Technical Consultant

Responsibilities

• Technical liaison for the client in requirement gathering
• Developed Logical and Physical data models using Erwin4.0
• Enforced referential integrity by adding Foreign/Unique/Primary Key's
• Developed PL/SQL packages, database triggers

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL Loader, ERWIN

Confidential

Oracle Developer

Responsibilities

• Developed PLSQL packages, Triggers, Oracle forms and oracle Reports
• Developed web pages using Java Server Pages JSP's /Servlets, struts 1.1 web frame work
• Upgraded Oracle Forms6.0 Reports6.0 based stockhighway back office application to Oracle 9i developer release

Environment: Java J2EE , JSP, Struts Frame Work, JDBC, Oracle 9iAS, PL/SQL, JBOSS, Tomcat, Apache, Oracle Forms 9i, Oracle Reports 9i, Oracle Designer, TOAD