PROFESSIONAL SUMMARY:

• 9+years of professional IT experience in OLAP, Business Analysis, Requirements gathering, Designing, Developing and Testing of Hyperion Enterprise Performance Management Architecture EPMA and Java applications.
• 8 years of Strong experience in Hyperion Planning11.1.2, 11.1.1.3/9.3.1, Hyperion Essbase 11.1.2/11.1.1.3/9.3.1/7.x, Hyperion Financial Reporting.
• Well experienced in Planning Application implementation from end to end includes architecting, designing teh metadata, building, loading data. Worked wif Business unit, Process unit, Review process, Rules.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add - In, Hyperion Analyzer, Smart view and OBIEE.
• Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view, Hyperion Intelligence designer 8.3.2, MDM or DRM, ODI, OBIEE, EPMA.
• Expertise in writing Calc Scripts, Report Scripts and Load rules. Good Exposure on Hyperion Dashboard.
• Implemented/Installed teh EPM applications Essbase11.1.2/9.3.1, Planning11.1.2/9.3.1 in Windows Server 2003.
• Creating Macros/ CDF’s using VB scripts through Excel Spreadsheet Add-in, Smart views.
• Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulasand Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Upgradations,Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Created & Used ODIroutines to update teh metadata changes in Planning.
• Involved in developing Web forms usingHyperion planning web client for teh users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Possess excellent project management skills in managing, developing and implementing teh project. Possess excellent analytical, interpersonal, logical, communication skills, reliable and great team player.
• Experienced in knowledge transfer, preparing teh required documentation and training teh clients.
• Possess excellent analytical, logical, communication skills, familiar wif teh SDLC methodology of system development.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Planning11.1.2/9.3.1/4.x, Hyperion Essbase 11.1.2/9X/7.x/6x, HFM11.1.2, Hyperion System 9.3.1 BI+ Analytic Administration Services,Hyperion System 9.3.1 BI+,Hyperion System 9 Application Link (HAL), Hyperion System 9 BI+ Financial Reporting, Hyperion Intelligence designer 8.3.2, Hyperion Web Analysis 11.1.2/9.3(Analyzer), Esscmd, MaxL, Hyperion Financial Reports 11.1.2/9.3, Hyperion Enterprise and Hyperion Essbase Administration Services console (EAS),OBIEE Essbase Development,EPMA,ASO/BSO, Hyperion Data Integration Management (DIM), ODI,FDM,OBIEE

Dimension Modeling: Star-Schema Modeling, Erwin Snowflake Modeling, Fact and Dimension Tables.

Databases: Oracle 10g/9i/8i, DB2 UDB, MS SQL Server 2005 and MS Access.

Languages: SQL, PL/SQL, Perl.

Operating Systems: Windows NT 4.0/XP/2000/2003 and UNIX.

Server Applications: Apache-Tomcat, Active Directory, Terminal Services, Outlook Web Access (OWA), Front Office, Web logic 8.1

GUIs: Visual Basic 6.0/5.0, VB Scripts, VB.NET and TOAD.

Reporting Tools: Hyperion Financial Reports 11.x/9.x/7.x/2.x, SmartView, Essbase Excel Add-in, Hyperion Analyzer 7.x/6.x/5.x

PROFESSIONAL EXPERIENCE:

Confidential, Rhode Island

Hyperion Planning Admin

Responsibilities:

• Was responsible for creating, building, testing and documentation of reports for Co-operate reporting purposes and also for all teh business units.
• Was responsible for providing schemes for executing teh targets/deadlines by gather requirements and conducting meetings wif teh business units, assigning and assisting users wif tasks for functioning of Hyperion suite of products like ESSBASE, Planning, generating Reports and Analyzing teh data.
• Was responsible for designing and developing of Project Forecast and Revised Budget processes for teh business.
• Created Excel VBA base Overlay template for forecast data.
• Worked on different reporting template as per business requirement.
• Worked on maintenance activity like weekly load, daily load and monthly load data files.
• Customized calc scripts, batch script, rule files for data load.
• Was responsible for building financial reports for VP for Engineering and co-operate using Hyperion Financial Reporting and Scorecard Template.
• Was responsible for maintaining and administering security permissions for users and groups.
• Customization of applications, smart lists, data forms, menus and dimensions where done through workforce planning.
• Was responsible for providing support for teh project team for development until teh production and loaded metadata using FDM.
• Documentation of all teh issues which could occur for teh users and their respective solutions for reference was been created.

Environment: Hyperion Essbase11.1.1.3/11.1.2.2,OBIEE,EAS,Hyperion Planning 11.1.1.3/11.1.2.2, Hyperion workspace 11.1.1.3/11.1.2.2,Essbase Deployment Services,FDM.

