SKILLS SUMMARY:

• HCP /HRMS
• Expense
• Revenue
• GL
• Actuals
• Forecasting
• SDLC policies and procedures
• SOX (Sarbanes - Oxley Act) Compliance
• SoD (Segregation of Duties)
• COSO Framework
• Essbase
• Planning (Classic, Workforce, EPMA, PSPB, PSCB)
• HFM
• BI Publisher /OBIEE
• HFR & Interactive Reporting, XML /BI Publisher, OBIEE
• Shared Services
• Smart View /Spreadsheet Add-in
• Web Analysis
• User Productivity Kit (UPK)
• ODI
• FDM /FDQM /FDMEE
• DRM
• ERPI Integrator
• Maxl, MDX, ESSCMD, VB/VBA, Batch Scripting

PROFESSIONAL EXPERIENCE SUMMARY:

Confidential

Hyperion Techno-Functional Lead

Environment: Hyperion PSPB Production Techno-Functional Support & Enhancement 11.1.2.4 & 11.1.1.3.x - OMCS (PAAS Cloud)

Responsibilities:

• Designed and Developed Interface framework (FDMEE & ODI) to streamline interface development by following SDLC process
• Led the team in conversion activities to convert manual data and reporting process into automated Hyperion system.
• Streamlined development effort by establishing quality gates and development standards.
• Develop environment strategy to create efficiency in metadata and data migration and project deployment.
• Performed upgradation of Hyperion PSPB from older to newer version and integrated with R12 using ODI and FDMEE
• Comply change management process to any make changes from development to UAT/Test or Production as per SOX compliances

Confidential, FL

Hyperion Financial System Analysts Lead

Environment: Hyperion Production Technical and Functional Support 11.1.2.x

Responsibilities:

• Improved delivery by prioritizing development items.
• Improved efficiency by removing dependencies and delegating work.
• Designed multidimensional Hyperion applications and databases, and aggregation techniques after carefully analyzing customer requirements.
• Worked and set up drill through to relational SQL Server databases.
• Developing repots in OBIEE and Hyperion FR /Financial Reporting.
• Planned and Managed change management and migration process as per Confidential ’s change management process and assign provisions to users per SOD compline

Confidential, IL

Hyperion PSBP Technical Consultant

Environment: Hyperion PSPB development and production support 11.1.2.x

Responsibilities:

• Improved delivery by prioritizing development items.
• Improved efficiency by removing dependencies and delegating work.
• Designed and developed reporting Hyperion cubes and reports using HFR.
• Planned and Managed change management and migration process.
• Provided design recommendations based on long-term IT organization strategy.

Confidential, CA

Hyperion Techno-Functional Lead

Environment: Hyperion PSPB Technical and Functional Production Support, Enhancement and implementation 11.1.2.3 (PAAS Cloud)

Responsibilities:

• Manage technical development for both Hyperion HCM and Budget system enhancements and implementation.
• Design and Develop conversion framework to streamline conversion activities as per SDCL policies and procedures
• Define/implement branding and security requirements across multiple districts.
• Develop and configure custom Hyperion PSPB application for project management and tracking.
• Centralized repository built on Hyperion PSPB to store project requirements, Business process, design specifications, test scripts, knowledge transfer, issue tracking and deliverable tracking.
• Built custom dashboards to provide management with quick overview on the project status.
• Implemented standards to use latest Hyperion PSPB technology for budgeting and forecasting and report development.
• Reports: Standardized report development by using BI publisher and HFR as standard for all reporting requirements.
• Trained resources on latest Hyperion PSPB technology.
• Developed HCP, Actual & Budget data loading process using OLU and FDMEE and ODI from PSoft to Hyperion PSPB application
• Worked with a team of remote system administrators and network engineers to host environments.
• Managed and delivered technical deliverables.
• Developed user and system security per SOD and administrated Hyperion Environments per SOC compliances
• Developed technical and functional documents and training materials as per COSO process

Confidential, CA

Technical Manager

Environment: Hyperion Workforce Planning & ERP 11.1.1.2.1

Responsibilities:

