We provide IT Staff Augmentation Services!

Senior Hyperion Consultant Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • More TEMPthan 15 years of information technology management experience wif focus as Project Manager for diverse industries, including manufacturing and high - tech environments.
  • Expert in information systems technology, project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning, and tracking of results.
  • Highly knowledgeable in software development, requirements analysis, and database design.
  • Excel at creating and implementing technical and operational plans and strategies.
  • Competent liaison between management, clients, and personnel.
  • Strong communication, presentation, analytical and problem solving skills.
  • Vast knowledge and experience of a broad range of technologies and methodologies dat is applied to global project management and business solutions.
  • Full SDLC (Systems Development Life Cycle), or (Software Development Life Cycle)knowledge and systems infrastructure including inception/scope definition, functional requirements, architecture/design, implementation, change management, testing, requirements matrix analysis, documentation, training, service level agreements, risk and gap analysis, issue resolution management, and roll-out management for small, large and multi-project systems.
  • Strong expertise in teh areas of business analysis, software analysis, business process development, requirements development, requirements analysis, team leadership, systems implementation, systems integration, and development life cycle.
  • Self-motivated wif strong facilitation and communication skills resulting in clear and focused communication between all levels of management, internal/external customers, business stakeholders, steering committee facilitation, and technical teams.
  • Work as teh liaison between teh IT development staff and business users to ensure dat all business needs are correctly defined, documented, and communicated during all phases of teh projects life cycle.
  • Understanding and articulating business requirements from user interviews and converting requirements into technical specifications.
  • Vendor management experience including contract negotiation,
  • Outstanding analytical, organizational, communication and problem solving skills. Masters new systems and technologies very quickly, experience wif design and layout of marketing materials, strong technical writing abilities for project communications, and training and user manuals.

TECHNICAL SKILLS

  • Enterprise Performance Management (EPM) Solutions
  • FM
  • Hyperion Planning ESSBAS
  • FDM
  • SQL
  • Visual Basic
  • ORACLE
  • MySQL
  • MS Access
  • Linux/UNIX
  • Perl
  • HTML
  • Apache
  • FDMEE Data Integration
  • Jython Scripting.

PROFESSIONAL EXPERIENCE

Confidential

Senior Hyperion Consultant

Responsibilities:

  • Responsible for teh Hyperion Essbase and Planning applications and performance optimization.
  • Served as primary leader on teh Hyperion tool kit and its capabilities.
  • Assessed/analyzed current state architecture, provided best practice solutions for identified areas of improvement.
  • Defined application/system roadmap/design document(s) ensuring self-service, flexibility, scalability, and security.
  • Developed architectural standards documents for future design, team-based development, and code release management in teh new architecture in compliance wif corporate development and change management process.
  • Led initial design and scripting activities to adjust teh current model to support new needs and eliminate constraints on flexibility.
  • Aligned Hyperion architecture wif enterprise architecture.
  • Developed and assisted in teh support/maintenance of processes related to teh Hyperion Planning applications and any impacted upstream/downstream processes.
  • Partnered wif teh IT department to understand how Hyperion Planning integrates wif teh supporting data warehouse and BI reporting tool.
  • Hyperion technical lead for teh installation, hardware and environment configuration, and administration of Oracle Essbase and Planning application.
  • Batch Scripting, Performance Tuning, MaxL Scripting, Patching,
  • FDMEE Data Integration, Mapping and troubleshooting, Jython Scripting.
  • Developed and Maintained disaster recovery strategy.
  • Determined and ensured execution of backup and recovery strategy.
  • Ensured execution of archival strategy.
  • Provided technical guidance and mentoring to technical and functional staff.
  • Lead technical resource for reporting projects utilizing Oracle Essbase and Planning applications.
  • Responsible for Performance Tuning and System patch updates for both Oracle Essbase and OS environment.

Confidential

Hyperion Senior Consultant/ Project Lead

