SUMMARY

• For the last decade working on analysis, design, application development, implementation, testing and maintenance of software solutions on Oracle Databases with Windows/UNIX and Client - Server and data warehousing environments

TECHNICAL SKILLS

Backend: Oracle 11g/10g/9i/8i/7.x/6.0 Database Enterprise Edition, Oracle 10g/ 9i Application Server

Business Intelligence: Oracle Discoverer 10g/9i/4i/3.0

Data Modeling: Erwin ERX/4.0 CASE Tool

DW-Data Warehouse: Good understanding of Data Warehouse Concepts, OLAP Vs OLTP design and Implementation of DW databases, Report writing and SQL Tuning, maintaining Data Quality, Data Scrubbing on very large databases VLDB’s.

ETL: Good understanding of ETL concepts using plsql, Trained on Informatica Power Center 9.5/8.6.

Programming: ORACLE PLSQL 11g/10g/9i/8.0/2.3/2.1, UNIX K-Shell Scripting, AWK, SED, HTML, XML

Front End: Oracle Developer Suite 10g/9i/2000, FORMS Builder 10g/9i/6i/5.0/4.5/3.0 REPORTS Builder 10g/9i/6i/3.0/2.5, Graphics 6i/3.0/2.5, CURAM 2.0/1.5 and Software Framework

Version Control: PVCS (Standard and web based), Seapine’s SURROUND SCM, MS Visual Source Safe

Third Party Tools: TOAD 8.6/7.5/7.0, PLSQL Developer 7.0, Exceed 10, Humming Bird, Workflows, Citrix, PC Anywhere, MS-Office 2007/2000, Lotus Notes, IBM Tivoli

Operating System: Windows Vista/XP/2003/2000/NT, HP UNIX 11.0 Server, AIX 5.1, Solaris 8.0/10

PROFESSIONAL EXPERIENCE

Confidential, NJ

PLSQL Developer

Responsibilities:

• Created and maintained numerous stored procedures packages, functions, packages and wrote new PLSQL standards
• In depth SQL tuning using TKPROF, EXPLAIN PLAN
• Optimizing PLSQL Code by using BULK BINDS, BULK COLLECTS, dynamic SQL’s,
• Data loading using SQLLOADER from flat files and also used external tables
• Performance and tuning of SQL and PLSQL code SQL trace, explain plan
• Report generation using data Warehousing SQL functions, aggregation functions and analytical

functions like RANK, DENSE RANK, ROW NUMBER etc

Environment: Oracle 11g/10g database, PLSQL, SQL Developer, AIX

Confidential, Irving, TX

Senior Database Developer

Responsibilities:

• Business Logic conversion and data extraction and transformation logic implementation in PLSQL code in the form of Packages, stored procedures and functions
• Data loading using SQLLOADER from flat files and also used external tables
• Daily monitoring of job runs, used IBM Tivoli for Job Scheduling and all the scripts written in shell programs dat perform database activities
• Maintaining existing and building Adhoc reports on demand
• In depth performance and tuning of SQL and PLSQL code using TKprof, SQL trace, explain plan
• Optimized PLSQL code using pipelined table functions for certain very large running reports, used enhanced features of materialized views, refreshing mechanism
• Writing stored functions to email from the database and also from the shell scripts, dumping data to excel spread sheet from customized stored procedures

Environment: Oracle 11g database in RAC environment, SQL Developer, Unix K-Shell Scripting, AIX, TextPad, MS-Office 2007

Confidential, Montvale, NJ

Senior Oracle Developer

Responsibilities:

• Heavy PLSQL coding development involvement to build new and maintain existing stored procedures and packages to accommodate business logic of retail industry
• Heavy shell scripting to run and execute batch reports and store procedure executions
• Used Retek Merchandise System (RMS) tables, Retail Pricing and Stock Ledger for retail price changes and feeding to stock ledger to update the inventory
• In depth optimizing current PLSQL Code using PLSQL Code with Collections, using Hints, bitmap indexes, REF Cursors, NOCOPY compiler directive, dynamic SQL’s, Nested Cursors or Cursor Expressions, PLSQL tables, use of Table Functions, VARRAY
• Used Advanced SQL and PLSQL tuning using TKPROF, EXPLAIN PLAN for better performance, used hints like ORDERED,DRIVING SITE,APPEND,DYNAMIC SAMPLING etc
• Optimizing table very large table partitions to create the right indexes like Local indexes or Global partition or Global non partition indexes
• Used in depth materialized views, refreshing mechanisms of dependable mv for fast refresh

