PROFESSIONAL SUMMARY

• Over 6years of IT experience in Advanced Analytical Software Application, Business Analysis, Requirement Gathering, Testing and Database Administration of OLAP and Client/Server projects using industry accepted methodology.
• 4years of strong Technical and Functional experience in OLAP Designing, Administration, Development, Reporting, and Migration of various financial applications using Hyperion Essbase, Essbase Integration Services (EIS), Shared Services9.3, Hyperion System 9 BI+, Hyperion Planning, Hyperion Business Rule, Hyperion Financial Reporting, Hyperion Reports, Hyperion Analyzer, Hyperion Workspace, Hyperion Application link(HAL), ESSCMD, MaxL, Calc Script, MDX, Essbase Spreadsheet Services, Web analysis and Hyperion Smart View.
• Expertise ininstallationandconfigurationof Hyperion products such as Essbase, Planning, Analyzer and Reports on both Windows and UNIX environments and maintain security through Shared Services.
• Expert in creating Business Rules, Web Forms and maintenance of Metadata using Hyperion Planning.
• Strong knowledge of Financial Reporting Systems and Decision Support System (DSS) using Hyperion Planning and developed financial Budgeting and Forecasting of OLAP applications.
• Extensively designed and developed monthly/quarterly financial reports (balance sheet statement, cash flow statement) using Hyperion Intelligence, Hyperion Analyzer, Hyperion Reports and Hyperion SpreadsheetAdd-In.
• Strong experience in analyzing, designing, updating, testing and migrating Essbase Cubes in different environments and also proficient in performance tuning and optimization of Essbase applications.
• Expert in building Dimensions, Attributes, Shared Member using Rule Files in an outline by means of several build methods such as Generation, Level and Parent-Child references.
• Very proficient in writing Calculation Scripts and automating the Essbase cubes using MaxL, ESSCMD, MDX and Batch Scripts.
• Experience in creation and maintenance of numerous applications and Multi Dimensional Database (MDDB) using BSO and ASO.
• Experience in creating the replicated, linked and transparent partitions using the Partition Manager.
• Strong understanding of Software Development Life Cycle(SDLC) in the Hyperion Essbase environment.
• In depth knowledge of OLTP System Study, E-R model, relational Database Design, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Proficient in Testing, having good experience in both Manual Testing and Automation Testing using various testing tools like Quick Test Pro (QTP), Quality Center, LoadRunner, WinRunner and also having good knowledge of writing automation scripts using VB Scripting language.
• Experience in C, C++, J2EE, JAVA, EJB, XML, JSP, Servlets, JavaScript, VB Script, HTML,UNIX and Databases using JDBC, DB2, Oracle, SQL Server, that includes complete system life cycle.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Outstanding team player with an aptitude to learn. Strong analytical, communication, interpersonal, customer interaction and problem solving skills in technology arena.

CERTIFICATION

• ORACLE Hyperion Certified Essbase Analytics 9.3 Developer.
• ORACLE Hyperion Certified Planning 9.3 Administrator I & II.

OLAP Development Tools

Hyperion System 9 BI+, Hyperion Essbase 7.1.2/9.3.1/9.3.2, Essbase Integration Server 7.1/9.1.2 (EIS), Hyperion Essbase Administrative Services 9.1.2/7.x, Hyperion Planning System 9.3.1/9.3.0/3.3, Hyperion Application Link (HAL) 7.3/7.1, Hyperion Shared Services 9.3, MaxL, MDX, ESSCMD.

Reporting Tools

Hyperion Financial Reporting Studio 9.3, Web Analysis, Hyperion Reports 7.2/7.0, Hyperion Analyzer 7.2/7.0, Hyperion Essbase Excel Spreadsheet Add-in, Hyperion SmartView 9.2, MS-Excel.

Database

Oralcle 8.2/9.1/10g, DB2 7.1/8.1, MS-SQL Server 7.0, SQL, PL/SQL, JDBC2.0.

Software and Internet Technology

