Shiva Reddy Sareddy

Mobile: +1-737-***-****

adxbw9@r.postjobfree.com

Linked in: Shiva's Linked In

Experience Summary

Having total 14+ years of experience in Information technology. Over 12+ years of experience in

Oracle Hyperion EPM suite products Administration, Development, Support, Maintenance, upgrade in on perm and cloud environments.

Over 2+ years of experience in Windows/Linux/MSSQL Administration and networking experience on TCP/IP, HTTP/ HTTPS, SSH, SMTP, SFTP, DNS, DHCP, firewall, etc…

Extensively worked on Oracle Hyperion EPM suite 11.1.1.X, 11.1.2.X, and 11.2.X versions and Hyperion ESSBASE, planning, HFM, FDQM/FDMEE, FCM, FR, DRM, ODI, and OBIEE components administration, design, development, upgrade, and support projects.

Create and Maintain Metadata of Planning applications, Consolidation applications, Essbase applications in on perm and cloud environment.

Performance tuning at application level and infrastructure level for Oracle EPM Suite of products such as Hyperion ESSBASE, planning, HFM, FDQM/FDMEE, FCM, FR, DRM, ODI, and OBIEE.

Strong Understanding of Banking financial and Accounting, Month/Year end close, adjustments, journal entries, management and statutory reporting requirements and functional users’ perception of the data loaded into Oracle EPM suite.

Working experience of developing reports using Hyperion Financial Reports, and strong knowledge in Excel Add-in, and Smart view.

Extensive knowledge of Service Now ticketing tool, resolving incidents, implementing changes, responding to production incidents on time, and meeting the SLA.

Experience working business on resolving any data issues like out of balance in consolidation reports and any data discrepancies in Essbase and Planning applications.

Well experienced in multi-tier Installation, configuration, patching, performance tuning and upgrade of Hyperion products on Windows and Linux operating systems platforms.

Well experienced in multi-tier application Horizontal and vertical cluster and High Availability setup with Round Robin based http or https load balancer.

Setup and deploy Hyperion and other multi-tier application on AWS cloud using Terraform, Jenkins, EC2, RDS, S3, ALB, Route 53, EBS, Lambda, SNS, Cloud watch and other AWS services.

Rehydrate (destroy and recreate) all AWS Hyperion and other application severs when new AWS AMI releases.

Code changes and deployments and security patches automation using GitHub, Jenkins and One Pipeline.

Weblogic, OHS, Java, Coherence, Hyperion security and bug fix patching vulnerability remediation.

Hyperion Planning application migration from On-premise to EPBCS.

Automated EPBCS tasks like metadata load, clear data, data load, backup application, import export files between On-premise and EPBCS, etc… using epmautomate and shell scripting.

Planning application artifacts, security and data migration through LCM and L0 export and import.

ESSBASE application defragmentation automation using MAXL and shell scripting.

HFM metadata update, FR report changes, FDMEE period mapping update, dataload monitoring and troubleshot on failures.

ESSBASE and Planning daily loads daily metadata and data load monitoring and troubleshot on failures or rejects.

Planning, ESSBASE, HFM, FDMEE, FR, DRM Applications artifacts and data backup automation using LCM Utility, batch and shell scripts.

Disaster recovery environment setup for Planning, ESSBASE, HFM, FDMEE, FR, DRM Applications and perform DR drill / exercise quarterly of half yearly based on business requirement.

HFM applications migration one environment another environment using copy application utility and schema backup and restore.

Application services recycle/maintenance automation through Jenkins/Batch/Shell with pre/post validation checks.

Well experienced in managing Application changes, incidents, requests & problem records through ITIL based tools like Service Now, CA SDM, IBM IT service desk, etc.…

Setup application url monitors using Jenkins, Shell and PowerShell scripts.

Well experienced in Batch, Shell, PowerShell, VB, Python & etc… scripting languages.

Having good experience with Oracle & MSSQL databases (Creating DB/schema users, Assign roles to DB/ schema users).

Windows/Linux administration like Active directory, DNS, DHCP, TCP/IP, LAN, WAN Public/Private networking, Clustering, MSSQA, MySQL, etc…

Services recovery and Errors salvation by referring application logs, event viewer logs and error codes.

Technical Summary

Skills: Hyperion Administrator, Hyperion Planning, Hyperion Essbase, Hyperion Finance Management, Hyperion Calculation Manager, Hyperion Shared services, Hyperion Financial Reporting, FDMEE, ODI, Hyperion DRM, Smartview, EPBCS, EPM Automate, Data Management, Weblogic, CA7 ESP, Control - M, Jenkins, Windows server administration, Linux server (RHEL, OEL, CentOs, Ubuntu, etc.. ) administration.

Cloud and DevOps Skills: AWS, Jenkins, Git, Jira, Service now, Terraform, etc…

Languages: Batch, Bash, Shell, Power Shell, Python, SQL, MAXL and VB

