KOMAL SHARMA

Phone: 925-***-****

Email: acutup@r.postjobfree.com

QUALIFICATIONS SUMMARY

Over 6 years of experience in implementing end to end projects using Hyperion Planning (Workforce, Capex, Opex )modules, Hyperion Financial reports, ODI,

ERPi, Accounting Hub.

Over nine (9) Years of experience in IT with seven (6+) years of experience in

Data Warehousing, ETL & OLAP with focus on Hyperion Suite of Technology.

7+ years of experience in design, analysis, development and implementation of various applications in client/server environment using Hyperion Essbase System 11/9/7.1/7.0/6.5.4/ 6.5.3/6.5.1, Hyperion Planning, DRM, Hyperion Financial reporting, Web-forms, Hyperion Reports, ESSCMD, Essbase Excel Add in,Smartview, VBA, ESSBASE Studio,ERPiEssbase Query Designer, under Windows 2000/NT4.0 and UNIX environment.

Strong database development and business intelligence modeling capabilities; database backups, Dense/Sparse settings, partitioning, MaxL scripts, Calc Scripts, Optimization and performance tuning cubes etc with strong Data Modeling skills.

Worked with various operational data sources like Oracle, Sybase and flat files.

Experience in SQL Plus, PL/SQL, Stored Procedures, Functions, Triggers, SQL *Loader, UNIX Shell Scripts.

Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules

Strong Programming skills in JAVA, C++, HTML, XML, Visual Basic

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

DEVELOPMENT BACKGROUND

Business Intelligence Products

Hyperion Essbase & Enabling Analysis Solutions:

EPMA, Essbase OLAP (6.x - 11.x), EAS (9x - 11x), Essbase Spreadsheet Add-In (6.x - 11.x), Smart View, EIS, Essbase Studio, ODI, Esscmd, MaxL, ASO & BSO, Calculation Scripts, Allocations

Hyperion Financial Analysis Solutions:

EPMA, Hyperion Planning, Business Rules,,ODI, ERPi,FDM

Hyperion Analysis Tools and Solutions:

Web Analysis (Analyzer) (7.x - 9.x), Financial Reporting (7.x - 9.x), Hyperion Intelligence (8.3.x), Smart View (9.x -11.x), Excel-Ad-In, OBIEE, FDQM, DRM

Programming Languages

PL/SQL, Visual Basic 6.0, Perl, C/C++

Other Databases

Oracle, SAP, MS SQL SERVER

Platforms

UNIX, WINDOWS

APPLICATION EXPERIENCE

Systems

Actuals/Budgeting/Forecasting/Planning, Hyperion Business Intelligence Systems, Financial Applications/Consolidations, Financial and Management Reporting, Sales and Marketing Applications.

Areas of Focus

Architect, Managing and Maintaining Business Intelligence solutions

INDUSTRY EXPERIENCE

Insurance

Banking and Financials

Manufacturing and Logistics

Education and IT services

CLIENT EXPERIENCE

CSAA Insurance Group (California,USA, Mar 13 - Present) /Employer: CSAA

AAA Insurance provides unique combination of excellent insurance products, superior personal service and enthusiastic support to more than 20 states in USA. I work closely with CFO team to get there Plan and Forecast cycle executed on time.

Role : Sr. Hyperion Developer

Working as Hyperion Admin to implement and maintain planning modules to meet Business Requirements.

Support FP&A team to Automate processes using Maxl’s, EPMA Batch client.

High interaction for using ESSBASE studio for Drill back reports. In the same stream implemented ERPi.

Strong knowledge on EPMA and classic Hyperion Plan type apps.

Main lead to handle new configurations upgrades and patches to the environment.

Developed complete BCP and lead the same.

Strong hold on SQL.

Lead migrations using LCM. Main contact for any new requirements and implementing the same for Budget and Forecast cycles.

Leading Cash flow model for the enterprise (Initial stages).

Strong skill set to support Accounting Hub implementations.

Worked on FR to support Management Reporting of enterprise.

Worked with technology groups and Business users to execute the Plan and Forecast for enterprise.

Coordinated with ODI and PS financials to have accounts flows into Hyperion Essbase and Planning cubes.

Designed Business Rules and new workflows for the users to facilitate their Plan.

Review Web-Forms and Security for the users.

Follow the flow of data from BSO Planning Cubes to ASO Planning Cubes to ensure data aggregates correctly and calculations perform as they should.

Review all newly designed Hyperion Planning dimensions for completeness via ODI .

Designed Calc scripts for allocations based on Premiums and losses for AAA.