C, C++, J2EE, JAVA 1.3/1.4, JSP, XML, EJB, Servlets, Java Script, HTML, VB Script, UNIX Shell Scripts, IBM WebSphere 5.0/6.0, Apache/HTTPServer 6.0, SunOne WebServer 6.1.

Testing Tools

Quick Test Professional (QTP) 8.2/9.0, Win Runner 7.0, Load Runner 7.8/8.1, Test Director, Mercury Quality Center 8.2/9.0, Clear Cache, Crystal Report.

Tools

DNS, SSH, TCP/IP, SSL, Firewall, Visual Age Java, LDAP, XSession, MS-Office, IBM Lotus Notes 5.0/6.5, IBM Sametime.

Operating Systems

UNIX, Sun Solaris 5.8/5.9, AIX 4.0/5.0, Linux, Windows 2000/2003, Windows XP, Windows NT 4.0.

PROJECT EXPERIENCE:

Confidential, Dearborn, MI. Feb 2008 - Oct 2009
Hyperion Essbase/Planning Consultant

Description: For decades, Henry Ford's company is the world's No. 2 automaker, and a pillar of American corporate stability. FMC uses Hyperion Planning for Budget and Forecast, which includes development and administration of planning and budgeting application using Hyperion Business Rules, Hyperion Reports and Hyperion Planning. The project included Design, Implementation and Execution of a new Essbase deployment architecture based on various requirements, migration of applications across platforms, creation and maintenance of various finance and reporting Essbase applications. This project is for developing a budgeting, planning and forecasting application for North America, Europe and Asia Pac.

Responsibilities:

• Designed and managed applications using Hyperion System 9 BI+. Involved in installation and upgrading the Hyperion Essbase and Hyperion Reports.
• Worked on planning applications like Revenue, Budget, Consol and Analysis also called Financial Planning and Analytics (FPA).
• Worked on Hyperion Application Link (HAL) routines to load data from PeopleSoft to Planning. HAL routines included metadata refresh, translation of metadata.
• Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR's—Global Security Filters and Web forms. Salary script based on Headcounts, Rundown units calculation, cost of sales were few of HBR's.
• Developed the reporting framework using for wide range of users as per the requirements using Excel Add-In Templates, Hyperion Reports and Hyperion Performance.
• Created working capital reports by looking at existing excel reports using Hyperion Financial Reporting Studio.
• Developed a Multi-Dimensional Database (MDDB) application using Hyperion Essbase that stored and maintained company\'s financial and marketing data and performed the loading and manipulation of data into the database using Build and Load Rules files.
• Administered Security, User creation with Native and External authentication, Filters, Dimensional level Security, Groups and assign the proper privileges.
• Used attribute dimensions to retrieve and analyze data in terms of characteristics of dimensions.
• Developed and maintained Calc Scripts forperforming calculations and developed member formulas for dynamic calculations and SignFlip.
• Automated Hyperion Essbase Cubes to minimize manual entry through Batch File using ESSCMD/MaxLScripts. Removed errors occurring during the nightly dimension build and data load processes by referring to Log files.
• Involved in creating ASO Cubes for better performance, migrated BSO Cubes to ASO Cubes and also changed Calc Scripts to MDX.
• Involved in Performance Tuning to minimize data load time using the Dense/Sparse settings, responsible for performance monitoring, backup and recovery of the cubes and also implemented various troubleshooting procedures to recover databases.
• Created linked and transparent partitions between source and target cubes.
• Interacted with the users to gather report requirements and there upon designed reports and also involved in troubleshooting the user issues with the Essbase Excel add-in.
• Provided daily back-ups of Essbase Database and Relational Database Reports, regular performance maintenance operations like eliminating fragmentation, disc and memory management.
• Extensively involved in troubleshooting and managing all the environments and worked heavily on documenting all jobs and processes in form of VISIO flow.

