Hyperion Consultant

Shweta Yadav

Phone: +1-916-***-****

Email: *********@*****.***

GC-EAD

Skill Set

Functional Skills

Enterprise Performance Management, Management Reporting & Analysis

BI Technologies

Hyperion Suite, OBIEE, Excel and VB

Industry Exposure

Public Sector, Finance, Energy

Technical Skillset

Java Scripting, VB, C, C++

Databases

Oracle/SQL Server

Summary

Diverse experience in Management Consulting and Technology Delivery

10 years of exposure on Budgeting, Forecasting & Management Reporting

Hands on technology exposure –Hyperion, SQL, OBIEE, ODI

Worked with leading project delivery processes (SDLC and Delivery Tools)

Conducted Hyperion trainings as Oracle primary trainer

Well developed communication and multi tasking skills

Recognized ACE and H&PS Beacon Award by Accenture Leadership

Authorized to work for any employer in US

Objective

Effectively utilize and build my techno functional skillsets in the Management Reporting / BI space

Education

Bachelor of Technology (Electronics and Communication) with 80% First Division- Chandra Shekhar Azad University Duration: 2004-2007

10th and 12th standard Merit Holder with 83%(Topped in School) and 79% respectively.

Job Summary

Company : Accenture Services Pvt. Ltd

Period : April 2010 to Present

Designation : Associate Manager

Company : Nouvasys Pvt Ltd.

Period : March 2008 – Feb 2010

Designation : Associate Consultant

Company : 3i- Infotect Ltd.

Period : July 2007 – March 2008

Designation : Software Trainee

Technology Exposure

Business Intelligence and Enterprise Performance Management

-Hyperion Planning

oDimensional Design (Sparse, Dense, Attributes etc)

oWeb Form Design

oCreate business rules and process design

oSecurity

-Essbase

oASO and BSO modeling

oMaintain Filters

oCreate calc scripts

oRules to load data and metadata

oReport, MaxL and MDX scripting

-Smart View & VBA

oDesign complex forecasting and rollover models

oAutomate using VB

oIntegration via SmartView

-Finance Reporting Studio

oCreate complex FR reports with multiple grids and connections

oCreate formula based calculation

oAdvanced formatting

oAdvanced suppression logic

-Interactive Reporting

oComplex IR reports and Dashboards with custom Java scripting

oCreate write back functionality to RDBMS

oCreate and run batch scripts real time with command prompts and VB scripting

-ETL (ODI, Informatica)

oMaintain and enhance ODI process to refresh ASO/ BSO data/ metadata

oCreate and design ODI interface to develop Data Mart sourced from Hyperion

-Oracle Business Intelligence Enterprise Edition (11.x)

oDevelop Answers/Analysis and Dashboards

oSet up Repository (RPD)

SQL

oSQL skill set to query databased and ability to analyze and mine large datasets

oConceptual and Logical Data modeling

Selective Experience

State of California – Fi$Cal

Role: Onshore Hyperion Application and Reporting Lead (in US)

Software and Platform: Hyperion Planning, Essbase, Financial Reporting, SmartView, ODI and Oracle Data Marts

Client Background

The FI$Cal Project for State of California (6th largest economy) replaced legacy systems with a centralized Budgeting process using Hyperion. Fiscal also developed statewide Governor’s Budget Requests, Spring Revisions and delivered the Enacted Budget for FY14-15, FY15-16 and FY16-17

Functional Roles and Responsibility:

Conduct design sessions with Department of Finance, State Business and tech team

Develop business requirements and model for proposed solution

Provide weekly updates to Department of Finance, State tech team, State Business team and Accenture leadership.

Create workplan and streamline tasks for efficient delivery

Technical Roles and Responsibility:

Lead major re-design of Hyperion Planning application

oMerge three dimensions into one dimension for better data entry.

oDesign and set up tasks list to allow multiple budget request types and Finance task maintenance.

oDesign web forms with multiple validation rules and guard rails to allow data entry for dollars, flags, smart lists and free form text.

oCreate, design and enhance business rules to allow custom creation of budget requests and for other purposes.

FR Reporting

oDeigned complex FR reports with attributes, time variant flags/smart-lists, retrieval of text information

