OBJECTIVE:

Seeking a Position in Hyperion EPM Solution Design and Implementation of both new Installation and Upgrades including Migration to new Infrastructure and Platforms.

SUMMARY OF QUALIFICATIONS:

• Seventeen years of IT experience including fourteen years of experience managing the Oracle Hyperion EPM Suite of Application.
• Managing the Implementation of new installation and Upgrades of existing Hyperion EPM Environments - version 9.x and version 11.x for a Huge and Complex Highly Available Windows and Linux (Exalytics) Environments.
• The Implementation of the Highly Available Environments were done on a single WebLogic Home, a Single Reporting and Analysis Repository Home and with a common instance of the epmsystem Home to facilitate Application Migration.
• Maintaining and Supporting the Hyperion Technical Infrastructure both Hardware and Software
• Coordinating Infrastructure activities with other teams including the Windows Server Engineering Team, the Storage Team, the Security Team, the IPAM, the Application Deployment Team (Web sphere, WebLogic, etc), the Packaging Team and the Citirx Server Team.
• Coordinate and plan with other teams all outages especially during the implementation of Microsoft Security Patches and other Hyperion Patches and Service Fixes.
• Coordinating supporting issues with the vendor (Oracle), creating service request during critical month end close periods to avoid downtime.
• Hyperion Financial Management and Administration, Hyperion Planning and Implementation and Hyperion Essbase Development.
• Managing the following tasks - Consolidation, Reporting and Analysis, Planning and Forecasting as well as Business Strategy using the following tools
• Managing and Maintaining Hyperion EPM Systems version 9.x and version 11.x in an HA Environment
• Experience with Hyperion Applications Particularly Consolidations, Budgeting Planning and Global Chart of Accounts.
• Experience implementing Confidential and Essbase System 9.x and Hyperion System 11.x
• Other Confidential Applications will include Hyperion Analyzer and Web Analysis, SmartView, Hyperion Reports, Essbase Add-In,etc.
• Assist in the Support and Maintenance of the Server health of Confidential, Planning and Essbase Systems.
• Maintain and synchronize the Hyperion development environment to mirror the Hyperion production environment.
• Troubleshoot and resolve Confidential and Upstream user questions and issues where possible and work with the IT department to address issues that might require joint attention.
• Assist in training and developing less experienced system administrators/analysts.
• Document and maintain operational support procedures, coordinate and liaison with the 24 X 7 IT Operations staff.
• Over 3 years’ experience in database and data management processes including development using Oracle architecture, database security, database design and creation using the Entity-Relational model
• Experienced in graphic design, spreadsheet and word processing software
• Demonstrate Resource Management Techniques such as Memory, CPU, Disk input/output, SQL Statements, TKPROF utility, RMAN, Statspack, etc.
• Analyze commands used in gathering statistics e.g. the ANALYZE COMPUTE Command.
• Managing medium and large databases from 100 Confidential or more and exposed to Real Application Clusters and Oracle Parallel Server
• Knowledgeable in backup and recovery, and demonstrate the effective use of tools associated with Backup and Recovery.
• Understand and identify efficient coding practices to aid in performance and tuning.
• Checking nightly, weekly and monthly statistics to stay proactive with my environment by using well tested scripts to gather critical statistics thus looking for objects that break rules.
• Trained In Computer Software Management - Oracle Relational Database Management Systems and expose to other Software Management Engines (Sybase, Informix, SAP, DB2, SQLDBA, etc.).
• Bilingual - Able to express myself in English and French

COMPUTER SKILLS:

PROGRAMMING LANGUAGES: SQL, PL/SQL UNIX, Linux, Java, C, C++, HTML, XHTML, XML, DHTML, JavaScript, VBScripts, etc.

DATABASE: SQL 2012, SQL 2008, ORACLE 12C, ORACLE 8/8i/9i, Sybase, Informix, SQLDBA, etc.

OPERATING SYSTEMS: Windows 2012, R2, SP1; Windows 2008, Windows XP, Windows 2003 Server, UNIX, Linux Sun Solaris, etc.

SOFTWARE APPLICATION DEVELOPMENT: Oracle Hyperion EPM version 11.x and version 9.x Oracle Enterprise Manager-OEM (Oracle Diagnostic Pack, Oracle Tuning Pack, Change Management pack), Microsoft Word (all versions), Microsoft Excel, Word Perfect (all versions), Microsoft PowerPoint, Web Page Design and Development, TSREORG, Lotus notes, PC Anywhere 32, Telnet, TCP/IP.

