SUMMARY:

• Over Ten (10+) years of professional experience in development, implementation, analysis, reporting, administration and consulting in a Client - Server environment.
• Over six (6+) years of extensive experience in application designing and development using Hyperion Essbase 9.x/7.x/6.x, Hyperion Financial Reports, ESSCMD, MAXL, Essbase Excel Add-In and Hyperion web Analyzer.
• Extensive experience on the installation, configuration, server settings, backups, client installations of Hyperion products such as Essbase, Essbase Integration Services, Analyzer and Hyperion Reports on both Windows and UNIX environments.
• Experience in architecting complete data models combining multiple transaction systems ETL tools INFORMATICA PowerCenter 7.0 and relational and multi dimensional data stores for star schema, snow flakes schema designs and reporting tools.
• Extensive experience in Calc Scripts, Load Rules and Report scripts.
• Commendable knowledge and experience in Automation, Essbase cube designing and partitioning and optimization of report queries in Microsoft Excel.
• Worked on Financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and in building Financial Budgeting and Forecasting OLAP applications.
• Experienced work Hyperion system 9 BI+ Reporting and OBIEE 10.1.x.
• Worked with Integration tool Like Hyperion Application Link(HAL), Hyperion Data Integration Management(DIM), Hyperion Financial Data Quality Management (FDM), Hyperion Essbase Integration services(EIS), Oracle Data Integrator(ODI)
• Extensive experience with Hyperion Planning - system 9
• Experienced in the configuration and maintenance of Windows servers and UNIX servers with different operating systems.
• Experience in developing complex reports in Hyperion Interactive Reporting Studio V 9.3.1 (BRIO) & Hyperion Web Analyzer 6.5/7.0.
• Experience in building Complex reports through financial reporting studio (FR studio 9.3.1).
• Extensive experience with Oracle Hyperion Enterprise 6.x
• Worked on Hyperion Financial Management (HFM) 9.3.
• Created an application in Hyperion Financial Management (HFM) from the scratch starting from meeting with Business user together requirements until deployment on the production server.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.
• Excellent command over SQL, PL/SQL, Oracle Forms and Reports proficient in SQL and Oracle databases.
• Good understanding of coding in PL/SQL and very strong in performance tuning and database design expert level Oracle 10g/9i/8i /7.x
• Thorough knowledge in concepts of OLAP, BI, DBMS, Data mining, Database Tuning, Data Warehousing.

TECHNICAL SKILLS:

OLAP Tools: Hyperion System 9,Hyperion Essbase 7.x/6.x, Excel Add-In, Essbase Integration Services 7.1 / 6.x, ESSCMD, MAXL, Hyperion XTD, MaxL, Essbase Administration Services, Hyperion planning 3.5/4.0,Hyperion Planning - System 9.

Business Intelligence Tools: Hyperion Planning 3.3.x, H.A.L, Hyperion Financial Management Suite (HFM)

Language: SQL, PL/SQL, C, C++, C Graphic, C#, Visual Basic, UNIX shell scripting Java.

Database: Essbase, ORACLE 7.X/8i/9i/10g, MS-Access, MS-SQL SERVER 6.5/7.0/2000, DB2, Sybase, Oracle Financial Application, Kronox.

Utilities/Application: MS-Office (97/98/00/XP) Clear Case, Crystal Report, Adobe PhotoShop 6/7, Adobe Illustrator, Acrobat Reader/Writer.

Web Programming: HTML DHTML, java script, VB script, ASP.NET

Tools: TOAD, PL/SQL developer, DB Designers, SQL Navigator.

Internet Tools: Front Page, Macromedia 6(Flash, Fireworks, Dream weaver), FTP, TCP/IP, LAN, VPN, Remote Desktop Access, NetMeeting, MS-Outlook.

Operating Systems: MS-DOS, WINDOWS 95/98/NT/2000/XP Professional, UNIX.

GUI Visual: Basic 6.0/5.0, SAP GUI

Integration Tool: Hyperion Financial Data Quality Management (FDM) 9.3.1, HAL, Hyperion EIS, Oracle Data integrator (ODI), Hyperion Data Integration Management (DIM)

