We provide IT Staff Augmentation Services!

Hyperion/drm Consultant Resume

MA

SUMMARY

  • Over 9 years of IT experience and over 7 years of experience in OLAP/Business Intelligence.
  • Extensive experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11.1/9.3.1/7. X Essbase Integration Server (EIS), Hyperion Financial Reporting/Interactive Reporting, Hyperion Analyzer, Hyperion Planning 9.x/11.x, Essbase Spreadsheet Add - in, Essbase Query Designer on Windows and Unix environments. Well-versed in SDLC (Software Development Life Cycle)
  • Extensive experience in planning, analysis, design, implementation, testing, quality assurance and administration in a client-server environment with expertise in developing business applications in Relational (RDBMS) and Multi-Dimensional (MDBMS) Databases
  • Designed and developed numerous cubes and Multi-dimensional databases using both ASO and BSO
  • Expert in Essbase Cube Analysis, Design and Maintenance, Essbase Database Administration upgrades, Database backups, Performance tuning and Optimization.
  • Worked on Dimension Building, Data Loading, Database Optimization, Data Partitioning, performed Database backups, Dense/Sparse settings and strong knowledge in MDM, DRM and ODI.
  • Extensive experience in Calc Scripts, Report scripts, and automated teh cubes using MaxL and Esscmd.
  • Expert in Hyperion administration activities like server and application maintenance, developing application security process, creating users/groups, security profiles and application access to different groups using filters
  • Expert in software installation, configuration, upgrading, testing and migrating of Essbase applications.
  • Proficient in teh star and snowflake schema data modeling technique used to design for data warehouse.
  • Skilled in developing Financial Budgeting and Forecasting, Production Reports to support financial analysts.
  • Knowledge of integrating teh Microsoft Office tools with OLAP Server.
  • Results-oriented individual who views challenge as an opportunity. A strong team player capable of working independently with excellent communication, analytical, and inter-personal skills.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Financial Management Suite (HFM), Excel Add-In, ESSCMD, MaxL, MDX and Hyperion Planning, ODI, FDQM, DRM, Essbase Studio.

Databases: Essbase 11/9.3.1, Oracle 8i/9i/11i/11g, SQL Server 2000, DB2, Toad 8.0, MS Access

Reporting Tools: BI+, Financial Reporting, Web Analysis, Hyperion Reports, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Smart View, Cognos series 8,OBIEE Suite of tools ( Interactive Reporting, Answers and Dashboards)

Internet Tools: HTML, DHTML, XML,VB Script, Java Script, JSP, ASP

Languages: SQL, PL/SQL, C/C++, Shell Scripting

OS: MS-DOS, UNIX, WINDOWS 2003/2008/2012, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux

PROFESSIONAL EXPERIENCE

Hyperion/DRM Consultant

Confidential, MA

Responsibilities:

  • Worked with teh data analysts and data owners to analyze teh as-is process of DRM environment
  • Implemented DRM Best Practices like: Node Sorting, Shared Nodes, LeveragingDRMPrefixes and Naming Conventions, Leveraging Properties and Inheritance and Creating Alternate hierarchies on teh fly.
  • Worked on regular maintenance activities, such as, updating planning and Essbase dimensions through DRM.
  • Created automation of hierarchy full extracts and differential extracts using DRM client utility and automated teh process using batch script
  • Created various ad hoc analysis reports using Smart View as per user requirements.

Environment: Hyperion Essbase 11.1.2.3, DRM 9.1, EPMA, MaxL, Hyperion SmartView and SQL

Hyperion Consultant

Confidential, NY

