Sales Oracle

Kavitha Guddam

(: 215-***-****

(:

*************@*****.***

Professional Summary:

. Seven years of extensive experience in Development, Administration,

Production Support and Infrastructure support(installation and

configurations) of various Oracle EPM/ Hyperion Products and

Applications - Essbase, Planning, Financial Reports, DRM/MDM, HAL, and

Hyperroll

. Experience in latest version of Oracle EPM/Hyperion suite 11.1.1.3

. Experience in global implementations of Hyperion Planning and Essbase

. Experience in general ledger and FP&A functions of global corporations

. Extensive infrastructure experience of various Hyperion products

installation and configuration in both Windows and UNIX environments.

. Experience in full lifecycle implementation of Hyperion Planning

applications

. Experience in Essbase BSO and ASO

. Experience in Performance/UAT testing of Hyperion Applications.

. Experience in Leading New Implementations, supporting existing

applications and Installations.

. Team Lead with excellent Analytical, Communication and Trouble

shooting skills.

. Self-Starter and Adaptive to new technologies.

. Well versed with onshore & offshore implementation and support models.

Technical Skills

. Oracle EPM/Hyperion: Oracle Essbase 11.1.1.3/9.3.1/7.0/6.5, Hyperion

Planning 11.1.1.3/9.3.1, Hyperion WebAnalysis, Financial Reports,EPMA,

DRM/MDM, Excel Add-In, Smart View, HAL, ODI, Hyperroll 4.2, EAS,

Shared Services

. Languages: SQL, PL/SQL, C, C++, Java 1.2

. Databases: Oracle 10g/9x/8i

. Operating Systems: UNIX, Linux Windows 9x/2000/2003/XP, MS-Dos.

. Tools/Utilities: Oracle Toad, RMI, Appworx

. Emulation: Putty, Telnet and Windows Terminal Server

. Others: HTML, Java Scripting, PERL, Weblogic, IIS, Apache

Awards:

. Received "Service Excellence Award" from GE Commercial Finance for

outstanding performance.

. Awarded Star Player of Genpact for excellent performance during

critical situations.

. Bronze Award from AVP of Genpact for successful project deliverables.

. Awarded Star Player of the year 2008 from GE (client-side).

. Awarded Certificate by GE COMFIN Client for an outstanding performance

and contribution to the organization during Hyperion Version

Upgradation and Hyperroll Upgradation

Education:

. Bachelor of Technology in Computer Science - May 2003 - JNTU,

Hyderabad, AP, India.

Professional Experience:

GENPACT Aug 2008 to

till date

Client: GE Commercial Finance, Danbury CT.

Role: Hyperion DRM/MDM System Administrator

GE Commercial Finance uses a centralized approach for managing all its

dimensional Master Data related to all its businesses. All the hierarchal

Meta Data is now maintained in a centralized server called as Hyperion

Master Data Management. It provides a centralized, transparent process for

managing critical business performance management master data that drive

enterprise reporting.

Responsibilities:

. Responsible for requirements gathering for the implementation of

Hyperion DRM

. Development of hierarchies and attributes using import and automator

scripts.

. Responsible for creation of validations and verifications as per the

Business needs for validation of data through DRM.

. Responsible for maintaining data mappings of accounts and other

hierarchies.

. Responsible for maintaining and administering security permissions for

users and groups.

. Responsible for defining and creating batch scripts for automation in

import and export using DRM.

. Responsible for installation and configuration of SOA for deploying

the DRM request client application.

. Responsible for setting up the properties, property categories, system

preferences and queries in DRM.

. Provided documentation of all the technical and functional issues

which would be helpful to users for future reference.

. Assigning of Node access group and property categories to Users and

groups.

. Creation and deletion of Versions, Hierarchies, Exports, Imports,

Properties, Property Query, Node Access groups, Blenders, System

Categories.

. Adding properties to Property categories.

. Creation of Node Types and adding Properties and

Validations/Verifications to Node types

. Involved in Creating of Blender to synchronizing two hierarchies of

different version in terms of their structural differences.

. Automated the import and export process of MDM hierarchies using

Appworx tool

. Troubleshooting issues related to MDM.

. Automated the MDM migration process and handled migrations between

different environments.

. Building exports for loading into Hyperion Planning, Essbase and HFM

applications and troubleshooting the build issues.

. Planning refresh and other application related issues.

. Performed upgrade of DRM from 9.2.0 to 11.1.1.3 version

. Assisted upgrade other Oracle EPM/Hyperion products from 9.3.1 to

11.1.1.3

. Testing of Hyperion Products

. Migration of applications

. Installation and configuration of Hyperion products

. Applying Hyperion security patches.

. Performance tuning of Hyperion Essbase.

. Developing Load rules, calc scripts for Essabse applications.

. Automation of cube builds, maintenance of Essbase operations such as

Backups, Defrags etc using PERL scripts.

. Developing Backup and Recovery Shell scripts.

. Technical trouble shooting and maintenance

. Having good knowledge in using new features of Oracle EPM/Hyperion

latest suites like Enterprise Performance Manager Architect (EPMA),

Calc Manager.

. Performed conversion of Essbase BSO cubes to ASO

Environment: Hyperion DRM/MDM 11.1.1.3/9.2.0, Hyperion Planning 11.1.1.3,

Essbase 11.1.1.3/9.3.1, Windows Server Enterprise version 2003, MS-SQL

Server, Appworx 6.1

GENPACT Jun 2006 to

Jul 2008

Client: GE Commercial Finance, Danbury CT.

Role: HyperionAdministration (Application and Infrastructure Support)

GE Commercial Finance is one of General Electric's largest "growth engines"

with Lending Products, Growth Capital, Revolving lines of Credit, Equipment

Leasing of every Kind, Cash Flow Programs, Asset Financing, and more. GE

Commercial Finance plays a key role for client businesses all across the

world. Hyperion is implemented in all of the GE COMFIN businesses (CFS,

CAP, EFS, HFS, GECAS, CFA and CSE), with all business reporting to CFC

(Corporate).

Hyperion SME is the Hyperion Infrastructure Support team in GE that

provides 24/7 support on Hyperion Applications across the GE COMFIN domain.

The team consists of six members (5 offshore, 1 onsite support). Currently

the SME (Subject Matter Expert) team supports nine businesses across GE

Comfin.

Responsibilities:

. Performed upgrade of Hyperion Systems from pre System 9 to System 9

. Performed installation and configuration of System 9 products

. Migration of applications, objects and reports from older version to

new version

. Testing of migrated applications in new environment

. Mastered high level trouble shooting of all the infrastructural

activities related to Hyperion products (Hyperion Essbase, Planning,

EAS, Reports, Analyzer, Hyperroll, HAL)

. Individually handled many outages (planned as well as unplanned) like

reboot of all the servers which happens on every third fiscal week,

day light savings, OS patches etc.

. Pioneer (in the team) in preparing proper SOP's for all the Hyperion

infrastructural activities (migrations, DR process, access related

issues, automations using Appworx)

. Played a pivotal role in installation and up gradation of Hyperion

Essbase, Reports, HAL between different environments for CFA, CAPSOL,

CSE business.

. Handled migration of applications (all data and level 0) between

different environments.

. Played a vital role in resolution of infrastructural issues on server-

side before going-live in production.

. Installed Essbase on Linux, Planning on Windows 2003, Reports on UNIX,

Planning Web

. Automated the backup process for all the applications of all

environments using Appworx tool.

. Took the lead in Disaster Recovery process when all the production

servers went down.

. Trained new Associates joining the team.

. Hands-On experience in writing queries in database and shell scripts

in UNIX.

. Good hold of UNIX commands and Appworx tool which involves creating

and trouble shooting chains.

. Found out the root cause (RCCA) of application corruption due to

signal 11 crash in Essbase 6542 version. Implemented the fix in all

the environments (prod, qa and dev). Was involved in coming up with a

permanent fix to all the issues, which were repeating.

. Worked closely with Hyperion Support (USA, Aus and Europe) Analyst's

for unresolved issues faced during troubleshooting Hyperion products.

. Presented many lean (which reduced lot of Non value added work) like

creation of chain to restart 20-25 server's at a single go using

appworx tool, automated the reports restart on 16 servers with one

login.

. L1-certified in the project

. Applying RCCAs (Root cause corrective action) for repeated issues

. Creation of Applications in System9 environment.

. Handled migrations (both Essbase and Planning), adding user and groups

in System9 environment

. Involved in documenting all the RCCA's, PPA, SOP's and more

. Supported more than 30 applications in production both functionally

and technically.

. Took Ownership and lead the Defragmentation maintenance for all

critical production applications in order to make smooth Quarter close

. Automated the CFS business activities through appworx chains which

updates the new accounts in Essbase closing cubes on daily basis, with

Zero Defects, resulting in NO Manual dependency on Nightly Cycle

processes

. Took charge of maintaining GIS Outage Tracker for all GE COMFIN

business consistently for a very long period.

. Performed Essbase Upgrades/Migrations from version 6.5.4 to 7.1.5 for

all business.

. Played a key role in the performance testing of planning and closing

applications before being deployed to production.

. Troubleshooting issues during 7 version installation/Application

migrations.

. Prepared implementation/Rollback plans for Hyperroll Upgrade

. Performed up gradation of Hyperroll

. Performed UAT after upgrade

. Conversion of BSO cubes into ASO cubes and development of MDX formulas

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1/3.5.1,

Financial Reports 11.1.1.3/9.3.1/7.0.1.2, HAL7.0, Websphere 5.0, Weblogic,

Oracle 10g/8i, Oracle GL, Hyperroll 4.2, Windows 2003 server, Linux, HP

UNIX.

Tata Consultancy Services Apr

2004 to May 2006

Client: TARGET Corporation, Minnesota, MN

Role: Essbase Developer & Database Developer/Support

The aim of Expense Report Planning System (ERPS) was to analyze the

historical information of the corporation stored in relational format and

flat file format and use it for budgeting purpose. Profitability

and expenses are were compared and calculated depending on sale of products

made during various seasons, holidays, weekends and normal days for each

zip code area. Sales per quarter, average budget per quarter was

determined. Overheads including salary of employees, damaged goods, and

security systems were taken into account for calculating the yield per

year/ quarter/ month/day.

. Designed, developed, and implemented Expense Planning and Reporting

System for the Financial Department at Target Corporation using Essbase

6.5.1, for better decision-making by Top Management.

. Developed and optimized Data Loads and Calculations.

. Designed and developed monthly, quarterly and yearly Retail P&L Cubes.

. Developed Calc Scripts to calculate various figures for the outline.

. Involved in weekly meetings, to discuss current project status.

. Involved in checking the status and progress of each planning unit so as

to analyze variances in real time, revise, promote, reject and approve

plans.

. Worked on PL/SQL for writing Stored Procedures, Packages, Functions and

Database Triggers.

. Developed PL/SQL scripts for back end validation/ updates.

. Production support for month end and quarter end close process

. Production support for annual budget cycle

. Installation and configuration of Hyperion Essbase, Planning, client

tools and other related activities

. Set up of new planning applications

. Migration of planning applications and essbase databases from one

environment to another environment

. Performance tuning of Essbase data loads and calc scripts

. Development of reports using Excel VBA, Hyperion Reports and Analyzer

tools

. Partitioning of Essbase applications using replicated and transparent

methods

Environment: Hyperion Essbase 6.5.1, planning 3.5, Microsoft Excel 2000,

Oracle 8i, PL/SQL, SQL*Loader, MS SQL Server 7.0, Windows NT 4.0, UNIX

Metamor, Hyderabad, India Jul 2003 to

Mar 2004

Database Developer

The Sales Order Processing application was a tool designed to manage all

phases of the Sales Order Process lifecycle - from the receipt to the

completion of an order. Main functions included Enquiry Recording,

Quotation Generation, Purchase Order Recording, Order Acceptance

Generation, Order Allocation Generation, Purchase Requisition Generation,

Sales Work Order Generation, Delivery Note Generation and Invoice

Generation.

. Responsible for determining the database requirements for the application

and designed database using Oracle 8i.

. Involved in Writing Oracle Packages, Procedures, Functions and Triggers

using Oracle's PL/SQL Structures to enforce business rules and/or

relationships uncovered in the data model.

. Created tables, indexes, views and audit triggers.

. Used Oracle's Export/Import utility to move data from one environment to

another.

. Migrated data from the legacy system to Oracle. Involved in Unit testing

and bug fixing.

. Responsible for monitoring the day-to-day activities for the application

on the production environment.

Environment: Developer 2000, Oracle 7.3, PL/SQL, SQL*LOADER, Windows NT/98.

Contact this candidate