Summary of Qualifications

Insightful, intuitive and responsive IT Professional with a proven record of success with over 15+ Years of experience in the Private, Public, Educational, Non Profits Sectors in the areas of Business & Technology. Innovative and persistent problem solver who thrives on challenges, calm under pressure and gets the job done. Confident, diligent and resourceful team builder who possesses outstanding interpersonal and communication skills. Proven skills in managing well with priorities and balances competing agendas while consistently providing value

Areas of Expertise

Database Administration: Extensive experience in handling DBA duties such as Creation, Implementation, Monitoring, Performance Tuning, User maintenance and maintenance of the Oracle RDBMS v10g, 9.x, 8.x & 7.x. in large production environments with very good understanding on Cluster and Storage architecture.
Business Continuity & Disaster Recovery including business information analysis and risk assessment, identifying time to recover, developing action plan with agreed restoration tactics, negotiating strategies / consensus / funding, establishing recovery procedures, policy development and training, communicating to internal / external stakeholders, documentation and executive reporting.
Operations Consulting including scoping and pricing of engagements, proposal development, conducting in-depth organizational and operations reviews, developing findings and recommendations.

Affiliations/ Membership/ Certifications
Oracle 10G Administrator Certified Professional (OCP)
Member, Professional Risk Managers International Association, PRMIA
Member, Global Association of Risk Professionals, GARP
Completed Professional Risk Manager Training, December 2008
Certified in Homeland Security

EDUCATION / TRAINING

Undergraduate/Bachelors Degree 4 year Integrated Degree M Sc (Tech) Science & Technology Development

Technical Skills

Application Server Oracle 11i ERP, Oracle Application Server 10G, Web logic 9.0/8.x/7.x
Database Systems Oracle Apps 11i, ORACLE (10G, 9i, 8i, 7 and 6), Object Store (1.0), Sybase, SQL Server 2000/2005
Security &Audits SAS 70, Account Management for IT Operations
CRM Siebel Epharma Analytics 7.0.3 (Analytics Apps. /Data warehouse Server), Siebel Epharma 2000/ 7.0.3/ 6.3
Oracle Tools Partitioning, RMAN, Materialized Views, Stats pack, SQL Tracing, TKPROF, OEM grid, PL/SQL, SQL, SQL*Loader, Export / Import, Oracle Reports, SQL*Net, SQL*Plus, Pro*C
Oracle HA Data guard, RAC (Real Application Clusters), Oracle 9i Replication
DBA Tools DB Artisan, BMC Patrol, OEM, TOAD 7.3/7.6/8.0 (Debugger, Xpert, DBA), Database Edition 3.5, Quest Shareplex, Quest Central (Spotlight, Performance Diagnostic, Database Analysis, Space Management, SQLLAB Tuner, SQLLAB Expert, TOAD & SQL Navigator), ODM (Oracle Disk Manager)
Storage: Hitachi, EMC / DMX, NetApp
Tools HP Data Protector 5.5/6.0, Control M, HP Open view, ERWIN Data Modeler 7.5, Designer 2000, dbx, shell, TEAMWORK (CASE Tool), OOATool, Network Sniffers, Veritas Net backup 3.4, Cluster 1.3.1, Quick I/O, Load Runner, QTP, TOAD, UML, VISIO, VM Ware, Quest Shareplex, Quest Central (Spotlight, Performance Diagnostic, Database Analysis, Space Management, SQLLAB Tuner, SQLLAB Expert, TOAD & SQL Navigator) and DBArtisan.
Data warehousing Informatica Power Mart v5.0/4.7 & Power Center v5.0/1.7
Languages C, SQL, UNIX Shell Scripts
Configuration Mgmt Rational Clear Case, PVCS, CONTINUUS/CM
Servers UNIX Servers SUN Fire 280R, SUN E4500/Sparc2, HP 700/8400,IBM RS6000, HP-9000 Superdome, RP, (K, N, T, H & E) classes, SUN (E25K, 15K, 10K), IBM P series, Netfinity
Operating Systems HP-UX v 11, 10 & 9, Solaris 5.8, AIX 5.1,5.3, SUNOS 4.1.1/5.9, MS Windows NT/2000, AIX, LINUX SUSE 9.0, RH4, VM Ware, AIX
CRM/ERP Oracle 11i ERP, Oracle Applications 11.5.10.2, Oracle Identity Management 10.1.4.1, Oracle SOA suite for BPEL 10.1.3.1.0, Oracle Apps 2 Node RAC, People Soft 8.1 (People Tools), SAP R/3, Siebel Epharma Analytics 7.0
Design Methodologies Structured Analysis/Structured Design, Object Modeling Technique (Rum Baugh), (ER) diagrams
Standards ISO 9001, SEI (Software Engineering Institute) CMM}
Project Management: Oracle AIM Methodology, PMI