Environment: Hyperion System 9 BI+, Hyperion Essbase 9.3.2/9.3.1, Essbase Integration Services 9.1.2, Hyperion Essbase Administrative Services 9.1.2, Hyperion Planning 9.3, Hyperion Financial Reporting Studio 9.3, Hyperion Application Link (HAL), Hyperion Reports 7.2, Shared Services 9.3, Hyperion Smart View, Hyperion Essbase Excel Spreadsheet Add-In, MaxL, ESSCMD, Web Analysis, MS-Office, Oracle 10g and 9i, MS-SQL Server, SQL, PL/SQL, JavaScript, UNIX (AIX, Sun Solaris, Linux), Windows 2003/XP.

Confidential, Kansas City, MO Nov 2006 - Jan 2008

Hyperion Essbase/Planning Developer

Description: UMB Financial Corporation is a multi-bank holding which offers complete banking and financial services to individuals and business customers. The company owns and operates 134 banking centers throughout Missouri, Illinois, Colorado, Kansas, Oklahoma, Nebraska and Arizona. Implemented Hyperion Planning, Hyperion System 9 BI+ and Hyperion Essbase to integrated the data from multiple sources to meet the needs of users. As a result, the company has improved its financial planning and reporting systems and increased its financial flexibility by identifying working capital issues more rapidly.

• Installed and Configured Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports and Workspace in development, staging and production environments.
• Used Hyperion Planning to create, maintain and manage the budget and plans. Maintained Essbase Databases using Planning application to input financial data requirements.
• Involved in assigning Security for Hyperion Planning applications using Hyperion Shared Services.
• Created and managed numerous data entry forms, business rules for several applications andvariousReports in Hyperion planning.
• Involved in building Hyperion Application Link (HAL) adapters for loading metadata into planning.
• Performed dynamic dimension build and data load using rules files, developed member formulas and Calc Scripts computing input values into actual scenario results and projecting these values using Excel Add-in and Hyperion Reports.
• Designedanddeveloped numerous Essbase applications with excellent balance of Dense and Sparse dimensions, arranged in an hourglass fashion.
• Completed tuning, debugging, routine maintenance of Essbase applications as well as provided support for these applications.
• Involved in creation, update, deletion and maintenance of user accounts and groups for cube access. Monitored the log files of the cubes to make sure there are no errors related to dimension build and data load.
• Provided Database optimization with dimension building, data loading, Indexing, calculations, cache management and partition management.
• Involved in migration of Hyperion Essbase Cubes form 7.1.2 to 9.3.1/9.3.2, and transfer of applications, outlines and data exportation (ETL).
• Involved in automation of Essbase Cuberefresh, securityset up using MaxL shell script and interacted with the users to gather report requirements and there upon designed reports and also utilized the Essbase Query Designer to customize query builds and generate tailored reports to illustrate details in a spreadsheet format.
• Successfully used Linked Partition to achieve optimization in performance and navigation between the databases.
• Provided daily back-ups of Essbase Database and Relational Database Reports, regular performance maintenance operations like eliminating fragmentation, disc and memory management.

Environment: Hyperion System 9 BI+, Hyperion Essbase 7.1.2/9.3.1/9.3.2, Essbase Integration Services 7.1.2, Hyperion Essbase Administrative Services 7.x, Hyperion Planning 9.3/3.3, Hyperion Financial Reporting 9.3, Hyperion Application Link (HAL), Hyperion Reports 7.2, Hyperion Analyzer 7.x, Shared Services 9.3, Hyperion Essbase Excel Spreadsheet Add-In, Hyperion Smart View, MaxL, ESSCMD, MS-Office, Oracle 9i, DB2, SQL, PL/SQL, UNIX (AIX, Sun Solaris), Windows 2000/XP.

Confidential, Minneapolis, MN. Nov 2005 - Oct 2006
Hyperion Essbase Developer

Description: United Health Group is a group of companies, which include United Health Care, Specialized Care Services and various other business segments. Each of these different segments provides various products and services across the nation. The aim of the project was to provide the top management and end users, a fully functional data warehouse for each of the business segments separately and as per the user requirements. Development of various Cubes, Developing Calc Scripts, Developing Load Rules Forecast and Budgeting, combining various Cubes, SQL performance tuning, optimization of calc time, were few of the performed tasks.

