SUMMARY:

• For the last Twenty years, He has provided various IT services. His focus has been in the area of Oracle Fusion Middleware, 12c RAC with ASM and Active DataGuard, Oracle OBIEE, OID and OAM, Integrated OBIEE with Windows Active Directory (AD),OAM and OID, Oracle OBIA with BIACM and FSM, Oracle Key Vault and Audit Vault with database Firewall, Oracle ODI, Oracle Exalogic and Oracle Exadata, Oracle Big Data Appliance, Oracle Hadoop and Oracle Endeca and Oracle
• Exalytics In - Memory Machine, Oracle Big Data Connectors, Oracle Linux, Oracle Hyperion Essbase Database, Oracle database Vault and Audit Vault, PostgreSQL, MySQL Database Administrator, Performance Tuning, Database Backup and Recovery and Programming.
• He has current and strong skills in the development of SQL Reports, SQL Forms, Korn Shell scripting, PL/SQL procedures, functions and packages programs, Oracle Business Intelligence report. Tuxedo, PeopleTools 8.51, Weblogic Server, EPM Database, OBIEE 11g Fusion Intelligence, DataStage. PeopleSoft EPM 9.1 Module. Encryption in Oracle.
• He is well versed in the functionality of Oracle 11g and 12c Real Application Cluster (RAC),ASM, skilled at Project Management, gathering Technical requirements, Testing and Training.
• He also specialized in tools such as SQL Developer, OEM, Oracle OBIA with BIACM and FSM, TOAD, ErWin, BCV, Oracle Designer, JDeveloper, Oracle APEX , Hyperion Essbase, HFM, FDM, and Planning Applications and is able to serve as a knowledge base for others.
• He has worked on all configurations of the Oracle Database and Apps Server: Distributed Option, Parallel Server, Oracle Big Data Appliance, Oracle Hadoop and Oracle Endeca and Oracle Exalytics In-Memory Machine, Oracle Big Data Connectors, Parallel Query, Oracle Essbase, Oracle GoldenGate, Active Data Guard, Oracle OBIEE Suite, Oracle Beehive, Oracle Data Integrator, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Application Server, Flashback, Linux, RMAN,ASM, Oracle GRID Control, Oracle OID. WebLogic Server, SOA Suite, Oracle Key Vault and Audit Vault with database Firewall,OBPM Suite, Oracle Fusion Middleware, Forms, Reports and EAR, WAR files Deployment. Wrote and tuned SQL and PL/SQL code, scripts, triggers, views.
• Implemented data models and database designs, data access and table maintenance codes.
• Integrated OBIEE with OAM (for Single Sign-On):Installed OID and OAM, Hyperion Essbase, Panning, HFM, FDMEE Applications.Integrated OBIEE with OID, Integrated OAM with OID.
• Encryption in Oracle. data Masking, audit alert report, data redaction for IRS 1075 Compliance with Oracle advanced security

TECHNICAL SKILLS:

Hardware, Programming Languages & Operating Systems: IBM RISC 6000, HP 9000 (T520, T500), Sun Enterprise 220R, Sun Fire V240, DELL Powerage. HTML, XML,PL/SQL, Java, JavaScript, PERL. PVCS, ClearCase, BCV,AIX (3.2.5, 4.1.4, 4.3.2, 4.3.3), HP-UX (9.04, 10.10, 10.20), SOLARIS (2.5, 2.6, 2.7, 2.8), TRU64 V5.1 732 alpha, Linux. Windows Advanced server 2008.

Oracle Database: Oracle RAC with ASM, Active DataGuard, Oracle Applications12i, JDeveloper, Oracle Designer and Oracle s Tools, Solaris, Legato Networker, Cognos, Microsoft SQL Server 2000, Erwin, Oracle OBIEE, Oracle APEX, Oracle OID, Fusion Middleware, WebLogic, Enterprise manager, Forms, Reports and EAR files deployment.

PROFESSIONAL EXPERIENCE:

Oracle Data Warehouse DBA/Developer

Confidential