Reporting Tools: Hyperion Analyzer 7.0, Hyperion Reports 7.0, Hyperion Interactive Reporting 9.3.1, Micro Strategy 8.2

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling, Erwin 4.0.

ERP: People soft 8.0 (HR)

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Hyperion Administrator

Responsibilities:

• Involved in maintaining several existing HFM 9.3.1applications.
• Involved in developing new HFM application for testing purpose and assigned security privileges as the using shared services.
• Modified existing HFM rules for custom calculations and consolidation in rules editor and modified metadata to add members in various dimensions of HFM application.
• Developed Time and leave Reports from scratch in Hyperion Interactive Reporting studio 9.3.1.
• Created and managed numerous Data entry forms and Created many Business Rules for several applications using HFM 9.3.1
• Interacted with users to support analysis and provide definition and requirements for the Interactive reporting and other Essbase supported processes.
• Interacted with PeopleSoft Team in order to understand the Data structure for analysis. Tables and field identification for Data modeling Into Interactive Reporting.
• Created many Web Reports and wrote queries, analyzing data, producing reports using Hyperion Intelligence and translating functional requirements into technical specifications.
• Worked with IR to create build queries, apply filters and sorting, generate desire results and create reports from top of that result.
• Used Hyperion Intelligence Dashboard studio to reduce development and maintenance time.
• Wrote JavaScript on control buttons to connect different sections like query, result, Pivot Tables with Dashboard.
• Used Drag and drop tables, pivots and charts onto the layouts
• Created ODBC and oce connections to connect to the database.
• Created customized dashboards and reports for more detailed analysis of data from a single application.
• Designed and developed numerous HR Reports Using Hyperion System 9 BI interactive Reporting created various reports to provide executives, business user and analyst with intuitive user-directed relational query and capabilities.
• Worked on OBIEE 10.1.3.3/Siebel business analytics 7.8.2 for EPM warehouse.
• Worked with OBIEE interactive dashboard for reporting purpose.
• Worked on the rationalization, design, documentation, build and testing of over Time and Leave reports.
• Report optimizations, functions, dashboards and formatting for the customer. Worked on reports rationalization and functional and technical documentation, unit testing and integration testing of reports.

Environment: Hyperion BI+ system 9, Hyperion Financial Management 9.3.1,Hyperion Workspace 9.3.1,Hyeprion Shared services 9.3.1, Hyperion Planning- System 9,Microsoft Excel 2000, Oracle 10g,Peoplesoft 8.0, Kronox, Windows 2003 Server, OBIEE 10.x.

Confidential, Reston, VA

Hyperion Administrator /Consultant

Responsibilities:

• Worked with Oracle Financial Application and developing UNIX script to fetch the data from oracle and FTP it to treasury server and made it automatic using Kron-Job on Unix server.
• Responsible for creating and managing applications profile in HFM 9.3.1.
• Created certain rules for consolidation of data using business rule editor in HFM 9.3.1
• Worked with Hyperion shared service 9.3.1 to create HFM and HP groups according to the security matrix provide by business users, assign roles of particular application to those groups and assign access to users on that group.
• Created security reports from Hyperion Shared Services 9.3.1 and worked with security classes
• Worked with Hyperion workspace 9.3.1 to schedule the certain task flow in HFM applications.
• Involved in maintaining several existing HFM 9.3.1applications.
• Worked with Hyperion Financial Data Quality management (FDM) 9.3.1 to integrate Oracle GL with HFM and Essbase.
• Involved in various process of MDM/DRM including data identification, collection of identified data and transformation.
• Developed Event script and Import Integration script in order to design workflow for whole integration process.
• Created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members.
• Migrated Essbase server into newer versions and newer operating systems.
• Utilized Application Manager/EAS: Model sizing, optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing/validating scripts
• Responsible for exporting and check (validate) the source data from FDM to target system HFM and Essbase.
• Worked on OBIEE 10.1.3.3/Siebel business analytics 7.8.2 for EPM warehouse.
• Worked with OBIEE interactive dashboard for reporting purpose.
• Installed and configured Oracle Hyperion Enterprise Performance Management suite 11.1.1
• Involved in analysis of Multidimensional OLAP (MOLAP) which is stored in Essbase cubes.
• Involved in troubleshooting of issues arise in Essbase server and loading process as well as automation related issues.
• Configured security on Essbase server, Hyperion planning and HFM using Hyperion shared service 9.3.1.
• Made the dashboards interactive and user friendly to have different cascading options with beautiful depiction in Interactive Reporting Studio.

