Project Technical Support

PAVAN KUMAR VADLA

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

FREMONT, CA 94555 CELL#510-***-****

LinkedIn: linkedin.com/in/pavanvadla/

EXPERTISE : Oracle EPM, Hyperion Planning, Essbase(BSO and ASO), DRM,DRG

Web Analysis, Financial Reporting, ODI, DRM, Smart view, HVE, Calculation

Scripts, Maxl Scripts, Business Rules, MDX,Exalytics,Version 7 to latest

11.1.2.2.

EXPERIENCE : 11 Years

PROFESSIONAL SUMMARY:

With more than 10 years of strong technical background and functional domain experience, am

an techno-functional enthusiastic who always strive for continuous advancements, learning new

technologies and performing a detailed value-add analysis, suggesting business process

improvements for optimal resource utilization. My ability to co-ordinate and work with cross-

functional teams and excellent analytical & communication skills would bring immense business

value.

I am a IT professional with subject matter expertise on Corporate FP&A, Sales & Marketing, and

highly skilled in Oracle EPM tools like Hyperion Planning, Essbase and Reportingspace,etc.

As a team lead for a customer facing BI team, was involved in business requirement meetings,

creating functional and technical design documents, mentoring and guiding the Onsite-Offshore

teams and providing quality deliverable on-time, with performance and user satisfaction as a

highest priority.

I have conducted numerous training sessions for users of varying departments/levels and created

training manuals as a self-starter kit.

Specialties: Hyperion Planning, Essbase, Hyperion reporting tools, Business Intelligence

reporting, Finance, Sales & Marketing, Supply Chain, Tableau, Data Quality & Data Governance

EDUCATION:

• Bachelor of Engineering (B.E) in 2003

• Diploma in Engineering

WORK EXPERIENCE:

• Zensar Technologies Inc,San Jose,USA

• Zensar Technologies Ltd,Pune,India

• Bearing Point Business consulting Ltd,Bangalore,India

KEY ACHIEVEMENTS:

• Received Outstanding Performance Award for a client engagement - Logitech.

Page 1 of 6

PAVAN KUMAR VADLA

34209 KASPAR TERRACE ***************@*****.***

FREMONT, CA 94555 CELL#510-***-****

• Awarded “SPOT” award for extraordinary performance in Business Intelligence practice -

Zensar Technologies

Project 1

Client : Logitech

Role : Lead Consultant

Location : Fremont, USA

: Oracle Data Relationship Management & DRG 11.1.2.3

Technology

Team Size :3

Scope : Designed, Implemented DRM and DRG for Logitech organization hierarchies.

Responsibilities :

o Requirement gathering

o Designing the business requirements into application design

o DRM Version and Hierarchies setup

o DRG workflows, Properties and validations

o COA requests workflows

o Integration to downstream systems (EBS,EDW,HFM and Essbase)

o Security setup

o Engaging work to offshore

o Delivery and Team management

Project 2

Client : Logitech

Role : Lead Consultant

Location : Fremont, USA

Technology : Exalytics,EPM 11.1.2.2,ODI,Hyperion Planning system9, Hyperion BI+

Analytic Services,HAL,Exadata,PL/Sql,OBIEE

Team Size :6

Scope : Designed, Implemented and supported multiple Hyperion essbase and

planning projects

Responsibilities :

o Onsite coordinator and Hyperion support lead

o Hyperion Planning, essbase system architect,designer and

developer

o Exalytics and Exadata migration

o Direct interaction with AMR and Corporate Finance business

partners

o Direct communication/point of contact to both client and Zensar

project managers

o Planning and Budgeting support for AMR and corporate finance

o Development

o GL and AR data support

Page 2 of 6

PAVAN KUMAR VADLA

34209 KASPAR TERRACE ***************@*****.***

FREMONT, CA 94555 CELL#510-***-****

o General Hyperion applications support

o Month end and quarter end close support

o Requirement gathering

o Designing the business requirements into application design

o Engaging work to offshore

o Team management

Project 3

Client : Aditya Birla Retail Ltd. (One of the largest retailer in India)

Role : Technical Consultant

Location : Mumbai

Technology : Hyperion Planning, Hyperion BI+ Analytic Services

Team Size :6

Scope : Budgeting & Forecasting Application Implementation

Responsibilities :

o Hyperion Planning Application Creation

o Web Form design and creation in Planning Application

o Development & testing of Business Rules

o Development of Report Scripts

o Development of MaxL Scripts

o Preparation of Security Matrix & applying security as per matrix

o Installation of Hyperion Essbase, Planning and Reporting services

o Performance tuning of calculation scripts

o Development of Financial and Web Analysis reports

o Migration of applications from Development to Production server

o Automation of back up process

o Preparation of User Guides, System Design Documents

Project 4

Client : Thomas Publishing Co.

Role : Hyperion Technical support

Technology : Hyperion Planning, Hyperion Essbase, Hyperion Reports, Web

