SUMMARY:

• Over 8+ years of Experience as HFM with analysis, design and implementation of consolidation systems using HFM (Hyperion Financial Management) version 9 and version 11, Fusion Edition (Oracle Enterprise Performance Management)11 and its suite of products which includes Hyperion Financial Reports (HFR).
• Requirement gathering as part of functional role in order to implement HFM for corporate information system.
• Experience as part of functional role by assessing existing system and improvement needed by discussing with the users.
• Identifying scope, limitations and possibility of the system in comparison to the requirement and existing system.
• Administering during the development phase. Trained in - house administrator. Created security profile, provisioning and role.
• Clear Understanding of accounting concepts such as Financial Statement, Balance Sheet, Cashflow Statement.
• Involved in verification, validation based on design.
• Liason between Technical and accounting/finance department.
• Around 3 years of experience implementing, deploying, testing, administering and supporting applications in HFM.
• Experience in Developing, modifying HFM application and exposure in other Hyperion tools as Essbase, Hyperion Planning, and Financial Data Quality Management (FDQM).
• Experience in creating, maintaining and validating journal entries, Intercompany Transactions.
• Experience in creating reports using HFM and HFR (Hyperion Financial Reporting).
• Trained Hyperion users in applying Hyperion tools in order to meet the objectives of the clients.
• A comprehensive understanding of multi-dimensional databases, OLAP servers and its concepts.
• Experience in support of HFM applications and other Hyperion tools as Essbase, Planning, FDM, HFR, etc.
• Experience in design, analysis, development and administration of various applications in Client/Server OLAP environment using Hyperion Essbase, Hyperion Planning, Hyperion Financial Management and Hyperion Business Rules.
• Extensive knowledge and hands on experience in Essbase Calculation Architecture and Scripts, Calc Script optimization, Error and Variance Reporting.
• Experience in Analysis, Design, Development and Maintenance of various software applications emphasizing on Data warehousing.
• Experience in Informatica Power Center and Power Mart.
• Experience in the Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas.
• Relational and Dimensional Data Modeling experience.
• Extensively Worked on Data warehousing with Data Marts, Data Modeling, DataCleansing, ETL tool Informatica and data analyzing reporting Tool.
• Experience in working with data extraction, transformation and loading using Informatica Power Center.
• Experience in working with all Informatica modules like Server manager, Repositorymanager, Designer.
• Expertise in administering Informatica Repository, including creating and managing users.

TECHNICAL SKILLS:

Databases: MS Access, SQL Server 2000, Teradata, DB2, Oracle 11, 10g /9.x /8.x /7.x /6.x

OLAP tools: Hyperion System 11.1/9 BI+ Analytic Services 11.1/9.3/7.x/6.5, Hyperion Planning System 11.1/9.3/9.2 , Hyperion Planning 11.1/9.3/3.0/4.0 , Hyperion Workspace 11.1/9.3

Reporting Tools: Hyperion Financial Reporting release 11.1/9.3, Sales Reporting, Hyperion Interactive Reporting release11.1/ 9.3, Hyperion Production Reporting release 11.1/9.3, DRM, Hyperion Smart View 11.1/9.3, Dash Boards, Hyperion Reports 11.1/9.3/7.2 , Hyperion Excel Spreadsheet Add- in, Hyperion Analyzer7.2.x, Budgeting, Forecasting, Planning

Operating Systems: Windows

Web Designing: HTML, XML, PHP

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

HFM Consultant

Responsibilities:

• Responsible for development of Hyperion Financial Management v11 and Hyperion Reports.
• Build Metadata; create Hyperion Reports, Data Validation, and Project documentation.
• Managed Hyperion Application Environment for Hyperion (HFM/Planning/Essbase) environments.
• Involved in developing new HFM application for testing purpose and assigned security privileges as the using shared services.
• Redesigned quarterly forecast process in 2011/2012 to better handle translated data. Included changes to Hyperion rules, metadata, data entry forms and reports.
• Consolidated the various hierarchies and matched the Business and Legal hierarchies.
• Created certain rules for consolidation of data using business rule editor in HFM 11x
• Provided technical support for preparation, close and submissions processes for all Hyperion applications
• Configured servers, Hyperion system 11x applications, and database settings to achieve optimal operating conditions on multiple environments
• Managed the backend Oracle application database repository and generate usage tracking reports
• Designed and maintained Web data entry forms to be used by process administrator for specific data entry fields within HFM
• Provided support and assisted with training end-users as required to ensure productive and efficient utilization of the HFM application
• Maintained job schedules for periodic generation of reports using different modules of Hyperion Performance Suite
• Performed migration of reports and application patches from previous versions to the current version of Hyperion Intelligence
• Created many Web Reports and wrote queries, analyzing data, producing reports using Hyperion Intelligence and translating functional requirements into technical specifications
• Extensively worked with Hyperion Reports and Hyperion Analyzer to generate financial reports from different Multi-Dimension Databases
• Performed data and cubes (ASO & BSO) migration between multiple environments (Development, Test, Production)
• Used Drag and drop tables, pivots and charts onto the layouts
• Created Users and Groups in Hyperion Essbase and assigned privileges to them.