Environment: Hyperion BI+ system 9, Hyperion Financial Management 9.3.1,Hyperion Workspace 9.3.1,Hyeprion Shared services 9.3.1, FDM 9.3.1, MDM,Oracle Financial application, Hyperion Planning- System 9,Microsoft Excel 2000, Oracle 9i, Windows 2003 Server, HP-UNIX.

Confidential, NYC, NY

Hyperion Essbase Administrator

Responsibilities:

• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Created and managed numerous Data entry forms and Created many Business Rules for several applications using HFM 9.3.1
• Involved in maintaining several existing HFM 9.3.1 Applications.
• Involved in developing new HFM application for testing purpose and assigned security privileges as the using shared services.
• Modified existing HFM rules for custom calculations and consolidation in rules editor and modified metadata to add members in various dimensions of HFM application
• Developed Aggregate Storage Cubes using Essbase system 9.
• Managed BSO and ASO cubes and improved their performance through tuning: recognize design issues, eliminate fragmentation, setting of the cache, optimize Essbase cache, fine tuning of cache setting usage of filters.
• Developed batch scripts using MaxL and ESSCMD to load data from relational systems database to Essbase cube; developed MDX queries.
• Developed star schema for the OLAP model and created EIS meta-outline for the Essbase cubes.
• Created a transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Actively involved in complete project development life-cycle from analysis of Functional Specification Documents or Business Requirements Documents, application design, development, parallel testing, and rollout into production environment. Implementation and end user training across subsidiaries.
• Worked with User Define Attributes (UDA) with attribute dimension and standard dimension.
• 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.
• Interacted with end users and developed numerous Business Rules in Hyperion Planning.
• Worked with Hyperion Financial Data Quality management.
• Create certain rules for consolidation of data using business rule editor in HFM
• Involved in gathering requirements and developing a project plan.
• Involved in migration from development to test Scripts, wrote test scripts for testing purpose backup of the templates during migration.
• Involved in fix-up performance related issues in Essbase and planning.
• Developed reports, wrote SQL Queries and generated tables in TOAD
• 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.
• 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).
• Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
• 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.
• 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.

Environment: Clarity, Hyperion Essbase System 9.3.1,Hyperion Reports 7.0, Hyperion Analyzer 6.5, Hyperion Planning 3.5.1,Essbase Integration Services 7.1, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server, UNIX, Perl, SQL server 2000, Power play, Hyperion Financial Management 9.3.1.

Confidential

Hyperion Essbase Administrator

Responsibilities:

• Involved in gathering requirements and developing a project plan.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase cube.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Used Hyperion Financial Management (HFM) for Financial Analysis and Reporting.
• Worked with Hyperion Data Integration Management
• Involved in creating Rule files for multi-dimensional databases.
• Optimized Data Loads and Calc Scripts.
• Worked with UDAs and formulas.
• Implemented calculation engine that includes robust mathematical functions for computing derived data.
• Provided seamless integration of historical, projected and derived data.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Loaded data using Essbase Integration Services (EIS).
• Implemented star schema and used EIS to interface with the company’s existing Oracle 10g data warehouse.
• Created various filters as per user requirement in EIS.
• Designed and developed numerous applications with excellent balance of dense and sparse dimensions.
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
• Implemented robust data-access security and user management.
• Developed Excel Templates for user interface in Essbase database.
• Involved in system installation, configuration and software upgrades from Essbase version 6.5 to 7.1.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
• Thorough internal training and practical experience got familiarized with budgeting system, mainframe applications and the General Ledger database.
• Used Hyperion Application Link (HAL) to establish connections between an Essbase database, HFM and a People soft System, developed data flow diagrams for the same. Developed translation rules and used them with the translation adapter in HAL.