Professional Experience
Architect/DBA (24X7), Confidential, TX, USA Jan 2010 till Present
Health system comprised of almost 350 services and facilities including more than 50 hospitals and long-term care facilities.

• Leadership role in the development of new technical strategies and solutions as well as a tactical role involved with the execution of business analytics, financial contract systems, and financial dashboard systems.
• Service Design/ Transition following ITIL V3 Foundation
• Responsible for translating client's business requirements into systems/applications.
• Apply Oracle CRS Bundle Patch 7117233 to the Oracle 10g RAC Database for HPM Application.
• Apply Linux Security Patches to the 2 Node Oracle 10g RAC Database for HPM Application. Work with System Administration team for Red Hat Linux Upgrade from 5.1 to 5.3 and coordinate with EMC Storage Engineer to upgrade the corresponding Power path for the changed Kernel.
• Responsible production support 24X7 for the Databases supporting the applications, administration and upgrade of McKesson HPM, HBI, and PCON applications, HBI and PCON applications have a SQL Server 2005 backend DB and HPM has Oracle 10G RAC.
• Log Tickets with Oracle Metalink Technical Support and work through the database issues.
• Worked with the Program Manager to gather business needs for Hyperion 11 upgrade from Hyperion 6 and helped architect the Hyperion Performance Management Solution
• Consolidation of 8 individual Patient Keeper Databases from a 2 Node Oracle 10g RAC into a Large Single Node Oracle Database with Standby Server, recommended change from RAID 5 storage to RAID 10 Storage for better performance considering the 1000 user load.
• Discovery Phase to gather business needs and propose business cases , Case for Change, Conduct Infrastructure, IT, Security, Risk and Compliance review to the technical components identified and evaluated as part of the Solution Design which includes researching current vendor products/ solutions and the drivers for change.
• Day to day activities include working with business users to support new system requirements and existing system operations which encompass: performance tuning, system maintenance, and addressing compatibility issues.
• Architect Solutions with New Technologies in the areas of Healthcare Information Exchange (HIE), Patient Health Record (PHR), Financial Management & Reporting, Hi Tech Advanced Clinical, Integrated Project Dashboards, Hospital Administration, Billing and Records, and Compliance to Health/Medical care regulatory standards.

Environment: Oracle Data warehouse size 2TB, Oracle 10G RAC, System Analytics, EMC, Linux, SQL Server 2005, Application Servers, Web Servers, Linux, Windows 2003, HP Service Center, Mc Kesson Products (HBI, HPM, PCON), Large corporate systems environment with a wide variety of Information Management systems, networks and technologies, ITIL V3 Foundation

Enterprise Disaster Recovery Architect, PMO, Confidential, USA Aug 09 till Nov 09
Confidential, Quantico VA

Enterprise Disaster Recovery Solution Architecture will address the various essential functions and the guaranteed availability of those essential functions from an Alternate Site if an irreversible disaster event, occurs at the Primary Site.

The Enterprise Disaster Recovery Plan (EDRP) applies to major, usually catastrophic, events that deny access to the normal facility for an extended period designed to restore operability of the target system, application, or computer facility at an alternate site after an emergency.

