Latheswar S aogm9i@r.postjobfree.com

Mobile: 91-956*******

PROFESSIONAL SUMMARY

• Having around 6 years of experience in the analysis, design, development and implementation of various applications using Hyperion Essbase, Planning, HFR, HAL, FDM Web Analysis, Essbase Spreadsheet Add-Ins and HFM.

• Worked on Hyperion Planning to create applications, security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users, user groups and their security rights.

• Handle the Admin tasks for planning and essbase applications.

• Having extensive experience in creating Data Load Rule files, Calc Scripts, MaxL Scripts, Batch Scripts, Reports, Web Forms, Business Rules and Excel Add-in.

• Involved in upgrading, testing and migrating of cubes in different environments.

• Experienced in providing security for Users and Groups using Hyperion Shared Services.

• Experience in installation and configuration of several Hyperion products in windows environment.

• I have also worked on developing of web application using Java/j2ee technologies.

• Excellent communication skills and versatile team player with good analytical, presentation and inter-personal skills.

EDUCATION

• 2005: Completed Master of Computer Applications (M.C.A) from Anna University

• 2002: Completed Bachelor of Computer Applications (B.C.A) from S.V.University

WORK EXPERIENCE

• Worked as a Sr.Consultant in Capgemini India Pvt Ltd from Jan 2009 to Oct 2011.

• Worked as a Sr.Software Engineer in Satyam Computers from Nov 2006 to Dec 2008, Hyderabad (INDIA).

• Worked as a Programmer Analyst in EDS (Electronic Data Systems) from Dec 2005 to October 2006, Chennai (INDIA).

SKILLS SET

OLAP Tools : Hyperion Essbase7.1, 9.3.1, Hyperion Planning9.3.1, 11.1.1.3, Shared Services Reporting Tools : Spreadsheet Services, HFR, Web Analysis and Smart View

Databases : Essbase, Oracle 8i/9i/10G, SQL Server 2000/2005

Operating System : Windows 2003 Server/XP, UNIX

Languages : Java/j2ee, VB, C, C++

PROJECT # 1 SPACE-Spare Part and Accessories Contribution Efficiency

Client Renault Global, Europe

Period Apr 2011 – Oct 2011

Environment Hyperion Essbase 9.3.1, Planning 9.3.1, HFR, HAL,FDM

OS Microsoft Windows XP

Role Team Member

Project Description:

"SPARE PART AND ACCESSORIES CONTRIBUTION EFFICIENCY". It is a business intelligence reporting on the spare and accessories parts business of Renault. It also reports the spare part contribution on actual monthly basis for each country. It allows to work forecasts and to build the budgets. This application target budget processing for the “Price and Accessories” Department. The scope of this application is worldwide.

Responsibilities:

• Designed the cube based on the business requirements of the client.

• Loaded the metadata into Planning application using Hyperion Application Link (HAL) and refreshed into Essbase database.

• Designed and developed web forms for the data input as per the business requirements using Hyperion Planning.

• Load the data into planning application using FDM

• Involved in migration of planning application from Development to QA to Production.

• Involved in database and security refreshes in Hyperion Planning.

• Used Business rules for allocation and budgeting in Hyperion Planning.

• Involved in Unit Testing to test the Web forms and their associated business rules functionality.

• Written MaxL Scripts to automate the process of dimension build and data load.

• Implemented application security process, created users/groups, security profiles and application access to different groups using filters.

• Optimized the applications to reduce the calculation time and database size considerably.

• Extracted the reports using HFR and Smart View.

• Restored database by taking regular backup in case of database corrupt or server crash.

PROJECT # 2

RBS –CRA(Credit Rating Agency)

Client RBS

Period Jan 2010 – Mar 2011

Environment Hyperion Essbase 11.1.1.3,HFM11.1.1.3,FDM11.1.1.3,HFR

OS Microsoft Windows XP

Role Team Member

Project Description:

RBS –CRA is a Credit Rating Agency; it is a third party agency between the banks and customers. Before Issuing the credit cards and loans banks will communicate with this third party agency and provide the customer’s details to this agency. This agency will do cross check and verification with the provided information and pass that information to the banks; banks will issue the loans or credit cards based on this information. The main aim of this project is to provide the analytical data to the Enterprise Management. This project involves in creation of HFM applications and generation of reports.

