We provide IT Staff Augmentation Services!

Data Warehouse Resume Profile

Lansing, MI

SUMMARY OF EXPERTISE:

  • Over 6 years as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
  • Experience in the Implementation, development, design, analysis and of various applications using Essbase 11.x/9.x/7.x/6.x, planning 11.x/9.x/4.x/3.x, Hyperion Workforce Planning, Hyperion Capital Expense Planning, Essbase Integration Services, Hyperion financial Reports, Essbase Studio and Essbase Spreadsheet Add-In, Smartview.
  • Worked on installation and configuration of Hyperion EPM 11.1.2.3 version on windows/Unix environments.
  • Extensive experience in all critical phases of Software Development Life Cycle SDLC like research, analysis, design, modeling, development, testing, deployment, and support.
  • Good understanding of RDBMS, data warehousing, data reporting and experienced in writing queries using SQL. Experienced in dimensional modeling using Star Schema and Snow-Flake Schema.
  • Extensive experience in design, development, performance tuning and optimization of Essbase databases. Well versed in Essbase architecture, Calculation Scripts, Business Rules, Aggregate Storage Option ASO , Block Storage Option BSO , MDX Member calculations, ESSCMD, MaxL for batch scripting, and shell scripting.
  • Worked extensively on Hyperion Financial Reporting Studio, created edited Financial Reports
  • Understanding of Essbase security features and ability to create user and group profiles, and assign the proper privileges.
  • Strong Understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes. Used ODI to load data into planning.
  • Strong SQL knowledge in creating queries, tables, and relational references, and maintaining the referential and data integrity.
  • Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules
  • Created the Meta Data using EPMA Data synchronization, ADS files
  • Proficient in building dimensions dynamically, creating rule files, loading data in Essbase applications.
  • Functional background with regard to gathering and analyzing the requirements of users and translating them into specifics cube definitions and design.
  • In depth understanding of Essbase security features and ability to create user/group profiles, and assign proper privileges using both native security, and shared services mode.
  • Worked on Dimension Building, Data Loading, Database Optimization, performed Database backups, Dense/Sparse settings.
  • Experience in Calc Scripts, Report scripts, and automated the cubes using Maxl and Esscmd.
  • 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:

Hyperion Essbase 11.x/9.3.1/7.X/6.x, Hyperion Planning 3.0/3.3/3.5/4.x/9.x/11.x, Hyperion Financial Management9.3/11.x, Financial Data Quality Management FDQM 9.3, Oracle Data Integrator 11G , Hyperion SharedServices System 9 BI , Hyperion System 9 Smart View, Hyperion Financial Reports 11.1.1.3,Teradata v13, SQL, Java, MS Office, Quick Books, Peachtree Accounting, MS Visio, Windows,,UNIX, HTML, XML, Java Script, Servlets, JSP, Oracle 11g/10g / 9i / 8i / 7x, MS SQL Server 2000/2005/2008, MS Access, SQL plus, Hyperion Financial Reporting, Hyperion Analyzer/Web Analysis, Excel Add-in, Smart View.

PROFESSIONAL ACCOMPLISHMENTS

Confidential

Confidential credit is subsidiary of Ford Motor Company. Their experts providing financing to Ford Motor vehicles create plans for the customer for flexible way to lease or assisting buying ford motor vehicle .The purpose of the project was to implement GAAP and IFRS accounting standard in to the pre-existing models which were used for forecasting, planning and budgeting purpose. This change in application will integrate financial and operational planning process on world standard and will improve business predictability and productivity.

Responsibilities

  • Worked as Essbase and Financial consultant in Finance Analysis and Treasury Risk Systems team. Project worked is involving Global financial analytical service and financial forecasting application.
  • Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage ASO and Block Storage BSO cube as per the requirement.
  • Worked with Essbase and Teradata which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data thru essbase and created and resolved any mapping kick outs.
  • Developed and customized Data Forms in Hyperion essbase for users to input forecast, working data and accounting changes and other variance data.
  • Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Developed Calc Scripts to calculate various Metrics for the outline.
  • The included application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P L, Functional P L and Revenue for USA ,Europe and ASIA
  • Loaded actual in to Hyperion essbase to drive actuals, forecast and budget numbers.
  • Performed Integration test, system test and validation of reports and report data.
  • Created and edited Hyperion essbase reports using Excel add-in.
  • Worked closely with external auditors, business analyst and business Intelligence team.
  • Implement best practice in to Essbase in order to get highest performance out of the cube.

Environment: Windows Server 2008, Hyperion essbase11.1.1.3 Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Reporting / Hyperion Essbase /,Teradata v13,Teradata ODBC

Confidential

Hyperion Financial Analyst

Confidential is a provider of home internet and cable television. It's the third largest home telephone service provider in the Confidential. It also provides their customer with home security in residential and commercial customers across America.

