We provide IT Staff Augmentation Services!

Oracle 12c Db Build, Hyperion Admin Resume

Charlotte, NC

SUMMARY:

  • Energetic, passionate leader with exceptional vision, and commitment that drives strategic growth, maximizes productivity and improves operational efficiency, while maintaining a positive organizational climate around team members and business customers.
  • Possessing an adept ability to design secure, complex OLTP decision and support systems across multiple data centers with a focus on high availability, reliability and scalability.
  • Architecting, deploying, managing and supporting global service delivery lines.
  • Developing and implementing innovative solutions in Oracle Hyperion architecture.
  • Creating and executing innovative and multi - faceted strategies.
  • Activating relationships that optimize collaboration & service delivery throughout cross-functional teams.
  • Providing technology leadership, training and mentoring
  • Building collaborative efforts with clients to identify needs/challenges and exceed expectations
  • Led the architecting, install and configuration of Oracle Hyperion EPM solution for Federal client
  • Led O&M activities for maintenance, automation and performance tuning of Hyperion Planning Budget and acquisitions system for Federal client
  • Directed the assessment, production deployment strategy and implementation of Oracle RAC, DataGuard, Oracle Database security (VPD, TDE and Database vault) and Goldengate Replication Product
  • Onsite Deloitte SME during install and configuration of Oracle GRC suite, AACG, CCG and PCG.
  • Led the deployment Oracle Hyperion 11.1.2.4 HFM and Essbase application suite for multiple client
  • Created framework and standards documentation for deploying the database technology in for State client
  • Successfully migrated and decommissioned over 50 non-production databases at wells Fargo.
  • Developed a new process to concisely communicate to the DBA team the functional overview, technical requirements and service expectations for new projects, which eventually became a part of the core services delivery.
  • Energized capacity planning efforts by developing new processes that support an agile, high availability, business ready and secure environment
  • Steered DBA Organization transformation efforts that led to better service quality, project delivery and turnaround.

CORE COMPETENCIES:

  • Operations Management Customer Relationship Management Problem Resolution
  • Capacity Planning Performance Optimization Process Management
  • Project Management Crisis Management Process Improvement

TECHNICAL EXPERIENCE:

Database Systems: Oracle RDBMS 7x - 12cR2

BI Technologies: Hyperion EPM, Oracle GRC, Oracle Access and Identity Management System

Big Data Technologies: Apache Hadoop, Splunk , Exadata

Replication Technologies: Oracle Goldengate, Oracle Streams, Oracle Dataguard

Operating Systems: IBM AIX, Sun Solaris, LINUX, MAC OSX, Windows

H/A and Virtualization Solutions: IBM HACMP Cluster, VERITAS Cluster, and Linux VMs, Oracle RAC

Tools: Oracle OEM, BMC Patrol, Oracle Spotlight, DBSPI, HP Openview, Precise, Oracle RMAN, Statspack, ADDM, AWR, Oracle Exp/Imp, Oracle Data Pump

Programming Languages: Unix Shell script, c, c++, c#, Java, PL/SQL

Project Delivery Tools: iWork Office Apps, Microsoft Office Apps

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle 12c DB build, Hyperion Admin

Responsibilities:

  • Onsite support for US Federal Department manufacturer in Silver Spring MD
  • Provided technical architecture design and documentation
  • Hyperion software install
  • WebLogic 11g install and configuration
  • Hyperion 11.1.2.4 components configuration
  • Hyperion patching to latest available patches for all components
  • Components included HFM, SOA, FCM, ARM, FDMEE, EAL, EAS, Essbase, HFR and APS
  • Set up external directory configuration with Open LDAP
  • Also set up ODI, Smartview and HFR studion
  • Complete build of DEV, QA and PROD environments on 3 nodes

Technical Environment: Hyperion 11.1.2.4, Weblogic 12.2, Linux and Unix, Oracle RDBMS 12c

Confidential, Charlotte, NC

Oracle 12c DB build, Hyperion Admin

Responsibilities:

  • Onsite support for large Electronics manufacturer in New York:
  • Provided technical architecture design and documentation
  • Hyperion software install
  • Hyperion 11.1.2.4 components configuration
  • Hyperion patching to latest available patches for all components
  • Components included HFM, SOA, FCM, ARM, FDMEE, EAL, EAS, Essbase, HFR and APS
  • Set up external directory configuration with Open LDAP
  • Also set up ODI, Smartview and HFR studion
  • Complete build of DEV, QA and PROD environments on 3 nodes

