Mark Vignovich

980-***-****

adc3b2@r.postjobfree.com

SUMMARY:

●Senior consultant with a deep knowledge on both sides of the business intelligence equation Technical and Functional that has excellent design and problem-solving skills.

●21 years of experience including analytics, management, tax and consolidation accounting on the business side and Oracle’s Hyperion suite including Planning (on premise and PBCS), Essbase, Financial Management, FDMEE, Smart View along with training in ODI and DRM as well as SQL, VBA and other advanced Microsoft skills.

●Specialty skill include Object Oriented Synthetics, that he devised, which are a very valuable aid for designing, re-designing, integrating and troubleshooting applications.

EDUCATION:

●Robert Morris College – Coursework towards Master of Science, Taxation -1992

●Robert Morris College – CPA Review Course - 1992

●Clarion University of Pennsylvania – Bachelor of Science Business Administration, Accounting (Magna cum Laude), PA Institute of CPA State Scholarship Contest (Honorable Mention) - 1989

●The School of Computer Technology – Technical Diploma, Computer Programming Concepts (9 Month Program) - 1984

OTHER PROFESSIONAL TRAINING:

●Public Sector Planning and Budgeting

●DRM Administration

●Oracle Data Integrator

●HFM Business Rules

●SAP ABAP Overview and ABAP Objects Overview

●HFM Administration and Development

●Hyperion System 9, Hyperion Planning System 9, Hyperion Essbase Calc Scripting

●Hyperion Web Analysis, Hyperion Financial Reporting Tips and Tricks

●Essbase Aggregate Storage Option

●Cognos Report Net Metadata I and II

●Java

●C++

●Visual Basic 4

●Programming in C

●Schlumberger Field Engineer Program (6 months)

●FDIC Professional Mentoring

ENTERPRISE PERFORMANCE MANAGEMENT (EPM) EXPERIENCE:

●Hyperion Essbase - (21 yrs.)

●Hyperion Planning - (14 yrs.)

●Hyperion Smart View - (Several Projects)

●PBCS - (Two Short Projects)

●Hyperion Financial Reports - (Some Projects)

●Hyperion Financial Quality Data Management (FDM) - (3 Projects), FDMEE – (1 Project)

●Hyperion Financial Management (HFM) - Training and some Hands On

●Hyperion Data Relation Management (DRM) - Training and some Hands On

●Oracle ODI – Training

●Cognos Report Net Metadata I and II - Training and some Hands On

●Fixed Asset Accountant – (5 yrs.)

●Financial Analyst – (1.5 yrs.)

DETAILED PROFESSIONAL EXPERIENCE:

Hyperion Cloud Services

XPO Logistics thru Infosys Nov-19 to Jan-20

Lead EPBCS Developer

Responsibilities: -

●Collect and organize project requirements help with functional designs and understandings scripting and other deliverables

Environment: - Hyperion Enterprise Planning and Budgeting Cloud Services

Cathexis March-19 to May-19

Hyperion Manager

Responsibilities: - Provided support, to include Administration, Trouble Shooting and Developmental

●Management and Administration of several aspects of The Accounting and Reporting environment including changes and corrections, for each.

Environment: - Amazon Work Station, Oracle Public Cloud Budgeting Services

Focus Area: Hyperion: - AWS, PBCS, FDMEE, FR, BOLO, DOCVIEW, Access, Excel

Full Life Cycle Hyperion Planning

Houston Community College, Houston, TX Aug-13 to Dec-13

Technical Developer - Expense Planning

Responsibilities: -

●Served as the technical developer for the Full Life Cycle Hyperion Planning project.

Environment: Hyperion 11.1.2

Focus Area: Hyperion Planning

The University of Texas System, Fort Worth, TX Jun-12 to Dec-12

Designer and Developer for Public Sector Planning

Responsibilities: -

●Technical Lead in a team of two for a Full Life Cycle Development of Hyperion 11.1.2.2 Public Sector Planning and Budgeting Template to be used across seven universities.

●Each school has its own Public Sector Planning database for human resource and a Planning revenue/expense database along with two Aggregate Storage Option databases for reporting if needed.

Environment: Hyperion 11.1.2

Focus Area: Public Sector Planning and Budgeting, Essbase, Financial Reporting, Aggregate Storage Option

ProQuest, Ann Arbor, MI May-10 to Aug-10

Designer and Developer for Implementation

Responsibilities: -

●Led the design and development for a Hyperion 11.1.2 system Planning project.