Confidential, Berlin,CT

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for teh Regional agencies application and maintenance of teh same.
• Implemented teh cubes for reports on various scenarios as per business requirement.
• Developed teh outlines using teh text file method and by using Interface tool ODI.
• Created Hyperion Planning Application for North America and other region.
• Checking Err File for Dimension build as well as data load, if their is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Created Workflow Process for User to submit teh data to Approver and after Approval data Move to another layer.
• Worked as an Essbase administrator and created rules and give access privileges to teh users.
• Was responsible for administrating teh task of maintaining teh server, providing user security and application maintenance.
• Implemented EPM applications Essbase11.1.1.3 Planning 11.1.1.3 in Windows server.
• Developed Web Forms using Hyperion planning web client for teh users to input accounting changes and other variance explanations data.
• Written Essbase formulas, Calculation scripts, MDX formulas as per teh requirements and created substitution variables for teh ease of maintenance of application.
• Written MaxLscripts to load databases, adding users, alter substitution variables and executed teh scripts in both interactive modes and maintenance for daily backup.
• Trouble shooting teh errors which we face in Essbase, planning,ODI.
• Involved in to maintenance activities like Verifying teh new dimensional members which are coming in actual data load daily or monthly, Restoration procedure, security maintenance.
• Maintaining teh Planning and essbase objects like, outlines, calc scripts, Maxl scripts, report scripts, Partitions, Substitution variables, location aliases, business rules, run time prompts, global variables, security filters.
• Work on 6 BSO Cube and converted into one ASO Cube.
• Set up users and groups according to teh Business Entity andFinancial Channel security to users and groups from Hyperion shared services and assigned security to web forms.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: HyperionEssbase11.1.1.3/11.1.2.2c,EAS, EIS, Hyperion Planning 11.1.1.3/11.1.2.2,, Hyperion workspace 11.1.1.3/11.1.2.2, SQL Interface, Toad, SQL server 2005, Essbase Deployment Services.

Confidential, CT

Hyperion Essbase /Planning Lead (Dev/Admin)

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for teh Regional agencies application and maintenance of teh same.
• OBIEE 11g, teh Oracle Business Intelligence Server generates queries optimized for each data source, appropriately aggregates them, Web browser via easy-to-use dashboards and reports.
• Implemented teh cubes for reports on various scenarios on Actual/Budget/Forecast.
• Developed teh outlines using teh text file method and by using Interface tool ODI.
• Created Rule files for Data Loading in to teh cubes. And for Dimension building as well.
• Checking Err File for Dimension build as well as data load, if their is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Was responsible for handling teh administration of BSO/ASO cubes and creating Batch files, rule files using Maxl for data loading..
• Implemented/Installed teh EPM applications Essbase11.1.1.3/9.3.1 /Planning 11.1.1.3/9.3.1 in Windows server.
• Developed Web Forms using Hyperion planning web client for teh users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• Work on OBIEE Essbase Reports 11.1.1.3.
• Written Essbase formulas, Calculation scripts, MDX formulas as per teh requirements and created substitution variables for teh ease of maintenance of application.
• Written MaxLscripts to load databases, adding users, alter substitution variables and executed teh scripts in both interactive modes and maintenance for daily backup.
• Created DRM imports and Exports for Metadata changes.
• Trouble shooting teh errors which we face in Essbase, planning, EPMA, ODI and DRM.
• Involved in to maintenance activities like Verifying teh new dimensional members which are coming in actual data load daily or monthly, Restoration procedure, security maintenance.
• Maintaining teh Planning and essbase objects like, outlines, calc scripts, Maxl scripts, report scripts, LRO's, Partitions, Substitution variables, location aliases, business rules, run time prompts, global variables, security filters.
• Set up users and groups according to teh department and maintained security to users and groups from Hyperion shared services and assigned security to web forms.
• Installed and configured Hyperion financial reporting studio, web analysis and Hyperion spread sheet add-in in teh client systems.
• Developed some key reports like direct cost P&L summery, Income statement, Net Margin, Balance sheet and Headcount reports by using financial reporting studio.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: Hyperion Essbase11.1.1.3/9.3.1,EAS, EIS, Hyperion Planning 11.1.1.3/9.3.2, Hyperion financial Reporting 11.1.1.3, Hyperion workspace 11.1.1.3, Hyperion web analysis, ODI, MAXL, Essbase Deployment Services.

Confidential, Richmond, VA

Sr. Hyperion Essbase Developer

Responsibilities:

• Worked as an Essbase administrator and created rules and give access privileges to teh users.
• Was responsible for Designing and Reporting for forecasting using teh Hyperion Intelligence designer 8.3.2.
• Developed teh Profit and Loss statements, Balance sheetsreports and teh Essbase cubes for them.
• Used Hyperion Application Link (HAL) to integrate for data sources to Hyperion planning database.
• Worked on workforce planning and capital application.
• Was responsible to provide data integrity and verification of financial reporting using Hyperion FDM application.
• Worked on workforce planning to handle and forecasting of data for financial expenses.
• Was responsible for reporting using teh AS cubes.
• Was able to build teh outline using DIM adapter for Essbase.
• Was responsible for handling teh administration of BSOcubes.
• Was responsible for creating and maintaining of web data forms and journals using HFM.
• Used Hyperion Planning 9.3.1 to create new web forms to reduce teh work load of teh user theirby focusing on a Planning, Budgeting and Forecasting.
• Responsible for system life cycle documentation (SDLC) for teh changes made to teh system.
• Was responsible for building financial reports using Hyperion Financial Report.
• Created new complex calc- scripts for data calculations for reporting purposes and also re-scripted existing calc scripts for more TEMPeffective calculations.
• Responsible for Data Optimization and performance tuning for Essbase.
• Was responsible for transfer of data from General Ledger (GL) and ERP systems using DRM (Data Relational Management).
• Was responsible for developing dimension build rules, data loading and also maintain calc scripts via Esscmd and Maxl scripts.
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for providing schemes for executing teh targets/deadlines by gather requirements and conducting meetings wif teh business units.
• Created Dashboards for reporting using teh Web Analysis.
• Was responsible for leading teh team to maintain and development of Essbase cubes.
• Created reports using Web Analysis for financial data.
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using teh smart view for office.
• Was responsible for providing support for teh project team for development until teh production.
• Maintaining teh Planning and essbase objects like, outlines, calc scripts, Maxl scripts, report scripts, LRO's, Partitions, Substitution variables, location aliases, business rules, run time prompts, global variables, security filters.
• Documentation of all teh issues which could occur for teh users and their respective solutions for reference was been created.
• J D Edwards is teh ERP used in teh back end and Actual data was pulled from JD Edwards’s table space.

Environment: Hyperion Essbase 9.3.1,DB -2, Hyperion Reports V 9.3, Hyperion Analyzer, Hyperion Integration Services, SQL Server, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX, Windows.

Confidential, Chicago, IL

Hyperion Essbase Developer

Responsibilities:

• Coordinated wif business analysts / clients to understand and develop an optimized Essbase cube.
• Gatheird requirements and developed a project plan.
• Prepared an optimized data source.
• Developed aggregate storage cubes (ASO) using Essbase 7.1.
• Developed a transparent partition wif ASO / BSO cubes to leverage advantages of both technologies.
• Developed rule files for loading data and for dimension build.
• Implemented robust data-access security and user management.
• Automating of cube refresh through MaxL and UNIX Scripts.
• Optimized data loads and calculation scripts and maintained existing Essbase cubes.
• Optimized teh applications to reduce runtime.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Maintained teh OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing appropriate documentation.

Environment: Hyperion Essbase 7.1.5, Hyperion Reports 7.0, Hyperion SQR, Hyperion Planning, PL/SQL, SQL Server, Excel Add-in, Windows NT 4.0, Oracle 8i.

Confidential, Chicago, IL

Web Designer/Developer

Responsibilities:

• Updating company websites which includes information, images, various media and products.
• Analyzes designs, develops, test, and supports all aspects of web services.
• Developed Wordpress website from scratch.
• Maintaining Wordpress and CMS Website regularly.
• Create design prototypes, including graphic design and layout of content, for emails and landing pages.
• Designing and sending emails wif ESP.
• Designing graphics, logos and animation for websites.
• Designing responsive website using HTML5 & CSS3, Fluid Grid layout.
• Overseeing and driving day-to-day website operations.
• Creating processes for posting content to teh website.
• Ensuring web site quality, performance and reliability.
• Search Engine Optimization.
• Designing brochures, newsletters, light boxes, signs, posters and other promotional material.
• Making animation wif flash and JavaScript.
• Creating flash animation for education, ads and for websites.
• Maintaining database wif MySQL/SQL.
• Keeping up-to-date wif recent technological and software developments.

Confidential

Web Designer/Developer

Responsibilities:

• Analyzes designs, develops, test, and supports all aspects of web services.
• Edits, maintains and updates current web pages.
• Maintains company’s websites updating content, images, videos etc.
• Consults wif program administrator/coordinators to determine departmental web page needs and goals.
• Defines web page design criteria, ensures design is consistent wif existing or established standards.
• Making animation wif flash for web.
• Overseeing and driving day-to-day website operations.