Technical Environment: Hyperion 11.1.2.4, Weblogic 12.2, Linux and Unix, Oracle RDBMS 12c

Confidential

Oracle 12c DB build, Hyperion Admin

Responsibilities:

  • Onsite support for large manufacturing company in Ann Arbor, Michigan:
  • Provided technical architecture design and documentation
  • Hyperion 11.1.2.4 software install
  • Hyperion 11.1.2.4 components configuration
  • Hyperion components patching to latest available patching
  • Components included HFM, FDMEE, HFR and APS
  • Also set up ODI, Smartview and HFR studio
  • Set up external directory configuration with Active Directory
  • Complete build of DEV, QA and PROD environments on 3 nodes

Technical Environment: Hyperion 11.1.2.4, Weblogic 12.2, Linux and Unix, Oracle RDBMS 12c

Confidential

Sr DB Admin

Responsibilities:

  • Supported state client pre GO - Live and infrastructure preparation.
  • 11gR2 databases created for DEV and Production
  • Oracle TDE (transparent encryption) configured
  • RMAN backup set up and configuration
  • RAC Dataguard active/active setup and configuration
  • OEM 12c install, build, configure and documentation
  • Production environment validation with SCESM compliance validation
  • DB performance troubleshooting and optimization to support multiple application deployments
  • Also provided high level documentation for installing and deploying 11gR2 RAC dataguard

Technical Environment: Oracle RAC 11gR2, Weblogic 12.2, Linux and Unix, OEM 12c

Confidential

Sr DB Analyst

Responsibilities:

  • Assisted client Federal Client with production database performance issues while client was unable to load client related data.
  • Also provided high level documentation for installing and deploying 11gR2 RAC and set up POC for Dataguard Physical standby.
  • Assisted client in troubleshooting SSO and OID config issues.

Technical Environment: Oracle RAC 11gR2, Weblogic 12.2, Linux and Unix, OEM 12c

Confidential

Sr Analyst, GRC and Weblogic support

Responsibilities:

  • I provided On-site and remote support to install and deploy Oracle GRC-PCG & AACG modules
  • Evaluated the GRC certification matrix for platform compatibility and EBS integration compatibility
  • Installed Oracle 11.2.0.5 database and Weblogic 12.2 Server for AACG, and Installation of AACG 8.6.5 module
  • Installed GRC PCG 7.3.3 on existing client's 12.2.4 eBS non production environment
  • Integrated the installed AACG and PCG with existing EBS
  • Supported the clients existing EBS environment and advised on best practices and performance tuning
  • Coordinated and worked with remote Deloitte GRC experts

Technical Environment: Oracle 11gR2, EBS R12.2, Weblogic, GRC AACG & PCG, Linux and Unix, OEM 12c

Confidential

Sr Analyst, DB performance and support

Responsibilities:

  • Served as Oracle RAC and DB Performance tuning expert responsible for validating the migrated 5 node RAC environment, knowledge transfer for best practice upgrade to Oracle 11gR2 (11.2.0.4), monitoring ALL test, QA, Dev and UAT RAC db environments for performance issues and immediately making recommendations to fix and remediate query performance and system bottlenecks.
  • Worked with application developers and BI team to identify and tune long running queries to run better than stand-alone source instance and meet client SLAs.
  • I utilized OEM 12c and other Oracle tools and features for monitoring and maintenance.
  • Performance effort resulted in significant improvement in query performance and overall system stability.

Technical Environment: Oracle 11gR2, EBS R12.2, Informatica, Linux and Unix, Oracle 11g RAC (2 node), OEM 12c

Confidential

Sr Analyst, DB performance and support

Responsibilities:

  • Served as Oracle RAC and DB Performance tuning expert responsible for monitoring ALL test, QA, Dev and Validation EBS db instances for performance issues and immediately making recommendations to fix and remediate query performance and system bottlenecks.
  • Worked with cross section of technical experts such as application developers, Sys Admins and Functional Application analysts to identify and implement best practice for Oracle db performance, identify top ten queries, I/O bottleneck and document these with recommended fixes.
  • Utilized OEM 12c and other Oracle tools and features for monitoring and maintenance. Performance effort resulted in significant improvement in query performance and overall system stability.

Technical Environment: Oracle 11gR2, EBS R12.2, Linux and Unix, Oracle 11g RAC (2 node), OEM 12c

Hire Now