BACKUP SOFTWARE COMPONENT: Backup Server SGI Origin 3000 SERVER Dick Storage SGI TP95000 Raid Arrays (Developed by LSI Storage systems) Tape Storage 48 Storage Tek T9940B Tape Drives and PowderHom 9310 Library SAN Infrastructure Brocade Family of SilkWorm 2. Confidential Fibre Channel Switches Backup Application LEGETO NetWorker 7.0

HARDWARE: Compaq ProLiant 5500, RISC/SYSTEM 6000, HP 2000, SPARC CENTER 5000, SUN OS

WORK EXPERIENCE:

Confidential

Sr. Staff System Administration Engineer

Responsibilities:

• Leading a team of Eight members in the Management of the Hyperion EPM/FCM and DRM Environments running on Oracle Exalytics and on Windows Infrastructure.
• Managing and Leading all Deployment activities (Installation, Configuration) of the Hyperion EPM, Confidential, Planning, Essbase, FCM and DRM Environments Version 11.1.2.4.x and also leading all support activities.
• Coordinate with the Database Teams to define how each Deployment will be implemented in these EPM/FCM and DRM Environments.
• Managing the shared platform to maintain all Confidential Subsidiaries Financial Systems - Confidential Corp has about 32 Hyperion EPM Environments to provide services for Confidential Subsidiaries to run their Financial Applications.
• Lead the maintenance of Hyperion EPM Platforms, including Patching and Upgrades, Migrating the Apps from DEV to QA and then Production.
• Oversee or lead all daily issues in DEV, QA and PROD by assigning more critical tasks of members depending on how severe the issue is and the level of expertise of the team member.
• Upgrade Hyperion Applications for all Confidential Sub Businesses from Confidential Private Cloud - version 11.1.2.3.500 to on Premise Exalytics 11.1.2.4.200
• Lead the Patching of the different releases and Testing in the Lab and if everything goes well the same Patch will be applied in DEV, QA and PROD.
• Managing Bi-Weekly and Monthly server reboots and perform final validation of all the Apps to make sure everything is running as expected.
• Working with Oracle Support and Development Teams to Manage all existing SRs, scheduling weekly calls to go through the SRs and to make sure the issues are resolved.
• Assist in the Oracle Database Migration from Oracle 11g to 12c Exadata Environment by making sure all the EPM Apps are stopped during the DB Migration.
• Lead all Hyperion EPM Performance Tuning activities, making sure all the tuning parameters and settings especially the JVMs and the DataSources in Weblogic are tuned to some Oracle recommended values.
• On the DRM front, lead all Upgrades and Migration to version 11.1.2.3.344 on windows 2012 machines, applying all the repositories updates, also performing the DRM Analytics and Web Services API for Confidential Integration.
• Lead the same Upgrades and Migration activities in the Confidential /Essbase and Planning Environments.

Confidential

Sr. Hyperion EPM Technical Architect

Responsibilities:

• Managing the installation, Configuration, Deployment and Setting up of Hyperion EPM environment both version 9.x and version 11.x
• Experienced on various Hyperion products such using Essbase Analytic Services version 11.1.2.1 or 9.3.x, Hyperion Planning, Hyperion Financial Management, Hyperion Financial Data Quality Management, Hyperion Shared Services version 9.x or 11.x, Hyperion Interactive Reporting, Financial Reporting Studio, Web Analysis, Smart View, Essbase Query Designer on Windows and Linux environments.
• On the Confidential front apply the most recent Confidential patches once issues are identified. Most of the times work very closely with the Oracle Support and Development Teams to make sure most of the we address some ongoing issues. Perform Bi-Weekly and monthly service restarts of Confidential especially prior to month end close for a smooth close.
• Housekeeping of Confidential Audit tables to avoid performance issues Work with the business to make sure all Metadata and Data Loads are successful as well as managing different versions of Metadata for a successful Consolidation.
• Developing integrated projects management plans, managing deadlines and dependencies across initiatives, and coordination of project team activities. Performing Migration between different Environments and Upgrades between different Versions including Lifecycle Management Utility in version 11.
• Worked on Hyperion Planning projects to create EAS applications, EAS security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users, user groups and their security rights.
• Providing technical support on all Hyperion EPM consolidation, Reporting and Planning tools which includes Confidential /FDM, Hyperion Reports, Hyperion Workspace, Hyperion Web Analysis, Smart View and Essbase Excel Add-In.
• Coordinating Infrastructure activities with other Infrastructure teams during the installation of the Hyperion EPM products, especially the windows server team.
• Creating and maintaining Client Reporting packages and tools to facilitate financial reporting for all the application teams which includes: Hyperion Reports, Hyperion Smart View, Essbase Excel Add-In and the Web Client (Hyperion Workspace).

