SUMMARY

• Over 3 years of detail - oriented, skilled professional experience in Relational Databases, Data warehousing (Hyperion/OLAP), Client-Server applications, Oracle and SQL Server Database Administration.
• Three plus years of implementation experience as Hyperion Developer, Planning Administrator, hands on experience using Hyperion ESSBASE, Planning, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports, Hyperion SQR, Hyperion Analyzer, Financial Reporting Studio environments.
• Thorough noledge of the SDLC and also the entire life cycle of Data warehouse design, development and implementation.
• Expertise in architecting complete data models combining multiple transaction systems ETL tools and relational and multi-dimensional data stores for star schema, snowflakes schema designs and reporting tools.
• Proficient in the development of ETL processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.
• Hands on experience in installation, configuration and maintenance of Hyperion Shared services 11.x/9.x, Hyperion Essbase11.x/9.x, Administration Services 11.x/9.x.
• Responsible in migrating Hyperion 11.1.2.1. To 11.1.2.3.500 and 9.x to Hyperion 11.1
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outline.
• Commendable noledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Strong experience as Essbase Cube Analysis & Design, Essbase database Administration and performed upgrades, Maintenance, database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
• Experience and proficiency in functional and technical development for Hyperion Planning application involving budgeting, strategic planning, forecasting Capex planning and workforce planning. Experience in application implementation in different industry sectors. Solid understanding of Planning architecture and solutions expected by client.
• Extensively involved in generating monthly/quarterly financial reports (Balance sheet Statement, cash flow statement) using Hyperion Intelligence, Hyperion Analyzer, Hyperion Reports and Hyperion Essbase Spreadsheet Add-in.
• Hyperion Essbase also, building Financial Budgeting and Forecasting OLAP applications.
• Responsible in providing production support, maintenance, development, and administration of Essbase cubes.
• Involved extensively in developing load rules, calc scripts, automation scripts, and partitioning.
• Strong noledge of Financial Domain using Hyperion Financial Management Suite (HFM).

TECHNICAL SKILLS

Business Intelligence Tools: EPMA11.1.2.1, Oracle Hyperion Planning, 11.1.2.x/ 11.1.1.3/9. x.x, Workforce Planning, Oracle Hyperion Essbase 11.1.2.x/ 11.1.1.3/9. 3.1, Hyperion Financial Management (HFM) 9.3.1/11.1.1 , Hyperion Integration Services 9.3.1/7.x/6x, Financial data management (FDM) 9.3.1/11.1.2.1 , MS-Excel, OBIEE11G, spreadsheet add-in VBA. Hyperion Analyzer, Hyperion Workspace

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Table Modeling, Physical and logical data modeling. Hyperion Analyzer, Hyperion Reports, MS-Excel Spread Sheet Add-in VBA and Crystal Reports 8.5..x, Hyperion Reports 9.x, Hyperion Enterprise Services, Hyperion Financial Management Suite (HFM),OBIEE, DRM

Hyperion Brio Suite: Intelligence i-Server, Reports i-Server/SQR, Insight Server and Client Products, Designer, Explorer, Insight, SQR Developer. Brio 6.5 OLAP (ODS), Hyperion Brio Intelligence EIS and Dash boarding (Version 8), Hyperion Metrics Builder, Hyperion Performance suite

OLAP: Hyperion Essbase7.x/9.x/11.x,EPMA 11.1.1, Essbase Integration Server 9.X (EIS), Hyperion Planning 9.x/11.x, Data Relationship Management 11.1.1,MaxL, MDX, Esscmds.

ETL Tools: Oracle Data Integration, DIM, ODI 11g

Microsoft Tools: MS Office Suite, MS Visio, MS SharePoint

Automation Tools: Mercury Test Director, Remedy

Databases & Tools: Oracle, SQL, PL/SQL, Toad 8.6, SQL Programmer

Environment: UNIX, Sun Solaris, MS-DOS, Windows XP/Vista, Linux

