SUMMARY

• Over 7 (Seven) years of experience in design, analysis, development and implementation of various applications in client/server environment by using various versions of Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Workspace, Hyperion Shared Services, EPMA and generating numerous reports by using Essbase Excel Add in /SmartView, Financial Reporting and Hyperion Interactive reporting. Experienced in working on database side to Map, Extract and Manipulate data and performed Gap Analysis.
• Extensive experience in developing and designing of Essbase Cubes, Dynamically Build members in the Cube, load Rules, ESSCMD, MaXL, Calc scripts, Security and Provisioning in Hyperion Shared Services, Hyperion Planning ( Data Forms, Security, Metadata maintenance and Business Rules), Web Analysis, Essbase Excel Add - In, Financial reporting and Hyperion Interactive Reporting Studio (Complex Reports, Reporting Studio, Joins and Data Modeling).
• Extensive experience in Hyperion Essbase System 11.x/9.x/7.x
• Involved in installation and configurations of various products of Hyperion system 11.x, 9.x, 7.x such as Hyperion Analytics Services, HFM, Hyperion Planning, Analytic Services Client and Essbase Administrative Service (EAS) Console
• Expertise in working in ASO and BSO cubes.
• Experienced in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, ESSCMD and Batch Scripts.
• Experienced in writing SQL quires for improving data load performance.
• Experience in providing support & maintenance for Hyperion Applications.
• Administered Hyperion shared services for creating users and groups, and granting access to applications and databases
• Experience in the full software development life cycle (SDLC) using the Waterfall Model and Rational Unified Process (RUP) with a good understanding of Agile Methodologies
• Technical writing - Use Case development, sequence diagrams, process & workflows, data dictionaries, gap analyses, change requests, test scripts, etc.
• Skilled in working with both client & development team. Successfully complete projects & works with client to develop ongoing relationship.
• Good knowledge of financial reports like balance sheet, income statements, p&l statements, cash flow statements, account receivables and payables.
• Designed and developed numerous complex Essbaseand Hyperion Planningapplications with excellent balance of Dense and sparse dimensions.
• Developed various OLAP Models and Meta-Outline using Essbase Integration Services.
• Migration of Hyperion applications from 9.x version to 11.x versions
• Created forms based on the user requirement using Hyperion Planning.
• Proficient in the star and snowflake schema data modeling techniques used to design for data warehouse and data mart.
• Versatile team player with ability to work independently having excellent analytical, presentation and inter-personal skills with ability at building productive relationships

TECHNICAL SKILLS

Hyperion Applications: Hyperion Essbase 11.x/9.x/7.x,Hyperion Planning, Hyperion financial management(HFM), Hyperion Workspace, Essbase Integration Services (EIS), Hyperion Shared Services, Essbase Analytic Services, FDM, EPMA

Reporting Tools: Excel-Add-In, Hyperion Smart view, SQL server reporting, Web Analysis, Hyperion Financial Reporting, Hyperion Interactive Reporting (Brio)

Databases: MS SQL Server 2005, Oracle 10g/9i/8i

Languages: C, Microsoft VBA, HTML, SQL, MaXL, MDX

Operating Systems: Windows 98/2000/2003/ NT/XP, Windows server 2003, Unix

Microsoft Office suite: Microsoft Power point, Visio, MS Project, MS Excel, MS Word, Microsoft VBA.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Hyperion Essbase and EPMA

Responsibilities:

• Involved in analyzing requirements, functional specifications, design documentation and testing strategies.
• Involved with data analysts in design of Extract, Transform and Loading of meta-data From people-soft to Oracle Database, EPMA, Essbase Studio and in downstream Applications.
• Worked on Shared services in revising and setting up new groups and filters.
• Worked on Two ASO cube OPBS C01 and REPORT cube.
• Performed Impact Analysis.
• Performed EPMA filtering, configuration, batch jobs for the different applications and Financials Reports.
• Performed end to end System Integration Testing.
• Handle UAT defects and performed production Deployment.

Environment: Hyperion Essbase 11.1.3, Hyperion planning 11.1.3,EPMA, Shared Services, Hyperion Workspace, Smart View, Excel Add- In, Excel Query Designer and Windows 2005 server, Oracle 10g, Informatica 8.1 & 9.1.

Confidential, Itasca, IL

Hyperion Planning lead Developer

Responsibilities:

• Analyzed the Business Requirements Documents to understand and construct the prospective planning cube and interact with the business users to facilitate the mutual understanding and implementation of the application in production environment.
• Write and maintain the TTD (Technical Design Document) for the EXPFCST planning application.
• Actively participate in weekly status meeting during development phase and daily standup meeting during UAT phase.
• Involved with business users and database team for extracting, transforming and loading the dimensions and data into planning application through the help of Informatica 8.1
• Developed all Informatica Mapping, Session and Workflows.
• Developed SQL load rules for some dimensions and loaded some dimension and attributes through flat files.
• Developed calc scripts and business rules.
• Developed a numbers of web forms including composite web forms.
• Create task lists and planning unit hierarchy for Process management.
• Maintain FX rates, Merit rates, Fringe rates, Allocation rates and Bonus rates through different business rules.
• Worked on supporting detail on the beginning of each planning cycle.
• Worked on Oracle Database for load optimization.
• Worked on Excel Add-in and Smart view Tools to generate various ad-hoc reports for analyzing the business.
• Created Web Forms Menus according to requirements.
• Automated building dimensions, loading data and calculation scripts using MaxL.
• Continuously worked on problem solving, and adding needed documentation
• Communicated with the financial team in order to meet reporting and consolidation requirements
• Schedule the entire process using windows batch scheduler in development environment.
• Created the CI Logs for all the application objects.
• Migrate the application and code form development to UAT environment and UAT environment to Production

