SUMMARY

• 12+ years hands on experience in software industry and a wide range of progressive experience in assisting business users with design, product development, project management, production support, documentation, budget management and providing BI reports.10+ years of experience in data warehousing, development and administration using Hyperion Essbase 11.1.2.4, OBIEE, FR 11.1.2.3, Planning 11.1.2.4, Interactive Reporting, HFM.
• Proficient in all teh phases of Data Warehousing life cycle, including Extraction, Transformation, Loading, dimensional modeling, reporting and end - user support.
• Extensive experience in OLAP development, administration, and maintenance in a client-server environment using Hyperion Essbase 7.x/6.x,9.x Hyperion Reports, ESSCMD, MAXL, Essbase Excel Add-In and Smart view, Financial Reporting studio, Web analysis, ODI, DRM, EPMA, OBIEE, Business Objects, ASO, BSO, MDX. Strong database development and business-intelligence modeling capabilities.
• Extensive experience on calculation scripts and Business Rule. Extensive experience on Smartview and Excell-Addin
• .Excellent understanding of fundamental concepts of Data Modeling, Schema Design, Design of Dimension and Fact Tables. Expertise in implementing Essbase formulas, optimizing database and developing automation scripts. Interacted and provided solutions to business professionals and end users.

TECHNICAL SKILLS

Industries: Public Sector, Manufacturing, Telecommunications, Hotel, Banking

Functional Areas: Project Management, User-Acceptance Testing, Knowledge Transfer & Training, Financial Planning & Analysis, Financial Reporting, Corporate Consolidations, Annual Budgeting, Accounting, SEC, GAAP compliance, Compensation Metrics, Budgeting & Forecasting, Trouble-shooting & Problem Resolution, System Strategy & Implementation, Process Reviews & Improvements, Business & Operations Analysis

Methodologies: Systems Development Life-Cycle (SDLC), Agile, Six Sigma, Waterfall

Application Package: Oracle Hyperion Planning, Oracle Hyperion Workforce Planning, Oracle Hyperion Capital Asset Planning, Oracle Essbase, Smart View for Microsoft Office, Essbase Add-In for Microsoft Excel, Oracle Hyperion Financial Data Quality Management (FDM), Oracle Hyperion Financial Reporting, Hyperion Interactive Reporting, Enterprise Reporting, Oracle, TOAD, SAP, Business Objects, OBIEE

Database / DB Tools: Oracle, SQL Server, Neteza, Teradata, MS Access, People Soft, Lawson

Desktop Tools: Microsoft Project Manager, Visio, Publisher, Adobe

PROFESSIONAL EXPERIENCE

Confidential

Senior TEMPPrincipal Consultant (Hyperion/OBIEE)

Responsibilities:

• Provide production support for Hyperion Planning, Essbase, and Financial Reporting.
• Work with functional team on enhancement of existing process for improvement..
• Create financial reports, planning web forms and excel templates on Smartview.
• Work on change management system, create test scenarios for UAT and move to production.
• Hands on experience on Loading Metadata and data, using outline utility, ODI, rule files, and sql views.
• Schedule monthly variance reports and trend reports using workspace with teh bursting option,
• Covert Classic application to EPMA for Long Range Planning.
• Create composite form for better view after data submission.
• Translate strategic business needs into practical consolidations and reporting solutions
• Define systems strategy; develop systems requirements; design, prototype, implement and launch solutions
• Create necessary project plans during client design sessions
• Proactively and frequently communicate with customers to build and maintain a solid working relationship
• Tactically develop Hyperion Financial Management (HFM) environments, including outlines, FDM mappings, rules, reports, input forms and security.
• Design and build required reports using Hyperion reporting applications including Smartview
• Write and maintain clear, concise functional and technical specifications on HFM applications and business system processes
• Optimization of HFM, Planning an Essbase applications
• Maintain security of teh system using shared services for all teh components.
• Support users for their Smartview and excel add-in issue.
• Maintain and monitor nightly backup process and weekly maintenance.
• LCM used for migration on ad-hoc basis for application artifacts, security.
• Lead onsite and off-shore team for Hyperion.
• Create Business rules and calculation scripts for allocation, forecast, aggregation etc.
• Hyperion database maintenance and optimization (Calc scripts, outline, reports)
• Involve in requirement gathering for HFM.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into teh financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Identified teh aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP autantication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
• Created workflows for full load and incremental loads to be used by DAC
• Assembled subject areas and created execution plan and accommodated teh new metadata mappings.
• Monitoring Incremental & Full load through DAC.
• Trained End Users and Pilot Users about OBIEE Tools.
• Create disaster recovery guidelines for Hyperion and relational database.
• Create Out of teh box application for Hyperion workforce planning and Capex module.

Environment: Hyperion Essbase V 11.1.2.1 EMPA, Hyperion Planning, Workforce Planning, Capex, Oracle, Smart View, Excel Add-In, Hyperion Financial Reporting, Window Server 2008, VM, Citrix, Oracle, Oracle EBS, SQL, OBIEE, HFM

