SUMMARY:

• 7+years of Diverse experience in Information Technology and Finance with Emphasis on Enterprise Performance Management (EPM), Business Intelligence(OBIEE),Finance& OLAP tools.
• Expertise in Design, Analysis, Architecture, Development, Implementation of EPM & OBIEE Environment.
• Performed several Administrative tasks likeInstalling and configuring of Hyperion Essbase,EAS, Hyperion Planning, Hyperion Shared Services, and Hyperion Financial management, DRM, Hyperion Reporting and Hyperion Workspace, OBIEE on client and servers(Windows and Unix) machines.
• Expertise in Applying patches to different EPM & OBIEE Environments.
• Expertise in providing Security for Essbase, Planning, HFM and FDM, OBIEE applications.
• Created user and group profiles for assigning proper privileges using both User provisioning, Native security and Shared services modes.
• Experience in automation, optimization and performance tuning of different Hyperion& OBIEE applications.
• Migrated Different Essbase, planning Applications and Reports between different environments in EPM & OBIEE.
• Designed and developed numerous Essbase applications with excellent balance in dense and sparse dimensions, various OLAP models and meta - outlines across Block/Aggregate storage and Partitioning.
• Expertise in dynamically building Dimensions, Attributes using rule files and loading Fact data in an Essbase Applications by means of several build methods such as generation, level and parent-child references.
• Expertise in developing BATCH scripts using windows batch scripting and UNIX shell scripting as well to automate data load in Essbase cubes.
• Expertise in developing calculation scripts, member formulae, report scripts
• Good Knowledge ofCreating and Registering HFM Applications.
• Expertise in loading data& consolidating.
• Expertise in building Financial budgeting and Forecasting OLAP Applications with Hyperion Planning using forms, business rules, menus, plans, and application migration as well as application management and troubleshooting.
• Highly Skilled in developing and debugging Business Rules (Especially for Maintenance and Manipulation).
• Worked on Vignette,HAL andODI for metadata loading into Hyperion Applications.
• Worked on Different ODI Technologies, Topology, Models.
• Created Different Packages and Procedures.
• Created customized Reports using different tools like Hyperion Interactive and Financial Reporting studios based on the requirements of the clients.
• Worked on HFM and FDM Applications.
• Expert in Developing BI publisher reports.
• Developed OBIEE Dashboards, Reports, Analysis.
• Expert in performing Administrative Tasks related to OBIEE.
• SSL Certificates updates on Production and Test EPM &OBIEE Servers.
• SFTP and FTP account setup between servers.
• Troubleshoot critical issues in timely manner to ensure established SLAs are met.
• Support month-end, quarter-end and year-end activities within the EPM environment.
• Provided technical assistance and support to end-users.
• Ability to listen and work as a team player.
• Familiar with creating queries, tables, Stored Procedures, relational references and maintaining the referential and data integrity in SQL.
• Proficient in gathering end user’s requirements and documentation.
• Ability to work individually or in team environment.

TECHNICAL SKILLS:

Tools: Enterprise Performance Management (EPM)(11x/9x), Business Intelligence(OBIEE)(12c/11x/9x), Hyperion Essbase, Hyperion Planning,Hyperion Workspace, Hyperion Shared Services, Essbase Administrative Services(EAS), Essbase Integration Services (EIS), Hyperion Financial Management, Financial Data Management, Data Relationship, management, ESSCMD, Oracle Data Integrator, HAL, SSL, Task scheduler, Event Viewer

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Interactive reporting studio, Hyperion Smart view, Brio, Hyperion Essbase Excel AddIn, OBIEE

Programming Languages: SQL, PL/SQL

Operating Systems: Windows 95/98/2000/NT/XP/2008/2008 R2/2012 UNIX, LINUX.

Oracle 12c,11g/10g/9i, MS: Access, SQL Server.

Microsoft: Internet Information Services, Excel, Word, Access, Power point.NET Framework

Web Server: Oracle WebLogic server(10X/12X), Oracle http server

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Responsibilities:

• Provided technical programming and application administration for different tools and technologies. This includes the regular loading of data a sets, application administration and, process documentation, training, and compliance.
• Involved in Center of Excellence Team that provides support for Different Hyperion planning applications related to People cost, Manufacturing and Engineering.
• Monitor overall Hyperion planning applications and functionality and ensure consistent uptime and stability of Applications.
• Processing and tracking metadata changes in Hyperion planning application using Data Relationship management(DRM).
• Updating Member properties in DRM and push all changes to Hyperion planning.
• Performed all Regular and Complex administrative activities including maintain shared service security authentication via Native and LDAP.
• Develop and maintain an understanding of data sources and data outputs
• Promote Application changes from Dev to QA to Production
• Created Forms for planning applications for users to load data and extract the data.
• Provided member level security in planning applications.
• Created different packages to migrate and Tie the data between different applications.
• Update and document changes to Business Rules and Calculation scripts in Hyperion calculation Manager, Forms, and Reports in workspace
• Creation and maintenance of Hyperion Financial Reporting reports, Smart view reports, and ad-hoc reporting
• Maintain controlled processes for loading and validation of data.
• Loading Data into Hyperion planning applications using Financial data quality management(FDMEE) and updating .
• Update and Maintenance of mapping logic in Financial Data Quality Management (FDMEE) to fix loading issue.
• Supported month-end, quarter-end and year-end activities within the EPM environment
• New Security user groups set-up and periodic review of existing users’ security rights.
• Work with the IT group/hosting provider to support system, servers, upgrades and patches.
• Work with Developers, System and Network Administrators to support and Improve performance and stability.
• Created users, groups, filters and assigned different kinds of Security access to users for all Hyperion applications using Hyperion shared services.
• Creation and implementation of process improvements which includes testing, validating and documenting change process.
• Provide training sessions and documentation for all end users of the Corporate Planning system
• Adherence to tight close and reporting schedules
• Work with Developers, System and Network Administrators to support and Improve performance and stability.
• Perform Testing of planning Applications and reports.
• Perform EPM planning application Administration such as security, tuning.
• Involved in production support and maintenance of existing cubes.
• Performed all tasks for Go live and fixed all Issues.
• Worked with Different teams to get the Application stable.
• Performed root cause analysis to identify permanent resolutions to software or business process issues.
• Developed methods and processes for seamless integration of different products.
• Provided technical specifications for application enhancements.
• Participated in application customizations and extensions.
• Anticipated long term support issues and plans for corrective actions.
• Performed cross training.
• Supported special projects.
• Assisted with other projects as may be required to contribute to efficiency and effectiveness of the work.
• Investigated and Responded to team helpdesk requests for managed applications
• Performed data validation and tie-out procedures.
• Partnered with team Business Analysts to program hierarchy and statistic updates.
• Ensured meta-data consistency between Systems tools.
• Provided technical assistance and support to end-users.
• Created different packages to migrate and Tie the data between different applications.
• Helped users with Smart View Queries and Macros.
• Responsible for documentation on all Hyperion, processes for all business groups and technical team.
• Engaged stakeholders to clarify and finalize requirements.
• Support business readiness for upcoming changes.
• Ensure backlog is visible, accurate and updated in timely manner.
• Involved in various aspects of software development lifecycle including requirements capture, design, implementation testing, installation and support. converted project specifications, using flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved. provided support to users located all over the globe

Environment: EPM (11.1.2.4), Essbase (11.1.2.4), Planning (11.1.2.4), Financial Reporting Studio (11.1.2.4), Essbase Administrative Services (11.1.2.4) Workspace (11.1.2.4), Shared Services (11.1.2.4), Smart View 11.1.2.5.602 , Financial Data Quality Management(FDMEE 11.1.2.4),Data Relationship management(DRM)

Confidential, Ann Arbor, MI

Responsibilities:

• Performed several Administrative Tasks like Installing and configuring, Migration, Patches, Upgrades to different EPM & OBIEE Environments.
• Monitored overall system health and functionality and ensure consistent uptime and stability of Oracle EPM and OBIEE environments.
• Worked with Developers, System and Network Administrators to support and Improved performance and stability.
• Resolved issues with Hyperion & OBIEE infrastructure and increased system performance.
• Performed Testing of All EPM & OBIEE Applications and reports.
• Performed EPM & OBIEE application Administration such as security, tuning, backup and recovery.
• Responsible for maintaining all Hyperion&OBIEE Servicesin all Servers.
• Involved in production support and maintenance of existing cubes.
• Provided technical programming and application administration for different tools and technologies. This includes the regular loading of data a sets, application administration and upgrades, process documentation, training, and compliance.
• Performed performance tuning, and monitoring of all system tiers.
• Monitored OBIEE & EPM applications environment to identify and recommend alternatives/enhancements.
• Applied WebLogic patches.
• SSL setup and Certificate updates on Production and Test servers for EPM Environment.
• SSL setup and Certificate updates on Production and Test servers for OBIEE Environment.
• Installed EAS, Financial reports Client for Users.
• Worked on Vulnerabilities related to applications.
• Created an Architecture Plan for EPM 11.1.2.4 Environment.
• Installed and configured EPM 11.1.2.4 Environment.
• Performed security setup of EPM with MSAD and LDAP.
• MigratedEssbase, Financial Reports from EPM 11.1.2.3 to 11.1.2.4.
• Migrated Security between different Environments.
• Performed all tasks for Go live and fixed all Issues.
• Installed and configured ODI 12.2.1 Environment.
• Migrated Repositories from 11g to 12.2.1 Environment
• Fixed all repository, topology, Projects, Architecture issues for ODI after migration.
• Created an Architecture Plan for OBIEE 12.2.1.2 Environment.
• Installed and configured OBIEE 12.2.1.2 Environment.
• Setup of singleton Data Directory.
• Security Configuration and server configuration of OBIEE.
• OBIEE Services Automation.
• Migrated OBIEE application from 11g to 12c.
• Disaster Recovery and Backup plan for OBIEE Environment.
• Performed performance Tuning of OBIEE Environment after setup.
• Performed all tasks for Go live and fixed all Issues.
• Worked with Different teams to get the Servers ready for New Environments.
• Updated Oracle Clients on different servers with the help of Database team.
• Performed root cause analysis to identify permanent resolutions to software or business process issues.
• Perform log analysis and best practices for backup/restore disaster recovery.
• Migrated deployed Essbase, planning between DEV/ UAT and production via LCM and classic methods.
• Developed methods and processes for seamless integration of different products.
• Provided technical specifications for application enhancements.
• Participated in application customizations and extensions.
• Conducted Research and made recommendations on Oracle Hyperion products, tools, services, protocols, and standards in support of procurement and development efforts.
• Collaborated with team members to recommend new or improved.
• EPM/Hyperion/OBIEE solutions and development processes.
• Anticipated long term support issues and plans for corrective actions.
• Defined system documentation.
• Performed cross training.
• Supported special projects.
• Assisted with other projects as may be required to contribute to efficiency and effectiveness of the work.
• Continuous process improvement.
• Automation, optimization and performance tuning of different Hyperion applications.
• Investigated and Responded to team helpdesk requests for managed applications
• Performed all Regular and Complex administrative activities including maintain shared service security authentication via Native and LDAP.
• Created users, groups, filters and assigned different kinds of Security access to users for all Hyperion applications using Hyperion shared services.
• Supported month-end, quarter-end and year-end activities within the EPM/OBIEE environment.
• Performed data validation and tie-out procedures.
• Partnered with team Business Analysts to program hierarchy and statistic updates.
• Ensured meta-data consistency between Systems tools.
• Provided technical assistance and support to end-users.
• Managed data and dimension loads to EPM/OBIEE applications.
• Designed and developed numerous Essbase applications with excellent balance in dense and sparse dimensions, various OLAP models and meta-outlines across Block/Aggregate storage and Partitioning.
• Loaded Fact data in an Essbase Applications by means of several build methods such as generation, level and parent-child references.
• Developed BATCH scripts using windows batch scripting and UNIX shell scripting as well to automate data load in Essbase cubes.
• Developed Report Scripts dynamically.
• Created planning application and Loaded data into applications.
• Created Forms for planning applications for users to load data and extract the data.
• Imported and exported Dimensions for planning applications.
• Provided member level security in planning applications.
• Created different packages to migrate and Tie the data between different applications.
• Created and customized Reports using different tools like Hyperion Interactive and Financial Reporting studios based on the requirements of the clients.
• Setup EPM automation for cloud Environment
• Basic concepts of PBCS like loading users, Logging and checking user forms through Smart View etc..
• Attended Tableau training.
• Helped users with Smart View Queries and Macros.
• Worked on Different ODI Technologies, Topology, Models.
• Created Reports using different tools like Hyperion Financial Reporting studios based on the requirements
• Developed Hierarchy in Essbase Studio and Deployed the Applications in EAS.
• Applied Patches to OBIEE Environments.
• Developed and Analyzed Reports in OBIEE.
• Performed Administrative tasks like Updating, BackUp and of OBIEE Environments.
• Helped users with OBIEE Analysis and documented for Updating the subject areas.
• Worked on Essbase and OBIEE Integration.
• Tested OBIEE Reports and updated the reports and migrated them.
• Developed BI publisher reports.
• Responsible for documentation on all Hyperion, OBIEE processes for all business groups and technical team.

