Lou Angelo, MBA Philadelphia, PA

267-***-****

adjluy@r.postjobfree.com

Summary:

Motivated application developer of Oracle BI software with over twelve years of experience in designing, developing, testing, implementing and automating key business processes with a focus on master data and metadata management through Oracle’s Data Relationship Management (DRM). Technical Experience:

Main Product Suite/Versions:

Oracle Enterprise Performance Management 9.2, 9.4, 11.1.1.3, 11.1.1.4, 11.1.2.3, 1.1.2.4, (analysis of 11.2.1 upgrade performed but not implemented due to Oracle’s delay of both windows and Linux support). Infrastructure, Repositories, Data Sources and Servers: Microsoft SQL Server, Windows Server, Red Hat Enterprise Linux, Oracle Web Logic, Oracle Application Server, Oracle HTTP Server (OHS), Internet Information Services (IIS), Microsoft .NET Framework, Foundation Services.

Applications:

Data Relationship Management (DRM), Essbase Cubes (ASO, BSO and Hybrid), Planning (classic and EPMA), E-Business Suite (EBS), Financial Data Management Enterprise Edition (FDMEE), Hyperion Financial Management (HFM), Hyperion Profitability and Cost Management (HPCM), Oracle Data Integrator (ODI), Financial Reporting, Web Analysis.

Components/files/tools:

Substitution variables, Partitions (replicated, transparent and linked), MDX scripts, MaxL scripts, Calculation scripts, Web Forms, Business Rules, Shared Services, Integration Services, Provider Services, Essbase Analytics Link (EAL), User Defined Attributed (UDA), SmartView, Calculation Manager, Batch Processes, Windows Command Scripts (.cmd), batch files (.bat), Visual Basic Scripts (.vb), python (.py), Post Encrypted files (.mshs,

.mxls, .txts)

Experience:

Application Development Senior Advisor February 2020 - July 2020 Cigna Philadelphia, PA

DRM (Data Relationship Management) Development

● Development of DRM end-to-end processes to streamline current processes and the management of key dimensions and hierarchies across the US and Global businesses on larger projects with wider exposure to more areas of the business and company as described in the DRM development in my previous role.

● Development of a “self-service” repository of commonly-requested data to be routinely exported to a networked share drive with tiered levels of security to control the recipients of said data, setup utilizing a completely automated process.

Application Development Advisor February 2017 - February 2020 Cigna Philadelphia, PA

DRM Development

● Development of DRM end-to-end processes to streamline current processes and the management of key dimensions and hierarchies across the US and Global businesses, ultimately populating the Oracle General Ledger, Financial Management, Essbase, Planning, and other financial and non-financial systems o The overall objective of these initiatives is to save time and cost managing hierarchies for both current and new applications, while creating a central repository for financial or “analytic” master data.

● Replacement of multiple entry points where hierarchy and related information is stored and updated using DRM as a central repository or foundation that allows for hierarchy changes to be made once and then propagated to multiple systems. Setting up processes in this manner also ensures the validity of data across many systems.

● Utilized a combination of VBscript, batch scripts, windows command files, Oracle DRM script and WinSCP scheduled through windows scheduler to automate with alerts and attachments the movement of data and metadata.

● Other DRM activities: data integration. versioning strategy, validation, automation, migration activities, documentation and communications, monthly process management and dependency tracker. Oracle Managed Cloud Services (OMCS) to Oracle Cloud Infrastructure (OCI)

● Participated in the system testing of front-end applications related to DRM to identify and resolve issues related to the movement of the upgraded (back-end) hosted cloud infrastructure to ensure a clean cut-over for end users.

Vender Management – Oracle

● Submission and tracking of product and system Service Requests (SRs) and Request for Change (RFCs) for all products and environments.

● Discussion, planning and resolving issues related to minor software (Patch) upgrades to major 'dot' release upgrades.

● Complete infrastructure changes from on-premise servers to servers hosted by Oracle Managed Cloud Services (OMCS) to Oracle Cloud Infrastructure (OCI)

● Participated in bi-weekly meetings with our Oracle service manager to discuss the above items and track them accordingly, in addition to quarterly reviews of identified security vulnerabilities and performance measures. Agile – Scrum Master (Interim)

● Performed scrum master duties for the Hyperion team and all of its products and application in an interim capacity.

● Initially setup Program epics, features and user stories in ‘Rally’ to capture all of the existing and future development work for the team.