• Installed and Configured Oracle VM Server on bare metal machines and Oracle VM Manager on Oracle Linux Server.
• Created a Private Cloud Data Center using oracle Exalogic, Active DataGuard, OEM 12c Cloud, Fusion Middleware Applications
• Discovered Oracle VM Servers, Created and configured Networks, Created Virtual Network Interfaces cards, Created and configured a Server pool, Created a server repository
• Imported the Oracle VM Templates, and Cloned virtual Machines from Templates. Implemented Program Products Update Package (PPUP) and Disaster Recovery Exercise (DRE).
• Installed and Configured Oracle Big Data Appliance with Oracle Exadata and Oracle Big Data Connectors with Exalytics In-Memory Machine.
• Configured Oracle OBIEE and Oracle Endeca with Oracle Hadoop
• Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault, and Database Firewall: Tablespace encryption, data Masking, audit alert report, data redaction for IRS 1075 Compliance with Oracle data security
• Deployed a Two Nodes Oracle RAC 12c Cluster using Oracle VM Templates
• Installed and Configured the 12c Cloud Enterprise manager to monitor and maintained the Oracle Infrastructure.
• Installed and Configured Oracle GoldenGate; Implemented GoldenGate Replication: Prepared the Source and Target Environment: Configured the Manager, Extract, Replica processes for GoldenGate. Configured Change capture on source and Change delivery on target.
• Installed, Configured and Maintained Oracle Data Integrator (ODI): used Oracle ODI studio to Create ODI Master and work repositories: worked with ETL Project, Mapping, and packages. . Executing ODI developments and Review Results. Created and maintained topology, interfaces, packages and load plan components .
• Installed & Configured Oracle Hyperion, and Maintained Oracle Essbase Server with Essbase Administration Services. Maintenance and Support for Essbase, HFM and FDM, Planning Applications and Other Hyperion Products.
• Supported users who use Smart view and Hyperion Financial Reporting to generate reports. Tuned Hyperion: Java heap
• Installed, configured and tune performance on middleware products to support middleware applications.
• Installed, Configured and Maintained Oracle Fusion Middleware products - perform supply chain application middleware infrastructure planning, design and integration using Oracle Fusion middleware (SOA, BAM, Service Bus), Oracle Business Intelligence Enterprise Edition (OBIEE).
• Installed and configured Oracle BI Applications with Data Source E-Business Suite. Implemented OBIEE Security Model With users and Groups of Corporate LDAP (Windows Active Directory) with the Application Roles to access the Catalog and RPD. Added users and configured security in web logic console of OBIEE.
• Managed OBIEE security privileges for each subject area and dashboards according to user requirements setting up "User Tracking",Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Worked in a Multi-User Development Environment (MUDE) check out repository, made changes, and completed the merge process.
• Develop complex reports in BI publisher with multi dimensions and metrics
• Installed and Configured BI Administration Tool, Access to Repository
• Used Oracle BI Applications Configuration Manager (BIACM), Functional Manager(FSM), WebLogic for Setting up and Maintained Oracle BI Applications
• Built the start and Stop script that will include the OBIEE Admin server, Node Manager, Managed Server, and opmn processes
• Used OBIEE EM Fusion Middleware Control, WebLogic Administration Console, as well as the Windows-based BI Admin Tool
• Administered the repository, manage variables, the catalog, and security on several levels of OBIEE
• Imported schemas, designed and built logical business models, and exposed business models to users in Oracle BI Analyses Editor. build physical and logical joins, simple measures, and calculation measures. extended the initial repository and model more complex business requirements, such as dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. used Administration Tool wizards and utilities to manage, maintain, and enhance repositories.
• Created analyses and dashboards for business intelligence applications. administered the Oracle BI Presentation Catalog and build an Oracle BI dashboard, including basic analyses and more advanced features, such as pivot tables, maps, graphs, gauges, navigation links, prompts, embedded content, and KPIs (Key Performance Indicators) on the dashboards. also used Oracle BI Delivers to send personalized, real-time alerts to dashboards and subscribers
• Configured the Analysis and Dashboards settings.Configured the presentation services initialization file of OBIEE
• Managed the mail and agent setting of OBIEE to properly configure report delivery. Read logs, diagnose problems, and fix them.
• OBIEE backup and recovery to protect your system against failure.

Oracle DBA/Developer