Environment: EPM (11.1.2.3,11.1.2.4), Essbase (11.1.2.3,11.1.2.4), Planning (11.1.2.3,11.1.2.4), Financial Reporting Studio (11.1.2.3,11.1.2.4), Essbase Administrative Services (11.1.2.3,11.1.2.4), Web Logic (10.3.6,10.3.5,12.2.1), Workspace (11.1.2.3,11.1.2.4), Shared Services (11.1.2.3,11.1.2.4), Smart View 11.1.2.5, OBIEE 12.2.1.2, OBIEE 11.1.1.7, OBIEE 11.1.1.6,Oracle BI publisher, Oracle Database 11g/12c.

Confidential, Saint Louis, MO

Responsibilities:

• Involved in production support and maintenance of existing cubes.
• Involved in the duties of Administrator in resolving issues using ticketing system.
• Involved in migration of Essbase, planning and reporting objects in between all Hyperion environments and troubleshooting the issues after migration.
• Created users, groups, filters and assigned different kinds of Security access to users for all Hyperion applications using Hyperion shared services.
• Provided user provisioning by configuring user active directories to Shared services and creating groups, assigning roles.
• Worked on different Hyperion issues reported by users.
• Responsible for monitoring Application performance and tuning.
• Extensively worked on performance tuning of BSO and ASO applications.
• Expertise in dynamically building Dimensions, Attributes using rule files and loading Fact data in an Essbase Applications by means of several build methods such as generation, level and parent-child references.
• Worked on Financial budgeting and Forecasting OLAP Applications with Hyperion Planning using forms, business rules, menus, plans.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and Adhoc reports using Smartview.
• Responsible for updating with new resolved issues for future reference.
• Responsible for documentation on all Hyperion processes for all business groups and technical team.

Confidential, Schaumburg, IL

Responsibilities:

• Involved in Installation and configuration of Essbase, planning, EAS, Financial Reporting Studio, FDQM, DRM, Shared service and Workspace, Web logic, Interactive reporting.IR web client and Smart view.
• Troubleshooting issues for Hyperion EPM Servers and clients After installation and configuration
• Responsible for maintaining all the Hyperion Services in all Servers.
• Created and registered Planning, Essbase and HFM application in Hyperion Workspace.
• Responsible for implementing LCM Utility to migrate application artifacts between different Environments.
• Involved in setting FTP and SFTP accounts between different servers.
• Worked on Cygwin to set up different Admin accounts for servers.
• SSL Certificates updates on Servers.
• Involved in trouble shooting the issues after migration of ODI.
• Responsible for monitoring of Application performance and tuning.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning applications using Hyperion shared services.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Worked on setting Oracle Data Integrator (ODI) interfaces for metadata load into Planning Applications.
• Worked on various SHELL scripts for cube builds and data extracts as a part of Automation.
• All Administrative tasks. worked with different teams to perform upgrades.

Confidential, Libertyville, IL

Responsibilities:

• Created and registered Planning, Essbase and HFM application in Hyperion Workspace.
• Expertise in loading data into Essbase, planning and HFM application.
• Responsible for maintaining all the Hyperion Services in all Servers
• Involved in production support and maintenance of existing cubes.
• Worked on Hyperion Shared Services for maintaining security to Essbase, Planning and HSF applications.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Involved in Materialization and Query Tracking That helps to Reduce the Retrieval time of Application
• Expertise in Developing and Deploying Cubes using various dimension build and data load methods, automation of data loads using MAXL batch scripts.
• Copied HFM application Between Production and Test Environment.
• Configured Data Sources through Hyperion Configuration Utility.
• Worked on Retrieval time and Zoom in options of Essbase.
• Involved in the development of CALC scripts, rules files for loading budget and actual data to the Essbase cube.
• Worked with Vignette and HAL Tools for loading metadata into planning application.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and Adhoc reports using Smart View.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• SSL Certificates updates on Production and Test Servers.