● Met with agile coaches, product owners and stakeholders to understand what is expected of the various agile team members and developed best practice guides and instructions accordingly. Senior Application Development Specialist February 2014 - February 2017 Cigna Philadelphia, PA

Source Control – SVN & Git

● To be in compliance with CIP (Cigna Information Projection) policies and standards, including the segregation of duties, we utilized Subversion (SVN) as a source control system (initially). o Setup the initial configuration of Subversion (the source control system) used to enforce the above mentioned policies and standards as our source control tool, as well as the installation, setup and usage documentation and training.

● Installation and migration from Subversion to GitLab once decommission of Subversion was announced. Hyperion Financial Reporting (HFR) Development

● Developed HFRs supporting Hyperion Financial Management, Hyperion Planning, and Essbase. o These reports utilized dynamic suppression, conditional formatting, specific user Point-of-View

(POV) population, calculations, dynamic formatting and user input to mirror existing Management Reports that existed prior.

Hyperion Modernization and Upgrade Project

● One of the lead participants in the complete Hyperion system overhaul and revamp project alongside several Accenture consultants. This included the evaluation of current Hyperion state to identify opportunities for optimization, clean-up, reduction of the application footprint and to address current pain points which produce the following opportunities for improvement;

● Reduced the application foot print – From 18 applications with 21 cubes (databases) to 9 applications and 12 cubes

Lead Hyperion Systems Analyst November 2013 – January 2014 Independence Blue Cross Philadelphia, PA

● Completed an upgrade of our Oracle EPM 11.1.1.3 system to 11.1.2.1, similar to the ones completed two years ago by a team of consultants, without any outside assistance. The products upgraded were: Oracle EPM Suite of Products, including Planning Applications, Essbase, Financial Reporting, Web Analysis, SmartView, Shared Services, WebLogic, and Oracle Data Integrator.

● Managed an end-user upgrade of Windows 7, MS Office 2010, and IE9 while concurrently completing the EPM system upgrade, to ensure present and future compatibility and utilization of new functionality.

● Developed a Segment Reporting Application database to enable advanced analysis for timely, accurate and efficient decision-making by upper management. Developed automated dynamic front-end reporting and analysis documents to provide additional insight into the various products, segments, and other dimensions. Senior Hyperion Systems Analyst November 2010 - November 2013 Independence Blue Cross Philadelphia, PA

● Managed a team of 5 Consultants, facilitated communication between Corporate IS, Informatics, Human Resources IS (HRIS), and Finance IS (FIS) departments through the entire system upgrade process (moving from Hyperion version 9.2 to 11.1.1.3) as well as the implementation of a new workforce planning system.

● Maintained current Oracle Data Integrator (ODI) processes to import various types of bottom-level data into our databases.

● Maintained Planning and Workforce planning dimensions, forms, substitution variables, calculation scripts, business rules, sequences, run-time prompts, and all security and access through shared services and Hyperion Planning.

● Installed SmartView on client PC’s through a mass radia deployment and trained financial planners on using this MS Office products add-in.

● Created a Project Portfolio Database to accommodate business needs by gathering data, which was shared over from the current databases and uploaded by planners. Created financial reports and web analysis documents to be reported out of this database as well.

● Managed end-user training and support by developing tutorial documentation utilizing screen shots as well as recorded screen capture software with voice over instructions of the many processes required by the end users to properly perform their job functions.

Business Analyst January 2008 - October 2010

Temple University Health Systems Philadelphia, PA

● Developed new database system outlines and applications (cubes), maintained and enhanced existing outlines and applications in both Essbase and Hyperion Planning databases.

● Created complex reports, in addition to books and batches of reports, using Hyperion Reporting Studio.

● Created Planning Forms for end users to input data into the forms themselves, or alternatively, into Excel, which was then linked to the forms through Hyperion SmartView.

● Developed a Variance Analysis Tool in Hyperion Analyzer to report traditional straight line variances of budget minus actual as well as flexible variances which showed what various portions of the variance were due to; volume variances, rate/cost variances, and efficiency variances based on different driver statistics for various departments. This tool also allowed for “Drilling-through” to details held in various SQL server databases such as Accounts Payable, General Ledger and Inventory systems. Education:

LaSalle University - 2006

MBA in Management Information Systems

Catholic University of America (CUA) - 2004

BA in Business Financial Management

Contact this candidate