SUMMARY

• 7 years of efficient, dynamic, result - oriented experience in IT, Design & Development of OLAP, Decision Support Systems, Business Intelligence, and Client/Server Applications.
• Expertise in a range of Hyperion products including Essbase, Hyperion Planning, Web Analysis, Integration Services, Smart view and Spreadsheet Add-In, in Windows environments.
• Experience with installation, configuration of 11.1.2 versions and migration from 9.3.1 versions.
• Expertise in ETL tool like FDM and ODI.
• Expertise with relational drill-through, managing spreadsheet templates, reporting on web-analysis and Interactive Reporting.
• Expertise in Calc Scripts, MaxL, MDX Querying, Esscmd, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework.
• Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Applied in-depth understanding of STAR and SNOWFLAKE SCHEMA modeling techniques to develop optimized OLAP models and meta-outlines using relational and other database sources.
• Skilled in installations, upgrades, and configuration procedures in client/server environments.
• Result oriented experience performance optimization, tuning, performance analysis, and creation of debugging procedures through development of dynamic test cases.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase.
• Applied Brio Reports knowledge for reports generation and portal development.
• Extensive experience with Migrations of Essbase version 6.x & 9.x.
• Experience with Clarity Tool.
• Expertise in building Relational Databases using SQL Server and Oracle and knowledge of Essbase server upgrades.
• Proficiency in data warehousing techniques, application of PL/SQL for migration, querying, development, end-user training, parallel testing and production environment for Essbase.

TECHNICAL SKILLS

Computer Software: Microsoft Word, Excel, PowerPoint, Access, Outlook, Stat graphics, SPSS.

Analytic Tools: Hyperion Essbase System 11.x/9x/7x/6.5.1,Essbase Administration Services(EAS),Hyperion Essbase Integration Services (EIS)9.x/7.x, Hyperion Shared Services

Analysis Tools: Hyperion Planning 11.x/9.3.1/3.x,Hyperion Business Rules(HBR)

Reporting Tools: Web Analysis, Hyperion Analyzer 6.5, Hyperion Reports 7.2, Hyperion Financial Reporting 9.x, OBIEE/OBIEE+, Interactive reporting, SQR production reporting Excel Add-in.

Databases: Oracle 11g/10g/9i, SQL Server 2005,2000

Languages: MDX, MaxL, ESSCMD, SQL, PL/SQL Scripting.

Operating Systems: IBM AIX 5.x,6.x,MS Windows 2003, 2008, NT / XP / / 95,/ DOS

Dimensional Modeling & Integration Tools: Star Schema and Snow Flake Schema Modeling, Fact and Dimensional Tables, Physical and Logical Data Modeling FDQM 11.x/9.x, EIS 9.x,7.x

PROFESSIONAL EXPERIENCE

Confidential, Santa, Clara California

Hyperion Developer & Support Lead

Responsibilities:

• Involved in Migration from 9.1.2.to 11.1.2.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Involved in production support and maintenance of existing (ASO & BSO) cubes. Worked as a team member in Hyperion Essbase & Planning migration activity.
• Used ODI as an adaptor to retrieve data from the source.
• Responsible for end to end build and testing of all the applications.
• Involved in improving performance of the applications by adding new dimensions and optimized data retrieval by creating materialized views
• Maintained application security and added/deleted users per management requests.
• Was responsible for all the scripts migrations and their validations in all the environments.
• Assist Financial Analysts to load and validate their budget, and prepare Actuals, forecasts, budget, ad-hoc reporting and management reporting by working with the departments’ managers.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Provide support to users on access related issue and to some users, installing essbase add ins and smart view.
• Involved in testing the performance of the scripts in UAT and preparing test cases and results.
• Involved in Knowledge transfer and development transition to the other team members and to production team(onshore and offshore).
• Analyzed financial results and prepared web based financial budgeting and forecasting with Hyperion Planning tool to support business managers make profitable decisions.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Expertise in development and performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision

Environment: Oracle EPM suite 11.1.2.1, Oracle System 9 Suite (Hyperion Planning, Essbase, EASAPS, Shared Services, Workspace, Hyperion BI+), Smart View, Excel - Add-in, Oracle 10g, ODI6.1,Windows 2008 R2 server.

Confidential, Los Angeles

Hyperion Developer/Admin

Responsibilities:

• Involved in requirements gathering, design, development, implementation, production testing, and implementation of planning project.
• Applied HP for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data. .
• Involved in performance issues of FDM mapping.
• Used ODI and FDM to extract data from people soft.
• Loaded Data to multiple target applications of multiple systems using Financial Data Management (FDM).
• Translated end user requirements into application design specifications.
• Developed ASO and BSO cubes using Hyperion Essbase that contained financial data that was retrieved using FR reports and supported Excel Add-in for MS Excel 2003
• Developed Hyperion Planning application (full cycle implementation) for budgeting and forecasting requirements. Worked with business analysts for requirements gathering and creation of design documentation.
• Worked on the performance tuning (Cube Optimization) of the BSO cubes for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulas and by optimizing Calc scripts
• Performed data loads using FDM.
• Worked extensively with Data forms, Data grids, Rules, Journal entries, FDM, Calculations, and Consolidations.
• Created enterprise view of both Financial and Analytical Master Data Management.
• MS Excel Report generation with VBA programming for Essbase.
• Created maps to handle sign flips for some accounts.

