PROFESSIONAL SUMMARY:

• 9+ years of experience in design, analysis, development and administration of various applications in Hyperion Suite of Technologies.
• Experience in full cycle implementation of Hyperion Essbase, Planning applications, extensive experience in Administration of production applications.
• Expert in a full lifecycle development in a Hyperion Planning(EPM) environment from initial conception through implementation including Requirement gathering, design, development, testing, implementation, maintenance and administration of planning cubes with substantial knowledge on various planning components like Web forms, Security, Meta data maintenance, Business rules, Workflow, Task lists and Smart view for Office.
• Extensive experience in designing/developing applications in client/server OLAP environment using Hyperion Essbase, EAS, MaxL, Hyperion Financial Reporting.
• Robust knowledge and experience in Essbase cube designing, Data Load Rules, developed numerous complex calc scripts, involved in application tuning and optimization, MaxL Scripting, Report Scripts, Automation using Batch scripts.
• Troubleshoot, diagnose, and solve Hyperion Planning/ Essbase related issues - Proactive tuning, optimizing, and maintenance of the Hyperion applications.
• Excellent analytical and research skills along with conceptual skills and demonstrated experience on documentation & presentation. Demonstrated ability to adapt to changing tools and technologies as well as changing business needs.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Ability to learn new tools, concepts and environments. Self-starter and Adaptive to new technologies.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. Have subsequent experience as Technical Lead in managing a team and work closely with multiple teams, developers and users.
• Solid communication abilities; able to articulate and document technical solutions to clients, executives, vendors, and team members at all proficiency levels.
• Maintain keen awareness of new development technologies and industry trends. Expertise in knowledge transfer, and Project Documentation.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Oracle/Hyperion Tools: Oracle EPM 11.x/Oracle Hyperion 9.x/Hyperion 7.x/6.x, Oracle Hyperion Shared Services, Essbase, Planning, Calc Manager, Workspace, EAS, MAXL, ESSCMD, MDX Scripting

Operating Systems: Windows 9x/2000/XP,2003 Server

Other Skills: Expert Level skill in MS Excel, MS Word and MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Hyperion Administrator

Responsibilities:

• Was responsible for design and development of Project Forecast and Revised Budget processes for the business.
• Was responsible for creating and testing new business rules and calculation scripts as per the needs of the users usingHyperion Planning11.1.2.
• Was responsible for building financial reports for management usingHyperion Financial Reporting 11.1.2 and Smart view.
• Developed BI Reporting dashboard, queries, reports using Hyperion Interactive reporting (IR)
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using thesmart viewfor office usingOBIEE.
• Was responsible for Support for Month end close and resolvingon-call issue for users.
• Was responsible for Optimization of Business Rules.
• Was responsible for designing and developing of the workflow process using planning unit inHyperion Planning11.1.2Was responsible for requirements gathering for cube building in Planning.
• Customization of applications, smart lists, Data forms, menus and dimensions where done throughHyperion Planning11.1.2.
• Target Designer—The Targets menu of Warehouse Designer (in Data Integration Management) includes the Import from Hyperion Planning command for use with theDIMAdapter for Planning
• Was responsible for handling the administration ofBSO/ASOcubes and creatingBatch files, rule files using Maxl for data loading.
• Was responsible for creating, maintaining and loading data through extract scripts and rules as abackup process for recovery of data.
• Responsible for Data Optimization and performance tuning of the application.
• Was responsible for resolving functional and technical issues inProduction support.
• Created exiting budget book report by using Financial Reporting Studio and Web analysis.
• By usingInteractive Reporting (BRIO) 11.1.2created various weekly, monthly, and quarterly reports to provide executives, business users.
• Was responsible for system maintenance and applying patches if necessary.
• Was involved in Installing, Configuration,Upgrading and Migration from Hyperion 11.1.0 suite to Hyperion 11.1.2(Oracle EPM).
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for loading data throughODIand resolve issue if any in the process. CreatedODI packagesto load actuals data into planning cubes and automated those usingODI Scenarios.
• Was responsible for providing data toPDDfor reporting purpose.
• Created Hyperion dashboards pivots, charts, reports using Interactive Reporting Studio11.1.2
• Was responsible for providing Functional and technical support for problem identification and solving for issues occurring from development to production environment.
• Provided documentation of all the technical and functional issues which would be helpful to users for future reference.
• Used Essbase Studio to create drill through reports and automated EIS using olapi and cbs scripts. Created cube schema in Studio.