Environment: Oracle 10g database, PLSQL Developer 8.0, Unix K-Shell Scripting, JSP, HTML, RETEK 10, TOAD 9.6, AIX

Confidential, Brooklyn, NY

Senior Oracle Developer

Responsibilities:

• Conversion of Legacy systems COBOL programs used for calculation of employee pensions and biweekly payroll and to PLSQL codes for the business rules in the form of stored procedures, packages, overloaded functions, object types following on Confidential very large multi terabyte VLDB
• Maintaining data model of Confidential data warehouse system using ER Studio
• Also implemented Star schema and maintained data model of Confidential data warehouse system using ER Studio for analyzing numerous reports for overtime salary calculations, budget analysis
• Used in depth materialized views, refreshing mechanisms of dependable materialized for fast refresh etc in DW database
• Optimizing PLSQL Code by using BULK BINDS, BULK COLLECTS, Object TYPES, dynamic SQL’s, pinning frequently used packages, functions into SGA etc
• Optimizing table partitions, global partitioned and global non partition indexes, materialized views( Includes Dependable materialized views as well)
• Loading data from flat files with SQL Loader through k-shell scripts
• All SQL scripts dat calls oracle package functions, procedures initiated through K-Shell scripts
• Complete ETL procedures from Staging Area, Transforming data and loading finally to production database were written and maintained in Unix K-Shell scripts
• Handled production support job by analyzing any production issues when new applicants appear for online fire fighter exams and provided prompt resolutions

Environment: Oracle 10g database in RAC environment, PLSQL Developer, Unix K-Shell Scripting, TOAD 9.0, Solaris, ER Studio, Win XP Professional, TextPad, MS-Office 2000

Confidential, New York, NY

Senior Oracle Database and ETL Developer

Responsibilities:

• Writing numerous stored procedures, packages, overloaded functions, object types following PLSQL standards on Confidential very large database dat generates negotiated dollar numbers for every medical procedure, for every state provided by providers(hospitals, doctors) automatically from end to end(from the point Confidential claim from clients enters the system to the point where final dollar numbers are generated and faxed to the providers.)
• Extensive usage of partitions, move, alter partitions (range, hash, list etc). created sub partitions
• Created XML based queries and data structures, used materialized views, Global temp tables and some data modeling using ER Studio
• SQL tuning using TKPROF, EXPLAIN PLAN
• Some DBA responsibilities like job scheduling using DBMS SCHEDULER, gathering of table and schema level statistics, analyzing indexes, pinging cursors, packages into SGA for improving performance using DBMS SHARED POOL oracle package, generating TKPROF file at server side
• In depth optimizing current PLSQL Code using PLSQL Code with Collections, using Hints, bitmap indexes, REF Cursors, dynamic SQL’s, PLSQL tables, use of Table Functions, VARRAY
• Used PRAGMA compiler directives like EXCEPTION INIT, AUTOMOUS TRANSACTION, SERIALLY RESUABLE, RESTRICT REFERENCES where ever required
• Loading data from flat files with SQL Loader and writing k-shell scripts
• Written autonomous triggers and have handled mutation triggers issues
• Fine tuned the performance of ETL processes

Environment: Oracle10g Database, PLSQL Developer, TOAD 8.6, Seapine’s Surround SCM, Win XP, MS-Office 2000

Confidential, New York, NY

Senior Oracle Developer

Responsibilities:

• Created and maintained numerous stored procedures packages, functions, packages and wrote new PLSQL standards
• Optimized slow running reports using blocks based on stored procedures
• In depth SQL tuning using TKPROF, EXPLAIN PLAN
• Optimizing PLSQL Code by using BULK BINDS, BULK COLLECTS, dynamic SQL’s, PLSQL tables, use of NOCOPY, REF Cursors, Table Functions, FORALL statements, pinning frequently used procedures and functions into SGA
• Loading data from flat files with SQL Loader and writing k-shell scripts
• Written autonomous triggers and have handled mutation triggers issues
• Extensive usage of Global Temp tables, materialized views, dynamic queries, dynamic reports generation, Record Groups, Object and .pll libraries, object inheritance in Oracle reports

Environment: Oracle 10g Database, PLSQL Developer, TOAD 8.6, UNIX (AIX) Shell Scripting, Win XP, MS-Office 2000

Confidential, New York, NY

Senior Oracle Developer