Confidential

• Installed and configured Oracle Enterprise Manager (CLOUD) to assist in managing databases, application servers and web servers.
• Installed and configured 12c Real Application Cluster (RAC) with ASM on Linux using Oracle Grid Infrastructure with Single Client Access Name (SCAN).
• Installed, Configured and Administered Linux Server and Oracle ASM.
• Implemented Active Oracle Data Guard, and Enabled Flashback as Oracle’s data protection and disaster recovery solution.
• Installed and Configured Oracle Big Data Appliance with Oracle Exadata and Oracle Big Data Connectors with Exalytics In-Memory Machine.
• Configured Oracle Obiee and Oracle Endeca with Oracle Hadoop
• Integrated OBIEE with OAM (for Single Sign-On):Installed OID and OAM, Integrated OBIEE 11g with OID for user repository, Integrated OAM with OID for user repository, Enabled SSO in OBIEE using FMW Enterprise Manager Control, Testd OBIEE Single Sign-On configuration
• Installed and Configure Oracle Beehive in the back end server, and in the DMZ, Oracle Beekeeper. Support Oracle Beehive users.
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal. Installed
• Installed Hyperion Essbase, Panning, HFM, FDMEE Applications. Maintained, tuned, Migrated and backup Hyperion applications
• Implemented GoldenGate Replication: Prepared the Source and Target Environment: Configured the Manager, Extract, Replica processes for GoldenGate. Configured Initial Data Load using Direct Load Method with Initial Load capture on source and Initial load delivery process on target. Configured Change capture on source and Change delivery on target.
• Installed and Configured Oracle OBIEE Suite. Maintain and Tune Oracle OBIEE Portal environment. Generated Ad Hoc, Drill down Reports with graphs on the Dashboard using OBIEE.
• Created Materialized views and enabled query rewrite parameters.
• Created Hash sub-partitions within the existing Range partitions to use Partition pruning on SQL. Implemented indexes strategies using bitmap and local indexes and enabled star transformation to improve performance of the Data Warehouse.
• Refreshed and cloned Development and Test Databases. Deployed Forms and Reports. Migrated Various Oracle databases to new Versions. Setup and Maintained oracle APEX environment.
• Wrote and tuned SQL and PL/SQL code, scripts, triggers, implemented data models and database designs, data access, table maintenance codes, and Deployed them to the databases.
• Installed, Configured and Maintained Tuxedo
• Installed, Configured and Maintained PeopleTools 8.51, Weblogic Server

Oracle DBA/Architect

Confidential

• Installed, configured, and maintained Oracle Fusion Middleware with SOA, OBPM Suite and WebLogic Server. Installed JDeveloper on the client Machine. Deployed Java EAR files.
• Add users to OID and to their appropriate group.
• Created RMAN cronjobs for hot Cumulative Level 1 incremental Backup. Tuned and implemented Block Change tracking file to improve RMAN backup.
• Migrated the Oracle portal contents from different environment. Installed, Configured, supported Oracle Warehouse Builder for the mapping, transformation and data load.
• Installed CPU quarterly patches. Setup Metrics and alert with Grid Control to send e-mail notifications to DBA’s when databases and listeners are down and when tablespaces or filesystems get to 90% full. Automatically monitor the 24/7 system with Oracle’s workload Repository and Advisory Framework. Implemented ADDM(Automatic Database Diagnostic Monitor) to automatically detects and diagnoses common performance problems. Used Active Session History(AHS), Automatic Workload Repository (AWR) reports.
• Used sar, vmstat, iostat, top to tune Oracle databases. Used PVCS for version Control.
• Installed, Configured and Maintained OBIEE 11g Fusion Intelligence
• Installed, Configured and Maintained DataStage
• Installed, Configured and Maintained Hyperion Essbase

Oracle DBA/Architect

Confidential

