SUMMARY

• 8+ years of experience consisting of Analysis, Design, Implementation, Business Intelligence(Hyperion Essbase, Planning, Hyperion Financial Management, Data Relation Management & Oracle Data Integration), Decision Support systems in Financial & Business applications., Testing and Documentation.
• Extensive experience of OLAP Application Development and Administration using Hyperion Essbase, DRM, EPMA, Hyperion Planning, Hyperion Analyzer - Web Analysis Studio, Hyperion Financial Reports, Smart View, Excel Add-in, Essbase Studio, Essbase Integration services with HFM in Windows and Unix environment.
• Implemented Distributed Hyperion environment on AWS servers with Hyperion Essbase, Planning, Financial management, Data quality management, financial reporting and interactive reporting.
• Extensive experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11.x/9.3.1, Hyperion Planning 9.x/11.x, Essbase Integration Server (EIS), Hyperion Financial Reports, Hyperion Analyzer, OBIEE, Essbase Spreadsheet Add-in, Essbase Smart view.
• Expert level skills in Hyperion suite of products, specifically Essbase, Hyperion Planning, HFM, Hyperion Reporting and FDM
• Specialized in leading development of the end to end integration between Hyperion HFM, Planning/Essbase and Oracle EBS using Hyperion’s FDM, DRM/ MDM, DIM/ HAL, report script, load rules, etc.
• Experience in Maintenance and Administration of Hyperion Essbase Cubes, strong experience in Data loading using Rule files, ESSCMD, Essbase Integration Services, and Essbase Studio. Expertise in writing ESSCMD and MaxL Commands, MDX querying, Report scripts.
• Proficient in Excel Add-in and Hyperion Smart view. Experience with providing training to business users and technical team members on OLAP concepts, Excel Add-in and Smart View.
• Experienced in analyzing internal user needs and desired results and develop software solutions with responsibility for the delivery of requirements.
• Extensive Experience in AWS environment and good knowledge of S3, EC2, CLI, Cloud Formation.
• Experience in developing application security process, creating users/groups, security profiles and application access to different groups using filters.
• Experience in software installation, configuration, upgrading, testing and migrating of cubes in different environment.
• Experience in creating classic Hyperion Planning applications and EPMA, Data Forms, Business Rules, Task Lists, planning security. Loading metadata and data using planning load utility.
• Created Quarterly and Yearly reports: P&L, Expense and Revenue reports, Balance Sheet trend analysis, budget reports, forecasting reports using HFR, Smart View and Excel Add-in
• Experience in acting as a liaison between business and technical teams and converting business requirements into technical specifications.
• Extensive knowledge of Financial Statements, Reconciliations,, Budgeting, Forecasting and Oracle Financials Modules
• Expertise in Strategic Management, Financial Planning & Analysis and Valuation.
• Experience with Linux, Perl, Putty, WinSCP, Oracle, Netezza, SQL Server, Remedy.
• Good Experience with windows PowerShell and Unix/Linux shell scripting.
• Proficient in implementing code through Oracle SQL and PL/SQL.
• Results-oriented individual who views challenge as an opportunity.
• A strong team player capable of working independently with excellent communication, analytical, and inter-personal skills

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x, Hyperion Financial Management Suite (HFM), Excel Add-In, ESSCMD, MaxL, MDX and Hyperion Planning, ODI, FDQM.

Databases: Essbase 11.x/9.3.1, Oracle 8i/9i/11i, SQL Server 2000, Toad 8.0, MS Access

Reporting Tools: BI+, Financial Reporting, Web Analysis, Hyperion Reports, Hyperion Interactive Reporting, Hyperion Spreadsheet Add-in, Smart View, DODECA Spreadsheet Add-in, OBIEE.

Languages: SQL, C/C++, Shell Scripting

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2016/NT 4.0/XP/Vista/7/10

Testing Tools: Win runner, Load Runner, Quick Test Professional QTP.

Monitoring Tools: Zabbix, Grafana, Site Scope, Splunk, Influx DB, ELK

CI/CD Tools: Subversion, GitHub, Nexus, Jenkins, uDeploy, Artifactory, Ansible professional Experience:

PROFESSIONAL EXPERIENCE

Sr. Hyperion Infrastructure Consultant

Confidential, San Antonio TX

Responsibilities:

• Experienced on Installation and configuration of various Hyperion Planning / Essbase components
• Good understanding on the architecture of the oracle Hyperion products possess excellent technical, analytical, communication and client interaction skills.
• Experienced in PERL/Python scripting.
• Job and Server maintenance activities might need to overlap with Onsite hours. have experience in Onsite/Offshore working model.
• Administer user/groups within shared services, Role assignment and Provisioning.
• Perform migration of objects between environments (DEV, TEST and PRODUCTION)
• Document resolution to issues and capture as knowledge base for ongoing support
• Monitor and manage system availability during month end close and forecast cycle.
• Support end users on Hyperion Planning, Essbase and HPCM applications.
• Perform Backup and recovery of Hyperion applications.
• Good knowledge in LCM Migration and Deployments.
• Monitoring Performance, Logs, Scripts & Jobs
• Experience in DRM, ODI, HPCM, Hyperion Planning, Data stage and OFSAA administration, setups, configurations etc.
• Performance tuning activities in Essbase will be added advantage have knowledge in Windows, Linux and RDBMS administration skills.

Software Developer

Confidential, VA

Responsibilities:

• Implemented Hyperion suite on AWS environment for lift and shift kind of a project for move out of data center effort.
• Developed software components, adhering to existing process guidelines.
• Perform application Lifecycle Management by Programming, testing, Validation and Deployment and Documentation.
• Developed and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes.
• Developed SQL Loader functionality to interact Essbase Cubesto and from with Oracle Database.
• Developed Essbase Partitioning, automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Created and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rules.
• Designed custom Essbase calculations scripts, MDX scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
• Created database objects such as outlines, report scripts, load rules, Calculation scripts, dimension build rules, MaxL scripts to automate administrative/query operations, data load automations and security provisioning.
• Coordinate software installation and monitor implementation process with different agile teams.
• Executed Proof of Concept (POC) by using CI/CD (continuous integration / continuous deployment) practice using Subversion, Jenkins, Nexus, uDeploy.
• Monitor system performance trends using tools like Zabbix, Grafana, Site Scope to identify potential issues.
• Successfully adopted internal tools like Artemis to simplify the change order process with integration of Version One and HPSM.
• Developed Essbase BSO application for CCAR (Comprehensive Capital Analysis and Review) which was recognized by internal TechXcellence award.
• Suggested Opportunities for improvement within the applications.
• Analyze internal user needs and desired results and develop software solutions with responsibility for the delivery of requirements, with limited or no supervision
• Understand desired application capabilities and testing scenarios by working with Product Owner.
• Work within and across Agile team to design, develop, test, implement, and support technical solutions across a full-stack of development tools and technologies.
• Prepare test cases and effectively conduct unit testing, including interacting with business users to validate results
• Supported data conversion and interfacing activities, including user support to load and reconcile data.
• Lead Reporting, Planning, and Master Data design sessions and own the architecture and design of aggregate solution.
• Worked with business application developers to determine how enterprise infrastructure will optimally meet business needs, while promoting adherence to analysis, design, and development standards and methodologies.
• Actively participated in planning discussions with development and other IT teams.
• Worked with System Integrators to understand the business requirements to ERDs (Entity Relationship Diagram).
• Clearly communicate technical information to both developers and business stakeholders.

Hyperion Consultant

Confidential, Atlanta, GA

Responsibilities:

• Review, design and implement modifications to existing applications to correct errors, allow it to adapt to new hardware, or to improve its performance.
• Gather requirements, design and implement new Hyperion Essbase or Planning applications, calculations, load rules, and validating data.
• Create and develop performance improvements and implement new features.
• Designed Business Rules as per client requirement and creating Translation function as per the Business requirement.
• Worked on building rule files for data load and metadata loading for ASO applications.
• Worked with Oracle/HyperionSupport team to resolve issues and reported new Bugs in the software.
• Helped the client users in coming up with the test cases for User Acceptance Testing.
• Improved Performance by Tuning Application Dense/Sparse Settings and Optimizing Cache settings.
• Implemented interfaces with ERPi tools like PeopleSoft to Essbase BSO cubes.
• Advise systems analysts, programmers and others on project limitations and capabilities, performance requirements and interfaces.
• Develop and direct software system testing and validation, programming, and documentation.

Hyperion Consultant

Confidential, NC

Responsibilities:

• Reviewed the design and implementation of the Hyperion modules to understand enhancement scopes.
• Actively involved in analysis of enhancement projects to create reports using Financial Reporting Studio.
• Used Service now automation tool to automate the tickets generates for Hyperion related Issues.
• Used data loading from Financial Data quality management tool to load the data to BSO cube from Oracle E-Business Suite.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning and optimization of calc scripts and tuning of calc cache.
• Automation of dynamic dimension building & Loading in to the Cube using MaxL Scripts.
• Managed queries, tables, and relational references, and maintaining the referential and data integrity with PL/SQL.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
• Developed task list and process management for quarterly rolling forecast.
• Responsible for requirement gathering and creating the end user security for the ASO cube and for the financial reports.
• Compared the Hyperion planning security with Hyperion essbase security to make them in Sync.
• Actively participated in technical testing of Hyperion upgrade from version 11.1.2.2 to 11.1.2.3.

Hyperion Developer/Administrator

Confidential

Responsibilities:

• Single Point of Hyperion Contact for the whole company for Hyperion Planning enhancements and administration.
• Responsible for the technically owning and managing the Planning Applications for Advance Auto Parts as an application Administrator.
• Monitored all the Hyperion activities on 24/7 basis.
• Worked with FP&A staff for their monthly and quarterly reporting requirement with Hyperion Planning and Financial Reporting Studio.
• Documented Hierarchy changes and update of substitution variables and business rules.
• Collaborating with Infrastructure group to ensure reliable and responsive financial systems
• Identifying and resolving issues critical to theclients' strategic and operational success
• Participated in Enterprise wide end users training and support with Smart View, Grids, queries and functionalities to facilitate financial data mining for analysis, inquiries and ad hoc reporting.
• Actively involved in analysis of enhancement projects to create reports using report scripts.
• Involved in system installation, configuration and software upgrades from Essbase version 9.3.1 to 11.1.2.1.
• Participated in testing and validation of all the Essbase and planning artifacts after the upgrade.
• Create several interfaces from external systems to Hyperion Planning application to feed the data from RDBMS tables.
• Used OLAP Process management console to give access to the business user for running the Interface.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through Outline Load Utility.
• Maintaining and Tuning of the Essbase cube frequently for ideal Essbase clustering ratio.
• Developed a forecasting application for the users and created business rules using calculation manager.
• Worked with BI EDW team to manage and create new interfaces to feed various types of data into planning cubes.

Hyperion Administrator

Confidential, Miami, FL

Responsibilities:

• Reviewed the backup scripts for the Hyperion environment and reviewed the SQL scripts.
• Monitored the Hyperion process scripts on a 24/7 basis.
• Responsible for the Essbase applications of Carnival Corporate, as an application and system administrator
• Address, re-route and resolve user issues generated by help desk.
• Involved in analysis and requirements gathering of the Interactive Reports.
• Created Interactive Reports using Hyperion Interactive Reporting Studio 11 using SQL queries.
• Supported and participated in the testing and implementation phase of the Interactive reports
• Used TOAD for SQL programming to Interactive Reports code testing
• End users support with data reporting tools and process including errors, discrepancies, validations, corrections to insure timely and accurate finance reporting along with providing the most effective and efficient process and tools for data loading(templates, Web Forms, Grids, Journals)
• Performed the performance tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Worked on filter creation, creation of users, creation of groups and related activities. Involved in analysis, development and enhancement of database outlines. Maintained application security and added/deleted users per management requests.

Data Analyst/ DBA

Confidential

Responsibilities:

• Installing Microsoft SQL Server with log and data location configuration.
• Plans, designs and develops all reporting requests, including but not is not limited to ad hoc reporting, Design and generate trend analysis reports.
• Designing a quality RDMS with the options of normalizations, association/relationship, cardinality, and to avoid data redundancy, referential integrity, data integrity, and other irregularities.
• Develop, plan, schedule and implement changes to the database environment while maintaining critical business data availability.
• Creating and executing SQL Server backup and recovery policies, and maintain integrity and reliability of access to information.
• Involved in code reviews, designing technical specs, Unit testing, Query optimization and SQL tuning. Extensive performance tuning utilizing hints, index creations and calculating table size.
• Analysis phase included understanding of existing system and interview with end users to find additional system requirements. Analyzed requirements to come up with design Data Model, which included design decisions like sizing of Database, prototypes for screens and reports, etc.
• Used SQL * Loader scripts to load the data into temporary tables and PL/SQL procedures to Validate the data.
• Developed forms and reports ensuring that users’ requirements are being adhered to the requirement, developed backup and recovery strategies. Designed and implemented test plans for Unit and Integration testing.