Responsibilities:

  • Hyperion Technical Lead for HFM 11.1.2.4 implementation for a 12 Billion Dollars Engineering Services Company.
  • Provided technical direction for a major financial systems upgrade Including infrastructure design, requirements gathering, SOW, development of technical and functional design documents
  • Oversaw teh installation, Configuration and testing of EPM system 11.1.2.4. wif all its required components including HFM Workspace, Shared, Services, ESSBASE, Planning,, FDMEE,DRM
  • Assisted in teh design and development Hyperion Applications and metadata structure
  • Assisted in teh development of HFM and FDMEE applications including metadata, data integration, mapping tables, security and provisioning and financial reports.
  • FDMEE Data Integration, Mapping and troubleshooting, Jython Scripting.
  • Assisted in teh development of admin and user documentations for system and application maintenance, outlining instructions on start/stop EPM services and guidelines on managing applications in teh EPM environment andmaintaining teh HFM rule file.
  • Helped Finance & Accounting in developing SOX compliance processes related to Corporate Accounting and Financial Reporting through teh use of HFM and BI.
  • Coordination wif Finance and IT stakeholders, third party vendors, and consultants.
  • Oversaw teh development of BI Reporting tools and Dashboard Design solutions
  • Jointly responsible wif IT group for ensuring consistent upgrade strategy across Hyperion products, consistent operability and shared vision between Hyperion Planning and HFM users

Confidential

Hyperion Managing Consultant

Responsibilities:

  • Managed support functions for Hyperion environment for one of teh world’ largest medical device manufacturers.
  • Developed applications leveraging Hyperion Planning for budgeting, Planning & forecasting, including Hyperion Workforce Planning, and Capex,
  • Data Relationship Management, and Hyperion Profitability and Cost Management.
  • Managed teh monthly system maintenance process, patch updates, metadata changes, loading financial data, updating business rules/calculations for various Planning Applications
  • Managed Planning related load processes wifin FDM.
  • Managed User Access and Provisioning.
  • Conducted scheduled training classes for new and existing Planning users
  • Oracle Business Intelligence Enterprise Edition, web-based dashboard reporting and analytics in order to deliver teh data necessary for profitable decision making.
  • Managed a staff of 12 Hyperion in-house and offshore resources to ensure sustainability, availability and reliability of company’s financial consolidation, budgeting and reporting systems for company’s multiple divisions worldwide.
  • Directed teh business processes and user support functions wif more TEMPthan 2 dozen Hyperion applications and all related forms, reports, peripheral applications including HFM, FDM, FDMEE, DRM, Planning, ESSBASE and Smart view.
  • Admin and technical support, Application creation and Performance tuning.
  • Server install/patching, ODI debugging. Operations support, ODI, DRM, FDMEE, ESSBASE Calc. Scripts/MDX.
  • Developed/Implemented Disaster recovery strategy.
  • Design and develop HFM and DRM solution. HFM, ESSBASE, Planning, Financial Reporting, SQL server, WebLogic server.
  • Troubleshoot failed production runs and restarting of servers and services.
  • Performance tuning EPM system, HFM, ESSBASE, Planning Applications and servers and resolved end-user application and system/infrastructure issues.
  • Developed/executed plans to improve teh system performance and efficiency.
  • Managed primary support functions for HFM users in solving day-to-day issues.
  • Implemented a System Stabilization and Application Optimization plan dat pulled teh company out of frequent system freezes dat were continuing for over 90 days, saving teh company millions of dollars in downtime and lost revenue.
  • Managed teh monthly server maintenance, performance optimization, Start/Stop services. Tuning and optimization, user security and provisioning, Rules File Editor, HFM Reports.
  • Directed teh issue resolution wif Oracle SR, support/testing during monthly maintenance.
  • Delivered status updates and prepared weekly/bi-weekly status reports.
  • Development of teh enterprise-wide financial system strategy (to drive Hyperion Systems and information requirements and for financial system improvements, and oversight for conversions, patches, and upgrades).
  • Proactively assisted in defining teh direction for future Hyperion initiatives and understand teh downstream impact of system changes.
  • Mentored business teams in year-end system/process analysis, planning/forecasting improvements, and overall financial system direction.
  • Developed and facilitated training activities, globally, and work wif stakeholders to enhance teh application process resulting in a stable production environment, System/data integrity, business validation, follow up and corrective action.

Confidential

Sr. HFM Consultant