Confidential, Phoenix, AZ

Sr. Confidential Systems Administrator/Developer

Responsibilities:

• Responsible for consolidation and international accounting IT systems maintenance and support.
• Supervise and/or assist with certain aspects of the monthly close process and other division oversight responsibilities
• Perform Hyperion Financial Management ( Confidential ) Administrator duties including maintenance of metadata and rules.
• Participate in monthly close process including extraction and validation of data from/to the SAP general ledger systems for Actuals, forecast and budget reporting.
• Maintain multiple sources to Hyperion account mappings used in conjunction with Confidential .
• Maintain Access databases used to support the administrator function and to assist users;
• Create and maintain Hyperion reports as well as facilitating ad-hoc reporting requests;
• Load of monthly supplemental data via Hyperion Smart View;
• Preparation and revision of Microsoft Excel/VBA based tool used for the collection of actual, forecast and budget data for non-SAP entities.
• Assist in upgrade of Confidential applications to System9. User support, training and setup (security maintenance);

Confidential, Milwaukee, WI

Confidential Administrator/Developer

Responsibilities:

• Ensure overall system stability of the Hyperion Financial Management ( Confidential ) and Upstream Financial Management Applications.
• Coordinate with IT staff and functional end-users to provide Level 3 support for the Hyperion 9 suite of applications.
• Manage and maintain the Confidential and Essbase Systems 9 and earlier versions, multiple environments and versions.
• Creating an Outline from scratch, using either the block or the aggregate storage options.
• Strive for performance by optimizing the Dimensions making them dense or sparse.
• Creating load rules, calc scripts and member formulas for the Essbase databases.
• Develop and maintain all technical aspects of the Confidential Application which includes constructing metadata changes, maintenance of application structures, loading and extracting data, creating and loading journal entries, maintaining member lists, opening and closing periods, adding periods to the control periods, and creating import scripts
• Develop logic and methodologies for mapping tables, loading data, designing logic groups, rule changes, grid development, and object maintenance
• Build and modify complex reports and create reporting solutions for global users Proactively review application design and make recommendations for design enhancements
• Oversee and manage application security Manage user acceptance testing in support of new software developments and fix any identified bugs.
• Document complex system functionality, illustrating support for business processes; Document changes to the business processes as they are introduced
• Develop and update training documentation Serve as the top technical expert and first point of contact for all world-wide Confidential and Upstream user queries; assist users with mapping questions/issues regarding ICP and custom dimensions
• Troubleshoot and resolve Confidential and Upstream user questions and issues where possible and work with the IT department to address issues that might require joint attention Assist in training and developing less experienced system administrators/analysts

Confidential, Milwaukee, WI

Oracle Database Administrator

Responsibilities:

• Manage different database software and application on several platforms.
• Experience with Medium to large databases from 100 Confidential or more.
• Experience with Real Application Clusters (RAC) / Parallel Server.
• Experience setting up hot standby databases, replication agreements, Oracle Streams.
• Responsibilities also include fault monitoring and management, troubleshooting, analysis and database change management.
• Monitoring database performance and perform required tuning, manage space utilization, perform backup and recovery procedures, verify utility outputs and also perform the installation of patches and upgrades. (Upgrading Oracle 8.0.5 to 8.1.6 and then migrate Oracle 8i boxes to 9i).
• Implement some vigorous tools like the OEM and its console, RMAN; use NETWORKER and ADMS for backups.
• Implementing real space management issues and the use of third party tools - TUNING PACK, DIAGNOSTIC PACK AND CHANGE MANAGEMENT PACK with their associated products.
• Other tools include STATSPACK AND AMBAQUEDERO, all from the OEM CONSOLE Configure Oracle8i and 9i databases.
• Currently working on different projects with Oracle 8i and Oracle 9i