Confidential

TEMPPrincipal Consultant

Responsibilities:

• Hyperion Essbase, Hyperion Planning Installation, Configuration Upgrade from 7.1.6 to 9.3 to 11.1.3.
• Responsible for complete SDLC until production support. Build, Design, configure Hyperion Essbase Architecture for Financial Application.
• Gathering functional user’s requirements for modification on current system with new features.
• Working with Finance team for their Budget and monthly Estimates process.
• Hands on experience on Oracle Hyperion Essbase optimization, data flow, security, create new calc scripts.
• Create disaster recovery guidelines for Hyperion and relational database.
• Maintain data flow, create test scenarios for UAT.
• Create Financial Reports, (Trend reports, Variance reports, Qtr spending reports)
• Automate financial reporting through workspace using bursting option.
• Create Project Plan for Black & Decker financial System upgrade.
• Involved in reporting and analysis requirements, documenting teh reports specifications, implementing teh metadata layers includingPhysical, Business Model and Mapping and Presentation layer.
• Upgrade andmigration of OBIEE between dev/test/prod environments.
• Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing StarandSnow Flake schemas.
• Expertise in design and development of teh three layers(Physical/Business Model and Mapping/ Presentation)ofan OBIEE Metadata Repository(.rpd) using Oracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables,interactive dashboards, and reports.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in usingOBIEE Answersto create queries, format views, charts, and add user interactivity and dynamic content to enhance teh user experience.
• Experienced in working withVariable Managerto definesession and repository variablesandinitialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Proficient in Installation, configuration, and administration of teh OBIEE platform.
• Experienced in developingDimensional Hierarchies,Level Based Measures,and adding multiple sources to business model objects.
• Cost Allocation and derived Budget by formulas.
• Create Reporting package, which include Budget and Monthly Estimates on Financial Reporting studio.
• MDX formulas for financial database. Conversion of BSO cube to ASO.
• Transparent portioning for ASO and BSO cube.
• Support Finance user with their Excel Add-In, lock and send and access issues.
• Create Automation process for daily backups, weekly maintenance, daily loads.
• Build dimension and load data using rules file.

Environment: Hyperion Essbase V 11.1.1.3, EMP, HFM, Oracle, Smart View, Excel Add-In, Hyperion Financial ReportingWindow Server 2003, VM, Citrix, Oracle, OBIEE, Upstream.

Confidential

Oracle / Hyperion Consultant

Responsibilities:

• Responsible for capturing client requirements and project scope in functional specification deliverable, including identifying data sources required to satisfy teh scope and objective of teh project
• Coordinated teh team and tasks to facilitate and successfully identify business requirements, project scope, and resources
• Managed client expectations through formal and informal communications.
• Optimization Essbase databases, Improving financial process for global financial system.
• Create calculation script, for financial process.
• Create automation process for essbase backup, system maintenance, data load process.
• Hyperion Server Migration for system 9.3.1 which includes installation, configuration, testing.
• Gathering user requirments for re-organization.
• Deploy Essbase service to servers.
• Maintain Hyperion shared services for security and assign access to Global Financial system.
• Enhancement of Financial Reporting structure.
• Test and provide recommendation to client for stablity of system
• Create road map for Essbase optimization and upgrade process.

Environment: Hyperion Essbase 9.3.1, SQL Server, PeopleSoft, Oracle, Windows 2003, API’s

Confidential

Senior Specialist Consultant (Hyperion/OBIEE)

Responsibilities:

• Responsible for teh scoping, design and delivery of data migration, model development, and reporting. Solicited user requirements with system stakeholders. Designed and built Hyperion Planning, Performance Scorecard, and Financial Reports.
• Automation process for daily backups, weekly maintenance, daily loads.
• Create Business Rules, Calculation script, for financial process.
• Working on Payroll application and provide end user support.
• Hands on experience on Hyperion Server Migration for system 9.3.1 which includes installation, configuration, testing.
• Gathering user requirments for re-organization.
• Maintain Hyperion planning payroll application and essbase application.
• Maintain Hyperion shared services for security and assign access to Hypeiron Planning.
• Import and export of data, security, application.
• Enhancement of Financial Reporting structure.
• Created/modified Metadata repository using teh OBIEE 10g's Physical, Business Model and Mapping and Presentation Layers.
• Collaborated with Business Analysts, discussed and identified teh analytics requirements to be obtained from various user groups.
• Created star schemas in teh repository. Used teh foreign key link in teh physical layer and teh new complex joint key in teh Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Communicated directly with teh stakeholders to gather detailed requirements for business components, data interfaces, security and reporting through working sessions, walk-thru sessions and business process descriptions.
• Facilitated and documented teh business requirements
• Evaluated information harvested and created teh functional requirements documentation for application development.

Environment: Oracle's Hyperion Planning, Hyperion Essbase, Financial Reporting Studio, HAL, FDM, Web Analysis, Windows, OBIEE

Confidential

OBIEE Hyperion Consultant