• Installed and Configured Solaris.
• Installed and Configured 10g RAC on Sun Solaris, and configured the RMAN Backup.
• Configured Data Guard for the Disaster recovery in Addition to the BCV.
• Applied Patches with Rolling Patch Upgrades feature using RAC and using Data Guard.
• Configured Portal clusters behind a set of Web Cache servers.
• Designed and planned the layout of the Application Servers universe, including clustering of the infrastructure, integrated Oracle OID with Microsoft Active directory. Maintained and Supported MySQL Database.
• Used Oracle BIEE Administration Tool to build, modify, enhance, and manage an Oracle BI repository.
• Installed, Configured and Maintained Oracle E-Business Suite.
• Integrated 10gAS to work with a backend RAC database.Deployed EAR files to cluster OC4J instances. Create business intelligence Portal Report via Oracle BI user interfaces, such as Oracle BI Answers and Oracle BI Interactive Dashboards. Used Oracle Utilities Sql loader and Data pump to load and refresh data.
• Generated AWR(Automatic Warehouse Repository) Reports to detects and diagnoses common performance problems. Used ClearCase for version Control.
• Implemented Single Sign-on (SSO) plan for 0TR including the integration of Oracle infrastructures, Portal, Business Intelligence Reports. Apply Oracle patches. Installed,configured, and maintained Oracle Hyperion and Essbase Database.
• Served as technical lead, and DBA consultant on the Datawarehouse project using Oracle 11g RDBMS on a RAC server, ODI (ETL), Oracle Discoverer (Business Intelligence) implementation.
• Frequently used Erwin to model staging, enterprise Datawarehouse and Data Mart logical models and physical architectures.
• Designed a sound backup and recovery strategy on multi-terabytes database, including crisis scenario, capacity planning.
• Setup, configuration & maintenance of Real time replication, using Oracle Streams, between ERP production database and other Oracle production databases
• Oracle Database backups & recovery using, RMAN and Legato Networker, perl, k-shell scripts

Oracle DBA/Developer

Confidential

• Performance tuning involving Disk, Memory and SQL tuning considering performance and physical resources. Tuning techniques include querying Dynamic Performance Tables, Multiple Background processes, changing initialization parameters, implementing partitioning and function based indexes, parallel queries and Data striping etc. Used tools such as Explain Plan, TKPROF, StatsPack. Implementation resulted in dramatic improvement in accuracy, reliability and operating efficiency. Installed, Configured and maintained PostgreSQL Database. Installed and configure Oracle RAC with ASM. Maintain and support ASM Diskgroup.
• Database Design, Review and Modeling: Logical and Physical database design
• Participates in new product design and planning.
• Work in database design process and suggest database design best practices through all phases of SDLC. Created Stored procedures, functions, Triggers, Materialized Views, Tables, and PLSQL Code Packages.
• Designed Maintenance involving performance monitoring, backup monitoring, upgrading to new releases and patches, manage space, instance/SQL tuning, process scheduler maintenance, perform adhoc SQL for users and review production process logs. Supported and Maintained Oracle PeopleSoft Database
• Installed and maintained Oracle WebLogic Server with SOA and OBPM Suite.
• Providing database support, guidance and training for developers. Worked closely with programmers, administrator and support staff for wide range of Oracle programming initiatives, including data migrations, database modeling and backend application design, coding, debugging, testing and training support.

Oracle Data Warehouse DBA/Developer

Confidential

• Served as an application DBA, coordinating and supporting the effort of PL/SQL and web developers, then translating their recurrent changes into database objects. Lead a team of six Oracle DBA and Developers.
• Implemented Oracle Advanced Security with Oracle Database Vault and Audit Vault: Tablespace encryption, data Masking, audit alert report, data redaction for HIPAA Compliance with Oracle data security
• Installed and Maintained Oracle E-Business Suite.
• Installed, Configured, supported Oracle Warehouse Builder.
• Installed and administered Oracle 9iAS and set up reports and forms services.
• Set up Virtual hosts and tuned Apache Web Server.
• Troubleshot Oracle reports issues and tuned reports parameters.
• Proposed and documented proof of concept for selecting an ETL tool.
• Designed, developed and executed Proof of Concept for Business Intelligence (BI) tools including Oracle Discoverer and Business Objects (BO). Additional responsibilities include database security management, designing the tables and indexes partitioning, Unix shell scripting and application related system management.
• Daily responsibilities include database design and modeling, performance tuning, database objects (table spaces, tables, indexes, users procedures, functions, triggers etc.)

