Post Job Free

Resume

Sign in

Financial Systems Manager (Oracle/Hyperion)

Location:
Brandon, FL
Posted:
March 01, 2024

Contact this candidate

Resume:

Adeleye Odunfa-Jones

727-***-****(cell) ~ ad31en@r.postjobfree.com

SUMMARY:

Highly motivated and productivity-driven financial systems Manager/Developer/Administrator with extensive financial reporting, systems design, development and management experience. A determine and creative experienced systems manager, proficient in developing, implementing and managing Hyperion EPM suites, Oracle applications (On-Premise and Cloud), ETLs, managing junior developers, managing data transfers, and facilitating ongoing system improvements and projects. Excellent communication skills and professional demeanor obtained through extensive interaction with Corporate Executives.

16+ years of IT experience. 10+ years of managing Hyperion and Oracle Products, and 5+ years of managing FTEs (Analysts, Developers and Program Managers) and Contractors.

AREAS OF EXPERTISE:

Project Management (Agile and Waterfall)

Operations Management

Enterprise Systems Transformation

Oracle Applications Development and Automation

Hyperion EPM Implementation (On-Premise and Cloud)

ETL/ELT and Reporting Applications

ERP Systems Integration

Cloud Architecture (IaaS, PaaS & SaaS)

Continuous Process Improvement

Leadership and Team Building

TECHNICAL ACUMEN:

Programming Languages: SHELL SCRIPTING, SQL, JAVA, NJSON, PL/SQL, Python

OS & Database: Unix, Linux, Windows, Oracle 9i, SQL Server (2008+)

ERPs: SAP, PeopleSoft, EBS, Workday

Cloud Architecture: IaaS, PaaS, SaaS

Development tools: DRM, EAS 11.1.1+, SQL Developer, Teradata, FRS, NODE.JS, GITLAB

ETL/ELT tools: ODI, FDMEE, PL/SQL, EDMCS, OIC

Reporting Tools: EPM pods (FCCS, EPBCS, Essbase), SmartView, Tableau, OBIEE, Power BI

Project Management, Methodology, Processes, and Rules: Agile, Software Development Life Cycle (SDLC), Application Lifecycle Management, Change Management Process

WORK EXPERIENCE:

BON SECOUR MERCY HEALTH – Remote (Tampa, FL)

Manager – Financial IT Systems.

(May 3rd, 2021 to February 22nd, 2024 )

Managed both on-prem Oracle EPM applications and EPM Cloud pods for FP&A and Accounting Reporting department.

Provided strategic direction, leadership and technical oversight for management and individual contributors on achieving team, department, and organization financial systems goals.

Ensured the data, metadata and performance on the EPM Cloud (FCCS, EPBCS and Essbase) pods along with the on-prem applications are accurate, efficient and accessible.

Managed the Financial System architecture project of transforming current On-prem Oracle EPM applications and servers to EPM Cloud Pods (SaaS).

Managed all Financial Reporting Systems improvement projects using Agile methodology.

Deep knowledge of Oracle On-premise and Cloud EPM applications architecture which consist of FCCS, EPBCS, Essbase, EDMCS, EBS, Integrations, Automation along with Power BI, OBIEE and SmartView.

Ensured integration of quality performance, enhancements, and improvements on processes and tasks within applications and servers.

Took initiatives to step outside technical domain and take the voice of end-users as input into direction setting and decision making.

Managed a team of 5 FTEs that are SMEs on EPM, Power BI, Reports Development and Training

Coached and mentored direct FTEs on improving their careers, skillsets and upholding company’s objectives and goals.

Remained focus and up to date on key technology and industry trends.

INFOSYS LIMITED – Tampa, FL

Systems Manager – Technology Solution.

(December 31st, 2018 to May 28th, 2020)

Managed the Event Streaming Processing (ESP) systems along with the LINUX development server and ETL (ODI & PLSQL) systems that supported Verizon FP&A and Accounting users.

Managed and resolved all technical ESP issues within database, ETL (ODI, FDMEE, PLSQL), Hyperion EPM and reporting applications (OBIEE, Hyperion Essbase and Planning/EPBCS, HFM/FCCS) reported by users and/or management.

Designed and maintained the EPM suite data load, rules, automation (Task Flows) and metadata using the utilities (Dimension Library, LCM and EPMA File Generator).

Led and delivered Oracle Hyperion applications implementation, upgrade and deployment both on-premise and Oracle cloud.

Developed and performed code analysis on DEV, SIT, UAT and STAGE environments configuration and business process changes resulted from BAU request or upgrades.

Applied enterprise and technical wide thinking to department request for IT and reporting investments that ensured end-to-end process and data integration were accomplished.

Partnered with Architecture and Database Team (Infosys & Verizon) to assess how technologies can best streamline processes and add business value.

Managed a team of developers and outsourced resources to metrics on a global scale.