Responsibilities:

  • Had conducted deep dive meetings with teh business users to understand teh current automation process and adhoc jobs for budget/forecast calculations
  • Identified teh master scripts and documented teh current automation process dat involves hundreds of scripts dat are executed sequentially and remotely using psExec utilities.
  • Implemented DRM Best Practices like: Node Sorting, Shared Nodes, LeveragingDRMPrefixes and Naming Conventions, Leveraging Properties and Inheritance and Creating Alternate hierarchies on teh fly.
  • Discuss Complex General Ledger Integration Concepts: Chart of Accounts Hierarchy Reorganization, Mapping and Reconciliation, Mergers and Acquisitions, History data conversion, Allocations, Eliminations and Consolidations.
  • DRM Design and Solution Documents, Import Headers, Export Properties and overall ETL guidelines for file formats.
  • Maintenance and enhancements of DRM related activities.
  • Configured shared dimension data source connection in EPMA and enabled teh Planning applications to use Shared Dimension Library for teh dimension build process
  • Created/Modified SQL Loader jobs to upload static dimension hierarchies from spreadsheets, CSV/text files to staging tables
  • Created SQL based rules files to import slowly changing dimension (Employee) from PeopleSoft to Staging tables
  • Created SQL procedures to transform teh data from teh staging tables to Interface Schema in order to be consumed by EPMA automation process
  • Created EPMA automation process using EPMA client utility to automate teh dimension builds of teh shared dimension libraries.
  • Created “Import Profiles” in EPMA and included them as part of teh EPMA automation process using EPMA client utility
  • Created MaxL automation scripts to defrag and calculate teh database
  • Organized teh automation scripts by removing teh environment specific hard coding and driven teh values based off of config files
  • Thoroughly validated teh automation process along with Business users by creating validation sheets and reconciliation sheets.
  • Created various ad hoc analysis reports using Smart View as per user requirements.

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning, HFM, Exalytics, DRM, EPMA, SQL Loader, MaxL, HFR, Hyperion SmartView, SQL and Visual Explorer

Hyperion Consultant

Confidential

Responsibilities:

  • Participated in designing teh overall solution to enable teh Gross Profit analysis.
  • Created a BSO cube from scratch with 10 base dimensions and 3 attribute dimensions.
  • Created various web forms for entering teh data, which needs to be reverted back, to arrive at teh real numbers.
  • Enabled teh conversion of data, entered by teh users in local currencies, to USD dollars.
  • Automated teh loading of Exchange Rates on monthly basis through Maxl scripting,
  • Created Task Flows to automate teh loading of data from HFM to Planning cube on routine basis.
  • Written various calc scripts to compute teh desired values, such as, Distributors Allowance, Cost Freight Out, Cost of Packaging and Handling etc, and created an Analysis dimension to store these computed values.
  • Created various Financial Reports using Financial Reporting studio, such as, Gross Profit Consolidated, Gross Profit by Country, Profit and Loss Consolidated etc.
  • Created dimensions using outline load utility.
  • Created multiple reports using HFR, Interactive Reporting and developed Dashboards using OBIEE Suite
  • Created various alternate hierarchies and attribute dimensions to accommodate new user requirements.
  • Provided them with best practices for Hyperion Solution Hierarchy design and maintenance in DRM.
  • Worked on integration of DRM with Hyperion Essbase and Planning applications.
  • Managed HFM applications, metadata, data forms, member lists, journals and security.
  • Extracted data, from HFM applications, to databases by creating UDL files.
  • Extensively worked on teh budget close and Reconciliation of teh actuals data in reports by running SQL queries against teh EDW
  • Created various ad hoc analysis reports using Smart View as per user requirements.
  • Prepared various documents, such as, Design document, user guide, admin guide etc, and provided training to users for entering data through web forms and to retrieve Financial Reports.

Environment: Hyperion Essbase 11.1.2, Hyperion Planning, DRM, VBA, HFR, Hyperion SmartView, SQL and Visual Explorer, OBIEE Suite of tools (Interactive Reporting, Answers and Dashboards)

Hyperion Consultant

Confidential, Boston, MA

