We provide IT Staff Augmentation Services!

Associate Resume

MD

SUMMARY:

  • Over 12 Years of experience in IT with 8 years of experience in Hyperion Suite of products and 4 years of experience in Testing
  • Over 4 years of team management experience for day to day activities as well as long term resource allocation, cube development, testing, etc.
  • Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, business Process modeling, Project planning and creation of user cases.
  • Experienced in a range of Hyperion products including Oracle PBCS, Smart push, EPM Automate, Oracle/Hyperion System 11x, Essbase Analytics (BSO and ASO), Hyperion System 11x Planning, Hyperion Financial Reporting Web Studio, Web Analysis, Smart View, ODI, Maxl, MDX, Report Scripts, EIS.
  • Strong experience as a Hyperion Essbase and Planning Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
  • Strong Understanding of dense and sparse strategy dimension allocation, calculation scripts, developed, reviewed, and optimized report queries.
  • Analyzed user requirements and involved in the process of finalizing dimensions for Cubes.
  • Extensively involved in designing and modifying the outlines for Essbase and Planning Cubes.
  • Extensive experience in Calculation scripts, Dimension build rules, Data load rules and report scripts.
  • Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
  • Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
  • Experience in HFM applications - metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
  • Experience in interacting with business users at various levels and converting the requirements into technical specifications
  • Excellent technical communication skill, analytical and strong inter-personal skills and good documentation skills. Team player capable of working independently, motivated and quick learner.
  • Performed optimization of the applications for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulas.
  • Optimized outline for calc performance and faster retrieval using optimization techniques such as hour glass structure etc.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Associate

Responsibilities:

  • Participated in workshops with business stakeholders to understand future state processes and the functionality needed to enable it.
  • Documented initial business requirements collected via the workshops and creation of BRD.
  • Created PBCS application and enabled the prebuilt Out Of The Box (OOTB) features and functionality for the Financials, Workforce and Projects business processes.
  • Designed and loaded standard and custom dimensions, Addition of NRC specific chart of accounts into the standard dimensions through Simplified user interface.
  • Created custom budget forms and integrated them into dashboards along with user specific infolets
  • Leveraged the prebuilt Rules for Workforce including the Process Loaded data, Calculate Compensation, Synchronize Defaults and Definition.
  • Created custom forecast process and calculations for 3+9, 6+6 and 9+3 forecasts cycles incorporating actuals and budget data.
  • Developed Data management import formats, location, period mappings, data load rules and data mappings for integrating and importing data from legacy systems into PBCS and drill through functionality.
  • Configured Security using Identity Management and My Services leveraging predefined roles, user & group creation and granting roles.
  • LCM from Test to Prod instances and Snapshot Backups using Migration utility.
  • Build automation of metadata and data load process using Oracle Data Integrator and EPM Automate utility
  • Created of Valid Intersections to restrict unwanted data intersections and have only the required data views.
  • Testing and validation of all the build and documentation, including unit and integration testing.
  • Conducted UAT for periodic review of the build
  • Performed performance tuning and optimization of the application for data load, aggregation and calculations.
  • Design and develop the ELT process (Data Extraction, Loading and Transformation) from source to PBCS using Oracle Data Integrator
  • Developed packages, scenarios using interfaces and variables
  • Created load plans to run the scenarios in a hierarchy of sequential and parallel steps
  • Maintained the on-prem Hyperion Classic planning applications day to day activities, user requests, pefromances tuning, etc.
  • Maintained the ODI load process for both existing and new Planning applications (on-prem and PBCS)
  • Maintained the OBIEE reports and also the load process via ODI. Troubleshoot user related BI tickets
  • Ensured that the user tickets are prioritized and resolved in a timely manner
  • Ensure that the Change Management tickets have clear documentation with well defined processes

Confidential, Dallas, TX

Hyperion Developer/ On site lead

Responsibilities:

  • Planned day to day activities of the Hyperion team as the on-site Team Lead for a team of four working in India and Mexico (24 hours support).
  • Planned and assigned work for the development and test schedule of all enhancements
  • Worked as the on-point lead to respond to any queries or concerns of the client.
  • Administer the ASO and BSO cubes which are used for reporting and making the changes as needed
  • Gathered requirements from the business users Finance team and coordinate with the team to design/ enhance the application based on the business needs
  • Executed and edited nightly batch jobs as required on UNIX Platform
  • Gathered the requirements and determined the time line and effort required in designing the applications.
  • Participated in business requirements for new enhancement & systems development activities.
  • Work with Admin to migrate the Essbase applications for both BSO and ASO including artifacts from the existing production server and maintain metadata and managing data transfers between applications
  • Ensure all development activity is compliant with change control procedures and is rigorously tested
  • Maintenance of the existing developed code/Scripts in the Hyperion environment.
  • Responsible for the management of the development review process for all Hyperion development.
  • Ensure support and development service that meets or exceeds existing SLA’s
  • Ensure that the SLA’s for Service requests and incidents/ defects are met
  • Performance Tuning and optimization, Configuration settings, Dense/Sparse Outline configuration, scripting, Batch scripting.
  • Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
  • Provide a technical support and development service for each of these applications. This will involve gaining a detailed understanding of the application structures, the business processes they support and the requirements of a diverse user base
  • Performed Constant updates to the config files ensuring that the performance is good
  • Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
  • Created and modified the Calc. Scripts and Report Scripts based on the Finance team’s request.
  • Works with internal customers to consistently improve and refine processes and procedures
  • Support for issues based on dimension Build Rules, Data Load Rules, Calc Scripts, MDX scripts, MaxL Scripts and Config Files.
  • Experience ensuring change procedures comply with SOX controls

Confidential, Mechanicsville, VA

