Manager Customer Service

Professional Summary

*+ years of IT experience with Four and a half plus years of internal and

external analytical systems consulting experience in financial services,

healthcare, retail and services industries. Hyperion Certified Professional

and Hyperion Certified Consultant. Knowledge base includes project

evaluation, project planning / execution / management, systems development,

process re-engineering, pre-sales proof of concept, financial and

operational planning / analysis / reporting, and extensive data mart

planning and data architecture skills. Development experience with Hyperion

Essbase OLAP and related front-ends tools, including the latest Hyperion

System 9 framework. Professional experience includes business intelligence

and systems consultant, leveraging extensive business knowledge and

technical skills. Innovative, tenacious, entrepreneurial, and a team player

dedicated to achieving objectives.

Technical Tools: ODI, FDM, MAXL, ESSCMD, MDX, Calc Manager, Calc Scripts,

Business Rules, Shared Services, Automation, Dimension Load/Data Load

Rules, Report Scripts, and ASO cubes

Professional Experience

ISA Consulting (Business Performance Management) Apr 2007 to

Present

Hyperion Lead Consultant

Full-System Development Life Cycle Projects:

. Sallie Mae: Current Project: Duration: 2 months: Location: Reston, VA

Description: Mainly work on design and development of different cubes

used for creating reports about various business strategies, decision-

making and future planning. Fulfill reporting requirements for 2

different reporting business units and allocate costs

Responsibilities:

o Work on a 5-stage Top-Down Budget Allocation Process for Financial

Reporting needs.

o Project involves the use of Replicated Partitions, automated data

load process complex calculations scripts and ad-hoc analysis based

on Business units. Building Reports using Financial Reporting

Studio and VBA macros in Excel Reports. Work on building interfaces

used to load dimensions and data. Improved calculation performance

and resolved calculation time bottlenecks by over 60%.

o Tools Used: Essbase, BSO, ASO, MAXL Replicated Partitions, Calc

Scripts, Reports

o Environment: Hyperion Essbase 11.1.1, Financial Reporting Studio,

Excel 2007

. Associated Press: Duration: Total 2.5 years; 9 months of full-time and

1.5 years of part-time support: Location: Manhattan, NY

Description: Work with the FP&A team to support their analytical

reporting requirements. The scope of the project included Profit-Loss,

Payroll, and Revenue database. A fast and efficient real-time support

system was the goal of the project. Other deliverables included sourcing

data from 3 different ERP systems such as SAP, Microsoft CRM, and Ross.

AP achieved high-level budgeting reports with a drill-down capability.

Hyperion increased efficiency, performance and reporting accuracy. Also

work on Dashboard Reports for corporate using Web Analysis.

Responsibilities:

o Used ODI to load metadata and ASO databases for Reporting. Created

Planning applications, applied Shared Services Security on

Users/Groups/Dimensions, Data Loaded and Validation for all the

fiscal years. Created planning web forms for end-users to input

budget. Created Planning & Budgeting Analysis reports. Provided

admin training to end-users and administrators. Created MAXL

scripts to automate tasks. Created calculation scripts to calculate

financial calculations. Applied dense-sparse Essbase database

settings for optimal performance. Used HAL to load metadata.

o Worked on translating the COA from Finance SAP BI to Hyperion

Planning. Worked on helping Data Integration Consultants to loading

dimensions using ODI. Wrote calculation scripts to convert local to

reporting currency and aggregating the database

o Automated reporting through the use of ASO database type from BSO

o Tools Used: ODI, SQL Views, MSSQL, Planning, Essbase, Calc Scripts,

Reports, ODI, MAXL, HAL (system 9.2), Report Scripts, Calc Scripts,

Business Rules, Web Forms, Workforce, Currencies, BSO, ASO

o Environment: Hyperion Planning/Essbase 11.1.1 (upgraded from 9.2),

Excel 2007

. Polo: Duration: Total 3 months: Global Offshore Delivery Model in Hong

Kong; Onsite: US

Description: Implement a 2-Phase Oracle project. First phase involves