Professional Experience

Client: Capital One Financial

Location: Richmond,VA

Role: Senior Hyperion Infra Consultant AWS Engineer Jan 2023 – Till date

Roles and Responsibilities:

Extensively involved in gathering business requirements during business meetings and translating them into project technical requirements.

Hyperion Planning and consolidation applications Administration, Design, Development, Testing, Implementation, Support, Maintenance of various complex workflows and process in production and lower environments.

Business process automation on multiple platform (On Premises and cloud) and multi operating system environments (Linux and Windows) using Automic automation tool and different scripting language: batch, Shell, PowerShell, SQL, MAXL, etc…

Rehydrate (Destroy and provision EC2 instances) Hyperion application (Windows) DEV/QA/PROD ENVs every month.

Rehydrate (Destroy and provision EC2 instances) Mortgage application (Linux) DEV/QA/PROD ENVs every month.

AWS services (EC2, RDS, S3, Lambda, SNS, Cloud watch, etc...) vulnerability fixes and remediation.

Shell, Power Shell, Python code fixes, enhancements and deployment.

Commit code changes to Git repository apply changes to Hyperion and weblogic applications through Jenkins pipeline.

Automated Hyperion patch upgrade process every quarter.

Automated applying Weblogic, OHS and java quarterly security patches.

HFM application migration from PROD to QA.

Perform half yearly DR test for Hyperion and mortgage applications from AWS east to west and west to east regions.

Perform month end close activities like HFM metadata update, FR reports changes, HFM metadata update, FR report changes, FDMEE period mapping update, data load monitoring and troubleshot on failures.

ESSBASE and Planning daily loads daily metadata and data load monitoring and troubleshot on failures or rejects.

Arrow jobs monitoring troubleshoot job failures.

All application environment services and servers monitoring.

Troubleshoot application Infrastructure related issues.

Client: Suntrust and Truist Financial

Location: Atlanta, GA

Role: Senior Hyperion Infra Consultant Dec - 2017 to Jan - 2023

Roles and Responsibilities:

Built and managed EPBCS application dimensions from DRM source files.

Managed EPBCS application data loads using EPM automate.

Created planning form based business requirement.

Managed EPBCS application security.

Automated Admin tasks like run rules, import export data, Run data maps import export cell level security, refresh database, etc… using EPM automate.

Created validate intersections.

Refresh EPBCS application from PROD to TEST.

Built new end to end Hyperion 11.2.7 multi-tier (web/app) environments like DEV/ TEST/ PrePROD/ PROD/ DR on Windows 2016 and Redhat 7.9 OS

Migrated HSS, HFM, FDMEE, Planning, ESSBASE, FR from 11.1.2.4 to 11.2.7

Applying Weblogic CPU and bug fix patches on Hyperion/DRM environments.

Built new end to end DRM 11.2.2 multi-tier (web/app) environments (DEV/TEST/PrePROD/PROD/DR) on windows 2016 OS with DRM API web services.

Migrated DRM apps from version 11.1.2.4 to 11.2.2.0.

Integrated shared services authentication with Microsoft Active directory.

Migrated HSS, HFM, FDMEE, Planning, ESSBASE, FR from 11.2.7 to 11.2.11

Migrates Hyperion DRM application changes from lower environments to PROD.

Automated Hyperon / DRM application services recycle/maintenance through Jenkins automation tool with pre/post checks.

As part of Suntrust and BB&T merger migrated HSS/HFM/FDMEE/ESSASE/ Planning/FR apps from Suntrust environment to BB&T environment.

Developed and implemented custom shell scripts for ESSASE/ Planning apps artifacts/data backups and automated them through ESP jobs.

Developed and implemented custom shell scripts for clearing cache memory, CPU/Memory/DISK space utilization monitoring and automated them through CA7 jobs.

Developed custom shell scripts for data export/import from MSSQL DB table/view using SQLCMD/BCP utilities.

Automated Hyperion application services recycle/maintenance through Jenkins automation tool with pre/post checks.

Creating, provisioning, and maintaining user’s access and managing user security across all Hyperion modules including external authentication in Hyperion Shared services

Designing data forms in Hyperion Planning which is spreadsheet like web-based grids with dimensions in columns and rows which is used by users and planners to submit data, update, and analyze data.

Writing Essbase calculation scripts by which data is calculated using calculation command, equations, and formulas.

Create Business rules for planning or Essbase applications to run custom business rules by the business users.

Create Report scripts to export data from the existing application.

Create load rules to import data to the existing applications from warehouse or from different data sources.

Installed and configured FCM on existing HFM/FDMEE environment.

Application artifacts migrations between environments using LCM and CLI.

ESSBASE/Planning cubes L0 data export/Import using EAS/CLI.

Patch management using Opatch utility.

CA7 daily jobs monitoring applications validation after daily jobs completion through SmartView templates.

