Rajesh Uppili

Email-ID: ac30kr@r.postjobfree.com

Mobile: +1-832-***-****

Career Objective

Seeking a quality environment where my knowledge and experience can be shared and enriched. Looking for an opportunity to work in the area of Hyperion Financial Management.

Summary of Qualifications

Having 9+ years of extensive experience in the development, design, analysis and implementation of various applications using Hyperion System 11.x/9.x This includes Hyperion Shared Services, Hyperion Financial Reports, Hyperion Financial Management and Financial Data Quality Management, Smart View and Excel Add-In. Knowledge on Hyperion Financial Management Installations, Hyperion Essbase and Planning also in ODI. Design & development of OLAP and decision support systems with focus on Oracle Hyperion Suite of Technology.

Extensive experience in Developing Data Forms for Exchange rates.

Proficiency and experience in a range of Hyperion products including EPMA applications and FDMEE.

Created extensive Data Grids and Data Entry Forms to view or enter the data using HFM web client.

Trained user community to manage the review process using process control and journal creation.

Used to automate the tasks such as data loading, calculation & translation.

Strong development experience in Hyperion System 9 /System11 suite including

Hands on experience in the development of metadata and Dimensions like Entity, Year, Value, Scenario, Account, ICP, Period, View, consolidations, allocations, forms .

Knowledge and experience in understanding the Business rules and writing the rules as per business request.

Hands on experience in providing securities, provisions and assigning the control access.

Experience in attending the status calls and interacting with Client.

Excellent Interpersonal, analytical and communication skills.

Created substitution variables as per business requirement and used in Calculation Scripts.

Created Excel Templates for ad-hoc reporting using Lock and Send.

Created required web Data forms to facilitate the entry and review of data and provided access to users based on security level of access.

Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies

Strong problem-solving, communication, interpersonal, training, and presentation skills.

PROFESSIONAL EXPERIENCE

Working as Senior System Analysist in Nabors Industries, Houston, Texas from NOV 2016 to Till date

Working as Senior Software Engineer in Staffcube LLC., Houston, Texas from Feb 2016 to Nov 2016

Working as Technical coordinator in Tech Mahindra (Americas) Inc., Houston, Texas from June 2015 to Feb2016.

Working as Senior Software Engineer in Tech Mahindra, Hyderabad, India from July 2012 to May 2015.

Working as Hyperion Consultant in Appro Systems, Hyderabad, India from Nov 2008 to May 2012.

Technical Skills

Operating Systems

Windows 98/2000/XP/2008, Windows Server 2003.2008 R2R.

Languages

C,C++,Java, VB Script

BI Tools

Hyperion Financial Management, Financial Data Quality management, Hyperion Business rules, Hyperion Financial Reports, EPMA, Hyperion Essbase, Hyperion Planning and ODI

MSOffice Tools

MS Word, Excel, PowerPoint

Databases

Essbase, Oracle 10g, MS SQL Server 2008, 2005, 2000

Educational Background

B.Tech in 2007 from gayatri vidya parishad college of engineering, Visakhapatnam, India.

CLIENT EXPERIENCE

Client : Nabors Industries Houston, Texas

Period : MAR 2016 to Till Date

Role : Senior Software Engineer

Environment: Hyperion Financial Management 11.1.2.3, FDQM, EPMA, FDMEE, ODI, Smartview, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server

Description

Nabors Industries (NYSE: NBR) owns and operates the world's largest land-based drilling rig fleet and is a leading provider of offshore drilling rigs in the United States and multiple international markets. Nabors also provides directional drilling services, performance tools and innovative technologies throughout the world’s most significant oil and gas markets. Leveraging our advanced drilling automation capabilities, Nabors’ highly skilled workforce continues to set new standards for operational excellence and transform our industry.,

Responsibilities

Create and deploy applications and designing metadata.

Loaded metadata for Accounts, entities, Scenario and custom dimension.

Extracted, loaded the metadata whenever metadata changes occur.

Doing Consolidations and Analysis through HFM Client and Web.

Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.

