SUMMARY

• Expertise in installation and configuration of Hyperion products such as Essbase, Planning, HFM, Financial Reporting, EAL, FDQM on both windows and UNIX platforms in HSS and standalone mode.
• Result oriented, analytical and self - driven professional seasoned with years of working in a dual role of architecture and production support.
• Experienced in implementing and maintaining SAP R/3,ECC6.0, Cognos and STAT.
• Experienced in Oracle financials administration..
• Excellent and extensive experience in SAP Basis, Hyperion Administration, IT Readiness, System Administration & Hardware& Software Support, System Analysis/Design and Implementation of various products.
• Strong knowledge in ESSCMD, MaxL, Smartview, Weblogic, Tomcat and IIS.
• Worked on Proof of Concepts and implemented best practices.
• Strong understanding of Software Development Life Cycle (SDLC).
• Excellent trouble shooting, problem solving, performance tuning, re-engineering, analytical skills and a team player with good communication and leadership skills.
• Managed and lead teams both onsite and offshore during the critical phases of projects.
• Experienced in building DR sites for Hyperion and SAP systems.
• Worked effectively with various software vendors Oracle, SAP, IBM, Quest etc. on product related issues and bugs. Ensured that requests raised have a quick resolution turnaround time.
• Installation, Administration and Production maintenance of Enterprise performance management products, Monitoring, Backup & Recovery, Tuning & Security, Export / Import, Patching, Upgrade/migration, Shell Scripting.
• Installation, Upgrade, Administration and maintenance of SAP R/3, ECC6.0
• Hardware Sizing and Capacity Planning, Installed Environments (Dev, Training, Live), Communication Network, Operational & Support Procedures, Technology Analysis.
• Maintaining Safe Environment by resolving IT Infrastructure issues such as Software, Hardware, Database, IT Security, Operations and etc.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Hyperion Admin/Analyst

Responsibilities:

• 24/7 production support for Hyperion products such as HP, HFM, HSF, FDM & Essbase on version 11.1.2.2 in a Win 2K8 environment and SQL DB backend.
• Installed and configured additional instances/servers to achieve load balancing of HFM.
• Administered security for users and groups within HSS.
• Monitored daily automated task such as backups, integration scripts, daily loads, application restart’s and availability of all environments.
• Developed, maintained and enhanced scripts that perform daily tasks such as backups, monitoring etc in VB and PowerShell.
• Maintained and enhanced reports and data forms.
• Administered Windows, WebLogic, IIS and Tomcat.
• Configure, maintain and updated FDM adapters based on the business requirements.
• Performed Essbase, HFM and FDM application refresh from PROD to QA on need basis.
• Involved in developing the security at the user, group and Entity level using the Hyperion shared services and also using the ESSBASE.
• Designed and developed complete automation of metadata and data loading using
• Facilitated modifications to integration scripts based on requirements from the functional team.
• Followed change control policies using SERVICENOW for migrating changes, updates and enhancements to the environment and applications.
• Developed Calc/report scripts for exporting the data between applications.
• Installed quarterly patches (PSU) for various Hyperion suite of products.
• Monitored server loads during peak usage of the systems using performance counters on the Windows server.
• Collaborate, guide and work with 3rd party vendors and Oracle support for prompt issue resolution.

Confidential

Sr. Hyperion Admin/DBA

Responsibilities:

• 24/7 production support for Hyperion versions 9X and 11X.
• Supported Classic EPMA Planning applications for the Budget and forecasting.
• Supported Hyperion application migration between environments using LCM.
• Designed system and hardware specifications for an upgrade from v11.1.2.1 to v11.1.2.3.
• Involved in day to day activities supporting DRM, Essbase, Planning, HSS and Interactive reporting.
• Worked with PowerShell, VB and shell scripts to automate tasks such as backups and monitoring.
• Automated alerting using Big Brother to monitor environment availability.
• Developed calculation scripts for allocations and back calculation for the accounts like Operating Earnings, Net Income Reconciling Items, Retained earnings Etc
• Created various business rules for currency conversion and constant currency USD rate.
• Developed Dynamic web-forms for faster performance and better results as per the business requirement.
• Administered Windows and Linux servers that host the EPM platform.
• Maxl scripts to automate version copying in essbase ASO cubes.
• Performed system refresh from Prod to QA.
• Performed cube refresh from DRM on a daily basis and monitor the automated job.
• Provided documentation for upgrade of the Hyperion products.

