We provide IT Staff Augmentation Services!

Senior Consultant Resume

Virginia, NJ

SUMMARY:

  • Over 8+ years of extensive experience in application designing and development using Hyperion Financial management, Hyperion Financial Strategic, HSF, FCM,ARM, FDM,DRM, Excel Add - In and Hyperion web Analyzer.
  • 3+ year experience into Hyperion Strategic management, close management and Account reconciliation management as a functional and admin.
  • Strong knowledge on HPCM and Public Sector and budgeting.
  • 4+ years of experience in project management and delivery management expert in change management and also in project deliverables.
  • Strong experience in people management, vendor management, account management.
  • 7 years of experience into DWH & BI technologies .Informatica, cognos planning .
  • Extensive experience on the installation, configuration, server settings, backups, client installations of Hyperion products such as HFM,FDM,DRM, Close management and Account reconciliation management and strategic management.
  • Over 6+ years of IT experience as a Financial Business Analyst Worked in Design, Development, Implementation, Administration and maintenance of various applications in Oracle EPM Product suits (Hyperion Essbase, Hyperion Planning, Oracle Data Integrator, OBIEE) including all phases of Software Development Life Cycle (SDLC) with different role as a Lead Developer, Sr. Developer and Hyperion Business Analyst.
  • Strong application development experience using different Oracle EPM Products Hyperion Essbase, Hyperion Planning including Workforce and CapEx Planning,ODI,OBIEE- Answer,Dashboard,Publisher, EPM 11.1.x.
  • Used Hyperion System 9 BI+ Interactive Reporting, Financial Reporting,
  • Experience withWork Space, VBA MACROS, ESSCMD, MAXL SCRIPTS, Shell Script API programming, Report Script, Crystal Report XI.
  • Strong hands on Experience as an Essbase Administrator including (EPM 11.x Installation and configuration) and performed various activities like, Installation of different Hyperion Products and Migration of applications server.
  • Good experience on automation of various processes, maintenance of Security, substation variables, backup using MaxL Scripting,Esscmd, Unix Shell scripting, archival process. Load process using Outline load utility.
  • Strong Experience in SQL Server and Oracle 10g,11g, Teradata, ETL tool like Oracle Data Integrator(ODI)
  • Big exposure to interact with Business User and gathering process requirement from finance, HR and Engineering Business users. Understanding of Organization Chart of Account and ETL extract metadata and data file for Hyperion applications. Defining the Solutiondesign (Creating Technical Design Documents) for multiple projects. Team player with strong interpersonal and communication skills with leading big development & support team for new implementation and migration/support projects.
  • Automation of scripts for loading reference data, performing batch processes and performing calculations where required.
  • Performs unit testing and maintains evidence of test plans and test results.
  • Performs integration test for all the integrated applications and maintains evidence of test plans and test results.Provides support for Quality Assurance and Regression test cycles.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 95/98/NT/2000/ME/XP, DOS, UNIX, LINUX, AIX 5.2

Languages: VB,JavaScript, HTML, XML, SQL, PL/SQL, UNIX Shell Scripting, MDX, MXL, ESSCMD, ESSMSH

Databases: Oracle 10G,11G, Teradata, SQL Server

Tools: & Utilities: EPM 11.1.2.3 Planning with Workforce and CapEx module, Hyperion EssBase 11.x/9.x/7.x/6.x, ODI,Financial Reports, Work Space, Hyperion 9 BI+ Interactive Reports, OBIEE- Answer, Dashboard, Publishers, Excel Add-in, SmartView, ESSCMD, MaxL, Excel VBA, Unix shell script.

Domain knowledge: Networking,Banking,Finance,Accounting,Energy utilities and Retail

PROFESSIONAL EXPERIENCE:

Confidential, Virginia, NJ

Senior Consultant

Responsibilities:

  • Worked as Hyperion senior resource on this project with different responsibilities right from beginning of the project.
  • Responsible for requirements gathering, installation, setups, automation and migration.
  • Worked as HFM functional resource in the beginning of the project and documented all the requirements.
  • Analyzed existing system captured all the important information. Identified gaps and provided assessment report to fill the gaps.
  • Worked with users from various parts of the world in requirement gathering phase and documented all the details.
  • Designed multi-currency application to support global transactions and converted into local currency.
  • Worked on 2 different versions of HFM at a same time and part of migration team from 9.x,11.1.2.0 to 11.1.2.3.
  • Implementing Database management to copy data from once scenario to another
  • Responsible for effective communication between the project team and the business
  • Prepared the Technical Documents by evaluating the mappings in BODI in DRM integrated Hyperion servers with People soft, JD Edwards, OBIEE,SAP
  • Developed the mappings, sessions and workflows in DRM
  • Tested individual modules of the software against the Unit test cases in DRM
  • Monthly update to the DRM Servers when new product and department Hierarchy comes from the people soft
  • Created user securities in DRM and expertise in Environment backups in DRM

Environment:, HFM,FDQM,DRM,HSF,FCM &ARM windows,SQL2005