Environment: Hyperion Essbase 7.0/6.5.1, Hyperion Analyzer 6.5, Hyperion Reports 7.0/ 6.5, Essbase Integration Services 6.5,Hyperion Financial Management (HFM), Hyperion Application Link(HAL), Cognos Report Net 1.1,Erwin 6.0, MS-Excel 2000 Spreadsheet Add-In, SUN Solaris 7, Windows NT 4.0

Confidential, Chicago, IL

Essbase Analyst / Essbase Developer

Responsibilities:

• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
• Translated end user requirements into application design specifications
• Assured optimal match between cube design and report specifications
• OLAP models and meta-outlines designed through Essbase Integration Services
• Managed system upgrades and client installations based on users’ requirements
• Ported applications and migrated database from version 6.2 to 6.5
• Developed four cubes - Developed four cubes - one for Confidential Loans, one for Confidential Credits, one for Market Research and one for Customer Analysis.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users
• Documented and issued procedures pertaining to Essbase applications
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage
• Create reports using Hyperion Planning 4.0.
• Involved in checking the status and progress of each planning unit so as to analyze variances in real time, revise, promote, reject and approve plans.

Environment: Hyperion Essbase 6.2/6.5, EAS 6.5.1, Excel Spreadsheet Add-In, EIS 6.5, Hyperion Analyzer 6.5, Hyperion Planning 4.0, Hyperion Reports, Windows 2000

Confidential, Framingham, MA

Essbase Developer

Responsibilities:

• Installation of Essbase family products in both Windows 2000/NT and UNIX (Sun-Solaris) environments.
• Responsible for producing the functional design documents and specification for the Essbase modules.
• Maintenance of two previous Essbase cubes.
• Involved in script writing for dynamic dimension builds and data loads.
• Worked on performance tuning of data loads and calculation times.
• Design and development of calculation scripts.
• ESSCMD is extensively used to run these calc scripts.
• Developed the Load Rules to automatically validate the data and feed into Essbase new structure.
• Developed report scripts to populate data, which was fed into the other cube.
• Created batch files to run calc scripts, data load and data calculations.
• Extensively worked with Hyperion Reports and Hyperion Analyzer.

Environment: Hyperion Essbase 6.1/6.0, ESSCMD, Hyperion Analyzer, Excel Add-In, MS Project, Oracle, Windows NT/2000, Hyperion Reports, Sun-Solaris UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked extensively on detailed system analysis, design and development of the system lifecycle.
• Used ERD models for modeling designed logical and physical database architecture.
• Used Data Modelers before implementing the data model, giving inputs about the required indexes, constraints, foreign key relationships.
• Worked on Oracle and SQL Server databases.
• Worked on PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers.
• Developed PL/SQL scripts for back end validation/ updates.
• Developed Manual Test Scripts for unit testing.
• Developed reports using SQL* Plus and Crystal Reports.
• Evaluation of ETL tools - Informatica, Business Objects Data Integrator, Oracle Ware house builder.
• Evaluation of 3rd party database GUI tools - DBVisualizer, server studio and WINSQL
• Supporting the DBA team with object validation and granting user privileges.
• Use SQL LOADER to bulk load data.
• Use TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.
• Worked on performance tuning using Explain Plan and Tkprof.

Environment: Windows 98/2000, Oracle 9i/8i, UNIX Shell Scripting, PL/SQL, SQL Loader, Linux, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Wrote complex PL/SQL stored procedures, functions, packages, triggers and advanced SQL queries
• Created business design document and technical design document for the application.
• Involved in extensive design of Sql and shell scripts.
• Working with Oracle databases to manage data for development, QA and production environments.
• Involved in laying out database tables and database schema design
• Developed scripts to create tables, views, procedures, functions and packages executed them using SQL*Plus.

Environment: Windows 98/2000, Oracle 7.x, UNIX Shell Scripting, PL/SQL.