This Enterprise system is the core of LCM project and is based on the Oracle 11i E-Business software package to support improved logistics business processes.

Database Server and Network Architecture, is aimed to provide the strategy and architecture for an Enterprise Disaster Recovery (EDR), which is a key component of the Continuity of Operations (COOP) for LCM Project.

Environment:
Oracle 11i ERP Environment, Oracle Applications 11.5.10.2, Oracle Identity Management 10.1.4.1, Oracle SOA suite for BPEL 10.1.3.1.0, Oracle Apps two node RAC, Middle Tier: Concurrent manager, Report server, Forms Web services: Oracle 10G Discoverer, Red Hat Enterprise Linux Advance Server 4.0.

Consultant, Confidential, NJ 07/2008 - 08/2009
Managed Services - Oracle Database Server Administration
Administer Oracle Server & Microsoft SQL Server databases. Manage Oracle database instances with RAC/Data guard technologies in HP AIX, Sun Solaris, and Linux platforms. Configure and support databases using High Availability. Monitor server performance and tune the databases and applications. Perform backup and recovery, Perform Oracle software installation, database creation, and several database upgrades from Version 9i to 10g Rel. 2. Apply software patches quarterly via Metalink CPU alert. Use 10g Grid Control & TOAD for database administration and maintenance tasks. Work actively with Oracle support on different database issues.

Major Accomplishments:

• Key roles in 10g upgrades & database server consolidation project
• Assist clients with in-house feasibility study to determine projects best suited for outsourcing.
• Participated with client stakeholders to complete definition of the project.
• Set local technical support and guide client through how effective project management using the Onsite/ Offshore Model can help provide timely implementation of a project
• Implemented effective communications management to avoid miscommunication issues that are experienced in most projects in an Onsite / Offshore Model.
• Ensure all aspects of the business at the client are identified and that a Continuity of Business Plan (COB) plan exists for each section of the client.
• SAS 70, SEI CMM Audits & Process Improvement Projects End-to-End Implementation.

• Responsible for production support, supporting applications in Investments, Fixed Income, Equity Systems and Sales/ Marketing (184 applications with 77 underlying Database Instances)
• Responsible for performance tuning using AWR, ADDM, and ASH Reports in 10g, and Stats pack for 9i
• Configured Oracle 10G OEM for all instances.
• Successfully supported data center migrations to support corporate initiatives while exceeding our business availability and disaster recoverability requirements.
• Defined Standards for Monitoring requirements for Oracle using HP Open View SPI, and implementing it across the enterprise for all Development, QA and Production Servers.
• Develop & Implement Production Acceptance Criterion (PAC) for all applications which included DB PAC, WEBLOGIC PAC, UNIX/Wintel PAC, Monitoring PAC (Open view alerting system)
• Applied DST and JVM patches for 23 DB's (15 9i DB, 6 10g on UNIX, 4 10g on Windows)
• Upgraded 9i production DB's to Oracle 10G in a UNIX environment.
• Used Meta link support from Oracle for resolving various DBA issues.
• worked successfully with KPMG consultants and internal teams for Data Center Migration.
• Developed Shell Scripts to refresh Oracle Databases using EMC SRDF R1/R2 and automation of Night cycle/EOD processing jobs through BMC CONTROL M / PERL.
• Applied Critical Patch Updates (CPU APR 2007) for all production Oracle DB's.
• Participate and Lead teams comprising of Network Engineers, Web Admins, Application Server Admins, UNIX Admins, DBA in problem management and root cause analysis and participated with group for On Call rotations every other week.
• Developed DR plan and conducted backup and recovery exercise using Data Protector 6.0 and Oracle RMAN scripts.
• Work with HP Open View monitoring team to define file system thresholds, table space thresholds, Oracle events for Tele alerts to be sent to DBA team and kick off Archive log RMAN backup scripts for archive directory thresholds.
• Used ERWIN 7.5 Data Modeler to reverse engineer applications to generate Logical/Physical Data Models and provide application groups with Subject Areas.
• Used EMC SRDF R1/R2 Sync & Split, Refresh DB Scripts to restore databases to different node.
• Worked with CONTROL M (Job Scheduling Software) to automate database maintenance tasks.
• Involved in Data Center Move (End to End) working with Bearing Point.
• Developed automated data extraction routines using SQL, PL/SQL, database functions, UNIX shell scripts to generate downstream data to feed the Investments Data warehouse and other Application Databases.
• Implemented data validations into the Equity Methods module of application using database constraints, policy, roles, triggers and functions.
• Developed complex database procedures to retrieve Grant Details (stock options, dividend, and balances) using PL/SQL, dynamic SQL, Ref Cursors, utilizing Oracle database with Database, Partitioned Table spaces.

