We provide IT Staff Augmentation Services!

Obiee Resume Profile

5.00/5 (Submit Your Rating)

OBJECTIVE To obtain a position that will enable me to utilize my business, technical and management skills, while offering a challenging and rewarding career in the fields surrounding Oracle Database and Application consulting, Project Architecture / Engineering, Oracle Identity Management implementation / integration, Maximum Availability Architecture MAA and Disaster Recovery DR architecture / implementation surrounding Oracle published best practices.

GENERAL I have over 18 years experience in database configuration for high availability surrounding eBus 11 / 12,

OVERVIEW PeopleSoft 8 / 9, OBIEE, and several others . Proven competency surrounding Oracle database architecture design and administration for both OLTP and Data Warehouse projects, and specialized in Oracle Exadata implementation, Oracle Identity Management, database migration and ldap / OID integration. I hold many industry certifications, including Oracle Exadata 11g Implementation Certified Specialist and Oracle Database 11g Performance Tuning Certified Expert, foreign systems integration, Maximum Availability Architecture MAA , database fail over and disaster recovery system architecture, full lifecycle development support, senior project engineering, principal project architecting, principal database / Identity management security architect, integration delivery and performance tuning.

TECHNICAL Programming/Administration:

OVERVIEW Installation / configuration Oracle applications Linux and Windows HR, Finance, ERP, Supply Chain, Analytics, and several other modules , OBIEE Installation / Configuration / Administration in Linux and Windows, Oracle database 11g/10g, Oracle Apps 11 12, Oracle Fusion Middleware, Oracle Spatial, Oracle Identity Management 11g/10g, Microsoft Active Directory LDAP Integration with Oracle Internet Direct, Oracle Exadata V1 / V2 11.1.0.7 R1 11.2.0.3 R2 including advanced clustering, SCAN utilization, ASM, RAC surrounding eBus DR and fail over automatic application, middleware, database, service failover , Oracle ETL programming, Oracle RAC, Oracle Data Guard 11g/10g, CICS, SQL, PLSQL, CCL Ext SQL

Operating Systems:

Sun Sparc Solaris, Sun x86-64, HP-UX PAR RISC64, RedHat Linux 4.2-5, Sun Solaris, Unix various , VM-Ware Virtual Server and Virtual Workstation ,SCO, NT Server, Open VMS, Windows 2000 Pro, Windows XP Server, Windows XP Pro, Windows 2003 Server, Windows Vista, Citrix Server and Presentation server client install and integration, Exchange Server

Roles and Responsibilities:

  • Principal Security Consultant, Principal Consultant of Business Process and Domain, Project - Program Architect / Manager, Senior Oracle / Sybase DBA, Director of IT, Functional Team Lead, Integration Lead.
  • EBS DBA responsible for numerous implementations and upgrades
  • Installation of Oracle Apps 11.5.10.2, 12.0.4, 12.0.6, 12.1.1 on single node, multi node and on VM ware with
  • DataGuard, RAC, Streams, ASM, Clustering, and Grid Infrastructure
  • OBIEE Installation, Configuration, and Administration.
  • Operating Systems including Linux, Sun Solaris, IBM AIX, HP-UX.
  • Linux 4, 5 numerous flavors / releases ASM disk, os kernel, and os patch administration / configuration
  • Oracle 11gR1 / 11gR2 Grid Infrastructure installation and configuration
  • Implementation of multi nodes Oracle RAC on Linux with ASM, NFS.
  • Installation of Oracle Workflow, Toad, PL/Sql developer on client systems
  • Upgrade of Oracle Apps from 11.5.10.2 to R12.1.1.
  • Adding and Configuring of Printers in Apps R12 and in 11i
  • Configuring of Workflow Notification Mailer.
  • Experienced in troubleshooting any Oracle EBS issues including performance, Workflow, forms, reports, and concurrent programs and processes
  • Upgraded Oracle Apps from release 10.7 to 11i 11.5.2 with HRMS and Payroll
  • Implemented 11i on an active/passive VERITAS Cluster Server VCS
  • Implemented 11i on TruCluster on HP Tru-64
  • Oracle 11i platform migrations including HP-UX to Oracle Enterprise Linux
  • Supported best practices for Oracle EBS development methodologies
  • Mentored many Database Administrators DBA to support Oracle EBS post install
  • Work with clients to meet and exceed required Service Level Agreements SLA
  • Experienced in Vertex Quantum integration in Payroll and Receivables
  • Research, plan, and performed patch and clone activities
  • Perform Sarbanes-Oxley SOX audits around EBS and supporting infrastructure
  • Developed technical architecture to securely support EBS products
  • Implement EBS security leveraging technical options and customer demands
  • Support and troubleshoot integration with EBS from various 3rd party applications
  • Supported application tier issues with 9iAS, 10gAS, WebLogic, WebSphere
  • Support and troubleshoot concurrent manager issues