Environment: Hyperion 11.1.1.2/9.3.1 , Hyperion Essbase 11.1.1.2/9.3.1 , Hyperion Financial Reports, ODI, Hyperion Web Analysis, Workspace, Shared Services, Hyperion Planning 11.1.1.2/ 9.3.1 , ESSCMD, Calc Script, ESSCMD, MaxL, MDX, SQL, VBA Excel Windows NT Essbase.

Confidential, Columbus, OH

Hyperion admin

Responsibilities:

• Involved discussions with business users to derive requirements. Lead design sessions and created functional and technical design documents.
• Expertise in designing and developing of ASO and BSO cubes to support Planning, Forecasting and Reporting.
• Trouble shoot all critical issues in time in order to not to miss the SLA(Service level agreement ) and also Qtr release to the Press.
• Worked and used DRM/MDM in the following areas: Import/export process, Blenders, various metadata validation processes
• Optimized the various cache settings to enhance the performance of Cubes.
• Created Unix scripts using MaxL to automate Essbase application refresh process (dimension building, data loading and calc scripts).
• Involved in developing Report scripts to export data from ASO applications.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Responsible for security provisioning using shared services across the entire Hyperion environment.
• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training across subsidiaries.
• Worked with offshore team in order provide Overnight processing tasks.
• Created reports Using Smart View and Excel Add-ins.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Worked Extensively on Shared Services, Essbase applications 9.3.1. Performed monthly, weekly and quarterly data loads and verifications.
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly budget data.
• Worked with the business users directly on Drill through issues
• Responsible for month-end tie-out and provide related support to financial controllers.

Environment: Essbase Administration Services 9.3.1/7.1.6. , MAXL, Hyperion Work Space 11.1.1.3,Hyperion Integration Services, DRM Autosys, Smart View, Essbase Excel Add-In, Oracle 10g, Solaris, Unix / AIX Shell scripts.

Confidential, New York, NY

Hyperio Developer/Financial Reporting

Responsibilities:

• Provided seamless integration of historical, projected and derived data.
• Involved in dimension building and data loading using Essbase Integration Services (EIS) by OLAP Models and Meta outlines.
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging
• Automated Essbase operations through ESSCMD and MaxL scripts in shell script programming to run monthly balance sheets and ledgers.
• Involved in performing DBA activities such as performance tuning the calculation scripts, along with taking periodical ESSBASE backups.
• Played major role in user requirement analysis, development and implementation of finalizing dimensions and members of the cubes.
• Responsible to develop Object like load rules, report scripts, formulas and batch scripts by using ESSCMD.
• Provided web-enabled reports using for OLAP application.
• Involved in installation and upgrade of Essbase Administrative services, Essbase Integration Services, Hyperion Reports and Hyperion Analyzer.
• Retrieved data using Hyperion Essbase Excel Add-in for analysis of data.
• Involved in development and modification of existing financial and marketing reports which include corporate consolidation reports, and financial and planning reports for management.
• Loaded data using Essbase Integration Services (EIS).
• Implemented star schema and used EIS to interface with the company’s existing Oracle 10g data warehouse.
• Designed dashboard layout for populate report specific data points from each departments within the organizations.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods using Hyperion Reports/Analyzer.
• Prepared ad-hoc reporting and management reporting, quarterly forecasts, annual budget, by working with the business managers.
• Automated the data loads using ESSCMD in both interactive and batch modes.
• Involved in installation and migration of the existing cubes as part of system 9 POC.

Environment: Hyperion EssBase 7.1/6.5.4, Essbase Integration Services 7.1/6.5.,Hyperion Planning 4.0/3.5, Hyperion Reports 7.0/2.6, Hyperion Analyzer 7.0/6.5 Excel-Add-in, MS Access, Oracle 9.x/8.x, Windows 2000

Confidential

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.
• Develop new Essbase cubes and database objects or update existing ones to meet new business requirements.
• Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts.
• Developed and designed cubes using Essbase Integration Services.
• Managed system upgrades and client installations based on users requirements.
• Developed Batch files using MaxL, and Rules files to upload data from financial systems Database to Essbase cube.
• 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.

Environment: Hyperion Essbase 7.1.2, EAS 7.1.2, EIS, Excel Spreadsheet Add-In, Hyperion Analyzer 7.2, Hyperion Reports 7.2, Windows 2003.

Confidential

Oracle Developer

Responsibilities:

• Worked extensively on detailed system analysis, design and development of the system lifecycle.
• 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.
• Used ASP and Developer 2000 for designing the client server applications.
• Developed Manual Test Scripts for unit testing.
• Performed Integration testing simulating a real time production environment.
• Developed reports using SQL* Plus and Crystal Reports.

Environment: Pl/SQL, Oracle, Win2000