SUMMARY

• Certified Hyperion Essbase & OBIEE Consultant with Fifteen years of IT experience, Fourteen years of focus has been on providing solutions, robust system architecture, installation & Configuration, administration of Hyperion System 9\ EPM OBIEE 10g\11g\12c products on a distributed environment on Exalytics and other OS,Windows, Solaris & Linux operating systems with SSO integration, clustering, load balancing, high availability features for commercial clients and Non - clustered distributed environment for Federal Implementation.

TECHNICAL SKILLS

• Oracle Hyperion Essbase
• Hyperion Planning
• Hyperion Shared Services
• Hyperion Financial Reporting
• Tableau
• HFM
• ODI
• FDMEE
• EPM Suite
• OBIEE 10g\11g \12c
• Web logic 10g & 11g\ SQL Server 2000\2008\Windows
• Solaris\ Linux
• Exalytics
• Hadoop
• AWS
• Jenkins and Salesforce.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

EPM & OBIEE Infrastructure \ Solutions Consultant \Devops Engineer

Responsibilities:

• Responsible for migrating several On premise EPM \OBIEE\ODI\SOA\ADF and custom applications to Amazon web services (AWS) Cloud.
• Extensive hands on experience in designing, building and automating cloud infrastructures on Amazon Web Services.
• Responsible for building Amazon EC2 cloud instances with S3, VPC, RDS, Elastic Load Balancing, Autoscaling, IAM, SQS, security groups, Lambda, Cloud Watch and other AWS services.
• Configured CI/CD tools Jenkins, Maven, Ant, and GitHub repository for the continuous smooth build process (OBIEE RPD deployments (11g & 12c)\ EPM LCM artifacts.
• Enabled SSL/TLS certificate installation/configuration for EPM & OBIEE Suite \SOA/ODI/DRM & HFM .
• Managing various Amazon web services (AWS) cloud systems, automated the build to deploy through Jenkins ( DEVOPS).
• Responsible for setting up Pipeline for rehydration
• Used Jenkins build node need to run all security scans.
• Implemented and managed continuous delivery systems and methodologies on AWS
• Understand, implement, and automate security controls, governance processes, and compliance validation
• Defined and deployed monitoring, metrics, and logging systems on AWS
• Implemented systems that are highly available, scalable, and self-healing on the AWS platform

Confidential, Roswell, GA

BI Cloud Integration Consultant

Responsibilities:

• Worked on Salesforce Cloud integration with OBIEE 12c.
• Worked on Cloud based solution for invoking transformations and jobs remotely.
• Responsible for Data loads using Data N cloud based service.
• Responsible for building operations to pull the source data, apply the transformation logic.
• Worked on translations to push the data to the target systems, discover and load Data.
• Responsible for Daily Data loads Monitoring.
• Worked on Change request and tickets to support the entity update process.
• Worked on backups, data loads and scheduling of batch jobs and system testing of the cloud platforms.
• Conducted POC on Hadoop.

Confidential

EPM & OBIEE Architect \Infrastructure Consultant

Responsibilities:

• Gathered the requirements, evaluated and provided the Hardware & Hyperion EPM 11.1.2.3 Stack Specifications.
• Responsible for architecture layout design and deployment of the EPM Suite for Confidential Financial Applications
• Responsible for Installation & configuration of the EPM Suite on Various Distributed high available clustered environments (Exalytics, Linux\Solaris and Windows).Worked on setting up the Excel add in\Smart view issues.
• Installed and Configured FDMEE & DRM CSS Mode,API Adaptors.
• Worked on User Provisioning for EPM Suite (Hyperion Essbase, Planning, Financial Reporting, FDMEE).
• Worked on Configuring EBS Source system and EPM Target applications.
• Provisioned the EPM Security for Essbase, Planning, HFR & FDMEE.
• Responsible for data loading and Entity update process, worked on backups, data loads and scheduling of batch jobs.
• Responsible for building the OBIEE environments, Applied custom styles to improve look and feel of OBIEE Dashboards user interface, enforced Data and object level security based on applications roles assigned to the users in active directory group.
• Worked on BSO & ASO Cubes optimization, performed Fine Tuning of both EPM & OBIEE Stack.
• Responsible for configuring DRM web services, hierarchy issue resolution.
• Responsible for maintaining the overall health of the engineered systems.

Confidential

EPM & OBIEE Infrastructure Consultant

Responsibilities:

• Gathered the requirements evaluated and provided the Hardware & OBIEE 11g (11.1.1.6.8 ) Specifications.
• Responsible for Architecture layout \design and deployment of the OBIEE 11g for the clients HRMS Payroll Management.
• Upgraded OBIEE 10g-11g on Linux environment.
• Migrated the code (RPD & Catalog).
• Worked on UI Customizations.
• Worked on Security setup for OBIEE & BI Publisher Reports.
• Resolved the post upgrade security issues.
• Worked on Performance Tuning of EPM & OBIEE Suite.
• Responsible for patching the environment to resolve the EPM & OBIEE component bug fixes.

Confidential, Atlanta, GA

EPM & OBIEE Architect \Infrastructure Consultant

Responsibilities:

• Gathered requirements for OBIEE11g Oracle EBS Integration
• Worked on OBIEE11g Security setup in the distributed environment.
• Worked on OBIEE 11g security issues.
• Reviewed the Hyperion ODI10g environment.
• Evaluated & Prepared the ODI environment for upgrade from (10.1.3.5 to 11.1.1.6).
• Performed ODI pre & post upgrade Tasks.
• Used ODI Upgrade assistant Tool for ODI 10g Repositories upgrade(Master & Work \KM Modules)
• Updated the ODI agent configurations, post Upgrade, reviewed the Upgrade Assistant (UA Logs).
• Worked on migration of the EPM artifacts across the distributed environments using (LCM) utility.
• Worked on Performance Tuning of EPM & OBIEE Suite.
• Responsible for patching the environment to resolve the EPM& OBIEE component bug fixes.

Confidential

EPM Architect \ Infrastructure Consultant

Responsibilities:

• Gathered the requirements evaluated and provided the Hardware & EPM 11.1.2.2 Stack Specifications.
• Responsible for architecture layout designed and deployed the EPM Components HPCM for the clients Financial Management to manage their Direct and Indirect costs.
• Installed & configured the EPM system with HPCM on Distributed environment.
• Worked on setting up the Excel add in\Smartview issues.
• Integrated various sources systems with EPM & HPCM Systems.
• Installed and Configured ODI & FDQM Adaptors.
• Worked on provisioning the security through EPM Shared services for Essbase \FR Reports.
• Migrated artifacts across the distributed environment.
• Responsible for data loading and Entity update (monthly) and Quarterly Update process.
• Worked on Performance Tuning of EPM & OBIEE Suite.
• Responsible for patching the environment to resolve the EPM& OBIEE component bug fixes.

Confidential

EPM & OBIEE Architect

Responsibilities:

• Installed and configured Hyperion EPM Suite (11.1.1.3 & 11.1.1.2.1 )\ Hyperion System 9 and OBIEE Products on a distributed high availability environment to support their complex Financial applications for budgeting that are flexible enough to adopt the sudden change in the business life cycle.
• Responsible for setting up the Excel add in\Smartview \HFM\HFR & resolved issues as per the CMIS tickets.
• Assisted end users with Excel add in\Smartview issues.
• Used LCM Migration utility to migrate the artifacts and security across the distributed environment.
• Worked on provisioning the security through EPM Shared services for Essbase \FR Reports.
• Responsible for EPM DRM Web Services Configuration.
• Installed & Configured OBIEE 11g on Distributed Environment, configured the SSO (CA site minder).
• Worked on Code Migrations (RPD & Catalog) and UI Customizations.
• Worked on Performance Tuning of EPM & OBIEE Suite.
• Responsible for server patching the environment to resolve the EPM& OBIEE component bug fixes.

Confidential

EPM & OBIEE Support Lead

Responsibilities:

• Worked on EPMA Pension application to support the global pension plan and DRM Entity Update Process.
• Involved in the monthly (SII\Operational plan) and quarterly Finance close and HFM reconciliation process.
• Involved in Server Patching monthly recycling of the Hyperion Services.
• Installed & Configured OBIEE 11.1.1.5 on distributed & clustered Linux environment.
• Responsible for the Architecture layout of OBIEE solution to analyze multiple client reporting needs.
• Responsible for setting up the Framework agent archived the reports and scheduled the cronjobs to send the archive reports.
• Converted BSO cubes into ASO and provided regular support for ASO applications like hierarchy changes and data loads, Optimized BSO & ASO Cubes for better performance.
• Worked on Performance Tuning of EPM & OBIEE Suite.

Confidential, Woodland Hills, CA

Hyperion Support Lead\Senior Hyperion Administrator

Responsibilities:

• Worked on Forecast system close and open for the rollover forecast system (3+9, 9+3and 6+6 Forecasting).
• Developed numerous simple to complex Business Rules and attached them to the web forms.
• Used version copy to take the backup of the current version once budgeting is finalized.
• Responsible for Administration of the Planning applications and DRM Hierarchies for the Entity Update Process.
• Optimized applications/ Business Rules for optimal performance.
• Created User Security system and also test plans to test the security system.
• Involved in monthly financial close and quarterly forecast reporting and HFM Entity update process.
• Responsible for Providing the Quarterly SOX Audit HFM and Allocation Security Reports.
• Worked on Hyperion Financial Reporting import and export of FR Reports and provisioned security.
• Worked on the upgrade project System 9 to EPM 11.1.1.3.

Confidential, Pittsburg, PA

Hyperion Support Lead

Responsibilities:

• Worked on Migration of the application from 9.2.1 to system 9.3.1.
• Installed and configured Hyperion Essbase 9.3.1 products in Development and Production Environment.
• Maintained security with Shared services for financial reports, Essbase and Planning and created new groups and applied filters at different levels provided SOX Audit reports.
• Responsible for the Daily management of the Hyperion Distributed environment.
• Automated scripts for back up and Refresh of all Production Cubes during recovery.
• Applied Server Patching monthly recycling of the Hyperion Services.
• Involved in Production support monitoring jobs\fixed the failures in a timely manner.

Confidential, Beaverton, OR

Senior Hyperion Essbase & Planning Developer\Administrator

Responsibilities:

• Created web\Data forms for Planning.
• Loaded data and metadata from flat files through Hyperion Application Link to the Planning application using planning, flat file, and other adapters
• Responsible for maintaining the rollover forecast planning system.

Confidential

Senior Hyperion Essbase Administrator

Responsibilities:

• Involved in gathering requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool.
• Responsible for maintenance of batch scripts, scheduling runs, developing report scripts, load rules and calculation scripts.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Implemented robust data-access security and user management.
• Involved in optimization of Essbase Server Settings for better Performance.
• Retrieved reports using Excel add-in and generate reports out of batch in Hyperion Reports.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Responsible in supporting users and maintenance of cubes.
• Involved in migration of Analyzer reports from one environment to another environment.
• Worked as part of the support team to handle vendor support calls.
• Involved in customization of the existing IM/POSO modules as per the client’s business requirements.