Effective knowledge sharing and hand over of processes to Production support team.

Created the Automate process.

Worked on ERPi for enabling Drill through from Balances to Transactional details.

Was responsible for any Break and fix in current system. Re-design the applications for optimization.

Facilitated requirements gathering of third party vendor features for proposed application enhancements.

Responsible for project planning, timeline, budget, and milestone deliverables.

Environment: EPMA, Hyperion Essbase(11x), ASO and BSO, Hyperion Planning, Hyperion Financial Reporting, ODI, Hyperion Shared Services, Maxl, Esscmd, Batch Scripts, Smart-View, SQL Server, Windows,ERPi

Kraft Foods Ltd. (Chicago,USA, Aug 11- Feb 13) / Oracle (Employer)

Kraft Foods is a Big name in Grocery and Snacks producer with its headquarters in Chicago. While being part of Fit system of Kraft’s I Managed Onshore and Offshore team at this company and managed the merger of Cadbury lines with Kraft’s from BI perspective.

Role : Hyperion Lead

Worked with technology groups and Business users to implement the merger of two companies for the specific business applications.

Coordinated with DRM, FDM and HFM applications to have converted accounts flow into Fit system.

Designed Hyperion Planning multi-currency Applications, Designed Business Rules, and Smart-list for the users to facilitate their Plan.

Analyze the design of FDM Locations to ensure data is mapped accordingly for new Hyperion Planning Driver Based Design

Designed Web-Forms and Defined Security for the users.

Follow the flow of data from BSO Planning Cubes to ASO Planning Cubes to ensure data aggregates correctly and calculations perform as they should

Review all newly designed Hyperion Planning dimensions for completeness via DRM and Essbase Ad-Hocs

Designed FDQM Mappings for a newly acquired company's Non SAP Data so that their Ledgers could be loaded from their Legacy System into HFM 9.2

Lead onshore and Offshore Essbase Team and provided excellent service support to our customers 24/7 Global coverage. Different regions AP, CEEMA, LA, north America.

Created the Automate process to consolidated data movement to Kraft’s FP&A.

Was responsible for any Break and fix in current system. Re-design the applications as to minimize the CR request process.

Worked as a Gate-keeper in the Actual/Outlook/Plan/Forecast freeze process in case the correct file didn’t arrived and which could have potentially impact the total Company’s Number.

Facilitated requirements gathering of third party vendor features for proposed application enhancements.

Facilitated technical requirements gathering, and technical feasibility study for distributing the application between Snacks and Grocery.

Responsible for project planning, timeline, budget, and milestone deliverables.

Environment: Hyperion Essbase(11x), ASO and BSO, Hyperion Planning, Hyperion Financial Reporting, HFM, DRM, ODI, OBIEE, Hyperion Shared Services, Maxl, Esscmd, Automate, Batch Scripts, Smart-View, SQL Server, Windows

Wells Fargo Bank (San Francisco, USA, Jul 10 – Aug 11) /IRISGS(Employer)

Wells Fargo Bank is a premier financial institution with its headquarters in San Francisco CA. Was part of Basel Reporting Hyperion BI group.

Hyperion Consultant :

Responsible for Re- conciliation of Regulatory, Management and Public disclosure numbers of Bank internally. Implemented and Managed the ESSBASE cubes from which all stated reports were fetched.

Wrote and designed BCP plan for BASEL reporting Group.

Designed the Essbase Applications for Actuals and Plan from the scratch.

Responsible for Re-conciliation of Month-End close number during the Actual Close.

Created Excel templates for the Business Users to facilitate the Plan-Transfers and for GPR’s

Helped Business users to understand the system constraints and provided them with the solutions.

Met with Business users/Finance Managers in understanding their requirements and provide them time-line for the implementation.

Validate any new Logic change before moving it to the Production Environment.

Primary point of contact between Finance Managers/ Business users and ESSBASE developers.

Designed the Plan/Outlook/Forecast/Flash Models for the group and created the process for systematic copies to FP&A outlook/Plan Models.

Designed the reconciliation process for Plan and Actual model to FP&A.

Designed the calculation scripts to calculate Interest Income, COF$, FDIC rates, Equity, Taxes, Balancing of Balance sheet and “Net on Funds”.

Designed the calc scripts to Allocate the dollars based on multiple basis as per the requirement.

Wrote Maxl, ESSCMD, and Batch Jobs to automate the load/calc process.

Optimized the dataload and calc processes of the application.