oMultiple grids with Planning and Essbase connections, conditional formatting and suppressions

oMultiple Prompts (grid level and report level), Multiple User POVs, precise header and footers and complex functional data validation

oReal time reports using planning ASO

ASO cube modeling

oDesign ASO Cubes to support Financial Reporting requirements including Internal Planning ASO cube and Standalone ASO cube.

oStandalone ASO has more dimension to allow better reporting

Lead and performed Rollover Process

oCreated multiple validation FR reports for rollover process and Scheduled reports for Gov Publishing Systems.

oTrained users on how to use Smart View for ad hoc validation and standard template based data input.

oManage work plan for conversion/ rollover process during annual cutover processes

Hyperion Essbase (EAS)

oDesign and develop Export Calculation Scripts and rollover scripts

oDesign Rules files to load data and metadata

oTuning and optimization with sparse/dense settings

oMaxL and MDX scripting

VicRoads Registration and Licensing - Australia Public Service

Role: OBIEE development lead (in Australia)

Software and Platform: OBIA, OBIEE, Answers, Dashboards, Informatica

Client Background

VicRoads is a statutory corporation which is the road and traffic authority in the state of Victoria, Australia. It also issues licenses and vehicle registration.

Functional Roles and Responsibility:

Gather functional requirements from client and document functional designs

Analyze requirements and assist business analysts regarding technical capabilities

Assist Estimation and Project Planning

Technical Roles and Responsibility:

Lead OBIEE reports and Dashboards designs

Lead offshore team to enable out of the box Oracle analytics warehouse integrated with Siebel CRM

Massachusetts Budget systems

Role: Hyperion Developer and Analyst (in India)

Software and Platform: Hyperion Planning, Essbase, Interactive Reporting and Dashboards, Java Scripting, VB Scripting, FR

Functional Role and Responsibility:

Gathered requirements from Accenture client team

Designed Report and Dashboard design prototypes to get sign offs

Technical Skills:

To build user interface using Interactive Reporting dashboards to collect Budget data and integrate data flow to Planning cube, and store details in RDBMS.

Build highly Complex Dashboards in the Hyperion Interactive Reporting environment with write back functionalities.

Build IR Oracle repository which contains Tables, views, joins to capture and load Essbase data at summarized level.

Implement the automation for the application with VBScript and batch files

Build ASP pages for real time data flow across applications.

On Hyperion planning application front was responsible to implement functional requirement of SGAAG process more effectively to enable selective and mass copy across versions

Build Hyperion Essbase calculation script to find out variances for all the spending and revenue accounts and set the SGAAG Flag accordingly.

Awarded by Health and Public Sector Leadership as ‘Superstar’ in the Beacon Awards.

Merck Pharmaceuticals -FCCP

Role: Application upgrade specialist and performance tester (India)

Software and Platform: Upgrade from 7 to system 9

Role and Responsibility:

Installation and configuration of Hyperion Essbase Server system 9 64 bit.

Upgrade Essbase application software from version 7 to version 9

Create Excel add in Macro to perform multi user performance testing on data retrieval times. This Macro was re-used for multiple modules in the project.

Provided test data and coordinated with onshore team.

Documentation for future references

Oracle Hyperion trainings Globally

Role: Oracle Hyperion Primary trainer

Role and Responsibility:

Conduct Oracle trainings as primary trainer for High End Hyperion courses at global client sites such as Colombo, Singapore, Jordan, Abu Dhabi, India etc.

Provided training on following Oracle Courses:

Hyperion Planning Fundamentals Bootcamp

Hyperion Essbase ASO/BSO- Bootcamp, Partitioning, Administration, calculate databases

Hyperion Interactive Reporting, advance dashboard development

Hyperion Financial Reporting

Hyperion Master Data Management/ Hyperion Data Relation Management

Hyperion DIM

Oracle Data Integrator (Sunopsis)

BI and Data ware housing concepts

OBIEE: Create reports and dashboards

OBIEE: Managing repository layers

Personal Profile

Name : Shweta Yadav

Date of Birth : 28th June 1986

Passport : Valid for 10 years till 2028

Status : EAD (Authorized to work for any US employer)

Sex : Female

Mobile : +1-916-***-****

Email Id : *********@*****.***

Contact this candidate