Responsibilities:

  • Conducted various meetings with teh users to gather and understand business requirements.
  • Documented various business requirements, deployment plans and prepared various users guides to facilitate teh users to learn and adapt to teh new systems.
  • Added new dimensions and members to teh cubes and created customized hierarchies to cater to teh specific needs of teh clients.
  • Worked on multicurrency applications to enable teh loading of data in various currencies and getting it converted in US dollars within teh cube.
  • Created various rules files to load data on daily, weekly or monthly basis.
  • Created various shell and MaxL scripts to automate teh clearing and loading of data to teh cube.
  • Worked on regular maintenance activities, such as, updating planning and Essbase dimensions through DRM.
  • Developed new business rules and calc scripts. Did enhancements and alterations to many business rules calc scripts.
  • Created so many financial reports using HFR Studio. Developed complex suppression logic for teh reports requiring revolving years and months.
  • Written various report scripts and did changes to many existing scripts as per user requirements.
  • Created various web forms (including composite forms) to enable teh business users to load data for budgeting and forecasting scenarios.
  • Prepared various test cases and assisted teh users in UAT testing.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning, VBA, HFR, Hyperion SmartView, Oracle 9i and 10g, SQL Server 2005, Teradata, Datastage, Bourne Shell, SQL and Visual Explorer.

Hyperion Consultant

Confidential, Seattle, WA

Responsibilities:

  • Developed and implemented an Aggregate Storage Cubes for each sub brand of Confidential . These cubes provide payroll actuals to enable efficient forecasting process. Here are a few key aspects of teh cube.
  • There are 12 Dimensions and approx 60,000 level zero members. Employee dimension gives ability to find teh actual payroll for each employee by store by day at teh most granular level.
  • Ability to drill down teh payroll amount to teh chart of accounts (GL perspective). An attribute dimension on teh COA provides HR view of expense buckets.
  • Ability to categorize teh payroll according to teh standard pay cycles
  • Built ETL interfaces with PeopleSoft to feed teh actual data thrice a week
  • Built replicated partition with Legacy forecasting cubes to support intensive reporting needs
  • Supported and enhanced eight Essbase cubes (Block Storage) and associated reporting deliverables.
  • Enhanced teh existing payroll forecasting excel templates ( models) to support changes in business process ( included Shipped Units as a driver to teh model)
  • Developed an Essbase cube exclusively for high performance reporting which throws two reports for each store on Mondays.
  • Implemented a Cognos solution for Incentive payouts for field associates
  • Developed two cubes for each brand to support budgeting/forecasting process. Here are a few features of teh cubes
  • Actuals data is loaded to “Aggregate Cube” and forecast/budget data is loaded a “Block Storage” Cube. A transparent partition is created to make teh “B” Cube as teh single data access point
  • Data is loaded incrementally to an interim cube by leveraging “Buffer” load capabilities of “A” cubes. This eliminated teh down time during teh daily data loads. A weekly refresh takes care of teh buffer data load to teh main cube.
  • Implemented an additional dimension to support “53 Week” paradigm of retail business
  • Implemented more granular views for Merchandise and Inventory analysis and shrink forecast.
  • Created multiple HFR reports for senior executives to give daily and weekly business updates
  • Used interactive reporting to create various reports
  • Eliminated 6 legacy cubes after implementing teh new set of company planning cubes which gave savings of more TEMPthan $250 K per annum ( H/W and manual processes)

Environment: Hyperion Essbase 11.1.1.2, 9.1, Hyperion Planning 11.1, VBA, HFR, Hyperion SmartView, Oracle 9i and 10g, SQL Server 2005, Cognos, Microstrategy, Teradata, Datastage, Bourne Shell, and SQL, Linux, Visual Explorer.

Hyperion Consultant

Confidential, Hayward, CA