Confidential

Sr. Database Administrator

Responsibilities:

• Over 6 years of hands on administration experience with different versions of Hyperion EPM suite of products.
• 24/7 production support for Hyperion versions 9X and 11X.
• Performed a Full implementation of Hyperion 11.1.1.3 products on both windows and UNIX platforms.
• Installed & configured Hyperion 11.1.1.3 products.(HFM, Planning, Essbase, EAL, HSS, FDM, FR and EPMA on Windows and RHEL 4 & 5) using oracle 10.2.0.4 RDBMS.
• Support the upgrade of Hyperion products from version 9X to 11.1.1.3.
• Installed and configured Hyperion 11.1.2.3 products (HFM, Planning, Essbase, HSS, FDM, FR, SmartView and EPMA) on Win 2K8 and using Oracle 11.2.0.3 RDBMS as part of the proof of concepts.
• Developed migration paths of Hyperion applications from version 11.1.1.3 to 11.1.2.3.
• Installed and configured a Disaster Recovery system for Hyperion 11.1.1.3.
• Administered Security, User creation with Native and External authentication, Filters, Dimensional level Security, Groups and assign proper privileges, SSL.
• Configured and maintained FDM adapters between various source and targets.
• Administered Windows and Linux servers that host the EPM platform.
• Installed/configured and administered Weblogic, IIS and Tomcat.
• Installed client tools such as SmartView, Essbase Add-in, EAS client and HFM clients.
• Performed day to day activities involving production support, migrations, backups and resolve user tickets.
• Performed quarterly maintenance which involved file system cleanup, apply maintenance patches etc.
• Developed 7Z/Shell/VB & PowerShell scripts for automating tasks such as backups, system monitoring, server monitoring and reporting.
• Supported Hyperion application migration between environments using LCM.
• Implemented automation tasks such as backups, application restart, server reboots, application/server monitoring and notifications using TIDAL enterprise scheduler.
• Provided training and knowledge sharing sessions within the team on the EPM platform.
• Provided extensive documentation involved with troubleshooting, technical design, processes, support manuals for managing the Hyperion platform and share them with the team via SharePoint.
• Collaborated, guided and worked with the offshore team in order to provide effective 24/7 support.
• Over 7 years of hands on BASIS experience with SAP versions 4.6 B/C, 4.7C and ECC6.0.
• Provided 24/7 production support.
• Performed day to day activities which involved trouble shooting, security, STMS transport, monitoring, performance tuning and user support.
• Performed system refresh from PROD to UAT on need basis.
• Over 3 years of experience in administering cognos 8 systems on .
• Led the implementation of Cognos 8 BI which included technical requirements gathering, sizing and performing install multiple installations for DEV, QA and PROD.
• Provided 24/7 production support and day to day activities.
• Supported user issues with quick resolution response time.
• Performed maintenance activities such as backups, patching, monitoring, tuning and reporting.
• Over 3 years of experience in administering STAT on Linux 5 for change management.
• Led the implementation of STAT software which included technical requirements gathering, sizing and performed install multiple installations PROD and sandbox.
• Installed and configured STAT for PeopleSoft and generic applications(Oracle Ebusiness, RAMMS, END etc)
• Configured security for different teams and management personnel depending on roles and responsibilities.
• Generated reports for the Audit team based on the SOX requirements.
• Developed scripts for automation of backup’s, monitoring and reporting.
• Over 5 years of experience with Oracle database.
• Involved in day to day activities supporting Oracle EBusiness systems which involved code deployments between environments, managing user security etc.
• Supported data change migrations using PVCS and Serena systems.
• Installed/configured various versions of Oracle DB software on version 9i/10g/11g on windows and Linux.
• Performed Database refresh, Database backup, restore check and ensuring database availability.
• Schedules, Coordinates and Implements Patching & Database maintenance activities.
• Provided the recommendation for process/ Technical enhancement, mentored and transferred knowledge to the team.