Responsibilities:

  • Responsible for providing HFM support and analyzing business processes and requirements by working wif Finance to specify, design, configure, test and support HFM and all related forms, reports, and peripheral applications.
  • Manage primary support functions for HFM users in solving day-today issues.
  • Monitor, identify, resolve and improve Hyperion financial systems’ performance.
  • Research alternatives and recommend business solutions to improve system performance, increase efficiencies and reduce costs.
  • Responsible for Meta Data Changes, Copy Applications, Backup, DR. LCM Utility.
  • Support monthly server maintenance, performance optimization, Start/Stop services. Tuning and optimization, user security and provisioning, Rules File Editor, HFM Reports.
  • Troubleshooting advanced issues wif Oracle SR, support/testing during monthly maintenance.
  • Develop supporting flowcharts, tables, diagrams, formulas and methods for solving business problems, incorporating infrastructure requirements and interfaces.
  • Prepare and update necessary documentation and assist in developing and maintaining system documentation.
  • Support existing and developed new HFM applications including defining metadata (accounts, entities, scenarios, custom dimensions, currencies, consolidation methods, member lists, journals, data forms, intercompany transactions, process management and security, as well as rules development (expressions, functions, variables, sub procedures, conditional / consolidation / elimination rules, string comparisons, sub cubes).
  • Design/build, develop and test data validation, data backup and recovery and provide key administration support for HFM users worldwide.
  • Performed key functions utilizing Financial Data Quality Management (FDM) including FDM Location setup and configuration and FDM Mapping and Validation Rules Development
  • Provide support in configuring client and server hardware, as well as tuning server configurations for optimizing Hyperion performance.
  • Work closely wif business stakeholders to ensure teh application is maintained and satisfy teh finance requirements for monthly Meta Data changes.
  • Identify gaps and alternative solutions wif current configuration and interfaces.
  • Performed Project Management tasks to ensure progress against teh schedule, track project financials, identify and mitigate risks and address any issues.
  • Deliver status updates and prepare weekly and bi-weekly status reports to be reviewed by teh senior leadership and client executives.
  • Perform Day-to-day management/liaison between teh off-shore development and support teams, teh onsite teams and teh client support teams.

Confidential

Sr. Managing Consultant

Responsibilities:

  • Led teh design and development effort for a major power generation client.
  • Led teh Upgrade of Hyperion Enterprise to HFM 11.1.2.1. Designed, Built & Implemented teh HFM application to improve teh consolidation and close process for multiple entities across teh globe. Created HFM applications for teh Cash Flow requirements and teh Fair Value Balance Sheet requirements.
  • Designed teh HFM Cash Flow application to store data by cash flow line item, cash flow id, and data provider/adjustment type.
  • Built teh application to perform automatic intercompany elimination and automatic rounding.
  • Set up Teh HFM Fair Value Balance Sheet application to store data by fair value balance sheet line item, work stream, data provider type, balance type, and business segment.
  • CreatedseparateFDMapplicationsfortheCashFlowrequirementsandtheFairValueBalanceSheetrequirementstoextract, map and load teh People Soft general ledger data into HFM. This extract and submission contains all general ledger accounts for all valid Cash Flow ID’s. Teh application tan imports, processes and loads teh cash flow templates for each Cash Flow
  • Worked as HFM developer on developing financial reports through data consolidation and reconciliation using HFM and Financial Reporting Studio.
  • Teh FDM Fair Value Balance Sheet application extracts maps and loads teh PeopleSoft general ledger data into HFM. This extract and submission contains all general ledger accounts for all valid business Segments. Teh application tan imports, processes and loads teh fair value templates for each fair value work stream.
  • Responsible for developing reporting templates for Balance Sheet and P&L matching previously used data using Hyperion Financial Reports.
  • Solely responsible to develop, implement and test Shared Services security management systems across HFM, Planning, Hyperion Financial Reporting, Web Analysis, and Essbase projects. Used Shared Services for implementing HFM Process Management activities. Also designed and developed FDM security (not involving Shared Services).
  • Responsible for setting FDM security standards and administration of FDM roles across teh company.
  • Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training across subsidiaries.
  • Imported, validated, and exported historical data to HFM using FDM.
  • Applied Hyperion Financial Data Quality Management (FDM) for data importing, validation and exports to HFM applications. Developed FDM maps, setup of HFM and FDM security.
  • Responsible for developing documentation and video tutorials for end-users across subsidiaries around teh world in Hyperion Financial Management, Planning and using Web-Analysis. Interacted wif subsidiaries to design training documents in different languages.
  • Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data.
  • Responsible to architect Hyperion Essbase platform in coordination wif IT to analyze best implementation of Essbase for advanced analyses and to prepare for Hyperion Planning framework.
  • Applied Hyperion Planning 11.1.2 to provide a framework for perpetual planning, managing volatility, reporting on frequent planning cycles involving both short and long term planning.
  • Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
  • Solved several issues involving Hyperion Planning and Essbase interaction at architecture and end-user level based on business, financial and accounting department requirements.
  • Designed interactive Dashboard layout to populate report specific data points for each department wifin teh organization; ensured TEMPeffective synchronization.

Environment: Hyperion Financial Management (HFM) 11.1.2x, Hyperion Financial Reports, Hyperion Web Analysis 11.1.2.x, Workspace, Shared Services, Hyperion Planning 11.1.2, ESSCMD,UNIX,, Calc Script, SQL, Windows NT Essbase.

Confidential

Sr. Consultant

Responsibilities:

  • Different kind of projects includes Project Management, Executive Level Reporting, Supervisory, Financial planning and Analysis, Budgeting, Forecasting, Spreadsheet Modeling, Policies & Procedures, Internal Reporting and Process Improvement
  • Financial & Management & Statutory Reports
  • Reported to teh project manager on teh progress of projects on weekly basis.
  • Implemented new ideas wif teh halp of team members in planning new projects.
  • Managed project budgets as part of global implementation responsible for North America
  • Participated in teh meetings wif clients for ongoing projects.
  • Performed budget/actual analysis and identified and addressed variance issues.
  • Processed and settled inter-company accounting transactions and dealt extensively wif foreign currency issues.
  • Supervised staff, domestic and international, reviewed financial statements, analyzed variances, and compiled monthly income statements.
  • Reviewed capital appropriation request, marketing plans, and expenditures

Confidential

IT Project Manager (Financial Systems)

Responsibilities

  • Managed to complete teh project in given budget and scheduled time
  • Created rapport and maintained TEMPeffective communication wif teh team members and external stakeholders in teh project.
  • Le, mentored and trained teh team members.
  • Prepared and presented weekly reports to teh senior management on teh progress of teh project.
  • Conducted meetings of team members to solve their queries and gave feedback on their performance
  • Identified and implemented schedule and process improvements to significantly reduce time to complete assigned work.
  • Identified process improvement opportunities for Hyperion and Oracle related systems.
  • Partnered wif internal Customers to define requirements and translate into detailed Hyperion project specifications.

Confidential

HFM and SAP Project Manager

Responsibilities:

  • Project Lead for teh implementation of a time tracking system across multiple regions
  • Performed budget/actual analysis and identified and addressed variance issues.
  • Supervised staff, domestic and international, reviewed financial statements, and compiled monthly income statements
  • Consulted management and departmental staff to ascertain and implement researched technology solutions.
  • Provided translation of high-level business needs into business rules, business processes, and business reporting/analysis requirements.
  • Contributed in planning, creating and implementing IT vision and strategy aligned wif teh company’s strategic business plans.
  • Developed projects from initial analysis of business requirements through design, coding, testing, and implementation.
  • Coordinated hardware installation.
  • Trained end users on new systems.
  • Used MS Project to establish teh project schedule and track progress.
  • Led information technology projects through teh project life cycle.
  • Increased revenue wifin one month by leading teh creation and implementation of highly TEMPeffective technology solutions.
  • Evaluated existing technology platform and upgraded to a Y2K compliant platform to meet company’s future growth expectations.
  • Researched and completed comparative analysis to determine specific technology solutions for each client.
  • Aggressively drove issue resolution.
  • Developed and launched community based web sites to promote local businesses.
  • All Implementations were completed on schedule wif high quality

We'd love your feedback!