Responsibilities:

• Upgrade Essbase 9.2 to 9.3, migration of Essbase application, database, and reports.
• Create new reports for revenue analysis using Financial Reporting studio and Interactive Reporting and dashboards.
• Working on ASO and BSO cube for financial database.
• Using Maxl script for automation, and create Bath Files for Backups, Building Dimensions, loading data, and executing calc script.
• Working on budget, revenue, salary and commission Applications.
• Maintain Application Security; assign users on shared service environment,
• Loading data and build dimension using rules files, EIS, and HAL process.
• Create Reporting and Application documentation for end users.
• Hyperion Planning Application Capex module and workforce for their budget and Planning Application.
• Calc script and business rules for budget application.
• Maintain Hyperion Planning/Essbase security.
• Installation and Configuration system 9.3.

Environment: Essbase Integration Services, System 9.2 Essbase, Smart View, HAL, Neteza, Redbrick, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10, Hyperion Planning, Lawson, AIX, Web sphere, Oracle 10g, MS Access

Confidential

Oracle Hyperion Developer Consultant

Responsibilities:

• Designed, developed, and implemented Cube for Item Transaction and Reporting System for teh Supply Chain Department using EIS, for better decision-making for Top Management. Complete SDLC with short amount of time.
• Create ASO cube for supply chain department and create MDX formulas.
• Involved in gathering requirements and developing a project plan for Finance Department
• Created Dynamic reports by using Interactive reporting based on teh user requirements.
• Created Outlines, Calc script, Load Rules for General Ledger using Essbase System 9 Application
• Database applications Using Essbase that stored and maintained company Financial, operations, Employee, and Sales data, and also data loading and Manipulations into teh database.
• Created reports (POV, Prompt in a Page, Page) based on teh user requirement using Financial Reporting Studio, Web Analysis and Dashboard (Demo)
• Created Calc scripts using teh Calc script editor for performing calculations.
• Maintained security and added/deleted users per management requests.
• Developed several Reports for Hyperion, validating and reconciling data using Interactive Reports and Smart View
• Convert Oracle Reports from RDBMS to Multidimensional Database through EIS by creating OLAP MODEL and Meta outline
• Used both Block storage and Aggregate Storage.
• Convert Business Object universe to Essbase cube.
• Maintain Hyperion Planning/Essbase security.
• Installation and Configuration system 9.3.

Environment: Essbase Integration Services, System 9.3.1 Essbase, Smart View, TOAD for Oracle, Teradata, Dashboard, Web Analysis, Financial Reporting, Interactive Reporting, Oracle 10gBrio, Visual Studio, MS Access, Business Object.

Confidential

Hyperion Consultant

Responsibilities:

• Involved in troubleshooting, Performance tuning and Performance monitoring.
• Created customized and ad-hoc reports using Excel spreadsheet add-in
• Creating and calculating Subscription Acquisition Cost (SAC) Reports for Management
• Developed various management web Reports using Hyperion Reports and scheduled teh reports
• Extensively involved in using Hyperion Reports, Analyze and Brio (Interactive Reporting)
• Provided technical support to business units and end users
• Retrieved data in Excel for teh analysts and other end users for teh purpose of forecasting and analysis
• Identifies teh report as being either Fully Automated, Automated with Manual Adjustment,
• Produce Monthly, Quarterly, and Trended SAC Reports
• Create Snap Shot, Books on Workspace

Environment: Hyperion Essbase 6.5.2, Hyperion Reports, ESSCMD, Excel Add-In, Windows NT/2000, Lawson G/L, Crystal Reports, Hyperion Planning. Brio

Confidential

Hyperion Developer

Responsibilities:

• Designed, developed, and implemented Expense Planning and Reporting System for teh Financial Department using Hyperion Planning,
• Involved in gathering requirements and developing a project plan.
• Created forms based on teh user requirement using Hyperion Planning.
• Created Business Rules, using Hyperion Business Rules, to attach teh forms in order to facilitate teh business process
• Database applications Using Essbase that stored and maintained company Financial, operations, marketing, and Sales data, and data loading and Manipulations into teh database using teh Hyperion Application Link (HAL).
• Created reports (POV, Prompt in a Page, Page) based on teh user requirement using Hyperion Reports and heavy use of brio.
• Created Calc scripts using teh Calc script editor for performing calculations.
• Maintained security and added/deleted users per management requests.
• Developed several Reports for Hyperion, validating and reconciling data using Hyperion Reports.
• Created applications, databases and data outlines using Essbase Application Manager with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion
• Involved in defining requirements, functional specifications and transformation rules
• Developed calc scripts for allocations, eliminations, moving teh data, calculating formulae etc depending upon teh business case
• Developed Report Scripts for extensive reporting in Report Extractor.

Environment:Hyperion Planning, Hyperion Essbase, Microsoft Excel Add In 2000, Hyperion Business Rules, Hyperion Application Link, Hyperion Reports, MS SQL Server 7.0, and Windows 2000 Server