Reporting Tools: Financial Reporting Studio, Web Analysis, Hyperion Reports, Hyperion Spreadsheet Add-in

Project Management Tools: MS Project, Primavera Team Play Project Manager, Niku CA Clarity

PROFESSIONAL EXPERIENCE

Confidential, Hanover MD

Hyperion Essbase and Planning Developer

Responsibilities:

• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed batch scripts and rules files to upload dimensions and data to Essbase cubes.
• Optimized Data Loads and Calc Scripts by applying various techniques.
• Involved in developing web forms applications, Assigning Security, Workflow procedures and developed several Essbase Planning applications which suit the business and for best performance.
• Analyzed, designed and optimized the load rules to improve the Dynamic database updates and to optimize the Essbase database cubes performing the calculation scripts in order to calculate the data present in the Essbase cubes, Smart view, Forecasting and to calculate Dynamic Time Series data.
• Developed MaxL scripts to automate daily backup and consolidations of monthly data.
• Created MaxL scripts to update outlines in batch, load data and execute calc scripts, during maintenance.
• Technical support for existing cubes, problem identification, resolution and documentation.
• Maintained Essbase databases using Planning application to meet financial requirements.
• Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Developed reports using Hyperion Financial Reporting. Involved in administrative activities such as setting up users, security groups and access filters to set the security policy and to ensure maximum security.

Environment: Hyperion system 11.1.2.3, Hyperion Essbase 11.1.2.3, Hyperion Financial Reports 11.1.2, Hyperion Interactive reporting, EAS 11.1.2, Hyperion Planning, Oracle 11g, Oracle SQL, Windows 2000 Advanced Server, Linux.

Confidential, Jersey City,NJ

Hyperion Essbase Developer

Responsibilities:

• Involved in implementation, migration and validation for Hyperion Essbase upgrades.
• Acted as a liaison between the technology and business areas of the organization.
• Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan.
• Interaction with finance and accounting customers who possessed various levels of business noledge.
• Assess new Business needs, initiatives and translate them into detailed business requirements specifications.
• Worked closely with IT and finance teams to resolve issues, upgrade, develop, test, and implement financial systems.
• Develop, derive, clarify and review functional specifications and User cases.
• Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase cubes.
• Developed Batch and Rules files to load data from financial system's database to Essbase cube.
• Created and scheduled batch jobs for complete automation processes for nights and weekends application backup.
• Responsible for functions such as users/groups creation, security profiles and application access to different groups.
• Developed Calc scripts and optimized it according to the Essbase outline.
• Developed Aggregate Storage Cubes (A.S.O). Optimized applications to bring down runtime and database size considerably.
• Modified the existing outline according to the requirements for Hyperion Planning application.
• Involved in providing security autantication for the users of Hyperion Planning and maintaining workflow management process.

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, EPMA,Essbase Administration Services (EAS), Shared Services, Oracle Database 10g, Windows Server2008, Windows XP, MS Excel 2010, 2007

Confidential

Hyperion Essbase Admin/Developer

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application
• Installed Hyperion 9.3.1
• Created basic dimension build rule files.
• Created attribute dimensions
• Loaded data
• Configuring the data sources
• Retrieving the data using multidimensional data and label placement guides
• Creating reports with smart view for office.
• Creating small calculation scripts.
• Reporting with Essbase Spread sheet add-in
• Customer Relationship Management projects consists of three modules Customer, Billing and Service Order
• Involved in creating databases, Building rules files, Reporting with smart view for office.
• It contains information about services like Telephone, Basic Cable, Internet, Voicemail, Call forwarding etc.
• It contains information about services like Telephone, Basic Cable, Internet, Voicemail, Call forwarding etc. Billing holds the customer information and Service Order Universe holds the information about the new services ordered by customer.

Environment: Hyperion Essbase 9.3.1, Administration,Smart view for office,Spread sheet add-in, Oracle 9i, SQL, MS Office, Windows 2000.