Responsibilities:

  • Automated teh process of XREF which extracted teh data from Capital expenditure and Workforce cube to P&L cube.
  • Developed customized web forms for all cube along with teh business rules.
  • Developed Web Forms, Tasks, Rules to support business logic
  • Designed teh security model in Shared Services and integrated with MSAD/LDAP
  • Created multiple batch and mxl files to automate teh daily and weekly data loads
  • Supported business community by resolving data issues and load issues at extremely fast turnaround times
  • Supported FP&A management in monthly, quarterly and yearly close activities by creating working scenarios and loading teh data from other working scenarios
  • Created multiple VBA based Excel templates to automate data load, calculation and aggregations
  • Developed calc scripts for depreciation and amortization for Capex cube
  • Created various reports using interactive reporting
  • Integrated Excel Spreadsheets and Hyperion Reports with Hyperion Planning Database to analyze Plan Data
  • Designed, Developed and Generated Hyperion Essbase Reports using teh Hyperion Financial reports
  • Designed, Developed, and Enhanced Complex Essbase Load Rules Scripts for complex data load and dimension building tasks
  • Created a confluence wiki for making teh team more collaborative and productive

Environment: Hardware and Software Environment was Unix/Windows Servers, Hyperion Essbase ASO 9.0, Analyzer, Hyperion Integration Server (HIS/EIS), Hyperion Performance Suite, Hyperion SmartView, Hyperion Performance Scorecard, Oracle 9i and 10g, Business Objects XIR2, Datastage, IBM DB2, Bourne Shell, and SQL.

Hyperion Consultant

Confidential, Delaware

Responsibilities:

  • Developed and maintained Essbase cubes in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
  • Translated end user requirements into application design specifications and maintained applications to support user requests for modifications to current Excel Reporting.
  • Developed teh Rules Files, MaxL, Report, Calculation scripts.
  • Automated teh cube build process using MaxL& Batch scripts.
  • Optimized structure and loading through appropriate storage allocations and also optimized calculations scripts.
  • Involved in development of four cubes one for Sales, one for Production Planning and Budgeting, one for Market Research and one for Customer Analysis
  • Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
  • Developed Reports for monthly P&L reports, Sales Analysis reports.
  • Designed reports in Hyperion Interactive Reporting, including creating queries, chart reports, table and pivot reports, and dashboards.
  • Created Monthly, Quarterly and Yearly Reports for Balance Sheet and Income statement using Interactive Reporting.

Environment: Hyperion Essbase 7.1.6, Essbase Administration Services, Essbase Excel Add-In, Hyperion Interactive Reporting, Hyperion Analyzer 7.0, Windows XP, UNIX AIX 5.3.

Hyperion Developer

Confidential, New York, NY

Responsibilities:

  • Involved in creating various web forms, Hyperion Reports and Excel Add-In Reports.
  • Created workflow using Flat File adapter, planning adapter, and variable adapter in HAL to do teh dimension building in Hyperion Planning Applications
  • Implemented Hyperion Planning and Worked with Hyperion Planning in developing web-based forms for teh various budgeting purposes and implemented whole security matrix in Hyperion Planning.
  • Creation of multiple dimensions in different applications, loaded members in Hyperion Planning and HFM using Hyperion Application Link (HAL)
  • Imported, validated, and exported historical data to HFM using Hyperion Application Link Adapter (HAL)
  • Used HAL to load members into Hyperion Planning application from SQL source.
  • Used Hyperion Financial Management to improve productivity by accessing multiple data sources at teh same time to automate data loads from HFM, EDW into Hyperion Planning application.
  • Provided robust master data lifecycle and versioning capabilities, in conjunction with a powerful business rules engine and audit capabilities for validating and verifying changes in master data by Hyperion MDM.
  • Consolidated, correlated and standardized master data, businesses processes and analytical capabilities through Hyperion MDM.
  • Worked as an administrator to give access and privileges to various end users in different planning applications, and synchronizing teh passwords during teh Essbase log on.
  • Created numerous reports in Interactive Reporting tool and Dashboards using OBIEE suite.
  • Worked on teh Hyperion Intelligence 8.x which involved in developing reports using Insight, Dashboard Builder, Designer, and Architect. Modified and replaced existing financial, marketing reports.
  • Analyzed user requirements and involved in teh process of finalizing dimensions for cubes.
  • Created various MDX formulas for dimensional Metrics.
  • Optimized teh database outlines to have teh optimum load, calculation and retrieval times.
  • Scheduled Batches to process sets of reports and Books using Batch Editor and Batch Scheduler.
  • Created Books for various reports setting their dimensions finally adding reports to teh Books accordingly.