creating a traditional Essbase application to produce excel-based

Financial reports for profit margin, eliminations, inter-company transfer

pricing and exchange data in local and reporting currency. Second phase

involves migrating from the current Essbase application to a new Planning

application.

Responsibilities:

o Build Essbase Application to meet US GAAP reporting requirements in

international currencies as well as Reporting currencies. This also

included Forex translation from local data to Reporting currency.

Build Essbase database for ad-hoc analysis such as calculate

vertical margin data. Also, perform elimination entries for newly

acquired retail stores

o Allocate depreciation to Rent & Occupancy costs that is for retail

stores expenses from General Overhead depreciation accounts. Create

excel-based input templates for retrieving data from Essbase and

creating Reports. Created Variance reports such as actual vs budget

dollar and percent

o Tools Used: Essbase, Calc Scripts, MAXL, Excel VBA Macro Reports

o Environment: Essbase 11.1.1, Financial Reporting Studio, VBA Macros

in Excel 2003

. BauschNLomb: Duration: Total 5 months; Location: Rochester, NY

Description: Complete global System 9.3.1 implementation project that

involves capital, balance sheet/cash flows, P&L, workforce and

customer/revenue modeling. Includes automated data load process using

FDM, complex calculations, automation of data loads, and state-of-art

outline design.

Responsibilities:

o Custom workforce cube was created. Budgeting Worked on setting the

HR related Payroll expenses. Use of web forms, and calculation

scripts to calculate salaries & benefits, overtime, merit

increases, FICA, FUTA, active, inactive, temporary workers. Also,

provide the flexibility to calculate travel expenses and provide

budgeting capability.

o COA included considerations for P&L, Balance Sheet and Cash Flow

statement. A separate database was created for balance sheet

calculations and Cash Flow was incorporated in P&L database. Use of

xref formulas, and then came up with custom calculations to move

data from balance sheet to P&L. Calculation of capital

expenditures/assets such as machinery. Depreciation calculation

that Included purchase of an asset, Complication came when

depreciation did not start until you make payments on the assets.

Also, payments can be made in installments.

o Tools Used: Capex, Workforce, Planning, Essbase, Calc Scripts,

MAXL, Web Forms

o Environment: Hyperion Planning System 9.3.1, HAL, FDM, Workforce,

Capex

. Lahey Clinic: Duration: Total 3 months; Location: Boston, MA

Description: Implement custom 11.1.1 planning solution to the Revenue

Lahey's revenue modeling process. Includes forecasting and budgeting by

statistics and volume drivers. Create labor/non-labor targets for

budgeting process.

Responsibilities:

o Includes Dimension building through flat files using ODI, and

Reporting using Financial Studio and Web Analysis. Processing of

Actual data in to Hyperion Essbase through native Essbase Rules

File. Define a Planning process that includes loading actual,

initializing forecast, re-process forecast, and modify/approve

budget

o Tools Used: ODI, Planning, Essbase, Calc Scripts, MAXL, Reports

o Environment: Planning System 9.3.1, Financial Reports, Excel 2003

. HealthFirst: Duration: Total 3 months: Location: Manhattan, NY

Description: Implement detailed level analysis of customer satisfaction

based on new membership, enrollments, and customer service calls.

Responsibilities:

o Build a new Essbase application that supports Inputs through Lock &

Send data through Excel, Web Forms. Build Excel Reports, Hyperion

Reports, interactive Dashboard applications, and two financial