Oracle DBA/Unix Admin

Confidential

• Created and deployed innovative Web Services using Oracle 9iAS Oc4j.
• Coded fast SQL queries, PL/SQL procedures, packages and triggers to scrub and pull data from mainframe and flat files and generate and output to feed into the SAS analytical Engine.
• Designed a sound backup and recovery strategy on multi-terabytes databases, including crisis scenario, capacity planning.
• Executed clustering and high - availability solutions, using Sun Cluster Server, Oracle Failsafe, and Oracle 9i Real Application Clusters (RAC).
• Installed setup, configured and administered the oracle application web server and Designer repository and Oracle Management server.
• Worked intensively on Server performance monitoring, tuning and troubleshooting the data bases, instances in Unix systems.

Oracle DBA Small Business Administration(SBA)

Confidential

• Lead the design phase of an Oracle 9i implementation. Helped business system analysts gather business requirements and produced a detail design specifications document, then translated those requirements into a multidimensional model.
• Set up a database environment with more than ten instances ranging from test, pilot, and development to training. Performed set refresh schedule to allow fast counts to be updated in the database and maintained Set Analyzer repositories.
• Designed and created ERDs, Star schemas and Multi-dimensional models as part in the development and rollout of data management policies, standards, and procedures.
• Install and maintained Oracle Application Server.

Oracle Architect/Developer

Confidential

• Responsible for analyzing and designing the dimensional models along with working with other DBAs to implement the physical models in Oracle.
• Installed and configured Oracle 7.3, 8.x, 8.0.5, 8.1.7 and later 9i in a distributed environment that included multithreaded server (MTS).
• Performed Unix system administration duties on a number of production databases. Developed reports. Migrated MySQL database to Oracle.

Oracle DBA/ Architect

Confidential

• Installed and administered Oracle Warehouse Builder.
• Designed and implemented a summary management including bitmap indexes, materialize view and Table Partition.
• Implemented and ETL solution using Oracle Warehouse Builder (ODI) supplemented with Unix shell scripts.
• Built reports using Oracle Discoverer.
• Wrote complex and error-checking shell scripts to automate migration of development changes across different environments, ensuring that all jobs are audit-trailed.
• Planned and created a fail-safe and high-availability Oracle environment, including Oracle Real Application Cluster, replication.
• Installed and configured Oracle 9iAS in a multi-infrastructure environment, integrating Oracle LDAP (OID) with Microsoft Active Directory to allow for a single user repository across the company.
• Refreshed the development Databases monthly. Integrate the Oracle Application server with Oracle e-business suite.
• Migrate The oracle database to new Version.

Oracle DBA/Developer

Confidential

• Coded shell scripts to perform backups, maintenance and send pager messages.
• Configured Oracle 9i on Sun Solaris, HP Tru 64 as a management platform, database server.
• Captured Unix server statistics with Oracle 9i STATSPACK.
• Implemented Advanced Replication to provide database load balancing, disaster recovery, and offline distributed transaction processing.
• Database Analysis, Logical/Physical design and Development based on functional requirements. Capacity and Storage planning for DB objects depending on the application and space limitations. Generation of scripts for Database creation and schema migrations for new releases. Testing and deploying release modifications on development and testing servers. Installation and configuration of Production databases (RAID).

Oracle DBA/Developer

Confidential

• Undertook several tuning efforts to ensure a high performing database, such as tuning database design, application, memory usage, input/output and contentions.
• Involved in daily maintenance of databases to ensure the improvement of a high performing SQL statements and database availability at all time.
• Implemented Oracle parallel server, Oracle Names server.
• Installed, Configured, Administered Veritas Volume Manager, Legato Networker and Sun Storage Array A1000.
• Worked intensively on server performance tuning and developed database synchronization and backup strategies and programs to ensure recoverability of databases. Used ClearCase for version Control.
• Assisted in database design of this project by performing data analysis, user requirements, and data modeling using ErWin. Also generated reports, created forms, PL/SQL triggers and procedures, charts and graphics using Developer/2000 tools. Established the database requirements, created and fully supported the development instance in addition to supporting a data warehouse by performing huge loading of data on a database repository for the Platinum project.