Responsibilities:

  • Worked as a Financial Business Analyst on Hyperion Essbase/Planning multi-currency application for the companies budgeting and forecasting purpose.
  • Perform monthly consolidate reporting of fixed assed and capital spending for the upper management.
  • Developed financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well in cash flow statements.
  • Reported directly to senior management for issuance of management reports for earned and unearned revenue by title.
  • Developed reports using Hyperion Interactive Reports, Hyperion Financial Reports, Web Analysis, and modified existing reports.
  • Handled quarterly and year-end audit requirements. Worked closely with external auditors attorneys for International Transfer Pricing
  • Developed Hyperion Financial Management application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P L, Functional P L and Revenue.
  • Worked with HFM and FDM which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data thru FDM and created and resolved any GL Account mapping kick outs.
  • Created and edited Hyperion financial reports using Financial Reporting Studio.
  • Performed Integration test, system test and validation of reports and report data.
  • Worked directly with forecasters and planners and helped them in analysis.
  • Loaded actuals into Planning Application and consolidated actuals, forecast and budget numbers.
  • Used best practices to optimize calculation time.

Environment: Hyperion essbase11.1.2.3 Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Reporting / Hyperion Essbase / Planning Consultant

Confidential

Hyperion Consultant

Confidential is banking institution which provides it this clients with banking, insurance , brokerage and investment banking in the United States.

The purpose of this project was to develop an application for financial consolidation using Hyperion Financial Management and budgeting/forecasting application using Oracle Essbase and Oracle Hyperion Planning. This application will integrate financial and operational planning process and will improve business predictability.

Responsibilities:

  • Participated in gathering business and functional requirements details during business meetings and translated them into program specification documents.
  • Involved in the installation and configuration of the development server consisting of Hyperion System 11 Essbase, Hyperion Planning, Hyperion Financial Management Hyperion Shared Services, Financial Reports, Web Analysis and Workspace on UNIX.
  • Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage ASO and Block Storage BSO cube as per the requirement.
  • Developed and customized Data Forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
  • Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
  • Used Oracle Data Integrator ODI 11g for data loading.
  • Wrote calculation scripts and business rules to perform allocations based on different drivers.
  • Participated in optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
  • Developed reports using Hyperion Interactive Reports, Hyperion Financial Reports, Web Analysis, and modified existing reports to incorporate global operations.
  • Involved in database and security refreshes in Hyperion Planning.
  • Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
  • Created Hyperion Financial Management application to develop financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well cash flow statements.
  • Created applications, locations, import formats, mapping templates, control tables, integration scripts, and validation rules in Oracle Hyperion Financial Data Management FDM .
  • Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.

Environment: Hyperion System 11, Hyperion System 9 BI , Hyperion Essbase 11.x/9.x/7.x, Hyperion Planning, Hyperion Financial Management Suite HFM , Excel, Smart View, and FDQM, UNIX

Confidential

Hyperion Financial Analysis Reporting

Confidential Company produces day to day household products. In this project I worked on analysis of Revenue, Expenses and Assets data using Hyperion Essbase

Responsibilities:

  • Managed all franchise related accounting and advertising including Management variance Analysis reports using Hyperion Essbase Reports.
  • Performed analysis on Payroll and benefits functions using Hyperion Essbase Application.
  • Created Excel Add In Budget and forecasting Planning reports.
  • Created users and user groups in the Planning applications and assigned security to web forms.
  • Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
  • Worked directly with forecasters and planners and helped them in analysis
  • Designed and developed monthly, quarterly and yearly sales Cubes.
  • Developed Calc Scripts to calculate various Metrics for the outline.
  • Involved in weekly meetings, to discuss current project status.
  • Worked closely with outside auditors for Financial Statement Preparation.
  • Used best practices to optimize calculation time.
  • Supported Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.
  • Created reports using Hyperion Financial Reports and Smartview Excel Add-In from Hyperion Planning
  • Worked with FPNA teams for their month end close process.

Environment: Excel, VB Scripts, Macros, Hyperion Essbase 7.1/6.x, Hyperion Financial Reporting Studio Hyperion Planning Excel Add In

ETL Developer

Confidential is a global information company. The company provides product to IT services and business outsourcing to industries like insurance, banking, capital markets, mutual funds and asset management.

Responsibilities:

  • Involved in extracting data from various sources, applying the transformations before loading the data into target warehouse Oracle tables.
  • Worked on Informatica power center tools-Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer and Mapplet Designer.
  • Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, and Sequence Generator.
  • Used Informatica Designer to create mappings using different transformations to populate data to a data warehouse.
  • Involved in developing Unit Test cases for the developed mappings.
  • Extensively worked in the performance tuning of transformations, Mappings and Workflows.
  • Created sessions and Workflows using Informatica Workflow Manager.
  • Wrote PL/SQL procedures for processing business logic in the database, Tuning Sql queries for better performance.

Environment: Informatica 6.1, Oracle 9i, UNIX, Toad

Hire Now