Responsibilities:

• Support the existing application and handle the tickets based on SLA’s.

• Uploading the security Files into HFM application

• Loading the Meta Data based on given input files.

• Set the adapters, mappings of source and target systems in FDM.

• Load the data into HFM application using FDM

• Designed and developed Data forms for the data input as per the business requirements.

• Involved in migration of HFM application from Development to QA to Production.

• Worked on Load rules for calculating the data.

• Involved in Unit Testing to test the Data forms and their associated calculations functionality.

• Implemented application security process, created users/groups, security profiles and application access to different groups using filters.

• Involved in optimize the application and backup recovery process to improve performance.

• Involved in creating the e-mail alerts to update the users to perform important task.

• Knowledge in HFM journal process.

• Extracted the reports using HFR and Smart View.

• Restored database by taking regular backup in case of database corrupt or server crash.

PROJECT # 3 CBIC ( Consumer Banking Information Cube)

Client CITI BANK, USA

Period Nov 2007 – Dec 2008

Environment Hyperion Essbase 9.3.1, Planning 9.3.1, ODI, IR

OS Microsoft Windows 2003 Server

Role Team Member

Project Description:

This project is involved in the development of data warehouse for City bank based on different kinds of functional areas such as Accounts and Loans. In loans City Bank has loan amounts for various purposes like: Personal Loan, Educational Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The main aim of this project is to provide the analytical data to the Enterprise Management. This project involves in creation of planning applications and generation of reports.

Responsibilities:

• Involved in installation and configuration of Hyperion System9 Products on windows environment.

• Creating the data source, application, data bases, outlines and dimensions.

• Manage the data base to store the planning application data in database

• Written business rules based on requirements to perform calculations on database.

• Perform Meta data and data load.

• Created Users & Groups in Hyperion System 9 Shared Services and given appropriate access to the users for the cubes.

• Designed and developed web forms for the data input as per the business requirements using Hyperion Planning.

• Performance and optimizing outlines/database restructuring, data loads, calculations.

• Installing and configure of Excel add ins for viewing/extracting essbase data

• Develop the report using IR.

PROJECT # 4

California Dept Of Insurance & Finance

Client CDI&F, US

Period Nov 2006 – Oct 2007

Environment HyperionEssbase7.x, HyperionAnalyzer7.x, Excel-Add-Ins, Windows XP, Oracle8i

OS Microsoft Windows XP

Role Team Member

Project Description:

Main aim of this project is to develop the Finance cube and analytical data to the enterprise organization, which can provide data to the end users across the world. The application provides

Information about the expense, Interest earned revenues, Consolidated Profit and loss, etc. The data was loaded for a particular combination of the application members and then Calc Scripts were written to populate the data across the cube. The Cube was refreshed twice a day.

Responsibilities:

• Building Applications and data bases

• Building outlines and dimensions

• Written outline formulas & simple calculation scripts.

• Involved in creating rule files to build dimensions.

• Involved in creating rule files to load data.

• Creating partitioned data base.

• Perform data load.

• Performance and optimizing outlines/database restructuring, data loads, calculations.

• Installing and configure of Excel add ins for viewing/extracting essbase data

• Execute viewer reports to view essbase data.

• Manual Testing

PROJECT # 5 NOAS- National Order Administration System

Client Sprint Telecom , US

Period Dec 2005 – Oct 2006

Environment Core java, Servlets, Jsp, Struts, IBM Websphere, Oracle 8i

OS Microsoft Windows XP

Role Team Member

Project Description: NOAS is a web-based application designed to manage and capture service order assignments and related Service Provisioning Center work activities in a paperless environment. NOAS is a web-based front end to CLAS that will allow the Service Provisioning Specialist to display the next available service order waiting for assignment. ARC will route all unassigned service orders to a work group table in NOAS which will eliminate the need to print unassigned service orders to specific printers in the Service Provisioning Centers.

Responsibilities:

• Analysis of the specifications provided by the clients.

• Involved in development of open source framework struts.

• Coding Action Classes and Action Forms for Struts

• Involved in creating the reports using Jaspers Reports

• Creating the front end screens for application using Servlets, Jsp and HTML

• Unit Testing and write Test Cases

Contact this candidate