Environment: Hyperion Essbase 9.3.3, Hyperion planning 9.3.3, Hyperion Workspace, Hyperion Web Launcher, Excel Add- In, Excel Query Designer and Windows 2005 server, Oracle 10g, Informatica 8.1 & 9.1.

Confidential, Scottsdale, AZ

Hyperion Essbase Developer/Report Developer

Responsibilities:

• Involved in gathering and analyzing requirements, functional specifications, design documentation and testing strategies.
• Involved in Capacity Planning meetings and project management meeting.
• Involved with customers and data analysts in design of Extract, Transform and Loading of data into data marts.
• Designed and developed OLAP models and Meta outlines in EIS for all the Essbase cubes.
• Extensively used ESSCMD &MaXL script to run automation job on UNIX system.
• Designed & developed the Essbase CUBE dynamically using Load Rule Files.
• Worked on SQL databases for load optimization.
• Worked on two Hyperion planning application on 11.1.2 as a production support.
• The day to day task involved the maintenance of planning Hierarchy, data loading, adding and maintaining business rules, Task list and clearing supporting detail.
• Worked on designing the database outlines to get the best performance of Essbase Server.
• Worked on Excel Add-in and Smart view Tools to generate various ad-hoc reports for analyzing the business.
• Optimized the Essbase cube to balance the calculation and retrieval performance.
• Automated building dimensions, loading data and calculation scripts using MaxL.
• Developed the analytic reports using Hyperion Web Analysis, Interactive Reporting, Financial Reporting, Excel Add-in and Smart view.
• Created data models for Interactive Reporting and generate numerous complex queries and reports using drill paths and scheduled interactive reports job on demand.
• Migration cubes and code form development to testing environment sand testing environment to Production
• Performed migration of all applications to the performance management architect.
• Performed lifecycle management migration of numerous oracle hyperion planning applications.
• Schedule the entire process using windows batch scheduler in development environment.
• Participated in testing, debugging and documentation
• Migration of Hyperion applications and reports from system 9.3.1 to system 11.1.2
• Created filters on subdivision of various cubes to grant appropriate access according to users jobs and responsibilities using Data Definition Language.

Environment: s:HyperionEssbase 11.1.2, Essbase Studio, Essbase Integration Services,, Hyperion Essbase 9.x, Hyperion Planning 9.x, EPMA, Hyperion Web Analysis, Hyperion workspace, Hyperion Interactive reporting, Hyperion Excel Add-in, Smart View, UNIX,SQL Server 2008, Oracle 9i& Windows 2005 server, Financial Reports and Web analysis.

Confidential, Fishers, IN

Hyperion Essbase Developer/ Hyperion Planning

Responsibilities:

• Involved in gathering and analyzing requirements, functional specifications and design documentation.
• Worked in a team of 6 to create a system for all sales data
• Works on Data base to map data according to outline for faster loading.
• Developed Essbase cubes, loaded data, and designed reports with Web-Analysis
• Developed reports using Hyperion Interactive reporting.
• Functions and Formulas were used to drive reports where users can see lower level data from summary level (drill-through)
• Optimized data loads and calculation scripts by proper ordering of members in dense/sparse dimensions.
• Continuously worked on problem solving, and adding needed documentation
• Generated numerous Financial reports and charts on weekly/Monthly basis for users
• Involved in designing, modifying, and optimizing the Essbase database outlines, and data blocks
• Created rule files to upload data from the system’s database to Essbase
• Created planning classic application for testing.
• Created planning application objects and Forms.
• Optimized the database by writing calculation scripts to improve performance
• Performed migration of all applications to the performance management architect.

Environment: Hyperion Essbase 9.x, Essbase Integration Services, Hyperion Workspace, Excel Add- In, Excel Query Designer, Hyperion Financial Reporting and Windows 2000/NT

Confidential

Hyperion Consultant

Responsibilities:

• Built Essbase, performed data loading of financial data and utilized calculation scripts to properly update information
• Developed & Maintained BSO Cubes
• Developed and employed calculation scripts
• Created rules files for dynamic outline build.
• Worked on SQL server to Map data bases. And constructed Data Mart.
• Work closely with client management and users to define requirements and project scope
• Modified and maintained Hyperion Essbaseapplications and databases to in corporate new business requirements
• Utilized Excel Spreadsheet Add-in and SQL server reporting tools to help meet the reporting needs of business and management
• Perform the analysis necessary to design and architect solutions that meet identified client requirements
• Managed the use of time and other resources to complete projects

Environment: Hyperion Essbase 7, MS Windows 2000/NT/XP, Excel Add-In, SQL server