Build the Taskflows for two HFM applications

Build the Data synchronization mappings between two HFM applications

Managing POV in the explore data setting.

Creating Member lists and Rules using VB scripting.

Creating Journals.

Posting and Unsporting of Journal for adjustments of Entities.

Mapping between FDM and HFM.

Creating locations in FDMEE and Batch rule file setup

Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly data.

Worked Extensively on Shared Services and Energy LDAP, HFM/FDM applications 11.1.2.3. Performed weekly, monthly, and quarterly data loads and verifications.

Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.

Responsible for security provisioning using shared services across the entire Hyperion environment.

Client : GE OIL & GAS (GE ENERGY) Houston, Texas

Period : NOV 2012 to FEB 2016

Role : HFM Technical Consultant

Environment: Hyperion Financial Management 11.1.2.3, FDQM, EPMA, FDMEE, ODI, Smartview, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server

Description

Energy Management’s three businesses Energy, Industrial and Power Conversion bring GE’s electrical capabilities together. Global teams design leading technology solutions for the transmission, distribution, management, conversion and optimization of electrical power for customers across multiple energy-intensive industries. GE has invested more than $4 billion in our Energy Management capabilities, with 14 strategic acquisitions and joint ventures that enable GE to increase its offerings to the utility, industrial, renewables, oil & gas, marine, data center, metals and mining industries. Backed by our technological expertise, operational excellence and a collaborative, world-class team, Energy Management is GE’s electrification business.

Responsibilities

Create and deploy applications and designing metadata.

Loaded metadata for Accounts, entities, Scenario and custom dimension.

Extracted, loaded the metadata whenever metadata changes occur.

Doing Consolidations and Analysis through HFM Client and Web.

Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.

Managing POV in the explore data setting.

Creating Member lists and Rules using VB scripting.

Creating Journals.

Posting and Unsporting of Journal for adjustments of Entities.

Mapping between FDM and HFM.

Responsible for month-end tie-out and provide related support to financial controllers.

Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly data.

Worked Extensively on Shared Services and Energy LDAP, HFM/FDM applications 11.1.2.3. Performed weekly, monthly, and quarterly data loads and verifications.

Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.

Responsible for security provisioning using shared services across the entire Hyperion environment.

Client : Indorama Ventures Ltd

Period : July 2012 to Oct 2012

Role : HFM Techno Functional

Environment: Hyperion Financial Management 11.1.2.2, FDQM, Smart view, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server.

Description

Indorama Ventures Public Company Limited is one of the largest vertically integrated polyester chain producers in the world and a leading global manufacturer of wool yarns. Our global sales and manufacturing presence can be seen in all high-growth economies and industries. Our products serve major players in diversified end use markets, including food, beverages, personal and home care, health care, automotives, textile, and industrial.

This is semi development project, where Client is existing with HFM quarterly application and we have implemented HFM monthly application and created alternate hierarchy for entity, tweaked the rules part for monthly application based on quarterly application.

Responsibilities

Worked as an administrator to give access and privileges to various end users in different HFM applications

Installation, Troubleshooting and Configuration of Hyperion HFM in distributed Environment

Participation to build HFM Profile, Application and Metadata based on General Ledger Mappings and doing corrections to Metadata

Created users and groups and provision with specific roles and assigned Security Classes in user management console

Loading Inter-Company Transaction and Journals into Target Application

Manage the financial review cycle using Process Management

Involved in creation of Web Entry Forms, Web Data Grids and Smart View Forms

Modified the Rules based on exiting HFM Quarterly application

Running Consolidations after Data Load

Loading Data through Financial Data Quality Management

Client : Ramsay Health Care, Australia

Duration : Apr 2011 to May 2012.

Role : Hyperion consultant

Environment : Financial Reports, Hyperion FDQM 9.3.1, Hyperion

Financial Management 9.3.1. Microsoft Excel 2003,

MS SQL Server 2005,and Windows 2003 Server.

Project Description:

Ramsay Health care was a global hospital group operating over 100 hospitals and day surgery facilities across Australia, United Kingdom and Indonesia. Ramsay Health care is Australia’s largest private hospital operator and a well-recognized brand in the industry.

This is designed to analyze the business information for the company. It provides reports based on their businesses and their corporations so that decision-makers were assisted in budget analysis and expansion of business. This system was developed to provide an integrated data source and create data marts for management reporting, Forecasting and budgeting. The company requires different level of analysis regarding various inventories and regions etc. This system maintains the historical data for analysis.

Responsibilities

Involved in extracting reports using Hyperion Analyzer.Created and HFM applications profile.

Designing and implementing data load process.

Designing and implementing FDM data load process.

Creating Data grids and Data Forms.

Responsible for Financial Reports – developing new reports.

Creating Rules and testing and loading into application.

Setting the POV in FDQM

Locking the entities if process not requires modifications.

Resolving the client issues.

Client : Oak Brook

Duration : Jan 2010 to Mar 2011

Role : Hyperion consultant

Environment : Hyperion Essbase, Hyperion Planning, Hyperion Smartview Hyperion Shared Services (HSS).

Project description:

This Project was designed and created to have the ability to perform budgeting and forecasting for 5 consecutive years, to track revenue by Customers for example Customer type such as major/minor, Sales Executives, Sales region. The System should have the ability to enable sales executives to enter forecast revenue by customer type. The project needs to perform their budgeting and forecasting for 5 years. The salary information entered in the first year would be used to automatically calculate based on the grade specifications. The system should have the ability to calculate facility allocation and the corporate expenses.

Responsibilities

Created high level budgeting application and building the Hyperion Planning, Essbase application to aid the company in their budget planning and financial reporting requirements.

Design and implement Planning application to fulfill the needs of the Sales executives to forward forecasting revenue system. (Strategic Forecasting system).

Creating Rule File’s to load data and Build dimension by Parent Child Reference, Generation reference and Level Reference.

Developed Applications, Databases, and Outlines and optimizing the Outlines.

Developed rules files (dimension build rules and business data load rule files).

Developed and implemented Dimensions and member Attributes.

Creating the users and groups and also giving appropriate provisions to them using Hyperion Shared Services.

Involved in Essbase cube analysis, design and maintenance, database backups, performance tuning and optimization on System 11.1.1.3

Part of multi-dimensional modeling, calc scripts, MaxL Scripts. Strong at making automation script and scheduling using MaxL Commands.

Created substitution variables as per business requirement and used in Calculation Scripts.

Created Excel Templates for ad-hoc reporting using Lock and Send.

Created required web Data forms to facilitate the entry and review of data and provided access to users based on security level of access.

Client : Net Logic, U.S.A

Duration : Nov 2008 to Dec 2009.

Role : Hyperion Consultant

Environment : Hyperion Financial Management 9.3.1.Microsoft Excel 2003, MS

SQL Server 2005, Hyperion Financial Reporting 9.3.1,

Hyperion FDQM 9.3.1, and Windows 2003 Server.

Description

Net Logic Microsystems is a worldwide leader in intelligent semiconductor solutions that are powering next-generation Internet networks. Net Logic Microsystems best-in-class products perform highly differentiated tasks of accelerating complex network traffic to significantly enhance the performance and functionality of advanced 3G/4G mobile wireless infrastructure, data center, enterprise, metro Ethernet, edge and core infrastructure networks. Hyperion Financial Management Project was implemented to analyze the financial details.

Responsibilities:

Created and HFM applications profile.

Involved in creating the HFM application.

Designing and implementing data load process.

Responsibility to verify Validation Rules and HFM Rules.

Created Database outlines and optimized the outlines by arranging the dimensions.

Creation of grids by using Explore Data Module and consolidate the grids to refresh the values upon loading.

Creation of Web Data Entry Forms by using Web Application.

Creation of Journals and doing Process Management in HFM.

Running Consolidations after data load.

Involved in creating security to the end users.

Replicating the client issues and resolving the same Management.

Contact this candidate