Analysis

Team Size : 1 Offshore

Scope : Hyperion Planning, Essbase, Financial reporting and Web Analysis technical support

Responsibilities:

• Resolving Hyperion technical issues.

Project 3

Client : Thomas Publishing Co.

Role : Hyperion Technical Lead

Technology : Hyperion Planning, Hyperion Essbase, Hyperion Reports, Web

Analysis

Team Size : 2 Onsite + 2 Offshore

Scope : Hyperion Financial reporting and Web Analysis Deployment.

Page 3 of 6

PAVAN KUMAR VADLA

34209 KASPAR TERRACE ***************@*****.***

FREMONT, CA 94555 CELL#510-***-****

Responsibilities:

• Hyperion Environment setup at the client side on Linux

environment.

• Installed Hyperion Planning, Essabe, Financial Reports, Web

Analysis.

• Created Planning applications

• Created Hyperion Financial reports and Web Analysis reports.

• Managing Security setup using shared services utilities.

• Documentation of the entire Installation and hardware

configuration of Hyperion servers.

• Training the IT support team for troubleshooting the Hyperion

servers.

• User documentation and training.

Project 5

Client : BMC Software Ltd.

Role : Hyperion Support Lead

Technology : Hyperion Planning, Hyperion Essbase, Hyperion Reports

Team Size : 2 Offshore + 2 Onsite

Scope : Hyperion Technical Support & Deployment

Responsibilities:

• Resolving Hyperion technical issues.

• Managing Production deployment.

• Managing Hyperion Application Migrations & Security setup

using shared services utilities.

• Developed automation process using Maxl.

• Schedule batch scripts using Control-M.

• Documentation of the entire project for traceability and reference

perspective

Page 4 of 6

PAVAN KUMAR VADLA

34209 KASPAR TERRACE ***************@*****.***

FREMONT, CA 94555 CELL#510-***-****

Project 6

Client : General Motors (Europe)

Role : Senior Consultant

Location : Pune

Technology : Hyperion Planning, Hyperion Essbase

Team Size : 3 Offshore + 2 Onsite

Scope : Plan & Define, POC

Responsibilities :

• Business Process Analysis and documentation.

• Led offshore development team

• Created Prototype using Hyperion Planning and Essbase based

on the design specifications

• Building application, create web-forms, write business rules and

create reports as per technical specification

• Documentation of the entire project for traceability and reference

perspective

• Understanding the Component Delivery Plan.

Project 7

Role : Consultant

Client : Target Retail (US)

Location : Bangalore GDC

Technology : Hyperion Reports, Hyperion Analyzer, HFM

Team size : 4 + 2 Onsite

Scope : Plan & Define, Construct Reports and Deploy

Responsibilities :

•Involved in gathering reporting requirements

•Report Template creation in Hyperion Reports

•Reports Development & Testing in Hyperion Reports and

Hyperion Analyzer

• Support during Deploy Phase

Project 8

Role : Developer

Client : General Motors (Europe)

Location : Bangalore GDC

Technology : Hyperion Planning, Hyperion Essbase,

Hyperion Reports, DataStage

Team size : 10 Offshore + 2 Onsite

Scope : Plan & Define, Construct to Deploy

Responsibilities :

• Created Action Plans for individual components to be developed

using Hyperion Essbase / Hyperion Planning

• Developed & Tested Business rules, Calculation scripts

• Developed Report scripts and Hyperion Reports

• Developed Data Load Rules and Business Rules Sequences

• Provided Support during UAT & Deploy Phase.

Page 5 of 6

PAVAN KUMAR VADLA

34209 KASPAR TERRACE ***************@*****.***

FREMONT, CA 94555 CELL#510-***-****

Project 9

Role : Level 2 Support

Client : General Motors (USA)

Location : Bangalore/China

Technology : Hyperion Planning, Hyperion Essbase,

Hyperion Reports

Team size : 15 Offshore + 5 Onsite

Scope : Off shore support from China for Hyperion Applications for

General Motors

Responsibilities : To support general motors in production environment.

Given Training to Chinese people on Hyperion

• Involved in Outline Hierarchy changes as per client requirements

• Involved in user administration and data investigation

• Involved in month end data loading

Project 10

Role : Development team member

Client : AFLAC Insurance

Location : NY, USA

Technology : Informatica 5.1, Oracle 9i

Team size : 6 Offshore/2 onsite

Scope : Offshore Development, Testing & Support

Responsibilities : Created mappings to extracting data from flat files and production

systems to stage using Informatica designer. Using Informatics

to extract data from flat files and load to oracle database.

• Designing mappings in Informatica Designer to extract data from

Stage and load to Data warehouse

• Cleansing and processing data from stage to data marts using

Informatica transformations

• Performed the Tasks of Validating, Execution and scheduling the

sessions in Informatica

Page 6 of 6

Contact this candidate