Environment: Hyperion Essbase, Hyperion Financial management (HFM) 11.x, Hyperion Essbase, Interactive Reporting Studio, Performance Suite, Workspace, Oracle, Windows Server 2003 and Java.

Confidential, Wall Street, NY

Sr. HFM Consultant

Responsibilities:

• Gathering the requirements from the client to build the consolidation system.
• Creating the same application using HFM with the same chart of accounts.
• Creating the target application with the new chart of accounts.
• Participated in writing business rules to recreate and enhance the consolidation logic which existed in Hyperion Enterprise.
• Intercompany Transaction (ICP) elimination.
• Conduct systems maintenance including security, metadata, rules/logic, reports, data grids, Web forms, FDM, validation roll-ups, and translation tables.
• Load monthly data, forecasts, budgets, and long-range numbers into HFM.
• Employ strong time management skills to produce monthly reports via Reporting Studio System 9, SmartView, Enterprise Reporting and Excel Retrieve.
• Reconciling the data between the applications.
• Writing reports in Hyperion Reports for consolidation and reporting purposes.
• Participating in the parallel closing process before going live.

Environment: Hyperion System 9 Financial Management, Hyperion Planning, SmartView, Windows Server 2003, SQL Server.

Confidential, Lincoln, NE

HFM Consultant

Responsibilities:

• Gathering requirements from different teams such as Finance team, marketing department.
• Experience as part of functional role by assessing existing system and improvement needed by discussing with the users.
• Identifying scope, limitations and possibility of the system in comparison to the requirement.
• Modified the requirement as per user request.
• Involved in implementation, testing, production rollout, documentation, and on-going maintenance.
• Installed Hyperion applications within Hyperion Business Performance Management.
• Adding and editing dimension members using Hyperion Workspace 9.x
• Creation and running of Financial Budget and Forecast reports using Financial Reporting Studio.
• Running Reports and Batches using Workspace.
• Creating dimensions and loading metadata.
• Loading data using flat files.
• Maintain HFM Application including Database and Security Refresh.
• Created, edited and performed constant security updates in HFM.
• Managed system upgrades and client installations based on users’ requirements
• Creating and maintaining Corporate financial Reports using Financial Reporting Studio 9.x
• Creating and editing corporate Business Rules/Calc scripts using AAS in Hyperion System 9.x
• Adding and editing dimension members in BPMA using Hyperion Workspac
• Security maintenance and updates using Shared services in system 9.x
• Maintenance and security filtering on data forms in Hyperion Planning 4.x
• Involved in creation and maintenance of data forms in Hyperion Planning.
• Creation and running of financial budget and forecast reports using Financial reporting studio.
• Maintain, support and manage all assigned applications including administration, tuning, production fixes, upgrades, and routine maintenance of the Hyperion applications.
• Performed detailed Documentation of tasks, processes and optimization requirements based on run times during data load and application build, within the project.
• Created HFM rules, Consolidation and Principles (Journal Entries, Current Translation, Intercompany)

Environment: Hyperion Financial Management 9.x,Hyperion FDM,HAL, Excel Spreadsheet Add-In, Hyperion Reports, Windows 2000, MaxL, Microsoft Excel 2000, Microsoft Access, Hyperion Performance Suite, Hyperion Enterprise.

Confidential, Long Island, NY

Sr. Hyperion Developer /HFM/ Planning & Essbase

Responsibilities:

• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Essbase System 9.
• Installed Hyperion Planning software and 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.
• Responsible for Designing and Creating HFM Applications for internal budget and forecast application across different cost centers
• Involved in requirement gathering and created reports using Financial Reports from HFM applications.
• Designed and developed security matrix and created data reconciliation templates for HFM applications.
• Responsible for the designing the automation HFM Processes in the essbase environment.
• Interacted with end users and developed numerous Business Rules in Hyperion Planning.
• Involved in gathering requirements and developing a project plan.
• Involved in gathering data and supervising data load.
• Involved in creating Rule files and batch files to automate the data load process.
• Created wrapper scripts (.ksh ) to automate all the variables and all the (.scr) scripts.
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Implemented robust data-access security and user management.
• Designed and developed optimized Essbase applications.
• Developed Excel Templates for user interface in Essbase database
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services. Loaded data using Essbase Integration Services (EIS).
• Development and running of Data Integration Manager (DIM) to load and maintain dimensions.
• Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Implemented Data Access layer to Communicate with the Oracle Database.
• Used ESSCMD in an interactive and batch mode to load data files.
• Developed and maintained Rules file for loading of data.
• Developed some complex calculation scripts based on the financial and budgeting applications.
• Developed Calculation scripts and optimize the running time for the scripts.
• Involved in Performance Tuning to minimize data load time.
• Used Hyperion interactive report studio to create interactive report for reporting purpose.
• As part of the BI Implementation, Designed interactive reports for Top management of different functional areas like HR, Marketing, Finance and others.
• Created and involved in Hyperion Interactive Reports Jobs scheduling which associated with External Trigger Event, on Hyperion Workspace.
• Retrieved some data in Excel spreadsheets to see that the data is loaded properly in the cubes.
• Installed and upgraded Hyperion Planning applications.
• Created and mapped H.A.L jobs to load the hierarchies into different planning applications.
• Worked as an administrator to give access and privileges to various end users in different planning applications, and synchronizing the passwords during the Essbase logon, or using external provider in Essbase.
• Created and managed numerous Data entry forms and Created many Business Rules for several applications.
• Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes.