Responsibilities:

• Utilized PL/SQL to call Oracle stored procedures, packages etc
• Wrote batch job scheduling scripts and handling all kind errors (returning SQL error codes
• From SQL to Korn Shell Script etc) and sending emails to support group within the script
• Wrote SQL Loader scripts to load data into database and generating reports using data Warehousing SQL functions, aggregation functions and analytical functions like LEAD, LAGRANK, DENSE RANK, ROW NUMBER etc
• Query optimization using EXPLAIN PLANS, TKPROF, optimized partitions, used extensively collections and bind variables etc
• Used TOAD 8.6 for building Stored Packages, Materialized views, Procedures, Functions and Database Triggers, scheduling database Jobs

Environment: Oracle 9i Database, PLSQL Developer, AIX 5.1 (UNIX), K-Shell scripting, TOAD 8.6, Exceed 10, Win 2000

Confidential, Garden City, NY

Senior Oracle Developer

Responsibilities:

• Extensive PLSQL coding and optimizing SQL and PLSQL code using bulk collects, bulk binds, PLSQL tables, global temp tables, writing overloaded procedures and functions
• Worked on ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets
• Designed all front end screens using advanced features of Forms 9i
• Created Object Libraries .obj’s, .pll’s
• Created dynamic and static reports using Reports 9i and Oracle Discoverer on data warehousing database of star schema designing and data marts
• Created menus to be used throughout the project modules for uniformity
• Used TOAD for building Stored Packages, Procedures, Functions and Database Triggers, Jobs

Environment: Oracle 9i Database, Oracle Discoverer 9i, Oracle 9i Application Server, Developer Suite (Oracle 9i Forms and 9i Reports), Lotus Notes, TOAD 7.5, PVCS, Win 2000, Solaris 7.0, MS-Office 2000

Confidential, New York, NY

Senior Oracle Developer

Responsibilities:

• Designed all front end screens with Forms 9i using advanced features of hierarchical tress, REF cursors to implement interface forms dat is used to enhance A2A State Standards for publishing different standard subject books
• Creating dynamic reports by passing lexical parameters from Forms to Reports with different formats in HTML, PDF, CSV, EXCEL etc
• Created Object Libraries, .pll’s to be used in forms where required
• Created Template Forms to be used throughout the project modules for uniformity and Standard Menus for all the Forms created
• Generating Stored Packages, Procedures, Functions and Database Triggers as required for the developers
• Software Testing and Documentation

Environment: Oracle 9i Database Enterprise Edition, Oracle 9i Application Server, Internet Developer Suite (Oracle 9i Forms and 9i Reports), ER Studio, TOAD 7.5, Win 2000 Professional Server, MS-Office 2000

Confidential, Yonkers, NY

Oracle Consultant

Responsibilities:

• Setting up the environment of development for developers
• Creating required Forms for user registration, card tracking, activation, deactivation inventory modules etc and deployed on the web
• Created Object Libraries to be used in forms where required
• Created Template Forms to be used throughout the project modules for uniformity and Standard Menus for all the Forms created
• Complex Forms with multiple master details relations involving object types and blobs data type elements and using the navigational tree items
• Created object libraries, pl/sql libraries .pll’s used throughout the forms
• Generating Stored Packages, Procedures, Functions and Database Triggers as required
• Build complex multi view and matrix reports using Reports 9i
• Responsible for System Analysis and QA

Environment: Oracle 9i Database Enterprise Edition, Oracle 9i Application Server, Internet Developer Suite (Oracle 9i Forms and 9i Reports), Erwin ERX 3.5, TOAD 7.5, Erwin ERX 3.5,Win 2000 Professional Server

Confidential, Harrisburg, PA

Oracle Consultant

Responsibilities:

• Installing and configuring of Oracle 8i Database
• Upgrading to 9i database
• Implementing Stored Packages, Procedures, Functions and Database Triggers
• Extensively involved in writing SQL queries, PL/SQL programming and Query Level Performance tuning
• Analysis of the Referential Data model for the prototype development
• Creating Production CURAM Database in Oracle 8i
• Database Management involving all database activities like installation, setting up the client server environment, data backup & recovery
• Installing patches whenever as required

Environment: Oracle 9i/8i Database, PL/SQL 8.0, TOAD 7.0, Erwin ERX 3.5, IBM Visual Age for Java 4.0, CURAM Application Server, XML, MS Visual Source Safe, Win 2000 Server, MS-Office 2000