Electrical Engineer Data

Ms.Sooriar

*** ********* ***,

Piscataway NJ, ********@*****.***

Summary

Oracle Hyperion Certified professional with experience in Oracle Enterprise Performance Management, Hyperion Essbase, Smart View, Planning and Workforce Planning, Hyperion Financial Reporting Studio, Shared Services, Life Cycle Management, HFM, Essbase Studio, FDMEE, Consolidations, Data Warehousing, ETL & OLAP

Experience in installation & configuration of Hyperion

Development & Functional experience in Smart View, Hyperion Planning Forms, Security, Metadata Maintenance, and Business Rules.

Expertise in developing Hyperion FR reports

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

Versatile team player with excellent analytical, presentation and inter-personal skills.

Experience in migration between different environments, including Life Cycle Management.

Excellent knowledge of Block Storage (BSO) and Aggregate Storage (ASO) concepts.

Outstanding organizational skills including ability to multi-task, prioritize and manage increasingly complex issues.

Adaptability to new systems and environments.

Results oriented with excellent work ethic, ownership of duties, problem solving and decision-making skills.

Ability to effectively interact with business users and all levels of management, and translate requirements into detailed functional requirements documents.

Professional Experience

Quest Diagnostics, Secaucus, NJ. 2017 – Present

Sr. Financial Reporting Analyst

Corporate headquarters of Quest Diagnostics, the world's leading provider of diagnostic information services.

Financial Systems Support:

Provide month-end financial close support to Finance.

Develop financial reports according to user requirements in Smart View and Hyperion Financial Reporting.

Create Essbase member formulas and reporting metrics.

Validate, reconcile and analyze financial data using Smart View.

Support users on Smart View, Essbase and Planning add-ins - drill through, uploads, cascade, calculating and refreshing data.

Guide users on Smart View set up, installation, connectivity, and ad-hoc reporting.

Produce maintenance-free templates, forms, reports for users.

Create new database applications using Hyperion Essbase Studio.

Maintain Essbase outline, substitution variables, and calculation scripts using MAXL

Create or update the Forms in planning, update the business rules.

Load Restatements data to Essbase applications.

Hyperion Workspace:

Batch scheduling, creating books and batches for Reporting.

Shared Services: security audit report, security filter access, group access to various Essbase cubes.

Migrate application components and artifacts from QA to Production environments.

PeopleSoft:

Produce and run month-end queries.

Update monthly FX rates from PeopleSoft to Essbase.

Revise and modify nVision reports per user requests.

Other Skills:

Extensive knowledge in Microsoft Office –Excel (complex models, pivot tables, VLOOKUP formulas), Word, Power Point)

Excellent problem solving skills and the ability to deliver quality solutions on time

Positive attitude with the ability to work independently and as part of a team

Strong organizational skills and attention to detail.

Extensive experience in process quality improvement.

Good relationship builder

Team player and strong communicator

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3.700, Workspace, Hyperion FR report 11.1.2.3.700, Essbase studio 11.1.2.4, FDMEE, Essbase Smart view, MS- Excel, Power point, Word document & Access.

ConvaTec, Bridgewater NJ 2016 – 2017

Hyperion Administrator Analyst

Medical Device companies strive to enhance the lives of millions of people around the world. ConvaTec utilized its skin care technology.

Administrated Hyperion product suite11.1.2 including metadata, data grids, forms, reports, FDM scripts, business rules, entity security, and system support for Financial Planning & Analysts.

Provided support for over 200 global finance users during month end closing, forecasts, estimates and the budget projection process using Hyperion Financial Management (HFM) for legal entity reporting, Essbase, Web logic, Hyperion Planning for management reporting and modeling.

Developed custom financial reports using Report Studio, Smart View and Essbase Excel Add in.

Performed monthly SAP data loads and validations, mapping updates and VB scripting using Financial Data Quality Management (FDM).

Patched the Hyperion Essbase.

Analyze requirements and design solutions to meet business requirements.

Creating the application user implications of new functional designs, create technical and user documentations.

