Manager Software Engineer

B. Ramesh Babu ( : **********.********@*****.***

( : +804*******

Intend to build my career with a leading corporate which will help me to

utilize my capabilities in a optimal way.

Summary:

> Overall Experience of 6+ Years in Data Analysis, Development,

support and Reporting using Hyperion Essbase, knowledge on Planning,

Data Relationship Management, Reporting Tools, IBM DB2 SQL, Toad Sql

and Unix Commands.

> Developed numerous Essbase MDDB applications with excellent balance of

dense and sparse dimensions, developed various OLAP Models & Meta-

Outlines

> Involved in Smart view Pilot for upgrading from Excel add-in to Smart

view.

> Responsible for change order submission for migrating the

enhancements/defects for production migration scripts

> Developed and maintained Rule files, MaxL Scripts.

> Having knowledge on Hyperion planning

> Optimized and tuned performance for Data Load/Calculations.

> Proven ability to work in both in an individual role as well as in

cross - functional teams

> Possess good technical acumen, oral & written communication,

analytical and interpersonal skills.

> Having knowledge on Agile Process

Professional Profile:

. Currently working with Capital One Bank as Senior Software Engineer

from Mar '11 till date

. Worked with IMB Denmark, Bangalore as Software Engineer/Business

Analyst from July '07 to Mar'11.

Technical Skills:

Business Intelligence : Hummingbird BI Query (BI Reports)

Languages : Sql/PlSql, C, UNIX

Databases : Oracle, Toad, IBM DB2 SQL

Operating Systems : Windows XP, 2007

Software Tools : Hyperion Essbase, Calculation Manager,

Essbase Integration Services, Hyperion DRM, Hyperion

Interactive Reporting, Smart

View/Excel - Addin

CAREER SUMMARY:

(Sep 2013 - Till Date)

Role: Developer for Retail Stores (Ross Stores, Dublin, CA)

Responsibilities:

. Involved in creating multi-dimensional Essbase Cubes.

. Developed Essbase applications and loaded data from flat files, Oracle

and SQL SERVER.

. Responsible for developing the new Calculation Scripts, Report Scripts

in existing and new applications as per the requirement of the Client.

. Developed calculation scripts, rule files using different reference

methods.

. Automated data load, outlined process updates using ESSCMD. Optimized

data, index cache settings and database size.

. Responsible for reviewing and testing of all the Calculation Scripts

and the member Formulas using excel Add in and the Smart View prepared

by team members.

. Creating the applications in new planning environment and loading the

Dimensions with the batch file.

. Migration of all the Business rules to Hyperion Calc Manager.

. Validating all the rules and rule sets in the Calc Manager and

deploying the Business rules to Hyperion Planning (Upgrade).

Capital One Bank

(Mar'11 - SEP '13)

Role: Developer for Leading US Bank (Richmond, VA )

Responsibilities:

. Involved in the Upgradation of all the Essbase and Planning objects

from Version 11.1.1.3 to 11.1.2.

. Involved in the requirements and design document inspection meetings.

. Involved in creating multi-dimensional Essbase Cubes.

. Modified the Calculation Scripts for the new functions incorporated in

the version 11.1.2.

. Developed Essbase applications and loaded data from flat files, Oracle

and SQL SERVER.

. Responsible for developing the new Calculation Scripts, Report Scripts

in existing and new applications as per the requirement of the Client.

. Developed calculation scripts, rule files using different reference

methods.

. Automated data load, outlined process updates using ESSCMD. Optimized

data, index cache settings and database size.

. Responsible for reviewing and testing of all the Calculation Scripts

and the member Formulas using excel Add in and the Smart View prepared

by team members.

. Creating the applications in new planning environment and loading the

Dimensions with the batch file.

. Migration of all the Business rules to Hyperion Calc Manager.

. Validating all the rules and rule sets in the Calc Manager and

deploying the Business rules to Hyperion Planning (Upgrade).

. Testing all the Business rules, Webforms and securities in Planning.

. Prepared high level Design and the code review Documents.

. Possess Hands on Experience on analysis, design, development,

customizations and implementation of software applications.

IMB Denmark &GDMIT Billing

(Jun '07- Mar '11)

Responsibilities:

. Involved in Design & Development of new reports, Queries from given

Functional Specifications.

. Involved in production support, analysis and development work.

. Involved in outline modifications, maintenance of batch scripts,

scheduling runs, developing report scripts, load rules and calc

scripts.

. Responsible for Reviewing and testing the Queries and preparing the

test cases.

. Analyzed the given data to provide insights based on business

requirements.

. Resolved day-to-day technical and Functional issues.

. Translated customer requirements into formal requirements and design

documents called TSD (Technical Specification Document).

. Responsible for KT on Hyperion IR, Essbase, SQL to other teams like

ITD GD and ITS GD Organizations

. Responsible for creating the Interactive Reports useful for data

extraction. This will be very useful to the ones who are not

comfortable writing SQL queries.

. Single Point of contact for trouble shooting/updations in

Hyperion/Brio Report changes.

. Detailed documentation for all completed projects for the benefit of

the concerned client.

Project # 2 GDMIT: Autobilling Solutions

Customer IBM India Pvt Ltd

Period August 2007 to March 2011

Description The Main aim of this project is to automate the

Billing (Labore and Expense) by eliminating the

manual billing process. Employees claim their

hours through the ILC system, then recoveries

are automated through the BMS system. This

clocking system enables the ability to bill the

end customer directly based on ILC clocking.

Hours and cost breakups flow to requesting

country ledger and reporting. Billing system

depends upon Employees clock hours details,

rates set up against the employee levels.

Employees' claims their expenses in the WWER

system. Expense costs directly flow to the

Requesting country ledger and cost recoveries

will be done automatically.

Role

Business Analyst/Developer Team Size :

08

Responsibilities Capturing requirements from Client

Preparing design documents.

Develop calc script, Business Rules, Load Rules

and Report Scripts and EIS filters.

Create new batch scripts using ESSCMD/MaxL for

the automation of Objects.

Preparing test cases documents for unit testing

Maintain all process related documents.

Solution Environment Hyperion Essbase Administration

Services,Integration Services, Hyperion

Interactive Reporting, DB2 Sql

Highlights Gathering Enhancement requirement.

Requirement Analysis.

System Analysis and Design.

Involved in several team building exercises.

Support the existing production BI application.

Demos of screens to users as functionality are

available.

Onsite Offshore Communication.

Educational Qualifications:

. M.C.A (Master of Computer Applications) 2007, G. Pulla Reddy

Engineering College, S.K University

Contact this candidate