Environment: Hyperion Essbase 9.2, Hyperion EPM, Hyperion Analyzer 9.2, Hyperion Planning 9.3., Hyperion Financial Management, Interactive Reports 9.2, Essbase Integration Services, Microsoft Excel 2000, Smart view, Oracle 9i, Windows 2000 Advance Server, UNIX

Confidential, OH

Hyperion Essbase/Planning Developer

Responsibilities:

• Closely worked with the functional and the business analyst team during the pre-implementation phase of the applications.
• Developed Planning dimensions and Essbase outline
• Developed Planning Web Forms.
• Developed several Business rules for Allocations, eliminations, drivers and other calculations.
• Developed Planning Workflow and task flows.
• Developed Essbase calc scripts and partitions.
• Develop Essbase reporting cube on top of planning cube.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase, HFM and Essbase Integration Services.
• Setup automated scripts for weekly backup of the application.
• Created and automated aggregation scripts in ESSCMD and MaxL to run at the specific times that the business required.
• Provided 24/7 support for the application during key financial submission periods as requested by the business, thereby keeping the system-downtime to a minimum.
• Closely worked with business users across the globe to troubleshoot and resolve issues as and when they surfaced.
• Created .prp files in HAL in order to make periodic changes to the dimensions per the business’s requirement.
• Developed Hyperion Reports.
• Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
• Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
• Defined and documented the steps to migrating applications in the Hyperion Planning, Essbase as well as the HFM environments in Prod, QA, and Dev.
• Worked with Hyperion Support on a number of issue resolutions.
• Analyzed, planned and coordinated the process to upgrade Hyperion Planning, Essbase from 7.x to 9.x and applied patches to Websphere and BIPlus.
• Migration of Planning Applications from Test to Production.
• Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer.

Environment: Hyperion System 9, Hyperion Planning 4.x, Hyperion Essbase 7.x, EAS 7.x, Hyperion Reports 7.x, Essbase Add-in, Smart View, HFM Add-in, HFM 4.x, Oracle 9i/10g, Solaris, Windows 2000 Advanced Server, Windows 2003.

Confidential, St Louis, MO

DW Consultant

Responsibilities:

• Worked with data modeler’s team to create Data Flow Diagrams.
• Developed Informatica mappings and mapplets, between sources and operational stagingtargets, and fine-tuned some of them for better performance.
• Created views and altered some of the dimensional tables to satisfy the reporting needs.
• Employed Source Qualifier, Lookup, Expression, Aggregator, Rank, Sequence generator and Joiner transformations for populating the datamarts
• Used pre-session and post-session stored procedures in PL/SQL to improve the performance of the session.
• Implemented Type II Slowly Changing Dimensions using Version number.
• Performed migration from 6.2 TO 7.1, and performed backup and performance tuning.
• Extensively Worked with Variables and Parametersin the mappings to pass the values between sessions.
• Instrumental in writing PL/SQL stored procedures and packages for transactional details (insert, update and delete operations)
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created Event Wait, Event Raise, Timer and Control Events in workflow manager according to the business requirement.
• Responsible for unit testing the mappings using SQL scripts.

Environment: Informatica PowerCenter 6.2, 7.1, ORACLE 9i, HP-Unix, Windows 2000, Erwin 3.5, SQL*PLUS, SQL, PL/SQL.

Confidential, San Francisco, CA

ETL Developer

Responsibilities:

• Analyzed and studied various Schemas for Implementation.
• Created source definitions from the operational sources and target definitions.
• Designed Sources to Targets mappings from primarily Excel/Flat files/XML to Oracle using Informatica.
• Worked Extensively on Informatica modules - Repository Manager, Designer, and Server Manager.
• Developed mappings, reusable Transformations for ETLusing Informatica Power Center .
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator and joiner.
• Configured sessions with Email and Command task.
• Command task and decision task based upon business requirements.
• Created workflows and reusable worklets for designed mappings.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Worked with mapping variables, Mapping parameters and session parameters.
• Extensively used debugger to troubleshoot logical errors.
• Extensively used PL/SQL for creating views, stored procedures on the tables.
• Involved in partitioning of the sessions and performance tuning of database, Mappings, as well as Sessions.

Environment: Informatica Power Center 8.x, Oracle 9i, SQL*Plus, PL/SQL, TOAD 7.6, UNIX, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created Repository using Repository Manager.
• Worked Extensively on Informatica tools -Repository Manager, Designer and ServerManager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Involved in production support which also includes trouble shooting of connectivity issues
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Tuned the mappings to increase its efficiency and performance.

Environment: Informatica Power Center 5.1/6.2, Oracle 8i, UNIX, TOAD, SQL * Loader, Windows NT.