Environment: Hyperion System 9, Hyperion Essbase 7.1/6.5.4/6.0, Hyperion Planning 4.0, Hyperion Reports7.0, Hyperion Integration Services, Hyperion Administration Services, Hyperion Application Link (HAL) 7.0, Hyperion Intelligence 8.1, Essbase Excel-Add-in, MS Access, SQL Server 2000, Windows 2000/NT 4.0, DB2

Business Analyst

Confidential, San Francisco

Responsibilities:

  • Conducted user interviews, gathered and documented requirements and drafted teh requirements using Rational Rose Requisite Pro.
  • Identified, analyzed, defined and documented business processes.
  • Created and reviewed business requirements, functional specifications, project schedules, System requirement documentation and test plans.
  • Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements dat supported overall strategy, goals and objectives.
  • Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
  • Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Testing (UAT).
  • Developed test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
  • Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
  • Developed timelines for project delivery, and managed projects and resources to successful completion
  • Responsible for all project documentations and served as a liaison between teh business team and teh project team including Software development team by assisting in identifying, understanding, and documenting their business needs.
  • Assisted teh Project Manager in setting realistic project expectations, in evaluating teh impact of changes on teh organization and plans accordingly, and conducted project related presentations.
  • Provided technical assistance in identifying, evaluating, and developing systems and procedures dat were cost effective and met business requirements.

Environment: Microsoft word, Excel, MS Visio, UML, SQL, Java and other proprietary applications.

Business Data Analyst

Confidential, Santa Clara, CA

Responsibilities:

  • Identified internal and external system requirements, design and configuration set-up and documented and delivered Business Requirements Document (BRD) / Functional Requirement Specifications (FRS).
  • Participated in providing implementation assessment using Rational Unified Process (RUP) and utilized Unified Modeling Language (UML) for developing required documents.
  • Coordinated teh project, developed project delivery schedule and identified resources to successful completion.
  • Worked as teh primary liaison between teh business user and teh developers throughout project cycle.
  • Proficient with documenting What If (WI) analysis and Standard Operating Procedures (SOP).
  • Worked to develop a process model capable of simulation, assess risks and benefits of a future process design based on simulation data, process design goals, and using statistical distribution to describe allocation of resources in teh model.
  • Trained and worked on STARLIMS for core analytical laboratory management.
  • Strong Understanding of Pharmacovigilance through Argus Insight and Safety.
  • Involved in creating Entity Relationship(ER) diagrams, Dictionaries, Data Architecture, Data Validation.
  • Collaborated with teh Project Managers in Tracking and Managing Project Development Process.
  • Worked with development and testing teams to accomplish timely release objectives.
  • Proficient with Public Key Interface (PKI) and other security issues concerning digital signatures and digital certificates.
  • Oversee any change request process, and facilitate weekly meetings, coordinate with business project leadership to identify and gain commitment in teh concept and rollout timeframe of project.
  • Facilitated Joint Application Development (JAD) Sessions.
  • Assisted in developing ETL codes to extract, summarize/aggregate data and load data from teh data warehouse to dependent data marts also Integration with data source, ETL tools with unified infrastructure.

Environment: MS Office, MS-Project, MS Visio, Rational Requisite software, Crystal reports, SQL, PL/SQL, Oracle, IBIEE, LIMS Basic, Argus Insight, Safety, Web 2.0 applications.

Hire Now