Executed and managed monthly Metadata changes in HFM, FDME, Essbase and Hyperion Planning using Oracle Data Integrator (ODI) and Essbase Analytic Services (EAS) to update Essbase and Planning.

Assisted the global finance directors and financial analysts in troubleshooting technical problems and data issues.

Verizon, Basking Ridge, New Jersey 2015 – 2016

Hyperion Financial Reporting Specialist

Verizon is one of the largest communication technology companies in the world

Worked closely with FP&A staff and corporate staffs.

Involved in requirement gathering, analyzed reports followed up with questions/information requests; additional research and analysis as required, as needed, to support requested information.

Extensive experience using Financial Reporting Studio – created Hyperion Financial reports, edited report objects.

Worked in workspace - created folders, exported and import files from different environments, and set up e-mail links to folders, reports, and snapshot books. Using Book Editor in Financial Reporting Workspace created book of reports.

Created complex reports with multiple grids and graph charts, designed with a header that contains an image and a title, and two grids and charts.

Port Authority of New York & New Jersey. 2011 – 2015

Hyperion Administrator Analyst

Hyperion Administrator of Management & Budget Department. Supported three different environments (Production, QA and Development).

Responsible for day-to-day support and Application Maintenance.

Used FDM to Maintain FDM Mappings, Monitor FDM processing, Resolved validation errors, Managed FDM user security, Importing Planning data to HFM.

Update Planning Forms, Maintained Calculation Manger rules, manage dimension security, Manage data forms, managed security, Copy Versions, Copy Scenarios (Forecast, Prior, 2ndPrior, BOD)

Responsible for Performance Monitoring, Backup and Recovery of the cube.

Support to update the Window System from 2003 to 2008 and installing Hyperion and Oracle in Production Server.

Create and Modify report scripts to extract and send the data for cube balancing.

Add the members in dimensions and in proper hierarchies.

Very good experience using EPMA to Create/Update dimension members, Deployed changes to HFM, Essbase, and Planning.

Extensively involved in developing the calculation scripts as per the requirements of the business users.

Involved in designing Essbase outline, substitution variables.

Resolved various performance issues for the database and optimized the calculation scripts for reducing the calculation time

Hyperion Consultant 2010 – 2011

Responsibilities:

Responsible for Day to day support with the business team and worked with help desk (IT).

Involved in Installation and Configuration of Hyperion Development, Test and Production Environments

Migration of version 11.1.2.1, Essbase, HFM and Planning to the new 11.1.2.2 environment Essbase,

Resolved login issues for users and guided them with Hyperion Workspace navigation in production environment.

Ability to plan approach for analyzing, categorizing, and managing requirements.

Assist, contribute & coordinate presentations to the client and user groups to display the application and training.

Work independently with different groups to create documentation products in a fast-paced environment

Research, outline, and write technically accurate documentation that conforms to style guides

Extensively involved in developing the calculation scripts as per the requirements of the business users

Involved in tuning of dimensions and by setting new heap size, cache settings for better calculation and retrieval timings

Prepared the change request documents for approval of the changes

Responsible for Day to day support with clients and worked closely with IT help desk.

Involved in creating new Essbase cubes and restructure and redesigning of existing cubes.

Scheduled these batch files for complete automation process for nights and weekend's cube refresh

Extensively involved in designing and modifying the outlines for ESSBASE Cubes.

Implemented various troubleshooting procedures to recover databases.

Supported users with excel add-in, Essbase databases and data issues.

Prepared the change request documents for approval of the changes

Investigated and resolved consolidation and metadata design issues

Horizon Computer Services, Edison, NJ

Software Analyst

•Gathered business/technical requirements from clients and designed documents per business needs.

•Provided process improvement solutions and best overall contact center industry practices to clients.

•Developed training plans, deployment/rollout plans, end-user and operational support manuals for end-users.

•High level of energy, drive, enthusiasm, initiative, commitment.

•Effective in a challenging and constantly changing environment; a high-energy and self-motivated entrepreneurial style and spirit

EDUCATION:

Bachelor of Electrical Engineer, Lake Head University-Ontario Canada.

REFERENCES: Provided upon request.

Contact this candidate