Automated delete Temp data & Achieve logs process.

All environments application services and servers monitoring.

Troubleshoot Hyperion Infrastructure related issue.

All environments application services and servers monitoring.

Troubleshoot Hyperion Infrastructure related issues.

Development of Hyperion Planning application in Enterprise Performance Management workspace and configuring plan type, application dimensions and configuration with Shared services

Client: Weatherford International

Location: Houston, TX

Role: Hyperion Consultant Dec - 2015 to Dec – 2017

Roles and Responsibilities:

As per customer requirement learned Jenkins automation tool created builds for Hyperion services recycle & rebooting servers (PROD, QA & DEV) weekly basis.

Automated HFM task monitoring though AutoIt automation tool.

Applying windows patches through SCCM.

MSSQL DB fail over activity when required.

ESSBASE failover activity when required.

Automated delete Temp data & Achieve logs process.

Maintenance of OBIEE (Restart services, delete temp & archive logs).

OBIEE migrations (RPD, Forms & repots).

Troubleshoot Hyperion & OBIEE Infrastructure related issue.

Involved in Oracle Endeca installation.

Client: ANZ Financial

Location: Melbourne, Australia

Role: Hyperion Consultant Sep - 2013 to Dec - 2015

Roles and Responsibilities:

Regular Hyperion Applications health check.

Monthly Services & Servers restart.

Servers and Services monitoring through Eagle-I & Net IQ.

Backup & deletion of Hyperion applications log files.

Monthly HFM invalid records deletion.

Implemented HFM task audit and data audit extract & truncate automation.

Shared services Users & Groups creation & deletion using CSS Import Export utility.

Changes implementation in Production as per development team instructions.

Monthly HFM & ESSABSE data loads monitoring through Control-M.

Change, Incident & request management.

Managing L0 backups of ESSBASE & Planning apps.

ESSBASE & Planning cubes restructure.

Client: Moody's Investors

Location: Lowell, MA

Role: Hyperion Consultant May - 2013 to Sep - 2013

Roles and Responsibilities:

Regular Hyperion Applications health check.

Monthly Services & Servers restart.

Servers and Services monitoring through Eagle-I & Net IQ.

Backup & deletion of Hyperion applications log files.

Monthly HFM invalid records deletion.

Implemented HFM task audit and data audit extract & truncate automation.

Shared services Users & Groups creation & deletion using CSS Import Export utility.

Changes implementation in Production as per development team instructions.

Monthly HFM & ESSABSE data loads monitoring through Control-M.

Change, Incident & request management.

Managing L0 backups of ESSBASE & Planning apps.

ESSBASE & Planning cubes restructure.

Client: Gungen Shipping and Trading Inc

Location: Istanbul, Turkey

Role: System Engineer Oct - 2008 to May - 2013

Roles and Responsibilities:

Actively identify the Gaps with the infrastructure issues and risks associated with the project to the design Hyperion environment for the organization.

Installed & Configured Oracle Hyperion EPM system 11.1.2.1 under Windows 2008 EE & SE server consolidation application and FDM application in DEV, TEST, QA, UAT & Production environments…

Assisted in troubleshooting and taking corrective action on issues.

Applied patches on Hyperion applications using Opatch utility.

Created Oracle Database users and schemas and applied required role to DB users under windows server.

Configured Shared services with Microsoft active directory.

Responsible for Infra support, application migration and security related uses.

Regular production HFM, FDM applications & application server’s health check.

Incident & request management.

Backup & deletion of Hyperion applications log files.

Monthly HFM invalid records deletion.

Hyperion servers & services maintenance.

Installation and configuration of Windows server 2003, 2008.

Installation, configuration, maintenance & migration of mail server (Mail enable enterprise edition).

Installation and configuration of Windows 2003 & 2008 Active Directory Service.

Ubuntu & Kubuntu os authentication integration with windows active directory service.

Implemented windows domain controller with users, permissions, securities & GPOs.

Configuration of MS clusters service in win server 2008 with MSSQL 2008.

Website hosting & migration with deferent hosting providers Windows & Linux (Amazon, Go daddy, RDS, ESDS, etc...)

IIS service installation and configuration.

Hands on experience with database administration like Oracle database, MSSQL, MySqL, ETC…

Apache, MySQL, PHP Installation, Configuration using xampp, wamp, etc…

Troubleshooting Active Directory Related Problems.

Software Deployment in Windows using group policies.

Installation & configuration of sonic firewall & Endian firewall.

Well experienced in RAID 0, RAID 1 and RAID 5 connects.

Managing Backups and Restoration of data Using NTBACKUP service.

OS Installation and restore using LAN & Disk cloning.

Educational and Trainings

Master of Business Administration (Information Technology)

Microsoft Certified System Administrator

Trained in Hyperion Financial Management, Data relationship management and EPBCS.

Contact this candidate