●Two applications with four Planning databases and three detail Essbase databases all custom built including custom workforce and capex cubes, web forms, reports and smart view.

Environment: Hyperion 11.1.1.3

Focus Area: Planning

CB&I, Chicago, IL Mar-08 to Apr-08

Designer and Developer for Implementation

Responsibilities: -

●Completed the development on the WIP cube. Started with shell design, rethought and developed the Essbase cube, dynamic members, calculation logic and the legacy ETL.

Environment: Hyperion 9.x

Focus Area: Essbase

Full Life Cycle Hyperion Essbase Developer

ProQuest, Ann Arbor, MI Jan-12 to Mar-12

Designer and Developer for Optimization

Responsibilities: -

●Provided Hyperion 11.1.1.3 Essbase Block Storage optimization assessment and determined that the forecast cube would convert nicely to the Aggregate Storage Cube (ASO) option.

●Converted the forecast cube to ASO, along with the necessary exchange formulas, mxl, automation scripts and financial reports, to shave hours off the daily cycle.

Environment: Hyperion 11.1.1.3

Focus Area: Essbase, Block Storage Option, Aggregate Storage Option

Alcon, Fort Worth, TX Apr-06 to Jul-07

Developer for Implementation

Responsibilities: -

●Designed and developed a global financial sales price, volume and exchange rate sensitivity across all product brands and SKUs. Played a major role in developing the SQL extraction. Along with Some Cognos Report Net Prototyping

Environment: Hyperion 7.x

Focus Area: Essbase

Mazzios, Tulsa, OK Oct-02 to Nov-02

Designer and Developer

Responsibilities: -

●Full Life Cycle Essbase Budget, Planning and Analysis Application

Environment: Hyperion

Focus Area: Essbase, Excel

Reliant Resources, Houston, TX Aug-02 to Sep-02

Functional Consultant and Developer for Reporting

Responsibilities: -

●The assurance of quantitative value as well as supplying Essbase and Excel SME to revise and assist with the current year general and administrative budget.

Environment: Hyperion 6.x

Focus Area: Essbase, Excel

Waste Management, Houston, TX Aug-01 to Aug-02

Designer and Developer for Implementation

Responsibilities: -

●Full Life Cycle Essbase Budget, Planning and Analysis Application

Environment: Hyperion 6.x

Focus Area: Essbase, Excel

Reliant Energy, Houston, TX Apr-00 to Aug-01

Designer and Developer for Implementation

Responsibilities: -

●Full Life Cycle Essbase Budget, Planning and Analysis Application

Environment: Hyperion 5.x

Focus Area: Essbase, Excel

Remote Services

Ramsey County, City of Omaha, IDX, Navy Federal Credit Union, City of Red Deer, 3d Systems and The University of Georgia Aug-15 to Jan-19

Remote Managed Services – Hyperion Techno Functional for In-House Administrator

Responsibilities: -

●Provided support, to include Administration, Trouble Shooting and Developmental Follow up for Hyperion 11.1.2 Public Sector Planning and Budgeting, Planning, Essbase, Financial Reports, Financial Data Quality Management, and Oracle Data Integrator for Sierra–Cedar clients.

Environment: - Hyperion 11.1.2

Focus Area: Hyperion - PSPB, PBCS, Planning, Essbase, Financial Reports, FDMEE, EPMA. DRM

Scientific Games, Alpharetta, GA Oct-14 to Aug-15

Administrator and Developer for Application Administration, Troubleshooting and Rework

Responsibilities: -

●Filled in for the departure of the previous team to keep the applications up and running along with making optimization and functional improvements.

Environment: - Hyperion 11.1.2

Focus Area: - Hyperion Planning

City of Omaha, Remote Apr-14 to May-14

Consultant and Developer for Troubleshooting and Development

Responsibilities: -

●Troubleshot and manned the current implementation of the Hyperion Public Sector Planning and Budgeting project that was targeted for completion within the current month.

Environment: Hyperion 11.1.2

Focus Area: Public Sector Planning and Budgeting

Hyperion Consulting Services

The University of Texas Southwestern Medical Center, Dallas, TX Jan-13 to Apr-13

Developer for Position Employee Budgeting

Responsibilities: -

●Assist in the rewrite of the Employee and Position Planning and Expense cubes, business rules, calculation scripts and to create several reports.

●Solve all issues with the Hyperion Employee and Position custom cube and deploy it to production right on schedule.

●Make last minute adjustments to the Expense cube and it is slated to go live mid-month.

Environment: Hyperion 11.1.2

Focus Area: Custom Based Employee Planning, EPMA, Calc-Manager, Financial Reports

