System Administrator Data Quality
Resume:
Sarah M. Ibison
Houston, TX 77071
********@*****.***
Summary
Fourteen years of experience building financial consolidation systems in Hyperion Financial Management, importing diverse data sources through Hyperion Financial Data Quality Management, managing metadata through EPMA and DRM, and designing financial reports in Hyperion Financial Reporting Studio. Able to grasp new technologies and adapt to new challenges quickly. Experience in gathering requirements from system end users, bridging the gap between finance and IT departments, and providing hands on user training and user documentation.
Knowledge
•Technologies: Oracle Hyperion Financial Management (HFM) up to version 11.2, Oracle Enterprise Performance Architect Management (EPMA) up to version 11.1.2.1, Oracle Hyperion Financial Data Quality Management (FDM and FDMEE) up to version 11.2, Oracle Data Relationship Management (DRM) up to version 11.2, Oracle Hyperion Financial Studio (HFR) up to version 11.2, VBScript, SQL
•Functional Expertise: Custom Application Development, Financial Consolidation, Financial Reporting, Data Management, Metadata Management
•Industry Expertise: Oil and Gas, Aerospace and Defense, Telecommunications, Consumer Packaged Goods
Work Experience
Oracle Hyperion Lead System Administrator
Southwestern Energy, Houston, TX November 2011 – December 2014, September 2015 - present
•Primary system administrator for HFM, FDM, DRM, and HFR; secondary administrator for Planning and Essbase
•Performed routine system maintenance for HFM financial consolidation application such as metadata updates, rules changes, etc
•Maintained metadata for all Hyperion systems through DRM
•Maintained data loads for all Hyperion systems through FDM
•Built and maintained reports in FRS
•Built a second HFM application to handle the processes of an overwhelmed Essbase cube to provide G&A allocations for the company
•Built a third HFM application to house historical data to allow the retirement of an old reporting system
•Enhanced FDM loads to and between Hyperion systems, providing lights out and on demand load capabilities
•Developed new HFM functionality as requested by users, such as automated cash flow, new KPIs and converting Excel-based reports into HFR reports
Oracle Hyperion Contractor
Total Safety (part time off hours), Houston, TX September 2015 – May 2022
Primary system administrator for HFM, FDM, HFR, Planning and Essbase
•Performed routine system maintenance for HFM financial consolidation application such as metadata updates, rules changes, etc
•Performed routine maintenance for planning application such as metadata updates, script changes, etc
•Maintained data loads for all Hyperion systems through FDM
•Built and maintained reports in FRS
Oracle Hyperion System Administrator
Total Safety, Houston, TX December 2014 - September 2015
Primary system administrator for HFM, FDM, HFR, Planning and Essbase
•Rebuilt a failed HFM application
•Performed routine system maintenance for HFM financial consolidation application such as metadata updates, rules changes, etc
•Performed routine maintenance for planning application, such as metadata updates, script changes, etc
•Built and maintained data loads for all Hyperion systems through FDM
•Built and maintained reports in FRS
Oracle HFM Architect
Hitachi Consulting, Houston, TX August 2004 – November 2011
•Performed multiple installations and configurations of HFM, EPMA, FDM, and HFR
•Performed multiple upgrades of existing instances of HFM, EPMA, FDM, and HFR
•Implemented and configured the internal instances of HFM, EPMA, FDM, and HFR for Hitachi Consulting’s finance team
•Facilitated requirements and understanding between financial end users and IT system administrators for numerous companies
•Created and delivered technical training and documentation for system end users and IT departments
Project Experience
Oil and Gas Company
Lead Developer, Hyperion Upgrade April 2011 – November 2011
•Migrated five HFM applications from 9.3.1 to 11.1.2.1
•Upgraded one of the HFM applications from classic to EPMA-enabled
•Replaced existing ODI data load processes with FDM and automated batch loading of the data
•Coordinated user acceptance testing and migrations between environments
•Technologies: HFM 11.1.2.1, FDM 11.1.2.1, HFR 11.1.2.1
Consumer Packaged Goods Company
Developer, HFM and Interim Mgmt Reporting Build June 2010 – March 2011
•Configured FDM for current data loads
•Oversaw report design team
•Gathered requirements for and designed approximately 40 reports
•Wrote logic to perform a variety of financial operations
•Technologies: HFM 11.1.2, FDM 11.1.2, HFR 11.1.2
Bank
Developer, Hyperion Upgrade April 2010 – June 2010
•Gathered requirements for and implemented upgrade from HFM 4.1 to HFM 11.1.1.3
•Gathered requirements for and configured security for Hyperion products
•Migrated two HFM applications and approximately fifty HFR reports to the upgraded system
•Documented in detail the advantages of implementing FDM
•Technologies: HFM 11, HFR 11
Consulting Firm
Lead Developer, Internal – HFM Implementation July 2009 – April 2010
•Gathered requirements for, designed, and implemented a consolidation system
•Gathered requirements for data loading and configured Financial Data Quality Management
•Wrote logic to perform a variety of financial operations
•Oversaw the creation of approximately 25 standardized and customized financial reports
•Educated and trained clients to use system
•Technologies: EPMA 11, HFM 11, FDM 11, HFR 11
Oil and Gas Services Company
Developer, Consolidation Close Reporting and MDM September 2008 – July 2009
•Gathered requirements for, designed, and implemented a consolidation system
•Wrote logic to perform a variety of financial operations
•Oversaw the creation of approximately 30 standardized and customized financial reports
•Technologies: HFM 9.3, FDM 9.3, HFR 9.3
Oil and Gas Drilling Company
Report Writer, Enterprise to Hyperion Finance January 2008 – February 2008
•Created approximately 20 standardized and customized financial reports
•Technologies: Hyperion Financial Studio 9.2, Essbase 9.2
Title Guaranty Company
Report Writer, Profit Center Application and Planning April 2007 – September 2008
•Created over 60 standardized and customized financial reports
•Performed data translation and loads
•Performed database maintenance and structure changes
•Technologies: HFR 9.2, HFM 9.2, FDM 9.2, Essbase 9.2
Education
•Bachelor of Business Administration, Information and Operations Management, Texas A&M University at College Station, May 2003, Cum Laude
•Master of Science, Management Information Systems, Texas A&M University at College Station, May 2004
Contact this candidate