SUMMARY

• 6+ years of diverse experience in Information Technology with emphasis on Data warehousing OLAP tools, focus on OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning, Hyperion Finance, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer, Essbase Spread Sheet Add - in, Essbase Query Designer under Windows and UNIX environments.
• Handed on the Hyperion Financial Business Analyst, and deal with the financial requirements.
• Experience in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis.
• Extensive knowledge of Essbase and Hyperion Planning 11.1.2 and Essbase 11.1.2.
• Experienced in developing OLAP models and metadata outlines for loading dimensions and data into Essbase Cubes.
• Strong knowledge of Report creation using Financial Reporting studio, Web Analysis and Interactive Reporting studio.
• Extensive knowledge in Hyperion Interactive Reporting including query, results and dashboard sections.
• Good knowledge of Data Ware housing concepts, BI applications, EBS, Hyperion Financial Management (HFM) and Financial Data Management (FDM).
• Extensive knowledge in Hyperion Business Rules (HBR), Hyperion Application Link (HAL), and Essbase Calculation scripts, Essbase Commands and Essbase functions.
• Experienced in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).
• Extensive knowledge in Hyperion Shared Services and Workspace.
• Experienced in SDLC that included duties like providing documentation on design, testing and migration from development to production.
• Working knowledge in writing Calculation Scripts & MAXL statements commands, MDX querying and Report scripts.
• Excellent functional knowledge for FDM and Hyperion Shared Services.
• Worked with Installing and configuring Essbase / EIS Shared Services, Work Space, and Planning on Windows and UNIX environment.
• Understanding and implementation of Essbase security features, and ability to create user and group profiles, and assign the proper privileges.
• Created OLAP Models and Meta outlines using Essbase Integration Services (EIS) to populate Essbase database. Converted EIS OLAP models to Essbase Studio Schemas.
• Experienced Oracle Data Integrator (ODI) and Data Integration Management (DIM) to load both metadata and data.
• Experienced in application designing and development using Hyperion Essbase 11.x/ 9.x/7.x
• Hyperion Web Analysis, ESSCMD, MAXL and Essbase Excel Add-In.
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables.
• Strong customer relationship management, analytical, problem-solving and communication skills.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11.1.2, Hyperion Essbase 11.x/9.x/7.x, Excel Add-In, Essbase Integration services 9.x/7.x, ESSCMD, MAXL, Essbase administration services, Hyperion Planning, Hyperion performance suite, Hyperion Interactive Reporting.

Business Intelligence Tools: Hyperion Planning 11.x/9.x, H.A.L, Hyperion Financial Management Suite (HFM), OBIEE.

Reporting Tools: Hyperion BI+ (Web Analysis, Financial Reporting) Hyperion Reports 11.x/9.x,Hyperion Analyzer 11.x, Hyperion Excel Add-in, Smart View.

Scripting Languages: Unix shell, MAXL, ESSCMD.

Internet Technologies: ASP, HTML, MS FrontPage, Dream Weaver, Macromedia Flash, DHTML.

Programming Languages: PL/SQL, HTML, DHTML, XML.

Databases: Essbase, Oracle 10g/9i,SQL, SQL Server 2005,2008 DB2

Operating Systems: MS-DOS, Microsoft Windows 7/Vista/ XP

PROFESSIONAL EXPERIENCE

Confidential, Livingston, NJ

Senior Business Analyst (Hyperion)

Responsibilities:

• Assist with integration of new legal entities into the existing financial reporting systems architecture.
• Develop an understanding of the financial reporting applications and assist in maintaining the underlying monthly and year-end processes.
• Collaborate with Finance, Accounting and IT teams to understand documentation and training needs. Work with the appropriate teams to deliver the needed materials.
• Oversee and coordinate the offshore development effort (Japan, Malaysia, Philippines, etc.) and guide the team during the change management.
• Retrieve and reconcile data from Millennium General Ledger (GL) and Production using Excel Add-In.
• Assist Administer to validate data before immigrate into Production from Essbase.
• Be involving with the end user training for BIRs and Excel Add-In.
• Document the business requirements for change management to the IT team.
• Participate in the design and testing phases, including design and testing of prototypes and orchestration and sign-off on acceptance test results to ensure design integrity.

Environment: Hyperion EPM System, BIRs, Web Analysis, Hyperion MAXL, Excel Add-In, Hyperion Application Link, MS Excel Add-in, visual explore.

Confidential, Sunrise, FL

Hyperion Consultant

Responsibilities:

• Interfaced with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner; Document, test, implement and provide ongoing support for Hyperion applications/Planning.
• Worked on Hyperion Financial Management (especially, GL, accounts receivable/payable), and assisted on data Financial Data Management (FDM).
• Created and maintained Data forms and Data grids in HFM.
• Created Financial Template through Hyperion Planning (Web forms).
• Extensive knowledge in Hyperion Shared Services and Workspace.
• Strong skills in using the Financial Report Studio to create numerous reports.
• Created ad-hoc reports using Hyperion Essbase Visual Explore, and Spreadsheet Add-in.
• Installed and maintained the Hyperion products.
• Configuration of Hyperion/Planning application components, including databases, rules, calc scripts, print server, PDF, reports, security and process management modules.
• Set up security of users and groups both in Essbase and workspace.
• Highly skills on Administration works, and strong ability to troubleshoot installation issues.
• Created smart list in Hyperion Planning.
• Developed business process & requirements as it pertains to data within the Customer Business Center; Responsible for source system analysis, data transformation, data loading and data validation from source systems to Hyperion Application;
• Extensively involved in making changes to reporting and planning applications according to the user requirements.
• Experienced migration of applications from one server to another server.