Confidential, New York, NY 10/2005 - 01/2007
Sr. Oracle DBA/Team Lead

• Installed Oracle Application Server 10G (10.1.2) with both the Oracle Infrastructure layer (comprising of Oracle Metadata Repository and Oracle Identity Management), and the Oracle Middle Tier Layer (system components including the Business Intelligence and Forms type of installation - HTTP Server, OC4J, Oracle Portals, Oracle 10G Server Control, Oracle Internet Directory, Single Sign on (SSO)) on a LINUX server with SUSE LINUX 9.0
• Worked with the System administrator in installing the requisite libraries/rpm packages on LINUX for Oracle 10G Application Server Installation.
• Provide operational KPI, project status and reports to upper management for monthly progress review.
• Work with offshore vendor team to increase project bandwidth and increased off-hour support and coverage. Increased project load by 50% and site support tickets by 100%. Project change management process implemented to reduce mission creep and track impact of project changes.
• Developed Reports in Oracle Portals 10.1.2 by using Oracle Port lets, providers, Page Groups and Pages.
• Installed the Oracle 10G OEM on LINUX which has a web interface to Oracle Database Administration.
• Implemented an Oracle 9i Data guard Physical standby server, and switchover to a new data center.
• Co-lead offshore vendor relationship to increase project bandwidth and increased off-hour support and coverage. Increased project load by 50% and site support tickets by 100%. Project change management process implemented to reduce mission creep and track financial impact of project changes.
• Provided 24x7 support on all the Production, Staging and Development Databases.
• Made changes to the replication tables and set up masters groups for Multimaster Replication
• Diagnosed and fixed production issues including, high server load, broken DBMS jobs, user session and performance issues and problems in data feed with the use of shell scripts, Cron Jobs, DBMS_JOBS.
• Provided support to application groups for deployment of code changes to production from staging.
• Installed Oracle 9.2.0.1 and applied upgrade patches for Oracle 9.2.0.6.
• Utilized Oracle 10G features, which include Advisor Central (SQL Tuning Advisor, SQL Access Advisor), and ASM (Automatic Storage Management).
• Used Meta link support from Oracle for resolving various DBA issues.
• Managed Oracle objects including tables, indexes, views, constraints, db links, jobs, and snapshots.
• Maintained Oracle Replicated Groups and Oracle Replicated Objects in a Multimaster Replication environment.
• Extensively used SQL and PL/SQL to implement database functionality (packages, procedures, functions and triggers).
• Supported several scripts to feed data from Source Systems using FTP, SQL*Loader, Import/Export, SQL, PL/SQL, C, and also automated the feed processes using UNIX shell, awk scripts and cron jobs.
• Involved in strategic planning & implementation of the company's data center relocation.
• Provide support to the in-house and offshore development team in schema management, privileges, PL/SQL development and debugging, query performance tuning etc.

Confidential, Warren, NJ 06/2005 - 09/2005
Oracle DBA (Applications Support)

