SUMMARY
Over 15 years of experience in analysis, design, development, implementation and testing of software solutions on Oracle 11g/10g/9i/8i/ 8.0/7.x Database with Windows/UNIX and Client-Server and data warehousing environments

Backend: Oracle 11g/10g/9i/8i/7.x/6.0 Database Enterprise Edition, Oracle 10g/ 9i Application Server
DW/Business Intelligence: Oracle Discoverer 10g/9i/4i/3.0, currently undergoing training on OBIEE
Data Modeling: Erwin ERX/4.0 CASE Tool
ETL Tools: Trained on Informatica Power Center 8.6/7.1.
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

Confidential, Feb 2012 to Sep 2012 Union, NJ
PLSQL Developer
PIM Support System

• 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, SQL Developer, AIX

Confidential, Nov 2010 to Oct 2011 Irving, TX
Senior Database Developer
DNS Marketing Data Warehouse Decision Support System

• 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, SQL Developer, Unix K-Shell Scripting, AIX, TextPad, MS-Office 2007

Confidential, Feb 2010 to Nov 2010 Montvale ,NJ
Senior Oracle Developer
RETEK RMS Retail Pricing and Stock Ledger Legacy System

• 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
• Used Advanced SQL and PLSQL tuning using TKPROF, EXPLAIN PLAN for better performance, used hints like ORDERED,DRIVING_SITE,APPEND,DYNAMIC_SAMPLING etc
• 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
• 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, Oct 2007 to Jan 2010: Brooklyn, NY
Senior Oracle Developer
EPIS Employee Payroll Information System and DW

• 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 a very large multi terabyte VLDB
• Maintaining data model of a data warehouse system using ER Studio
• Also implemented Star schema and maintained data model of a 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
• Produced test cases for quality assurance tests for the functionalities implemented or have been fixed and also documented
• 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, PLSQL Developer, Unix K-Shell Scripting, TOAD 9.0, Solaris, ER Studio, Win XP Professional, TextPad, MS-Office 2000

Confidential, Feb 2007 to Sep 2007: New York, NY
Senior Oracle Database and ETL Developer
Fee Negotiation System FNX

• Writing numerous stored procedures, packages, overloaded functions, object types following PLSQL standards on a 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 a 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, Apr 2006 to Jan 2007: New York, NY
Senior Oracle Developer
Time Keeping System

• 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, October 2005 to March 2006: New York, NY
Senior Oracle Developer
Purchase order Management POM Manifest Project

• 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, LAG,
  RANK, 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, June 2004 to October 2005: Garden City, NY
Senior Oracle Developer
CMS Catalog Management System

• 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, January 2004 to March 2004: New York, NY
Senior Oracle Developer
Digital Asset Management System

• 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, March 2003 to November 2003:Yonkers, NY
Oracle Consultant
Global Card Calling System

• 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, April 2002 to March 2003: Harrisburg, PA
Oracle Consultant
CURAM Referential Model's Prototype for Health and Human Services Industry

• 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 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, KSA, December 1997 to March 2001: Jeddah, K.S.A
System/Analyst
In-House Business Management System

• 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, OracleDeveloper/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, June 1996 to September 1997: Hyderabad, India
Programmer/Analyst
Hospital Management System

• 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

• Bachelor of Computer Engineering.