Environment: Hyperion EPM System 11.1.2. Hyperion planning 11.x Interactive Reporting, Web Analysis, Hyperion Integration Services, MAXL, Excel Add-In, Hyperion Application Link, SQL Server 2008, MS Excel Add-in, visual explore.

Confidential, NJ

Hyperion Business Analyst (Functional)

Responsibilities:

• Created Financial reports (Balance Sheet and Income statement) using Hyperion Essbase Spreadsheet Add-in and Financial Report Studio.
• Developed reports in Pivots, Charts, Reports, and Dashboards in Interactive Reporting Studio.
• Worked with business analysts/End Users for gathering requirements, functional specifications, testing strategies and developing a project plan.
• Allocated income and expenses requirements.
• Worked on Oracle E-Business Suite, especially, focus on the Financials Management and FDM. And used ODI to transfer data from Essbase into EBS.
• Experienced in Monthly closing activities in HFM.
• Maintained FDM mappings, locations, validation rules, validation entities.
• Oracle Data Integrator (ODI) has been used; ETL Design and Development, Data Integration, Data Migration, Data Quality, Data Profiling.
• Converted BSO member formulas and calculation scripts to the appropriate MDX formulas and correct solve-order
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
• Migration of the Hyperion from 9x to 11x.
• Pulled out data from data repositories so that user can ease of access using Interactive Reporting.
• Developed MAXL scripts to automate daily backup and consolidations of monthly data.
• Have been involved in the Admin support to answer technique questions that came up.
• Involved in developing web forms applications, Assigning Security, Workflow procedures and developed several Essbase Planning applications which suit the business and for best performance.
• Developed numerous simple to complex Business Rules and attached them to the web forms.
• Deal with numbers and a lot of facts with strong flexibility.
• Data processing and analyzing.
• Served as the point of contact for team at queries concerning the business
• Assisted to develop all information materials relating to business
• Bridged the gap between the technological complexity and the business requirements

Environment: Hyperion EPM System 11.1.2. Hyperion Planning 11.x Interactive Reporting, Web Analysis, Hyperion Integration Services, MAXL, Excel Add-In, Hyperion Application Link, SQL Server 2005, MS Excel Add-in, Hyperion Intelligence Explore 8.

Confidential, Fairfield, IA

Hyperion Analyst

Responsibilities:

• Involved in the complete Software Development Life Cycle (SDLC) and was responsible for the design and development of two cubes business collection and strategy.
• Involved with creating reports use Financial Reporting and Hyperion Interactive Reporting Studio and published in the workspace for users.
• Delivered numerous financial reports to users, for instance, Income statement, Balance sheet and Cash flow.
• Implemented Data rule files and dimension builds rule files.
• Prepared reports and Dashboards using Hyperion Analyzer as per client requirement using Hyperion Analyzer.
• Have extensive skills in client interaction, communication and in support.
• Developed calculation scripts and tuning of calculation scripts was performed
• Designed and developed web based data entry forms within Hyperion Planning and task lists.
• Developed and modified Report Scripts and Rules files.
• Involved with Hyperion Planning budgeting application to add dimensions, assign member properties, variance reporting procedures, time balancing, currency dimension properties, overall metadata building and refreshing the data.
• Worked on the General Leger, Accounts receivable/payable for the Hyperion Financial Management.
• Well versed with Smart View features Data analytics in HFM.
• Created customized templates for Balance sheet and Income statement in Ms Excel Automated the reports in Essbase Excel Add-in.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Provided troubleshooting (as Administrator) and involved in Partitioning of Essbase database applications.
• Involved in Optimization and Performance Tuning of Essbase Systems that includes outline, calculation, database settings and cache settings to minimize data load time.
• Provided a Functional and Technical documentation of Essbase Cubes and Reports.
• Developed report in Pivots, Charts, Reports, Dashboards, Financial reports.
• Involved in the configuration of Essbase Deployment services which will be used to cluster cubes and allow 24-hour availability.

Environment: Hyperion ESSBASE 9.X, Hyperion Administration Services, Hyperion Reports 9.X, Hyperion Spread Services, Essbase Excel Add-In, MAXL, UNIX, Informatica, Oracle, MS-Excel.

Confidential

Hyperion Analyst (Functional)

Responsibilities:

• Coordinated with Client and Business Analyst to understand and develop an Optimized cube.
• Involved in development and modification of existing financial (especially, For the P&L and Balance sheet reports) and marketing reports which include corporate consolidation reports, and financial and planning reports for management.
• Evaluated Hyperion system architecture including logical views, data hierarchies and reporting structures
• Involved in gathering requirements and developing a project plan.
• Involved in preparing optimized data source which used in Interactive report and financial report Studio.
• Involved in dimension building and data loading using Essbase Integration Services (EIS) by OLAP Models and Meta outlines.
• Restructured as well as maintained existing Essbase cubes.
• Developed load rules for loading data files and for dimension build.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Provided technical guidance and support to end-users by developing documentations required.
• Communicate with users for system availability and worked for the Admin support.
• Manage on demandrefresh of GL and Planning systems
• Implement calc script to reproduce Group calculations (FX, ST, split of markets…)
• Assisted data transfer to HFM Group reporting tool.
• Worked closely with the testing team to help them in data validation and issues related with the data validation.
• Designed and developed reporting solutions using SQL Reporting Services and Hyperion.

Environment: Hyperion Essbase 6.5, EIS 7.1, Hyperion Reports 7.0, Hyperion Essbase Excel Add-in, MAXL, MS Excel 2007, AIX UNIX 5.2