SUMMARY

• 17+ years of experience from Finance to IT, working predominately with Oracle, Hyperion, SQL, Hyperion and all EPM related systems, including Essbase, Planning, Smart View, OBIEE and DRM technologies. This experience pool includes the position of General Ledger Accountant and special projects in the Finance department.
• Successful architecture and actual hands - on experience building multiple Oracle EPM Suite environments of various versions (9.3 to 11.1.2.4), with the inclusion of multi-module middleware, such as HFM, EPMA, Essbase, Planning, Smart View, FDMEE and Financial Reporting.
• This includes the installation and configuration of, and development in DRM 11.1.2.4 on a standalone and integrated server setup to manage metadata between all applications.
• Daily maintenance of environment builds, including all patching, bug fixes, infrastructure administration and server/network environment issues.
• First-hand experience working with Oracle Support to get assistance with undocumented software issues.
• Responsible for all Windows server environments, including the pre-setup before installation and the post monthly updates and future environment scope.
• Responsible for the database repository creation setup and maintenance of actual SQL Server 2008 and Oracle databases.
• Create databases, run scripts, create indexes, and monitor performance and remove locks that may occur from application administration side.
• Application development and administration experience with HFM, EPMA, Planning, Essbase, EAS, FDM, OBIEE, DRM, Smart View and Financial Reporting.
• I have a working knowledge in all these areas to help develop, administrate, test and support the finance team with all modules and applications to ensure goals, proper functioning and use.
• Extensive experience with performance tuning of all software modules (application and infrastructure configuration files), including IIS, Weblogic and Windows server registry settings for greater performance, task response times and overall throughput.
• Sox experience providing auditing policies and documentation for all Oracle EPM system and server changes. Built and maintained an actual DEV (multiple), QA, Disaster Recovery and PRODUCTION environment setup with policies created to properly promote new application work, patching, software version updates or other changes from DEV safely through QA to production.
• Strong background in finance and accounting, providing a ‘user’ perspective in the development of reports and applications, with the ability to understand and interact amongst all business groups.
• Experience in business and systems architecture with strong skills in data analysis, mapping and data mart modeling and the development of reporting applications using Brio/Hyperion (Interactive and Production Reporting, Dashboards, HFM, Financial Reporting, FDM, Essbase, Smart View, and OBIEE), SQR, SQL, PL/SQL, and JavaScript.
• Experience with new cloud technologies, such as the Oracle PBCS (Planning cloud solutions) migrating applications and data, and working with Oracle support to assist with implementation and troubleshooting issues.
• Commitment to the production of robust applications that can be easily maintained and updated.
• Strong self-discipline in the assessment and completion of projects in a timely manner, with the ability to work independently, as a team player, and a team lead.
• Management skills from Reporting and Technical Lead to Infrastructure Team Manager.

Areas of Expertise

• Oracle EPM (Hyperion) 11.1.2x Distributed System Management, Architecture, Infrastructure, Installation, Administration and Support (includes ALL Hyperion products, such as Shared Services, HFM, Financial Reporting, Financial Data Management, Planning, SQR, OBIEE, DRM, FDMEE and Essbase).
• JavaScript
• Unix, Perl, Windows and Python Scripting
• SQL Server Reporting Management Studio
• SQL Server Integration Services
• Oracle, SQL Server and DB2 Databases
• Smart View and Planning Forms
• Informatica PowerCenter ETL
• DataStage

PROFESSIONAL EXPERIENCE

Confidential

Hyperion Financial Architect

Responsibilities:

• Essbase and Planning installation, upgrade, application architecture and development in a Unix environment.
• Shared Services and Essbase security management and administration.
• Lifecycle Management Cycle of Planning applications migrations between environments.
• Essbase backups and migration of data.
• Oracle EPM environment tuning, troubleshooting and administration.
• Patching Oracle EPM environments with upgrades and bug fixes.
• Provide technical leadership to establish automation methodologies and processes.
• Ideate and design the Hyperion applications, reports, framework and automation scripts.
• Provide leadership in the creation of re-usable components in the Hyperion framework.
• Lead the development, implementation and maintenance of Hyperion Essbase, Planning, Financial Reporting and Shared Services modules.
• Responsible for the research and implementation of the applicable features of Hyperion automation in an agile environment.
• Participate in daily/weekly agile activities (scrum, stand-up, sprint development & testing activities) - prepared to take multiple roles within the Agile team.
• Participate in release planning, sprint planning and deployment.
• 9+ years of automation experience in a leadership capacity, high proficiency in Selenium/JAVA or other automation technologies.

