SUMMARY

• US Citizen with over 15 years of experience in Oracle Database Management and over 2 years of experience in Oracle BI Platform and Applications. A good team player and hard worker and has excellent communication skills.
• Experience in Administering OBIEE 10g / 11g clustered environment on Linux platform.
• Proven expertise in overall Oracle Business Intelligence Architecture.
• Experience in configuring Automated Management of OBIEE Infrastructure using Oracle BI management Pack module of Oracle Enterprise Management (OEM) Grid Control.
• Proficient in full life cycle development of Data Warehouse including Dimensional Modeling, ETL strategies and Reporting
• Expert in OBIEE 10g/11g install, configure and deploy on weblogic in clustered environment on Linux platform.
• Experence in Oracle LifeCycle Management and Configuration Management.
• Extensive experience in writing PL/SQL programming units like triggers, procedures, functions and packages.
• Full Life Cycle implementation of backend database configuration (Installation, Setup, Tune, Backups, Patching) and provide the full database tier support to all phases of software development (Development, QA and Production).
• Excellent communication skills and strong team player.
• Strong problem solving, analytical skills, good verbal, written communication and presentation skills and ability to work in a time - constrained and team-oriented environment.

TECHNICAL SKILLS

ETL Tools: Informatica (PowerCenter8.6), DAC ( 10.1.3.4.1 )

Oracle BI: Oracle Business Intelligence EE 10.1.3.4.1 , Oracle BI Apps 7.9.6OBIEE 11g, Weblogic 10.3.5, Oracle Fusion Middleware (OFM)

ERP Tools: SAP R/3 4.0B, SAPDBA

Applications: Financial Analytics, Supply Chain Analytics

Data Bases: Oracle 9i/10g/11g, Oracle PL/SQL 9i/8i, Unix Shell Programming.

Software Tools: Toad, BMC Patrol, Big Brother (Quest Software), clarify CRM

Oracle Tools: Oracle SQL Developer, Oracle SQL*Loader, RMAN, Data Guard, Oracle Enterprise Manager(OEM) Grid Control, Export/Import.

OS Environment: RHEL4/5, SUN Solaris 9.0/8.0/2.7/2.6 , HP/UX 11i/10.0, AIX, Linux & Windows

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

IT Engineer

Responsibilities:

• As an OBIEE Administrator support large User Community to Install and Configure OBIEE, DAC, Oracle Business Intelligence applications (OBIA).
• Automated the Migration process for migrating rpd and webcat files from DEV to QA to PROD environments.
• Configured the Oracle BI Management Pack (part of Oracle Enterprise Manager) to manage the Oracle BI systems.
• Installed and Configured the OBIEE 11g and Weblogic 10.3.5 on Many Linux platforms.
• Setup LDAP authentication and SSO for OBIEE 11g.
• Setup Oracle Configuration Manager (OCM) and Remote Diagnostic Agent (RDA), the data captured provides Oracle Support with a comprehensive picture of the environment which aids in faster problem diagnosis.
• Demonstrated the patch process in OBIEE 11g for the RPD when moving between DEV to PROD.
• Setup and configure OBIEE 10g cluster and deployed the analytics on Weblogic Application server, authenticated using Siteminder SSO.
• Setup Sitescope to monitor the Oracle BI components.
• Help the team in setting up the infrastructure for Noetix Generator.
• Train the offshore staff to manage the day-to-day operations of the deployments.

Environment: OBIEE 10.1.3.4, OBIEE 11g, Informatica 8.6.1, OBIA 7.9.6, DAC 10.1.3.4.1 , RHEL 5Oracle 11g Database, Weblogic 10.3

Confidential, Huston, TX

Sr. OBIEE Consultant

Responsibilities:

• As an OBIEE Administrator manage OBIEE, Oracle BI Apps and Informatica workflows.
• Installed and Configured for BI Apps Financial Analytics and Supply Chain Analytics with Oracle EBS adapters.
• Built multiple execution plans in DAC for weekly and daily loads.
• Replace current spread sheet reporting by Oracle BI using existing infrastructure.
• Automate the process of loading data from spread sheets into Database Tables using Informatica and DAC.
• Migrating Informatica mappings, workflows from DEV to QA to PROD.
• Migrating rpd and webcat files from DEV to QA to PROD.
• Migrating DAC Repository from DEV to QA to PROD.

Environment: OBIEE v10.1.3.4, RHEL 4, Oracle 10g Database, Informatica 8.6.0OBIA v7.9.6, DAC 10.1.3.4.1 , Oracle EBS 11.5.10

Confidential, Redwood City CA

Sr Oracle DBA

Responsibilities:

• Install and administer Oracle 10g RAC on a 2 node Linux for Homeland Security (TSA and Coast Guard) project.
• Troubleshoot database performance problems in systematic way using AWR, ADDM, ASH reports.
• Installed & Configured 10g OEM Grid Control for monitoring RAC databases. Setup paging and email for critical and warning alert thresholds.
• Maintain Oracle Application 10g (ias10g) and Oracle Single Signon (SSO)
• Experience implementing Oracle Streams.
• Review and apply oracle security patches.

Environment: Red Hat RHEL 4 ES, Oracle 10g R2 RAC, OEM Grid, Oracle Applications 10g Wireless (Part of Oracle Fusion), APEX 3.1 (HTMB DB)

Confidential, Cupertino, CA

Sr Oracle DBA

Responsibilities:

• Install and administer Oracle 10g on Red Hat Linux and monitoring tools.
• Day-to-day management of Oracle database system such a patching, performance tuning.
• Setup and configure the oracle backups using RMAN.
• Implemented Data Guard Fail-Over/Switch-Over in RAC.
• Installed & Configured 10g OEM Grid Control for monitoring RAC databases
• Tuning database using (AWR), ASH, Buffer Cache Advisors, and Statspack, tuning Oracle Wait Events/Latch-Enqueue/Memory(SGA, PGA, Buffer pools)
• Evaluate and Implement Dev/QA/Production schema releases.
• Evaluate clustering in MySql database.

Environment: RedHat RHEL 4 ES, Oracle 10g RAC, MySql 5.0

Confidential, San Jose, CA

Technical Manager

Responsibilities:

• Digital Rights Management (DRM) - Adobe Content Server Software, This Software distributes electronic documents from a Website as secure and reliable PDF to the client desktop.
• Managed five off-shore software engineers to integrate and build the application.
• As a project lead coordinated all the tasks to build E-commerce website, including contract for the datacenter, purchasing servers/software and taking credit card payments via service provided by Verisign.

Environment: RedHat RHEL 3 ES, Microsoft Windows 2003 Server, Oracle 10g, Adobe Content Server.

Confidential, San Jose, CA

Sr. Oracle DBA

Responsibilities:

• Senior Database Administrator to support Oracle 9i/8i & MySQL databases.
• Designed PL/SQL Stored Procedures to migrate data to new database structure
• Worked on physical database design, query optimization, security and integrity enforcement, debugging and testing of Oracle databases for new release of photo sharing software
• Coordinate with developers to develop and tune SQL queries and procedures

Environment: Sun Enterprise Servers E 4500, Sun Solaris 2.8/9, Oracle 9i/8i, MySQL, PL/SQL, Shell Scripting, OEM, Red hat Linux

Confidential, Cupertino, CA

Sr. Oracle DBA

Responsibilities:

• Installed and configured Clarify CRM package and Oracle 8i in UNIX environments.
• Upgraded application and databases, apply patches, space management, shell script writing, backup and recovery, resolving corruption problems and performance and tuning issues.
• Automated routine tasks such as backups, database growth by implementing Shell scripts.
• Setup and Maintain INFORMATICA Server for ETL (Extract Transform and Load) applications for Reporting through Oracle Database Data warehouse.

Environment: Sun Enterprise Servers E 4500, Sun2.7, Oracle 8i, Clarify CRM, Informatica

Confidential, San Ramon CA

SAP R/3 Oracle DBA

Responsibilities:

• Demonstrated the capabilities of SAPDBA tool to reorganize the table space in parallel and in batch, to eliminate third party tools and reduce expenditure.
• Responsible for EMC Business Continuous Volume (Time Finder), split mirror copy of the database for backup implementation. This reduced the system downtime from 2 hours to 5 minutes.
• Used SAP CCMS, BMC Patrol and Oracle Enterprise Manager Tool to monitor and troubleshoot the performance problems.
• Allocate server system storage and plan future storage requirements for the database. Analyze server disk utilization and capacity.

Environnent: HP v2250, HP/UX 11i/10.0, Oracle 8i

Confidential, Foster City, CA

SAP R/3 Oracle DBA

Responsibilities:

• Managed eleven R/3 Oracle database servers on HP-UX and Windows NT.
• Developed the backup plan for all the databases, so that the R/3 Systems are operational 24 hours and 7 days a week.
• Proactively monitor the space utilization and performance using SAP R/3 tool SAPDBA and CCMS. Regular use of BRBACKUP, BRARCHIVE to backup the systems. Restore the database from system crash using BRRESTORE and SAPDBA.
• Install and Upgrade SAP R/3 3.0D software.

Confidential Reston, VA

Oracle Application DBA

Responsibilities:

• Configure and administer ORACLE 7.1.4 server software on Unisys 5000 Unix machine and developer2000 software on the client side.
• DBA functions involved create tablespaces, manage storage and space requirements, create and maintain database object scripts such as tables, constraints, indexes, procedures and triggers.
• In addition, I created procedures and triggers to implement the business rules on the server.
• Also I was responsible for configuration management of the software using PVCS Version manager.