Sowmya Karnati [pic]

Contact +91-897*******

E-mail : abk33v@r.postjobfree.com

Career Objective:

To be committed and perform at the highest level of potential,

satisfaction and subsequently making success a habit in the challenging

environment. While being resourceful, innovative and flexible, I can learn,

acquire domain knowledge and effectively utilize my IT and related

experience.

Professional Experience

Current Organization Role Total Experience

HCL TECHNOLOGIES LIMITED Developer April 2011 till date

Professional Summary:

> Having 3 Years of Software Development Life Cycle implementation

experience of Business Intelligence using Oracle Hyperion products

like Hyperion Essbase, Hyperion Planning,Hyperion Shared Services,

Financial Data Quality Management and Oracle Data Integrator.

> Strong understanding of Hyperion Architecture.

> Creating Planning Applications and Design & development of Cube.

> Metadata Loading and Actual data loading using Outline

Load Utility.

> Experience in design and development of Web Forms,

Hyperion Financial Reports, WorkFlows, Task Lists, Menus and Smart

Lists.

> Loaded data manually and using Automation techniques using MaxL

Scripts into the outline developed for data cube.

> Maintain outline, metadata, and member formulas as

business requirement changes.

> Automation of dynamic dimension building & Loading in to the Cube

using MaxL Scripts.

> Hands-on expertise on EPMA Planning Applications; building

dimensions, worked on loading text data. Have good expertise on

Dimension and Application Library.

> Well versed with Financial Data Quality Management (FDQM);

mappings, locations in loading the data.

> Enhanced various calc- scripts as well as business rules.

> Excellent working knowledge in writing calculation scripts & MaxL

statements commands in Essbase.

> Knowledge on using Oracle Data Integrator (ODI) and Financial Data

Quality Management (FDM)

> Optimization of Cubes while loading, retrieving and

calculating using different techniques (Hourglass method,

Cache Settings, Buffer settings, Configuration file settings &

others).

> Security using Shared Services to create Users & giving Provisions

and restricting permissions.

> Good knowledge of Data Ware housing concepts and BI applications.

> Good analytical & troubleshooting experience with good exposure to

latest technology.

> Possess Ability and Willingness for learning

new applications as needed.

> Active team player with excellent inter personal skills,

keen learner with self-commitment& innovation.

Certifications:

Hyperion Planning 11 Essentials Certified.

Academic Qualifications:

> B.Sc. (Computers) from Nagarjuna University, Guntur.

> M.C.A from JNTU, Kakinada.

Technical Skill Set:

OLAP Tools: Hyperion 11.1..3, Hyperion 11.1.2.1,Hyperion

11.1.2.2,Hyperion 11.1.2.3 product

like Hyperion Essbase, Hyperion Shared Services,

Data Relationship Management, Financial Data Quality

Management

And Oracle Data Integrator.

Reporting Tools: Hyperion Web Analysis, Hyperion Financial Reporting,

SmartView,

Excel Add-In.

Operating Systems: Windows XP, Windows 7, Linux.

Databases: Essbase, Oracle 11g.

Project Experience

Title Hyperion Planning Implementation.

Client ADWEA

Duration May 2013 - till date

Environment Hyperion Essbase, Planning 11.1.2.3, DRM, ODI, FDM, Oracle

11g, Smart view 11.1.2.3, Windows 2008 R2.

Description:

ADWEA is a financially and administratively independent government

subsidiary working for citizens in efficiently producing, distributing

Water & Electricity. ADWEA Group has 7 entities for which its resource

management is performed using Public Sector Planning and Budgeting (PSPB)

and Project management is performed using Project Financial Planning (PFP)

having ODI, FDM along with ERPI as integration tools and DRM for Master

data management during Implementation.

Roles & Responsibilities:

> Application Creation in Hyperion PSPB Application as Position and

Employee Detail and PFP Application including Workforce

initialization. Worked on the annual budgeting and forecast updates

for 5 years Planning and Reporting.

> Worked on loading Dimensions into PSPB and PFP Application through

ODI.

> Loaded Data into HCP and Project Plan types using FDM.

> Adept in working with Compensation Budget dimensions loaded into

Human Capital Planning (HCP) plan type such as effective- dated

salary, benefit assignments, and HRMS-GL account allocation

percentages.

> Developed ADWEA HR policy tables pertained to Employee's

Compensation entitlements based on which Employee's Budgeting is

calculated.

> Worked with web forms as per the requirement and customized the

default forms and accomplished the requirement even with Composite

Web forms.

> Implemented automated Business rules and Variables in fulfilling

the Budgeting and Planning logic without manual calculation in the

Budget Preparation.

> Took the admin role in populating the line item budget by mapping

HCP dimensions and members to General Ledger accounts segments and

chart fields through XWrite functionality.

> Maintained dimension loading and data loading rule-files for

Automation process.

> Created Task-lists and assigned to users for security purpose.

> Created users and user groups in Hyperion Shared services and

assigned web forms to the users as per the privileges.

Title Hyperion Planning Implementation

Client Topps

Duration Jun 2012 - Apr 2013

Environment Hyperion Essbase, Planning 11.1.2.1, ODI, FDM, Oracle 10g,

Smart view 11.1.2.1, Windows 2008 R2