Environment: Hyperion Essbase 11.1.2,ODI 11.x,DRM,Hyperion Planning11.x, PDD, MFGPRO, Hyperion Financial Reports Studio, ODI, Hyperion Analyzer, Hyperion Integration Services, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Windows NT/2003, SharePoint.

Confidential, NJ

Hyperion Essbase Developer

Responsibilities:

• Involved in gathering/analyzing new requirements for Essbase and planning application
• Created BSO applications and automated the process for data load using Maxl scripts and batch scripts
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds
• Was responsible for assigning work for the DBAs related to Hyperion suite products, and conduct meetings with the business units to gather new user requirements, build road-map and the plan targets/deadlines
• Created web forms, business rule and workflows in Hyperion Planning application(EPM)
• Created reports using financial reporting and involved in decision making for future fiscal years by forecasting and budgeting
• Designed several custom reports using Hyperion System 9 Interactive Reporting for Corporate reporting processes (Monthly, Quarterly and Annual)
• Worked with Hyperion workspace to schedule the batches for FR reporting
• Involved in installation of Hyperion Planning on Windows environment
• Involved in database and security refreshes in Hyperion Planning
• Creating financial reports on planning application
• Involved in the Essbase migration of 9.3 applications to 11.1
• Validated, tested all the 9x applications from development before migrating to 11x production environment
• Tested all the scripts, rules, and Meta data’s in 9.3 development before migrating to 11 x production.
• Migrated Essbase cubes, web forms, reporting scripts, calculation scripts, business rules, Meta data from 9.3 to 11.1

Environment: Oracle General Ledger, Hyperion System 11.x/9.x BI+Analytic Services, Oracle EPM 11.1.2.1(Smart view/Work space/planning/reporting). Hyperion Administration Services 11.1.1.2, Hyperion Workspace 11.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Responsible for end-to-end implementation activities such as design, development, testing and user training
• Worked on Hyperion system 9 BI+ to create various BSO applications for budgeting, planning and forecasting
• Created and modified load rules, Dimension building and Business Rules
• Performed data loading from external sources to populate the database by free form data load method or rules file to plot values to the outline
• Created and maintained Essbase financial application objects including outline, Calc scripts and data load rules and user security objects
• Examined all standard and attribute dimensions and members in the Essbase outline editor for optimization and performance
• Used MaxL and Esscmd scripts to create batch files for database optimization
• Responsible for tuning the multidimensional cubes to optimize calculations time by using the calculation scripts using the combination of ESSCMD and Maxl
• Worked on performance tuning to minimize data load time that was feeding Essbase Cubes using various external database systems
• Optimized dense and sparse database settings for improving retrieval times
• Involved in performance tuning, backup and recovery of cubes

Environment: Windows NT, Hyperion Essbase 11.1.1.2, Essbase Spreadsheet Add-In, Essbase Integration Services 11.1.1.2, Web Analysis, MS Excel, SQL, Oracle log

Confidential

IT Consultant

Responsibilities:

• Worked closely with technical leads to understand business requirements
• Performed technical analysis of business requirements and formulated coding solutions.
• Involved in generating the end user expected reports
• Preparing the documentation for bidding process based on the quality specifications by consumers
• Extensively involved in database design
• Provided day to day support for the company’s data analysis requirements-designing procedures and queries to meet stakeholder needs.
• Involved in optimizing the Sql queries for better performance
• Designed and developed Sql Scripts to create, alter, and drop database objects, like tables, views, and sequences for security and efficiency
• Developed and modified code to make new enhancements or resolve problems, as per customer requirements
• Developed PL/SQL Functions & Procedures for extracting the market price data as per the user request
• Performed Unit Testing, White box and Black box testing on the created modules
• Involved in creating reports on purchasing patterns as per requirements

Environment: SQL, PL/SQL, SQL*Plus, TOAD, Marape Modeling, GAMS Modeling tool, MS Office, MS Visio, MS Access, Windows XP