Pfizer, NY, NY Mar-11 to May-11

Consultant for Review

Responsibilities: -

●Served as an architect for Financial Data Management and various integration aspects with Essbase and Hyperion Financial Management.

●Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.1.1.3 suite accompanied with reviews and recommendations.

●Focused on FDM performance characteristics and data flow options.

Environment: Hyperion 11.1.1.3

Focus Area: Financial Data Management

CTA, Chicago, IL Mar-11 to May-11

Consultant for Enhancement

Responsibilities: -

●Served as an architect for Financial Data Management (FDM) and various integration aspects with Essbase and Hyperion Financial Management.

●Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.1.1.3 suite accompanied with reviews and recommendations.

●Focused on FDM performance characteristics and data flow options.

Environment: Hyperion 11.1.1.3

Focus Area: Financial Data Management

Cisco, Remote Mar-11 to May-11

Consultant for Enhancement

Responsibilities: -

●Served as an architect for Financial Data Management (FDM) and various integration aspects with Essbase and Hyperion Financial Management.

●Critiqued and consulted about the architectural and functional concerns for different aspects of the Hyperion 11.x suite accompanied with reviews and recommendations.

●Focused on FDM performance characteristics and data flow options.

Environment: Hyperion 11.1.1.3

Focus Area: Financial Data Management, Financial Management, Essbase

Harris Corporation, Melbourne, FL Oct-08 to May-09

Developer for Upgrade

Responsibilities: -

●Provided ongoing development and administration support and custom scripting to improve and upgrade two Essbase, one Planning and a Financial Data Management application from Hyperion 7 to 9.1 along with performing support work with financial reports, Smart View and Web Analysis.

Environment: Hyperion 7 to 9.1

Focus Area: Financial Data Management, Planning

HCC, Houston, TX Jul-08 to Sep-08

Administrator and Developer for Administration

Responsibilities: -

●Prepared the current Hyperion Planning system for the New Year. Performed the necessary Planning administration functions, upgraded the business rules and reconciled the results for the 2009 budget and forecasting processes.

Environment: Hyperion 4.x

Focus Area: Planning

Adelphia Cable, Coudersport, PA Aug-05 to Oct-05

Designer and Developer for Implementation

Responsibilities: -

●Designed and developed a series of relational and multi-dimensional solutions to perform several sets of customer care analysis.

●Met with business users to design a customer care review and analysis over several Essbase cubes with relational drill back function.

Environment: Hyperion 6.x

Focus Area: Essbase

Hewlett Packard, Houston, TX Oct-05 to Mar-06

Architect and Developer for Enhancement

Responsibilities: -

●Led the project to make the Financial Consolidation Cubes Sarbanes Oxley compliant, accessible via 2-phase authentication only and available for archiving purposes as well. Interacted with staff and several departments to design an approved and ongoing solution to their need

Environment: Hyperion 6.x

Focus Area: Essbase

Norris County, Philadelphia, PA Feb-05 to Feb-05

Consultant for Review

Responsibilities: -

●Determined and made recommendations pertaining to the performance and design characteristics of the Hyperion 7.x Budgeting application.

●Met with staff and reviewed the design and performance characteristics of the Budgeting application, made confirmations and recommendations of possible configuration and optimization techniques.

Environment: Hyperion 7.x

Focus Area: Planning

Baker Hughes, Houston, TX Apr-10 to May-10

Contractor for Upgrade

Responsibilities: -

●Performed with a team for a total Hyperion 11 system reconciliation for a Hyperion Financial Management upgrade along with a partial split out to Planning and Essbase Aggregate Storage Option.

●It was a new install of Data Relationship Management along with the upgrade and change in dimensionality that required the extensive reconciliation.

Environment: Hyperion 11.1.2

Focus Area: Smart View

USAA, San Antonio, TX Jun-04 to Nov-04

Consultant for Documentation

Responsibilities: -

●Worked on an as is budget, planning, forecasting and modeling documentation project for a very large insurance company.

●Interacted with upper level management and specialty management experts of the various business divisions in order to promote the success of the documentation of the current systems which included PeopleSoft, Essbase, and Microsoft Access, Synobjects and Excel and various other third-party systems.

Environment: Hyperion 7.x

Focus Area: Essbase

Reliant Resources, Houston, TX Sep-03 to Oct-03

Functional Consultant for Reporting

Responsibilities: -

●To assure of quantitative value as well as supplying Essbase and Excel SME to revise and assist with the current year general and administrative budget.

