PROFESSIONAL SUMMARY:

• For more than 15+ years worked on most of the versions of Oracle database 11g to ver 6.0, architecture, database design and concepts, system tables usage and PLSQL programming for retail, healthcare domain and government agencies.
• Worked extensively on SQL Tuning, PLSQL code performance and optimization using TKprof, EXPLAIN Plans, Table Partitions, Materialized Views, Index mechanisms, Dynamic SQL tuning, effective usage of data collections.
• Advanced level of PLSQL error handling mechanisms and very detail level of error tracking by data registering at detail level and debugging.
• Implemented user data row level security RLS policies on tables as VPD’s.
• XML for data exchange from front end to backend for data editing, retrieval and storage. Requests from front end application received in XML format then breaking down by extracting attributes data like XMLAGG, XMLElement, XMLQuery etc and saving them in the tables.
• Involved and used Erwin ERX/4.0 CASE Tool as data modeling tool at developer level for reverse engineering database schema, creating subject area Entity relationships as data marts and making enhancements to ER diagrams and executing them on database.
• Worked on multiple Data Warehouse/Operational DataSource projects, data loads from flat files using SQL Loader initiated from Korn shell scripts. Good understanding of OLAP Vs OLTP design, maintaining Data Quality, Data Scrubbing on very large databases VLDB’s.
• Good understanding and implemented ETL concepts using plsql code. Extracting data from External Tables into Staging tables, messaging and transforming data and loading into target schema tables.
• Build Business Intelligence Reports using Oracle Discoverer 10g and lower versions 9i/4i/3.0.
• Build customization of Oracle RETEK forms using Oracle Developer Suite 10g, FORMS Builder 10g and REPORTS Builder 10g for report generation.
• Handled automation of job scheduling of Ksh and SQL scripts through IBM Tivoli job scheduler.
• Documented technical code, followed company standards, used third party tools for version controlling like PVCS, Seapine’s SURROUND SCM etc, PLSQL Developer and TOAD for code editing and development.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

PLSQL Developer

Responsibilities:

• Created and maintained numerous stored procedures packages, functions, packages to build business logic 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 using 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:

• Application build from scratch, adopted SCRUM approach for software build. Participated in architect design level project development.
• 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 that 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, IBM Tivoli, 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 architect technical solution design to in corporate business logic and rules in the form of PLSQL codes like 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 that 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 that 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, Oracle Forms 9i and Reports 9i, 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
• Application conversion and upgrade that involved Oracle forms/reports, stored procedures, table structures etc from version 8i to 9i.
• 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 Online Analytical Processing reporting using Oracle Discoverer on data warehousing database
• 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, OLAP reporting using 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 that 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

Confidential

System/Analyst

Responsibilities:

• Primary responsibilities include preparing Data Flow Diagram, Process Model, Data Model & working prototype along with other members of team.
• Database Design done using Erwin ERX/3.5 as Case Tools
• Used Features of Autonomous Transactions, Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic cursors (DBMS Packages and Native Dynamic)
• Maintaining database security, enrolling users, backup and restoring the databases, maintaining archived data on tape, allocating system storage planning, future storage requirements for the database system and optimizing Oracle 8.1 database too
• Implementing Database triggers, Stored Procedures, Functions, and Packages as required
• Designed and developed various complex Forms, Menus, Reports, Graphics & PL/SQL libraries
• Created and maintained Oracle Database objects using oracle designer
• Developed Oracle Reports in both character & bitmap mode
• Involved in developing Matrix Reports Using Oracle Reports

Environment: Oracle 8i/8.3 DB, Oracle Developer/2000 (Forms 6i/5.0, Reports 6i/3.0, Graphics (6i/3.0), Oracle Designer 6i, PL/SQL 8.0, TOAD 5.0, Erwin ERX 3.5, Win NT 4.0, HP UNIX, Win XP/98, MS Office 2000

Confidential

Programmer/Analyst

Responsibilities:

• Responsible for system study & information gathering for implementing various modules of the hospital management system which are Reception section, Patient In, Patient Out Block Modules, Diagnostic module, Patient & Staff record entries, statistical information forms for forecasting and finally Billing Modules
• Development was done using front end as Oracle Developer/2000
• Involved in creation of Tables using storage parameters and clusters
• Involved in writing Database procedures, Functions, Packages and Database Triggers
• Coded many generic routines like functions, which could be called from other procedures
• Developed user interface screens, Master detail relations and Report screens
• Front end coding and Creating LOV’s, Record groups, Libraries and menus
• Involved in integration testing

Environment: Oracle 7.3/7.1, Oracle Developer/2000 (Forms 4.0, Reports 2.0), PL/SQL 2.1/2.3, Win 95/NT, MS-Office