Created test plans based on critical business and functional requirements from senior management, and delegated test plan tasks to developers for execution.

Managed all issues during test plans execution in Non-Production environment and ensured issues were resolved in a timely fashion before deploying to production.

Remained focus and up to date on key technology and industry trends.

VERIZON CORPORATE OFFICE – Lake Mary, FL

Systems Manager – Technology Solution.

(September 2016 to December 2018)

Managed Verizon Corporate Performance Managements (CPM) systems along with various reporting and ETL applications that supported FP&A and Accounting users.

Managed IT solutions and ensured they met the business needs balanced with a pragmatic and integrated approach to the design of technical solutions.

Monitored and resolved all technical Access Lines data issues within Database, ETLs and Reporting applications reported by FP&A and Accounting users.

Provided assistant in resolving escalated and/or high priority technical issues on Essbase cubes, ERPs and reporting tools (Hyperion Planning/TM1, OBIEE, Smart view and HFM/FCCS).

Liaised with database team on installing AWS Management console and LAMP server using Amazon Linux.

Ensured that the Amazon EC2, S3 and RDS were installed and configured properly that allowed the Docker container, Object Storage and Oracle Relational database usage successfully.

Designed and integrated the ERP systems (SAP/EBS) with EPM applications using backend server scripts.

Managed various lines of business projects pertaining to process and systems improvement using Agile/Sprints methodology.

Gathered users process improvement requests and translated them into technical codes and programing languages for implementation team to execute in DEV, UAT and Production.

Partnered with database team to identify and resolve escalated database and server issues.

Functioned as a single point of contact or SME for business users on CPM and PMR architecture including Access Lines production related support and maintenance issues.

Developed and maintained Oracle Hyperion Essbase Cubes (BSO) for Access Lines (Broadband & LD lines) data that feeds CPM tables and cubes.

Delegated low priority changes and troubleshooting tasks to junior Analysts.

Led and managed resolution action steps among teammates for all escalated or priority issues/requests.

BLOOMIN BRANDS, INC – Tampa, FL

Hyperion Essbase Developer III (IT Systems).

(October 2015 to July 2016)

Developed and implemented Oracle Hyperion Essbase Cubes (BSO & ASO) for finance groups.

Designed, Implemented and maintained Hyperion EPM suite applications (Planning and HFM) and automated tasks using Task Flows for FP&A end-users.

Responsible for migrations of UAT environment signed-off data into production environment.

Applied performance tuning and optimization on applications for faster data loads, better calculation times of the cubes (BSO & ASO) and faster retrieval of reports using the Dense/Sparse, Cache, and Outline formulas settings.

Developed and managed hierarchy changes on all dimensions and members as well as updating calc scripts, business rules, web forms and reports according to change request from end-users.

Designed and developed MAXL, Batch, and PowerShell scripts with combination of Oracle SQL queries routine tasks like data export/imports, scheduling jobs on server, backups and purging app/server logs.

Performed infrastructure support including server maintenance like File system space management, moving Backups to staging server, Exports and OS patches on multiple servers.

Functioned as a single point of contact or SME for clients on all production related support and maintenance issues.

Assigned and delegated BAU changes and migration tasks to junior developers from development to UAT environment.

Managed and approved junior developers and Contractors development works before migration into production.

METLIFE, INC – Tampa, FL

Senior Technology Liaison (Hyperion/Oracle).

(October 2011 to October 2015)

Developed and implemented Oracle Hyperion Essbase Cubes (BSO & ASO) for Reporting and Executive groups.

Designed and developed financial hierarchies and information structures for Essbase and Planning through Hyperion DRM Administration Console.

Created and released various financial reports from Essbase cubes into IBM Cognos Executive Viewer web client and SmartView for accounting end-users.

Assisted, troubleshoot and trained end-users on Essbase Excel-addins, SmartView, Planning and Executive Viewer.

Created all user-guide documents for Essbase Cubes and IBM Cognos Executive Viewer.

Designed and implemented shared drives, folders and FTP connections within one or several severs for data exporting and importing.

Simultaneously managed multiple projects using waterfall, encompassing resource management and activities coordination, while guaranteeing smooth flow of operations on all my assign processes.

Redesigned the Constant Currency Essbase cubes that generated calculated constant rates data for international and domestic reporting.

Designed and implemented multiple automated cube processes applying data file MAXL, BATCH and POWERSHELL scripts techniques to generate end-results.

EDUCATION:

University of Phoenix – Tampa, FL

Master of Information Systems – Information Technology

2005 - 2007

University of Illinois – Springfield, IL

Bachelor of Business Administration – Accounting and Management

1999 - 2003

-Collegiate member of the University of Illinois Alumni Association

CERTIFICATE & TRAINING:

Oracle University – Online

EPM Cloud FCCS Implementation (Certification-in-Progress) (2024)

Oracle University – Online

Hyperion Data Relationship Management Administration (DRM) (2013)



Contact this candidate