Confidential, San Jose, CA

Sr. Business Analyst

Responsibilities:

  • Working with Business user to understand current state processes and gathering business requirement
  • Analysis and define future state processes based on business objectives
  • Responsible for documenting the system design and reviewing requirements documentation to ensure it is complete, deliverable, and consistent with business requirement and delivered system capabilities
  • Understanding the Organization Chart of Account and Defining the Measures /Dimensions and Hierarchy under different Entity, Product, Customer, geography, Departments.
  • Understanding the source system on DWH, Oracle ERP, EBS (Cash Management, Order Management, iExpenses, HR, GL, Oracle project module to extract data and metadata using Oracle Data integrator.
  • Understanding the Reporting requirement and Creating Prototype to demonstrate the business user to define an optimized Model.
  • Developing Hyperion Planning Web Forms for OPEX and CAPEX data inputs.
  • Developing Web Forms for Standard variance reporting and Data Analysis.
  • Creating Budget upload Hyperion SmartView templates for different business Unit.
  • Creating Revenue Report, Forecast Report, Variance Report, Headcount Report using Hyperion Financial Report.
  • Demonstrating Strong leadership skills and the ability to train, mentor, direct and peer review the work of team members.
  • Installation and configuration of EPM 11.1.2 Oracle Hyperion Planning module including Shared services, Oracle 11G,ODI,DRM, HFM,FDQM,Hyperion Essbase, and Reporting Analysis components.
  • Heavily involved in the Build phase and Conduct training classes to end users training for deployment
  • Responsible for Enterprise Application Integration & back-end data connectivity applications.
  • Implementation of Workforce &CapEx module for Operational /Non-Operational Expenses Calculation.
  • Preparing Support documents (Monthly and Annual Maintenance) for Post Project Go-live and User manuals and Business users Training.
  • Provide guidance to my development team, lead them in configuration efforts, Peer code review, and participate in configuration and unit testing to ensure business requirements are adequately met.

Environment: Database: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential, California, CA

Financial Business System Analyst and Administrator

Responsibilities:

  • Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
  • Understanding the Organization Chart of Account and Defining the Measures /Dimensions and Hierarchy under different Entity, geography, Departments.
  • Understanding the Reporting requirement and Creating Prototype to demonstrate the business user to define an optimized Model.
  • Participated in the installation and configuration of EPM 11.1.2 Oracle Hyperion Planning module including Shared services, Sql Server 2005, Hyperion Essbase, and Reporting Analysis components.
  • Building Multi Currency Hyperion Planning Application, Dimension Building using Outline Load Utility.
  • Developed business Rule for critical Business Requirement like Travel & Expenses, Conference & Training, Salary Calculation, Raisepool Calculation, Social Security Tax, 401K Employer Match Calculation etc.
  • Creating Webforms for Budget Entry and web form reporting.
  • Defining Planning Unit and Workflow for Budget process. Creation of Tasklist, Menu and Smartlist.
  • Creating Load Rule for Data Loading from Oracle system GL Ledger.
  • Implementation of Workforce Planning module
  • Implementation of CapEx module for Depreciation Calculation, Amortization, Retire Assets, Improve Assets etc.
  • Preparing Support documents (Monthly and Annual Maintenance) for Post Project Go-live and User manuals and Business users Training.

Environment: Database: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential, Houston, TX

Business Analyst

Responsibilities:

  • Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development, tests and production environments.
  • Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
  • Maintain Hyperion Servers, create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups.
  • Creating Calculation scripts, MaxL script for process automation.
  • Migration to new production server and supporting end user, planners for budgeting.
  • Daily and weekly back up process as well as Data loading job monitoring.
  • Reporting using Excel add-in, Hyperion Analyzer.
  • Creating Repository for Hyperion Planning Application.
  • Building Planning Application and building metadata using HAL.
  • Loading planning data using planning desktop and smart view client.

Environment: Database: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

  • Communicated with Line of Business and created Business Requirements Document (BRD), High Level Diagram (HLD), and part of Low level Diagram (LLD).
  • Conducted walkthrough for Line of Business, Development team, and Quality Assurance team.
  • Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
  • Analyzed system impacts as a result of proposed changes. It entailed interaction with other systems users and Subject Matter Experts (SME) s.
  • Designed screen layouts for proposed solutions, user interactions.
  • Tracked the project flow and acquired sign-offs from Business, System Development and Quality Analysis team.
  • Created Documentation - Analysis reporting, architectural presentations, infrastructure specifications, strategy planning, risk analysis, contingency plans for company executives.
  • Implemented new policy changes, legal requirements by creating the Business Requirement, Detailed Technical Requirement, User Requirement documents etc.
  • Provided solution for database requirements by designing controls, data fields and data formats. Worked in legacy system migration from Lotus Notes to Oracle.
  • Used different in house software to track data flow, system interactions, system defects, service requests and responses.

Environment: SharePoint, PL/SQL, Quality Center, UML, MS-Project, MS Office Suite.

Hire Now