Description:

The Topps Company is the preeminent creator and brand marketer of

sports cards, entertainment products, and distinctive confectionery. Topps

leading sports and entertainment products include Major League Baseball,

National Football League, English Premier League, Bundesliga, Indian

Premiere League, WWE, UFC, Wacky Packages, Garbage Pail Kids and other

trading cards, sticker album collections, and collectible games. The

Company's top confectionery brands include "Ring Pop," "Push Pop," "Baby

Bottle Pop", "Bazooka" bubble gum, "Sharkies" and "Juicy Drop Pop"

products.

Roles & Responsibilities:

> Application Creation in Hyperion Planning

> Loading Metadata into the planning application.

> Developed web forms using Hyperion Planning web client for the

users to input Forecast, Budget, Actual, Accounting changes

and other variance explanations data.

> Created Calculation scripts & Variables as per the requirement.

> Developed Business rules and attached to the input forms to

calculate data on save Option.

> Created users and user groups in the Planning applications and

assigned security to web forms.

Title Planning and Essbase Implementation

Client Integrated Performance Management Solution

Duration Dec 2011 - May 2012

Environment Hyperion Essbase/Planning 11.1.2.1, DRM,

Smart View 11.1.2.1, Oracle 10 g, Windows 2008 R2.

Description:

Integrated Performance Management Solution (IPMS) is the HCL Vision

for Banking and Financial Institutions in providing Operational

Solutions,EPM and Analytical Solutions, Enterprise Performance Management,

GRC Solutions with the aim of redefining the Banking Performance

Management, HCL proposes EPM Blue Print with an Integrated Solution

encompassing the key business and performance drivers of Banking viz

Planning & Budgeting, Forecasting & Modeling, Extended Performance

Management, Dashboard and Analytical Reporting .It is proposed with the

best of breed and established solutions - DRM, Data Mart, OFSAA, Hyperion

and OBIEE.

Roles & Responsibilities:

> Application Creation in Hyperion Planning and Metadata is

loaded into the planning application through rule-files and the

created rule-files are being used for Automation whenever new

member is added.

> Created Versions, Hierarchies, and Property groups in DRM.

> Batch scripts are created to load metadata from DRM to Hyperion

Planning application whenever new member is added to the

Hierarchies.

> Developed web forms using Hyperion Planning web client for the

users to input Forecast, Budget, Actual, Accounting changes and

other variance explanations data.

> Created Calculation scripts & Variables as per the requirement.

> Developed Business rules and attached to the input web forms to

calculate data on save Option.

> Created Task-lists and assigned to users for security purpose.

> Created users and user groups in the Planning applications and

assigned security to web forms.

Title Essbase Upgrade

Client Teradyne Inc.

Duration Jul 2011 - Nov 2011

Environment Hyperion Essbase 11.1.1.3, Hyperion Shared services, Excel

Add-In, Linux.

Description:

Teradyne designs and Manufactures automatic test Equipment that

delivers competitive advantage to world leading electronics companies.

Teradyne has the existing Essbase in 7.x on windows which has to be

migrated to Essbase 11.1.1.3 on Linux box.

Roles & Responsibilities:

> Understanding of Existing System.

> Taking the Lev0 data backup for all the applications.

> Taking the entire app directory backup excluding data files.

> Placing all the backups in the staging area.

> Creating applications and databases.

> Move the Outlines, Rulefiles and Calcscripts to the respective

databases.

> Verifying and Restart the applications.

> Moving the Lev0 data from staging to the respective applications.

> Loading the Lev0 data application by application.

> Data Reconciliation with Old and New System.

> Shared services user setup.

> Writing and validating test cases.

> Provided and scheduled automated scripts on services stop and

start, daily data backup and archiving database.

> Involved in Preparation of Design Document, Test plan document, UAT

Manual, Installation document.

Title Essbase Implementation

Client Internal Project

Duration April 2011 - Jun 2011

Environment Hyperion Essbase 11.1.1.3, Hyperion Shared services,

Excel Add-In, Windows.

Description:

The objective of the project was to build a data mart using Essbase

cube to do adhoc analysis on sales date. With the available reporting

template and data files, identified dimensions required to build the

Essbase data mart using OLAP dimensionality & loaded actual and budget data

to do variance analysis on the sales KPI's involving rule file, calculation

scripts, generating reports and assigning security to application.

Roles & Responsibilities:

> Study the reporting template provided by business and source data

files

> Identified required dimensions for reporting & developed dimensions

> Build outline using rule file & loaded data using rule files

> Created attribute members, Formulas, Substitution Variables, to

arrive a simple calculations

> Developed calculation script to calculate sales incentive based on

the % of product wise sales

> Developed smart view template for adhoc reporting on actual Vs

budget reporting

> Security setup in Hyperion Shared Services for users.

> Tested the requirements & fixed the issues

> Prepared knowledge transition document on the requirement and

approach.

About Me:

Name : Sowmya Karnati

Father's Name : Samba Siva Rao

Languages known : English, Telugu

Present Address : Flat No:502,IndraPrastha Aprt,AnjaneyaNagar,Moosapet,Hyd-

500018

I here by declare that the information furnished above is

true to the best of my knowledge.

(Sowmya Karnati)

Contact this candidate