TITLES Principal Consultant Process and Domain / Project Manager / Project Architect / Senior Oracle DBA /

ROLES HELD Sybase DBA / Technical Team Lead / Pre-Sales Post-Sales Engineer Oracle Product / Consulting Services

PROFESSIONAL EXPERIENCE

Tasks Performed - General

  • Installation of Oracle R12.1.1 multi node with 11g Database
  • Implement Oracle DataGuard, Streams, 2-8 node Clustering, ASM, and DR / MAA.
  • Installing of HRMS Localizations global and Canada using hrglobal driver.
  • Installation, Configuration, and Upgrading of Oracle APPS from R12.1.1 to R12.1.3
  • OBIEE Installation, Configuration, and Administration
  • Oracle Apps Several Modules Installation, Configuration, and Administration
  • Implementing MLS Lite to enable multiple Languages
  • Performed Daily Checks of database and applications.
  • Implemented RMAN Backups surrounding various disaster recovery requirements
  • Configuring of Printers and Troubleshooting the Alignment issues.
  • Configuring the Notification Mailer to send emails to the users.
  • Maintenance of R12.1.1 and 11.5.10.2 instances.
  • Performing Daily checks.
  • Prepared Daily Reports for Oracle Apps status and Database growth
  • Deployed daily checks script to monitor the instance
  • Installation of ORACLE R12 with 10g Database
  • Monitoring and troubleshooting the Oracle database and Application issues
  • Cloning of E-biz applications single node to single node.
  • Management of tablespaces, datafiles in the database
  • Performed daily checks of the database and applications
  • Applied OPatches on the database
  • Upgraded Oracle Clusterware and databases from 10.2.0.2 to 10.2.0.4
  • Upgraded Oracle databases including Exadata from 11.1.0.7 to 11.2.0.4
  • Implemented the RAC on EBS environment on ASM
  • Implemented the backup and recovery strategy with RMAN
  • Creation of users and assigning privileges and roles
  • Installed and configured several Oracle products including, but not limited to, Oracle Enterprise Database 11gr2, 11gr1, 10g all releases , Oracle Exadata V1 / V2, RAC, ASM, OCS, and APEX.
  • Provided long term technical needs analysis of hardware, software, and business workflows in an effort to reduce administrative costs while improving overall internal and external Oracle Applications administration / development resource allocations
  • Provided management with high level technical and financial implications in an effort to reduce the number of resources for administration and development, while maintaining support for business growth and improving scalability, functionality, and performance.
  • Provided technical direction for several senior level Oracle DBA's, Middleware architects and Developers surrounding organizational needs and SOX compliance utilizing Oracle Identity Management integration with current databases , Sun ldap, MSAD, Oracle Applications, and web applications. Also managed projects which included long term proactive management, centralization of administration, and centralization of disaster recovery practices, centralization of Microsoft Active Directory / LDAP / Oracle Internet Directory, Oracle Names Server, and Enterprise User Security
  • Provided long term technical needs analysis of hardware, software, and business workflows in an effort to reduce administrative costs while improving overall internal and external Oracle Applications administration / development resource allocations.
  • Provided management with high level technical and financial implications in an effort to reduce the number of resources for administration and development, while maintaining support for business growth and improving scalability, functionality, and performance.
  • Oracle Internet Directory 10g / 11g integration with oracle Microsoft Internet Directory

Tasks Performed - OBIEE

  • Install and configure Oracle Business Intelligence Enterprise Edition 10 and 11 components.
  • Oracle HTTP Server 11g 11.1.1.3
  • WebLogic Server 11g 10.3.3
  • Oracle Business Intelligence Enterprise Edition 11.1.1.3
  • Oracle Identity Management 11g 11.1.1.3
  • Built Oracle Business Intelligence Metadata Repository.
  • Setup and configured connections to various data sources.
  • Built the OBIEE physical layers, business models, and mapping layers.
  • Utilized multiuser development environment including mapping logical SQL reference.
  • Installed, managed, and administered OBIEE processes and components.
  • Migrated OBIEE to and from Linux and Windows servers.
  • Administered OBIEE Publisher including
  • Security
  • Data Source Connections
  • Integration with other Oracle products
  • Report delivery options
  • Runtime configuration settings
  • Scheduler settings
  • System maintenance options