Environment: Hyperion 6.x

Focus Area: Essbase, Excel

BP, Texas City, TX Aug-03 to Sep-03

Consultant for Review

Responsibilities: -

●Reviewed and made recommendations to promote the success of the current Essbase disaster recovery plan and to verify the ability of the upgradeability of current cubes.

Environment: Hyperion 6.x

Focus Area: Essbase

Full Life Cycle Hyperion FDQM

Harris Caprock, Houston, TX May-11 to Oct-11

Designer and Developer for Implementation

Responsibilities: -

●Served as a Hyperion 11.1.1.3 Financial Data Management (FDM) and Essbase developer responsible for overall technical and functional design and development of the FDM application and the integration to along with and corresponding Essbase scripting and operational integrity.

●Added a complex time matrix to the Essbase cube in order to provide various cross dimensional views for reporting and analytics.

Environment: Hyperion 11.1.1.3

Focus Area: Financial Data Management, Essbase

Praxair, Danbury, CT Aug-10 to Mar-11

Developer for Implementation

Responsibilities: -

●Served as the Financial Data Management (FDM) developer for a Hyperion Financial Management (HFM)\Planning EPMA project mostly responsible for import formats, scripting and mapping, used two adapters for one application and used the same data loads to each of the 80 plus HFM locations to load to a sister Planning location.

Environment: Hyperion 11.1.2

Focus Area: Financial Data Management, Financial Management, Planning

Hyperion Financial Reports Developer

Targa Resources, Houston, TX Aug-09 to Jan-10

Developer

Responsibilities: -

●Provided ongoing support and troubleshooting along with the IT department, along with a Planning upgrade and partial rewrite of the Planning metadata and calc scripts.

●Troubleshot Planning and Hyperion Financial Management (HFM) business rules, developed system 9 backup and restore procedures along with using the Synobjects concepts to architect an Essbase prototype to facilitate the data transfer between applications and reports.

Environment: Hyperion 11.1.1.1

Focus Area: Financial Data Management, Hyperion Planning

Pride International, Houston, TX Jul-07 to Feb-08

Administrator and Developer for Administration

Responsibilities: -

●Automated the SEC 10q and 10K reports along with several other internal reporting packages and researched and optimized Essbase automation and control procedures.

●Interacted with management and staff to obtain the necessary information while completing the development of the Hyperion Essbase and Reporting tools in order to complete the task at hand.

Environment: Hyperion 9.x

Focus Area: Planning, Financial Reporting

Hanger Orthopedic, Remote Jun-05 to Aug-05

Developer for Enhancement

Responsibilities: -

●Converted the Hyperion Essbase database and reports from a stacked time dimension database to one with split month and year time dimensions.

●Resolved outstanding statistical formula problems, worked offsite at the TLC office to resolve any dimension, formula and reporting issues while logged into the client’s network.

●Created all the necessary new reports, outlines, outline formulas, calc and report scripts.

●Created all the automation procedures and documented them as well.

Environment: Hyperion 7.x

Focus Area: Essbase

Temple University, Philadelphia, PA Apr-05 to Jun-05

Developer for Implementation

Responsibilities: -

●Performed an in-depth analysis to determine the problems associated with resolving the reports.

●Worked with staff to better understand their needs, from both an end users and administrator’s role.

●Resolved the operational reporting logic requirements specific to the environment and purpose and made the necessary changes to the current reports to provide a perfect solution.

Environment: Hyperion 7.x

Focus Area: Planning, Financial Reporting

Other Professional Experiences

MSCH Health Plans, Houston, TX Nov-98 to Apr-00

Senior Analyst for Financial Analyst

Responsibilities: -

●Essbase Budget, Planning and Financial Analyst

Environment: Hyperion 5.x

Focus Area: Essbase, Excel

Schlumberger, Sugar Land, TX Dec-93 to Nov-98

Accountant and Contractor for Accounting / and Taxation

Responsibilities: -

●Fixed Asset Accountant

Environment: Various

Focus Area: AS400, SAP, Microsoft Excel

Schlumberger, Scott, LA Jan-91 to Dec-91 and Jan-93 to Dec-93

Field Engineer for Anadrill / Schlumberger

Responsibilities:

●Offshore Engineering

Environment: Offshore Drilling

Focus Area: In house Systems

Federal Deposit Insurance, Wexford, PA Dec-89 to Sep-90

Assistant Bank Examiner

Environment: Lotus

Responsibilities:

●Reporting the Risks of the Bank to the Insurance Fund

Focus Area: Banking

Contact this candidate