• Created OLAP Model and Meta Outline for Essbase OLAP server using Essbase Integration Services 7.1.2.
• Developed Hyperion Essbase Cubes for reporting purpose by using Hyperion 7.1.2 from properly formatted data using Excel/SQL/Test Files for free form data loading through Rule File and configured Outline to add new dimensions, members and attributes.
• Analyzed all the dimensions and member in Essbase Outline based on dimension type, Density/Sparsity, Query Frequency etc for optimal performance.
• Involved in troubleshooting to optimize calc time, data load time and retrieval time of various Essbase cubes.
• Developed Calc Script to calculate complex values Cash Cost/User, YTD commitment, Variance, Capital Expenditures forecasts, Budgeted Cash Flow etc.
• Resolved issues related to Security, Security filters, Attributes, Aliases, Dimension building, Exporting data, EssCmd, Database portioning, Intelligent calculation, Calculation order, Outline calculation attributes, Member formulae, Dynamic calculations, Dynamic time series and Calc scripts.
• Worked with Essbase Integration Services (Meta Outline Workflow/Filters/Drill Through Reports).
• Develop MaxL Scripts for generating scheduling daily backup batch process and error checking.
• Extensively worked with Hyperion Reports 7.0 and Hyperion Analyzer 7.2. Developed reports for forecasting monthly expenditures, expense management and control, comparing actual vs. planned expenditure etc.
• Other duties involved providing support and maintenance for Hyperion OLAP Essbase Systems, including both client and server troubleshooting.
• Developed the Financial Reports and Sales Reports using Hyperion Reports 7.0.
• Used Smart View to integrate MS Office products with financial management and analytic services.

Environment: Hyperion Essbase 7.1.2, Essbase Integration Services 7.1.2, Hyperion Analyzer 7.2, Hyperion Reports 7.0, Essbase Excel Spreadsheet Add-In, Hyperion Smart View, MaxL, ESSCMD, MS-Office, MS SQL Server 7.0, Oracle 8i, SQL, PL/SQL, UNIX, MS Windows 2000/XP.

Confidential, India. Apr 2004 - Aug 2005
Quality Controller

Description: Confidential, is a leader in financial services providing information services, custody, investment management, trading, performance and analytic measurement, cash management and record keeping. Confidential, provides the comprehensive enterprise-wide customer management systems which are used to manage the activities of banking organizations in complex banking environments. Each product series offered a suite of optional extended modules, which allowed the customers to acquire a system tailored to their specific requirements.

Responsibilities:

• Experienced in both Manual and Automation testing tools like HP Quick Test Pro (QTP), HP Quality Center, WinRunner and LoadRunner.
• Developed manual test cases and also automated test scripts where needed to facilitate comprehensive testing.
• Designed test plans for functional testing. Performed functional and regression testing of the interface.
• Executed Black box, White box, Negative, Integration, UAT testing as per test plans.
• Documented and reported the bugs using Mercury Quality Center and provided the management with key metrics, graphs and reports.
• Execute analysis, debug, deployment, documentation, day to day Testing, Integration support of web based applications to verify and validate the functionality and performance, ensuring that all the applications meet the Corporate set Quality standards.
• All the applications has developed in JAVA, the front-end made using JSP, Servlets, Java Applets/Swing that connected to Oracledatabase using JDBC.
• Executed Oracle SQL Queries to perform backend validations. Pre reviewed testcases and uploaded testcases into testcase database.
• Designed and executed SQL Test Scripts using Oracle, and Involved in Testing Database with database check points by using Win Runner.
• Prepared Test Summary Reports and Metrics for various milestones.

Environment: HP Quick Test Pro (QTP), Test Director, Mercury Quality Center, Win Runner, Load Runner, (White Box and Black Box), Manual Testing, Oracle, SQL Server, SQL, PL/SQL, JDBC2.0, JNDI, Toad, MS Visual Source Safe (VSS), J2EE, JAVA, XML, JSP, Java Script, VB Script, SSH, DNS, MS-Office, UNIX, Windows NT/XP.

EDUCATION:

Masters in Science
P.G. DCA in Information Technology, India.