Tasks Performed - Oracle Analytics

  • Installed, configured, and integrated BI for several analytics modules
  • Monitor performance, analyze specific metrics, and compare them to budgets or performance benchmarks
  • Optimize the Supply Chain with Oracle Supply Chain and Order Management Analytics
  • Order Management Analytics Provided insight into critical Order Management business processes and key information, including Orders, Invoices, G/L Revenue, sales effectiveness and customer scorecards.
  • Order Fulfillment Analytics Provided complete analysis of every step in the back-office sales processes from Order to Cash, enabling companies to respond more quickly to customer issues and resolve them before they become problems.
  • Inventory Analytics Incorporated analysis of the inventory held by an organization, bill of materials, inventory movements in, out and through production or storage location, and understands customer and supplier returns. Optimized inventory levels, maximize customer sales through product availability.
  • Utilized Human Resources Analytics Dashboards
  • Utilized Oracle Supply Chain and Order Management Analytics Dashboards

Confidential

Senior Oracle DBA and Oracle Apps DBA / Technical Manager

  • Provided business to business technical team management of 14 senior level DBA's and 5 Application DBA's consisting of onshore and offshore resources. Assessed business needs analysis and coordinated resource allocations based on project requirements. Provided functional coordination and database administration on Oracle databases including load balancing of raid arrays, database installations and cloning efforts, Develop security policies and profiles, manage and support various development efforts, install, patch, upgrade, tune, troubleshoot and various other DBA functions surrounding Oracle's Database technologies and eBusiness suite.
  • Installed, migrated, and upgraded Oracle 9i, 10g, and 11g r2. Migrated / upgraded multiple db's ranging from .5tb to 8tb.
  • Provided database administration including RAC and Data Guard, backup and recovery functions using Oracle Recovery Manager, shell scripting, cron jobs for reporting, job execution, and backups.
  • Provided database administration for Sql Server 2005 and 2000 database engines using Server Management Studio for creating and managing databases, transaction logs and database snapshots. Provided security management login, database, and permissions , backup and recovery management, and automating tasks with jobs and alerts.
  • Provided project mgmt on a several development projects ranging from legacy system re-devel to web application development.
  • Provided build, support, and analysis of multiple Data Warehouse installations utilizing plsql, oracle forms, and oracle reports.
  • Provided business needs analysis for multiple groups within the organizations.
  • Worked with a number of contractors to satisfy projects requirements.
  • Allocated resources for multiple projects.
  • Provided support for 90 databases including 10 eBusiness installations in various operating systems, hardware, and environments including development, test, pre-production and production installations.
  • Developed system, network, and database design standards and documentation.

Confidential

Senior Oracle Applications and Database Consultant

  • Develop project plans, foreign systems integration plans, and resource allocation management
  • Analyze systems, database, and sqlnet performance statistics.
  • Analyze SQL calls to the production and development environments to support development staff.
  • Develop and implement Oracle disaster recovery plan
  • Maintain security profiles and Roles accessing the RDBMS
  • Perform database builds from system architecture through schema generation and data migration
  • Execute database schema migrations on all dev, test, cert and production environments.

Confidential

IT Director, Functional Oracle DBA / Apps DBA / Project Manager

  • Provided Oracle Database Administration and project management and resource allocation for database and network infrastructure related projects on UNIX and NT Platforms.
  • Managed development teams surrounding ERP, EBS, and EDI
  • Managed integration of all networking, telecommunication, server, and client hardware.
  • Installed, managed and supported all ERP systems and related industrial manufacturing process integration, process improvement, and work flow analysis.
  • Developed system rollout strategies, network topology strategies, disaster recovery strategies.
  • Managed enterprise server construction, systems integration, and database builds.
  • Coordinated support efforts in a client server environment for all critical business applications.

Confidential

Manager of Infrastructure and Database Integration

  • Supported production, certification, test, and demo databases for 14 hospitals, 9 labs, and multiple physician offices.
  • Maintained security, Oracle upgrades, and schema refreshes.
  • Developed and implemented backup and recovery strategies.
  • Optimized system performance at the OS and Oracle levels.
  • Worked with application developers on SQL tuning.

Confidential

Sql Server / Oracle / Microsoft Access Database Administrator

  • Built tables and migrated data from various foreign systems and databases including SQL Server, Access, DB2, Mumps, and COBOL flat file tables and arrays.
  • Aided with development of real-time foreign systems interfaces.
  • Planned and developed enterprise level backup and recovery strategies.
  • Allocated system storage, planned future storage requirements, and maintained system security.
  • Monitored performance and user access to the Oracle and SQL Server RDBMS.

We'd love your feedback!