• Improved delivery by prioritizing development items.
• Improved efficiency by removing dependencies and delegating work.
• Improved cost management by controlling over time hours on the team.
• Provided infrastructure planning for support and future phases.
• Planned and Managed change management and migration process.
• Responsible for leading and managing activities of technical on/off-shore Hyperion & ERP team pertaining to the design, development, implementation, administrating and testing of various applications and services e.g. Oracle ERP/EBS, Hyperion EPM/EPMA, ODI, FDQM, DRM, Essbase, Planning, Shared Services /Security management, Workspace, Arriba, CATS, AACG/GRCC, Moneta by providing both technical and functional expertise

Confidential, CT

Hyperion Technical Lead Analyst

Environment: Hyperion EPM Workforce Planning & HFM Support and Enhancement 11.1.1.2.x

Responsibilities:

• Reviewed client business process to gather and document functional requirements and understood dependencies and interrelationships between functional of Hyperion.
• Design, developed/updated, administrated and optimized both new/existing Essbase ASO/BSO and Planning (Classic/Workforce) applications’ cubes, artifacts, calculation/ FR-report scripts business rule, FR/interactive/dash board/web analysis and OBIEE FR /reports.
• Exported and imported budget/P&L and headcount actual data from HFM System into Essbase/workforce Planning for forecasting, budgeting purpose using Hyperion FDQM/FDM.
• Created Development standard document for technical development.
• Provided technical training to development team.
• Performed migration, maintenance and synchronization, manage /update between Prod, and non-prod environments.

Confidential, IL

Hyperion Technical Consultant

Environment: Hyperion Essbase, Planning and Reporting Production Support and Development 11.1.1.3.x

Responsibilities:

• Designed conversion programs to transfer data from Hyperion BSO to ASO and vice versa applications.
• Planned the database strategy and the migration paths between databases cubes.
• Configured the server environments (Application Server, Process scheduler, Web Server).
• Configured Change Assistant for installing patches.
• Wrote new SQL and Application programs for reporting and interface purpose.

Confidential, OH

Hyperion Technical Consultant

Environment: Hyperion EPM Workforce 11.1.1.3

Responsibilities:

• Completely responsible for executing upgrade activities and database activities which includes downloading upgrade template from Oracle websites, creating a job for the upgrade, configuring Application Server, Process Scheduler and application of patches.
• Configured Change Assistant for applying patches and running upgrade steps.
• Ran the compare reports and was also involved with the functional team for keep/drop decisions during compare report analysis.
• Completely responsible for executing UAT.
• Provided training to business users.

Confidential, NY

Hyperion Technical Consultant

Environment: Hyperion 11.1.2.1 Implementation

Responsibilities:

• Completely responsible for executing upgrade activities and database activities which included downloading upgrade template from Oracle website, creating a job for the upgrade, configuring Application server, Process scheduler and application of patches.
• Installed and execute upgrade steps.
• Configured Change Assistant for applying patches.
• Ran the compare reports and was also involved with the functional team for keep/drop decisions during compare report analysis.
• Configured Hyperion report node and default node definitions.
• Configured active directory with shared services which is a third-party system to implement single sign on.
• Prepared functionality documents to be presented to the client

Confidential, FL

Hyperion Technical Consultant

Environment: Hyperion Essbase 6.x

Responsibilities:

• Responsible for data migration from one Essbase application to another application cube.
• Developed Essbase standalone reporting applications.
• Involved in requirement gathering. Responsibilities involved interacting with functional users, understanding their functional needs and providing solutions for the same.
• Prepared mapping document and technical and functional specifications.
• Resolved issues during UAT.
• Retrofitted existing reports and interfaces as per the new environment.

Confidential

Hyperion Technical Consultant

Environment: Hyperion Essbase 7.x

Responsibilities:

• Installed and Upgrade Hyperion Essbase.
• Ran upgrade scripts.
• Generated compare reports to arrive at a decision with respect to retention/removal of existing functionality.
• Developed new functionality as per user requirement.
• Retrofitted existing interfaces and reports.
• Attended user queries and provided solutions for the same.
• Resolved issues during UAT.