SUMMARY:

• Oracle Database Specialist with sixteen years of experience
• Working experience in large scale Oracle deployments with end to end SDLC
• Exposure working in Relational, Data Warehouse and ERP environments
• ETL, SQL and Shell Scripting experience
• Strong troubleshooting and proactive analytical skills
• Working exposure to various operating environments
• Excellent communication and coordination skills
• Strive to deliver assigned tasks and projects on time

TECHNICAL SKILLS:

Database Administration: ERP, Data Warehousing, ETL, Change Management, Systems Development Lifecycle (SDLC), Application Architecture, Enterprise Job Scheduling, System Integration and Automation, System Administration, Shell Scripting, Software Version Control OPERATING SYSTEMS Windows, Mac OSX, Linux, Solaris, AIX, Novell Netware

ENTERPRISE APPLICATIONS ORACLE:: Database 7.3, 8/8i, 9i, 10g, 11g, 12c, ORACLE Apps 11i, Cognos Enterprise BI, HP Project and Portfolio Management, Appworx (Now called Automatic), Serena PVCS, Symantec Netbackup, RMAN, ASM, RAC, Oracle Enterprise Manager

ENTERPRISE TOOLS: MS Office, MS Access, MS Visio, TOAD, Oracle SQL Developer, MKS Toolkit

LANGUAGES:: C/C++, SQL, PL/SQL, UNIX Shell Scripting

COURSES: Oracle 7 Database Administration, Oracle 7 Backup and Recovery Workshop, Oracle Database 11g Performance Tuning, Oracle Apps 11i Install, Patch and Maintain Oracle Applications, Oracle Apps 11i System Administrator Fundamentals, Sun Microsystems, UNIX Shell Programming for System Administrators, AMA, Information Technology Project Management

PROFESSIONAL EXPERIENCE:

Confidential, Randolph, NJ

Course Delivery Database

Environment: Microsoft Access, Microsoft Office, Windows Designed and developed a Microsoft Access database system for the department’s Course Delivery System.

Responsibilities:

• Understanding current working environment and gathering requirement specifications
• Building a process workflow
• Translating requirement specifications to confirm with the workflow
• Build Entities and Relationships based on data
• Build a database solution based on entities and normalize the tables
• Build Access Forms on top of the tables for Data Entry process
• Gather Reporting needs and build the appropriate interfaces
• Build Reporting interfaces to integrate Access through Microsoft Word
• Understand Reporting needs and build appropriate interfaces

Confidential, Roseland, NJ

Data Warehouse System Development and Maintenance

Environment: ORACLE Database 11g, IBM Cognos Enterprise BI, Enterprise Linux.

• Streamlining, organization and cleanup of development/production ORACLE schema objects migration
• To document and implement plans and standards for database code migrations between environments
• Proposed and implemented database code deployments by utilizing Version Control Software
• SQL scripts development to assist in database code deployments
• PL/SQL procedures development to assist in ETL data processing
• Query optimization by utilizing Star Transformations in conjunction with Bitmap Indexes
• Materialized Views Implementation
• Identification and tuning of top timing SQL statements by utilizing AWR Reports
• To plan and co - ordinate between onshore/offshore teams for database maintenance and code deployments

Confidential, NJ

Sr. Oracle Database Administrator

Environment: AS400, Oracle Applications 11i, Oracle Database 9i, Appworx, HP-PPM, Serena PVCS This project involved transition from legacy AS400 environment to ORACLE Applications. As a DBA I got the opportunity to transition through the full development lifecycle of the project and manage the entire development environment that included Solaris servers, all development ERP instances, backups as well as all third party tools used with ORACLE ERP.

• Proposed Hardware architectural design for production and development ERP environments
• Installed and configured development Sun servers in data center and installed Solaris OS
• 11i instance cloning using Rapid Clone
• ERP patching, SSL implementation and VeriSign Certificate provisioning
• 32-bit to 64-bit Database conversion
• Discoverer 4i and workflows configuration. Discoverer 4i to 10g upgrade
• Registration of custom applications in Oracle Apps
• AD Utilities usage
• Oracle database 9i release upgrade to fulfill DST requirements
• Correspondence with Oracle support on TARs to troubleshoot and resolve issues
• Working with development teams and end users to troubleshoot performance related issues and their fixes
• Working on user documentation like instance strategy, instance management and change management
• To resolve application performance tuning issues
• Installation and configuration of Oracle Application Express 3.0 (APEX) with Oracle Apps
• Development of custom Shell Scripts to automate the multi-node cloning process
• Implementation of ERP database backups utilizing Recovery Manager in conjunction with Netbackup.
• Installation and configuration of Netbackup server and client software
• Installation and Configuration of ITG Patch Management and ITG Object/GL Migrator
• Installation and configuration of Serena PVCS Version Manager Software
• Interfacing of App11i Cloning shell scripts with Appworx

Confidential

Implementation

Environment: Oracle 9i/11g, Cognos Enterprise BI, Solaris The Data Warehouse was designed to pull data out of AS400 into an Oracle Database. Cognos was used to deliver multi-dimensional cubes and adhoc reports.

• Installation/Configuration of development Sun hardware and Solaris OS in data center
• Installation/Configuration of Oracle Database Software on Sun Servers
• Development of shell scripts to automate ETL transformation of data from AS400 to Oracle Systems
• Installation and configuration of VERITAS Netbackup
• Backup Implementation for the Data Warehouse environment using NetBackup
• Involved in Application Design based on Snowflake Schema architecture
• Created necessary database structures and schemas required for Cognos installation
• Implemented table-level partitioning at the database level for historical data maintenance in Fact Tables
• Implemented database procedures for dimensional data versioning and monthly data maintenance
• Implemented automated scripts for database backup and error notification
• SQL Performance Tuning, Application Performance Tuning
• Oracle Database 9i to 11g upgrade
• Installation/Configuration of Cognos Enterprise Software on Sun Servers
• DecisionStream ETL implementation from AS400 to Oracle Data Warehouse
• Publishing of Dimensional Cubes, Powerplay and IWR reports to Cognos Upfront
• Day-to-day administration of Cognos Systems
• Development of Appworx jobs for AS400 to Oracle ETL Batch Processing

Confidential

System Implementation

Environment: ORACLE 8i, Confidential HRMS on Windows This project involved Installation and Configuration of Confidential Enterprise Payroll Application software on Windows.. The Application backend was implemented in an Oracle 8 database environment.

• Working with the implementation team to deliver an in-house Confidential Enterprise Payroll Application
• Installation and configuration of Production and Development Windows environments
• Installation and configuration of Oracle 8 database and Confidential Enterprise Application Server software
• Maintenance of development and production Oracle instance hosting Confidential application.
• Confidential Enterprise HRMS Software Upgrades and patches

Confidential, Cranbury, NJ

Oracle Consultant

Environment: RICHTER, ORACLE 7.3 on AIX RICHTER, the MRP package designed for sewn Industry utilizes Oracle on back-end as the database.

• Development and maintenance of Oracle Reports using Developer 2000
• Resolve database performance bottlenecks
• Database backup strategy review and implementation