Hyperion Administrator/Developer

Responsibilities:

  • Gathered requirements from the business users FP&A team and coordinated with the consultants to design the application based on the business needs
  • After gathering the requirements determined the time line and effort required in designing the applications.
  • Upgraded the Essbase/Planning (Enterprise Performance Management) applications from Version 9.3.1.4 to 11.1.2.1
  • Responsible for creating new planning (Enterprise Performance Management) applications on version 11.1.2.1 for the Budget/Forecasting purpose.
  • Participated/created UAT test scripts during the project implementation
  • Used FDM for mapping and data load into an essbase/planning cube
  • Work with IT/Infrastructure/ Data warehouse teams to determine best plan of action for each implementation.
  • Creation of Standard Operational Procedures, Admin Manuals and Best Practices documents for application administration and maintenance and functional end user support
  • Hyperion Essbase and Planning cubes optimization and best practices implementations in existing applications and calculations (Calc Scripts & Calc Manager).
  • Reconcile data and assure data integrity.
  • Support monthly/quarterly/annual processes for Actuals, Budget and Forecast.
  • Data reconciliations, backups and maintenance of data integrity in all Hyperion applications
  • Used outline load utility to update the metadata in the planning application
  • Used LCM to migrate the Metadata from Environment to another environment
  • Created data forms based on FP&A request and also created Business Rules based on the requirement
  • Created calc scripts and executed them based on data loaded into the application
  • Participated in business requirements for new enhancement & systems development activities
  • Assigning security to Groups and Users, modifying the Essbase Filters based on the Essbase & Planning application business requirements.
  • Modified the allocation of the Business Rules, changed the calculation scripts based on the business needs.
  • Educated the users with the Smart View
  • Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
  • Worked with the internal customers to consistently improve and refine processes.
  • Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
  • Created and modified the Calc. Scripts and Report Scripts

Confidential, Chicago

Hyperion Developer/Administrator

Responsibilities:

  • Involved in documenting the designs and gathering specifications from business users for the development of Actual, Forecast, Budget and Business Plan Cubes.
  • Developed customized cubes according to the business requirements and maintain them for users.
  • Created Data Grids, Data forms and Security file, Process Control using HFM.
  • Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
  • Maintenance of FDMEE - create/update the mappings, validate and export the data into HFM
  • Automation of HFM tasks using task flows from workspace.
  • Created Rules Files for Loading Data.
  • Created Calc Scripts and Optimized Calculations.
  • User Management: Creation, Modification and Deletion of Users.
  • Created Load Rules, Report Scripts based on the business needs.
  • The Actual data feed used to come from Business Objects and troubleshoot any issue related.
  • Involved in writing Maxl Scripts, Calc Scripts, Load Rules and Report scripts.
  • Maintained Users security through Filters depending up on the functional business requirements.
  • Hands on experience in backup and recovery of Database.
  • Created multidimensional cubes using EIS where OLAP Model was created and Meta Outline was designed according to the requirements
  • Performed optimization of the applications for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulas.
  • Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
  • Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
  • Performed backups for the Essbase Applications & other administration activities
  • Automated data load and subsequent aggregations using MaxL and windows batch files.
  • Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
  • Develop reports using Hyperion Financial Reporting Studio.
  • Worked closely with IT and finance/accounting teams to resolve issues, upgrade, develop, test, and implement financial systems.

Confidential, Akron OH

Essbase Developer

Responsibilities:

  • Involved in the full cycle of gathering requirements, defining, designing, developing, testing and deploying the system.
  • Involved in preparing the Design document detailing the data acquisition, business processes, test plans and test cases for unit testing and system integration testing.
  • Supported the third party vendor conducting test processes such as User Acceptance Testing (UAT), system validation testing and performance testing.
  • Worked on performance tuning and optimization of BSO cubes as well as on cube enhancements process.
  • Created users and groups and assigned them different level access and privileges.
  • Redesigned and restructured the existing cubes using Hyperion Analytic Administrative Services.
  • Extensively worked on cube enhancement process which involved discuss, design, and document and add new requirements to existing cube outlines.
  • Optimized Essbase database using optimization techniques like hourglass structure, dense, sparse settings etc.,
  • Automated data load and subsequent aggregations using MaxL and windows batch files.
  • Created Hyperion reports using Hyperion Essbase Excel Spreadsheet Add-In.
  • Developed complex calculation scripts and formulas for the existing BSO cubes to implement the business logic.
  • Completed migration of planning application from one environment to other and developed “How to” Manuals.
  • Designed and developed nightly cycles which automate data loads, Aggregation, and backup of planning applications.
  • Developed Financial reports for the Executive Management Team.

Confidential . Indianapolis, IN

QA Analyst

Responsibilities:

  • Developed QA strategy, wrote Use Cases, UAT Plans and UAT test cases from Business Requirements.
  • Gathered business requirements, studied the application and collected the information from developers.
  • Wrote and implemented effective test plans.
  • Prioritized test scenarios for testing based on time schedules
  • Prepared Status Report, Summary Test Report and Readiness Matrix.
  • Reviewed test assignments, developed test plans and scripts, and conducted tests as assigned.
  • Data-Driven Testing using QTP
  • Utilized Quality Center to develop and execute test cases.
  • Performed Verification Testing and Regression Testing of the application.
  • Executed test scripts for newly developed functionality and reported problems.
  • Wrote Customized functions using QTP
  • Interacting with developers and QA team in fixing schedules for assignments
  • Documented Defects found during test on the TestDirector and communicated recorded problems to the responsible QA or development personnel.
  • Discussed Enhancement and Modification Request issues in various meetings.
  • Involved in weekly inspection meetings, to verify the status of the testing effort and the project as a whole.

Hire Now