Environment: Hyperion Essbase (v6x/9x/11x), ASO and BSO, Partitioning, MDM/DRM, HAL, Hyperion Reports, Hyperion Shared Services, Star Analytics, Maxl, Esscmd, Automate, Batch Scripts, Dodecca, Excel Ad-In, SQL Server2005, Windows, Unix

Nestle (Jul 08 – Jul 09) /IRISGS(Employer)

Role: Sr. Hyperion Consultant

As a Hyperion Essbase Administrator:

Responsible for system enhancement, maintenance, and administration.

Authored 'As-is' blueprint of all Functional Requirement Specifications (FRS) and Business Level Specifications (BLS).

Interacted with users to support analysis and provide definition and requirements for the Financial Management reporting and other Essbase supported processes.

Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them. Worked with Essbase Advanced Security Manager to extract and manipulate users/groups/&filters

Open and Closed Essbase cubes for different users.

Designed the budgeting and year-end process for Corporate and Divisions.

Migrated the Essbase Server from Windows2000 to Windows NT servers

Installed and set up the server with Hyperion Essbase.

Worked closely with the End users to understand their Reporting needs and updated the essbase application accordingly.

Developed automation scripts for application refresh and back up using Hyperion Essbase Esscmd and MaxL.

Designed and developed Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.

Designed and implemented Balance sheet based on the user requirements.

Modify the existing Essbase Applications to reduce the calc time and maintenance required for it.

Designed/Modified the Essbase Cubes based on reporting needs of the users.

Created partitioning and also used cross database function to load slice of data from other remote cube.

Developed Calc Scripts for allocation of expenses for the budgeting process.

Developed Calc Scripts for complex calculations and for currency conversion and optimized them.

Recovered application from its backup.

Responsible for production support and coaching to business users.

Used Essbase partitioning to improve performance of Essbase Application.

Responsible for the design, development, enhancement, and maintenance of the various BSO cubes used for forecasting and strategic decision-making.

Created batch scripts using ESSCMD/Maxl to automate Essbase application refresh process (dimension building, data loading and calc scripts).

Migrating existing application and databases from windows 2000 platform to Windows NT.

Developed VB and API’s to develop front-end for reports in Excel Ad-In.

Developed Calculation scripts and optimizes the running time for the scripts.

Designed Validation templates for validating Essbase databases with SAP..

Designed load rules to load specific type of flat files such *.csv, *.xls, *.txt, *.hir.

Created and managed numerous Data entry forms and Business Rules for several applications.

Actively participated in defining requirements, functional specifications, designing documentations and testing strategies

Enviornment: Hyperion Essbase System 11/9.x, Essbase Excel Add-In/VBA,,Hyperion, API, Visual Basic Essbase Advanced Security Manager 1.6, Essbase Outline Extractor, ESSCMD, MaxL, Microsoft Excel 2000,, Windows 2000 Advance Server, Microsoft Access, SAP

SBSIET (India, Jun 04 – May 06) Full Time

Role: Hyperion Essbase Administrator/Analyst

Role & Responsibilities:

Responsible for system enhancement, maintenance, and administration.

Authored 'As-is' blueprint of all Functional Requirement Specifications (FRS) and Business Level Specifications (BLS).

Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.

Implemented Hyperion Financial Management suite 3.5

Created Drill-Through Reports and defined Hybrid analysis using Essbase Integration Services.

Installed and set up the server with Hyperion Essbase, Hyperion Analyzer, HAL, and Executive Viewer.

Developed automation scripts for application refresh and back ups using Hyperion Essbase Esscmd and MaxL.

Designed and developed Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.

Designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.

Interacted with end users and developed numerous Business Rules in Hyperion Planning.

Involved in maintaining several existing Hyperion Financial Management applications.

Assisted with the integration of financial reporting along with improvement of data collection.

Prepared quarterly forecasts, annual budget using Hyperion analyzer.

Developed Calc Scripts for complex calculations and for currency conversion and optimized them.

Created OLAP Model (Star Schema) and Meta Outline for Essbase OLAP Server using EIS and wrote SQL query to load data using Essbase Integration Services (EIS).

Environment: Hyperion Essbase 7.1, Hyperion Financial Management, Hyperion Analyzer 7.2, Hyperion Planning 3.5.1, Hyperion Reports 7.0, Essbase Integration Services 7.1, Oracle 9i, UNIX, Cognos, BRIO, S.Q.R

EDUCATION

Masters, Computer Engineering, Allahabad University, INDIA

Bachelors, Computer Science and Engineering, Punjab University, INDIA

Contact this candidate