Essbase databases (one for Reporting purposes and the

o Tools Used: Essbase, Calc Scripts, Web Analysis, Excel VBA Reports

o Environment: Essbase System 7x

. Neustar: Duration: Total 2 months: Location: Sterling, VA

Description: Upgrade security to Shared Services to enable single sign-on

services across all Hyperion tools. Move all domain users from native

directory to active directory with provisioning rights

Responsibilities:

o Implementation of enhanced security with the use of SSL over

Hyperion Products. Created a Design Documentation and worked with

finance team to migrate Essbase applications, security filters,

security access-level, user roles and calculation scripts.

o Tools Used: SSL, Shared Services, MAXL Automation

o Environment: Essbase System 7x

Small Projects:

. WWF: Duration: 2 months: Location: Washington DC

o Complete successful upgrade from Planning System 3.5.1 to Oracle

EPM Fusion Edition 11.1.1.3. Moved 3 Planning applications from old

system to the new system including security, dimensions, data, and

Essbase objects such as rules file, calculation scripts, business

rules, and report scripts

o Tools/Environment: Planning, System 11, Reports

. AIG: Duration: Part-Time 2 months

o Developed customized out-of-box custom financial 10Q Quarterly

Reports using Hyperion SmartView and POV Manager. Developed Complex

Hyperion Financial Reports, Dashboard Reports, and Web Analysis.

o Tools/Environment: Essbase, Reports, SmartView; Essbase System 9.2

. NASDAQ: Duration: 1 month

o Migrate Hyperion Planning Applications, System Security using

import/export utilities, automation HAL routines to retrieve data

from source PeopleSoft systems in to Planning including automated

planning desktop refresh. Update import/export properties file to

migrate shared services provisioning from System 9 to System 9.2

o Tools/Environment: Security Automation Scripts; Essbase System 9.1

. Cantor Fitzgerald: Duration: 1 month: Location: Manhattan, NY

o Worked with the Finance Team in creating P&L, and Balance Reports

using Financial Reporting Studio. Reports matched their Excel and

SEC reporting standards with audit trail functionality. Reports

were successfully generated via the web for end-users globally to

US, UK, and Asia based on security rights assigned within Essbase

and Report Groups. Also, Created Variance Analysis Reports for

Budget and Actual data. Generated Hyperion Reports as books in

Acrobat Reader and Excel format for distribution to senior

management and executives. Also created Dashboards and PinBoards

using Web Analysis for senior management reporting. Created

Reporting and Web Analysis documentation and trained end-users and

administrators.

o Tools/Environment: Essbase, Reports; Essbase System 7x

. Hain Celestial: Duration: 3 weeks: Location: Long Island, NY

o Worked on creating planning applications to help create Reports by food

brands for more than 20 products, training for end-users and

administrators. Wrote automation calculation scripts to query the

databases, load data in Hyperion database, and perform optimization.

o Tools/Environment: Essbase, Calc Scripts, Reports Essbase System 7x

Vertical Pitch (Business Performance Management) Jan 2006 to Apr

2007

Hyperion Senior Consultant

. CalWater: Duration: 6 months; Location: San Jose, CA

o Successfully implemented a drill-down operating budget planning

application in Hyperion System 9 that includes allocation of

payroll, employee calculations, and vehicle/asset history.

o Create Hyperion Planning applications and load dimensions, members,

and data through automation techniques such as Business Rules and

HAL. Create excel-based input templates for retrieving data from

Essbase and creating Reports

o Tools Used: Planning, Essbase, Business Rules, Calc Scripts,

Reports, SmartView

. Blue Coat: Duration: 3 months; Location: Sunnyvale, CA

o Provide day-to-day implementation services for different phases of

a software implementation project. Customize web forms for data

input and data views through Hyperion Reports, and document

planning application. Improve the performance of calculation

scripts within Planning application through dense/sparse

configuration and reorder of Essbase outline.

o Tools Used: Planning, Essbase, Calculation Scripts, Custom Java

Scripts - Web Forms

. Alta: Duration: 1 month; Location: Denver, CO

o Create chart objects and grids using Hyperion Reports. Manage User

Rights and Manage Workflow processes using Planning Web Client.

Create custom-defined dimensions, attributes, shared members, and

alternate hierarchy in Planning Web Client

o Tools Used: Essbase Application Manager, Planning 3.5

. Sony: Duration: 2 weeks; Location: San Francisco, CA

o Migrate Hyperion Planning applications from development servers to

the production servers

o Tools Used: Essbase, Calc Scripts, Reports

. Levi's: Duration: 2 weeks: San Francisco, CA

o Worked on Creating P&L, and Balance Reports using Hyperion Reports

o Tools Used: Essbase, Calc Scripts, Reports

. Harrahs: Duration: 2 weeks: Location: Las Vegas, CA

o Massaging the excel spreadsheet to load thousands of members into

Planning applications. Create Hyperion business rules and

calculation scripts in Essbase to calculate Allocations &

Depreciations

o Tools Used: Essbase, Planning

. Others: Worked on System 9 Demos at client locations using Essbase &

Planning, and Proof-of-Concept cases

Hoffman E-Commerce Lab (High-end E-Commerce lab systems) Jan 2003 to Dec

2005

Part-Time Intern - System Administrator

. Team Leader for System Administration of 50 computers including 18

servers in Unix and Windows, Firewalls, Intrusion Detection Systems, and

Anti-Virus Servers

. Architect of implementing and maintaining Intranet/Extranet web services

using Microsoft SharePoint Portal Server 2003 portal site using .NET,

XML, SQL Server

. Wrote automated .NET administration scripts to access remote network

information

. ERP Audit experience on Installation and Maintenance of Microsoft Great

Plains, CRM and IBM Tivoli Manager

MISYS Healthcare Systems (global leader in healthcare products)

Jun 2002 to Aug 2005

Part-Time Intern - Systems Analyst

. Wrote Installation code released in software CDs using Visual Basic.

Automated tasks by creating ODBC drivers to remote Sybase databases with

friendly logs and status reports for clients

. Modified statistical reports and data dictionary manipulation using

PowerBuilder directly for clients

. Audit analysis and documentation of the complex SDLC management tool for

product manager. Audited and tested client-server installation code for

data quality using a testing tool personally written in Visual Basic

language for scope creep.

. Checked for referential integrity constraints, friendly logs and

monitored status reports for clients.

. Web Owner for Extranet and Intranet pages using Microsoft Content

Management Server. Coordinated the web pages for each version of product

for consistency.

. Single-handedly evaluated an Audit analysis, documentation, and

recommendations of the complex System Development Life Cycle for product

manager to validate deficiencies of the IT Audit findings and provide

risk reduction findings

. Extensive Research and Development on fraud issues with Digital

Signatures and Intranet/Extranet technology

. Planned and executed Quality Assurance testing of over 6,000 lines of

'Payroll Application' program using Visual Fox Pro on program migration

from Version 6.0 to Version 8.0

Technical Skills

Reporting Tools:

Planning Essbase

Analyzer/Web Analysis HAL

Hyperion Business Rules Financial Reporting Studio (Hyperion

Reports)

Essbase Spreadsheet Add-In SmartView Add-In for Office

Databases:

Oracle PeopleSoft

SQL Server Essbase

Languages:

VB.NET ASP.NET

ADO.NET MS FoxPro

MS Visio SQL Server

Java Content Management Server

Microsoft CRM Great Plains ERP

Microsoft SharePoint Portal Server C, C++

CISCO VBA

Firewalls/Routers/Hubs/Switches

Operating Systems

UNIX Windows Server 2003/2000/NT

LINUX Windows XP/Vista

Education

. B.S.B.A, Dual major in Management Information Systems and Accounting

University of Arizona, Tucson, AZ

Jan02-Dec05: Cumulative GPA: 3.78.

MIS ranked 3rd best and Accounting 21st. SAT: 1090; TOEFL: 247

. Higher Secondary School in Management and Commerce.

H.R. College, Mumbai, India

Jan99-Dec01: Cumulative GPA: 3.61.

Certifications

. 2007: Hyperion Essbase Certified Consultant (HCC)

. 2006: Hyperion Planning Certified Professional (HCP)

. 2002: Oracle Certified Professional Certificate in PL/SQL (OCP)

. 2001: Microsoft Certified Professional (MCP) & Microsoft Certified

Solution Developer (MCSD)

Viral Laliwala; *****.********@*****.***; 732-***-****; 88 N Wood Avenue,

Iselin, NJ

Contact this candidate