• Supported various projects, which included PFS (Prepay Financial Systems), WDS (Wireless Data Systems)
• Involved in Migration of DB from SUN Solaris 2.8 on Sun V490 to HP UX 11i on HP4440. Installed Oracle 9.2.0.1 on HP UX system, upgraded it to 9.2.0.6 and also applied various latest Jul 2005 security patches.
• Coordinated with system administration team in setting up Oracle servers and supplying the needed UNIX parameters (SHMMAX, SHMMIN etc) for the OS and tested various scenarios of fail over in a Veritas Cluster environment.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically and RMAN Hot Backup Scripts.
• Supported developers during batch jobs for additional month end updates to the system.
• Resolved developer problems by suggesting BULK fetch and BULK commit features, and various other query issues resolution/or structural changes as needed for new features in development.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Performed Database refreshes from Production to Development or Integration as necessary.

Consulting Firm 01/2003 to 06/2005
Oracle Consultant, Global Delivery
Global Delivery for CitiGroup/ Merrill Lynch/ Avon Products/ USI/ EBS Dealing Resources (Foreign Exchange & Gold Trades) and several other clients/projects:

• Maintained the project plan and communicating plan deviations, risks and mitigation options, communicating project progress via meetings, reports, and teleconference sessions
• Defined out-of-scope modules, assumptions, dependencies, constraints, project schedule and milestones.
• Examined the existing home grown application as source of input / validations and evaluated/mapped current business scenarios with existing application

Confidential, Wall Street, NY & India
Provided Production Support Oracle Database Administration

Provided an integrated, single, global source for Cash and Trade financial transaction and reporting information, both historical and intra-day, to meet the following objectives: Information delivery to customers via CitiDirect, CFS and other customer presentation channels. Enabling the decommissioning of the data components within the legacy EB platforms and Reporting and analytical needs of both internal and external users and systems

• Provide 24x7 architecture support, maintenance and implementation of the Worldwide Corporate Databases and Oracle ERP Applications version 11i and 11.0.3
• 10 Production and 24 test, development & QA instances, over tera bytes of each databases
• Hands-on experience maintaining ERP production systems having more than 10000 users
• Database administration includes proactive monitoring, trouble shooting & performance tuning
• Participated in Data Model Reviews with Business Analysts, Data Architects.
• Participated in Design Meetings and writing Program Specifications.
• Worked in an environment where both OLTP and OLAP database types were used.
• Performed Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i, 9i)
• Created Oracle TAR using Oracle Metalink for unresolved issues.
• Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Database Sizing, Table space Management, Transaction Management, Security Administration.
• Performed DBA preparatory steps prior to loads, and while moving data between SIT, UAT and Production systems.
• Responsible for translating business requirements into data requirements, Used ERWIN for Logical Data modeling and creating physical database designs.
• Build and maintain database store procedures, database triggers, and user-defined functions.
• Planned and conducted Database upgrades/Database Migrations.

Data Modeling / Data Architecture

• Involved in analysis and design with business analysts to generate Use Case diagrams, Object Model, and Visio to depict process flows
• Responsible for gathering data requirements through facilitated sessions and Use Cases and designing data models based on those requirements
• Handled multiple project assignments with minimal direction, manage and negotiate work load with project manager(s), escalate issues as necessary to management
• Influenced the project team to design and build quality data models within defined standards
• Evaluated and mapped current business scenarios with existing application
• Responsible for review and approval of the data model by the project team
• Manage data processing through the various stages from RAW data to structured data to Normalized and Aggregated data.

Confidential NJ 01/ 2002 - 12/2002
Oracle DBA, Siebel Consultant