Confidential

Senior Software Engineer/Hyperion Tech Lead

Responsibilities:

• Implementation, development and administration of multi module Oracle EPM 11.1.2.4 systems.
• Develop and administer DRM 11.1.2.4 applications on a separate on-premise server.
• Tune environment and troubleshoot all application related issues.
• Implementation, development and administration of Hyperion Financial Management, Planning, Essbase and HPCM applications.
• Documentation and communication of best practices for services and server administration for this Oracle EPM 11.1.2.4 environment.
• Train business users on how to use and perform some administration functions in HFM, Planning, Essbase, Financial Reporting and Smart View.
• Provide detailed ‘how to’ documentation guides on various applications and services.
• Assist with metadata creation and movement of metadata and data from UAT to DEV via the applications extract and import methods, as well as copy functionality and the LCM tool.
• Demo the Oracle cloud solutions, migrating the data from our current DEV environment to provide application for review by business.
• Planning administration to include changes in the dimensions, calculation manager business rules and scripts, and refresh database and security to update the Essbase cubes.
• Responsible for Hyperion Shared Services security, configure AD user security and groups and make changes to existing groups and roles.
• Maintenance of the DRM application metadata structures and workflows after initial installation and build.
• Patch Oracle EPM system applications and perform tuning tasks to enhance the Hyperion applications.

Confidential

Hyperion Technical Lead

Responsibilities:

• Development and administration of multiple Essbase and Planning applications.
• Tune environment and troubleshoot all application related issues.
• Review the entire system process flow with recommendations for changes to the current overall financial system, including SSIS packages and scripting.
• Install and administer DRM, followed by development work importing metadata from Planning, HFM, Essbase, EBS and other legacy data sources.
• Worked with the blender feature and creation of workflows in DRM 11.1.2.4.
• Managed the SQL Server side database along with writing SQL scripts to gather various data points.
• Work with SSIS packages, changing and developing steps and processes to achieve requested data flows.

Confidential, Houston, TX

Oracle EPM Infrastructure Architect

Responsibilities:

• Architect entire suite of environments with implemented change control and auditing procedures for better control and safety of environments, along with SOX auditing compliance.
• Technical Lead for other members of our Oracle EPM team.
• Mentored, researched and provided answers and support for application administration group, along with support for user side individual systems.
• Manage and administrate the Oracle EPM financial HFM, Essbase and Planning applications.
• Troubleshoot all errors related to the Oracle EPM Suite, both application and infrastructure side.
• Patch and upgrade all individual applications and related software.
• Create performance monitoring processes using various diagnostic tools to monitor systems on an application, user, server and network levels.
• Created and developed HFM, Planning, Essbase and DRM applications with full documentation for further training of business users.
• Extensive work with MyOracleSupport SRs for all technical related issues.
• Install and Configure Essbase Analytics Link for HFM, including user based training.
• Install and Configure DRM 11.1.2.3.3 and 11.1.2.3.4, latest patch version. Continued with development in DRM to manage metadata between all applications.
• Administrate the SQL Server database, writing scripts, copying and setting up new database for financial applications.

Confidential, Kansas City, MO

CONSULTANT

Responsibilities:

• New development of Interactive Reports with parallel modification and support of existing report structure.
• Create and modify customized interactive dashboard sections using extensive JavaScript code and procedures.
• Create training modules documentation of all work completed.

Confidential

Senior Business Systems Architect

Responsibilities:

• Lead internal business teams and customers to scope out specific work and steps involved to go from business need and conception to actual working end product to be delivered.
• Extensive research, mapping and technical documentation of all the specifics associated with each deliverable within a project.
• Author official requirements documentation, technical specifications, test plans and recommended user testing and training documents. ‘
• Conduct daily meetings with multiple teams involved in each project, along with initiate and manage all verbal and written communications between all internal and external teams.

Confidential

Hyperion 9.3 - 11.1.2 Infrastructure Architect and Support Consultant

Responsibilities:

• New net install and configuration of Hyperion 11.1.2.1 (all modules) on a Windows 2008 R2 64 bit OS with a SQL Server 2008 R2 repository and reporting database.
• Previously upgraded company from a 9.3.1 Shared Services and Reporting & Analysis Workspace only environment to a 9.3.3 better supported environment.
• 200+ Scheduled BQY reports migrated to vs 11 with focus on recreating reporting environment in OBIEE with more robust subject area reporting capabilities for user audience.
• Technical documentation of all work and services.
• Create training modules and conduct classroom/knowledge transfer sessions with multiple teams and key individuals as appropriated.
• Troubleshoot infrastructure issues relating to associated servers, the Hyperion software and compatibility between and within all Hyperion components.
• Daily administrative work with Shared Services and Workspace.
• Maintenance of start and stop scripts, log files, patch applications, etc.
• Regular development work in Hyperion IR, Essbase, Smart View, and Financial Reporting and Analysis.

Confidential

Senior Software Engineer/Database Reporting Architect

Responsibilities:

• Modify existing and create new more performance based queries in IR and on the backend of OBIEE.
• Liaison to multiple business user groups, analyzing and documenting database architecture and reporting requirements.
• Active role on the new data warehouse team to architect and develop robust and performance based data stores for future companywide business reporting.
• Analyze, streamline and document current and new IT to business processes.

Confidential

Senior Reporting and ETL Developer

Responsibilities:

• Responsible for support, troubleshooting, and production builds (full cycle of development work) of various reporting needs and data extracts, transformations and loads.
• Assist with Hyperion Foundation Administration setup and tasks.
• Responsible for training other team members and application users with reporting development and data management.
• Authored and published coding standards and other training manuals for technical and business audience.
• Requirements gathering with business groups for various reporting applications and other work streams to better manage data use.

Confidential

Hyperion Application Infrastructure Architect

Responsibilities:

• Responsible for all installations, maintenance and support of all Hyperion system 9 infrastructure and administration related issues, including Shared Services provisioning (migration tool and manual provisioning), Hyperion Financial Analyst, HAL and Essbase (all against Oracle 10g databases).
• Development work in all above mentioned tools, especially Essbase, HFM and Interactive reporting applications.
• Creation of various scripts, including Perl, to automate and monitor user and application processes.
• Started this position during the company-wide conversion from Hyperion Essbase to Hyperion System 9.
• Hyperion consultants were hired as needed to help with the original infrastructure architecture, implementation and first tier conversion of accounting systems and data.
• After original implementation was completed, I was responsible for the continual process of troubleshooting, researching and documenting all system related and user reported issues.
• Created and presented troubleshooting guide and user training manuals for power users and systems administrators at all other operation sites (this was a 24x7 mission critical business operation).

Confidential

Technical Lead - Report Application Development & Server Admin

Responsibilities:

• Responsible for multiple project management, assignment and supervision of resources to various tasks, troubleshooting of problem issues, and mentoring of other developers.
• Develop SQR Reports, BQY Reports, Dashboards, and complicated Application Development on a daily basis.
• This work requires a solid use and understanding of SQL, JavaScript, coding logic, DB2/Oracle database functions and strong database/SQL performance enhancement skills.
• Create and maintain a library of reusable functions, calculations and formats. Responsible for code review and report/design standardization and enforcement.
• Brio report development, including the creation of JavaScript and/or HTML pages for the application interface, passing of parameters to BQY queries via web browser.
• Java development (utilizing Versata development application) of application modules.
• Unix and Perl scripting for process automations.
• Detail design and requirements documentation.
• Integration and code version control (via StarTeam 4.2)
• Unit testing, enhancements and revisions.