Environment: SAP R3/ECC 6.0, Oracle Ebusiness Suite, Hyperion EPM Suite, Cognos, STAT, PVCS, Serena, ESSCMD, Windows (NT, 2K3, 2K8), Unix, RHEL 4/5x, MS-Office, Hyperion Essbase Excel Spread sheet Add-in, Hyperion SmartView, Oracle 9/10G/11G, PowerShell, VB, Java, Shell scripting, TIDAL, SharePoint.

Confidential

SAP Basis Administrator

Responsibilities:

• Installation and configuration of ECC 6.0 with oracle database.
• Managed SAP servers, Create and Maintain user Roles and Authorization profiles, Monitoring user logins, user sessions, restricting default logins in instance parameter file, troubleshooting user level problems to properly access the servers and maintaining security throughout the SAP landscapes.
• Configured and executed SAP change control functions including the Transport Management System (TMS), setting up Transport Routes, Configure Transport Domain Controller and customize Workbench Organizer.
• Client Administration like creating Clients, Client copy (Local and Remote), deleting clients and assigning logical systems to clients.
• Spool Administration like configuring printers and troubleshooting spool request, working with TemSe objects.
• Configured Operation Modes, Managing Instance Profile, managing Logon Groups for load balancing.
• Responsible to load & apply Support Packages, Add-ons, Kernel Upgrades and Hot patches.
• Database Backup / recovery, Monitoring, troubleshooting the Backup problems by investigating the cause like due to media failure or due to system failure or some other reasons.
• Applied OSS Notes to the systems downloading from OSS as per instruction or where ever applicable.
• Monitored the initialization parameters that determine the behavior of the Oracle Database Server.
• Monitored the alert log file to see the major changes, events and errors that occur during the running of the Oracle Instance.
• Managed Archive Logs. Monitoring Systems for its database growth, memory utilization, did SAP health checks daily for its better performance.
• Performed extensive tasks such as Reorganization of table spaces, creating indexes, maintaining data dictionary objects to suit various requirements of users in different environments.
• Installed Portal using the Rapid Installer and also configured Single Sign on login.
• Performance Tuning of SAP servers.
• 24X7 Production Support.

Environment: SAP R/3 4.7 / ECC6.0, BW 3.5/ 4.0, SAP Solution Manager 3.1, EP, BW3.1/3.5.1,WAS 6.20/6.30,Solaris, Windows 2000/2003, Oracle 8i/10g.

Confidential 

SAP Basis/Security Administrator

Responsibilities:

• Involved in the installation of SAP R/3 4.6 C.
• Installed SAP IDES on NT/Oracle with SAP 4.5B and 4.6C for testing and development purposes.
• Created users and assign Authorizations and profiles.
• Involved in the creation of mass users using t-code SU10.
• Creation of new group’s and assigning users to those specific groups.
• Troubleshooting user access problems using SU53 and SUIM.
• Daily activities such as, System lock, Update error, ABAP Dump error, Monitoring Buffers and System logs, Table space Administration.
• Supported in creating Printers, worked with other colleagues to create activity groups.
• Client-copy of Development to Production System.
• Actively involved in setting procedures for securing ABAP/4 programs and custom table with Authorization Groups, transactions and authority check statement.
• Evaluated security authorizations, segregation of duties conflicts and identifying sensitive T-codes and implement controls on them and monitoring the audit logs.
• Table space Administration and Reorganization.
• Monitored of the complete R/3 System, Buffers, Database, Work processes, Instances, Workload.
• SAP standard job scheduling using Operation Modes.
• Spool Administration like configuring printers and trouble-shooting spool request, deleting old spool jobs and working with TemSe objects.
• Tuned SAP buffers and memory utilization, Tuned database for performance optimization.
• Supported Package Installation.
• Experienced in TMS Administration and Configuration and Applying OSS Notes.
• Encouraged and enabled knowledge transfer while transition to project Teams.
• Homogenous System Copy

Environment: SAP R/3 4.6C, BW 3.x, ITS, APO 3.10, Solution Manager 3.1, Remedy, Oracle 8i, HP-UX, Win 2000.