• Responsible for reorganizing C3i's client development, test and production environment working with the IBM Hosting Team, Internal Support Team, Eisai Production Support team
• Assigned to the Eisai Siebel implementation as an Oracle DBA/Siebel Administration/ IBM Hosting Contact point. Monitoring Installed development, QA, and production environments for client and provided consulting on capacity planning/sizing issues and preparation of SOP (Standard Operating Procedures)
• Provided guidelines to the Production support team for Eisai database.
• Oversee migration of data from legacy systems into Siebel database.
• Performed data scrubbing of all legacy data before migration into Siebel database.
• Responsible for creating all documentation for all Sybase SQL/ Oracle Servers and related tasks associated with them.
• Oversee the Setup and configuration OLAP and OLTP Servers for the Siebel Epharma Analytics 7.03
• Oversee the processes associated and assisting the Siebel Business Analytics developers with the Syndicated Data Loads.
• Provide ongoing Production support for the Aspire Legacy system until SFA implementation was completed.
• Supported the ETL Team for Detail Data Feed Process/ Data Extract Process/Data Loads, in the Master Production Schedule from Legacy to Siebel Platforms for Boerhinger Ingelheim

Confidential Edison, NJ 08/1997- 12/2001
Applications Support

Supported client assignments/projects, which include Financial Firms & Hosted/Managed Services
(Clients include Accenture, Chase Manhattan Bank, Oracle Consulting Services) .

SAP

• Responsible for the data extractions from R/3(AFS) and external systems to BW for Logistics, FI/CO and Enterprise Controlling.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Conducted performance tests in the client's performance system and analyzed the performance of the system for every subject area loadings.

Peoplesoft

• Performed Fit -Gap Analysis. This was to define their requirements in relation to the implementation of Peoplesoft Release 7.53 of the Budget module
• Developed queries for building OLAP budget cubes relating to budget to actual comparisons at the various cost centers.
• Defined Workflow processes to move cubes from Budget Coordinator to the Budget Preparers.

Confidential, Edison, NJ 09/1995 - 08/1997
Business Analyst Confidential, New Jersey -- Configuration Management Tools (Software Engineering Process Group)
Investigate commercial packages like CONTINUUS, Clearcase and PVCS, present findings in terms of comparisons of features such as Seamless Support for heterogeneous networked development environment, support of Parallel Development, Version Management, Problem Tracking, Work Area Management in order to improve development environment

• Involved in the testing of CONTINUUS/PVCS/Clearcase with a set of benchmark experiments that comprised, support of parallel builds, change management, problem tracking, and Query/Reporting facilities.
• Involved in developing engineering practices and methods to continuously improve software quality, reduce development time etc. in conformance with the requirements set forth in ISO 9001-1994 standards of (Quality Management System, Project Management, Process Standards etc)

Result - Multiple phases of the system were successfully implemented - all four worldwide offices at Madge Networks cut over without incident

Environment: Sun 3/50, Sun Sparc IPX, PC- Crones, UNIX Scripts, CONTINUUS/CM, PVCS, Rational Clearcase, DDTS

Consulting Firm, New Jersey 03/1995 - 08/1995
IT Consultant Systems Administrator/ SQL Server DBA

• Act as a Team Leader to various projects, System Administrator of Windows NT, SQL Server, install operating systems, additional drives, upgrade memory, install SQL Server incorporate in-house application in a client/server environment, allocate disk spaces, resolve memory and space issues.
  

Environment: COMPAQ PROLIANT SERVER SERIES, Windows NT, SQL Server, and PowerBuilder 4.0

Consulting Firm, Kansas City 09/1994 - 12/1994
Systems Engineer US Sprint, Kansas

• Involved in the logical and physical design, of Continuing Property Records System. The system existing on a mainframe has been converted onto an ORACLE 7.0 Platform with HP-UX running on a HP9000 box. This application was developed for the taxation and CPR group to keep track of various US Sprint equipment all over the country and associated costs in each state.

Confidential, Irving, Texas 07/1994 - 09/1994
SAP DBA

• Responsible for User Management, Database and Transaction Logs Backup,
• Troubleshooting any system problems as required from time to time.

Confidential, Dallas, TX 05/1993 - 06/1994
System Administrator

• Sun System Administrator for a 200 + Sun Workstation Network. Support includes installing, maintaining, recommending, and troubleshooting all SUN based hardware and software products within the Laboratory.